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

Examples

=QM_Stream_AccumulatedTradeValue("AAPL")
Stream dollar volume for Apple
=QM_Stream_AccumulatedTradeValue("MSFT")
Stream dollar volume for Microsoft
=QM_Stream_AccumulatedTradeValue("SPY")
Stream dollar volume for SPY ETF
=QM_Stream_AccumulatedTradeValue(A1)
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

Q: What is accumulated trade value? A: It's the sum of (price * volume) for each trade during the session - also called dollar volume.

Q: Why use this instead of volume? A: Dollar volume normalizes across different stock prices, making it easier to compare trading activity.

Q: Why am I getting #N/A? A: Check that symbol format is correct.

Get Access to 1 Billion Usable Market data points IN YOUR EXCEL SHEETS WITH EASY TO USE EXCEL FUNCTIONS

Get started today
MarketXLS Excel Add-in Tutorial - How to Use Stream Accumulated Trade Value and Other Financial Formulas
▶
How does MarketXLS work?

Related Functions