Put/Call Open Interest Ratio

Returns the ratio of put open interest to call open interest. Unlike volume ratio (daily activity), OI ratio reflects accumulated positioning.

Parameters

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

OI Ratio vs Volume Ratio

Metric Measures Timeframe
Volume Ratio Daily trading activity Intraday
OI Ratio Accumulated positions Long-term

Examples

=opt_PutCallOIRatio("AAPL")
All expirations OI ratio
=opt_PutCallOIRatio("SPY", "2024-01-19")
Specific expiry OI ratio

When to Use

  • Long-term positioning analysis
  • Sentiment from accumulated positions
  • Support/resistance identification
  • Hedging activity analysis

When NOT to Use

Scenario Use Instead
Need volume ratio opt_PutCallVolRatio()
Need historical ratio opt_PutCallOIRatioHistorical()
Need raw OI opt_TotalOpenInterestOptions()

Common Issues & FAQ

Q: Why is OI ratio more stable than volume ratio? A: OI represents accumulated positions over time, while volume resets daily. OI provides a more stable long-term view.

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 OI Ratio (Options) and Other Financial Formulas
▶
How does MarketXLS work?

Related Functions