Stream Ask Size
Returns the real-time streaming ask size (number of shares available at the current ask price) using QuoteMedia's streaming data service.
What is Ask Size?
Ask size represents the number of shares that sellers are offering at the current ask (offer) price. It indicates sell-side liquidity at the best offer.
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
- Real-time streaming data
- Updates automatically
- Shows sell-side supply at best ask
Examples
=QM_Stream_AskSize("AAPL")=QM_Stream_AskSize("SPY")=QM_Stream_AskSize(A1)When to Use
- Real-time order flow analysis
- Live market depth monitoring
- Trading dashboards
- Execution planning
When NOT to Use
| Scenario | Use Instead |
|---|---|
| Don't need streaming | QM_RawAskSize() |
| Need bid size | QM_Stream_BidSize() |
| Need full depth | Level 2 data functions |
Common Issues & FAQ
Q: What does a large ask size indicate? A: Large ask size suggests significant sell-side supply at the current ask. It may indicate resistance at that price.
Q: How often does this update? A: Real-time streaming - updates continuously during market hours as the order book changes.
Q: Why compare ask size to bid size? A: Comparing sizes helps gauge supply/demand imbalance. Larger ask than bid may indicate selling pressure.
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?