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)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.
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?