V. 19:12 (56-57): Sidebar: Detrending a bar chart in Excel by Charles E. Miller

V. 19:12 (56-57): Sidebar: Detrending a bar chart in Excel by Charles E. Miller
Item# \V19\C12\144SB.PDF
Availability: In Stock

Product Description

Sidebar: Detrending a bar chart in Excel by Charles E. Miller


The technique used here is just about the simplest I can suggest for those who might not be fluent in Excel. Aficionados will doubtless see the numerous oppor-tunities to improve and/or automate this manual system, which consists of two worksheets and one chart. I suggest you first build the small model sheet shown in sidebar Figure 1 to see how, in simplified form, the working sheet is built and operated. If you can reproduce the accompanying charts, then itís safe to expand the sheet to suit your own needs.

Constructing your spreadsheet

Sheet 1: Raw data. The first step is to paste ASCII text data for an index or a security into an Excel spreadsheet. I prefer to paste several years of date, high, low, and close data into its own sheet. Sheet 2: Working. Create the (second) working sheet shown in sidebar Figure 1. The data will be pasted into columns A:D, and each data row will be an array of values.

*Note: $2.95-$5.95 Articles are in PDF format only. No hard copy of the article(s) will be delivered. During checkout, click the "Download Now" button to immediately receive your article(s) purchase. STOCKS & COMMODITIES magazine is delivered via mail. After paying for your subscription at store.traders.com users can view the S&C Digital Edition in the subscriber's section on Traders.com.

Take Control of Your Trading.
Professional Traders' Starter Kit
All these items shown below only $299.99!
  • 5-year subscription to Technical Analysis of STOCKS & COMMODITIES, The Traders' magazine. (Shipping outside the US is extra. Washington state addresses require sales tax based on your locale.)
  • 5 year access to S&C Archive
  • 5 year access to S&C Digital Edition
  • 5-year subscription to Traders.com Advantage.
  • 5-year subscription to Working Money.
  • Free book selection.
  • Click Here to Order