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
Examples
=QM_RawBidSize("AAPL")=QM_RawBidSize("SPY")=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
Q: What's the difference between raw and regular bid size? A: Raw shows actual shares. Regular may be normalized to lots (100 shares). Raw bid size of 800 means 800 shares, not 8 lots.
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.
Q: Why use raw instead of regular? A: 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?