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)Parameters
Stock or ETF ticker symbol
The year (e.g., 2025)
Quarter number: 1 (Mar 31), 2 (Jun 30), 3 (Sep 30), or 4 (Dec 31)
Returns
Closing price on the last trading day of the specified 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.
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