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

Examples

=QM_Bid("AAPL")
Bid price for Apple
=QM_Bid("MSFT")
Bid price for Microsoft
=QM_Bid("SPY")
Bid price for SPY ETF
=QM_Bid(A1)
Symbol from cell reference
=QM_Ask("AAPL")-QM_Bid("AAPL")
Calculate spread

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

Q: How do I calculate the bid-ask spread? A: Use =QM_Ask("AAPL")-QM_Bid("AAPL").

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.

Q: Why am I getting #N/A? A: Check that symbol format is correct.

Get Access to 1 Billion Usable Market data points IN YOUR EXCEL SHEETS WITH EASY TO USE EXCEL FUNCTIONS

Get started today
MarketXLS Excel Add-in Tutorial - How to Use Bid Price (On Demand) and Other Financial Formulas
▶
How does MarketXLS work?

Related Functions