Bank of Canada Historical exchange rates
Results 1 to 10 of 10

Thread: Bank of Canada Historical exchange rates

  1. #1
    Member
    Join Date
    Sep 2012
    Posts
    37

    Bank of Canada Historical exchange rates

    Hello,

    I'm trying to wrap up my taxes today and am rather frustrated that I am unable to find historical daily US-CAD exchange rates on the bank of canada website. It will not let me look back further than January 2017. Can anybody help?

    thanks.

    Last edited by RParks; 2017-04-30 at 04:27 PM.

  2. #2

  3. #3
    Member
    Join Date
    Sep 2012
    Posts
    37
    Quote Originally Posted by jerryhung View Post
    Thanks.. I know the website and that is what I've been searching on...... it won't let me look back further than 2017.

  4. Remove Advertisements
    CanadianMoneyForum.com
    Advertisements
     

  5. #4
    Senior Member
    Join Date
    May 2009
    Location
    Ottawa
    Posts
    2,592
    They claim to have the "legacy" rates posted in 3 types of downloadable files on this site: http://www.bankofcanada.ca/rates/exc...closing-rates/

    But they all appear to be database formats of some kind.

  6. #5
    Senior Member
    Join Date
    Oct 2010
    Posts
    7,811
    Database formats ???

    CSV is comma separate value that Excel or alternatives (ex. OpenOffice, LibreOffice) will open just fine. The one I downloaded started with a 2007 date.

    JSON and XML are for java.


    Cheers

  7. #6
    Senior Member
    Join Date
    Apr 2013
    Posts
    328
    Even Notepad will open a csv file; but in this case it isn't an easy read.

    If you don't have Excel or an alternative, you can download the free Excel Viewer from MS
    https://www.microsoft.com/en-ca/down...ils.aspx?id=10

  8. #7
    Junior Member
    Join Date
    Jan 2017
    Posts
    3
    Hello RParks,

    I see what you mean. You can only see rates back to Jan 2017, and if you download the data in a CSV or XML format, it also only goes back as far as Jan 2017.
    I suspect there is and issue with the BofC site.

    I was able to find historial rates at the CanadianForex site "CanadianForex.com"

    But obviously, these aren't the official BofC rates.

    Good luck.

    Joe

  9. #8
    Senior Member
    Join Date
    Oct 2010
    Posts
    7,811
    Quote Originally Posted by Joebaba View Post
    ... I see what you mean. You can only see rates back to Jan 2017, and if you download the data in a CSV or XML format, it also only goes back as far as Jan 2017.

    I suspect there is and issue with the BofC site.
    I am not so sure as there is another link in post #4 that provides May 1st, 2007 through April 14th, 2017. The layout used to be better from what I recall but it is available.


    Quote Originally Posted by Joebaba View Post
    ... I was able to find historial rates at the CanadianForex site "CanadianForex.com" But obviously, these aren't the official BofC rates.
    The post #4 link give the choice of "Noon", "Closing", "Monthly Average Rates" and "Annual Average Rates".


    Cheers

  10. #9
    Junior Member
    Join Date
    Jan 2017
    Posts
    3
    Right you are.

    Joe

  11. #10
    Member
    Join Date
    Sep 2012
    Posts
    37
    Thanks everyone. Which one do I use... Noon or Closing?


Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •