{"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":45,"n_cols":28,"rows_kept":45,"cut":false,"hidden":false,"merged":[[42,0,42,7],[27,0,27,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",28]
[]
["Portefeuilledatum",{"$f":"SUM(Fondsen[Form date Portefeuille])","v":40694}]
["Annual portefeuille",{"$f":"IF(Evaluatiedatum-Portefeuilledatum>365, ((SUM(Fondsen[Totale waarde])/SUM(Fondsen[Totale investering in EUR]))^(365.25/(Evaluatiedatum-Portefeuilledatum))-1),\"\")","v":-0.67467774119760926}]
["Meerwaarde",{"$f":"SUM(Fondsen[Totale waarde])-SUM(Fondsen[Totale investering in EUR])","v":-102688.56},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"]
["LU1056593699","BNP","BNP Paribas L1 Eq Wld Guru","aand. Wld",null,242.14,"EUR",{"$f":"Fondsen[[#This Row],[Huidige Waarde]]/VLOOKUP(Fondsen[[#This Row],[Munt]],Koersen[],2,FALSE)","v":242.14},{"$f":"Fondsen[[#This Row],[Huidige waarde in EUR]]*0.9","v":217.92599999999999},217.15133,{"$f":"[90%]-[R ST LOSS]","v":0.7746699999999862},{"$f":"(Fondsen[[#This Row],[Huidige waarde in EUR]]-Fondsen[[#This Row],[R ST LOSS]])/Fondsen[[#This Row],[Huidige waarde in EUR]]","v":0.10319926488808122},{"$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":2979},{"$f":"[Aantal]*[Huidige waarde in EUR]","v":242.14},{"$f":"SUM(IF(Fondsen[[#This Row],[ISIN]]=TransactiesIn[ISIN],TransactiesIn[Aantal]))-SUM(IF(Fondsen[[#This Row],[ISIN]]=TransactiesOut[ISIN],TransactiesOut[Aantal]))","v":1},{"$f":"Fondsen[[#This Row],[Totale waarde]]-Fondsen[[#This Row],[Totale investering in EUR]]","v":-2736.86},{"$f":"(Fondsen[[#This Row],[Totale waarde]]-Fondsen[[#This Row],[Totale investering in EUR]])/ABS(Fondsen[[#This Row],[Totale investering in EUR]])","v":-0.91871769050016794},{"$f":"Fondsen[[#This Row],[Totale waarde]]/SUM([Totale waarde])","v":0.34619123870524993},{"$f":"SUM(IF(Fondsen[[#This Row],[ISIN]]=TransactiesIn[ISIN],TransactiesIn[Investering in EUR]))","v":2979},{"$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":32673},{"$f":"ROUND(Fondsen[[#This Row],[Form date Fonds]]*Fondsen[[#This Row],[Totale investering in EUR]]/SUM([Totale investering in EUR]),0)","v":941},{"$f":"ROUND(Fondsen[[#This Row],[Form date Fonds]]*Fondsen[[#This Row],[Totale investering in EUR]]/Fondsen[[#Totals],[Totale investering in EUR]],0)","v":941},{"$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":-9.065952072751482E-2},7221.3,240.71,{"$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":5.9407585891736048E-3},"BNP",42318]
["LU1056591487","BNP","BNP Paribas L1 Eq Wld Qual Focus Cla-Cap","aand. Wld",null,148.16999999999999,"EUR",{"$f":"Fondsen[[#This Row],[Huidige Waarde]]/VLOOKUP(Fondsen[[#This Row],[Munt]],Koersen[],2,FALSE)","v":148.16999999999999},{"$f":"Fondsen[[#This Row],[Huidige waarde in EUR]]*0.9","v":133.35299999999998},136.10889,{"$f":"[90%]-[R ST LOSS]","v":-2.7558900000000222},{"$f":"(Fondsen[[#This Row],[Huidige waarde in EUR]]-Fondsen[[#This Row],[R ST LOSS]])/Fondsen[[#This Row],[Huidige waarde in EUR]]","v":8.1400485928325481E-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":3640},{"$f":"[Aantal]*[Huidige waarde in EUR]","v":148.16999999999999},{"$f":"SUM(IF(Fondsen[[#This Row],[ISIN]]=TransactiesIn[ISIN],TransactiesIn[Aantal]))-SUM(IF(Fondsen[[#This Row],[ISIN]]=TransactiesOut[ISIN],TransactiesOut[Aantal]))","v":1},{"$f":"Fondsen[[#This Row],[Totale waarde]]-Fondsen[[#This Row],[Totale investering in EUR]]","v":-3491.83},{"$f":"(Fondsen[[#This Row],[Totale waarde]]-Fondsen[[#This Row],[Totale investering in EUR]])/ABS(Fondsen[[#This Row],[Totale investering in EUR]])","v":-0.95929395604395606},{"$f":"Fondsen[[#This Row],[Totale waarde]]/SUM([Totale waarde])","v":0.21184090129246255},{"$f":"SUM(IF(Fondsen[[#This Row],[ISIN]]=TransactiesIn[ISIN],TransactiesIn[Investering in EUR]))","v":3640},{"$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":36220},{"$f":"ROUND(Fondsen[[#This Row],[Form date Fonds]]*Fondsen[[#This Row],[Totale investering in EUR]]/SUM([Totale investering in EUR]),0)","v":1275},{"$f":"ROUND(Fondsen[[#This Row],[Form date Fonds]]*Fondsen[[#This Row],[Totale investering in EUR]]/Fondsen[[#Totals],[Totale investering in EUR]],0)","v":1275},{"$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":-0.17446245844779873},3275.1400000000003,148.87,{"$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":-4.702089071001659E-3},"BNP",42318]
["LU0318931192","Fidel","Fid. China Foc Fd A EUR ","aand. China",null,13.91,"EUR",{"$f":"Fondsen[[#This Row],[Huidige Waarde]]/VLOOKUP(Fondsen[[#This Row],[Munt]],Koersen[],2,FALSE)","v":13.91},{"$f":"Fondsen[[#This Row],[Huidige waarde in EUR]]*0.9","v":12.519},12.87317,{"$f":"[90%]-[R ST LOSS]","v":-0.35416999999999987},{"$f":"(Fondsen[[#This Row],[Huidige waarde in EUR]]-Fondsen[[#This Row],[R ST LOSS]])/Fondsen[[#This Row],[Huidige waarde in EUR]]","v":7.4538461538461553E-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":20390},{"$f":"[Aantal]*[Huidige waarde in EUR]","v":13.91},{"$f":"SUM(IF(Fondsen[[#This Row],[ISIN]]=TransactiesIn[ISIN],TransactiesIn[Aantal]))-SUM(IF(Fondsen[[#This Row],[ISIN]]=TransactiesOut[ISIN],TransactiesOut[Aantal]))","v":1},{"$f":"Fondsen[[#This Row],[Totale waarde]]-Fondsen[[#This Row],[Totale investering in EUR]]","v":-20376.09},{"$f":"(Fondsen[[#This Row],[Totale waarde]]-Fondsen[[#This Row],[Totale investering in EUR]])/ABS(Fondsen[[#This Row],[Totale investering in EUR]])","v":-0.99931780284453164},{"$f":"Fondsen[[#This Row],[Totale waarde]]/SUM([Totale waarde])","v":1.9887338442182319E-2},{"$f":"SUM(IF(Fondsen[[#This Row],[ISIN]]=TransactiesIn[ISIN],TransactiesIn[Investering in EUR]))","v":20390},{"$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":41292},{"$f":"ROUND(Fondsen[[#This Row],[Form date Fonds]]*Fondsen[[#This Row],[Totale investering in EUR]]/SUM([Totale investering in EUR]),0)","v":8144},{"$f":"ROUND(Fondsen[[#This Row],[Form date Fonds]]*Fondsen[[#This Row],[Totale investering in EUR]]/Fondsen[[#Totals],[Totale investering in EUR]],0)","v":8144},{"$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":-0.92518513119286039},30976,14.08,{"$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":-1.2073863636363631E-2},"KEY",42318]
["FR0010345389","Lyxor","Lyxor UCITS ETF Stoxx Europe 600 Bas.Resour","aand. Grondstof",null,32.79,"EUR",{"$f":"Fondsen[[#This Row],[Huidige Waarde]]/VLOOKUP(Fondsen[[#This Row],[Munt]],Koersen[],2,FALSE)","v":32.79},{"$f":"Fondsen[[#This Row],[Huidige waarde in EUR]]*0.9","v":29.510999999999999},31.593959999999999,{"$f":"[90%]-[R ST LOSS]","v":-2.0829599999999999},{"$f":"(Fondsen[[#This Row],[Huidige waarde in EUR]]-Fondsen[[#This Row],[R ST LOSS]])/Fondsen[[#This Row],[Huidige waarde in EUR]]","v":3.6475754803293688E-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":12241},{"$f":"[Aantal]*[Huidige waarde in EUR]","v":32.79},{"$f":"SUM(IF(Fondsen[[#This Row],[ISIN]]=TransactiesIn[ISIN],TransactiesIn[Aantal]))-SUM(IF(Fondsen[[#This Row],[ISIN]]=TransactiesOut[ISIN],TransactiesOut[Aantal]))","v":1},{"$f":"Fondsen[[#This Row],[Totale waarde]]-Fondsen[[#This Row],[Totale investering in EUR]]","v":-12208.21},{"$f":"(Fondsen[[#This Row],[Totale waarde]]-Fondsen[[#This Row],[Totale investering in EUR]])/ABS(Fondsen[[#This Row],[Totale investering in EUR]])","v":-0.99732129727963392},{"$f":"Fondsen[[#This Row],[Totale waarde]]/SUM([Totale waarde])","v":4.6880361432002748E-2},{"$f":"SUM(IF(Fondsen[[#This Row],[ISIN]]=TransactiesIn[ISIN],TransactiesIn[Investering in EUR]))","v":12241},{"$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":42292},{"$f":"ROUND(Fondsen[[#This Row],[Form date Fonds]]*Fondsen[[#This Row],[Totale investering in EUR]]/SUM([Totale investering in EUR]),0)","v":5007},{"$f":"ROUND(Fondsen[[#This Row],[Form date Fonds]]*Fondsen[[#This Row],[Totale investering in EUR]]/Fondsen[[#Totals],[Totale investering in EUR]],0)","v":5007},{"$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":""},11476.5,32.79,{"$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]
["lu0095527585","NN","NN (L) Euro Equity - P Cap EUR","aandelen eurozone",null,145.09,"EUR",{"$f":"Fondsen[[#This Row],[Huidige Waarde]]/VLOOKUP(Fondsen[[#This Row],[Munt]],Koersen[],2,FALSE)","v":145.09},{"$f":"Fondsen[[#This Row],[Huidige waarde in EUR]]*0.9","v":130.58100000000002},131.54940999999999,{"$f":"[90%]-[R ST LOSS]","v":-0.96840999999997734},{"$f":"(Fondsen[[#This Row],[Huidige waarde in EUR]]-Fondsen[[#This Row],[R ST LOSS]])/Fondsen[[#This Row],[Huidige waarde in EUR]]","v":9.3325453166999847E-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":5845},{"$f":"[Aantal]*[Huidige waarde in EUR]","v":145.09},{"$f":"SUM(IF(Fondsen[[#This Row],[ISIN]]=TransactiesIn[ISIN],TransactiesIn[Aantal]))-SUM(IF(Fondsen[[#This Row],[ISIN]]=TransactiesOut[ISIN],TransactiesOut[Aantal]))","v":1},{"$f":"Fondsen[[#This Row],[Totale waarde]]-Fondsen[[#This Row],[Totale investering in EUR]]","v":-5699.91},{"$f":"(Fondsen[[#This Row],[Totale waarde]]-Fondsen[[#This Row],[Totale investering in EUR]])/ABS(Fondsen[[#This Row],[Totale investering in EUR]])","v":-0.97517707442258339},{"$f":"Fondsen[[#This Row],[Totale waarde]]/SUM([Totale waarde])","v":0.20743737847420796},{"$f":"SUM(IF(Fondsen[[#This Row],[ISIN]]=TransactiesIn[ISIN],TransactiesIn[Investering in EUR]))","v":5845},{"$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":34403},{"$f":"ROUND(Fondsen[[#This Row],[Form date Fonds]]*Fondsen[[#This Row],[Totale investering in EUR]]/SUM([Totale investering in EUR]),0)","v":1945},{"$f":"ROUND(Fondsen[[#This Row],[Form date Fonds]]*Fondsen[[#This Row],[Totale investering in EUR]]/Fondsen[[#Totals],[Totale investering in EUR]],0)","v":1945},{"$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":-0.15678689455022943},20659.21,144.47,{"$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":4.2915484183567842E-3},"ING",42318]
["LU0995123261","Schrod","Schroders SISF UK Equity","aand. UK",null,103.37,"EUR",{"$f":"Fondsen[[#This Row],[Huidige Waarde]]/VLOOKUP(Fondsen[[#This Row],[Munt]],Koersen[],2,FALSE)","v":103.37},{"$f":"Fondsen[[#This Row],[Huidige waarde in EUR]]*0.9","v":93.033000000000001},93.764499999999998,{"$f":"[90%]-[R ST LOSS]","v":-0.73149999999999693},{"$f":"(Fondsen[[#This Row],[Huidige waarde in EUR]]-Fondsen[[#This Row],[R ST LOSS]])/Fondsen[[#This Row],[Huidige waarde in EUR]]","v":9.2923478765599365E-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":10639},{"$f":"[Aantal]*[Huidige waarde in EUR]","v":103.37},{"$f":"SUM(IF(Fondsen[[#This Row],[ISIN]]=TransactiesIn[ISIN],TransactiesIn[Aantal]))-SUM(IF(Fondsen[[#This Row],[ISIN]]=TransactiesOut[ISIN],TransactiesOut[Aantal]))","v":1},{"$f":"Fondsen[[#This Row],[Totale waarde]]-Fondsen[[#This Row],[Totale investering in EUR]]","v":-10535.63},{"$f":"(Fondsen[[#This Row],[Totale waarde]]-Fondsen[[#This Row],[Totale investering in EUR]])/ABS(Fondsen[[#This Row],[Totale investering in EUR]])","v":-0.99028386126515644},{"$f":"Fondsen[[#This Row],[Totale waarde]]/SUM([Totale waarde])","v":0.14778966029966834},{"$f":"SUM(IF(Fondsen[[#This Row],[ISIN]]=TransactiesIn[ISIN],TransactiesIn[Investering in EUR]))","v":11230},{"$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":41409},{"$f":"ROUND(Fondsen[[#This Row],[Form date Fonds]]*Fondsen[[#This Row],[Totale investering in EUR]]/SUM([Totale investering in EUR]),0)","v":4261},{"$f":"ROUND(Fondsen[[#This Row],[Form date Fonds]]*Fondsen[[#This Row],[Totale investering in EUR]]/Fondsen[[#Totals],[Totale investering in EUR]],0)","v":4261},{"$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":-0.84431991815907459},12201.048270000001,102.23,{"$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":1.1151325442629371E-2},"KEY",42318]
["LU1159236501","SSGA","State Street Europe Index Equity Fund P","aandelen eurozone",null,10.79,"EUR",{"$f":"Fondsen[[#This Row],[Huidige Waarde]]/VLOOKUP(Fondsen[[#This Row],[Munt]],Koersen[],2,FALSE)","v":10.79},{"$f":"Fondsen[[#This Row],[Huidige waarde in EUR]]*0.9","v":9.7110000000000003},9.8320399999999992,{"$f":"[90%]-[R ST LOSS]","v":-0.12103999999999893},{"$f":"(Fondsen[[#This Row],[Huidige waarde in EUR]]-Fondsen[[#This Row],[R ST LOSS]])/Fondsen[[#This Row],[Huidige waarde in EUR]]","v":8.8782205746061174E-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":37746},{"$f":"[Aantal]*[Huidige waarde in EUR]","v":10.79},{"$f":"SUM(IF(Fondsen[[#This Row],[ISIN]]=TransactiesIn[ISIN],TransactiesIn[Aantal]))-SUM(IF(Fondsen[[#This Row],[ISIN]]=TransactiesOut[ISIN],TransactiesOut[Aantal]))","v":1},{"$f":"Fondsen[[#This Row],[Totale waarde]]-Fondsen[[#This Row],[Totale investering in EUR]]","v":-37735.21},{"$f":"(Fondsen[[#This Row],[Totale waarde]]-Fondsen[[#This Row],[Totale investering in EUR]])/ABS(Fondsen[[#This Row],[Totale investering in EUR]])","v":-0.99971414189582997},{"$f":"Fondsen[[#This Row],[Totale waarde]]/SUM([Totale waarde])","v":1.5426627015898434E-2},{"$f":"SUM(IF(Fondsen[[#This Row],[ISIN]]=TransactiesIn[ISIN],TransactiesIn[Investering in EUR]))","v":37746},{"$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":41325},{"$f":"ROUND(Fondsen[[#This Row],[Form date Fonds]]*Fondsen[[#This Row],[Totale investering in EUR]]/SUM([Totale investering in EUR]),0)","v":15087},{"$f":"ROUND(Fondsen[[#This Row],[Form date Fonds]]*Fondsen[[#This Row],[Totale investering in EUR]]/Fondsen[[#Totals],[Totale investering in EUR]],0)","v":15087},{"$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":-0.95013500866128797},45000.666099999995,10.79,{"$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},"FORTUN",42318]
["GB0002771169","Thread","Threadn. Eur Sel Retail Net EUR KAP","aand.eurozone  ex UK",null,3.18,"EUR",{"$f":"Fondsen[[#This Row],[Huidige Waarde]]/VLOOKUP(Fondsen[[#This Row],[Munt]],Koersen[],2,FALSE)","v":3.18},{"$f":"Fondsen[[#This Row],[Huidige waarde in EUR]]*0.9","v":2.8620000000000001},2.87243,{"$f":"[90%]-[R ST LOSS]","v":-1.0429999999999939E-2},{"$f":"(Fondsen[[#This Row],[Huidige waarde in EUR]]-Fondsen[[#This Row],[R ST LOSS]])/Fondsen[[#This Row],[Huidige waarde in EUR]]","v":9.6720125786163555E-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":9908},{"$f":"[Aantal]*[Huidige waarde in EUR]","v":3.18},{"$f":"SUM(IF(Fondsen[[#This Row],[ISIN]]=TransactiesIn[ISIN],TransactiesIn[Aantal]))-SUM(IF(Fondsen[[#This Row],[ISIN]]=TransactiesOut[ISIN],TransactiesOut[Aantal]))","v":1},{"$f":"Fondsen[[#This Row],[Totale waarde]]-Fondsen[[#This Row],[Totale investering in EUR]]","v":-9904.82},{"$f":"(Fondsen[[#This Row],[Totale waarde]]-Fondsen[[#This Row],[Totale investering in EUR]])/ABS(Fondsen[[#This Row],[Totale investering in EUR]])","v":-0.99967904723455792},{"$f":"Fondsen[[#This Row],[Totale waarde]]/SUM([Totale waarde])","v":4.5464943383278058E-3},{"$f":"SUM(IF(Fondsen[[#This Row],[ISIN]]=TransactiesIn[ISIN],TransactiesIn[Investering in EUR]))","v":9908},{"$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":42089},{"$f":"ROUND(Fondsen[[#This Row],[Form date Fonds]]*Fondsen[[#This Row],[Totale investering in EUR]]/SUM([Totale investering in EUR]),0)","v":4034},{"$f":"ROUND(Fondsen[[#This Row],[Form date Fonds]]*Fondsen[[#This Row],[Totale investering in EUR]]/Fondsen[[#Totals],[Totale investering in EUR]],0)","v":4034},{"$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":""},9937.5,3.18,{"$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},"BKCP",42318]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUBTOTAL(9,[Totale investering in EUR])","v":103388},{"$f":"SUBTOTAL(9,[Totale waarde])","v":699.43999999999994},null,{"$f":"SUBTOTAL(9,[Meerwaarde bedrag])","v":-102688.56},{"$f":"(Fondsen[[#Totals],[Totale waarde]]-Fondsen[[#Totals],[Totale investering in EUR]])/Fondsen[[#Totals],[Totale investering in EUR]]","v":-0.99323480481293769},{"$f":"SUBTOTAL(9,[Totale waarde])/SUM([Totale waarde])","v":1},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":-0.67467774119760926},{"$f":"SUM([Vorige totale waarde])","v":140747.36437},{"$f":"SUM([Vorige waarde in EUR])","v":697.12},{"$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.99503052861323005}]
[]
[]
[]
[]
[]
[]
[]
[]
["TRANSACTIES IN"]
["ISIN","Beheerder","Naam Fonds","Categorie","Investering in EUR","Datum Aankoop","Aantal","Stukprijs"]
["LU1159236501",{"$f":"VLOOKUP(TransactiesIn[[#This Row],[ISIN]],Fondsen[],COLUMN(Fondsen[[#Headers],[Beheerder]]),FALSE)","v":"SSGA"},{"$f":"VLOOKUP(TransactiesIn[[#This Row],[ISIN]],Fondsen[],COLUMN(Fondsen[[#Headers],[Naam Fonds]]),FALSE)","v":"State Street Europe Index Equity Fund P"},{"$f":"VLOOKUP(TransactiesIn[[#This Row],[ISIN]],Fondsen[],COLUMN(Fondsen[[#Headers],[Categorie]]),FALSE)","v":"aandelen eurozone"},37746,41325,1,{"$f":"IF(TransactiesIn[[#This Row],[Aantal]]<>0,TransactiesIn[[#This Row],[Investering in EUR]]/TransactiesIn[[#This Row],[Aantal]],\"\")","v":37746}]
["LU1056593699",{"$f":"VLOOKUP(TransactiesIn[[#This Row],[ISIN]],Fondsen[],COLUMN(Fondsen[[#Headers],[Beheerder]]),FALSE)","v":"BNP"},{"$f":"VLOOKUP(TransactiesIn[[#This Row],[ISIN]],Fondsen[],COLUMN(Fondsen[[#Headers],[Naam Fonds]]),FALSE)","v":"BNP Paribas L1 Eq Wld Guru"},{"$f":"VLOOKUP(TransactiesIn[[#This Row],[ISIN]],Fondsen[],COLUMN(Fondsen[[#Headers],[Categorie]]),FALSE)","v":"aand. Wld"},2979,32673,1,{"$f":"IF(TransactiesIn[[#This Row],[Aantal]]<>0,TransactiesIn[[#This Row],[Investering in EUR]]/TransactiesIn[[#This Row],[Aantal]],\"\")","v":2979}]
["LU0095527585",{"$f":"VLOOKUP(TransactiesIn[[#This Row],[ISIN]],Fondsen[],COLUMN(Fondsen[[#Headers],[Beheerder]]),FALSE)","v":"NN"},{"$f":"VLOOKUP(TransactiesIn[[#This Row],[ISIN]],Fondsen[],COLUMN(Fondsen[[#Headers],[Naam Fonds]]),FALSE)","v":"NN (L) Euro Equity - P Cap EUR"},{"$f":"VLOOKUP(TransactiesIn[[#This Row],[ISIN]],Fondsen[],COLUMN(Fondsen[[#Headers],[Categorie]]),FALSE)","v":"aandelen eurozone"},5845,34403,1,{"$f":"IF(TransactiesIn[[#This Row],[Aantal]]<>0,TransactiesIn[[#This Row],[Investering in EUR]]/TransactiesIn[[#This Row],[Aantal]],\"\")","v":5845}]
["LU1056591487",{"$f":"VLOOKUP(TransactiesIn[[#This Row],[ISIN]],Fondsen[],COLUMN(Fondsen[[#Headers],[Beheerder]]),FALSE)","v":"BNP"},{"$f":"VLOOKUP(TransactiesIn[[#This Row],[ISIN]],Fondsen[],COLUMN(Fondsen[[#Headers],[Naam Fonds]]),FALSE)","v":"BNP Paribas L1 Eq Wld Qual Focus Cla-Cap"},{"$f":"VLOOKUP(TransactiesIn[[#This Row],[ISIN]],Fondsen[],COLUMN(Fondsen[[#Headers],[Categorie]]),FALSE)","v":"aand. Wld"},3640,36220,1,{"$f":"IF(TransactiesIn[[#This Row],[Aantal]]<>0,TransactiesIn[[#This Row],[Investering in EUR]]/TransactiesIn[[#This Row],[Aantal]],\"\")","v":3640}]
["GB0002771169",{"$f":"VLOOKUP(TransactiesIn[[#This Row],[ISIN]],Fondsen[],COLUMN(Fondsen[[#Headers],[Beheerder]]),FALSE)","v":"Thread"},{"$f":"VLOOKUP(TransactiesIn[[#This Row],[ISIN]],Fondsen[],COLUMN(Fondsen[[#Headers],[Naam Fonds]]),FALSE)","v":"Threadn. Eur Sel Retail Net EUR KAP"},{"$f":"VLOOKUP(TransactiesIn[[#This Row],[ISIN]],Fondsen[],COLUMN(Fondsen[[#Headers],[Categorie]]),FALSE)","v":"aand.eurozone  ex UK"},9908,42089,1,{"$f":"IF(TransactiesIn[[#This Row],[Aantal]]<>0,TransactiesIn[[#This Row],[Investering in EUR]]/TransactiesIn[[#This Row],[Aantal]],\"\")","v":9908}]
["FR0010345389",{"$f":"VLOOKUP(TransactiesIn[[#This Row],[ISIN]],Fondsen[],COLUMN(Fondsen[[#Headers],[Beheerder]]),FALSE)","v":"Lyxor"},{"$f":"VLOOKUP(TransactiesIn[[#This Row],[ISIN]],Fondsen[],COLUMN(Fondsen[[#Headers],[Naam Fonds]]),FALSE)","v":"Lyxor UCITS ETF Stoxx Europe 600 Bas.Resour"},{"$f":"VLOOKUP(TransactiesIn[[#This Row],[ISIN]],Fondsen[],COLUMN(Fondsen[[#Headers],[Categorie]]),FALSE)","v":"aand. Grondstof"},12241,42292,1,{"$f":"IF(TransactiesIn[[#This Row],[Aantal]]<>0,TransactiesIn[[#This Row],[Investering in EUR]]/TransactiesIn[[#This Row],[Aantal]],\"\")","v":12241}]
["LU0995123261",{"$f":"VLOOKUP(TransactiesIn[[#This Row],[ISIN]],Fondsen[],COLUMN(Fondsen[[#Headers],[Beheerder]]),FALSE)","v":"Schrod"},{"$f":"VLOOKUP(TransactiesIn[[#This Row],[ISIN]],Fondsen[],COLUMN(Fondsen[[#Headers],[Naam Fonds]]),FALSE)","v":"Schroders SISF UK Equity"},{"$f":"VLOOKUP(TransactiesIn[[#This Row],[ISIN]],Fondsen[],COLUMN(Fondsen[[#Headers],[Categorie]]),FALSE)","v":"aand. UK"},11230,41409,1,{"$f":"IF(TransactiesIn[[#This Row],[Aantal]]<>0,TransactiesIn[[#This Row],[Investering in EUR]]/TransactiesIn[[#This Row],[Aantal]],\"\")","v":11230}]
["LU0318931192",{"$f":"VLOOKUP(TransactiesIn[[#This Row],[ISIN]],Fondsen[],COLUMN(Fondsen[[#Headers],[Beheerder]]),FALSE)","v":"Fidel"},{"$f":"VLOOKUP(TransactiesIn[[#This Row],[ISIN]],Fondsen[],COLUMN(Fondsen[[#Headers],[Naam Fonds]]),FALSE)","v":"Fid. China Foc Fd A EUR "},{"$f":"VLOOKUP(TransactiesIn[[#This Row],[ISIN]],Fondsen[],COLUMN(Fondsen[[#Headers],[Categorie]]),FALSE)","v":"aand. China"},20390,41292,1,{"$f":"IF(TransactiesIn[[#This Row],[Aantal]]<>0,TransactiesIn[[#This Row],[Investering in EUR]]/TransactiesIn[[#This Row],[Aantal]],\"\")","v":20390}]
[]
[]
[]
[]
[]
["TRANSACTIES UIT"]
["ISIN","Beheerder","Naam Fonds","Categorie","Opbrengst in EUR","Datum verkoop","Aantal","Stukprijs"]
["LU0995123261",{"$f":"VLOOKUP(TransactiesOut[[#This Row],[ISIN]],Fondsen[],COLUMN(Fondsen[[#Headers],[Beheerder]]),FALSE)","v":"Schrod"},{"$f":"VLOOKUP(TransactiesOut[[#This Row],[ISIN]],Fondsen[],COLUMN(Fondsen[[#Headers],[Naam Fonds]]),FALSE)","v":"Schroders SISF UK Equity"},{"$f":"VLOOKUP(TransactiesOut[[#This Row],[ISIN]],Fondsen[],COLUMN(Fondsen[[#Headers],[Categorie]]),FALSE)","v":"aand. UK"},591,42316,0,{"$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.0769,"Amerikaanse Dollar"]
["JPY",132.297,"Japanse Yen"]
["GBP",0.70809999999999995,"Britse Pond"]
["CHF",1.0782,"Zwitserse Frank"]
["NOK",9.3567999999999998,"Noorse kroon"]
["CAD",1.4334,"Canadese Dollar"]
["AUD",1.5135000000000001,"Australische Dollar"]
["CNY",6.8598999999999997,"Chinese Yuan"]
["SEK",9.3124000000000002,"Zweedse Kroon"]