{"text_format":"3","workbook":"xlsx","n_sheets":3,"sheets":["Start","Portfolio","Activatoewijzing"],"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,"BELEGGINGENTRACKER"]
[]
[null,"Met de sjabloon Beleggingen bijhouden kunt u uw beleggingen en activatoewijzing volgen. Met het Excel-gegevenstype Aandelen blijft uw portefeuille up to date met actuele koersen en de details van uw activa. De twee werkbladen, portefeuille en activatoewijzing, worden hieronder beschreven. Opmerking: Het Excel-gegevenstype aandelen is alleen beschikbaar voor Office 365-abonnementen. "]
[]
[null,"Portfolio"]
[]
[null,"Voeg uw beleggingen, tickersymbolen, bedrijfsnamen of fondsnamen toe op de plaats van de voorbeelden, of voeg er meer toe op extra rijen. Selecteer een activacategorie en voer het aantal aandelen in.",{"$nulls":9},"Klik op de knop kolom toevoegen om extra kolommen toe te voegen, zoals tickersymbool of beurs.\n"]
{"$rows_empty":16}
[null,"Klik op een van de aandelen om de weergave te vernieuwen. Klik op het tabblad gegevens in de groep query's en verbindingen op alles vernieuwen of druk op Ctrl+Alt+F5."]
[]
[null,"Activatoewijzing"]
[]
[null,"Wijzig categorieën en mijn doel om deze aan te passen aan uw portfoliodoelen.","Wanneer een assetcategorie de drempelwaarde overschrijdt, worden de bedragen geel gemarkeerd."]

{"sheet":"Portfolio","index":1,"n_rows":12,"n_cols":9,"rows_kept":12,"merged":[[0,1,0,3]]}
[null,"BELEGGINGENTRACKER"]
[]
[null,"Portfolio"]
[]
[null,"Bedrijf","Categorie","Aandelen","Prijs","Wijziging","Wijziging (%)","Portefeuille (%)","Waarde"]
[null,{"$error":"#VALUE!"},"Amerikaanse aandelen",{"v":1200,"d":"1,200"},{"$f":"_FV(TabelPortefeuille[[#This Row],[Bedrijf]],\"Price\")","v":{"v":272.29,"d":"€ 272.29"}},{"$f":"_FV(TabelPortefeuille[[#This Row],[Bedrijf]],\"Change\")","v":{"v":-1.49,"d":"€ -1.49"}},{"$f":"_FV(TabelPortefeuille[[#This Row],[Bedrijf]],\"Change (%)\",TRUE)","v":{"v":-0.005442,"d":"-0.54%"}},{"$f":"IFERROR(I6/SUBTOTAL(109,TabelPortefeuille[Waarde]),\"\")","v":""},{"$f":"D6 * E6","v":{"v":326748,"d":"€ 326,748.00"}}]
[null,{"$error":"#VALUE!"},"Obligaties",{"v":1300,"d":"1,300"},{"$f":"_FV(TabelPortefeuille[[#This Row],[Bedrijf]],\"Price\")","v":{"v":9.72,"d":"€ 9.72"}},{"$f":"_FV(TabelPortefeuille[[#This Row],[Bedrijf]],\"Change\")","v":{"v":0.09,"d":"€ 0.09"}},{"$f":"_FV(TabelPortefeuille[[#This Row],[Bedrijf]],\"Change (%)\",TRUE)","v":{"v":0.009346,"d":"0.93%"}},{"$f":"IFERROR(I7/SUBTOTAL(109,TabelPortefeuille[Waarde]),\"\")","v":""},{"v":12636,"d":"€ 12,636.00"}]
[null,{"$error":"#VALUE!"},"Internationale aandelen",{"v":1200,"d":"1,200"},{"$f":"_FV(TabelPortefeuille[[#This Row],[Bedrijf]],\"Price\")","v":{"v":28.67,"d":"€ 28.67"}},{"$f":"_FV(TabelPortefeuille[[#This Row],[Bedrijf]],\"Change\")","v":0},{"$f":"_FV(TabelPortefeuille[[#This Row],[Bedrijf]],\"Change (%)\",TRUE)","v":{"v":0,"d":"0.00%"}},{"$f":"IFERROR(I8/SUBTOTAL(109,TabelPortefeuille[Waarde]),\"\")","v":""},{"v":34404,"d":"€ 34,404.00"}]
[null,{"$error":"#VALUE!"},"Contanten",{"v":10000,"d":"10,000"},{"$f":"_FV(TabelPortefeuille[[#This Row],[Bedrijf]],\"Price\")","v":{"$error":"#VALUE!"}},{"$f":"_FV(TabelPortefeuille[[#This Row],[Bedrijf]],\"Change\")","v":{"$error":"#VALUE!"}},{"$f":"_FV(TabelPortefeuille[[#This Row],[Bedrijf]],\"Change (%)\",TRUE)","v":{"$error":"#VALUE!"}},{"$f":"IFERROR(I9/SUBTOTAL(109,TabelPortefeuille[Waarde]),\"\")","v":""},{"$error":"#VALUE!"}]
[null,{"$error":"#VALUE!"},"Onroerend goed",125,{"$f":"_FV(TabelPortefeuille[[#This Row],[Bedrijf]],\"Price\")","v":{"v":110.69,"d":"€ 110.69"}},{"$f":"_FV(TabelPortefeuille[[#This Row],[Bedrijf]],\"Change\")","v":{"v":-4.25,"d":"€ -4.25"}},{"$f":"_FV(TabelPortefeuille[[#This Row],[Bedrijf]],\"Change (%)\",TRUE)","v":{"v":-0.036976,"d":"-3.70%"}},{"$f":"IFERROR(I10/SUBTOTAL(109,TabelPortefeuille[Waarde]),\"\")","v":""},{"v":13836.25,"d":"€ 13,836.25"}]
[null,{"$error":"#VALUE!"},"Grondstoffen",100,{"$f":"_FV(TabelPortefeuille[[#This Row],[Bedrijf]],\"Price\")","v":{"v":183.44,"d":"€ 183.44"}},{"$f":"_FV(TabelPortefeuille[[#This Row],[Bedrijf]],\"Change\")","v":{"v":3.07,"d":"€ 3.07"}},{"$f":"_FV(TabelPortefeuille[[#This Row],[Bedrijf]],\"Change (%)\",TRUE)","v":{"v":0.017020999999999998,"d":"1.70%"}},{"$f":"IFERROR(I11/SUBTOTAL(109,TabelPortefeuille[Waarde]),\"\")","v":""},{"v":18344,"d":"€ 18,344.00"}]
[null,"Totaal",{"$nulls":6},{"$f":"IFERROR(SUBTOTAL(109,TabelPortefeuille[Waarde]), \"\")","v":""}]

{"sheet":"Activatoewijzing","index":2,"n_rows":25,"n_cols":7,"rows_kept":25,"merged":[[0,1,0,6]]}
[null,"BELEGGINGENTRACKER"]
[]
[null,"Activatoewijzing"]
{"$rows_empty":15}
[null,"Categorie","Mijn doel","Werkelijk","Verschil","Drempel","Waarde"]
[null,"Amerikaanse aandelen",{"v":0.55,"d":"55%"},{"$f":"IFERROR(G20/SUBTOTAL(109,TabelActivaToewijzing[Waarde]),\"\")","v":""},{"$f":"D20 - C20","v":{"$error":"#VALUE!"}},{"$f":"MIN(5%, $C20 * 25%)","v":{"v":0.05,"d":"5%"}},{"$f":"SUMIF(TabelPortefeuille[Categorie], B20, TabelPortefeuille[Waarde])","v":{"v":326748,"d":"€ 326,748.00"}}]
[null,"Internationale aandelen",{"v":0.2,"d":"20%"},{"$f":"IFERROR(G21/SUBTOTAL(109,TabelActivaToewijzing[Waarde]),\"\")","v":""},{"$error":"#VALUE!"},{"v":0.05,"d":"5%"},{"$f":"SUMIF(TabelPortefeuille[Categorie], B21, TabelPortefeuille[Waarde])","v":{"v":34404,"d":"€ 34,404.00"}}]
[null,"Obligaties",{"v":0.1,"d":"10%"},{"$f":"IFERROR(G22/SUBTOTAL(109,TabelActivaToewijzing[Waarde]),\"\")","v":""},{"$error":"#VALUE!"},{"v":0.025,"d":"3%"},{"$f":"SUMIF(TabelPortefeuille[Categorie], B22, TabelPortefeuille[Waarde])","v":{"v":12636,"d":"€ 12,636.00"}}]
[null,"Contanten",{"v":0.05,"d":"5%"},{"$f":"IFERROR(G23/SUBTOTAL(109,TabelActivaToewijzing[Waarde]),\"\")","v":""},{"$error":"#VALUE!"},{"v":0.0125,"d":"1%"},{"$f":"SUMIF(TabelPortefeuille[Categorie], B23, TabelPortefeuille[Waarde])","v":{"$error":"#VALUE!"}}]
[null,"Onroerend goed",{"v":0.05,"d":"5%"},{"$f":"IFERROR(G24/SUBTOTAL(109,TabelActivaToewijzing[Waarde]),\"\")","v":""},{"$error":"#VALUE!"},{"v":0.0125,"d":"1%"},{"$f":"SUMIF(TabelPortefeuille[Categorie], B24, TabelPortefeuille[Waarde])","v":{"v":13836.25,"d":"€ 13,836.25"}}]
[null,"Grondstoffen",{"v":0.05,"d":"5%"},{"$f":"IFERROR(G25/SUBTOTAL(109,TabelActivaToewijzing[Waarde]),\"\")","v":""},{"$error":"#VALUE!"},{"v":0.0125,"d":"1%"},{"$f":"SUMIF(TabelPortefeuille[Categorie], B25, TabelPortefeuille[Waarde])","v":{"v":18344,"d":"€ 18,344.00"}}]