{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["Übersicht","Umsätze"],"not_rendered":{"charts":0,"images":1,"macros":1,"external_links":0,"defined_names":0,"comments":0,"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":"Übersicht","index":0,"n_rows":11,"n_cols":8,"rows_kept":11,"cut":false,"hidden":false,"merged":[]}
["Finanzübersicht vom:","2018-07-18"]
[]
["UnionDepot XXXXXXXX","ISIN","Stück","Kurs","Kurswert","GuV","GuV","Rendite"]
["Wertpapier",null,null,"EUR","EUR","EUR","%","p.a. %"]
["PrivatFonds: Kontrolliert","DE000A0RPAM5",{"$f":"Umsätze!C47","v":1570.3049999999998},{"$f":"DiBaFonds(B5,\"KAG\")","v":128.99},{"$f":"C5*D5","v":202553.64194999999},{"$f":"SUM(Umsätze!E4:E47)","v":20832.081949999993},{"$f":"F5/(E5-F5)*100","v":11.463737131686518},{"$f":"XIRR(Umsätze!E4:E47,Umsätze!A4:A47)*100","v":2.5361689925193787}]
[]
[]
[]
[]
[]
[null,null,null,"Gesamt-Depotwert:",{"$f":"SUM(E5:E5)","v":202553.64194999999}]

{"sheet":"Umsätze","index":1,"n_rows":47,"n_cols":5,"rows_kept":47,"cut":false,"hidden":false,"merged":[[2,0,2,4]]}
["Datum","Buchungsart","Stück","Kurs","Wert"]
[null,null,null,"EUR","EUR"]
["PrivatFonds: Kontrolliert"]
["2013-12-06","Kauf",408.67,113.88,-46539.3]
["2013-12-06","Kauf",235.108,113.88,-26774.12]
["2013-12-06","Kauf",269.91699999999997,113.88,-30738.13]
["2014-01-06","Kauf",92.484999999999999,115.37,-10670.01]
["2014-05-16","Ausschüttung",null,null,342.1]
["2014-05-16","Steuern",null,null,-134.22999999999999]
["2014-05-16","Wiederanlage",1.7629999999999999,117.92,-207.87]
["2014-09-09","Kauf",549.947,121.83,-67000]
["2014-12-24","Verkauf Depotgebühr",-3.5000000000000003E-2,122.22,4.26]
["2014-12-24","Steuererstattung",null,null,4.74]
["2014-12-24","Depotgebühr",null,null,-9]
["2015-01-09","Steuererstattung",null,null,18.420000000000002]
["2015-01-09","Wiederanlage",0.15,122.58,-18.420000000000002]
["2015-05-15","Ausschüttung",null,null,46.74]
["2015-05-15","Steuern",null,null,-12.09]
["2015-05-15","Wiederanlage",0.27200000000000002,127.37,-34.65]
["2015-12-24","Verkauf Depotgebühr",-3.2000000000000001E-2,124.97,3.97]
["2015-12-24","Steuererstattung",null,null,5.03]
["2015-12-24","Depotgebühr",null,null,-9]
["2016-01-07","Steuererstattung",null,null,109.99]
["2016-01-07","Wiederanlage",0.879,125.2,-109.99]
["2016-05-13","Ausschüttung",null,null,405.37]
["2016-05-13","Steuern",null,null,-386.26]
["2016-05-13","Wiederanlage",0.154,124.03,-19.11]
["2016-12-24","Verkauf Depotgebühr",-7.1999999999999995E-2,127.63,9.2200000000000006]
["2016-12-24","Steuern",null,null,-0.22]
["2016-12-24","Depotgebühr",null,null,-9]
["2017-05-12","Ausschüttung",null,null,483.35]
["2017-05-12","Steuern",null,null,-458.15]
["2017-05-12","Wiederanlage",0.193,130.86000000000001,-25.2]
["2017-12-24","Verkauf Depotgebühr",-6.8000000000000005E-2,131.63,9]
["2017-12-24","Depotgebühr",null,null,-9]
["2018-01-12","Steuererstattung",null,null,343.05]
["2018-01-12","Wiederanlage",2.5870000000000002,132.62,-343.05]
["2018-05-11","Ausschüttung",null,null,1265.1500000000001]
["2018-05-11","Steuern",null,null,-176.09]
["2018-05-11","Wiederanlage",8.3870000000000005,129.85,-1089.06]
[]
[]
[]
[]
[]
[]
[{"$f":"Übersicht!B1","v":"2018-07-18"},"Aktueller Wert",{"$f":"SUM(C4:C46)","v":1570.3049999999998},{"$f":"Übersicht!D5","v":128.99},{"$f":"Übersicht!E5","v":202553.64194999999}]