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
Syntax
=QM_Stream_AccumulatedPrice(Symbol)Returns
number
Real-time streaming accumulated price
Examples
=QM_Stream_AccumulatedPrice("AAPL")=QM_Stream_AccumulatedPrice("MSFT")=QM_Stream_AccumulatedPrice("SPY")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
What is accumulated price used for?
It's primarily used in calculating weighted averages and other cumulative metrics.
Why is the value so large?
Accumulated price sums all trade prices during the session - this is expected behavior.
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?