Supertrend Indicator Excel Sheet with Realtime Buy Sell Signals

Supertrend is a popular trend following indicator which works particularly well in Intraday timeframe. As a technical analyst, you might have across this indicator quite often during your studies. It is known for its preciseness and accuracy in all the timeframes. It works surprisingly well for all the instruments i.e. equities, commodities and Forex. As it is not readily available in all trading platforms, we have created a macro based Supertrend Indicator excel sheet which calculates the indicator values and buy/sell signal in real-time. The excel sheet is parameterized and works for all major exchanges. Read through to understand how supertrend is calculated and download the excel sheet from the end of this post.

Also Read: Options Trading Courses Online: A well reserached recommendation

Supertrend Indicator Calculation

Suprtrend is a trend following indicator like moving averages. It is caluclated based on Average true range (ATR) and a multiplier value. ATR measures the degree of volatility of the market.

A buy signal is generated when Supertrend indicator closes above the price and a sell signal is generated when it closes below the closing price.

Below are the mathematical formulas involved in calulcation of supertrend indicator:
  • True Range (TR) = Max of (High-Low, High-Close, Low-Close)
  • Average True Range (ATR) = Avearge of last n TR values (n is the first paramter in Supertrend indicator. 10 is default)
  • Basic Upperband  =  (High + Low) / 2 + Multiplier * ATR
  • Basic Lowerband =  (High + Low) / 2 – Multiplier * ATR
  • Final Upperband = IF( (Current BasicUpperband  < Previous Final Upperband) and (Previous Close > Previous Final Upperband)) Then (Current Basic Upperband) ELSE Previous FinalUpperband)
  • Final Lowerband = IF( (C urrent Basic Lowerband  > Previous Final Lowerband) and (Previous Close < Previous Final Lowerband)) Then (Current Basic Lowerband) ELSE Previous Final Lowerband)
  • SUPERTREND = IF(Current Close <= Current Final Upperband ) Then Current Final Upperband ELSE Current  Final Lowerband
Looks complex? Dont worry, we have created automated excel sheet which calulcates all these values for realtime stock market data.

Supertrend Indicator Excel Sheet Overview

This is an automated macro enabled spreadsheet which calulcates Supertrend value and Buy/Sell signals for the symbol entered. You need not to do anything manually.

See the below screenshots:

Supertrend Indicator Excel Sheet

Also Read: ADX Trend Strength Indicator: Realtime Excel Sheet

How to use this Excel Sheet

Step 1: Download the Excel file from the end of this post.

Step 2: Open this Excel file and make sure you are connected to internet. Please accept if it asks to enable Macros and Data connections.

Step 3: Input the Symbol Name, Exchange Name, Interval, Number of Days, ATR Periods and Multiplier

Step 4: Click on Get Data button. The data would be automatically downloaded and supertrend values would be caluclated. This data can be downloaded for max 15 days and the minimum interval is 1 minute.

Download link for Supertrend Indicator Excel Sheet

Please see the below link to download Supertrend indicator excel sheet. Let us know if you have any feedback or comments.

Supertrend Intraday v1.0

15 Comments

  1. what exchange name used for commodity ?
    I tried using MCX and ZINC for script name… it did not work…
    pl help

  2. Hi Team,
    I have downloaded the Excel Sheet. Just backtesting I have entered PNB with default value but it has given incorrect signal buy though the stock is in bearish trend.

    Can you please help ?

  3. This Excel is belongs to NSE Cash or NSE Futures? and i think BUY SELL is showing Wrongly.

  4. is the signal generated real time and what is the time delay… I use an alert in my brokerage that is 3 candles late. so for ex: on daily it give buy signal after it see 3 green days or hourly it gives buy after seeing 3 hourly candles etc…Let me know the delay so I know what I am going to use

    • There is no delay as such. Data is fetched directly from Google and signal is generated on realtime.

  5. It has some error because mostly only one direction is appearing mainly of Sell.

  6. Hi Couple of questions
    what will be the code for (1) Near month bank nifty futures .. say April end (2) Start time is from 9.30 AM whereas in the sheet its specfied as 9.15

    • Hi Roy,
      1) The sheet works only on equities, not future quotes
      2) Indian market (NSE) starts at 9:15 AM

Leave a Reply

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