{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["Portefeuille","Koersen"],"not_rendered":{"charts":0,"images":2,"macros":1,"external_links":0,"defined_names":11,"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":"Portefeuille","index":0,"n_rows":82,"n_cols":28,"rows_kept":82,"cut":false,"hidden":false,"merged":[[79,0,79,7],[30,0,30,7],[6,3,6,5],[8,0,8,27]]}
["Evaluatiedatum",42319,null,"Verhoog stop-loss met",0.03]
[null,null,null,"Stop-loss bijwerken","Op vraag"]
[null,null,null,"Geselecteerde rij",20]
[]
["Portefeuilledatum",{"$f":"SUM(Fondsen[Form date Portefeuille])","v":{"$error":"#DIV/0!"}}]
["Annual portefeuille",{"$f":"IF(Evaluatiedatum-Portefeuilledatum>365, ((SUM(Fondsen[Totale waarde])/SUM(Fondsen[Totale investering in EUR]))^(365.25/(Evaluatiedatum-Portefeuilledatum))-1),\"\")","v":{"$error":"#DIV/0!"}}]
["Meerwaarde",{"$f":"SUM(Fondsen[Totale waarde])-SUM(Fondsen[Totale investering in EUR])","v":0},null,"Franky-Matic v1.8"]
[]
["FONDSEN"]
["ISIN","Beheerder","Naam Fonds","Categorie","K/S","Huidige Waarde","Munt","Huidige waarde in EUR","90%","R ST LOSS","CTR ST L","ACTIE","Totale investering in EUR","Totale waarde","Aantal","Meerwaarde bedrag","Meerwaarde %","Participatie investering","Totale aankoop in EUR","Form date Fonds","Form date Portefeuille","Form date Visible","Annual","Vorige totale waarde","Vorige waarde in EUR","+/-","Broker","Laatste update RSL"]
["LU0231490524","Aberdeen","Aberdeen Global - Ind. Equity A2","aandelen India",null,121.81,"USD",{"$f":"Fondsen[[#This Row],[Huidige Waarde]]/VLOOKUP(Fondsen[[#This Row],[Munt]],Koersen[],2,FALSE)","v":112.83927744326078},{"$f":"Fondsen[[#This Row],[Huidige waarde in EUR]]*0.9","v":101.55534969893471},104.42922,{"$f":"[90%]-[R ST LOSS]","v":-2.8738703010652955},{"$f":"(Fondsen[[#This Row],[Huidige waarde in EUR]]-Fondsen[[#This Row],[R ST LOSS]])/Fondsen[[#This Row],[Huidige waarde in EUR]]","v":7.4531294721287361E-2},{"$f":"SUM(IF(Fondsen[[#This Row],[ISIN]]=TransactiesIn[ISIN],TransactiesIn[Investering in EUR]))-SUM(IF(Fondsen[[#This Row],[ISIN]]=TransactiesOut[ISIN],TransactiesOut[Opbrengst in EUR]))","v":0},{"$f":"[Aantal]*[Huidige waarde in EUR]","v":0},{"$f":"SUM(IF(Fondsen[[#This Row],[ISIN]]=TransactiesIn[ISIN],TransactiesIn[Aantal]))-SUM(IF(Fondsen[[#This Row],[ISIN]]=TransactiesOut[ISIN],TransactiesOut[Aantal]))","v":0},{"$f":"Fondsen[[#This Row],[Totale waarde]]-Fondsen[[#This Row],[Totale investering in EUR]]","v":0},{"$f":"(Fondsen[[#This Row],[Totale waarde]]-Fondsen[[#This Row],[Totale investering in EUR]])/ABS(Fondsen[[#This Row],[Totale investering in EUR]])","v":{"$error":"#DIV/0!"}},{"$f":"Fondsen[[#This Row],[Totale waarde]]/SUM([Totale waarde])","v":{"$error":"#DIV/0!"}},{"$f":"SUM(IF(Fondsen[[#This Row],[ISIN]]=TransactiesIn[ISIN],TransactiesIn[Investering in EUR]))","v":0},{"$f":"ROUND(SUM(IF(Fondsen[[#This Row],[ISIN]]=TransactiesIn[ISIN],(TransactiesIn[Datum Aankoop]*TransactiesIn[Investering in EUR])/Fondsen[[#This Row],[Totale aankoop in EUR]])),0)","v":0},{"$f":"ROUND(Fondsen[[#This Row],[Form date Fonds]]*Fondsen[[#This Row],[Totale investering in EUR]]/SUM([Totale investering in EUR]),0)","v":{"$error":"#DIV/0!"}},{"$f":"ROUND(Fondsen[[#This Row],[Form date Fonds]]*Fondsen[[#This Row],[Totale investering in EUR]]/Fondsen[[#Totals],[Totale investering in EUR]],0)","v":{"$error":"#DIV/0!"}},{"$f":"IF(Evaluatiedatum-Fondsen[[#This Row],[Form date Fonds]]>365, ((Fondsen[[#This Row],[Totale waarde]]/Fondsen[[#This Row],[Totale investering in EUR]])^(365.25/(Evaluatiedatum-Fondsen[[#This Row],[Form date Fonds]]))-1),\"\")","v":{"$error":"#DIV/0!"}},0,112.84973133222161,{"$f":"IF(Fondsen[[#This Row],[Vorige waarde in EUR]]<>0,  (Fondsen[[#This Row],[Huidige waarde in EUR]]-Fondsen[[#This Row],[Vorige waarde in EUR]])/Fondsen[[#This Row],[Vorige waarde in EUR]],0)","v":-9.2635479388510804E-5},"KEY",42318]
["LU0119133188","Amundi","Amundi Lu Amu Funds Glob Bond","oblg. Wld",null,25.39,"USD",{"$f":"Fondsen[[#This Row],[Huidige Waarde]]/VLOOKUP(Fondsen[[#This Row],[Munt]],Koersen[],2,FALSE)","v":23.520148216767023},{"$f":"Fondsen[[#This Row],[Huidige waarde in EUR]]*0.9","v":21.168133395090322},21.514389999999999,{"$f":"[90%]-[R ST LOSS]","v":-0.34625660490967647},{"$f":"(Fondsen[[#This Row],[Huidige waarde in EUR]]-Fondsen[[#This Row],[R ST LOSS]])/Fondsen[[#This Row],[Huidige waarde in EUR]]","v":8.5278298345805525E-2},{"$f":"SUM(IF(Fondsen[[#This Row],[ISIN]]=TransactiesIn[ISIN],TransactiesIn[Investering in EUR]))-SUM(IF(Fondsen[[#This Row],[ISIN]]=TransactiesOut[ISIN],TransactiesOut[Opbrengst in EUR]))","v":0},{"$f":"[Aantal]*[Huidige waarde in EUR]","v":0},{"$f":"SUM(IF(Fondsen[[#This Row],[ISIN]]=TransactiesIn[ISIN],TransactiesIn[Aantal]))-SUM(IF(Fondsen[[#This Row],[ISIN]]=TransactiesOut[ISIN],TransactiesOut[Aantal]))","v":0},{"$f":"Fondsen[[#This Row],[Totale waarde]]-Fondsen[[#This Row],[Totale investering in EUR]]","v":0},{"$f":"(Fondsen[[#This Row],[Totale waarde]]-Fondsen[[#This Row],[Totale investering in EUR]])/ABS(Fondsen[[#This Row],[Totale investering in EUR]])","v":{"$error":"#DIV/0!"}},{"$f":"Fondsen[[#This Row],[Totale waarde]]/SUM([Totale waarde])","v":{"$error":"#DIV/0!"}},{"$f":"SUM(IF(Fondsen[[#This Row],[ISIN]]=TransactiesIn[ISIN],TransactiesIn[Investering in EUR]))","v":0},{"$f":"ROUND(SUM(IF(Fondsen[[#This Row],[ISIN]]=TransactiesIn[ISIN],(TransactiesIn[Datum Aankoop]*TransactiesIn[Investering in EUR])/Fondsen[[#This Row],[Totale aankoop in EUR]])),0)","v":0},{"$f":"ROUND(Fondsen[[#This Row],[Form date Fonds]]*Fondsen[[#This Row],[Totale investering in EUR]]/SUM([Totale investering in EUR]),0)","v":{"$error":"#DIV/0!"}},{"$f":"ROUND(Fondsen[[#This Row],[Form date Fonds]]*Fondsen[[#This Row],[Totale investering in EUR]]/Fondsen[[#Totals],[Totale investering in EUR]],0)","v":{"$error":"#DIV/0!"}},{"$f":"IF(Evaluatiedatum-Fondsen[[#This Row],[Form date Fonds]]>365, ((Fondsen[[#This Row],[Totale waarde]]/Fondsen[[#This Row],[Totale investering in EUR]])^(365.25/(Evaluatiedatum-Fondsen[[#This Row],[Form date Fonds]]))-1),\"\")","v":{"$error":"#DIV/0!"}},0,23.522327218825275,{"$f":"IF(Fondsen[[#This Row],[Vorige waarde in EUR]]<>0,  (Fondsen[[#This Row],[Huidige waarde in EUR]]-Fondsen[[#This Row],[Vorige waarde in EUR]])/Fondsen[[#This Row],[Vorige waarde in EUR]],0)","v":-9.2635479388632858E-5},"KEY",42318]
["LU0201576401","Amundi","Amun Lu Am Fds Euro Infl C","oblig  inflat Eur",null,147.29,"EUR",{"$f":"Fondsen[[#This Row],[Huidige Waarde]]/VLOOKUP(Fondsen[[#This Row],[Munt]],Koersen[],2,FALSE)","v":147.29},{"$f":"Fondsen[[#This Row],[Huidige waarde in EUR]]*0.9","v":132.56100000000001},143.68781999999999,{"$f":"[90%]-[R ST LOSS]","v":-11.126819999999981},{"$f":"(Fondsen[[#This Row],[Huidige waarde in EUR]]-Fondsen[[#This Row],[R ST LOSS]])/Fondsen[[#This Row],[Huidige waarde in EUR]]","v":2.4456378572883457E-2},{"$f":"SUM(IF(Fondsen[[#This Row],[ISIN]]=TransactiesIn[ISIN],TransactiesIn[Investering in EUR]))-SUM(IF(Fondsen[[#This Row],[ISIN]]=TransactiesOut[ISIN],TransactiesOut[Opbrengst in EUR]))","v":0},{"$f":"[Aantal]*[Huidige waarde in EUR]","v":0},{"$f":"SUM(IF(Fondsen[[#This Row],[ISIN]]=TransactiesIn[ISIN],TransactiesIn[Aantal]))-SUM(IF(Fondsen[[#This Row],[ISIN]]=TransactiesOut[ISIN],TransactiesOut[Aantal]))","v":0},{"$f":"Fondsen[[#This Row],[Totale waarde]]-Fondsen[[#This Row],[Totale investering in EUR]]","v":0},{"$f":"(Fondsen[[#This Row],[Totale waarde]]-Fondsen[[#This Row],[Totale investering in EUR]])/ABS(Fondsen[[#This Row],[Totale investering in EUR]])","v":{"$error":"#DIV/0!"}},{"$f":"Fondsen[[#This Row],[Totale waarde]]/SUM([Totale waarde])","v":{"$error":"#DIV/0!"}},{"$f":"SUM(IF(Fondsen[[#This Row],[ISIN]]=TransactiesIn[ISIN],TransactiesIn[Investering in EUR]))","v":0},{"$f":"ROUND(SUM(IF(Fondsen[[#This Row],[ISIN]]=TransactiesIn[ISIN],(TransactiesIn[Datum Aankoop]*TransactiesIn[Investering in EUR])/Fondsen[[#This Row],[Totale aankoop in EUR]])),0)","v":0},{"$f":"ROUND(Fondsen[[#This Row],[Form date Fonds]]*Fondsen[[#This Row],[Totale investering in EUR]]/SUM([Totale investering in EUR]),0)","v":{"$error":"#DIV/0!"}},{"$f":"ROUND(Fondsen[[#This Row],[Form date Fonds]]*Fondsen[[#This Row],[Totale investering in EUR]]/Fondsen[[#Totals],[Totale investering in EUR]],0)","v":{"$error":"#DIV/0!"}},{"$f":"IF(Evaluatiedatum-Fondsen[[#This Row],[Form date Fonds]]>365, ((Fondsen[[#This Row],[Totale waarde]]/Fondsen[[#This Row],[Totale investering in EUR]])^(365.25/(Evaluatiedatum-Fondsen[[#This Row],[Form date Fonds]]))-1),\"\")","v":{"$error":"#DIV/0!"}},0,147.29,{"$f":"IF(Fondsen[[#This Row],[Vorige waarde in EUR]]<>0,  (Fondsen[[#This Row],[Huidige waarde in EUR]]-Fondsen[[#This Row],[Vorige waarde in EUR]])/Fondsen[[#This Row],[Vorige waarde in EUR]],0)","v":0},"KEY",42318]
["IE00B5WHFQ43","Blackrock","iSHR Mexico tracker CMEX Cap","aandelen Mexico",null,110.99,"EUR",{"$f":"Fondsen[[#This Row],[Huidige Waarde]]/VLOOKUP(Fondsen[[#This Row],[Munt]],Koersen[],2,FALSE)","v":110.99},{"$f":"Fondsen[[#This Row],[Huidige waarde in EUR]]*0.9","v":99.890999999999991},100.89757,{"$f":"[90%]-[R ST LOSS]","v":-1.0065700000000106},{"$f":"(Fondsen[[#This Row],[Huidige waarde in EUR]]-Fondsen[[#This Row],[R ST LOSS]])/Fondsen[[#This Row],[Huidige waarde in EUR]]","v":9.0930984773402945E-2},{"$f":"SUM(IF(Fondsen[[#This Row],[ISIN]]=TransactiesIn[ISIN],TransactiesIn[Investering in EUR]))-SUM(IF(Fondsen[[#This Row],[ISIN]]=TransactiesOut[ISIN],TransactiesOut[Opbrengst in EUR]))","v":0},{"$f":"[Aantal]*[Huidige waarde in EUR]","v":0},{"$f":"SUM(IF(Fondsen[[#This Row],[ISIN]]=TransactiesIn[ISIN],TransactiesIn[Aantal]))-SUM(IF(Fondsen[[#This Row],[ISIN]]=TransactiesOut[ISIN],TransactiesOut[Aantal]))","v":0},{"$f":"Fondsen[[#This Row],[Totale waarde]]-Fondsen[[#This Row],[Totale investering in EUR]]","v":0},{"$f":"(Fondsen[[#This Row],[Totale waarde]]-Fondsen[[#This Row],[Totale investering in EUR]])/ABS(Fondsen[[#This Row],[Totale investering in EUR]])","v":{"$error":"#DIV/0!"}},{"$f":"Fondsen[[#This Row],[Totale waarde]]/SUM([Totale waarde])","v":{"$error":"#DIV/0!"}},{"$f":"SUM(IF(Fondsen[[#This Row],[ISIN]]=TransactiesIn[ISIN],TransactiesIn[Investering in EUR]))","v":0},{"$f":"ROUND(SUM(IF(Fondsen[[#This Row],[ISIN]]=TransactiesIn[ISIN],(TransactiesIn[Datum Aankoop]*TransactiesIn[Investering in EUR])/Fondsen[[#This Row],[Totale aankoop in EUR]])),0)","v":0},{"$f":"ROUND(Fondsen[[#This Row],[Form date Fonds]]*Fondsen[[#This Row],[Totale investering in EUR]]/SUM([Totale investering in EUR]),0)","v":{"$error":"#DIV/0!"}},{"$f":"ROUND(Fondsen[[#This Row],[Form date Fonds]]*Fondsen[[#This Row],[Totale investering in EUR]]/Fondsen[[#Totals],[Totale investering in EUR]],0)","v":{"$error":"#DIV/0!"}},{"$f":"IF(Evaluatiedatum-Fondsen[[#This Row],[Form date Fonds]]>365, ((Fondsen[[#This Row],[Totale waarde]]/Fondsen[[#This Row],[Totale investering in EUR]])^(365.25/(Evaluatiedatum-Fondsen[[#This Row],[Form date Fonds]]))-1),\"\")","v":{"$error":"#DIV/0!"}},0,110.99,{"$f":"IF(Fondsen[[#This Row],[Vorige waarde in EUR]]<>0,  (Fondsen[[#This Row],[Huidige waarde in EUR]]-Fondsen[[#This Row],[Vorige waarde in EUR]])/Fondsen[[#This Row],[Vorige waarde in EUR]],0)","v":0},"KEY",42318]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUBTOTAL(9,[Totale investering in EUR])","v":0},{"$f":"SUBTOTAL(9,[Totale waarde])","v":0},null,{"$f":"SUBTOTAL(9,[Meerwaarde bedrag])","v":0},{"$f":"(Fondsen[[#Totals],[Totale waarde]]-Fondsen[[#Totals],[Totale investering in EUR]])/Fondsen[[#Totals],[Totale investering in EUR]]","v":{"$error":"#DIV/0!"}},{"$f":"SUBTOTAL(9,[Totale waarde])/SUM([Totale waarde])","v":{"$error":"#DIV/0!"}},null,null,null,null,{"$f":"IF(Evaluatiedatum-SUBTOTAL(9,[Form date Visible])>365, ((SUBTOTAL(9,[Totale waarde])/SUBTOTAL(9,[Totale investering in EUR]))^(365.25/(Evaluatiedatum-SUBTOTAL(9,[Form date Visible])))-1),\"\")","v":{"$error":"#DIV/0!"}},{"$f":"SUM([Vorige totale waarde])","v":0},{"$f":"SUM([Vorige waarde in EUR])","v":394.65205855104688},{"$f":"IF(SUBTOTAL(9,[Vorige totale waarde])<>0,(SUBTOTAL(9,[Totale waarde])-SUBTOTAL(9,[Vorige totale waarde]))/SUBTOTAL(9,[Vorige totale waarde]),0)","v":0}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["TRANSACTIES IN"]
["ISIN","Beheerder","Naam Fonds","Categorie","Investering in EUR","Datum Aankoop","Aantal","Stukprijs"]
["BE0124921827","Aberdeen","Aberdeen Global - Ind. Equity A2","aandelen India",127293,31332,72,{"$f":"IF(TransactiesIn[[#This Row],[Aantal]]<>0,TransactiesIn[[#This Row],[Investering in EUR]]/TransactiesIn[[#This Row],[Aantal]],\"\")","v":1767.9583333333333}]
["BE02 8447 5050 0040","Amundi","Amun Lu Am Fds Euro Infl C","oblig  inflat Eur",9952,31777,100,{"$f":"IF(TransactiesIn[[#This Row],[Aantal]]<>0,TransactiesIn[[#This Row],[Investering in EUR]]/TransactiesIn[[#This Row],[Aantal]],\"\")","v":99.52}]
["LU1159238549","Amundi","Amundi Lu Amu Funds Glob Bond","oblg. Wld",11537,41615,929.91489999999999,{"$f":"IF(TransactiesIn[[#This Row],[Aantal]]<>0,TransactiesIn[[#This Row],[Investering in EUR]]/TransactiesIn[[#This Row],[Aantal]],\"\")","v":12.4065116065997}]
["LU1159236501","Blackrock","iSHR Mexico tracker CMEX Cap","aandelen Mexico",37746,41325,4170.59,{"$f":"IF(TransactiesIn[[#This Row],[Aantal]]<>0,TransactiesIn[[#This Row],[Investering in EUR]]/TransactiesIn[[#This Row],[Aantal]],\"\")","v":9.0505180322208609}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["TRANSACTIES UIT"]
["ISIN","Beheerder","Naam Fonds","Categorie","Opbrengst in EUR","Datum verkoop","Aantal","Stukprijs"]
[null,{"$f":"VLOOKUP(TransactiesOut[[#This Row],[ISIN]],Fondsen[],COLUMN(Fondsen[[#Headers],[Beheerder]]),FALSE)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(TransactiesOut[[#This Row],[ISIN]],Fondsen[],COLUMN(Fondsen[[#Headers],[Naam Fonds]]),FALSE)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(TransactiesOut[[#This Row],[ISIN]],Fondsen[],COLUMN(Fondsen[[#Headers],[Categorie]]),FALSE)","v":{"$error":"#N/A"}},null,null,null,{"$f":"IF([Aantal]<>0,[Opbrengst in EUR]/[Aantal],\"\")","v":""}]

{"sheet":"Koersen","index":1,"n_rows":11,"n_cols":3,"rows_kept":11,"cut":false,"hidden":false,"merged":[]}
["Munt","Koers","Naam"]
["EUR",1,"Euro"]
["USD",1.0794999999999999,"Amerikaanse Dollar"]
["JPY",132.38149999999999,"Japanse Yen"]
["GBP",0.70879999999999999,"Britse Pond"]
["CHF",1.0807,"Zwitserse Frank"]
["NOK",9.3737999999999992,"Noorse kroon"]
["CAD",1.4336,"Canadese Dollar"]
["AUD",1.5154000000000001,"Australische Dollar"]
["CNY",6.8745000000000003,"Chinese Yuan"]
["SEK",9.3336000000000006,"Zweedse Kroon"]