Easy to work with currency rates in a Xojo app by downloading a standard rate list? Anyone experience? Thanks!
I am assuming that you wish to convert amounts from one currency to an equivalent amount in a second currency. Basically, I would load (and update) the exchange rate table downloaded from your source into a SQLite (or other) database. Then it is just the matter of a simple select with the from-currency, the To-currency and the date to get the factor to apply to your from-currency.
For the most popular currencys the ECB offers a daily updated file with the exchange rates: Euro foreign exchange reference rates
You can download as csv or xml and then parse the contents and work with the rates…
1 Like
Thanks Thomas, will make it work with the ECB file!
Thanks, was actually looking for the rate file to be downloaded.