How to Calculate the SuperTrend Indicator using Excel

The SuperTrend Indicator is a great way to identify the current market trend.  The indicator shows a clear distinction between uptrends and downtrends.  When the indicator is flat and flipping from above to below, it shows that there is no trend at present. Trend followers can use the SuperTrend on the daily timeframe to identify the primary trend and then use the 8-hour or 4-hour chart to identify trade entry opportunities.

I am a big fan of the SuperTrend and have used it in a number of trading strategies. You can see it here in the article on a SuperTrend Forex Trading Strategy.

If you want to improve and develop your strategy, the SuperTrend strategies are some of the most popular models in the Tradinformed Shop.

Video – How to Calculate the SuperTrend Indicator in Excel

The SuperTrend indicator is calculated by using the ATR to offset the indicator from the average price. When the price touches the SuperTrend line it turns over to the other direction. One of the great things about the SuperTrend is that it only moves in the direction of the trend.

If you are interested in the SuperTrend, I have recorded a video showing how it is calculated using Excel.

Formulas Used

Upper Band Basic O24 =((D24+E24)/2)+(\$O\$3*N24)
Lower Band Basic P24=((D24+E24)/2)-(\$P\$3*N24)
Upper Band Q24 =IF(OR(O24<Q23,F23>Q23),O24,Q23)
Lower Band R24 =IF(OR(P24>R23,F23<R23),P24,R23)
SuperTrend S24 =IF(AND(S23=Q23,F24<=Q24),Q24,IF(AND(S23=Q23,F24>=Q24),R24,IF(AND(S23=R23,F24>=R24),R24,IF(AND(S23=R23,F24<=R24),Q24,””))))