Percent Change (On Demand)
Gets the percentage change on-demand (snapshot) from QuoteMedia. This is the percentage difference between the current price and the previous close.
Supported Symbol Formats
| Type | Format | Example |
|---|---|---|
| US Stocks | SYMBOL | AAPL, MSFT |
| ETFs | SYMBOL | SPY, QQQ |
| Indices | ^SYMBOL | ^SPX, ^VIX |
Notes
- Returns a snapshot (does not auto-update)
- Positive = stock is up; Negative = stock is down
- Formula: (Last - PreviousClose) / PreviousClose * 100
Examples
=QM_ChangePercent("AAPL")=QM_ChangePercent("MSFT")=QM_ChangePercent("SPY")=QM_ChangePercent(A1)When to Use
- Static performance reports
- Comparing relative moves across stocks
- When streaming is not needed
- Snapshot reports
When NOT to Use
| Scenario | Use Instead |
|---|---|
| Need streaming percent change | QM_Stream_PercentageChange() |
| Need dollar change | QM_Change() |
| Need streaming dollar change | QM_Stream_Change() |
Common Issues & FAQ
Q: Why doesn't the percentage update automatically?
A: This is an on-demand function. Use QM_Stream_PercentageChange() for auto-updating.
Q: How do I get dollar change instead?
A: Use QM_Change() for on-demand or QM_Stream_Change() for streaming.
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
▶
How does MarketXLS work?