Stream Accumulated Price

Streams the real-time accumulated price for stocks and ETFs. This represents the cumulative sum of trade prices during the current trading session.

Supported Symbol Formats

Type Format Example
US Stocks SYMBOL AAPL, MSFT
ETFs SYMBOL SPY, QQQ

Notes

  • Data streams automatically update in Excel
  • Accumulated price resets at market open each day
  • Useful for calculating average prices and VWAP-related metrics

Examples

=QM_Stream_AccumulatedPrice("AAPL")
Stream accumulated price for Apple
=QM_Stream_AccumulatedPrice("MSFT")
Stream accumulated price for Microsoft
=QM_Stream_AccumulatedPrice("SPY")
Stream accumulated price for SPY ETF
=QM_Stream_AccumulatedPrice(A1)
Symbol from cell reference

When to Use

  • Advanced price analysis
  • Custom VWAP calculations
  • Cumulative price tracking
  • Algorithmic trading support

When NOT to Use

Scenario Use Instead
Need current price QM_Stream_Last()
Need VWAP QM_Stream_Vwap()
Need TWAP QM_Stream_Twap()
Need accumulated volume QM_Stream_AccumulatedVolume()

Common Issues & FAQ

Q: What is accumulated price used for? A: It's primarily used in calculating weighted averages and other cumulative metrics.

Q: Why is the value so large? A: Accumulated price sums all trade prices during the session - this is expected behavior.

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 Price and Other Financial Formulas
▶
How does MarketXLS work?

Related Functions