Open Price (Month End)
Returns the opening price for a stock or ETF on the last trading day of the specified month. Automatically adjusts for weekends/holidays and handles varying month lengths including leap years.
Validation
- Month must be 1-12
Syntax
=Open_MonthEnd(Symbol, Year, Month)Examples
=Open_MonthEnd("AAPL", 2025, 6)=Open_MonthEnd("MSFT", 2025, 2)=Open_MonthEnd(A1, B1, C1)When to Use
- Month-end trading day analysis
- Open-to-close calculations on month-end days
- Identifying overnight gaps at month transitions
When NOT to Use
\
Common Issues & FAQ
I'm getting "Invalid Month. Use 1-12."?
Month must be between 1 and 12.
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?