topic Re: Currency conversion in QlikView

Currency conversion

Tue, 13 Jan 2015 10:43:12 GMT

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

Re: Currency conversion

alexandros17 — Tue, 13 Jan 2015 10:45:45 GMT

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

Re: Currency conversion

Tue, 13 Jan 2015 12:28:32 GMT

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 !

Re: Currency conversion

Tue, 13 Jan 2015 13:29:50 GMT

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

Re: Currency conversion

Tue, 13 Jan 2015 13:36:31 GMT

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