Open Interest
Returns the open interest (number of open contracts) for an option or futures symbol.
Parameters
| Parameter | Type | Required | Description |
|---|---|---|---|
| Symbol | string | Yes | Option or futures symbol |
Syntax
=OpenInterest(Symbol)Examples
=OpenInterest("AAPL240315C00170000")=OpenInterest(OptionSymbol("AAPL",DATE(2024,3,15),"Call",170))When to Use
- Options analysis
- Liquidity assessment
- Market sentiment
When NOT to Use
| Scenario | Use Instead |
|---|---|
| Historical OI | Open_Interest_Historical() |
Common Issues & FAQ
What is open interest?
Total number of outstanding contracts not yet settled.
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?