The Fastest Way to Lookup Multiple Historical CAD to USD Rates

At Perceptus, we deal with the Canadian Dollar to US Dollar exchange rate a lot.  Doesn’t every small business in Canada? We need to convert our US revenues to Canadian CAD amounts for tax purposes, among other things.

We used to use the common websites like XE.com or X-Rate.com to get our historical exchange rates.  But those sites are too slow if you need to look up a half a dozen exchange rates from the past.  It takes several clicks to retrieve a single exchange rate for a date in the past.

So, I went looking for something better to use.  In fact, I was prepared to create a new tool for looking up historical Canada to USA exchange rates on the Web Tools by Perceptus site if I couldn’t find a satisfactory alternative.

Unfortunately for tools.perceptus.ca, I did find a reasonably good way to get a lot of old exchange rates in an efficient way.  The IMF website, of all places, has a great custom table generator.

Here’s the link: Http://www.imf.org/external/np/fin/ert/GUI/Pages/CountryDataBase.aspx

However, this link (until it breaks, anyway) will take you directly to every CAD to USD rate in the last 365 days in a nice and tidy table.  Just generate the table, and look up the rate you need for the date you need.

Nice!

Tags: , , , , , , , , , ,

Leave a Reply