Use Datastream (available at Barcelona and Madrid Libraries through LSEG Workspace (formerly Refinitiv Workspace)) which contains spot and forward currency rates. To access Datastream open Excel and click on the Datastream tab within Excel. Click on Time Series Request, then Find Series and Exchange Rates and Exchange Rate Explorer to select the datatype that you want. Select the dates and frequency that you want the data for and click on Submit.
