Page 1 of 1

currency performance

Posted: April 27th, 2006, 2:36 pm
by captainharlock
Hi, my problem refers to performance computing.That is, for exampe, I've got a stock (Apple - usd dollar priced).Well, if today Apple performance is -0.176%, and euro/usd performance is 0.72%,Apple performance in euro is computed as follow: (1-0.176%) * (1+0.72%) - 1 = -0.897%.Another way somebody suggest me, is as follow: -0.176%+0.72%+ (-0.176%*0.72%) = 0.54%But the results are very different.... How can I compute performance in euro ?Could somebody give me any suggestion ?

currency performance

Posted: April 27th, 2006, 3:57 pm
by Lepperbe
QuoteOriginally posted by: captainharlockHi, Apple performance in euro is computed as follow: (1-0.176%) * (1+0.72%) - 1 = -0.897%.Quoteehm 0,99824 * 1,0072 - 1 = 1,00543 = +0,543%

currency performance

Posted: April 28th, 2006, 8:32 am
by captainharlock
sorry.. you're right Lepperbe..Another approach to the problem refers to a portfolio (usd currency based) case : it's based on NAV value.That is, comebody told me that I could apply the Euro/usd change on the NAV value.So, if I'd want to compute performance in euro on a portfolio which is usd dollar based, between t and t-1, I've to compute A/ B -1 where A = NAV(t) / NAV(t-1)and B = eur/usd(t) / eur/usd(t-1) that is: [ NAV(t) / NAV(t-1) ] * eur/usd(t-1) / eur/usd(t-1)] -1 ,but I'm not convinced about this.So I'd prefer do: [NAV(t) * eur/usd(t)] / [NAV(t-1) * eur/usd(t-1)] -1What do you think about it?I'd have to compute the impact of the currency on a portofolio and the methods giveme different results.For example: NAV t = 100NAV t-1 = 87eur/usd (t) = 1.24eur/usd (t-1) = 1.23the first equation gives me: 14.02% and the second: 15.88%.

currency performance

Posted: April 28th, 2006, 5:32 pm
by Lepperbe
QuoteOriginally posted by: captainharlockSo, if I'd want to compute performance in euro on a portfolio which is usd dollar based, between t and t-1, I've to compute A/ B -1 where A = NAV(t) / NAV(t-1)and B = eur/usd(t) / eur/usd(t-1) that is: [ NAV(t) / NAV(t-1) ] * eur/usd(t-1) / eur/usd(t-1)] -1 ,but I'm not convinced about this.should be (1+A)*(1+B)-1with A = NAV(t) / NAV(t-1)B = eur(t)/usd(t-1)