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
Examples
=QM_TradeVolume("AAPL")=QM_TradeVolume("SPY")=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
Q: Why is trade volume much smaller than share volume? A: Trade volume counts individual trades. One trade can be for thousands of shares. Share volume counts all shares across all trades.
Q: What does high trade volume with low share volume indicate? A: This typically indicates many small trades, often associated with retail trading activity.
Q: How is this different from QM_Volume?
A: 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?