MarketXLS

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

Syntax

=QM_GetRecentOptionStats(Symbol)
Excel Desktop (Windows)

Parameters

symbolstringRequired

Underlying stock ticker symbol

Returns

array

Recent option statistics as a table

Examples

=QM_GetRecentOptionStats("AAPL")
Option stats for Apple
=QM_GetRecentOptionStats("SPY")
Option stats for SPY
=QM_GetRecentOptionStats("TSLA")
Option stats for Tesla
=QM_GetRecentOptionStats(A1)
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

What's the difference between this and QM_GetOptionMarketStats?

QM_GetRecentOptionStats() focuses on recent activity for a single symbol, while QM_GetOptionMarketStats() provides broader market statistics.

How often is this data updated?

Statistics are updated throughout the trading day as new options trades occur.

Related Formulas

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

See QM_GetRecentOptionStats used in a complete workbook: Options Spreadsheet in Excel: Track, Value, and Stress-Test Trades with 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 Statistics and Other Financial Formulas
▶
How does MarketXLS work?

Related Functions