0

I am trying to find a more efficient way to calculate the last 3 month volume for a given stock but I cant seem to find a function that would let me do. The other approach was get all volume data and add them and import it in the google sheet but it would take too long and wouldn't be as efficient. Thank you in advance.

Debuggingnightmare
  • 73
  • 1
  • 9
  • 1
    Read up on [`GOOGLEFINANCE`](https://support.google.com/docs/answer/3093281?hl=en) and [function list](https://support.google.com/docs/table/25273?hl=en&ref_topic=3105385) on dates. – Argyll Aug 09 '22 at 14:13

1 Answers1

1

An example on how to calculate the last 3 months volume using GOOGLEFINANCE would be:

=GOOGLEFINANCE("NASDAQ:GOOG","volume",TODAY()-90,TODAY())

This formula would display the information like this:

enter image description here

Gabriel Carballo
  • 1,278
  • 1
  • 3
  • 9