OData Valet

Bank of Canada Exchange Rate Data in Excel

source code: andesco/odata-valet
source data: Bank of Canada · Valet API
Currencies
other currencies
Period
Excel Table Name Name you'll assign in Excel's Close & Load To… dialog.
Your custom OData feed URL:
How to use in Excel
  1. select: Get Data → OData
  2. paste your URL
  3. select Close & Load To…, name the table: Rates
  4. use XLOOKUP to find rates by date: