{"text_format":"1","workbook":"xlsx","n_sheets":1,"sheets":["comdirect DEPOT"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":1,"comments":1,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"comdirect DEPOT","index":0,"n_rows":300,"n_cols":21,"rows_kept":300,"cut":false,"hidden":false,"merged":[[0,0,0,5],[2,0,2,8],[2,10,2,19],[0,7,0,17],[0,20,0,23]]}
["comdirect DEPOT .csv Konverter © by facetto",null,null,null,null,null,null,"Keine Änderungen an der linken Tabelle vornehmen!\nKommentare in einigen Zellen beachten.\nMakros müssen aktiviert sein.",null,null,null,null,null,null,null,null,null,null,null,null,"To Do: Informationen aus den Kontoumsätzen ebenfalls nutzen, um die fehlenden Infos zur Besteuerung von Verkäufen einzutragen"]
[]
["2. Ergebnisse hier unten auf evtl. Fehlermeldungen prüfen, dann geht’s rechts weiter mit Punkt 3\n4. per Klick auf \"von A bis Z sortieren\" im Feld \"Datum\" eventuell entstandene leere Zeilen nach unten verschieben\n5. entsprechende Schaltfläche \".csv Datei generieren\" drücken; in der erscheinenden .csv Datei können nun bei Bedarf beliebige Korrekturen vorgenommen werden, z.B. im Feld Steuern.\n6. Abspeichern, evtl. Kompatibilitätshinweis bestätigen und  in PP als \"Depotumsätze\" importieren",null,null,null,null,null,null,null,null,null,"1. In den grauen Rahmen unten die Depotumsätze aus der von der Bankwebsite exportierten .csv Datei einfügen, dann geht’s links weiter mit Punkt 2\n3. Hier rechts Korrekturen vornehmen (Inhalte einzelner Zeilen von L bis S löschen, die nicht importiert werden sollen; Texte anpassen; Werte ändern etc.; die Felder der linken Tabelle dürfen in dieser Arbeitsmappe noch nicht korrigiert werden!), dann geht’s links weiter"]
[]
["Datum","Typ","Wertpapiername","WKN","Stück","Wert","Gebühren","Steuern","Buchungswährung",null,null,"Buchungstag","Geschäftstag","Stück / Nom.","Bezeichnung","WKN","Währung","Ausführungskurs","Umsatz in EUR"]
[{"$f":"IF(L6=\"\",\"\",L6)","v":"2016-05-19"},{"$f":"IF(S6=\"\",\"\",IF(S6>0,\"Kauf\",IF(S6=0,\"UMSATZ PRÜFEN\",\"Verkauf\")))","v":"Kauf"},{"$f":"IF(O6=\"\",\"\",O6)","v":"Pipi Langstrumpf AG"},{"$f":"IF(P6=\"\",\"\",P6)","v":666666},{"$f":"IF(N6=\"\",\"\",IF(N6<0,-N6,N6))","v":249},{"$f":"IF(S6=\"\",\"\",IF(N6<0,-S6,S6))","v":2500},{"$f":"IF(S6=\"\",\"\",IF(S6=0,0,S6-N6*R6))","v":10},{"$f":"IF(B6=\"Kauf\",0,IF(B6=\"\",\"\",\"x\"))","v":0},{"$f":"IF(Q6=\"\",\"\",Q6)","v":"EUR"},null,null,"2016-05-19","2016-05-17",249,"Pipi Langstrumpf AG",666666,"EUR",10,2500]
["2016-05-25","Kauf","Pipi Langstrumpf AG",666666,11,115,5,0,"EUR",null,null,"2016-05-25","2016-05-23",11,"Pipi Langstrumpf AG",666666,"EUR",10,115]
["2016-10-25","Verkauf","Pipi Langstrumpf AG",666666,10,100,10,"x","EUR",null,null,"2016-10-25","2016-10-23",-10,"Pipi Langstrumpf AG",666666,"EUR",11,-100]
["","","","","","","","",""]
["","","","","","","","",""]
["","","","","","","","",""]
["","","","","","","","",""]
["","","","","","","","",""]
["","","","","","","","",""]
["","","","","","","","",""]
["","","","","","","","",""]
["","","","","","","","",""]
["","","","","","","","",""]
["","","","","","","","",""]
["","","","","","","","",""]
["","","","","","","","",""]
["","","","","","","","",""]
["","","","","","","","",""]
["","","","","","","","",""]
["","","","","","","","",""]
["","","","","","","","",""]
["","","","","","","","",""]
["","","","","","","","",""]
["","","","","","","","",""]
["","","","","","","","",""]
["","","","","","","","",""]
["","","","","","","","",""]
["","","","","","","","",""]
["","","","","","","","",""]
["","","","","","","","",""]
["","","","","","","","",""]
["","","","","","","","",""]
["","","","","","","","",""]
["","","","","","","","",""]
["","","","","","","","",""]
["","","","","","","","",""]
["","","","","","","","",""]
["","","","","","","","",""]
["","","","","","","","",""]
["","","","","","","","",""]
["","","","","","","","",""]
["","","","","","","","",""]
["","","","","","","","",""]
["","","","","","","","",""]
["","","","","","","","",""]
["","","","","","","","",""]
["","","","","","","","",""]
["","","","","","","","",""]
["","","","","","","","",""]
["","","","","","","","",""]
["","","","","","","","",""]
["","","","","","","","",""]
["","","","","","","","",""]
["","","","","","","","",""]
["","","","","","","","",""]
["","","","","","","","",""]
["","","","","","","","",""]
["","","","","","","","",""]
["","","","","","","","",""]
["","","","","","","","",""]
["","","","","","","","",""]
["","","","","","","","",""]
["","","","","","","","",""]
["","","","","","","","",""]
[{"$f":"IF(L70=\"\",\"\",L70)","v":""},{"$f":"IF(S70=\"\",\"\",IF(S70>0,\"Kauf\",IF(S70=0,\"UMSATZ PRÜFEN\",\"Verkauf\")))","v":""},{"$f":"IF(O70=\"\",\"\",O70)","v":""},{"$f":"IF(P70=\"\",\"\",P70)","v":""},{"$f":"IF(N70=\"\",\"\",IF(N70<0,-N70,N70))","v":""},{"$f":"IF(S70=\"\",\"\",IF(N70<0,-S70,S70))","v":""},{"$f":"IF(S70=\"\",\"\",IF(S70=0,0,S70-N70*R70))","v":""},{"$f":"IF(B70=\"Kauf\",0,IF(B70=\"\",\"\",\"x\"))","v":""},{"$f":"IF(Q70=\"\",\"\",Q70)","v":""}]
["","","","","","","","",""]
["","","","","","","","",""]
["","","","","","","","",""]
["","","","","","","","",""]
["","","","","","","","",""]
["","","","","","","","",""]
["","","","","","","","",""]
["","","","","","","","",""]
["","","","","","","","",""]
["","","","","","","","",""]
["","","","","","","","",""]
["","","","","","","","",""]
["","","","","","","","",""]
["","","","","","","","",""]
["","","","","","","","",""]
["","","","","","","","",""]
["","","","","","","","",""]
["","","","","","","","",""]
["","","","","","","","",""]
["","","","","","","","",""]
["","","","","","","","",""]
["","","","","","","","",""]
["","","","","","","","",""]
["","","","","","","","",""]
["","","","","","","","",""]
["","","","","","","","",""]
["","","","","","","","",""]
["","","","","","","","",""]
["","","","","","","","",""]
["","","","","","","","",""]
["","","","","","","","",""]
["","","","","","","","",""]
["","","","","","","","",""]
["","","","","","","","",""]
["","","","","","","","",""]
["","","","","","","","",""]
["","","","","","","","",""]
["","","","","","","","",""]
["","","","","","","","",""]
["","","","","","","","",""]
["","","","","","","","",""]
["","","","","","","","",""]
["","","","","","","","",""]
["","","","","","","","",""]
["","","","","","","","",""]
["","","","","","","","",""]
["","","","","","","","",""]
["","","","","","","","",""]
["","","","","","","","",""]
["","","","","","","","",""]
["","","","","","","","",""]
["","","","","","","","",""]
["","","","","","","","",""]
["","","","","","","","",""]
["","","","","","","","",""]
["","","","","","","","",""]
["","","","","","","","",""]
["","","","","","","","",""]
["","","","","","","","",""]
["","","","","","","","",""]
["","","","","","","","",""]
["","","","","","","","",""]
["","","","","","","","",""]
[{"$f":"IF(L134=\"\",\"\",L134)","v":""},{"$f":"IF(S134=\"\",\"\",IF(S134>0,\"Kauf\",IF(S134=0,\"UMSATZ PRÜFEN\",\"Verkauf\")))","v":""},{"$f":"IF(O134=\"\",\"\",O134)","v":""},{"$f":"IF(P134=\"\",\"\",P134)","v":""},{"$f":"IF(N134=\"\",\"\",IF(N134<0,-N134,N134))","v":""},{"$f":"IF(S134=\"\",\"\",IF(N134<0,-S134,S134))","v":""},{"$f":"IF(S134=\"\",\"\",IF(S134=0,0,S134-N134*R134))","v":""},{"$f":"IF(B134=\"Kauf\",0,IF(B134=\"\",\"\",\"x\"))","v":""},{"$f":"IF(Q134=\"\",\"\",Q134)","v":""}]
["","","","","","","","",""]
["","","","","","","","",""]
["","","","","","","","",""]
["","","","","","","","",""]
["","","","","","","","",""]
["","","","","","","","",""]
["","","","","","","","",""]
["","","","","","","","",""]
["","","","","","","","",""]
["","","","","","","","",""]
["","","","","","","","",""]
["","","","","","","","",""]
["","","","","","","","",""]
["","","","","","","","",""]
["","","","","","","","",""]
["","","","","","","","",""]
["","","","","","","","",""]
["","","","","","","","",""]
["","","","","","","","",""]
["","","","","","","","",""]
["","","","","","","","",""]
["","","","","","","","",""]
["","","","","","","","",""]
["","","","","","","","",""]
["","","","","","","","",""]
["","","","","","","","",""]
["","","","","","","","",""]
["","","","","","","","",""]
["","","","","","","","",""]
["","","","","","","","",""]
["","","","","","","","",""]
["","","","","","","","",""]
["","","","","","","","",""]
["","","","","","","","",""]
["","","","","","","","",""]
["","","","","","","","",""]
["","","","","","","","",""]
["","","","","","","","",""]
["","","","","","","","",""]
["","","","","","","","",""]
["","","","","","","","",""]
["","","","","","","","",""]
["","","","","","","","",""]
["","","","","","","","",""]
["","","","","","","","",""]
["","","","","","","","",""]
["","","","","","","","",""]
["","","","","","","","",""]
["","","","","","","","",""]
["","","","","","","","",""]
["","","","","","","","",""]
["","","","","","","","",""]
["","","","","","","","",""]
["","","","","","","","",""]
["","","","","","","","",""]
["","","","","","","","",""]
["","","","","","","","",""]
["","","","","","","","",""]
["","","","","","","","",""]
["","","","","","","","",""]
["","","","","","","","",""]
["","","","","","","","",""]
["","","","","","","","",""]
[{"$f":"IF(L198=\"\",\"\",L198)","v":""},{"$f":"IF(S198=\"\",\"\",IF(S198>0,\"Kauf\",IF(S198=0,\"UMSATZ PRÜFEN\",\"Verkauf\")))","v":""},{"$f":"IF(O198=\"\",\"\",O198)","v":""},{"$f":"IF(P198=\"\",\"\",P198)","v":""},{"$f":"IF(N198=\"\",\"\",IF(N198<0,-N198,N198))","v":""},{"$f":"IF(S198=\"\",\"\",IF(N198<0,-S198,S198))","v":""},{"$f":"IF(S198=\"\",\"\",IF(S198=0,0,S198-N198*R198))","v":""},{"$f":"IF(B198=\"Kauf\",0,IF(B198=\"\",\"\",\"x\"))","v":""},{"$f":"IF(Q198=\"\",\"\",Q198)","v":""}]
["","","","","","","","",""]
["","","","","","","","",""]
["","","","","","","","",""]
["","","","","","","","",""]
["","","","","","","","",""]
["","","","","","","","",""]
["","","","","","","","",""]
["","","","","","","","",""]
["","","","","","","","",""]
["","","","","","","","",""]
["","","","","","","","",""]
["","","","","","","","",""]
["","","","","","","","",""]
["","","","","","","","",""]
["","","","","","","","",""]
["","","","","","","","",""]
["","","","","","","","",""]
["","","","","","","","",""]
["","","","","","","","",""]
["","","","","","","","",""]
["","","","","","","","",""]
["","","","","","","","",""]
["","","","","","","","",""]
["","","","","","","","",""]
["","","","","","","","",""]
["","","","","","","","",""]
["","","","","","","","",""]
["","","","","","","","",""]
["","","","","","","","",""]
["","","","","","","","",""]
["","","","","","","","",""]
["","","","","","","","",""]
["","","","","","","","",""]
["","","","","","","","",""]
["","","","","","","","",""]
["","","","","","","","",""]
["","","","","","","","",""]
["","","","","","","","",""]
["","","","","","","","",""]
["","","","","","","","",""]
["","","","","","","","",""]
["","","","","","","","",""]
["","","","","","","","",""]
["","","","","","","","",""]
["","","","","","","","",""]
["","","","","","","","",""]
["","","","","","","","",""]
["","","","","","","","",""]
["","","","","","","","",""]
["","","","","","","","",""]
["","","","","","","","",""]
["","","","","","","","",""]
["","","","","","","","",""]
["","","","","","","","",""]
["","","","","","","","",""]
["","","","","","","","",""]
["","","","","","","","",""]
["","","","","","","","",""]
["","","","","","","","",""]
["","","","","","","","",""]
["","","","","","","","",""]
["","","","","","","","",""]
["","","","","","","","",""]
[{"$f":"IF(L262=\"\",\"\",L262)","v":""},{"$f":"IF(S262=\"\",\"\",IF(S262>0,\"Kauf\",IF(S262=0,\"UMSATZ PRÜFEN\",\"Verkauf\")))","v":""},{"$f":"IF(O262=\"\",\"\",O262)","v":""},{"$f":"IF(P262=\"\",\"\",P262)","v":""},{"$f":"IF(N262=\"\",\"\",IF(N262<0,-N262,N262))","v":""},{"$f":"IF(S262=\"\",\"\",IF(N262<0,-S262,S262))","v":""},{"$f":"IF(S262=\"\",\"\",IF(S262=0,0,S262-N262*R262))","v":""},{"$f":"IF(B262=\"Kauf\",0,IF(B262=\"\",\"\",\"x\"))","v":""},{"$f":"IF(Q262=\"\",\"\",Q262)","v":""}]
["","","","","","","","",""]
["","","","","","","","",""]
["","","","","","","","",""]
["","","","","","","","",""]
["","","","","","","","",""]
["","","","","","","","",""]
["","","","","","","","",""]
["","","","","","","","",""]
["","","","","","","","",""]
["","","","","","","","",""]
["","","","","","","","",""]
["","","","","","","","",""]
["","","","","","","","",""]
["","","","","","","","",""]
["","","","","","","","",""]
["","","","","","","","",""]
["","","","","","","","",""]
["","","","","","","","",""]
["","","","","","","","",""]
["","","","","","","","",""]
["","","","","","","","",""]
["","","","","","","","",""]
["","","","","","","","",""]
["","","","","","","","",""]
["","","","","","","","",""]
["","","","","","","","",""]
["","","","","","","","",""]
["","","","","","","","",""]
["","","","","","","","",""]
["","","","","","","","",""]
["","","","","","","","",""]
["","","","","","","","",""]
["","","","","","","","",""]
["","","","","","","","",""]
["","","","","","","","",""]
["","","","","","","","",""]
["","","","","","","","",""]
["","","","","","","","",""]