MarketXLS

Option Market Statistics

Returns comprehensive option market statistics for an underlying stock using QuoteMedia's data service.

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

  • Market-wide volume metrics
  • Open interest totals
  • Implied volatility statistics
  • Historical volatility comparisons

Notes

  • This is an array formula that returns tabular data
  • Provides broader market context than recent stats
  • Useful for overall market sentiment analysis

Syntax

=QM_GetOptionMarketStats(Symbol)
Excel Desktop (Windows)

Parameters

symbolstringRequired

Underlying stock ticker symbol

Returns

array

Option market statistics as a table

Examples

=QM_GetOptionMarketStats("AAPL")
Market stats for Apple options
=QM_GetOptionMarketStats("SPY")
Market stats for SPY options
=QM_GetOptionMarketStats("TSLA")
Market stats for Tesla options
=QM_GetOptionMarketStats(A1)
Symbol from cell reference

When to Use

  • Analyze overall options market activity
  • Compare implied vs historical volatility
  • Research options market depth
  • Market sentiment analysis

When NOT to Use

Scenario Use Instead
Need full option chain QM_GetOptionChain()
Need recent activity QM_GetRecentOptionStats()
Need individual Greeks QM_GetOptionQuotesAndGreeks()

Common Issues & FAQ

What's the difference between this and QM_GetRecentOptionStats?

QM_GetOptionMarketStats() provides broader market-level statistics, while QM_GetRecentOptionStats() focuses on recent trading activity.

How is implied volatility calculated?

Implied volatility is derived from option prices using standard options pricing models.

Related Formulas

More MarketXLS Price Quotes formulas you can use in the same worksheet:

See QM_GetOptionMarketStats used in a complete workbook: Option Prices in Google Sheets: Pulling Live Quotes, Chains, and Greeks with GOOGLEFINANCE and MarketXLS

Get Access to 1 Billion Usable Market data points IN YOUR EXCEL SHEETS WITH EASY TO USE EXCEL FUNCTIONS

Get started today
MarketXLS Excel Add-in Tutorial - How to Use Option Market Statistics and Other Financial Formulas
▶
How does MarketXLS work?

Related Functions