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
Syntax
=QM_Stream_Last(Symbol)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
Why isn't the price updating?
Check that RTD is enabled in Excel and .
Why is the price different from other sources?
Real-time prices may differ by milliseconds from other data providers.
Why am I getting #N/A?
Check that symbol format is correct.
Excel Templates Using Stream Last Price
These ready-made MarketXLS templates call QM_Stream_Last() in their worksheet formulas. Open one to see the function working inside a complete model.
- Forecasting the Index Level for the Upcoming Four Days
- Template for Accessing Real-Time Data on US Stock Option Bids, Greeks, Open Interest, and Unusual Op
- ^SPX Real time Option Chain with SPXW
- Option Chain Excel Sheet (SPY Example)
- MarketPulse Dashboard
- NASDAQ 100 Movement Tracker: Insight on Advancers and Decliners
- Portfolio Tracker Excel Spreadsheet
- Gamma Exposure (GEX) Template
Related Formulas
More MarketXLS Price Quotes (Streaming) formulas you can use in the same worksheet:
- Stream Last Trade Excode
- Stream Last Trade Size
- Stream Last Trade Size
- Stream Last Trade Time
- Stream Last Trade Time
- Stream Low
- Stream Mark
- Stream Mark Change
See QM_Stream_Last used in a complete workbook: Real Time Option Data in Excel: The Ultimate Guide to Live Options Streaming
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?