Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Currency conversion

Good Morning.

I have downloaded from Yahoo Finance historical data for equities in different currencies (EUR, Dollar). I need to convert them in the same currency. How can i do?

These are the fields of a table:

Honda:

LOAD year(Date) as Year,

  month(Date) as Month,

  Date,

     Open,

     High,

     Low,

     Close,

     Volume,

     [Adj Close],

     'HONDA' as Azione

4 Replies
alexandros17
Partner - Champion III
Partner - Champion III

You need to know for any date the change rate for the currencies and multiply values for the rate

Not applicable
Author

Hi Stefano,

To calculate the Currency Conversion Rate, Maintain a Monthly/ Weekly/ Daily Conversion Sheet with respective Rates.

You can use ApplyMap() to fetch and Multiply the Rate for those Respective Month.

Hope it help !

Cheers !

Not applicable
Author

Hi Stefano

you first need to get the ratio between these two currencies, for example, todays is 1 UERO = 1.39$, so if you have 3 UERO , THEN CONVERSION expression to dollars will b = 3*1.39, generalize this expression to make it true for all your data entries, you can  use this in either in your script  or in the expression tab.

Hope this works

Best Regards

Dlamini

Not applicable
Author

Hi Stefano

Please also go through this link, it should resolve your query: http://community.qlik.com/message/93743#93743, specifically check John Witherspoon solution, its is good.

Hope this works

Kind Regards

Dlamini