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.