how to determine average exchange rate in past transactions

[gbfabiani]

My main currency is Euro, but I have a number of portfolios where my investments are in other currencies : for example US stocks in US$
If I select "exchange rate adjusted" I see all numbers in euro, otherwise in the original currencies. When I look to may US stock account, I can see the value of it and the gains either in Euro or in US$, but I don't know the weighted average currency rate I had with all my transactions in a given time. Any suggestion ? thanks giovanni

[Mark]

Hi giovanni,

Sorry, this isn't a field we have available. You could do it manually by looking at a Custom report with some fields like:

Purchases (between)
Redemptions (between)
etc

and dividing these between the case where you view the report in the native currency and the default currency. This isn't an automated solution, but should allow you to obtain the information.