You can download this demo, that gets the data from the xml-pages offered at http://www.ecb.europa.eu/stats/exchange/eurofxref/html/index.en.html
The demo is part of an article written in Dutch, so you'll need google-translate, but the explanation in FM is written in english.
Note that the FM-file has dutch file-format, so the decimal-sign is the comma "," in stead of the dot "."
Also note that the rates of the ECB are against 1 Euro = ....
I found 2 more free feeds:
but you'd have to create your own stylesheets for them. All other sites you have to do some form of registration and payment.
Thank you , I will try it out
I have a subscription to Open Exchange Rates - for $12/month you can make 10,000 requests. I just do one each day.
The data is in JSON format so I've been using a Custom Function to parse it out - would be cool to do that natively in FM16
Old thread that can be updated! There are new functions for writing and reading JSON, along with Insert From URL (using cURL).
2 of 2 people found this helpful
Now since 16 is out, it can be done natively in just 2 script steps you can get the rate for a specific currency into another one:
1) Insert from URL into a variable
2) Calculate the rate directly from the resulting json in the variable:
Set-Variable [ $rate ;
Let ( [
base = "EUR" ; // The base-currency .... in this case 1 EURO = x USD
curr = "USD" ; // The currency you wish to find the rate for
dcmp = Middle ( Pi ; 2 ; 1 ) ; // Calculate decimal-sign for localization
rate = Substitute ( JSONGetElement ( $json ; "rates." & curr ) ; [ "." ; dcmp ] ) /
Substitute ( JSONGetElement ( $json ; "rates." & base ) ; [ "." ; dcmp ] )
Round ( rate ; 8 )