none
Power Query - Free Currency Exchange Rate Feed?

    Question

  • 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. 

    Cheers

    Steve

    Friday, June 06, 2014 1:19 AM

Answers

All replies

  • How about parsing a page like this?

    http://www.x-rates.com/historical/?from=EUR&amount=1&date=2014-06-03&date=2014-06-03

    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
    Moderator
  • 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 :(. 

    http://www.x-rates.com/average/?from=NZD&to=USD&amount=1.00&year=2014

    Any other ideas?

    Cheers

    Steve 



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

    http://www.exchangerates.org.uk/USD-NZD-exchange-rate-history.html

    Cheers

    Steve

    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
    Moderator