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.
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.