Help with some functions in Google sheets

=index(GOOGLEFINANCE("AAPL","price","02/20/2020"),2,2)

gives 320.3

=GOOGLEFINANCE("USDGBP", "price", "01/01/2020",500)

gives a list of exchange rates since the start of the year.

1 Like