Mid Price
Returns the mid price, calculated as the average of the current bid and ask prices. The mid price is often used as an estimate of fair value for a security.
Parameters
| Parameter | Type | Required | Description |
|---|---|---|---|
| Symbol | string | Yes | Stock ticker symbol |
Calculation
Mid Price = (Bid + Ask) / 2
Notes
- Useful for estimating fair value
- More accurate than last price for illiquid securities
- Common in options pricing
Examples
When to Use
- Estimating fair value for securities
- Options pricing calculations
- Illiquid securities valuation
- Spread analysis
- Order execution benchmarking
When NOT to Use
| Scenario | Use Instead |
|---|---|
| Need bid price only | Bid() |
| Need ask price only | Ask() |
| Need last traded price | Last() |
| Need historical mid price | Mid_Historical() |
Common Issues & FAQ
Q: Why is mid price different from last price? A: Mid price is the average of bid/ask, while last price is the most recent trade. They can differ based on where trades execute.
Q: When is mid price most useful? A: Mid price is most useful for illiquid securities where the bid-ask spread is wide and last price may not reflect current value.
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?