Bid Price (On Demand)
Gets the current bid price on-demand (snapshot) from QuoteMedia. The bid is the highest price buyers are willing to pay.
Supported Symbol Formats
| Type | Format | Example |
|---|---|---|
| US Stocks | SYMBOL | AAPL, MSFT |
| ETFs | SYMBOL | SPY, QQQ |
| Options | OCC Symbol | AAPL240315C00170000 |
Notes
- Returns a snapshot (does not auto-update)
- Bid represents the highest offer from buyers
- Use with
QM_Ask()to calculate spread
Syntax
=QM_Bid(Symbol)Returns
number
Bid price (on-demand snapshot)
Examples
=QM_Bid("AAPL")=QM_Bid("MSFT")=QM_Bid("SPY")=QM_Bid(A1)=QM_Ask("AAPL")-QM_Bid("AAPL")When to Use
- Order book analysis
- Spread calculations
- When streaming is not needed
- Static quote snapshots
When NOT to Use
| Scenario | Use Instead |
|---|---|
| Need streaming bid | QM_Stream_Bid() |
| Need ask price | QM_Ask() |
| Need last price | QM_Last() |
Common Issues & FAQ
How do I calculate the bid-ask spread?
Use =QM_Ask("AAPL")-QM_Bid("AAPL").
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.
Why am I getting #N/A?
Check that symbol format is correct.
Excel Templates Using Bid Price (On Demand)
These ready-made MarketXLS templates call QM_Bid() in their worksheet formulas. Open one to see the function working inside a complete model.
Related Formulas
More MarketXLS Price Quotes formulas you can use in the same worksheet:
- Bid Size
- Book Value
- Call/Put Flag (On Demand)
- Change % From Previous Close
- Change Percent YTD
- Change Value From Previous Close
- Company Name
- Contract High (On Demand)
See QM_Bid used in a complete workbook: Option Price in Excel: Pull Live Options Data, Greeks & Pricing Models into Your Spreadsheet
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?