{"text_format":"5","workbook":"xlsx","n_sheets":4,"sheets":["KGAST Immo-Index","KGAST Immo-Index Gemischt","KGAST Immo-Index Wohnen","KGAST Immo-Index Geschäft"],"props":{"title":"KGAST Immo-Index","subject":"Monatliche Eckdaten","description":"2019-06-28","creator":"Fundo SA","last_modified_by":"Unknown Creator","company":"Fundo SA"},"read":"whole","date_system":"1900"}

{"sheet":"KGAST Immo-Index","index":0,"n_rows":56,"n_cols":11,"rows_kept":56,"merged":[[0,3,0,5],[0,6,0,7]]}
["2019-06-28","ISIN","Kategoriserung","NAV",null,null,"Nettovermögen",null,"Gewicht","Perf.","Beitrag"]
["Adimora"]
["  1. Omega (Wohnimmobilien)","CH0149835834","Wohnen","2019-06-28",{"v":1223.84997558594,"d":"1,223.85"},null,"2019-04-30",{"v":211.039993286133,"d":"211.04"},{"v":0.004966452867095008,"d":"0.50%"},{"v":0.00204689025878906,"d":"0.20%"},{"v":1.016578399439177E-5,"d":"0.0010%"}]
["ASSETIMMO"]
["  2. Anlagegruppe G","CH0010493499","Geschäft","2019-06-28",{"v":414.859985351563,"d":"414.86"},null,"2019-05-31",{"v":727.283020019531,"d":"727.28"},{"v":0.01711531915691572,"d":"1.71%"},{"v":0.00277503967285156,"d":"0.28%"},{"v":4.749568967395742E-5,"d":"0.0047%"}]
["  3. Anlagegruppe W","CH0010493457","Wohnen","2019-06-28",{"v":540.97998046875,"d":"540.98"},null,"2019-05-31",{"v":1558.60498046875,"d":"1,558.60"},{"v":0.03667901070970234,"d":"3.67%"},{"v":0.00317970275878906,"d":"0.32%"},{"v":0.000116628351543294,"d":"0.0117%"}]
["Avadis"]
["  4. Immobilien Schweiz Geschäft","CH0141268083","Geschäft","2019-06-28",{"v":132063.46875,"d":"132,063.47"},null,"2019-05-31",{"v":860.558471679688,"d":"860.56"},{"v":0.02025172111895303,"d":"2.03%"},{"v":0.00271743774414063,"d":"0.27%"},{"v":5.503279135245287E-5,"d":"0.0055%"}]
["  5. Immobilien Schweiz Wohnen","CH0009359354","Wohnen","2019-06-28",{"v":142558.234375,"d":"142,558.23"},null,"2019-05-31",{"v":2369.25170898438,"d":"2,369.25"},{"v":0.05575614725784012,"d":"5.58%"},{"v":0.0027288818359375,"d":"0.27%"},{"v":0.0001521519374937764,"d":"0.0152%"}]
["CSA"]
["  6. Real Estate Switzerland","CH0013123002","Gemischt","2019-06-28",{"v":1867.81005859375,"d":"1,867.81"},null,"2019-05-31",{"v":5637.46899414063,"d":"5,637.47"},{"v":0.1326678588884728,"d":"13.27%"},{"v":0.00308799743652344,"d":"0.31%"},{"v":0.0004096780081566575,"d":"0.0410%"}]
["  7. Real Estate Switzerland Commercial","CH0113543620","Geschäft","2019-06-28",{"v":1497.89001464844,"d":"1,497.89"},null,"2019-05-31",{"v":1279.03552246094,"d":"1,279.04"},{"v":0.03009983813366569,"d":"3.01%"},{"v":0.00299980163574219,"d":"0.30%"},{"v":9.029354366894549E-5,"d":"0.0090%"}]
["  8. Real Estate Switzerland Residential","CH0025226090","Wohnen","2019-06-28",{"v":1802.5400390625,"d":"1,802.54"},null,"2019-05-31",{"v":709.331298828125,"d":"709.33"},{"v":0.01669285715911102,"d":"1.67%"},{"v":0.003116455078125,"d":"0.31%"},{"v":5.202253946192681E-5,"d":"0.0052%"}]
["Ecoreal"]
["  9. Suissecore Plus","CH0108524155","Gemischt","2019-06-28",{"v":154.339996337891,"d":"154.34"},null,"2019-03-29",{"v":870,"d":"870.00"},{"v":0.02047391078388823,"d":"2.05%"},{"v":0.00259834289550781,"d":"0.26%"},{"v":5.319824062857671E-5,"d":"0.0053%"}]
["  10. Suisseselect","CH0181111045","Geschäft","2019-06-28",{"v":147.149993896484,"d":"147.15"},null,"2019-03-29",{"v":396,"d":"396.00"},{"v":0.009319159391287055,"d":"0.93%"},{"v":0.00388862609863281,"d":"0.39%"},{"v":3.62387264262779E-5,"d":"0.0036%"}]
["Greenbrix"]
["  11. Greenbrix Housing","CH0224042157","Wohnen","2019-06-28",{"v":10449,"d":"10,449.00"},"* ","2019-05-31",{"v":228.186630249023,"d":"228.19"},{"v":0.005369968631947802,"d":"0.54%"},{"v":0.002783052284391685,"d":"0.28%"},{"v":1.494490346825402E-5,"d":"0.0015%"}]
["Helvetia"]
["  12. Immobilien Romandie","CH0301200108","Gemischt","2019-06-28",{"v":1221.10998535156,"d":"1,221.11"},null,"2019-05-31",{"v":215.657165527344,"d":"215.66"},{"v":0.005075109847026502,"d":"0.51%"},{"v":0.00222419738769531,"d":"0.22%"},{"v":1.128804606402309E-5,"d":"0.0011%"}]
["  13. Immobilien Schweiz","CH0188230780","Gemischt","2019-06-28",{"v":1272.43005371094,"d":"1,272.43"},null,"2019-05-31",{"v":607.297607421875,"d":"607.30"},{"v":0.01429167475129224,"d":"1.43%"},{"v":0.00262397766113281,"d":"0.26%"},{"v":3.750103528756663E-5,"d":"0.0038%"}]
["HIG"]
["  14. CH-Classico","CH0002875208","Wohnen","2019-06-28",{"v":12655,"d":"12,655.00"},"* ","2019-03-29",{"v":730,"d":"730.00"},{"v":0.01717925847383725,"d":"1.72%"},{"v":0.0039666748046875,"d":"0.40%"},{"v":6.814453175138444E-5,"d":"0.0068%"}]
["IST"]
["  15. Immobilien Schweiz Fokus","CH0002598578","Wohnen","2019-06-28",{"v":263669.6875,"d":"263,669.69"},null,"2019-05-31",{"v":265.029998779297,"d":"265.03"},{"v":0.006237012126507278,"d":"0.62%"},{"v":0.00383766174316406,"d":"0.38%"},{"v":2.39355428295473E-5,"d":"0.0024%"}]
["  16. Immobilien Schweiz Wohnen","CH0245229122","Wohnen","2019-06-28",118.53,null,"2019-05-31",{"v":187.382095336914,"d":"187.38"},{"v":0.004409706094742546,"d":"0.44%"},{"v":0.002198388131511297,"d":"0.22%"},{"v":9.694245542135046E-6,"d":"0.0010%"}]
["J. Safra Sarasin"]
["  17. Nachhaltig Immobilien Schweiz","CH0049550269","Gemischt","2019-06-28",{"v":1432.31994628906,"d":"1,432.32"},"* ","2019-05-31",{"v":490.074096679688,"d":"490.07"},{"v":0.01153302681944201,"d":"1.15%"},{"v":0.0134220123291016,"d":"1.34%"},{"v":0.00015479642816241,"d":"0.0155%"}]
["Patrimonium"]
["  18. Gesundheitsimmobilien Schweiz","CH0282527719","Geschäft","2019-06-28",{"v":1147.67004394531,"d":"1,147.67"},null,"2019-05-31",{"v":152.072875976563,"d":"152.07"},{"v":0.003578766086659138,"d":"0.36%"},{"v":0.00238449096679688,"d":"0.24%"},{"v":8.533535405917737E-6,"d":"0.0009%"}]
["  19. Wohnimmobilien Schweiz","CH0112589673","Wohnen","2019-06-28",{"v":1525.4599609375,"d":"1,525.46"},null,"2019-05-31",{"v":429.813354492188,"d":"429.81"},{"v":0.0101148968662032,"d":"1.01%"},{"v":0.00279380798339844,"d":"0.28%"},{"v":2.825907961605035E-5,"d":"0.0028%"}]
["Pensimo"]
["  20. Casareal (Wohnimmobilien)","CH0020488190","Wohnen","2019-06-28",{"v":1278.40002441406,"d":"1,278.40"},null,"2018-12-31",{"v":1688.65002441406,"d":"1,688.65"},{"v":0.03973939074145304,"d":"3.97%"},{"v":0.00274528503417969,"d":"0.27%"},{"v":0.00010909595466993,"d":"0.0109%"}]
["  21. Proreal (Geschäftsimmobilien)","CH0020488224","Geschäft","2019-06-28",{"v":1298.94995117188,"d":"1,298.95"},null,"2018-12-31",{"v":414.040008544922,"d":"414.04"},{"v":0.00974369907575753,"d":"0.97%"},{"v":0.00308891296386719,"d":"0.31%"},{"v":3.00974383911282E-5,"d":"0.0030%"}]
["Swiss Life"]
["  22. Geschäftsimmobilien Schweiz","CH0136837587","Geschäft","2019-06-28",145.75,null,"2019-05-31",{"v":1040.40087890625,"d":"1,040.40"},{"v":0.02448399399333961,"d":"2.45%"},{"v":0.00199363708496094,"d":"0.20%"},{"v":4.881219841308276E-5,"d":"0.0049%"}]
["  23. Immobilien Schweiz","CH0106150136","Gemischt","2019-06-28",{"v":165.229995727539,"d":"165.23"},null,"2019-05-31",{"v":2001.46484375,"d":"2,001.46"},{"v":0.04710093407819114,"d":"4.71%"},{"v":0.00236595153808594,"d":"0.24%"},{"v":0.0001114385274275808,"d":"0.0111%"}]
["Swiss Prime"]
["  24. SPA Immobilien Schweiz","CH0263627355","Gemischt","2019-06-28",{"v":1124.65002441406,"d":"1,124.65"},null,"2019-05-31",{"v":1498.44995117188,"d":"1,498.45"},{"v":0.03526336852231579,"d":"3.53%"},{"v":0.002692394288432043,"d":"0.27%"},{"v":9.494289200035733E-5,"d":"0.0095%"}]
["Swisscanto"]
["  25. Immobilien Schweiz","CH0002875893","Gemischt","2019-06-28",{"v":222.860000610352,"d":"222.86"},null,"2019-05-31",{"v":6863.356353759771,"d":"6,863.36"},{"v":0.1615169490401264,"d":"16.15%"},{"v":0.00328636169433594,"d":"0.33%"},{"v":0.0005308031143114814,"d":"0.0531%"}]
["Tellco"]
["  26. Immobilien Schweiz","CH0024559798","Gemischt","2019-06-28",{"v":169.483001708984,"d":"169.48"},null,"2019-05-31",{"v":948.874206542969,"d":"948.87"},{"v":0.02233007568953273,"d":"2.23%"},{"v":0.00334548950195313,"d":"0.33%"},{"v":7.470503379715055E-5,"d":"0.0075%"}]
["Turidomus"]
["  27. Casareal (Wohnimmobilien)","CH0020488026","Wohnen","2019-06-28",{"v":1483.55004882813,"d":"1,483.55"},null,"2019-04-30",{"v":3299.05004882813,"d":"3,299.05"},{"v":0.07763730617389566,"d":"7.76%"},{"v":0.00250030517578125,"d":"0.25%"},{"v":0.0001941169584603049,"d":"0.0194%"}]
["  28. Proreal (Geschäftsimmobilien)","CH0020488067","Geschäft","2019-06-28",{"v":1103.30004882813,"d":"1,103.30"},null,"2019-04-30",{"v":989.630004882813,"d":"989.63"},{"v":0.02328919129773515,"d":"2.33%"},{"v":0.00322807312011719,"d":"0.32%"},{"v":7.517921241748603E-5,"d":"0.0075%"}]
["UBS 1"]
["  29. Immobilien Schweiz","CH0002875497","Gemischt","2019-06-28",{"v":1749.10998535156,"d":"1,749.11"},null,"2019-05-31",{"v":2133.337890625,"d":"2,133.34"},{"v":0.05020433292476385,"d":"5.02%"},{"v":0.00387985229492188,"d":"0.39%"},{"v":0.0001947853963131671,"d":"0.0195%"}]
["  30. Kommerzielle Immobilien Schweiz","CH0100770533","Geschäft","2019-06-28",{"v":1628.53002929688,"d":"1,628.53"},null,"2019-05-31",{"v":671.746276855469,"d":"671.75"},{"v":0.01580836016292868,"d":"1.58%"},{"v":0.01229349817664316,"d":"1.23%"},{"v":0.0001943400468386821,"d":"0.0194%"}]
["Zürich"]
["  31. Immobilien – Geschäft Schweiz","CH0032598069","Geschäft","2019-06-28",{"v":1749.57788085938,"d":"1,749.58"},null,"2019-05-31",{"v":586.793701171875,"d":"586.79"},{"v":0.01380915159349487,"d":"1.38%"},{"v":0.0102613067626953,"d":"1.03%"},{"v":0.0001416999406334135,"d":"0.0142%"}]
["  32. Immobilien – Traditionell Schweiz","CH0023842187","Wohnen","2019-06-28",{"v":2416.02368164063,"d":"2,416.02"},null,"2019-05-31",{"v":592.690979003906,"d":"592.69"},{"v":0.01394793359372568,"d":"1.39%"},{"v":0.00876190185546875,"d":"0.88%"},{"v":0.00012221042523482,"d":"0.0122%"}]
["  33. Immobilien – Wohnen Schweiz","CH0018192903","Wohnen","2019-06-28",{"v":2681.47387695313,"d":"2,681.47"},null,"2019-05-31",{"v":1840.53002929688,"d":"1,840.53"},{"v":0.04331361794815115,"d":"4.33%"},{"v":0.004287109375,"d":"0.43%"},{"v":0.000185690217570687,"d":"0.0186%"}]
["Gesamtsumme",{"$nulls":6},{"$f":"SUM(H2:H53)","v":{"v":42493.103012085,"d":"42,493.10"}},{"$f":"SUM(I2:I53)","v":{"v":1,"d":"100.00%"}},null,{"$f":"SUM(K2:K53)","v":{"v":0.003487920317006817,"d":"0.3488%"}}]
[]
["* Kein offizieller Handelskurs."]

{"sheet":"KGAST Immo-Index Gemischt","index":1,"n_rows":23,"n_cols":11,"rows_kept":23,"merged":[[0,3,0,5],[0,6,0,7]]}
["2019-06-28","ISIN","Kategoriserung","NAV",null,null,"Nettovermögen",null,"Gewicht","Perf.","Beitrag"]
["CSA"]
["  1. Real Estate Switzerland","CH0013123002","Gemischt","2019-06-28",{"v":1867.81005859375,"d":"1,867.81"},null,"2019-05-31",{"v":5637.46899414063,"d":"5,637.47"},{"v":0.2650932945478192,"d":"26.51%"},{"v":0.00308799743652344,"d":"0.31%"},{"v":0.0008186074140032189,"d":"0.0819%"}]
["Ecoreal"]
["  2. Suissecore Plus","CH0108524155","Gemischt","2019-06-28",{"v":154.339996337891,"d":"154.34"},null,"2019-03-29",{"v":870,"d":"870.00"},{"v":0.04091040970625505,"d":"4.09%"},{"v":0.00259834289550781,"d":"0.26%"},{"v":0.0001062992724125616,"d":"0.0106%"}]
["Helvetia"]
["  3. Immobilien Romandie","CH0301200108","Gemischt","2019-06-28",{"v":1221.10998535156,"d":"1,221.11"},null,"2019-05-31",{"v":215.657165527344,"d":"215.66"},{"v":0.01014094597449805,"d":"1.01%"},{"v":0.00222419738769531,"d":"0.22%"},{"v":2.255546554523784E-5,"d":"0.0023%"}]
["  4. Immobilien Schweiz","CH0188230780","Gemischt","2019-06-28",{"v":1272.43005371094,"d":"1,272.43"},null,"2019-05-31",{"v":607.297607421875,"d":"607.30"},{"v":0.02855723440604292,"d":"2.86%"},{"v":0.00262397766113281,"d":"0.26%"},{"v":7.493354514518992E-5,"d":"0.0075%"}]
["J. Safra Sarasin"]
["  5. Nachhaltig Immobilien Schweiz","CH0049550269","Gemischt","2019-06-28",{"v":1432.31994628906,"d":"1,432.32"},"* ","2019-05-31",{"v":490.074096679688,"d":"490.07"},{"v":0.02304497940412515,"d":"2.30%"},{"v":0.0134220123291016,"d":"1.34%"},{"v":0.0003093099976860602,"d":"0.0309%"}]
["Swiss Life"]
["  6. Immobilien Schweiz","CH0106150136","Gemischt","2019-06-28",{"v":165.229995727539,"d":"165.23"},null,"2019-05-31",{"v":2001.46484375,"d":"2,001.46"},{"v":0.09411580088560718,"d":"9.41%"},{"v":0.00236595153808594,"d":"0.24%"},{"v":0.0002226734238634924,"d":"0.0223%"}]
["Swiss Prime"]
["  7. SPA Immobilien Schweiz","CH0263627355","Gemischt","2019-06-28",{"v":1124.65002441406,"d":"1,124.65"},null,"2019-05-31",{"v":1498.44995117188,"d":"1,498.45"},{"v":0.07046230049052814,"d":"7.05%"},{"v":0.002692394288432043,"d":"0.27%"},{"v":0.0001897122953904803,"d":"0.0190%"}]
["Swisscanto"]
["  8. Immobilien Schweiz","CH0002875893","Gemischt","2019-06-28",{"v":222.860000610352,"d":"222.86"},null,"2019-05-31",{"v":6863.356353759771,"d":"6,863.36"},{"v":0.3227387590716563,"d":"32.27%"},{"v":0.00328636169433594,"d":"0.33%"},{"v":0.001060636295090607,"d":"0.1061%"}]
["Tellco"]
["  9. Immobilien Schweiz","CH0024559798","Gemischt","2019-06-28",{"v":169.483001708984,"d":"169.48"},null,"2019-05-31",{"v":948.874206542969,"d":"948.87"},{"v":0.04461934775789717,"d":"4.46%"},{"v":0.00334548950195313,"d":"0.33%"},{"v":0.0001492735595080409,"d":"0.0149%"}]
["UBS 1"]
["  10. Immobilien Schweiz","CH0002875497","Gemischt","2019-06-28",{"v":1749.10998535156,"d":"1,749.11"},null,"2019-05-31",{"v":2133.337890625,"d":"2,133.34"},{"v":0.1003169277555709,"d":"10.03%"},{"v":0.00387985229492188,"d":"0.39%"},{"v":0.0003892148623719641,"d":"0.0389%"}]
["Gesamtsumme",{"$nulls":6},{"$f":"SUM(H2:H20)","v":{"v":21265.98110961916,"d":"21,265.98"}},{"$f":"SUM(I2:I20)","v":{"v":1,"d":"100.00%"}},null,{"$f":"SUM(K2:K20)","v":{"v":0.003343216131016853,"d":"0.3343%"}}]
[]
["* Kein offizieller Handelskurs."]

{"sheet":"KGAST Immo-Index Wohnen","index":2,"n_rows":28,"n_cols":11,"rows_kept":28,"merged":[[0,3,0,5],[0,6,0,7]]}
["2019-06-28","ISIN","Kategoriserung","NAV",null,null,"Nettovermögen",null,"Gewicht","Perf.","Beitrag"]
["Adimora"]
["  1. Omega (Wohnimmobilien)","CH0149835834","Wohnen","2019-06-28",{"v":1223.84997558594,"d":"1,223.85"},null,"2019-04-30",{"v":211.039993286133,"d":"211.04"},{"v":0.01495723298284672,"d":"1.50%"},{"v":0.00204689025878906,"d":"0.20%"},{"v":3.061581449102739E-5,"d":"0.0031%"}]
["ASSETIMMO"]
["  2. Anlagegruppe W","CH0010493457","Wohnen","2019-06-28",{"v":540.97998046875,"d":"540.98"},null,"2019-05-31",{"v":1558.60498046875,"d":"1,558.60"},{"v":0.1104644549030516,"d":"11.05%"},{"v":0.00317970275878906,"d":"0.32%"},{"v":0.0003512441320033629,"d":"0.0351%"}]
["Avadis"]
["  3. Immobilien Schweiz Wohnen","CH0009359354","Wohnen","2019-06-28",{"v":142558.234375,"d":"142,558.23"},null,"2019-05-31",{"v":2369.25170898438,"d":"2,369.25"},{"v":0.1679181715962254,"d":"16.79%"},{"v":0.0027288818359375,"d":"0.27%"},{"v":0.0004582288483927757,"d":"0.0458%"}]
["CSA"]
["  4. Real Estate Switzerland Residential","CH0025226090","Wohnen","2019-06-28",{"v":1802.5400390625,"d":"1,802.54"},null,"2019-05-31",{"v":709.331298828125,"d":"709.33"},{"v":0.05027309437132489,"d":"5.03%"},{"v":0.003116455078125,"d":"0.31%"},{"v":0.0001566738402465728,"d":"0.0157%"}]
["Greenbrix"]
["  5. Greenbrix Housing","CH0224042157","Wohnen","2019-06-28",{"v":10449,"d":"10,449.00"},"* ","2019-05-31",{"v":228.186630249023,"d":"228.19"},{"v":0.0161724824714994,"d":"1.62%"},{"v":0.002783052284391685,"d":"0.28%"},{"v":4.500886428659088E-5,"d":"0.0045%"}]
["HIG"]
["  6. CH-Classico","CH0002875208","Wohnen","2019-06-28",{"v":12655,"d":"12,655.00"},"* ","2019-03-29",{"v":730,"d":"730.00"},{"v":0.05173796638002241,"d":"5.17%"},{"v":0.0039666748046875,"d":"0.40%"},{"v":0.0002052276876854038,"d":"0.0205%"}]
["IST"]
["  7. Immobilien Schweiz Fokus","CH0002598578","Wohnen","2019-06-28",{"v":263669.6875,"d":"263,669.69"},null,"2019-05-31",{"v":265.029998779297,"d":"265.03"},{"v":0.01878371666649404,"d":"1.88%"},{"v":0.00383766174316406,"d":"0.38%"},{"v":7.208555084543732E-5,"d":"0.0072%"}]
["  8. Immobilien Schweiz Wohnen","CH0245229122","Wohnen","2019-06-28",118.53,null,"2019-05-31",{"v":187.382095336914,"d":"187.38"},{"v":0.01328050486131426,"d":"1.33%"},{"v":0.002198388131511297,"d":"0.22%"},{"v":2.919570426759137E-5,"d":"0.0029%"}]
["Patrimonium"]
["  9. Wohnimmobilien Schweiz","CH0112589673","Wohnen","2019-06-28",{"v":1525.4599609375,"d":"1,525.46"},null,"2019-05-31",{"v":429.813354492188,"d":"429.81"},{"v":0.03046256011561847,"d":"3.05%"},{"v":0.00279380798339844,"d":"0.28%"},{"v":8.510654364576978E-5,"d":"0.0085%"}]
["Pensimo"]
["  10. Casareal (Wohnimmobilien)","CH0020488190","Wohnen","2019-06-28",{"v":1278.40002441406,"d":"1,278.40"},null,"2018-12-31",{"v":1688.65002441406,"d":"1,688.65"},{"v":0.1196812577955598,"d":"11.97%"},{"v":0.00274528503417969,"d":"0.27%"},{"v":0.0003285591658979519,"d":"0.0329%"}]
["Turidomus"]
["  11. Casareal (Wohnimmobilien)","CH0020488026","Wohnen","2019-06-28",{"v":1483.55004882813,"d":"1,483.55"},null,"2019-04-30",{"v":3299.05004882813,"d":"3,299.05"},{"v":0.2338166308387412,"d":"23.38%"},{"v":0.00250030517578125,"d":"0.25%"},{"v":0.0005846129322698387,"d":"0.0585%"}]
["Zürich"]
["  12. Immobilien – Traditionell Schweiz","CH0023842187","Wohnen","2019-06-28",{"v":2416.02368164063,"d":"2,416.02"},null,"2019-05-31",{"v":592.690979003906,"d":"592.69"},{"v":0.04200633691157078,"d":"4.20%"},{"v":0.00876190185546875,"d":"0.88%"},{"v":0.0003680554013269375,"d":"0.0368%"}]
["  13. Immobilien – Wohnen Schweiz","CH0018192903","Wohnen","2019-06-28",{"v":2681.47387695313,"d":"2,681.47"},null,"2019-05-31",{"v":1840.53002929688,"d":"1,840.53"},{"v":0.130445590105731,"d":"13.04%"},{"v":0.004287109375,"d":"0.43%"},{"v":0.0005592345122696868,"d":"0.0559%"}]
["Gesamtsumme",{"$nulls":6},{"$f":"SUM(H2:H25)","v":{"v":14109.56114196779,"d":"14,109.56"}},{"$f":"SUM(I2:I25)","v":{"v":1,"d":"100.00%"}},null,{"$f":"SUM(K2:K25)","v":{"v":0.003273848997628947,"d":"0.3274%"}}]
[]
["* Kein offizieller Handelskurs."]

{"sheet":"KGAST Immo-Index Geschäft","index":3,"n_rows":22,"n_cols":11,"rows_kept":22,"merged":[[0,3,0,5],[0,6,0,7]]}
["2019-06-28","ISIN","Kategoriserung","NAV",null,null,"Nettovermögen",null,"Gewicht","Perf.","Beitrag"]
["ASSETIMMO"]
["  1. Anlagegruppe G","CH0010493499","Geschäft","2019-06-28",{"v":414.859985351563,"d":"414.86"},null,"2019-05-31",{"v":727.283020019531,"d":"727.28"},{"v":0.1021814979165193,"d":"10.22%"},{"v":0.00277503967285156,"d":"0.28%"},{"v":0.00028355771054974,"d":"0.0284%"}]
["Avadis"]
["  2. Immobilien Schweiz Geschäft","CH0141268083","Geschäft","2019-06-28",{"v":132063.46875,"d":"132,063.47"},null,"2019-05-31",{"v":860.558471679688,"d":"860.56"},{"v":0.1209063751806272,"d":"12.09%"},{"v":0.00271743774414063,"d":"0.27%"},{"v":0.0003285555474230644,"d":"0.0329%"}]
["CSA"]
["  3. Real Estate Switzerland Commercial","CH0113543620","Geschäft","2019-06-28",{"v":1497.89001464844,"d":"1,497.89"},null,"2019-05-31",{"v":1279.03552246094,"d":"1,279.04"},{"v":0.1797013844348888,"d":"17.97%"},{"v":0.00299980163574219,"d":"0.30%"},{"v":0.0005390685069729157,"d":"0.0539%"}]
["Ecoreal"]
["  4. Suisseselect","CH0181111045","Geschäft","2019-06-28",{"v":147.149993896484,"d":"147.15"},null,"2019-03-29",{"v":396,"d":"396.00"},{"v":0.05563703821086733,"d":"5.56%"},{"v":0.00388862609863281,"d":"0.39%"},{"v":0.0002163516388374096,"d":"0.0216%"}]
["Patrimonium"]
["  5. Gesundheitsimmobilien Schweiz","CH0282527719","Geschäft","2019-06-28",{"v":1147.67004394531,"d":"1,147.67"},null,"2019-05-31",{"v":152.072875976563,"d":"152.07"},{"v":0.02136586972612254,"d":"2.14%"},{"v":0.00238449096679688,"d":"0.24%"},{"v":5.094672335969811E-5,"d":"0.0051%"}]
["Pensimo"]
["  6. Proreal (Geschäftsimmobilien)","CH0020488224","Geschäft","2019-06-28",{"v":1298.94995117188,"d":"1,298.95"},null,"2018-12-31",{"v":414.040008544922,"d":"414.04"},{"v":0.05817161559656985,"d":"5.82%"},{"v":0.00308891296386719,"d":"0.31%"},{"v":0.0001796870575453434,"d":"0.0180%"}]
["Swiss Life"]
["  7. Geschäftsimmobilien Schweiz","CH0136837587","Geschäft","2019-06-28",145.75,null,"2019-05-31",{"v":1040.40087890625,"d":"1,040.40"},{"v":0.1461737966018358,"d":"14.62%"},{"v":0.00199363708496094,"d":"0.20%"},{"v":0.0002914175017549574,"d":"0.0291%"}]
["Turidomus"]
["  8. Proreal (Geschäftsimmobilien)","CH0020488067","Geschäft","2019-06-28",{"v":1103.30004882813,"d":"1,103.30"},null,"2019-04-30",{"v":989.630004882813,"d":"989.63"},{"v":0.1390406121118331,"d":"13.90%"},{"v":0.00322807312011719,"d":"0.32%"},{"v":0.0004488332625628489,"d":"0.0449%"}]
["UBS 1"]
["  9. Kommerzielle Immobilien Schweiz","CH0100770533","Geschäft","2019-06-28",{"v":1628.53002929688,"d":"1,628.53"},null,"2019-05-31",{"v":671.746276855469,"d":"671.75"},{"v":0.09437872038741311,"d":"9.44%"},{"v":0.01229349817664316,"d":"1.23%"},{"v":0.001160244626996578,"d":"0.1160%"}]
["Zürich"]
["  10. Immobilien – Geschäft Schweiz","CH0032598069","Geschäft","2019-06-28",{"v":1749.57788085938,"d":"1,749.58"},null,"2019-05-31",{"v":586.793701171875,"d":"586.79"},{"v":0.08244308983332291,"d":"8.24%"},{"v":0.0102613067626953,"d":"1.03%"},{"v":0.0008459738352441724,"d":"0.0846%"}]
["Gesamtsumme",{"$nulls":6},{"$f":"SUM(H2:H21)","v":{"v":7117.560760498051,"d":"7,117.56"}},{"$f":"SUM(I2:I21)","v":{"v":1,"d":"100.00%"}},null,{"$f":"SUM(K2:K21)","v":{"v":0.004344636411246727,"d":"0.4345%"}}]