Performance des positions en monnaie

Hi,

I would like to report an error of performance calculation with cash position.

my version : Portfolio Performance
Version: 0.79.1 (août 2025)
Platform: win32, x86_64
Java: 21.0.5+11-LTS, Azul Systems, Inc.

I have a cash position in EUR/JPY. In the performance calculation screen, under the calculation tab, I have EUR/JPY, value -19.56€, including a foreign exchange gain of -2682.82€. This is OK.

But in the Assets tab at the end, the market value does not take into account the foreign exchange gain (of -2682.82), but just the value (of -19.56). This foreign exchange gain value is therefore not reported anywhere in the performance calculations or in the other tabs like stock performance.

Sincerely,

Aurelien.

Bonjour,

To be sure to understand, I am using kommer file as example :

In your case, you have -19.56€ at the -15.89€ in the picture, “Cash Currency Gains”, and the -2682.82€ at the -182.97 €, “thereof foreign currency gains” , is that so ?

15.89 € is the currency gain/loss of the cash in deposit account.

182.97 € is included already in the capital gain of this security (528.07 € here). It is not in addition to it. 528.07 € value includes the effect of the change of exchange rate and the change of security price.

You can show this foreign currency gain as a column in Performance/Securities :

Hello Veterini,

Thanks for your fast answer. To be also very precise, I delete all my position but I keep my cash position EUR/JPY.

So I have indeed this in performance calculation :

But in all performance tab, currency gain is not take into account as here in perfromance tab where only the “value part” of -86,41€ appears :

Or here in trade tab where “exit value”, and so “Profit/loss” don’t take currency gain into account :

Sincerely,

Aurélien.

Hello, hm I do not know much about such situation, I hope other can help.
Would it be incorrect to use cash deposit account in EUR and JPY with deposit/removal/transfer ? Given than PP has the exchange rate already.

How is configured the security EUR/JPY ? Like this


or

or something else ?

Do you have one simple case with a single buy and the expected result ? “I bought xx JPY with YY EUR on 14 Nov 2024, today exchange rate is .. I expect to see bb € gains/loss”.

I found this topic, which may be similar to your case ?

hello,

Here’s what I did: I created a title and set it up as an stock.

Here’s a screenshot of the configuration of the “stock”

After that, you just need to enter the transactions, with the quantity as the number of yen and the price as the exchange rate. The result will give you the amount in euros.

You will then be able to see the unrealized gains or losses displayed consistently everywhere

Best regards

François

1 Like

Hello Veterini, Salut Francois,

Indeed, using the “inverse” stock (JPYEUR, currency € and not EURJPY, currency JPY) is a solution (even if it is less comprehensive but ok). The calculations are done and correct with this method.

Even if we have a solution in this case, it is clear that foreign exchange gains/losses are not calculated in the performance indicators, which seems to me to be a problem!

I have other stocks in USD, so I must conclude that the exchange rate gain is not taken into account, which is unfortunate.

If this can be reported to the developer, it would be great to fix it.

Thank you for your prompt response.

Sincerely,

Aurélien.

Mmm but it is included. The ‘thereof foreign capital gain’ is included in the value Capital Gain. It is not in addition to it. For foreign securities, 100% sure. For trades on exchange like this, I do not know if this is different

See this example, is this what you expect ?

But I show you that it is not the case here :

My security EUR/JPY is :

If I use the “inverse” method of Francois, it is ok and I have -2079.50€ in value column.

My security JPY/EUR is in this last case is just inverse : currency in EUR, and symbol JPYEUR=X.

By the way, I just see that the 2 values are differents (2508€ of currency gain is correct, not 2079.5€). I discover that is because of an approximation made by the application of the tracker yfinance JPYEUR=X :

quote 0,0058 is incorrect and should be 0.0057537… . It is another probleme with this inverse method..

Oui, la fin de ma phrase était “for trades on exchange like this not sure”. Ce que je voulais contester, c’est la généralisation que vous faisiez “I have other stocks in USD, so I must conclude that the exchange rate gain is not taken into account, which is unfortunate.” est je pense incorrect. C’est ce que j’appelais “For foreign securities”. Pour des achats d’Apple ou autre titre en USD, la valeur Capital Gain inclue les effets du taux de change. Je pense que l’exemple dans le lien que j’ai mis est assez clair pour voir ça.

C’est uniquement dans votre cas où c’est une paire de devise directement qui est acheté / vendu que se pose le problème.
Pour aller plus loin, il serait pratique d’avoir un exemple simple et reproductible. Avec juste l’information “la bonne valeur est 2500€”, c’est assez compliqué de solutionner, il faudrait également les dates et valeurs d’achats associés. Mais au plus simple, si un seul achat permet de mettre en évidence votre problème, ce serait mieux.
“14 Nov 2024, 1 achat de 10 EURJPY au prix de XXX, la plus-value latente attendue est donc YYY mais ZZZ est affichée à tel endroit”.