Open Price (Quarter End)
Returns the opening price for a stock or ETF on the last trading day of the specified quarter. Automatically adjusts for weekends/holidays.
Validation
- Quarter must be 1-4
Syntax
=Open_QuarterEnd(Symbol, Year, Quarter)Parameters
SymbolstringRequired
Stock or ETF ticker symbol
YearintegerRequired
The year (e.g., 2025)
QuarterintegerRequired
Quarter number: 1-4
Returns
number
Opening price on the last trading day of the specified quarter
Examples
=Open_QuarterEnd("AAPL", 2025, 4)=Open_QuarterEnd("MSFT", 2024, 1)Intraday range on quarter-end:
=High_QuarterEnd("AAPL",2025,4)-Low_QuarterEnd("AAPL",2025,4)When to Use
- Analyzing quarter-end trading day price action
- Calculating open-to-close returns on quarter-end days
- Identifying gap-ups/downs at quarter-end
When NOT to Use
\
Common Issues & FAQ
I'm getting "Invalid Quarter. Use 1-4."?
Quarter must be 1, 2, 3, or 4.
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?