Official Euro Exchange Rates pulled from API

Hi,

Sheet link: ECB Exchange Rater - Google Sheets

The API endpoint: https://sdw-wsrest.ecb.europa.eu/service/data/EXR/D.USD.EUR.SP00.A?format=jsondata&startPeriod=+++Sheet1!C2+++&endPeriod=+++Sheet1!C2+++&detail=dataonly

PS. I do in any way not guarantee that this URL is correct for your use case since there are many ways to get data and your legislation might place other demands on what data should be fetched and how it should be calculated.

API doc: ECB SDMX 2.1 RESTful web service

Best, Peter

1 Like