DEGIRO: unitPrice null after conversion.

64knl commented 1 week ago

When running the conversion the resulting JSON contains an entry with a null unit price (not accepted by Ghostfolio):

{
            "accountId": "guid-guid-guid-guid",
            "comment": "",
            "fee": 2.8, // Why?
            "quantity": 1,
            "type": "DIVIDEND",
            "unitPrice": null, // <- this is the issue
            "currency": "EUR",
            "dataSource": "YAHOO",
            "date": "2023-07-04T17:20:00+00:00",
            "symbol": "DSFIR.AS" // DSM-Firmenich AG
}

The associated source transaction seems to be:

04-07-2023,17:20,04-07-2023,,,"Overboeking van uw geldrekening bij flatexDEGIRO Bank 2,08 EUR",,,,EUR,9999999.99
04-07-2023,17:20,04-07-2023,FLATEX EURO BANKACCOUNT,NLFLATEXACNT,Degiro Cash Sweep Transfer,,EUR,2.08,EUR,888888.88,

This transaction seems unrelated to DSM-Firmenich.

dickwolff commented 1 week ago

Thanks for reporting. I would expectthese records to be ignored, as both "flatex" and "cash sweep" are on the ignore list. I will try and verify if there is a reason they are not.

dickwolff commented 1 week ago

Weirdly enough, when I run the tool with the lines you provided (with DEGIRO V3), they are ignored (as expected). I had to add a comma (,) after the first line though, but I don't think that is your issue.

Can you perhaps provide some more lines of the CSV that are around these lines? Perhaps some other record influences this.

64knl commented 3 days ago

@dickwolff Happy to share the surrounding data, preferably less public than this ticket.

dickwolff commented 3 days ago

Sure! You could send me a message on Telegram of a DM on Twitter?

dickwolff / Export-To-Ghostfolio

DEGIRO: unitPrice null after conversion. #124