Raw Bid Size
Returns the raw bid size (actual number of shares wanted 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.
Raw vs Normalized
| Type | Description |
|---|---|
| Raw | Actual number of shares |
| Normalized | May be in lots (100 shares) |
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 actual share count at bid
- Not normalized to lots
- Useful for precise market depth analysis
Syntax
=mxls.QM_RawBidSize(Symbol)Examples
=mxls.QM_RawBidSize("AAPL")=mxls.QM_RawBidSize("SPY")=mxls.QM_RawBidSize(A1)When to Use
- Precise market depth analysis
- Order flow analysis
- Execution planning
- Understanding exact demand
When NOT to Use
| Scenario | Use Instead |
|---|---|
| Need streaming data | QM_Stream_BidSize() |
| Need ask size | QM_RawAskSize() |
| Need normalized size | QM_BidSize() |
Common Issues & FAQ
What's the difference between raw and regular bid size?
Raw shows actual shares. Regular may be normalized to lots (100 shares). Raw bid size of 800 means 800 shares, not 8 lots.
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.
Why use raw instead of regular?
Use raw when you need the actual share count for precise calculations or analysis.
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?