MarketXLS

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.

Syntax

=QM_Volume(Symbol)
Excel Desktop (Windows)

Parameters

symbolstringRequired

Stock ticker or option symbol

Returns

number

Trading volume

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

Why is volume zero or very low?

This may indicate:

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

What's the difference between QM_Volume and Volume?

QM_Volume() uses QuoteMedia data on-demand, while Volume() may use different data sources.

Excel Templates Using Volume (On Demand)

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

Related Formulas

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

See QM_Volume used in a complete workbook: Stock Market Data MCP Connector: Live Prices in Excel and AI

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?

Related Functions