V. 19:12 (56-57): Sidebar: Detrending a bar chart in Excel by Charles E. Miller
Product Description
Sidebar: Detrending a bar chart in Excel by Charles E. Miller
DETRENDING A BAR CHART IN EXCEL
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.
DETRENDING A BAR CHART IN EXCEL
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.
FOR THOSE ORDERING ARTICLES SEPARATELY:
*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! |
| Click Here to Order |