Trade Volume
Returns the trade volume (number of trades executed) for a stock using QuoteMedia's on-demand data service.
Trade Volume vs Share Volume
| Metric | Description |
|---|---|
| Trade Volume | Number of individual trades executed |
| Share Volume | Total number of shares traded |
A single trade can involve many shares, so share volume is typically much larger than trade volume.
Supported Symbol Formats
| Type | Format | Example |
|---|---|---|
| US Stocks | SYMBOL | AAPL, MSFT |
| ETFs | SYMBOL | SPY, QQQ |
Parameters
| Parameter | Type | Required | Description |
|---|---|---|---|
| Symbol | String | Yes | Stock ticker symbol |
Notes
- Counts number of trades, not shares
- Useful for analyzing trading activity
- High trade count with low share volume can indicate retail activity
Syntax
=mxls.QM_TradeVolume(Symbol)Examples
=mxls.QM_TradeVolume("AAPL")=mxls.QM_TradeVolume("SPY")=mxls.QM_TradeVolume(A1)When to Use
- Analyze trading activity frequency
- Compare retail vs institutional activity
- Market microstructure analysis
- Liquidity assessment
When NOT to Use
| Scenario | Use Instead |
|---|---|
| Need share volume | QM_ShareVolume() or QM_Volume() |
| Need streaming data | QM_Stream_Volume() |
| Need historical volume | QM_GetHistory() |
Common Issues & FAQ
Why is trade volume much smaller than share volume?
Trade volume counts individual trades. One trade can be for thousands of shares. Share volume counts all shares across all trades.
What does high trade volume with low share volume indicate?
This typically indicates many small trades, often associated with retail trading activity.
How is this different from QM_Volume?
QM_Volume() typically returns share volume, while QM_TradeVolume() returns the count of trades.
Get Access to 1 Billion Usable Market data points IN YOUR EXCEL SHEETS WITH EASY TO USE EXCEL FUNCTIONS
Get started today
▶
How does MarketXLS work?