High Price (Quarter End)
Returns the intraday high price for a stock or ETF on the last trading day of the specified quarter.
Important Distinction
This is the daily high on the last trading day of the quarter — NOT the highest price during the entire quarter. For the quarter's overall high, use GetHistory() and find the maximum.
Validation
- Quarter must be 1-4
Syntax
=High_QuarterEnd(Symbol, Year, Quarter)Examples
=High_QuarterEnd("AAPL", 2025, 4)=High_QuarterEnd("MSFT", 2024, 1)Daily range on quarter-end:
=High_QuarterEnd("AAPL",2025,4)-Low_QuarterEnd("AAPL",2025,4)When to Use
- Analyzing intraday volatility on quarter-end days
- Calculating daily range on quarter-end trading days
- Complete OHLCV picture at quarter-end
When NOT to Use
\
Common Issues & FAQ
This isn't the quarter's highest price?
Correct — it's the daily high on the quarter's LAST trading day, not the max price over the whole quarter.
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?