Stream Open Interest
Returns the real-time streaming open interest for an option contract using QuoteMedia's streaming data service.
What is Open Interest?
Open interest represents the total number of outstanding option contracts that have not been settled. It's updated after each trading day but streaming provides the most recent available data.
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
- Real-time streaming data
- Updates automatically
- Note: OI is officially calculated end-of-day
Examples
=QM_Stream_OpenInterest("AAPL240315C00170000")=QM_Stream_OpenInterest("SPY240621P00450000")Symbol from cell reference
When to Use
- Real-time options monitoring
- Live dashboards
- Tracking market positioning
- Options flow analysis
When NOT to Use
| Scenario | Use Instead |
|---|---|
| Don't need streaming | QM_OpenInterest() |
| Need full chain with OI | QM_GetOptionChain() |
| Need historical OI | Historical data functions |
Common Issues & FAQ
Q: Does open interest update intraday? A: Open interest is officially calculated after market close. Intraday values may reflect the previous day's closing OI.
Q: Why is streaming OI useful if it's calculated EOD? A: Streaming ensures you have the most recent available data and updates immediately when new daily OI is published.
Q: What does changing OI indicate? A: Rising OI = new positions being opened. Falling OI = positions being closed.
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?