Share Volume
Returns the share volume (total number of shares traded) for a stock using QuoteMedia's on-demand data service.
Share Volume vs Trade Volume
| Metric | Description |
|---|---|
| Share Volume | Total number of shares traded |
| Trade Volume | Number of individual trades executed |
One 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
- Total shares traded for the day
- Resets at market open
- Useful for liquidity analysis
Examples
=QM_ShareVolume("AAPL")=QM_ShareVolume("SPY")=QM_ShareVolume(A1)=QM_ShareVolume("AAPL")/1000000When to Use
- Analyze trading liquidity
- Compare volume to average
- Volume-based indicators
- Market activity analysis
When NOT to Use
| Scenario | Use Instead |
|---|---|
| Need trade count | QM_TradeVolume() |
| Need streaming data | QM_Stream_Volume() |
| Need historical volume | QM_GetHistory() |
| Need average volume | AverageDailyVolume() |
Common Issues & FAQ
Q: What's the difference between QM_ShareVolume and QM_Volume? A: They may return similar values. Both represent share volume. Check if one is normalized differently.
Q: Why use share volume instead of trade volume? A: Share volume shows the total market activity in terms of shares exchanged. Trade volume shows transaction count regardless of size.
Q: How do I compare to average?
A: Compare QM_ShareVolume() to AverageDailyVolume() to see if today's volume is above or below average.
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?