Ignore cash currency gains

English
1

Hello! I really like the application so congratulations on all the people involved in the development, I really appreciate your effort put in the software.

Here’s my question: Is it possible to have the performance calculation (or the TTWROR) ignoring the cash currency gains?

Context, I have securities in different currencies (My main one is EUR). I’m mainly interested in the performance of my securities and not my cash deposits as I normally don’t update the deposit accounts with the deposits I’m doing but when I want to assess the performance of the entire portfolio it takes into account the cash currency fluctuations and I’d like to ignore them.

I tried by only selecting the securities account in the data series and this is indeed ignoring the cash currency fluctuations but then I have another problem which is that this performance is only taking into consideration the Dividends in EUR (which is only a fraction of the total dividends) so the performance is biased and wrong.

Is there any way of doing it? By either removing the cash currency gains from the calculation of the performance of the entire portfolio or including all the dividends to the calculation selecting the securities account only.

Thanks!

2

Probably the best way will be having multiple cash accounts, at least for every currency where you received dividends from.

3

Hello Sn1kk3r5 and thank you for the reply.
I do have different cash accounts, one for each currency and I think this is the main problem.
If I had only the EUR cash account and all the dividends were converted and inserted in that account the calculation of the performance would be alright. The problem is that I’m using Interactive brokers and I’m importing the information every month, the dividends in that report are always inserted in the cash account of the dividend currency and I haven’t been able to change it. I don’t think it’s possible as it’s not using the currency exchange at all during the import but if there is a way of doing it, It would solve my problem as all the dividend would be inserted in the EUR account and then taken into consideration in the performance of the securities account. I have a many operations each month so using the manual dividend transaction is not feasible at this point.

So, as a summary:

  • I have different cash accounts, one per currency
  • I’m importing operations from IB and the dividends are directly linked to the currency cash account
  • I’m not able to transact the dividends to the EUR account automatically

Cheers!