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. . .