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

Examples

=QM_Stream_PreMarketPercentChange("AAPL")
Stream pre-market % change for Apple
=QM_Stream_PreMarketPercentChange("MSFT")
Stream pre-market % change for Microsoft
=QM_Stream_PreMarketPercentChange("TSLA")
Stream pre-market % change for Tesla
=QM_Stream_PreMarketPercentChange(A1)
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

Q: Why is the percentage showing 0? A: Pre-market data is only available during extended hours (4:00 AM - 9:30 AM ET).

Q: What is the change calculated from? A: Pre-market percent change is calculated from the previous day's closing price.

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

Related Functions