[BUG] Currency does not match despite correct currency

[Raptor05]

Bug Description

I'm trying to import my historical share activities to Ghostfolio. For this I've collected all transactions in an excel file. After changing my computer language for the separator and using an online converter to replace the delimeter from ; to , I was able to upload the CSV file to Ghostfolio. But then the following error occurs: activities.5.currency ("EUR") does not match with "CHF" and no exchange rate is available from "EUR" to "CHF"

The relevant line is: "01.08.2017,LU0290355717,YAHOO,EUR,228.4722222,0.216,buy,0,Einlieferung,1234"

The transaction happened with EUR currency and Yahoo is listing that share with EUR, too.

When I'm removing all other entries from the file, it works with that line, thats really strange...

To Reproduce

I've uploaded the CSV file.

1. Go to activities
2. Choose Import activities
3. Choose the file
4. Error in step 2

Expected behavior Accept the line.

Environment

• Ghostfolio Version v2.55.0
• Self-hosted with docker on Synology NAS
• Experimental Features disabled
• Browser Edge
• OS is Win 11

test.csv

[dtslvr]

Hi @Raptor05

LU0274208692 should be in CHF instead of EUR.

It looks like the row in the error message is wrong, maybe because the entries in the CSV file are not sorted.

[Raptor05]

Thanks for your answer.

2 Questions:

1. What means sorted? Do they need to be sorted by date?
2. Okay, on YAHOO the ETF is listed with CHF, on other platforms in EUR. But I bought them in EUR. How should I handle that? If I just change the currency, the price is wrong.

[dtslvr]

1. What means sorted? Do they need to be sorted by date?

The entries in your CSV file seem to be ordered by ISIN and Ghostfolio maybe expects them to be ordered by date. I haven't analyzed it, it's just a guess. However, it is a bug and should work regardless the order.

2. How should I handle that?

You can try to find your asset on Yahoo Finance and replace the ISIN with the corresponding symbol (e.g. DBXW.DE).