Stream Percentage Change

Streams the real-time percentage change from the previous day's closing price. Positive values indicate gains, negative values indicate losses.

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
  • Formula: (Last - PreviousClose) / PreviousClose * 100
  • Use with QM_Stream_Change() for dollar amount

Examples

=QM_Stream_PercentageChange("AAPL")
Stream % change for Apple
=QM_Stream_PercentageChange("MSFT")
Stream % change for Microsoft
=QM_Stream_PercentageChange("SPY")
Stream % change for SPY ETF
=QM_Stream_PercentageChange(A1)
Symbol from cell reference
=TEXT(QM_Stream_PercentageChange("AAPL"),"0.00%")
Format as percentage

When to Use

  • Real-time performance dashboards
  • Comparing relative moves across stocks
  • Alert triggers based on percentage moves
  • Portfolio performance tracking

When NOT to Use

Scenario Use Instead
Need dollar change QM_Stream_Change()
Need on-demand percent change QM_ChangePercent()
Need post-market percent change QM_Stream_PostMarketPercentChange()
Need pre-market percent change QM_Stream_PreMarketPercentChange()

Common Issues & FAQ

Q: Why is the percentage showing as 0 before market open? A: Before trading starts, there's no change from the previous close.

Q: How do I format this as a percentage? A: Use =TEXT(QM_Stream_PercentageChange("AAPL")/100,"0.00%") or format the cell as percentage.

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

Related Functions