MarketXLS

Stream Price Change

Streams the real-time price change in dollars from the previous day's closing price. Positive values indicate the stock is up, negative values indicate it is down.

Supported Symbol Formats

Type Format Example
US Stocks SYMBOL AAPL, MSFT
ETFs SYMBOL SPY, QQQ
Indices ^SYMBOL ^SPX, ^VIX
Options OCC Symbol AAPL240315C00170000

Notes

  • Data streams automatically update in Excel
  • Change = Last Price - Previous Close
  • Use with QM_Stream_PercentageChange() for relative performance

Syntax

=QM_Stream_Change(Symbol)
Excel Desktop (Windows)

Returns

number

Real-time streaming price change in dollars

Examples

=QM_Stream_Change("AAPL")
Stream dollar change for Apple
=QM_Stream_Change("MSFT")
Stream dollar change for Microsoft
=QM_Stream_Change("SPY")
Stream dollar change for SPY ETF
=QM_Stream_Change(A1)
Symbol from cell reference
=IF(QM_Stream_Change("AAPL")>0,"UP","DOWN")
Conditional based on change

When to Use

  • Monitoring daily price movements
  • Building gain/loss dashboards
  • Alert triggers based on dollar moves
  • Portfolio change calculations

When NOT to Use

Scenario Use Instead
Need percentage change QM_Stream_PercentageChange()
Need on-demand change QM_Change()
Need current price QM_Stream_Last()
Need previous close QM_Stream_PreviousClose()

Common Issues & FAQ

Why is the change showing as zero before market open?

Before the market opens, there's no new trading activity to compare against previous close.

How do I calculate percentage change from dollar change?

Use =QM_Stream_Change("AAPL")/QM_Stream_PreviousClose("AAPL")*100 or just use QM_Stream_PercentageChange().

Why am I getting #N/A?

Check that symbol format is correct.

Excel Templates Using Stream Price Change

These ready-made MarketXLS templates call QM_Stream_Change() 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:

See QM_Stream_Change used in a complete workbook: Real Time Futures Prices in Excel: Live Streaming Data with MarketXLS 2025

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

Related Functions