Open Interest (On Demand)
Returns the open interest (number of outstanding contracts) for an option contract using QuoteMedia's on-demand data service.
What is Open Interest?
Open interest represents the total number of outstanding option contracts that have not been settled. It indicates market activity and liquidity for a particular option.
Supported Symbol Formats
| Type | Format | Example |
|---|---|---|
| Option (OCC) | SYMBOL+YYMMDD+C/P+STRIKE | AAPL240315C00170000 |
Parameters
| Parameter | Type | Required | Description |
|---|---|---|---|
| Symbol | String | Yes | OCC-format option symbol |
Notes
- High open interest indicates more liquidity
- Open interest updates after market close
- Changes in OI can signal market sentiment
Examples
=QM_OpenInterest("AAPL240315C00170000")=QM_OpenInterest("MSFT240419P00400000")=QM_OpenInterest(A1)When to Use
- Assess option liquidity before trading
- Analyze market interest in specific strikes
- Track changes in market positioning
- Building options flow analysis
When NOT to Use
| Scenario | Use Instead |
|---|---|
| Need real-time streaming OI | QM_Stream_OpenInterest() |
| Need full option chain | QM_GetOptionChain() |
| Need option volume instead | QM_Volume() |
Common Issues & FAQ
Q: Why is open interest zero or very low? A: This may indicate:
- Recently listed option series
- Very illiquid strike/expiration
- Far out-of-the-money option
Q: When does open interest update? A: Open interest is calculated and updated after market close each day.
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?