Technical Analysis from A to Z

A to Z Companion Spreadsheet

The A to Z Companion Spreadsheet is an Excel spreadsheet that contains worksheets for 103 of the technical indicators in Technical Analysis from A to Z. The formulas within the Spreadsheet demonstrate the precise calculations.

The calculations for the indicators listed below were too complex to include in the book, but they are included in the A To Z Companion Spreadsheet.


  • Commodity Selection Index
  • Correlation
  • Directional Movement
  • Dynamic Momentum Index
  • Linear Regression Trendline
  • Money Flow Index
  • Projection Bands
  • R-Squared
  • Relative Volatility Index (RVI)
  • Standard Error
  • Stochastic Momentum Index
  • Swing Index
  • Ultimate Oscillator