Returns the mid price (average of bid and ask) for a symbol

Returns the historical ask price for a symbol on a specific date

Returns the historical mid price (average of bid and ask) for a stock on a specific past date, useful for analyzing historical trading conditions.

Use when user asks for:
- "What was the mid price on January 15th?"
- "Show the historical bid-ask midpoint"
- "Get the average of bid and ask for a past date"

Do NOT use when:
- User wants current real-time mid price -> use MidPrice()
- User wants historical ask price only -> use Ask_Historical()
- User wants historical closing price -> use Close_Historical()

# Mid Historical

Returns the mid price (avg of bid/ask) on a historical date.

Mid Historical

Examples

When to Use

When NOT to Use

Get Access to 1 Billion Usable Market data points IN YOUR EXCEL SHEETS WITH EASY TO USE EXCEL FUNCTIONS

Related Functions