Stream Pre Market Percent Change
Streams the real-time percentage change during pre-market (before hours) trading. The change is calculated from the previous day's closing price.
Supported Symbol Formats
| Type | Format | Example |
|---|---|---|
| US Stocks | SYMBOL | AAPL, MSFT |
| ETFs | SYMBOL | SPY, QQQ |
Notes
- Data streams automatically update in Excel
- Pre-market hours: 4:00 AM - 9:30 AM ET
- Formula: (PreMarketLast - PreviousClose) / PreviousClose * 100
Syntax
=QM_Stream_PreMarketPercentChange(Symbol)Returns
number
Real-time streaming pre-market percentage change
Examples
=QM_Stream_PreMarketPercentChange("AAPL")=QM_Stream_PreMarketPercentChange("MSFT")=QM_Stream_PreMarketPercentChange("TSLA")Symbol from cell reference
When to Use
- Pre-market performance assessment
- Overnight news impact analysis
- Early morning trading decisions
- Gap analysis before market open
When NOT to Use
| Scenario | Use Instead |
|---|---|
| Need regular session percent change | QM_Stream_PercentageChange() |
| Need pre-market dollar change | QM_Stream_PreMarketChange() |
| Need post-market percent change | QM_Stream_PostMarketPercentChange() |
| Need pre-market price | QM_Stream_PreMarketLast() |
Common Issues & FAQ
Why is the percentage showing 0?
Pre-market data is only available during extended hours (4:00 AM - 9:30 AM ET).
What is the change calculated from?
Pre-market percent change is calculated from the previous day's closing price.
Related Formulas
More MarketXLS Price Quotes (Streaming) formulas you can use in the same worksheet:
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?