|  APR 1994

SIDEBAR: WAMI SPREADSHEET by Technical Analysis, Inc.

WAMI SPREADSHEET by Technical Analysis, Inc. The spreadsheet (seen in sidebar Figure 5) provides a way to evaluate the WAMI power and phase spectrum as a function of the WAMI parameters L, M and N. The first column starting with A5 contains the frequency values to be evaluated. Columns B, C, D, E, F, G and H are intermediate results needed to create the spectra, and columns I and J contain the power and phase spectra at each cycle frequency. To set up the calculations, first, I input values into A2, B2, C2 and D2: These are the input parameters. The value placed into A2 is the frequency increment. A value of 1.0 is more than adequate to obtain good frequency resolution. If this value is changed to 2.0, then the effect of higher frequencies can be plotted. Then in B2, C2 and D2, I place trial values of M, L and N. I used the optimal values for the MTP data in this example; that is, B2 = 5, C2 = 4 and D2 = 5.

by Technical Analysis, Inc.