Import Activities Error

[antoniopnp]

While trying to Import Activities from Trading212 I got the following error:

I've used docker and looking by the logs the file was converted fine.

How to reproduce: I've used this file: from_2024-03-02_to_2024-07-03_MTcyMDAyMjM3MTQxNw.csv

[dickwolff]

Thanks for reporting! I’ll look into it this weekend and let you know what I find!

[dickwolff]

The issue in this case seems to be the line below:

Dividend (Dividend),2024-06-13 09:44:24,US5949181045,MSF,"Microsoft",0.7644283000,0.59,EUR,Not available,,,0.45,"EUR",0.08,EUR,,,,,,

This seems to be a dividend payout for Microsoft (MSFT), but with a different symbol (MSF). The ISIN is the same. This is a normal record for a MSFT dividend:

Dividend (Dividend),2024-06-13 09:30:13,US5949181045,MSFT,"Microsoft",0.2366249000,0.64,USD,Not available,,,0.14,"EUR",0.03,USD,,,,,,

Notice also the first example has EUR as currency, and the second has USD (which is the correct currency).

I'm not really sure what to do about this. It looks like Trading 212 output some "garbage" data in the output. I would expect the dividend payout of the first example to be like the second. But it isn't...

[antoniopnp]

Maybe because one is from Nasdaq (USD) and another is from Deutsche Borse Xetra (EUR):

https://finance.yahoo.com/quote/MSFT/ https://finance.yahoo.com/quote/MSF.DE/

I have delete that line but I'm getting errors on symbols now:

I tried to delete also those lines but I keep gettting the same error on other symbols: O, GWW, AGNC, ADC, BLK, AAPL, LOW, PNR..

I've checked on Yahoo and all of them exist O GWW AGNC ADC BLK AAPL LOW PNR

[dickwolff]

Do you perhaps have a clean install of Ghostfolio currently, where you try it import this file? Could you try to add one manually, for example CSCO and see if Ghostfolio autocomplete finds the symbol?

[antoniopnp]

Yes, I have a clean install.

When I insert CSCO on the input field ghostfolio give me a suggestion to select. If i just type CSCO the field stays RED, and if I select the suggestion ghostfolio give me it becomes green and I can add it.

Visually all I can see on the input field is CSCO.

I took some screenshots for reference:

[dickwolff]

Thanks for confirming this. Have you tried to upload the CSV from the tool after this?

Reason being I have had the same issue with a clean Ghostfolio install not recognizing any symbol, and after looking one up via the Add activity window it automagically worked for me.

[antoniopnp]

I reduce the json list just for testing and I got the same error in 10 out of 100 symbols. After I add them sometimes I got the error again in the same symbol, but after some re-tries ghostfolio shows the correct list to add without error, it's weird.

Thank you for the suggestion.

[dickwolff]

Very weird, maybe @dtslvr has an idea what could cause this?

[dtslvr]

@antoniopnp do you see this in your log when you start the server?

Fetching crumb and cookies from https://finance.yahoo.com/quote/AAPL...
...
fetch https://query1.finance.yahoo.com/v1/test/getcrumb
New crumb: t***N.t***G

Or any other error in the log?