Historical Open Interest (Options)
Returns open interest data for a historical date. Useful for analyzing how options positioning has changed over time.
Parameters
| Parameter | Required | Description |
|---|---|---|
| Underlying | Yes | Stock ticker symbol |
| PastDate | Yes | Historical date (YYYY-MM-DD) |
| Direction | Yes | 'put' or 'call' |
Syntax
=opt_TotalOpenInterestOptionsHistorical(Underlying, PastDate, Direction)Parameters
underlyingstringRequired
pastDatedateRequired
directionstringRequired
Returns
number
Historical open interest for specified date
Examples
=opt_TotalOpenInterestOptionsHistorical("AAPL", "2024-01-15", "put")=opt_TotalOpenInterestOptionsHistorical("SPY", DATE(2024,1,10), "call")When to Use
- Analyzing OI changes over time
- Tracking positioning shifts
- Historical options analysis
When NOT to Use
| Scenario | Use Instead |
|---|---|
| Need current OI | opt_TotalOpenInterestOptions() |
| Need current volume | opt_TotalVolumeOptions() |
Common Issues & FAQ
How far back is historical data available?
Typically 1-2 years of historical OI data is available.
Related Formulas
More MarketXLS Options formulas you can use in the same worksheet:
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?