Volume (Year End)
Returns the trading volume for a stock or ETF on the last trading day of the specified year (Dec 31, adjusted for weekends/holidays). Year-end trading days often have lower-than-average volume due to the holiday period.
Notes
- Year-end volume is typically below average due to holiday trading
- Tax-loss harvesting can cause unusual volume in late December
Syntax
=Volume_YearEnd(Symbol, Year)Examples
=Volume_YearEnd("AAPL", 2024)=Volume_YearEnd("MSFT", 2023)=Volume_YearEnd("SPY", 2025)When to Use
- Year-end volume analysis
- Detecting tax-loss harvesting activity
- Comparing year-end liquidity across years
When NOT to Use
| Scenario | Use Instead |
|----------|-------------|
| Need average daily volume for the year | GetHistory() + AVERAGE |
| Need monthly volume | Volume_MonthEnd() |
Common Issues & FAQ
Year-end volume seems low.?
This is typical — many traders and institutions reduce activity during the holiday period between Christmas and New Year's.
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?