Mid Historical
Returns the mid price (avg of bid/ask) on a historical date.
Syntax
=Mid_Historical(Symbol, OnDate)Parameters
symbolstringRequired
onDatedateRequired
Examples
=Mid_Historical("AAPL", DATE(2024,1,15))When to Use
- Historical fair value
- Backtesting
When NOT to Use
| Scenario | Use Instead |
|---|---|
| Current mid | MidPrice() |
Related Formulas
More MarketXLS Price History formulas you can use in the same worksheet:
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?