Close Price (Quarter End)
Returns the closing price for a stock or ETF on the last trading day of the specified quarter. If the last calendar day of the quarter falls on a weekend or holiday, the function automatically uses the nearest prior trading day.
Quarter Mapping
| Quarter | End Date | Last Month |
|---|---|---|
| 1 | March 31 | March |
| 2 | June 30 | June |
| 3 | September 30 | September |
| 4 | December 31 | December |
Auto-Adjustment
The /Yes flag in the API call means: if the computed date (e.g., Dec 31) falls on a weekend or holiday, automatically return the price from the nearest prior trading day.
Validation
- Quarter must be 1, 2, 3, or 4
- Returns "Invalid Quarter. Use 1-4." for out-of-range values
Syntax
=Close_QuarterEnd(Symbol, Year, Quarter)Examples
=Close_QuarterEnd("AAPL", 2025, 4)=Close_QuarterEnd("MSFT", 2025, 2)=Close_QuarterEnd("SPY", 2024, 1)=Close_QuarterEnd(A1, B1, C1)When to Use
- Quarterly performance reporting
- Calculating quarter-over-quarter returns
- Building periodic return tables
- Marking portfolio values at quarter end
When NOT to Use
\
Common Issues & FAQ
I'm getting "Invalid Quarter. Use 1-4."?
The Quarter parameter must be 1, 2, 3, or 4.
The price doesn't match what I see for Dec 31.?
If Dec 31 is a weekend/holiday, the function returns the prior trading day's close. This is by design.
Should I use this or Adjusted_Close_QuarterEnd?
Use Adjusted_Close for return calculations over periods with stock splits or dividends. Use Close for actual traded prices.
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?