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
Syntax
=QM_Stream_PercentageChange(Symbol)Returns
Real-time streaming percentage change from previous close
Examples
=QM_Stream_PercentageChange("AAPL")=QM_Stream_PercentageChange("MSFT")=QM_Stream_PercentageChange("SPY")=TEXT(QM_Stream_PercentageChange("AAPL"),"0.00%")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
Why is the percentage showing as 0 before market open?
Before trading starts, there's no change from the previous close.
How do I format this as a percentage?
Use =TEXT(QM_Stream_PercentageChange("AAPL")/100,"0.00%") or format the cell as percentage.
Why am I getting #N/A?
Check that symbol format is correct.
Excel Templates Using Stream Percentage Change
These ready-made MarketXLS templates call QM_Stream_PercentageChange() 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:
- Stream Percentage Change
- Stream Post Market Change
- Stream Post Market Change
- Stream Post Market Last
- Stream Post Market Last Price
- Stream Post Market Last Trade Time
- Stream Post Market Last Trade Time
- Stream Post Market Percent Change
See QM_Stream_PercentageChange used in a complete workbook: Stock Market Data MCP Connector: Live Prices in Excel and AI
Get Access to 1 Billion Usable Market data points IN YOUR EXCEL SHEETS WITH EASY TO USE EXCEL FUNCTIONS
Get started today