cwo

Hallo YetAnotherBTCGeek, Ich habe zur besseren Analyse ein csv-export für Dich erstellt: "txid","refid","time","type","aclass","asset","amount","fee","balance" "LI47EH-FMCU2-FWEY4P","T666II-DWKOZ-JKN6PE","2017-03-02 21:10:58","trade","currency","XLTC",99.9301000000,0.0000000000,99.9301000000 "L6BEMW-DFICZ-4IKTA7","T666II-DWKOZ-JKN6PE","2017-03-02 21:10:58","trade","currency","ZEUR",-396.7225,1.0315,102.2460 "L6VG5L-XQ3HE-YVWGZ3","TDXX5H-45ASR-NB4EES","2017-03-02 21:14:36","trade","currency","XLTC",25.7546599400,0.0412065400,125.6435534000 "LJRD2I-ZCTNB-4NXKGW","TDXX5H-45ASR-NB4EES","2017-03-02 21:14:36","trade","currency","ZEUR",-102.2460,0.0000,0.0000 "LZYKC4-BFUZH-AYRRAN","TIIZDG-OYHVK-VXYFNQ","2017-03-10 07:42:33","trade","currency","XLTC",-125.6435500000,0.0000000000,0.0000034000 "LJQD6M-BJOKF-CWN4ZX","TIIZDG-OYHVK-VXYFNQ","2017-03-10 07:42:33","trade","currency","ZEUR",461.1118,1.1989,459.9129 "LV43JD-JKEIC-APQRB5","TH6IOK-L6NBJ-KS27D3","2017-03-13 14:00:14","trade","currency","XLTC",343.7866346400,0.0000000000,343.7866380400 "LNROYQ-HIEXX-YPHKQ7","TH6IOK-L6NBJ-KS27D3","2017-03-13 14:00:14","trade","currency","ZEUR",-1272.0106,3.3072,4317.5719 "LZIAJR-DYHZU-UMGDWZ","TBVOLU-DLFW3-R2ZFCI","2017-03-13 14:00:52","trade","currency","XLTC",2.8357865200,0.0000000000,346.6224245600 "L6SZ7H-CLAEP-5Z2CPE","TBVOLU-DLFW3-R2ZFCI","2017-03-13 14:00:52","trade","currency","ZEUR",-10.4924,0.0168,4307.0627 "LHCZRW-YHQ2V-GAE52G","TIOIK5-GLA4B-TM3MKJ","2017-03-13 14:10:06","trade","currency","XLTC",0.4482000000,0.0000000000,347.0706245600 "LYGLOP-7JIUC-CLUBQG","TIOIK5-GLA4B-TM3MKJ","2017-03-13 14:10:06","trade","currency","ZEUR",-1.6583,0.0027,4305.4017 "LKRKNH-DNHFX-AB4K4A","TDSMWH-PIWNK-MWE7TL","2017-03-13 14:18:41","trade","currency","XLTC",2.0451068700,0.0000000000,349.1157314300 "LVHRGF-IAHPJ-GIJE2L","TDSMWH-PIWNK-MWE7TL","2017-03-13 14:18:41","trade","currency","ZEUR",-7.5669,0.0121,4297.8227 "L5QGQE-Y4IHM-UTFYB3","TTVBVF-NDBBK-QWBRIY","2017-03-13 14:55:05","trade","currency","XLTC",-7.6741394900,0.0122780600,341.4293138800 "LBHHXF-LE7VW-EKJ3M7","TTVBVF-NDBBK-QWBRIY","2017-03-13 14:55:05","trade","currency","ZEUR",30.0826,0.0000,4327.9053 "LQM3B3-YQ6G5-CAQMC2","T3RJ5B-VJBS7-SSTM2R","2017-03-13 14:55:11","trade","currency","XLTC",-34.1884734700,0.0547015300,307.1861388800 "LXEKIK-UEFXB-IVBEKA","T3RJ5B-VJBS7-SSTM2R","2017-03-13 14:55:11","trade","currency","ZEUR",134.0188,0.0000,4461.9241 "LT2HPY-DAYPK-BNR63C","TAFWVP-444BM-H4HUY6","2017-03-13 14:55:17","trade","currency","XLTC",-7.6741394900,0.0122780600,299.4997213300 "LNGRGY-DX3H5-ASWSU6","TAFWVP-444BM-H4HUY6","2017-03-13 14:55:17","trade","currency","ZEUR",30.0826,0.0000,4492.0067 "LMBFIT-QKEAA-QFP7GV","TFLY5N-R5OBW-HXDE5S","2017-03-13 14:55:27","trade","currency","XLTC",-6.6641327800,0.0106632600,292.8249252900 "LJ27J3-ASQFL-VAQCBS","TFLY5N-R5OBW-HXDE5S","2017-03-13 14:55:27","trade","currency","ZEUR",26.1234,0.0000,4518.1301 "LG55CX-UIBGA-YEWSRW","TXRZ5S-VR4GM-3O77KH","2017-03-13 14:55:36","trade","currency","XLTC",-292.8249252900,0.0000000000,0.0000000000 "LHFH54-YPVVB-FOFXQA","TXRZ5S-VR4GM-3O77KH","2017-03-13 14:55:36","trade","currency","ZEUR",1147.8737,1.8366,5664.1672 "LJCK6F-43FGX-INXHUG","THNSZ4-NSHF4-T32T4Z","2017-03-13 15:02:00","trade","currency","XLTC",204.7731215100,0.0000000000,204.7731215100 "LZNSW3-KQJ27-YB7VDU","THNSZ4-NSHF4-T32T4Z","2017-03-13 15:02:00","trade","currency","ZEUR",-812.0360,2.1113,4850.0199 "LPBQ4N-A2SO5-QO7FLX","TVUBTJ-FTM3O-QU2YQL","2017-03-13 15:02:08","trade","currency","XLTC",0.1519000000,0.0000000000,204.9250215100 "LYBZSO-SBHLA-IUQU4G","TVUBTJ-FTM3O-QU2YQL","2017-03-13 15:02:08","trade","currency","ZEUR",-0.6030,0.0010,4849.4159 "LI5RDG-FQAF7-LY22XJ","TW3QM4-F6R5Q-G57JI2","2017-03-13 15:14:06","trade","currency","XLTC",-197.4419419700,0.5159175000,6.9671620400 "LSECNA-WRZJH-DWD76F","TW3QM4-F6R5Q-G57JI2","2017-03-13 15:14:06","trade","currency","ZEUR",810.9809,0.0000,5660.3968 "LR34RS-35WCL-LHH7S7","TWEFZD-UZOXP-JD3ECM","2017-03-13 15:14:12","trade","currency","XLTC",-6.9671620400,0.0000000000,0.0000000000 "LJJZGK-4Q6KF-ISUGXE","TWEFZD-UZOXP-JD3ECM","2017-03-13 15:14:12","trade","currency","ZEUR",28.4957,0.0456,5688.8469 "LWZU4F-NJN6K-BEJSJV","TFTLHL-ONSIH-A6WTWQ","2017-03-13 15:18:36","trade","currency","XLTC",171.4800000000,0.0000000000,171.4800000000 "LHVVF4-KMQ4K-MAHJEL","TFTLHL-ONSIH-A6WTWQ","2017-03-13 15:18:36","trade","currency","ZEUR",-714.6463,1.8581,4972.3425 "L54PAT-CFWJZ-VSE3MG","TPBH3Q-3M5SS-PDZWWK","2017-03-13 15:18:36","trade","currency","XLTC",72.9210060000,0.0000000000,244.4010060000 "LO5GEB-7FZW7-NFSXTG","TPBH3Q-3M5SS-PDZWWK","2017-03-13 15:18:36","trade","currency","ZEUR",-303.9005,0.7901,4667.6519 "LP2L34-V4SP5-K4AKGT","TSQUSK-VFRC4-QZPLXY","2017-03-13 15:18:36","trade","currency","XLTC",24.4686031100,0.0000000000,268.8696091100 "LR3ARK-WZD4V-4KCVBX","TSQUSK-VFRC4-QZPLXY","2017-03-13 15:18:36","trade","currency","ZEUR",-102.0001,0.2652,4565.3866 "LPSJK4-QFOJZ-INA4RR","THFD7G-7YC5B-HARCPG","2017-03-13 15:18:46","trade","currency","XLTC",31.1303908900,0.0000000000,300.0000000000 "LG4GH5-F6QEA-N3FWLB","THFD7G-7YC5B-HARCPG","2017-03-13 15:18:46","trade","currency","ZEUR",-129.8137,0.2077,4435.3652 "LJ2ARR-5VIEK-DCFE5M","TSTQ6G-CJ7FC-2WSNIW","2017-03-13 15:29:22","trade","currency","XLTC",-135.9409000000,0.0000000000,164.0591000000 "LP7F3E-KUVHU-REG2KJ","TSTQ6G-CJ7FC-2WSNIW","2017-03-13 15:29:22","trade","currency","ZEUR",564.1547,1.4668,4998.0531 "L5SGJ7-R54MW-YTQM54","TCDFB6-75WQC-FCN467","2017-03-13 15:29:22","trade","currency","XLTC",-164.0591000000,0.0000000000,0.0000000000 "L7YPWQ-6XIWN-OQ2RPK","TCDFB6-75WQC-FCN467","2017-03-13 15:29:22","trade","currency","ZEUR",675.9235,1.7574,5672.2192 Nach dem Import sollte die LTC Balance auf 0.00 stehen, es verbleiben aber 0,60583841 im Bestand. Die Gebühren werden mit 0,64704495 berechnet, was korrekt aussieht. Noch ein paar kleine Anmerkungen: Der Kauf incl. Gebühr wird korrekt gebucht: "L6VG5L-XQ3HE-YVWGZ3","TDXX5H-45ASR-NB4EES","2017-03-02 21:14:36","trade","currency","XLTC",25.7546599400,0.0412065400,125.6435534000 Hier wird die kaufende Balance wie folgt erhöht: 99,9301 (vom vorherigen Eintrag) + 25,7546599400 =125,6435534 (balance) Die Verkäufte incl. Gebühr hingegen führen zu dem Überschuss an Bestand. z.B. dieser hier: "LT2HPY-DAYPK-BNR63C","TAFWVP-444BM-H4HUY6","2017-03-13 14:55:17","trade","currency","XLTC",-7.6741394900,0.0122780600,299.4997213300 Hier wird die verkaufende Balance wie folgt verkleinert: 307,18613888 (vom vorherigen Eintrag) - 7,6741394900 - 0.0122780600 (Gebühren) = 299,4997213300 (balance) Intern scheint Kraken also die Gebühren beim Kauf (nach dem Kauf zu verbuchen) und beim Verkauf nehmen sie erst die Gebühren und dann den Rest. Könnte zumindest eine Erklärung sein, warum die Einträge nicht symetrisch sind. Viele Grüße cwo

Es gibt ein zweites Problem, das beim Import der Kraken-Daten auftritt: ein Ledger-Eintrag, der nur eine einzige Seite hat. Ganz selten scheint Kraken so kleine Summen zu haben, dass auf der Gegenseite 0 verbucht wird. Dann fehlt die Gegenbuchung in den Ledgers. Das führt beim Import zu einem Abbruch. Ich musste das XML manuell anpassen, damit es durchläuft. Ein API-Import ist damit nicht möglich. Hier der Beispielauszug aus dem XML: "txid" ,"refid" ,"time" ,"type" ,"aclass" ,"asset","amount" ,"fee" "L2FVH7-LSCBH-RAYLLK","TMA3QN-KP22B-ZCFEK3" ,"2017-08-14 09:04:03","trade" ,"currency","XXBT" ,0.0141752500 ,0.0000000000 "LQIJ5J-66KA7-GMJ622","TMA3QN-KP22B-ZCFEK3" ,"2017-08-14 09:04:03","trade" ,"currency","ZUSD" ,-58.5580 ,0.0351 "L3MMQV-VX42Z-A32U23","TBFPUW-4726W-DONWFU" ,"2017-08-14 09:04:13","trade" ,"currency","XXBT" ,0.0000000100 ,0.0000000000 "LBJ3IE-TBV6S-GPNZOQ","TCN75L-NOWJA-WV2CBG" ,"2017-08-14 09:04:13","trade" ,"currency","XXBT" ,0.2493742900 ,0.0000000000 "LIF6KI-NH3QC-Y5LZMR","TCN75L-NOWJA-WV2CBG" ,"2017-08-14 09:04:13","trade" ,"currency","ZUSD" ,-1030.1652 ,0.6181 Der L3MMQV-VX42Z-A32U23/TBFPUW-4726W-DONWFU ist als Trade markiert, hat im Ledger nur einen Eintrag - und keine Gegenbuchung (im Gegensatz zu "normalen Trades") Vermutlich ist die Gegenbuchung im Wert von 0$ erzeugt worden. Das führt aber leider zu einem Abbruch des Imports. Viele Grüße cwo

Hallo YetAnotherBTCGeek, ich habe nochmal etwas geforscht - das Problem scheint im Bereich Verkauf einer Position aufzutreten. Das Kaufen fürht zu einer korrekten Summe, beim Verkauf werden die Gebühren anscheinend nicht korrekt verbucht. Viele Grüße cwo

Hallo YetAnotherBTCGeek, ich denke, ich habe einen Fehler in der aktuellen Version (0.9.3) beim Kraken-Import gefunden, denn die Ein/Ausgänge werden nicht korrekt eingebucht. Es bleibt immer eine Differenz offen zu der Berechnung im Kraken-Ledgers-XML. ich nehme mal folgende Zeile aus dem Ledger XML-export: "txid","refid","time","type","aclass","asset","amount","fee","balance" "L5QGQE-Y4IHM-UTFYB3","TTVBVF-NDBBK-QWBRIY","2017-03-13 14:55:05","trade","currency","XLTC",-7.6741394900,0.0122780600,341.4293138800 Daraus werden zwei Buchungen erzeugt: 9730;"13.03.2017 15:55:05";"Verkauf";"Kraken.com";"Litecoin";7,67413949;7,66186143;"Kraken.com";"Euro";30,0826;30,0826;30,0826;"L5QGQE-LBHHXF";"trade LTC";False;"" 9731;"13.03.2017 15:55:05";"Gebühr";"Kraken.com";"Litecoin";0,01227806;0,01227806;"Kraken.com";"Gebühr Litecoin";0,01227806;0;0;"L5QGQE-LBHHXF/fee";"Gebühr zu Trade Referenz L5QGQE-LBHHXF";False;"" Das sieht auf den ersten Blick korrekt aus, doch stimmt die "balance" nicht mit der bei Kraken überein. Bei der Anlage der Original-Buchung wird m.E. brutto und netto falsch berechnet. In der 9730 ist der QuellBetrag: 7,67413949 = "-7.6741394900" aus dem Ledger QuellBetragNetto: 7,66186143 = "-7.6741394900" + "0.0122780600" Gebühren Scheinbar gibt Kraken die Zahlen aber als Netto aus. Die m.E. korrekt Berechnung wäre demnach: QuellBetrag: 7.68641755 = "7.6741394900" + "0.0122780600" Gebühren = "7.68641755" QuellBetragNetto: 7,6741394900 = "-7.6741394900" aus dem Ledger Könntest du das Prüfen und das Anlegen der Buchungen anpassen? Viele Grüße cwo