The A to Z Companion Spreadsheet is a complement to the book, Technical Analysis from A to Z, by Steven B. Achelis. This timeless book on investing is available in six languages and has sold more than 150,000 copies.
The A to Z Companion Spreadsheet is an Excel workbook that provides detailed, step-by-step calculations for more than 100 technical indicators, including such favorites as MACD, Stochastics, and Wilders'.
The following is a complete list of the indicators in the spreadsheet. The calculations for the indicators shown in bold are included in the spreadsheet, but they were too complicated to include in the book.
- Absolute Breadth Index
- Accumulation Distribution
- Accumulation Swing Index
- A/D Line
- A/D Ratio
- Advancing - Declining Issues
- Arms Index
- Aroon
- Average True Range
- Bollinger Bands
- Breadth Thrust
- Bull/Bear Ratio
- Chaikin Money Flow
- Chaikin Oscillator
- Chande Momentum Oscillator
- Commodity Channel Index
- Commodity Selection Index, Correlation
- Cumulative Volume Index
- DEMA
- Detrended Price Oscillator
- Directional Movement Indicators
- Dynamic Momentum Index
- Ease of Movement, Envelopes
- Forecast Oscillator
- Inertia
- Intraday Momentum Index
- Klinger Oscillator
- Large Block Ratio
- Linear Regression Indicator
- Linear Regression Trendline
- Linear Regression Slope
- MACD
- Market Facilitation Index
- Mass Index
- McClellan Oscillator
- McClellan Summation
- Median Price
- Member Short Ratio
- Momentum
- Money Flow Index
- Moving Average - Exponential
- Moving Average - Forecast
- Moving Average - Simple
- Moving Average - Triangular
- Moving Average - Variable
- Moving Average - Volume Adjusted
- Moving Average - Weighted
- Negative Volume Index
- New Highs - Lows Cumulative
- New Highs - New Lows
- New Highs / New Lows Ratio
- Odd Lot Balance Index
- Odd Lot Short Ratio
- On Balance Volume
- Open-10 TRIN
- Overbought/Oversold
- Parabolic SAR
- Performance
- Positive Volume Index
- Price Channels
- Price Oscillator
- Price Rate of Change
- Price and Volume Trend
- Projection Bands
- Projection Oscillator
- Public Short Ratio
- Puts/Calls Ratio
- QStick
- R-Squared
- Raff Regression Channel
- Range Indicator
- Relative Momentum Index
- Relative Strength, Comparative
- Relative Strength Index
- Relative Volatility Index & Inertia
- Standard Deviation
- Standard Deviation Channel
- Standard Error
- Standard Error Bands
- Standard Error Channel
- STIX
- Stochastic Momentum Index
- Stochastic Oscillator
- Swing Index
- TEMA
- Time Series Forecast
- Total Short Ratio
- TRIX
- Typical Price
- Ultimate Oscillator
- Upside/Downside Ratio
- Upside - Downside Volume
- Vertical Horizontal Filter
- Volatility (Chaikin's)
- Volume Oscillator
- Volume Rate of Change
- Weighted Close
- Wilder's Smoothing
- Williams Acc-Dist
- Williams' %R
Click here to see a list of all of the indicators that are described in the Technical Analysis from A to Z book. Click here to learn about the A to Z Companion Spreadsheet.