V. 20:6 (34): Sidebar: Calculating The Rules by M.H. Pee

Sidebar: Calculating The Rules by M.H. Pee

The trend intensity index (TII) can be calculated using an Excel spreadsheet. The data given in the spreadsheet following, which stretches from September 23, 1998, to December 31, 1998, is from the yen and is in continuous contract format. Hence, these values may not reflect the actual prices on those dates. This, however, does not in any way affect the trading signals and testing results. Daily data is used with the date, open, high, low, and close recorded in columns A, B, C, D, and E, respectively. Other values vital for the calculation of the TII are also included in the other columns for easy reference. The date is recorded using six digits, with the first two representing the year, the next two the month, and the last two the day. As an example, the number 980923 represents September 23, 1998.