Volume Average One Year
Calculates the average trading volume over the past year (approximately 252 trading days).
Syntax
=VolumeAverageOneYear(Symbol)Returns
number
Average trading volume over 1 year
Examples
=VolumeAverageOneYear("AAPL")=VolumeAverageOneYear(A1)When to Use
- Annual volume analysis
- Long-term volume baseline
When NOT to Use
- Short-term volume spikes
Excel Templates Using Average Volume 1 Year
These ready-made MarketXLS templates call VolumeAverageOneYear() in their worksheet formulas. Open one to see the function working inside a complete model.
Related Formulas
More MarketXLS Technical Indicators 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?