# How to convert column in $to other column in euro? [closed] I have a list of prices in$ in column A and need them into euro's in column B. In the help I found the function CONVERT with an example:

Example =CONVERT(100;"ATS";"EUR") returns the Euro value of 100 Austrian Schillings. =CONVERT(100;"EUR";"DEM") converts 100 Euros into German Marks.

and thought putting in column B : =CONVERT(A11,"USD","EUR") would do the trick, but it returns #N/A.

Help ? :) Thy

edit retag reopen merge delete

### Closed for the following reason the question is answered, right answer was accepted by Alex Kemp close date 2020-09-08 00:47:49.040116

Sort by » oldest newest most voted

Figured out an easy way to do this! First, get the Stock Market Functions extension:

http://extensions.libreoffice.org/ext...

Then you can look up your currency conversion in Yahoo:

Then use the GETYAHOO function provided by SMF to get the currency conversion that can auto-update:

=GETYAHOO("CADUSD=X", 21)


Use the yahooexample.ods provided by SMF to see what all the datacodes mean. 21 is the last trade price.

more

Note that the original developer discontinued the SMF extension, further development releases are available from dhocker/SMF-Extension.

( 2017-08-22 17:46:05 +0200 )edit
more

Have a look on my answer, its true also for EuroConvert

( 2016-03-29 21:28:15 +0200 )edit

Hallo

It should be obvious that this Function can only work between Currencys with a fixed exchange rate eg. Currencys from Countries in euro zone from|to € , but from US\$ to €UR is no fixed Rate, you have to lookup on your favourite stock exchange site for actual Rates and do the math by yourself.

more