Include TradeRepublic

[stefanriegel]

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

[dickwolff]

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]

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]

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]

@stefanriegel how did you get that JSON ?