Option Statistics
Returns recent option statistics for an underlying stock using QuoteMedia's data service. This provides aggregate statistics about options activity.
Supported Symbol Formats
| Type | Format | Example |
|---|---|---|
| US Stocks | SYMBOL | AAPL, MSFT |
| ETFs | SYMBOL | SPY, QQQ |
Parameters
| Parameter | Type | Required | Description |
|---|---|---|---|
| Symbol | String | Yes | Underlying stock ticker |
Statistics Included
- Total call volume
- Total put volume
- Put/Call ratio
- Implied volatility metrics
- Open interest statistics
Notes
- This is an array formula that returns tabular data
- Useful for quick options market overview
- Updates throughout the trading day
Examples
=QM_GetRecentOptionStats("AAPL")=QM_GetRecentOptionStats("SPY")=QM_GetRecentOptionStats("TSLA")Symbol from cell reference
When to Use
- Quick overview of options activity
- Analyze put/call ratios
- Gauge market sentiment through options
- Options trading research
When NOT to Use
| Scenario | Use Instead |
|---|---|
| Need full option chain | QM_GetOptionChain() |
| Need market-wide statistics | QM_GetOptionMarketStats() |
| Need individual option Greeks | QM_GetOptionQuotesAndGreeks() |
Common Issues & FAQ
Q: What's the difference between this and QM_GetOptionMarketStats?
A: QM_GetRecentOptionStats() focuses on recent activity for a single symbol, while QM_GetOptionMarketStats() provides broader market statistics.
Q: How often is this data updated? A: Statistics are updated throughout the trading day as new options trades occur.
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?