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
Syntax
=mxls.QM_BidSize(Symbol)Returns
number
Bid size (number of shares at bid)
Examples
=mxls.QM_BidSize("AAPL")=mxls.QM_BidSize("SPY")=mxls.QM_BidSize(A1)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
What does a large bid size indicate?
Large bid size suggests strong buy-side demand at the current bid. It may indicate support at that price level.
Is this the same as QM_RawBidSize?
They may differ in normalization. Raw typically shows actual shares; regular may be in lots (100s).
Why is bid size important?
Understanding bid size helps assess how much selling pressure is needed to move the price down.
Related Formulas
More MarketXLS Price Quotes formulas you can use in the same worksheet:
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?