Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements
QlikView Fans! We’d love to hear from you.
Share your QlikView feedback with the product team… Click here to participate in our 5-minute survey.
Rules, plus terms and conditions, can be found here.
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

Re: Currency conversion

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

Not applicable

Re: Currency conversion

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

Re: Currency conversion

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

Re: Currency conversion

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

Community Browser