Adjusted Close (Year End)
Returns the adjusted closing price for a stock or ETF on the last trading day of the specified year (Dec 31, adjusted for weekends/holidays). Accounts for stock splits and dividend distributions.
Notes
- Uses Dec 31 as target, auto-adjusts to last actual trading day
- Only requires Symbol and Year parameters
Syntax
=Adjusted_Close_YearEnd(Symbol, Year)Parameters
SymbolstringRequired
Stock or ETF ticker symbol
YearintegerRequired
The year (e.g., 2025)
Returns
number
Split and dividend adjusted closing price on the last trading day of the specified year
Examples
=Adjusted_Close_YearEnd("AAPL", 2024)=Adjusted_Close_YearEnd("MSFT", 2023)Annual total return:
=(Adjusted_Close_YearEnd("AAPL",2024)-Adjusted_Close_YearEnd("AAPL",2023))/Adjusted_Close_YearEnd("AAPL",2023)When to Use
- Annual total return calculations
- Multi-year performance analysis
- Tax year-end valuations accounting for splits
- CAGR calculations
When NOT to Use
\
Common Issues & FAQ
The adjusted close for 2020 keeps changing.?
Yes — each new dividend or split recalculates all historical adjusted prices. Query the value when you need it and store the result.
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?