Best source for importing currency exchange rates using PQ?

**kao** · 11-25-2018, 10:04 AM

Hello,

What is the best source for importing currency exchange rates using Power Query?
x-rates is a good source but only for main currency pairs and I need more.

thanks!

**Ron Coderre** · 11-25-2018, 09:13 PM

Is this something you can work with?

let
    Source = Web.Page(Web.Contents("https://www.xe.com/currencytables/?from=USD&date=2018-10-31")),
    Data0 = Source{0}[Data],
    #"Changed Type" = Table.TransformColumnTypes(Data0,{{"Units per USD", type number}, {"USD per Unit", type number}})
in
    #"Changed Type"

**kao** · 11-30-2018, 12:52 PM

Originally Posted by Ron Coderre

Is this something you can work with?

let
    Source = Web.Page(Web.Contents("https://www.xe.com/currencytables/?from=USD&date=2018-10-31")),
    Data0 = Source{0}[Data],
    #"Changed Type" = Table.TransformColumnTypes(Data0,{{"Units per USD", type number}, {"USD per Unit", type number}})
in
    #"Changed Type"

it would, but it does not refresh, is that right? I mean it will take the rates which are as of 31st Oct, 2018?