Select a cell from where you want to start displaying the exchange rates. Type the formula: =GOOGLEFINANCE(“CURRENCY:GBPEUR”, “price”, TODAY()-10, TODAY(), “DAILY”)