High Price (Year End)
Returns the intraday high price for a stock or ETF on the last trading day of the specified year (Dec 31, adjusted for weekends/holidays).
Syntax
=High_YearEnd(Symbol, Year)Examples
=High_YearEnd("AAPL", 2024)=High_YearEnd("MSFT", 2023)When to Use
- Year-end intraday range analysis
- Complete OHLCV at year-end
When NOT to Use
\
Common Issues & FAQ
This isn't the year's highest price?
Correct — it's the daily high on the year's last trading day only.
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?