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
Syntax
=MidPrice(Symbol)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
Why is mid price different from last price?
Mid price is the average of bid/ask, while last price is the most recent trade. They can differ based on where trades execute.
When is mid price most useful?
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?