Search code examples
google-sheetsgoogle-appsgoogle-finance

What is the formula for average daily trading volume calculated by Google Finance formula?


Average daily trading volume is obtained by this formula GOOGLEFINANCE("Symbol", "volumeavg") on Google Spreadsheet. How is the average volume calculated? Based on how many days of moving average?


Solution

  • Juan F Miguez has here "30 days" and a spot test has indicated it is around that period.

    Average volume used in finance market is 50 days.
    Presently google finance makes the average for 30 days.