Stream Pre Market Volume
Streams the real-time trading volume 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
- Pre-market volume is typically lower than regular session volume
Syntax
=QM_Stream_PreMarketVolume(Symbol)Returns
number
Real-time streaming pre-market trading volume
Examples
=QM_Stream_PreMarketVolume("AAPL")=QM_Stream_PreMarketVolume("MSFT")=QM_Stream_PreMarketVolume("TSLA")Symbol from cell reference
When to Use
- Pre-market activity monitoring
- Earnings announcement analysis
- Early morning liquidity assessment
- Overnight news impact evaluation
When NOT to Use
| Scenario | Use Instead |
|---|---|
| Need regular session volume | QM_Stream_Volume() |
| Need post-market volume | QM_Stream_PostMarketVolume() |
| Need total accumulated volume | QM_Stream_AccumulatedVolume() |
| Need average daily volume | AverageDailyVolume() |
Common Issues & FAQ
Why is pre-market volume so low?
Pre-market trading has lower participation than regular hours, so lower volume is expected.
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 Volume
- Stream Previous Close
- Stream Previous Close
- Stream Previous Mark
- Stream Price Change
- Stream Rho
- Stream Theta
- Stream Timestamp
See QM_Stream_PreMarketVolume 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?