Open Interest Historical
Returns the open interest for an option on a specific historical date.
Parameters
| Parameter | Type | Required | Description |
|---|---|---|---|
| Symbol | string | Yes | Option symbol |
| OnDate | date | Yes | Historical date |
Syntax
=Open_Interest_Historical(Symbol, OnDate)Parameters
symbolstringRequired
onDatedateRequired
Returns
number
Historical open interest
Examples
=Open_Interest_Historical("AAPL240315C00170000", DATE(2024,1,15))When to Use
- Historical options analysis
- OI trend analysis
When NOT to Use
| Scenario | Use Instead |
|---|---|
| Current OI | OpenInterest() |
Common Issues & FAQ
What dates are available?
Depends on data coverage.
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?