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.

1 Answer 1


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


Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

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