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
Syntax
=mxls.QM_ShareVolume(Symbol)Examples
=mxls.QM_ShareVolume("AAPL")=mxls.QM_ShareVolume("SPY")=mxls.QM_ShareVolume(A1)=mxls.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
What's the difference between QM_ShareVolume and QM_Volume?
They may return similar values. Both represent share volume. Check if one is normalized differently.
Why use share volume instead of trade volume?
Share volume shows the total market activity in terms of shares exchanged. Trade volume shows transaction count regardless of size.
How do I compare to average?
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?