This page provides links on how to calculate some of the most popular indicators. All the pages includes a YouTube video which gives additional information and help. The examples are all shown using Excel.
Buy my eBooks
If you are interested in learning how to program and trade with technical indicators, check out my eBooks: How to Calculate 21 Technical Indicators Using Excel and 21 More Technical Indicators. Both eBooks are exclusively available in the Amazon Kindle Store. They contain a wide range of indicators and chart patterns. Both books come with a free spreadsheet containing all the calculations so you can start testing your strategies immediately.
Williams %R
Developed by Larry Williams. The %R is an oscillator that is used by traders to find overbought and oversold areas. It is also suited to identifying divergences, when the price and oscillator and moving in different directions. See How to Calculate the Williams %R.
The Parabolic SAR
The PSAR indicator is a highly distinctive indicator developed by the great J. Welles Wilder. The indicator helps to identify the trend as well as time entry points. The PSAR contains an acceleration factor that speeds up the indicator during strong market moves. Find the calculations in this article and video: How to Calculate the PSAR Indicator – New Version
Bollinger Bands can be used on all markets on all timeframes. They use the standard deviation to offset the bands which expand and contract to suit market volatility. Read more here: How to Calculate Bollinger Bands Using Excel
Awesome Oscillator and Acceleration/Deceleration Indicator
Classic momentum technical indicator. The stochastic measures how the closing price compares to the most recent highs and lows. This article shows how it can be calculated: How to Calculate the Stochastic Indicator using Excel
The Relative Strength Index
The RSI is another type of momentum indicator. It measures the difference between closing prices. The RSI tends to be slower than the stochastic and spends less time in the overbought/oversold zones. Read more: How to Calculate the RSI Indicator using Excel
The MACD
Created by Gerald Appel, the MACD measures the difference between two exponential moving averages. The histogram measures the change of the MACD compared to another EMA. The full article: How to Calculate and use the MACD Indicator in Microsoft Excel
If you are interested in learning how to program and trade with technical indicators, check out my eBooks: How to Calculate 21 Technical Indicators Using Excel and 21 More Technical Indicators. Both eBooks are exclusively available in the Amazon Kindle Store. They contain a wide range of indicators and chart patterns. Both books come with a free spreadsheet containing all the calculations so you can start testing your strategies immediately.