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


The SuperTrend indicator is a nice visual way of following the dominant trend. It uses the ATR to calibrate the indicator offset. Find out more in this article: How to Calculate the SuperTrend Indicator using Excel

Bollinger Bands

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

Invented by Bill Williams, these indicators work together to help identify market speed and momentum. See how to trade and calculate them in this article: Awesome Oscillator and Acceleration/Deceleration Indicator

Stochastic Oscillator

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


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

Leave a Reply

Your email address will not be published. Required fields are marked *