CODEWITHSUNDEEP
google-sheetsgoogle-appsgoogle-finance
guagay_wk
guagay_wk

Reputation: 28060

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?

Upvotes: 2

Views: 20565

Answers (2)

sarikas
sarikas

Reputation: 93

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))

Upvotes: 7

pnuts
pnuts

Reputation: 59485

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.

Upvotes: 2

Related Questions