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

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

Q: Why is the change showing as zero before market open? A: Before the market opens, there's no new trading activity to compare against previous close.

Q: How do I calculate percentage change from dollar change? A: Use =QM_Stream_Change("AAPL")/QM_Stream_PreviousClose("AAPL")*100 or just use QM_Stream_PercentageChange().

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

Related Functions