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)

Excel Desktop (Windows)

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

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.

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?