Stream Bid Price
Streams the real-time bid price for stocks, ETFs, indices, and options. The bid price is the highest price at which buyers are willing to buy.
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
- Bid price represents the highest offer in the order book
- Use with
QM_Stream_Ask()to calculate bid-ask spread
Examples
=QM_Stream_Bid("AAPL")=QM_Stream_Bid("MSFT")=QM_Stream_Bid("SPY")=QM_Stream_Bid(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 bid price | QM_Bid() |
| Need ask price | QM_Stream_Ask() |
| Need historical bid | Bid_Historical() |
| Need last traded price | QM_Stream_Last() |
Common Issues & FAQ
Q: Why is the bid lower than the last price? A: The bid represents what buyers are willing to pay, which can be below the last traded price, especially in volatile markets.
Q: Why am I getting #N/A? A: Check that symbol format is correct.
Q: How do I calculate the spread percentage?
A: Use =(QM_Stream_Ask("AAPL")-QM_Stream_Bid("AAPL"))/QM_Stream_Bid("AAPL")*100.
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?