search

dickwolff / Export-To-Ghostfolio

Convert transaction history export from your favorite broker to a format that can be imported in Ghostfolio.
https://hub.docker.com/r/dickwolff/export-to-ghostfolio
Apache License 2.0
35 stars 8 forks source link

Include TradeRepublic #20

Open stefanriegel opened 6 months ago

stefanriegel commented 6 months ago

is there some way to include TradeRepublic? There is a Private API, where i get all my Transactions (in PDF)

dickwolff commented 6 months ago

That would certainly be possible. However the tool works with CSV files. Is there an option to get your transactions in a CSV format, or perhaps convert the PDF to CSV?

If you can provide me an example file, I can take a look at it and put in on the backlog to work on!

stefanriegel commented 6 months ago

here is an Example CSV:

[ { "type": "timelineEvent", "data": { "id": "545b758a-2ac1-451b-8833-b1XXXXX", "timestamp": 1585727959457, "icon": "https://assets.traderepublic.com/img/icon/timeline/Document.png", "title": "Basisinformationen", "body": "Alle Informationen rund um den Wertpapierhandel", "action": { "type": "timelineDetail", "payload": "545b758a-2ac1-451b-8833-b13d65fXXXa" }, "attributes": [], "month": "2020-04" } }, { "type": "timelineEvent", "data": { "id": "bec315b7-0a19-4ce3-8ff1-9b3xxxxcf", "timestamp": 1607589791720, "icon": "https://assets.traderepublic.com/img/icon/timeline/Arrow-Left.png", "title": "SAP", "body": "Verkauf zu 102,24 €\nRendite:  4,51 %", "cashChangeAmount": 1616.49, "action": { "type": "timelineDetail", "payload": "bec315b7-0a19-4ce3-8ff1-9b3xxxxcf" }, "attributes": [ { "location": 29, "length": 8, "type": "positiveChange" } ], "month": "2020-12" } }, { "type": "timelineEvent", "data": { "id": "b54f20fc-02df-4cd3-8e18-37XXX2b", "timestamp": 1703767141427, "icon": "https://assets.traderepublic.com/img/icon/timeline/Dividend.png", "title": "Hamborner Reit", "body": "Gutschrift Dividende pro Aktie von 0,136794 EUR", "cashChangeAmount": 2.74, "action": { "type": "timelineDetail", "payload": "b54f20fc-02df-4cd3-8e18-3XXX52b" }, { "type": "timelineEvent", "data": { "id": "5990492e-0a51-465d-8882-5XXXXXf", "timestamp": 1607589865000, "icon": "https://assets.traderepublic.com/img/icon/timeline/Arrow-Right.png", "title": "Call @200.00 $ Tesla Optionsschein", "body": "Kauf zu 20,58 €", "cashChangeAmount": -124.48, "action": { "type": "timelineDetail", "payload": "5990492e-0a51-465d-8882-5XXXXXf" }, "attributes": [], "month": "2020-12" } }, "attributes": [], "month": "2023-12" } }, { "type": "timelineEvent", "data": { "id": "18dccf0a-ef44-4624-85f2-946d1XXX9", "timestamp": 1585809353353, "icon": "https://assets.traderepublic.com/img/icon/timeline/Arrow-Right.png", "title": "Nutanix", "body": "Limit Kauf zu 13,758 €", "cashChangeAmount": -97.31, "action": { "type": "timelineDetail", "payload": "18dccf0a-ef44-4624-85f2-946dXXX" }, "attributes": [], "month": "2020-04" } }, { "type": "timelineEvent", "data": { "id": "2d4f8d88-f313-46b6-922c-7e2337XXX5", "timestamp": 1585809839592, "icon": "https://assets.traderepublic.com/img/icon/timeline/Cross.png", "title": "Nutanix", "body": "Limit Kauf-Order storniert", "action": { "type": "timelineDetail", "payload": "2d4f8d88-f313-46b6-922c-7e2337XXXX" }, "attributes": [], "month": "2020-04" } }, { "type": "timelineEvent", "data": { "id": "419fa9a9-260c-4d68-87ba-f0742XXX1f", "timestamp": 1704208164781, "icon": "https://assets.traderepublic.com/img/icon/timeline/SavingsPlanExecuted.png", "title": "Core MSCI World USD (Acc)", "body": "Sparplan ausgeführt zu 82,164 €", "cashChangeAmount": -1000.0, "action": { "type": "timelineDetail", "payload": "419fa9a9-260c-4d68-87ba-f074XXXXf1f" }, "attributes": [], "month": "2024-01" } }, { "type": "timelineEvent", "data": { "id": "44b06c1b-4c67-4daf-bf51-3c65bXXXf1", "timestamp": 1704208427639, "icon": "https://assets.traderepublic.com/img/icon/timeline/SavingsPlanExecuted.png", "title": "MSCI EM USD (Acc)", "body": "Sparplan ausgeführt zu 32,808 €", "cashChangeAmount": -100.0, "action": { "type": "timelineDetail", "payload": "44b06c1b-4c67-4daf-bf51-3c6XXXf1" }, "attributes": [], "month": "2024-01" } }, { "type": "timelineEvent", "data": { "id": "081c44e6-7ae6-438d-9c4d-e93c64XXXX", "timestamp": 1704212042575, "icon": "https://assets.traderepublic.com/img/icon/timeline/SavingsPlanExecuted.png", "title": "Electric Driving Tech USD (Acc)", "body": "Sparplan ausgeführt zu 6,846 €", "cashChangeAmount": -100.0, "action": { "type": "timelineDetail", "payload": "081c44e6-7ae6-438d-9c4d-e93cXXXXX" }, "attributes": [], "month": "2024-01" } } ]

dickwolff commented 6 months ago

Thank you. However this is a JSON file. I tried converting it to CSV myself, but this could lead to a mismatch with your own export. Can you verify if the export below matches your expetations?

"type","data__id","data__timestamp","data__icon","data__title","data__body","data__cashChangeAmount","data__action__type","data__action__payload","data__attributes__location","data__attributes__length","data__attributes__type","data__month"
"timelineEvent","545b758a-2ac1-451b-8833-b1XXXXX","1585727959457","https://assets.traderepublic.com/img/icon/timeline/Document.png","Basisinformationen","Alle Informationen rund um den Wertpapierhandel","","timelineDetail","545b758a-2ac1-451b-8833-b13d65fXXXa","","","","2020-04"
"timelineEvent","bec315b7-0a19-4ce3-8ff1-9b3xxxxcf","1607589791720","https://assets.traderepublic.com/img/icon/timeline/Arrow-Left.png","SAP","Verkauf zu 102,24 €\nRendite:  4,51 %","1616.49","timelineDetail","bec315b7-0a19-4ce3-8ff1-9b3xxxxcf","29","8","positiveChange","2020-12"
"timelineEvent","b54f20fc-02df-4cd3-8e18-37XXX2b","1703767141427","https://assets.traderepublic.com/img/icon/timeline/Dividend.png","Hamborner Reit","Gutschrift Dividende pro Aktie von 0,136794 EUR","2.74","timelineDetail","b54f20fc-02df-4cd3-8e18-3XXX52b","","","",""
"timelineEvent","5990492e-0a51-465d-8882-5XXXXXf","1607589865000","https://assets.traderepublic.com/img/icon/timeline/Arrow-Right.png","Call @200.00 $ Tesla Optionsschein","Kauf zu 20,58 €","-124.48","timelineDetail","5990492e-0a51-465d-8882-5XXXXXf","","","","2020-12"
"timelineEvent","18dccf0a-ef44-4624-85f2-946d1XXX9","1585809353353","https://assets.traderepublic.com/img/icon/timeline/Arrow-Right.png","Nutanix","Limit Kauf zu 13,758 €","-97.31","timelineDetail","18dccf0a-ef44-4624-85f2-946dXXX","","","","2020-04"
"timelineEvent","2d4f8d88-f313-46b6-922c-7e2337XXX5","1585809839592","https://assets.traderepublic.com/img/icon/timeline/Cross.png","Nutanix","Limit Kauf-Order storniert","","timelineDetail","2d4f8d88-f313-46b6-922c-7e2337XXXX","","","","2020-04"
"timelineEvent","419fa9a9-260c-4d68-87ba-f0742XXX1f","1704208164781","https://assets.traderepublic.com/img/icon/timeline/SavingsPlanExecuted.png","Core MSCI World USD (Acc)","Sparplan ausgeführt zu 82,164 €","-1000.0","timelineDetail","419fa9a9-260c-4d68-87ba-f074XXXXf1f","","","","2024-01"
"timelineEvent","44b06c1b-4c67-4daf-bf51-3c65bXXXf1","1704208427639","https://assets.traderepublic.com/img/icon/timeline/SavingsPlanExecuted.png","MSCI EM USD (Acc)","Sparplan ausgeführt zu 32,808 €","-100.0","timelineDetail","44b06c1b-4c67-4daf-bf51-3c6XXXf1","","","","2024-01"
"timelineEvent","081c44e6-7ae6-438d-9c4d-e93c64XXXX","1704212042575","https://assets.traderepublic.com/img/icon/timeline/SavingsPlanExecuted.png","Electric Driving Tech USD (Acc)","Sparplan ausgeführt zu 6,846 €","-100.0","timelineDetail","081c44e6-7ae6-438d-9c4d-e93cXXXXX","","","","2024-01"
Trefex commented 1 week ago

@stefanriegel how did you get that JSON ?