Bid Size

Returns the bid size (number of shares buyers want at the current bid price) using QuoteMedia's on-demand data service.

What is Bid Size?

Bid size represents the number of shares that buyers are willing to purchase at the current bid price. It indicates buy-side demand at the best bid.

Supported Symbol Formats

Type Format Example
US Stocks SYMBOL AAPL, MSFT
ETFs SYMBOL SPY, QQQ

Parameters

Parameter Type Required Description
Symbol String Yes Stock ticker symbol

Notes

  • Shows buy-side demand at best bid
  • May be normalized to lots (100 shares)
  • Useful for order flow analysis

Examples

=QM_BidSize("AAPL")
Bid size for Apple
=QM_BidSize("SPY")
Bid size for SPY
=QM_BidSize(A1)
Symbol from cell reference

When to Use

  • Analyze buy-side demand
  • Order flow analysis
  • Market depth assessment
  • Trading execution planning

When NOT to Use

Scenario Use Instead
Need streaming data QM_Stream_BidSize()
Need raw (unnormalized) size QM_RawBidSize()
Need ask size QM_RawAskSize()

Common Issues & FAQ

Q: What does a large bid size indicate? A: Large bid size suggests strong buy-side demand at the current bid. It may indicate support at that price level.

Q: Is this the same as QM_RawBidSize? A: They may differ in normalization. Raw typically shows actual shares; regular may be in lots (100s).

Q: Why is bid size important? A: Understanding bid size helps assess how much selling pressure is needed to move the price down.

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 Size and Other Financial Formulas
How does MarketXLS work?