Volume (On Demand)

Returns the trading volume for a stock or option contract using QuoteMedia's on-demand data service.

Supported Symbol Formats

Type Format Example
US Stocks SYMBOL AAPL, MSFT
ETFs SYMBOL SPY, QQQ
Options (OCC) SYMBOL+YYMMDD+C/P+STRIKE AAPL240315C00170000

Parameters

Parameter Type Required Description
Symbol String Yes Stock ticker or OCC option symbol

Notes

  • Volume represents the number of shares/contracts traded
  • For stocks: number of shares
  • For options: number of contracts
  • Volume resets at market open each day

Important: Volume Includes Pre-Market & Post-Market

The volume returned by this function includes all trading sessions — pre-market, regular hours, and post-market. It is not limited to regular session (9:30 AM – 4:00 PM ET) volume.

To calculate regular session volume only, subtract pre-market and post-market volume from the total.

Examples

=QM_Volume("AAPL")
Apple trading volume
=QM_Volume("SPY")
SPY ETF volume
=QM_Volume("AAPL240315C00170000")
Option contract volume
=QM_Volume(A1)
Symbol from cell reference

When to Use

  • Assess trading activity and liquidity
  • Identify unusual volume spikes
  • Volume analysis for trading decisions
  • Monitor market interest in a security

When NOT to Use

Scenario Use Instead
Need streaming volume QM_Stream_Volume()
Need average daily volume AverageDailyVolume()
Need volume over time QM_GetHistory()

Common Issues & FAQ

Q: Why is volume zero or very low? A: This may indicate:

  • Market is closed or pre/post market hours
  • Illiquid security
  • Data delay

Q: What's the difference between QM_Volume and Volume? A: QM_Volume() uses QuoteMedia data on-demand, while Volume() may use different data sources.

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