Stream Last Price
Streams the real-time last traded price for stocks, ETFs, indices, and options. This is the primary function for building live dashboards and watchlists.
Supported Symbol Formats
| Type | Format | Example |
|---|---|---|
| US Stocks | SYMBOL | AAPL, MSFT |
| ETFs | SYMBOL | SPY, QQQ |
| Indices | ^SYMBOL | ^SPX, ^VIX |
| Options | OCC Symbol | AAPL240315C00170000 |
Notes
- Data streams automatically update in Excel via RTD
- Most commonly used streaming function
- Updates continuously during market hours
Examples
=QM_Stream_Last("AAPL")=QM_Stream_Last("MSFT")=QM_Stream_Last("^SPX")=QM_Stream_Last("SPY")=QM_Stream_Last(A1)When to Use
- Building real-time dashboards
- Live watchlists
- Streaming portfolio tracking
- Real-time price alerts
When NOT to Use
| Scenario | Use Instead |
|---|---|
| Need on-demand price | Last() or QM_Last() |
| Need historical price | Close_Historical() |
| Need pre-market price | QM_Stream_PreMarketLast() |
| Need post-market price | QM_Stream_PostMarketLast() |
Common Issues & FAQ
Q: Why isn't the price updating? A: Check that RTD is enabled in Excel and .
Q: Why is the price different from other sources? A: Real-time prices may differ by milliseconds from other data providers.
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
▶
How does MarketXLS work?