I'm using this formula:

=ARRAY_CONSTRAIN(GOOGLEFINANCE("NYSE:"&A4, "all",  DATE(2020,4,1), DATE(2020,4,30), "DAILY"), 2, 4)

I'm only getting one column for April 1, 2020.

I would like to get the full range April 1, 2020 - April 30, 2020.


You're asking the function to return only two rows (the header and the first day):

enter image description here

Replace the next-to-last argument (2) by a higher number and you're good to go:

=ARRAY_CONSTRAIN(GOOGLEFINANCE("NYSE:"&A4, "all", DATE(2020,4,1), DATE(2020,4,30), "DAILY"), 30, 4)

enter image description here

  • thank you!!! is there away to remove the time next to the date? – Jorge Arbelaez May 26 '20 at 6:46
  • I haven't tried it, but you could adjust the formatting of that column, or introduce another column which truncates the dates. – Glorfindel May 26 '20 at 6:48
  • Thanks for the help!! – Jorge Arbelaez May 26 '20 at 6:50
  • You're welcome. You can accept the answer to mark it as the correct one (but if you want to wait until better answers come, that's fine too). – Glorfindel May 26 '20 at 6:51

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.