Options Total Volume Historical

Returns the total options trading volume for an underlying security on a specific historical date.

Parameters

Parameter Type Required Description
Underlying string Yes Stock ticker symbol
PastDate date Yes Historical date
Direction string Yes "Call", "Put", or "All"

Notes

  • Useful for historical volume analysis
  • Can filter by calls, puts, or all options

Examples

=opt_TotalVolumeOptionsHistorical("AAPL", DATE(2024,1,15), "Call")
Apple call volume
=opt_TotalVolumeOptionsHistorical("SPY", DATE(2024,3,1), "All")
SPY all options
=opt_TotalVolumeOptionsHistorical("MSFT", DATE(2024,2,20), "Put")
Microsoft puts

When to Use

  • Historical options volume analysis
  • Backtesting options strategies
  • Volume pattern research
  • Options activity studies

When NOT to Use

Scenario Use Instead
Current open interest OpenInterest()
Unusual activity scan opt_UnusualOptionVolOIScanEOD()
Option chain data opt_HistoricalOptionChain()

Common Issues & FAQ

Q: What dates are available? A: Historical data availability varies by symbol and data coverage.

Q: What does Direction filter? A: Use "Call" for calls only, "Put" for puts only, "All" for total volume.

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 Options Total Volume Historical and Other Financial Formulas
▶
How does MarketXLS work?

Related Functions