OData Valet

Bank of Canada Exchange Rate Data in Excel

source code: andesco/odata-valet
source data: Bank of Canada · Valet API

Currencies

Period

years

months

weeks

start & end dates

strict mode · disable 5-day padding

Your custom OData feed URL:

How to use in Excel

select: Get Data → OData
paste your URL
select: Close and load
use XLOOKUP to find rates by date:

=XLOOKUP(A2, Query[Date], Query[USD_CAD], 0.0000, -1)

date cell: A2 OR INDEX(A:A,ROW())
imported table name: Query
date column: [Date]
exchange rate column: [USD_CAD]
returned value when no match found: 0.0000
find previous business day: -1