Stream Accumulated Volume
Streams the real-time accumulated share volume for stocks and ETFs. This represents the cumulative number of shares traded during the current session.
Supported Symbol Formats
| Type | Format | Example |
|---|---|---|
| US Stocks | SYMBOL | AAPL, MSFT |
| ETFs | SYMBOL | SPY, QQQ |
Notes
- Data streams automatically update in Excel
- Volume resets at market open each day
- Similar to
QM_Stream_Volume()but explicitly labeled as accumulated
Syntax
=QM_Stream_AccumulatedVolume(Symbol)Returns
number
Real-time streaming accumulated share volume
Examples
=QM_Stream_AccumulatedVolume("AAPL")=QM_Stream_AccumulatedVolume("MSFT")=QM_Stream_AccumulatedVolume("SPY")Symbol from cell reference
When to Use
- Tracking total session volume
- Building volume-based indicators
- Monitoring cumulative trading activity
- Relative volume calculations
When NOT to Use
| Scenario | Use Instead |
|---|---|
| Need session volume | QM_Stream_Volume() |
| Need dollar volume | QM_Stream_AccumulatedTradeValue() |
| Need historical volume | Volume_Historical() |
| Need average volume | AverageDailyVolume() |
Common Issues & FAQ
What's the difference between Volume and AccumulatedVolume?
They are typically the same - both represent cumulative shares traded during the session.
Why does volume reset to zero?
Volume resets at market open each trading day.
Why am I getting #N/A?
Check that symbol format is correct.
Excel Templates Using Stream Accumulated Volume
These ready-made MarketXLS templates call QM_Stream_AccumulatedVolume() in their worksheet formulas. Open one to see the function working inside a complete model.
Related Formulas
More MarketXLS Price Quotes (Streaming) formulas you can use in the same worksheet:
- Stream Accumulated Volume
- Stream Ask Implied Volatility
- Stream Ask Price
- Stream Ask Price
- Stream Ask Size
- Stream Ask Size
- Stream Bid Implied Volatility
- Stream Bid Price
See QM_Stream_AccumulatedVolume used in a complete workbook: How to Insert Stock Price in Excel for Real-Time Quotes
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?