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

google-sheets google-apps google-finance
user781486 picture user781486 · Apr 5, 2014 · Viewed 12.1k times · Source

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?

Answer

sarikas picture sarikas · Jun 25, 2019

You can also do the following:

  • get the last x many days' volume for a ticker (I used 80 to be safe since there are weekends, and holidays for when the market is closed)
  • query the 50 records descending by date, (for a 50 day moving average use 50, for other averages use your own limit)
  • get just the prices

  • average

    =average(index(query(googlefinance("AAPL","volume",today()-80,today()), "select * order by Col1 desc limit 50"),0,2))

Related questions

Getting Google Spreadsheet CSV into A Pandas Dataframe

I uploaded a file to Google spreadsheets (to make a publically accessible example IPython Notebook, with data) I was using the file in it's native form could be read into a Pandas Dataframe. So now I use the following code …

Read More
Script to summarise data not updating

I have a Google spreadsheet of timesheet data; it has a sheet for each month, each sheet is a lot of six column blocks, one block per client. I have created a summary sheet that goes and gets the total …

Read More
If var isnumber, for script

I need to run a script which contains the logic: If isNumber, Then DoSomething. I've run other such if then tests such as if blank, and if cell contains "x". It should be simple but I can't find a solution. …

Read More