Adjusted Close (Month End)
Returns the adjusted closing price for a stock or ETF on the last trading day of the specified month. Accounts for stock splits and dividend distributions.
Validation
- Month must be 1-12
- Returns "Invalid Month. Use 1-12." for out-of-range values
- Correctly handles leap years (Feb 28 vs 29)
Syntax
=Adjusted_Close_MonthEnd(Symbol, Year, Month)Examples
=Adjusted_Close_MonthEnd("AAPL", 2025, 6)=Adjusted_Close_MonthEnd("MSFT", 2025, 12)Monthly return:
=(Adjusted_Close_MonthEnd("AAPL",2025,6)-Adjusted_Close_MonthEnd("AAPL",2025,5))/Adjusted_Close_MonthEnd("AAPL",2025,5)When to Use
- Monthly total return calculations
- Building monthly return series for analysis
- Performance attribution at month-end
- Comparing returns across securities with splits
When NOT to Use
\
Common Issues & FAQ
Why does the adjusted close for January change after a March dividend?
Adjusted prices are retroactively recalculated with each new corporate action. This is standard behavior across all financial data providers.
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?