Adjusted Close (Quarter End)
Returns the adjusted closing price for a stock or ETF on the last trading day of the specified quarter. The adjusted close accounts for stock splits and dividend distributions, making it the correct price to use for calculating total returns over time.
When to Use Adjusted vs. Raw Close
| Use Case | Function |
|---|---|
| Return calculations | Adjusted_Close_QuarterEnd |
| Actual traded price | Close_QuarterEnd |
| Portfolio mark-to-market | Close_QuarterEnd |
| Performance attribution | Adjusted_Close_QuarterEnd |
Validation
- Quarter must be 1-4
- Returns "Invalid Quarter. Use 1-4." for out-of-range values
Syntax
=Adjusted_Close_QuarterEnd(Symbol, Year, Quarter)Examples
=Adjusted_Close_QuarterEnd("AAPL", 2025, 4)=Adjusted_Close_QuarterEnd("MSFT", 2024, 2)Quarterly total return:
=(Adjusted_Close_QuarterEnd("AAPL",2025,4)-Adjusted_Close_QuarterEnd("AAPL",2025,3))/Adjusted_Close_QuarterEnd("AAPL",2025,3)When to Use
- Calculating total returns (price + dividends) across quarters
- Performance comparison across stocks with different split histories
- Building return series for backtesting
- Any analysis where splits/dividends would distort raw prices
When NOT to Use
\
Common Issues & FAQ
Why is the adjusted close different from the regular close?
Adjusted close accounts for stock splits and dividend payments. If a stock split 2:1, all historical adjusted prices are halved. Dividends also reduce adjusted prices retroactively.
The adjusted close keeps changing for the same date.?
Yes — adjusted close is retroactively recalculated whenever a new dividend is paid or split occurs. This is expected behavior.
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?