Currency conversion in LibreOffice Calc

libreoffice-calc

I have a *ods.-spreadsheet in LibreOffice. Some fields contain numbers in currency format (JPY), but they could also be in general number format. I want to create corresponding fields which display the amount of money in Euro and US$, doing the conversion automatically (i.e. without me supplying conversion rates, and the conversion rates updating themselves).

Is this possible and if yes, how?

Best Answer

Without using a plugin, try using api.fixer.io:

=LEFT(RIGHT(WEBSERVICE("http://api.fixer.io/latest?symbols=EUR,GBP"),9),7)

This will retrieve something like this:

{"base":"EUR","date":"2017-08-17","rates":{"GBP":0.90895}}

and display this:

0.90895

The same technique would work with any other currency URL.

Regards

Edit 2020-09-15: The original URL provided is no longer valid. You can still get free rates at fixer.io, but you have to sign up for an api key. Here is an alternative place to get the data: https://exchangeratesapi.io/.

Related Question