Price Change (On Demand)
Gets the price change in dollars on-demand (snapshot) from QuoteMedia. This is the 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
- Change = Last - PreviousClose
Syntax
=QM_Change(Symbol)Returns
number
Price change in dollars (on-demand snapshot)
Examples
When to Use
- Static gain/loss reports
- One-time change lookups
- When streaming is not needed
- Snapshot reports
When NOT to Use
| Scenario | Use Instead |
|---|---|
| Need streaming change | QM_Stream_Change() |
| Need percentage change | QM_ChangePercent() |
| Need streaming percent change | QM_Stream_PercentageChange() |
Common Issues & FAQ
Why doesn't the change update automatically?
This is an on-demand function. Use QM_Stream_Change() for auto-updating.
How do I get percentage change instead?
Use QM_ChangePercent() for on-demand or QM_Stream_PercentageChange() for streaming.
Why am I getting #N/A?
Check that symbol format is correct.
Excel Templates Using Price Change (On Demand)
These ready-made MarketXLS templates call QM_Change() in their worksheet formulas. Open one to see the function working inside a complete model.
Related Formulas
More MarketXLS Price Quotes formulas you can use in the same worksheet:
- Price Range Current Day
- QM Ask Size
- QM Get Recent Option Stats Dynamic
- Quote DateTime (On Demand)
- Raw Ask Size
- Raw Bid Size
- Share Volume
- Strike (On Demand)
See QM_Change used in a complete workbook: Best Excel Add-in for Stock Data: Top 8 Plugins for Real-Time Market Analysis (2026)
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?