Stocks & Commodities V. 22:12 (28-36): Sidebar: Excel codes for trend trigger factor by M.H. Pee
Product Description
Stocks & Commodities V. 22:12 (28-36): Sidebar: Excel codes for trend trigger factor by M.H. Pee
EXCEL CODES FOR TREND TRIGGER FACTOR
The Excel spreadsheet in sidebar Figure 1 shows all the required calculations for the 15-day trend trigger factor (TTF) on the euro between October 1, 2002, and January 15, 2003, inclusively. The data is represented in continuous contract format. The date, open, high, low, and close goes into column A, B, C, D, and E, respectively. The date is represented using eight digits, with the first four representing the year, the next two the month, and the last two the day. For example, 20030108 represents January 8, 2003.
Column F represents the 15-day buy power, which is defined as the difference between the highest high of the first period and the lowest low of the second period. Enter the following Excel codes in cell F30 and copy it to the bottom of the spreadsheet. . .
EXCEL CODES FOR TREND TRIGGER FACTOR
The Excel spreadsheet in sidebar Figure 1 shows all the required calculations for the 15-day trend trigger factor (TTF) on the euro between October 1, 2002, and January 15, 2003, inclusively. The data is represented in continuous contract format. The date, open, high, low, and close goes into column A, B, C, D, and E, respectively. The date is represented using eight digits, with the first four representing the year, the next two the month, and the last two the day. For example, 20030108 represents January 8, 2003.
Column F represents the 15-day buy power, which is defined as the difference between the highest high of the first period and the lowest low of the second period. Enter the following Excel codes in cell F30 and copy it to the bottom of the spreadsheet. . .
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 |