33

CPR Spreadsheet with Narrow Range Indicator : Free Download

Posted on by admin

In this post, we are going to look at a Central Pivot Range (CPR) spreadsheet which calculates the CPR as well as support-resistance levels of stock symbols. This fully automated CPR spreadsheet is built on Google sheets platform and fetches the data in real-time from Google Finance. Read on to know more about the sheet and get access to it free of cost.

CPR Overview

CPR stands for Central Pivot Range. It is a very accurate indicator used to speculate the price movements.

To understand CPR in-depth, its calculation, uses and interpretation please follow the below link.

All you want to know about CPR Indicator

CPR Spreadsheet

The CPR spreadsheet contains 3 tabs:

CPR – All F&O Stocks

This tab contains CPR levels for all the F&O listed stocks from NSE. The CPR levels include:

  1. Pivot
  2. Top Central (TC)
  3. Bottom Central (BC)
  4. Resistance Levels (R1 to R4)
  5. Support Levels (S1 to S4)

CPR Spreadsheet 1

The levels are calculated using the standard CPR formula we described in this post.

Kindly note that these CPR levels are calculated on a Daily (EOD) timeframe and can be utilized for Intraday trading.

Previous days OHLC values are used to calculate current CPR. The values are updated automatically and the frequency of updates depends on data availability at Google finance.

There is a column in this tab called “Narrow Range CPR”. The value “YES” in this column means the CPR width is very low, which is interpreted as a possibility of trending market move. If the absolute difference between TC and BC lines of CPR is less than 0.2% of the close price, it is marked as narrow.

Narrow Range Symbols

The Narrow Range Symbols tab contains the filtered list of all the symbols having a narrow range CPR. It is derived from the first tab itself.

CPR Spreadsheet 2

CPR – Individual Stock

In case you want to see the CPR levels of the stocks which are not present in the first tab, you can use this tab to calculate CPR levels of any financial instrument listed in Google Finance

Just enter the symbol name in the cell G6 and the CPR levels would get calculated automatically.

CPR Spreadsheet 3

The symbol name should be entered in the format “Stock Exchange Name:Symbol”.

The default symbol name is “NSE:TCS”. Since this is a shared Google spreadsheet the symbol name will revert back to the default whenever you refresh or open the sheet.

How to use this Sheet?

CPR levels can be used in several different ways for your trading decisions:

  1. Use narrow range CPR to predict trending moves
  2. Breakout of CPR levels can be used to take Buy/Sell positions
  3. The support/resistance levels can be used as a stop loss

You can read in detail about the interpretation and usage of CPR levels in this post.

Make sure you are connected to the internet to use this sheet.

Get Free Access to CPR Spreadsheet

Enter your Email address below to get access to this sheet. Alternatively, you can use this link.

Let us know in the comments section if you have any queries.

Related Posts

33 Comments

  3. Could you please share the formula used for identifying the Narrow range? Based on info given by you over here, I tried with ” If the absolute difference between TC and BC lines of CPR is less than 0.2% of the close price, it is marked as narrow.” but it is not working for me, and all are showing as “No” while your sheet showing correctly where it is a narrow case.

    • Hi Anand,

      Yes, that’s because Google finance keeps changing the symbol names for Nifty and Banknifty. We’ll update as soon as we get the new symbol name

      • Hi Admin
        I am no longer able to fetch the data in when I change the script name and internet connection is on, kindly guide me.

        • Hi Rahul,

          I just checked and the data is fetching correctly. Can you re-check on your side and let me know if you are facing any errors

  9. Hi!
    The sheet works fine on google docs. But the moment I download it, the individual stock sheet doesn’t automatically populate the fields when I select any stock from the dropdown list.
    Please help.

  10. Hi.
    I have downloaded this CPR sheet but it doesn’t update and neither do the values in the Individual Stock sheet auto-populate upon selection of any stock. However, they all work just fine on google docs. Please help.
    Thanks.

    • Hi Sheela,

      The CPR spreadsheet is designed to work only as a Google sheet. It would not fetch data if you open it in MS Excel

  12. Parameters!$B$1, what is the parameter here you used in the narrow CPR calculation function?

  14. Hi. When does the sheet get updated post market hours? I am looking it up at 19:53 IST today, 05/08/2021 but the OHLC value shown are not today’s but yesterday’s.

    • Hi Pramod,

      There is no fixed timing, the prices are fetched from Google finance and it depends on when they update it at their end

  15. Can you please share the back test data of these Strategy of at least 1000 Trades.

    • Hi Jatin,

      As of now we do not have backtest data. Do you want backtesting to be done on any particular scrip?

  17. GREAT stuff, the Link to download the CPR is not working, tried different E mails, Is there another link I can use or can you send one to me

    • Hi Russ,

      The CPR spreadsheet is built with Google sheets and can be accessed online (there is no option to download). Can you please share the link that you tried?

Leave a Reply

Your email address will not be published.