Volume Average Thirty Days

Volume is counted as the total number of shares that are actually traded (bought and sold) during the trading day or for a specified set period of time.

How calculated

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

Example usage

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


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.


Stocks ETFs Cryptocurrencies

Stand with Ukraine

As the situation in Ukraine escalates, many of us in MarketXLS are left with emotions too overwhelming to name. If you’d like to show your support, but aren’t sure how to, we want to help make it easier for you to act.

For any amount donated, we’ll extend your MarketXLS subscription for double of the donated amount. Please send proof of your payment to support@marketxls.com to avail the extention

From all of us at MarketXLS, thank you!