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)Parameters
SymbolstringRequired
Stock or ETF ticker symbol
YearintegerRequired
The year (e.g., 2025)
QuarterintegerRequired
Quarter number: 1-4
Returns
number
Intraday high price on the last trading day of the specified 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.
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?