Volume (Month End)
Returns the trading volume for a stock or ETF on the last trading day of the specified month.
Validation
- Month must be 1-12
Syntax
=Volume_MonthEnd(Symbol, Year, Month)Parameters
SymbolstringRequired
Stock or ETF ticker symbol
YearintegerRequired
The year (e.g., 2025)
MonthintegerRequired
Month number: 1-12
Returns
number
Trading volume on the last trading day of the specified month
Examples
=Volume_MonthEnd("AAPL", 2025, 6)=Volume_MonthEnd("MSFT", 2025, 12)When to Use
- Month-end volume analysis
- Identifying rebalancing patterns
- Liquidity checks on specific dates
When NOT to Use
\
Common Issues & FAQ
I'm getting "Invalid Month. Use 1-12."?
Month must be between 1 and 12.
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?