In this article, we’ll walk through how to build an Excel spreadsheet using Power Query to pull foreign exchange rates from the Bank of Canada’s website. Even if you’ve never used Power Query before, in 15 minutes or less you’ll get a basic understanding of the tool and be left with a useful automated exchange rates spreadsheet.
Bichon Associates 