Amount and price swapped in myTransactions.csv

[bufemc]

Sometimes the amount and the price is swapped, as here in the first line for Amazon. Could also be a TR bug.

Datum;Typ;Stück;amount;Wert;Gebühren;ISIN;name
..
2020-10-19;Kauf;1375.0000;2.0;2751.0;1.0;US0231351067;Amazon
2020-10-16;Verkauf;9.9783;42.36;422.68;1.0;DE0005654933;Hella
2020-10-16;Kauf;5.0000;190.32;952.6;1.0;US87918A1051;Teladoc Health Inc.Dl-001
..

Hint: this seems to happen quite often for higher prices. I have also seen this for Alphabet.

Just another blind guess: even in October 2020 Amazon was valued more likely 2750 Euros. It seems that somehow it's 2 times the value 1375 and should be instead something like ;1;2750 ..

[Zarathustra2]

hmmmm this is kinda weird. We don't do anything with the data so I assume it is a TR bug not sure

[bufemc]

Next time I connect to the TR API I should create a conditional breakpoint in case of Amazon or Alphabet (better use the ISIN) and then post here what the incoming untouched data is..

[bufemc]

When running it with the latest git version the output changed now to this:

Date;Type;Amount;Value;Price;Fees;ISIN;Name 2020-10-19;Buy;1000.0000;2.75;2751.0;1.0;US0231351067;Amazon 2020-10-16;Sell;10.0638;42.0;422.68;1.0;DE0005654933;Hella 2020-10-16;Buy;5.0084;190.0;952.6;1.0;US87918A1051;Teladoc Health Inc.Dl-001

So the column amount is still a little bit strange. I did not buy 1000 Amazon for 2.75 The other amounts are no integers, although they should be, but at least not that big deviation.

I tried to nail it down to the origin, I hope this one is it from myTimeline.json:

Amazon:
{
        "type": "timelineEvent",
        "data": {
            "id": "***",
            "timestamp": 1603116662950,
            "icon": "https://assets.traderepublic.com/img/icon/timeline/Arrow-Right.png",
            "title": "Amazon",
            "body": "Limit Buy order executed at 2,750.00 \u20ac",
            "cashChangeAmount": -2751.0,
            "action": {
                "type": "timelineDetail",
                "payload": "***"
            },
            "attributes": [],
            "month": "2020-10"
        }
    },

Teladoc:
    {
        "type": "timelineEvent",
        "data": {
            "id": "***",
            "timestamp": 1602876873451,
            "icon": "https://assets.traderepublic.com/img/icon/timeline/Arrow-Right.png",
            "title": "Teladoc Health Inc.Dl-001",
            "body": "Buy order executed at 190.32 \u20ac",
            "cashChangeAmount": -952.6,
            "action": {
                "type": "timelineDetail",
                "payload": "***"
            },
            "attributes": [],
            "month": "2020-10"
        }
    },

If helpful I could provide you my full files? I guess that we otherwise will never solve all these mysteries ,)

For the second one I would suggest this:

• cashChangeAmount - 1 = cash without fee = 952,6 - 1 = 951,6
• 951,6 / 190,32 = 5 (full integer)

For Hella I am not sure, it could be this:

    {
        "type": "timelineEvent",
        "data": {
            "id": "***",
            "timestamp": 1602878596596,
            "icon": "https://assets.traderepublic.com/img/icon/timeline/Arrow-Left.png",
            "title": "Hella",
            "body": "Sell order executed at 42.36 \u20ac\nProfit: \ufffc 0.34 %",
            "cashChangeAmount": 422.68,
            "action": {
                "type": "timelineDetail",
                "payload": "***"
            },
            "attributes": [
                {
                    "location": 39,
                    "length": 8,
                    "type": "positiveChange"
                }
            ],
            "month": "2020-10"
        }
    },