Stream Ask Price
Streams the real-time ask (offer) price for stocks, ETFs, indices, and options. The ask price is the lowest price at which sellers are willing to sell.
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
- Ask price represents the lowest offer in the order book
- Use with
QM_Stream_Bid()to calculate bid-ask spread
Examples
=QM_Stream_Ask("AAPL")=QM_Stream_Ask("MSFT")=QM_Stream_Ask("SPY")=QM_Stream_Ask(A1)=QM_Stream_Ask("AAPL")-QM_Stream_Bid("AAPL")When to Use
- Real-time order book monitoring
- Calculating live bid-ask spreads
- Building streaming quote dashboards
- Trading decision support
When NOT to Use
| Scenario | Use Instead |
|---|---|
| Need on-demand ask price | QM_Ask() |
| Need bid price | QM_Stream_Bid() |
| Need historical ask | Ask_Historical() |
| Need last traded price | QM_Stream_Last() |
Common Issues & FAQ
Q: Why is the ask price the same as the last price? A: During low liquidity periods or for highly liquid stocks, bid/ask/last can be very close or identical.
Q: Why am I getting #N/A? A: Check that symbol format is correct.
Q: How do I calculate the spread?
A: Use =QM_Stream_Ask("AAPL")-QM_Stream_Bid("AAPL") for the dollar spread.
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?