Google-sheets – Google Finance Historical Data with Multiple Attributes? (Dates, high, low, close,)

google sheetsgoogle-finance

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

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)

You can use JOIN to stitch the pieces together with a given delimiter:

=join(",", f o r m u l a )

=ARRAY_CONSTRAIN(GOOGLEFINANCE("NSE:"&A2, "all", TODAY()-($N$2), TODAY(), "DAILY"), 2, 4)

=QUERY(GOOGLEFINANCE("NSE:"&A2, "all", TODAY()-($N$2), TODAY(), "DAILY"), 
 "select Col2,Col3,Col4", -1)