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
Syntax
=QM_Stream_PreMarketLast(Symbol)Returns
number
Real-time streaming pre-market last traded price
Examples
=QM_Stream_PreMarketLast("AAPL")=QM_Stream_PreMarketLast("MSFT")=QM_Stream_PreMarketLast("TSLA")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
Why is the pre-market price showing the previous close?
If no pre-market trading has occurred, the price may show the previous close.
When is pre-market data available?
Pre-market hours are typically 4:00 AM - 9:30 AM ET.
Related Formulas
More MarketXLS Price Quotes (Streaming) formulas you can use in the same worksheet:
- Stream Pre Market Percent Change
- Stream Pre Market Trade Time
- Stream Pre Market Trade Time
- Stream Pre Market Volume
- Stream Previous Close
- Stream Previous Close
- Stream Previous Mark
- Stream Price Change
See QM_Stream_PreMarketLast used in a complete workbook: How to Insert Stock Price in Excel for Real-Time Quotes
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?