Stream Pre Market Last Price

Streams the real-time last traded price 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
  • Important for assessing overnight news impact

Examples

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

When to Use

  • Pre-market monitoring
  • Overnight gap assessment
  • Early morning trading preparation
  • Earnings reaction tracking

When NOT to Use

Scenario Use Instead
Need regular session price QM_Stream_Last()
Need post-market price QM_Stream_PostMarketLast()
Need pre-market change QM_Stream_PreMarketChange()
Need pre-market volume QM_Stream_PreMarketVolume()

Common Issues & FAQ

Q: Why is the pre-market price showing the previous close? A: If no pre-market trading has occurred, the price may show the previous close.

Q: When is pre-market data available? A: Pre-market hours are typically 4:00 AM - 9:30 AM ET.

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 Last Price and Other Financial Formulas
▶
How does MarketXLS work?

Related Functions