Power Query - Free Currency Exchange Rate Feed?


  • Hi Folks

    Does anyone know of a free or low cost exchange rate / FX feed that PowerQuery can plug into (say via Odata)?  I  need monthly FX data with history going back 3-4 years. 



    Friday, June 06, 2014 1:19 AM


All replies

  • How about parsing a page like this?

    It looks like there is quite a lot you can set in the URL and From Web in Power Query does a pretty good job parsing the page.

    • Marked as answer by Steve_Fox Tuesday, June 10, 2014 2:33 AM
    Monday, June 09, 2014 6:54 PM
  • Hi Ben

    Thanks for the reply.  That page does Parse well. However the monthly FX history page (link below) which is the dataset I am after, doesn't seem to parse at all :(.

    Any other ideas?



    Tuesday, June 10, 2014 2:26 AM
  • Ok- Found a suitable feed that worked



    Tuesday, June 10, 2014 2:34 AM
  • Great! Glad you were able to make it work. From Web looks for standard HTML tables and extracts those. Otherwise everything is dumped in to the Document data structure. If the page doesn't have a table on it, digging into the Document object can get pretty gnarly. I usually give up and try to find another source for my data at that point.
    Tuesday, June 10, 2014 4:28 AM
  • For this, I had been using this and it's great.

    It has instructions which can help you.

    I have been using MarketXLS for this, it's been working Great so far

    Just visit the site for more info.

    They also have a live support and a forum to help you with your questions/concerns.

    Tuesday, July 05, 2016 1:08 AM