MarketXLS

Total Volume (Options)

Returns the total options trading volume for an underlying stock. Can be filtered by option type (calls/puts), expiration date, and strike price.

Parameters

Parameter Required Default Description
Underlying Yes - Stock ticker symbol
OptionType No all 'all', 'call', or 'put'
ExpirationDate No all Specific date or 'all'
Strike No all Specific strike or blank

Understanding Options Volume

  • Volume = contracts traded today
  • High volume indicates active trading interest
  • Compare call vs put volume for sentiment
  • Use with open interest for complete picture

Notes

  • Returns today's cumulative volume
  • Data is typically 15-20 minutes delayed
  • Combine filters to narrow focus

Syntax

=opt_TotalVolumeOptions(Underlying, [OptionType], [ExpirationDate], [Strike])
Excel Desktop (Windows)

Parameters

underlyingstringRequired
optionTypestring
expirationDatedate
strikestring

Returns

number

Total options trading volume

Examples

=opt_TotalVolumeOptions("AAPL")
All AAPL options volume
=opt_TotalVolumeOptions("AAPL", "call")
AAPL call volume only
=opt_TotalVolumeOptions("AAPL", "put")
AAPL put volume only
=opt_TotalVolumeOptions("SPY", "all", "2024-01-19")
SPY volume for specific expiry
=opt_TotalVolumeOptions("TSLA", "call", "all", 250)
TSLA call volume at $250 strike
=opt_TotalVolumeOptions(A1, B1, C1, D1)
All params from cells

When to Use

  • Measuring options market activity
  • Comparing call vs put activity
  • Identifying unusual options volume
  • Analyzing volume by expiration
  • Options flow analysis

When NOT to Use

Scenario Use Instead
Need open interest opt_TotalOpenInterestOptions()
Need top contracts TopOptionsByVolume()
Need put/call ratio opt_PutCallVolRatio()
Need historical volume opt_PutCallVolRatioHistorical()

Common Issues & FAQ

Why is volume so different from open interest?

Volume = contracts traded today. Open interest = total outstanding. Volume resets daily; OI accumulates.

How do I get put/call ratio from volume?

Divide put volume by call volume, or use opt_PutCallVolRatio() directly.

Is the data real-time?

Options volume data is typically delayed 15-20 minutes during market hours.

Excel Templates Using Total Volume (Options)

These ready-made MarketXLS templates call opt_TotalVolumeOptions() in their worksheet formulas. Open one to see the function working inside a complete model.

Related Formulas

More MarketXLS Options formulas you can use in the same worksheet:

See opt_TotalVolumeOptions used in a complete workbook: MCP Options Order Flow Server: Read Options Flow in Claude and Excel (2026)

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

Related Functions