jaantaponen
commented
10 months ago 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
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.