Put/Call Volume Ratio

Returns the ratio of put volume to call volume. Values above 1.0 indicate more put activity (bearish sentiment), below 1.0 indicates more call activity (bullish).

Parameters

Parameter Required Description
Underlying Yes Stock ticker symbol
ExpirationDate No Specific expiry or all

Interpreting the Ratio

Ratio Interpretation
< 0.7 Bullish (heavy call activity)
0.7-1.0 Neutral to slightly bullish
1.0-1.3 Neutral to slightly bearish
> 1.3 Bearish (heavy put activity)

Examples

=opt_PutCallVolRatio("AAPL")
All expirations P/C ratio
=opt_PutCallVolRatio("SPY", "2024-01-19")
Specific expiry ratio
=opt_PutCallVolRatio(A1)
Symbol from cell

When to Use

  • Quick sentiment indicator
  • Contrarian analysis (extreme readings)
  • Options flow analysis
  • Market sentiment tracking

When NOT to Use

Scenario Use Instead
Need OI ratio opt_PutCallOIRatio()
Need historical ratio opt_PutCallVolRatioHistorical()
Need raw volumes opt_TotalVolumeOptions()

Common Issues & FAQ

Q: Is a high P/C ratio always bearish? A: Not necessarily. Extreme readings can be contrarian indicators. Very high ratios sometimes occur at market bottoms as fear peaks.

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

Get started today
MarketXLS Excel Add-in Tutorial - How to Use Volume Ratio and Other Financial Formulas
▶
How does MarketXLS work?

Related Functions