1

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?

guagay_wk
  • 26,337
  • 54
  • 186
  • 295
  • This question appears to be off-topic because it is about the internal operationss of a vendor-supplied service. – Mogsdad Oct 14 '14 at 19:08

2 Answers2

6

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))
zx485
  • 28,498
  • 28
  • 50
  • 59
sarikas
  • 83
  • 1
  • 7
2

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.

pnuts
  • 58,317
  • 11
  • 87
  • 139