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 |
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
Q: What dates are available? A: Depends on data coverage.
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?