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
Syntax
=QM_Stream_Bid(Symbol)Returns
Real-time streaming bid price
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
Why is the bid lower than the last price?
The bid represents what buyers are willing to pay, which can be below the last traded price, especially in volatile markets.
Why am I getting #N/A?
Check that symbol format is correct.
How do I calculate the spread percentage?
Use =(QM_Stream_Ask("AAPL")-QM_Stream_Bid("AAPL"))/QM_Stream_Bid("AAPL")*100.
Excel Templates Using Stream Bid Price
These ready-made MarketXLS templates call QM_Stream_Bid() in their worksheet formulas. Open one to see the function working inside a complete model.
- NDX100 Options Matrix: Comprehensive Risk-Weighted Analysis for Optimal Option Selection across All
- Option Chain Matrix
- Options Rollover Strategy Example Template
- Template for Accessing Real-Time Data on US Stock Option Bids, Greeks, Open Interest, and Unusual Op
- Portfolio Management (RBSandiego)
- Portfolio Tracker Excel Spreadsheet
- ^SPX Real time Option Chain with SPXW
- Option Chain Excel Sheet (SPY Example)
Related Formulas
More MarketXLS Price Quotes (Streaming) formulas you can use in the same worksheet:
- Stream Bid Price
- Stream Bid Size
- Stream Bid Size
- Stream Change
- Stream Close
- Stream Close Price
- Stream Currency Id
- Stream Data from QM Data Bundles
See QM_Stream_Bid used in a complete workbook: Real Time Futures Prices in Excel: Live Streaming Data with MarketXLS 2025
Get Access to 1 Billion Usable Market data points IN YOUR EXCEL SHEETS WITH EASY TO USE EXCEL FUNCTIONS
Get started today