Stream Accumulated Trade Value
Streams the real-time accumulated trade value (also known as dollar volume) for stocks and ETFs. This represents the total dollar value of all trades during the current session (price * shares for each trade, summed).
Supported Symbol Formats
| Type | Format | Example |
|---|---|---|
| US Stocks | SYMBOL | AAPL, MSFT |
| ETFs | SYMBOL | SPY, QQQ |
Notes
- Data streams automatically update in Excel
- Value resets at market open each day
- Useful for measuring institutional activity and liquidity
Syntax
=QM_Stream_AccumulatedTradeValue(Symbol)Returns
number
Real-time streaming accumulated trade value (dollar volume)
Examples
=QM_Stream_AccumulatedTradeValue("AAPL")=QM_Stream_AccumulatedTradeValue("MSFT")=QM_Stream_AccumulatedTradeValue("SPY")Symbol from cell reference
When to Use
- Measuring trading activity in dollar terms
- Institutional flow analysis
- Liquidity assessment
- Comparing activity across different priced stocks
When NOT to Use
| Scenario | Use Instead |
|---|---|
| Need share volume | QM_Stream_Volume() |
| Need VWAP | QM_Stream_Vwap() |
| Need accumulated volume | QM_Stream_AccumulatedVolume() |
| Need current price | QM_Stream_Last() |
Common Issues & FAQ
What is accumulated trade value?
It's the sum of (price * volume) for each trade during the session - also called dollar volume.
Why use this instead of volume?
Dollar volume normalizes across different stock prices, making it easier to compare trading activity.
Why am I getting #N/A?
Check that symbol format is correct.
Related Formulas
More MarketXLS Price Quotes (Streaming) formulas you can use in the same worksheet:
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?