{"text_format":"3","workbook":"xlsx","n_sheets":3,"sheets":["Start","Portfolio","Vermögensverteilung"],"not_rendered":{"charts":1,"images":6,"defined_names":1},"read":"whole","date_system":"1900"}

{"sheet":"Start","index":0,"n_rows":28,"n_cols":12,"rows_kept":28,"merged":[[0,1,0,12],[2,1,2,11],[6,1,6,3],[6,11,6,12],[27,2,27,4]]}
[null,"INVESTITIONS-TRACKER"]
[]
[null,"Mit dieser Vorlage für den Investitions-Tracker können Sie Ihre Investitionen und Kapitalverteilung nachverfolgen. Mit dem Excel-Datentyp \"Aktien\" wird Ihr Portfolio mit aktuellen Preisen und Details zu Ihren Anlagen auf dem neuesten Stand gehalten. Wie nachstehend beschrieben, gibt es zwei Arbeitsblätter, \"Portfolio\" und \"Kapitalverteilung\". Hinweis: Der Excel-Datentyp \"Aktien\" ist ein Feature ausschließlich für Office 365-Abonnements. "]
[]
[null,"Portfolio"]
[]
[null,"Fügen Sie Ihre Investitionen, Tickersymbole, Firmennamen oder Fonds-Namen über den Beispielen hinzu, oder fügen Sie weitere Zeilen hinzu. Wählen Sie eine Anlagenkategorie aus und geben Sie die Anzahl von Aktien ein.",{"$nulls":9},"Klicken Sie auf die Schaltfläche \"Spalte hinzufügen\", um weitere Spalten wie das Tickersymbol oder den Austausch hinzuzufügen.\n"]
{"$rows_empty":16}
[null,"Um die Daten zu aktualisieren, klicken Sie auf eine der Aktien. Klicken Sie auf der Registerkarte Daten in der Gruppe Abfragen und Verbindungen auf Alle aktualisieren, oder drücken Sie STRG +Alt + F5."]
[]
[null,"Kapitalverteilung"]
[]
[null,"Ändern Sie Kategorie und mein Ziel, um sie an Ihre Portfolioziele anzupassen.","Wenn eine Ressourcenkategorie den Schwellenwert überschreitet, werden die Beträge gelb hervorgehoben."]

{"sheet":"Portfolio","index":1,"n_rows":12,"n_cols":9,"rows_kept":12,"merged":[[0,1,0,3]]}
[null,"INVESTITIONS-TRACKER"]
[]
[null,"Portfolio"]
[]
[null,"Firma","Kategorie","Teilungen","Preis","Änderung","Änderung (%)","Portfolio %","Wert"]
[null,{"$error":"#VALUE!"},"US-Aktien",{"v":1200,"d":"1,200"},{"$f":"_FV(TablePortfolio[[#This Row],[Firma]],\"Price\")","v":{"v":235.81,"d":"235.81 €"}},{"$f":"_FV(TablePortfolio[[#This Row],[Firma]],\"Change\")","v":{"v":-4.54,"d":"-4.54 €"}},{"$f":"_FV(TablePortfolio[[#This Row],[Firma]],\"Change (%)\",TRUE)","v":{"v":-0.018889,"d":"-1.89%"}},{"$f":"IFERROR(I6/SUBTOTAL(109,TablePortfolio[Wert]),\"\")","v":{"v":0.7554602756768446,"d":"76%"}},{"$f":"D6 * E6","v":{"v":282972,"d":"282,972.00 €"}}]
[null,{"$error":"#VALUE!"},"Obligationen",{"v":1300,"d":"1,300"},{"$f":"_FV(TablePortfolio[[#This Row],[Firma]],\"Price\")","v":{"v":9.82,"d":"9.82 €"}},{"$f":"_FV(TablePortfolio[[#This Row],[Firma]],\"Change\")","v":{"v":0.09,"d":"0.09 €"}},{"$f":"_FV(TablePortfolio[[#This Row],[Firma]],\"Change (%)\",TRUE)","v":{"v":0.009250000000000001,"d":"0.93%"}},{"$f":"IFERROR(I7/SUBTOTAL(109,TablePortfolio[Wert]),\"\")","v":{"v":0.034081838059209384,"d":"3%"}},{"v":12766,"d":"12,766.00 €"}]
[null,{"$error":"#VALUE!"},"Internationale Aktien",{"v":1200,"d":"1,200"},{"$f":"_FV(TablePortfolio[[#This Row],[Firma]],\"Price\")","v":{"v":29.74,"d":"29.74 €"}},{"$f":"_FV(TablePortfolio[[#This Row],[Firma]],\"Change\")","v":{"v":-0.13,"d":"-0.13 €"}},{"$f":"_FV(TablePortfolio[[#This Row],[Firma]],\"Change (%)\",TRUE)","v":{"v":-4.352E-3,"d":"-0.44%"}},{"$f":"IFERROR(I8/SUBTOTAL(109,TablePortfolio[Wert]),\"\")","v":{"v":0.09527750561311801,"d":"10%"}},{"v":35688,"d":"35,688.00 €"}]
[null,{"$error":"#VALUE!"},"Bargeld",{"v":10000,"d":"10,000"},{"$f":"_FV(TablePortfolio[[#This Row],[Firma]],\"Price\")","v":{"v":1,"d":"1.00 €"}},{"$f":"_FV(TablePortfolio[[#This Row],[Firma]],\"Change\")","v":0},{"$f":"_FV(TablePortfolio[[#This Row],[Firma]],\"Change (%)\",TRUE)","v":{"v":0,"d":"0.00%"}},{"$f":"IFERROR(I9/SUBTOTAL(109,TablePortfolio[Wert]),\"\")","v":{"v":0.026697350821877946,"d":"3%"}},{"v":10000,"d":"10,000.00 €"}]
[null,{"$error":"#VALUE!"},"Grundbesitz",125,{"$f":"_FV(TablePortfolio[[#This Row],[Firma]],\"Price\")","v":{"v":123.48,"d":"123.48 €"}},{"$f":"_FV(TablePortfolio[[#This Row],[Firma]],\"Change\")","v":{"v":-1.81,"d":"-1.81 €"}},{"$f":"_FV(TablePortfolio[[#This Row],[Firma]],\"Change (%)\",TRUE)","v":{"v":-0.014446,"d":"-1.44%"}},{"$f":"IFERROR(I10/SUBTOTAL(109,TablePortfolio[Wert]),\"\")","v":{"v":0.04120736099356861,"d":"4%"}},{"v":15435,"d":"15,435.00 €"}]
[null,{"$error":"#VALUE!"},"Rohstoffe",100,{"$f":"_FV(TablePortfolio[[#This Row],[Firma]],\"Price\")","v":{"v":177.08,"d":"177.08 €"}},{"$f":"_FV(TablePortfolio[[#This Row],[Firma]],\"Change\")","v":{"v":-0.51,"d":"-0.51 €"}},{"$f":"_FV(TablePortfolio[[#This Row],[Firma]],\"Change (%)\",TRUE)","v":{"v":-2.872E-3,"d":"-0.29%"}},{"$f":"IFERROR(I11/SUBTOTAL(109,TablePortfolio[Wert]),\"\")","v":{"v":0.047275668835381465,"d":"5%"}},{"v":17708,"d":"17,708.00 €"}]
[null,"ERGEBNIS",{"$nulls":6},{"$f":"IFERROR(SUBTOTAL(109,TablePortfolio[Wert]), \"\")","v":{"v":374569,"d":"374,569.00 €"}}]

{"sheet":"Vermögensverteilung","index":2,"n_rows":25,"n_cols":7,"rows_kept":25,"merged":[[0,1,0,6]]}
[null,"INVESTITIONS-TRACKER"]
[]
[null,"Kapitalverteilung"]
{"$rows_empty":15}
[null,"Kategorie","Mein Ziel","Tatsächlich","Differenz","Schwellenwert","Wert"]
[null,"US-Aktien",{"v":0.55,"d":"55%"},{"$f":"IFERROR(G20/SUBTOTAL(109,TableAssetAllocation[Wert]),\"\")","v":{"v":0.7554602756768446,"d":"76%"}},{"$f":"D20 - C20","v":{"v":0.20546027567684455,"d":"20.5%"}},{"$f":"MIN(5%, $C20 * 25%)","v":{"v":0.05,"d":"5%"}},{"$f":"SUMIF(TablePortfolio[Kategorie], B20, TablePortfolio[Wert])","v":{"v":282972,"d":"282,972.00 €"}}]
[null,"Internationale Aktien",{"v":0.2,"d":"20%"},{"$f":"IFERROR(G21/SUBTOTAL(109,TableAssetAllocation[Wert]),\"\")","v":{"v":0.09527750561311801,"d":"10%"}},{"v":-0.104722494386882,"d":"-10.5%"},{"v":0.05,"d":"5%"},{"$f":"SUMIF(TablePortfolio[Kategorie], B21, TablePortfolio[Wert])","v":{"v":35688,"d":"35,688.00 €"}}]
[null,"Obligationen",{"v":0.1,"d":"10%"},{"$f":"IFERROR(G22/SUBTOTAL(109,TableAssetAllocation[Wert]),\"\")","v":{"v":0.034081838059209384,"d":"3%"}},{"v":-0.06591816194079061,"d":"-6.6%"},{"v":0.025,"d":"3%"},{"$f":"SUMIF(TablePortfolio[Kategorie], B22, TablePortfolio[Wert])","v":{"v":12766,"d":"12,766.00 €"}}]
[null,"Bargeld",{"v":0.05,"d":"5%"},{"$f":"IFERROR(G23/SUBTOTAL(109,TableAssetAllocation[Wert]),\"\")","v":{"v":0.026697350821877946,"d":"3%"}},{"v":-0.023302649178122057,"d":"-2.3%"},{"v":0.0125,"d":"1%"},{"$f":"SUMIF(TablePortfolio[Kategorie], B23, TablePortfolio[Wert])","v":{"v":10000,"d":"10,000.00 €"}}]
[null,"Grundbesitz",{"v":0.05,"d":"5%"},{"$f":"IFERROR(G24/SUBTOTAL(109,TableAssetAllocation[Wert]),\"\")","v":{"v":0.04120736099356861,"d":"4%"}},{"v":-8.792639006431395E-3,"d":"-0.9%"},{"v":0.0125,"d":"1%"},{"$f":"SUMIF(TablePortfolio[Kategorie], B24, TablePortfolio[Wert])","v":{"v":15435,"d":"15,435.00 €"}}]
[null,"Rohstoffe",{"v":0.05,"d":"5%"},{"$f":"IFERROR(G25/SUBTOTAL(109,TableAssetAllocation[Wert]),\"\")","v":{"v":0.047275668835381465,"d":"5%"}},{"v":-2.7243311646185375E-3,"d":"-0.3%"},{"v":0.0125,"d":"1%"},{"$f":"SUMIF(TablePortfolio[Kategorie], B25, TablePortfolio[Wert])","v":{"v":17708,"d":"17,708.00 €"}}]