Historical High Price
Returns the highest traded price for a stock on a specific historical date. This represents the intraday high for that trading session.
Parameters
| Parameter | Type | Required | Description |
|---|---|---|---|
| Symbol | string | Yes | Stock ticker symbol |
| OnDate | date | Yes | The historical date |
Date Format
The date can be provided as:
- Excel DATE function:
DATE(2024,1,15) - Cell reference containing a date
- Date serial number
Supported Symbol Formats
| Type | Format | Example |
|---|---|---|
| US Stocks | SYMBOL | AAPL, MSFT |
| ETFs | SYMBOL | SPY, QQQ |
| Indices | ^SYMBOL | ^SPX, ^DJI |
Notes
- Returns "NA" if market was closed (weekend, holiday)
- Represents the highest price reached during trading hours
Examples
=High_Historical("AAPL",DATE(2024,1,15))=High_Historical("TSLA",DATE(2024,1,2))=High_Historical("SPY",DATE(2023,12,29))=High_Historical("AAPL",A1)=High_Historical(B1,A1)When to Use
- Analyzing historical volatility (high-low range)
- Building candlestick charts
- Identifying support/resistance levels
- Backtesting trading strategies
When NOT to Use
| Scenario | Use Instead |
|---|---|
| Need current day's high | High() |
| Need 52-week high | x_week_high() |
| Need opening price | Open_Historical() |
| Need closing price | Close_Historical() |
Common Issues & FAQ
Q: Why am I getting "NA"? A: The market was likely closed on that date (weekend, holiday) or the date is before the stock was listed.
Q: How do I calculate the daily range?
A: Use: =High_Historical("AAPL",DATE(2024,1,15))-Low_Historical("AAPL",DATE(2024,1,15))
Q: How do I format the date?
A: Use Excel's DATE function: DATE(year,month,day) - e.g., DATE(2024,1,15) for January 15, 2024.
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?