Volume Average Six Months
Calculates the average trading volume over the past 6 months (approximately 126 trading days).
Syntax
=VolumeAverageSixMonths(Symbol)Examples
=VolumeAverageSixMonths("AAPL")When to Use
- Semi-annual volume analysis
- Medium-term volume trends
When NOT to Use
- Short-term volume analysis
Excel Templates Using Average Volume 6 Months
These ready-made MarketXLS templates call VolumeAverageSixMonths() in their worksheet formulas. Open one to see the function working inside a complete model.
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?