Historical Put/Call Volume Ratio
Returns the put/call volume ratio for a historical date.
Parameters
| Parameter | Required | Description |
|---|---|---|
| Underlying | Yes | Stock ticker symbol |
| OnDate | Yes | Historical date |
Syntax
=opt_PutCallVolRatioHistorical(Underlying, OnDate)Parameters
underlyingstringRequired
onDatedateRequired
Returns
number
Historical put/call volume ratio
Examples
=opt_PutCallVolRatioHistorical("AAPL", "2024-01-15")=opt_PutCallVolRatioHistorical("SPY", DATE(2024,1,10))When to Use
- Analyzing historical sentiment
- Tracking P/C ratio over time
- Backtesting sentiment indicators
When NOT to Use
| Scenario | Use Instead |
|---|---|
| Need current ratio | opt_PutCallVolRatio() |
| Need OI ratio | opt_PutCallOIRatio() |
Common Issues & FAQ
How far back is data available?
Typically 1-2 years of historical data.
Related Formulas
More MarketXLS Options formulas you can use in the same worksheet:
- American Option Value
- Average Vol/OI Ratio
- Average Volume (Options)
- Bachelier Option Value
- Black Scholes Option Value
- Black Scholes Option Value With User Inputs
- Black76Option Value
- Call Historical Vol/OI
See opt_PutCallVolRatioHistorical used in a complete workbook: Options Spreadsheet: Track IV Rank, Greeks and Strategy Selection in Excel (2026)
Get Access to 1 Billion Usable Market data points IN YOUR EXCEL SHEETS WITH EASY TO USE EXCEL FUNCTIONS
Get started today
▶
How does MarketXLS work?