Ask Your Question

How to convert column in $ to other column in euro? [closed]

asked 2016-03-29 19:09:12 +0200

SvenAERTS228 gravatar image

updated 2017-08-22 18:00:18 +0200

erAck gravatar image

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 flag offensive 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

3 Answers

Sort by » oldest newest most voted

answered 2016-06-16 14:45:44 +0200

eresonance gravatar image

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

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:


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

edit flag offensive delete link more


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

erAck gravatar imageerAck ( 2017-08-22 17:46:05 +0200 )edit

answered 2016-03-29 21:18:40 +0200

Rugslug gravatar image
edit flag offensive delete link more


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

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

answered 2016-03-29 21:22:42 +0200

karolus gravatar image

updated 2016-03-29 21:36:33 +0200


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.

edit flag offensive delete link more


Thanks for this info. That's a unique way around the European currency system to Euros. When I buy USD from CAD, 3 years ago was equal, today's it costs 1.30 to buy a USD. And 1.47 for a Euro. So the monetary units in the EuroConvert are not trade value dependent.

Rugslug gravatar imageRugslug ( 2016-03-29 21:36:46 +0200 )edit

Question Tools

1 follower


Asked: 2016-03-29 19:09:12 +0200

Seen: 2,330 times

Last updated: Jun 16 '16