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

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

SvenAERTS228
48 ●16 ●21 ●25

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

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

add a comment

1

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

eresonance
26 ●1 ●1

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:

https://ca.finance.yahoo.com/q?s=CADU...

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.

edit flag offensive delete link

Comments

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

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

add a comment

0

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

Rugslug

1341 ●5 ●12 ●22

Some information Here

Points here for more information for Open Document Standards

EuroConvert possibilities here

But does not indicate anything about USD or CAD

edit flag offensive delete link

Comments

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

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

add a comment

0

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

karolus

5584 ●17 ●40

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

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.

edit flag offensive delete link

Comments

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 ( 2016-03-29 21:36:46 +0200 )edit

add a comment

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

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

Comments

Comments

Comments

Question Tools

Stats

Related questions

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

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

Comments

Comments

Comments

Question Tools

Stats

Related questions

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

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