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 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.
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:
- Top Central (TC)
- Bottom Central (BC)
- Resistance Levels (R1 to R4)
- Support Levels (S1 to S4)
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 – 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.
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:
- Use narrow range CPR to predict trending moves
- Breakout of CPR levels can be used to take Buy/Sell positions
- 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.