In Google Sheets, GOOGLEFINANCE returns an array of values, like so:
The formula is entered in A1 but the result extends into other rows and columns. I would like to "select" (not sure what the exact term is) a subset of this data. For example, I would like to select only the prices, without header (so B2:B22 in the image above). And I would like to do that in one formula, without ever printing the full table.
I tried OFFSET
, but it doesn't work since it doesn't recognize the GOOGLEFINANCE
formula as a range. Conversely, INDEX
works, but only returns one cell at a time, so
INDEX(GOOGLEFINANCE("TSLA", "price", TODAY()-30, TODAY(), "DAILY"),2,2)
returns "345.66" for example.