Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Local values being used for calculations when currency is different from 'EUR' in DEGIRO reports #53

Open
DiogoPonte opened this issue Apr 16, 2023 · 1 comment

Comments

@DiogoPonte
Copy link

When a product is traded in a currency other than 'EUR', it'd be expected that the Purchase and Sale values to be used would be the actual transaction value (which takes into account the exchange rate), and not the local values.

example.csv

See attached for a sample purchase and sale of an asset in USD.

What i'm getting:

Tuote | Hankintapäivä | Luovutuspäivä | Myyty kpl | Luovutushinta | Hankintahinta | hankintahinnat | Luovutuskulut | Voitto/Tappio
NVIDIA CORPORATION - C | 04/10/2021 | 13/10/2022 | 3 | 108,93 € | 200,51 € | 0,51 € | 0,38 € | −275,62 €
NVIDIA CORPORATION - C | 26/08/2021 | 13/10/2022 | 2 | 108,93 € | 221,80 € | 0,51 € | 0,25 € | −226,50 €
NVIDIA CORPORATION - C | 25/08/2021 | 13/10/2022 | 3 | 108,93 € | 223,22 € | 0,51 € | 0,38 € | −343,76 €

What would be expected:

Tuote | Hankintapäivä | Luovutuspäivä | Myyty kpl | Luovutushinta | Hankintahinta | hankintahinnat | Luovutuskulut | Voitto/Tappio
NVIDIA CORPORATION - C | 04/10/2021 | 13/10/2022 | 3 | 112,76 € | 172,42 € | 0,51 € | 0,38 € | −179,87 €
NVIDIA CORPORATION - C | 26/08/2021 | 13/10/2022 | 2 | 112,76 € | 188,70 € | 0,51 € | 0,25 € | −152,64 €
NVIDIA CORPORATION - C | 25/08/2021 | 13/10/2022 | 3 | 112,76 € | 189,99 € | 0,51 € | 0,38 € | −232,58 €

The rationale is that by using the local amount, this is actually calculating capital gains/loss in the local currency of the traded product, and not in EUR

The purchase/sale value in EUR can be inferred by dividing the "Value" column, in the DEGIRO report, by the quantity.

The inferred purchase and sale prices then allow for the actual EUR capital gain/loss to be calculated.

@jaantaponen
Copy link
Owner

Ah, this is correct! Will look into correcting this soon. Will do some maintenance tasks for the project during spring before taxation is due in Finland.

Sorry for the long response! Been busy with finalizing my studies.

Jaan

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

2 participants