Volume Average Thirty Days
Calculates the average trading volume over the past 30 trading days.
Syntax
=VolumeAverageThirtyDays(Symbol)Returns
number
Average trading volume over 30 days
Examples
=VolumeAverageThirtyDays("AAPL")When to Use
- Monthly volume analysis
- Volume trend comparison
When NOT to Use
- Intraday volume analysis
Excel Templates Using Average Volume 30 Days
These ready-made MarketXLS templates call VolumeAverageThirtyDays() 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:
- Average Volume 5 Years
- Average Volume 6 Months
- Average Volume 7 Days
- Average Volume 9 Months
- Average Volume Between Custom Dates
- Change From 200-Day Moving Average
- Change From 50-Day Moving Average
- Commodity Channel Index
See VolumeAverageThirtyDays used in a complete workbook: Stock Screener Excel: Build a Powerful Custom Screener with MarketXLS
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?