Home MarketXLS
Dashboard MarketXLS
Screener MarketXLS
Options Profit Calculator MarketXLS
Stock Ranks MarketXLS
Spreadsheet Builder MarketXLS
Documentation MarketXLS
Logout MarketXLS

Live Put Call Ratio Nifty/NSE – (MarketXLS Formulas)

Written by MarketXLS Team on 
Thu Feb 08 2024
 about India
Boost your market advantage with MarketXLS. Real-time, enterprise-grade data. Book a demo or subscribe now!

Table of Contents

Welcome to the fascinating world of option trading! This comprehensive guide will elucidate the concept of the put call ratio Nifty, its pivotal role in deciphering the market sentiment, and how to correctly analyze it for enhancing your trading strategies.

What is Put Call Ratio?

The Put Call Ratio is an indicator used in the Option Trading. It is a ratio that compares the trading volume of put options to call options. The ratio is calculated by dividing the number of traded put options by the number of traded call options. An increase in the put-call ratio is seen as bearish because it implies an increase in the number of put options traded. Conversely, a decrease in this ratio is seen as bullish, as it suggests a higher number of call options being traded. This tool is useful for traders to understand the mood of the market.

What is a good Put Call Ratio?

A good put-call ratio is not a fixed number. It changes based on market conditions. Generally, a high put-call ratio, such as above 1, indicates a bearish trend, meaning investors expect the market to fall. Conversely, a low ratio, like below 1, shows a bullish sentiment, signalling that the market is expected to rise. Nevertheless, savvy investors watch for extreme variations. These extremes in the put-call ratio often signal market reversals. In effect, the right interpretation of a good put-call ratio depends on one’s perspective and market strategy.

How is Put Call Ratio Calculated?

The Put Call Ratio (PCR) is calculated by dividing the number of traded put options by the number of traded call options. As puts are used to hedge against price decreases and calls are used to hedge against price increases, this ratio can be used as a sentiment indicator. For example, if for Nifty 50 Options there are 2000 traded put options and 1000 traded call options, you would calculate the PCR by dividing 2000 by 1000, getting a PCR of 2. This suggests a bearish sentiment as more traders are expecting the price to decrease.

Is Put Call Ratio (PCR) same as Put Call Parity %?

Put Call Ratio (PCR) and Put Call Parity are two different concepts in the field of options trading. PCR is a popular indicator of investor sentiment, calculated by dividing the number of traded put options by the number of traded call options. It provides insights into market sentiment – a high PCR points to a bearish mood among investors and vice versa. On the other hand, Put Call Parity represents an equilibrium relationship between the prices of European put and call options with the same strike price, expiry, and underlying asset. It does not reflect a percentage or ratio in sales, rather it’s a principle used for price determination. Hence, PCR should not be mistaken as the Put Call Parity percentage.

What other key option metric as a trader you will monitor along with Put Call ratio?

As a trader, along with the Put Call ratio, another key option metric to monitor is Implied Volatility (IV). IV reflects market’s view on how much underlying stock will move in the future. It can provide insights on perceived risk associated with the stock. High IV can imply significant price movement whereas low IV may suggest stability. Furthermore, by comparing IV with historical volatility, traders can identify overpriced or underpriced options which can create profitable trading opportunities. Therefore, tracking Implied Volatility can be an essential part of a trader’s strategy.

How do you find the Put Call Ratio Today?

With MarketXLS, traders can utilize a key formula, =OPT_TotalVolumeOptions(“NIFTY”,”Call or Put”), to gain access to today’s volumes for both call and put options. This data can prove invaluable for those seeking to calculate the Put Call Ratio Volume. Rounded out with clear, user-friendly functions, MarketXLS even allows traders to input a future expiration date within this formula. This flexibility means traders can easily retrieve the Put Call ratio for an underlying Index or stock set to expire on a later date. With MarketXLS, getting key trading insights are just a few keystrokes away.

Two ways to calculate Put Call Ratio.

The Put Call Ratio can be calculated in two ways. First, one can get the ratio by dividing the total Put Volume by the Total Call Volume. This method provides a snapshot of the prevailing sentiment in the market. The second method involves dividing the total Put Open Interest by the Total Call Open Interest. This way tends to reflect a more broad market sentiment as it includes both the current trades and those that are yet to be settled. Among the two, the second method is often considered more reliable and accurate by investors and traders alike.

What is the typical range of Put/Call ratio for Nifty?

The NIFTY Put call ratio is a vital market indicator. It usually follows a precise trend. It fluctuates between 0.8 and 1.3. This recorded range represents a lower and upper band. The figure of 0.8 refers to the lower band. The measurement of 1.3 indicates the upper band. This fluctuation is a key trend to watch in market analysis. Achieving a balance is seen as optimal. This oscillating trend can inform investment decisions and strategies. It gives insights into the market’s bullish or bearish nature.

What timeframe to look for PCR ratio on?

The PCR (Put-Call Ratio) ratio is a popular tool used by investors to anticipate market trends. While there’s no universally perfect timeframe to consider its use, most technical analysts find it most effective when used on a near-term basis, typically one to two weeks. This is especially applicable to the Indian markets like Nifty. It’s essential to remember though, that no singular indicator can consistently predict market behaviour, and as such, PCR should be used in conjunction with other technical indicators.

How to interpret Put Call Ratio?

Put Call Ratio (PCR) is a vital tool to interpret market sentiment. PCR >1 indicates the market might surge as sellers expect market stability or growth. However, when traders anticipate a bearish market trend, they buy puts, increasing PCR to <1. Striking a note of caution, if PCR exceeds 1.7, this may signal extended markets that could reverse. Hence, it's crucial to interpret PCR correctly for informed trading decisions. Overall, a deep understanding of PCR helps predict market trends effectively. Remember to always approach with caution when markets seem overstretched, as indicated by a PCR above 1.7.

Follow the smart money

The put call ratio is a key indicator used in options trading, comparing the volume of traded put options to call options. This ratio can provide insight into market sentiment, with a high ratio indicating a bearish trend and a low ratio indicating a bullish trend. Extreme variations in the ratio can signal market reversals. It is calculated by dividing the number of traded put options by the number of call options. Along with the put call ratio, traders also monitor another key metric – implied volatility, which provides insight into the perceived risk associated with the stock. The put call ratio should not be confused with the put-call parity, which is a different concept. Furthermore, traders can use tools like MarketXLS to find today’s put call ratio and also track the put-call open interest ratio, another useful tool in options trading.

What is PutCall OI Ratio? And how can that help in trading options?

PutCall to Open Interest (OI) ratio is a tool used in options trading. It’s calculated by dividing the total put options open interest by the total call options open interest. This ratio can signal market sentiment, helping traders make more informed decisions. A high ratio indicates bearish sentiment as more traders are buying put options expecting prices to decrease. Conversely, a low ratio suggests bullish sentiment, as more traders are buying call options expecting prices to rise. By tracking changes in this ratio, traders can identify potential reversals and adjust their strategies accordingly. Thus, the PutCall to OI Ratio can be a valuable addition to a trader’s toolkit.

Example Functions

MarketXLS provides a range of key metrics useful for your options trading, all designed to give you a market advantage. Please check the list below showcasing these functions. Utilize these to gain an edge in market trading. They are all crucial elements for successful options trading. Majority of these are quite easy to understand and use. The potential gains could be significant.

put call ratio Nifty

Calculate PCR in Excel with MarketXLS

This example showcases the volume distribution of options for various expiration dates. Option traders can leverage this information to understand the market sentiment, bearish or bullish, by looking at the Put/Call (P/C) Volume Ratio and the P/C Open Interest Ratio (OI Ratio). For instance, the expiration date, February 8, 2024, shows a total volume of about 2.54 billion, with a P/C Volume ratio of 84%, indicating a relatively high volume of Call options. Similarly, the expiration date, March 28, 2024, has P/C OI Ratio of 160%, showing there is a higher open interest in Put options. These metrics provide insight into the market’s expected future performance, helping traders make informed decisions. The percentage in the last two columns depicts the magnitude of each date’s contribution to the total volume, giving an idea of market liquidity. This information could influence the trader’s choice in selecting suitable expiry dates.

put call ratio Nifty


Typically, smart money and institutional investors hold large positions focused more on option selling. These big players have access to detailed market information and the ability to make predictions others might miss. This gives them a strategic edge in the market. Therefore, following their moves can be a wise strategy. One good indicator to follow the smart money is the PCR (put-call ratio). It can indicate the sentiment of these savvy investors, helping the less-informed market participants to make wiser investment decisions. So, keep an eye on the PCR ratio if you wish to keep pace with the smart money in the market.

Interested in building, analyzing and managing Portfolios in Excel?
Download our Free Portfolio Template
I agree to the MarketXLS Terms and Conditions
Call: 1-877-778-8358
Ankur Mohan MarketXLS
Welcome! I'm Ankur, the founder and CEO of MarketXLS. With more than ten years of experience, I have assisted over 2,500 customers in developing personalized investment research strategies and monitoring systems using Excel.

I invite you to book a demo with me or my team to save time, enhance your investment research, and streamline your workflows.
Implement “your own” investment strategies in Excel with thousands of MarketXLS functions and templates.

We respect your privacy and will never share your email.
MarketXLS is a complete Excel stock solution

Kevin Hsu


I have used lots of stock and option information services. This is the only one which gives me what I need inside Excel

Lloyd Lenase

Option Day Trader

MarketXLS is a data junkie’s dream. It gives me the flexibility to mine for hidden treasures.


Swing trader since 2011

I like to access historical closing prices on a particular date. That makes tracking performance easy.

Patrick Cusatis, Ph.D., CFA

Associate Professor of Finance - Penn State University

Get Access to 1 Billion Usable Market data points IN YOUR EXCEL SHEETS WITH EASY TO USE EXCEL FUNCTIONS

Get started today

🎉 Exciting news! 🎉

You are invited to join our Discord Channel.

Interact, learn, and grow with experts in the markets!

Join our Discord