Stream Pre Market Change

Streams the real-time price change in dollars during pre-market (before hours) trading. Pre-market hours are typically 4:00 AM - 9:30 AM ET.

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
  • Change is calculated from the previous day's close

Examples

=QM_Stream_PreMarketChange("AAPL")
Stream pre-market change for Apple
=QM_Stream_PreMarketChange("MSFT")
Stream pre-market change for Microsoft
=QM_Stream_PreMarketChange("TSLA")
Stream pre-market change for Tesla
=QM_Stream_PreMarketChange(A1)
Symbol from cell reference

When to Use

  • Pre-market monitoring
  • Overnight news reaction assessment
  • Early morning trading preparation
  • Gap analysis before market open

When NOT to Use

Scenario Use Instead
Need regular session change QM_Stream_Change()
Need pre-market percent change QM_Stream_PreMarketPercentChange()
Need post-market change QM_Stream_PostMarketChange()
Need pre-market price QM_Stream_PreMarketLast()

Common Issues & FAQ

Q: Why is the pre-market change 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 change is calculated from the previous day's closing price.

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
MarketXLS Excel Add-in Tutorial - How to Use Stream Pre Market Change and Other Financial Formulas
▶
How does MarketXLS work?

Related Functions