Home MarketXLS
Dashboard MarketXLS
Screener MarketXLS
Options Profit Calculator MarketXLS
Stock Ranks MarketXLS
Spreadsheet Builder MarketXLS
Documentation MarketXLS
Logout MarketXLS

Volume Average One Year

Live
Returns the average traded volume over one year.

How calculated

(Sum of volume for the given x period)/Number of days in the x period

Example usage

=VolumeAverageOneYear("MSFT") - Returns the average volume for MSFT for the given period

Notes

This function calculates the average volume for the past X calendar days in the given period. This value is updated everyday at around 5PM EST.

Assets

Stocks, ETFs , Cryptocurrencies