{"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":"2023-06-30","creator":"Fundo SA","company":"Fundo SA"},"read":"whole","date_system":"1900"}

{"sheet":"KGAST Immo-Index","index":0,"n_rows":74,"n_cols":11,"rows_kept":74,"merged":[[0,3,0,5],[0,6,0,7]]}
["2023-06-30","ISIN","Kategoriserung","NAV",null,null,"Nettovermögen",null,"Gewicht","Perf.","Beitrag"]
[1291]
["  1. Immobilien Schweiz","CH0427260721","Gemischt","2023-06-30",{"v":120.4227,"d":"120.42"},"* ","2023-05-31",{"v":1056.94,"d":"1,056.94"},{"v":0.015027931513133,"d":"1.50%"},{"v":0,"d":"0.00%"},{"v":0,"d":"0.0000%"}]
["Adimora"]
["  2. Omega (Wohnimmobilien)","CH0149835834","Wohnen","2023-06-30",{"v":1402.4,"d":"1,402.40"},null,"2022-09-30",379.14,{"v":0.005390741152657,"d":"0.54%"},{"v":0.0020721686316543,"d":"0.21%"},{"v":1.1170524717904E-5,"d":"0.0011%"}]
["ASSETIMMO"]
["  3. Anlagegruppe G","CH0010493499","Geschäft","2023-06-30",441.28,null,"2023-05-31",{"v":789.772,"d":"789.77"},{"v":0.011229246245757,"d":"1.12%"},{"v":0.0052244753387052,"d":"0.52%"},{"v":5.8666920083204E-5,"d":"0.0059%"}]
["  4. Anlagegruppe W","CH0010493457","Wohnen","2023-06-30",594.07,null,"2023-05-31",{"v":1837.409,"d":"1,837.41"},{"v":0.026124904548616,"d":"2.61%"},{"v":0.0043691792184755,"d":"0.44%"},{"v":0.00011414439003847,"d":"0.0114%"}]
["Avadis"]
["  5. Immobilien Schweiz Geschäft","CH0141268083","Geschäft","2023-06-30",{"v":138716.8157128,"d":"138,716.82"},null,"2023-05-31",{"v":911.3374,"d":"911.34"},{"v":0.012957704347037,"d":"1.30%"},{"v":0.002270229678472,"d":"0.23%"},{"v":2.9416964973508E-5,"d":"0.0029%"}]
["  6. Immobilien Schweiz Wohnen","CH0009359354","Wohnen","2023-06-30",{"v":173031.1696472,"d":"173,031.17"},null,"2023-05-31",{"v":3344.7078,"d":"3,344.71"},{"v":0.047556190275553,"d":"4.76%"},{"v":0.0026502262840462,"d":"0.27%"},{"v":0.00012603466543737,"d":"0.0126%"}]
["  7. Immobilien Schweiz Wohnen Mittelzentren","CH0547737087","Wohnen","2023-06-30",{"v":1170.7987814,"d":"1,170.80"},null,"2023-05-31",{"v":289.1185,"d":"289.12"},{"v":0.0041107849236284,"d":"0.41%"},{"v":0.0023962169520548,"d":"0.24%"},{"v":9.8503325202498E-6,"d":"0.0010%"}]
["avenirplus"]
["  8. Immobilien","CH0371634939","Gemischt","2023-06-30",{"v":1419.137,"d":"1,419.14"},null,"2023-05-31",{"v":178.7902964,"d":"178.79"},{"v":0.0025421010932617,"d":"0.25%"},{"v":0.0020993331280841,"d":"0.21%"},{"v":5.336717040023E-6,"d":"0.0005%"}]
["AXA"]
["  9. Immobilien Schweiz ","CH0436698515","Gemischt","2023-06-30",{"v":1052.72,"d":"1,052.72"},"* ","2023-05-31",{"v":8589.7912005,"d":"8,589.79"},{"v":0.12213256558861,"d":"12.21%"},{"v":-0.0039832344620744,"d":"-0.40%"},{"v":-0.00048648264419412,"d":"-0.0486%"}]
["CSA"]
["  10. Real Estate Switzerland","CH0013123002","Gemischt","2023-06-30",{"v":2013.83,"d":"2,013.83"},null,"2023-05-31",{"v":6514.262481,"d":"6,514.26"},{"v":0.092621994080119,"d":"9.26%"},{"v":0.0030382571361687,"d":"0.30%"},{"v":0.0002814094344801,"d":"0.0281%"}]
["  11. Real Estate Switzerland Commercial","CH0113543620","Geschäft","2023-06-30",{"v":1682.24,"d":"1,682.24"},null,"2023-05-31",{"v":1447.5138,"d":"1,447.51"},{"v":0.020581242313391,"d":"2.06%"},{"v":-0.020153304909019,"d":"-2.02%"},{"v":-0.00041478005174816,"d":"-0.0415%"}]
["  12. Real Estate Switzerland Residential","CH0025226090","Wohnen","2023-06-30",{"v":2241.49,"d":"2,241.49"},null,"2023-05-31",{"v":1074.4312,"d":"1,074.43"},{"v":0.015276627329057,"d":"1.53%"},{"v":-0.0068235492203874,"d":"-0.68%"},{"v":-0.00010424081850134,"d":"-0.0104%"}]
["DAI"]
["  13. Gewerbeimmobilien Schweiz DAGSIS","CH0347818491","Geschäft","2023-06-30",180.19,null,"2023-05-31",{"v":245.295878,"d":"245.30"},{"v":0.00348770001612,"d":"0.35%"},{"v":0.0027825699816348,"d":"0.28%"},{"v":9.7047693698029E-6,"d":"0.0010%"}]
["Ecoreal"]
["  14. SUISSECORE Plus","CH0108524155","Gemischt","2023-06-30",192.36,"* ","2023-03-31",{"v":1258,"d":"1,258.00"},{"v":0.017886670807729,"d":"1.79%"},{"v":0.0025015634771735,"d":"0.25%"},{"v":4.4744642420841E-5,"d":"0.0045%"}]
["  15. SUISSESELECT","CH0181111045","Geschäft","2023-06-30",181.25,"* ","2023-05-31",{"v":532,"d":"532.00"},{"v":0.0075641564942067,"d":"0.76%"},{"v":0.0033213396069747,"d":"0.33%"},{"v":2.5123132557564E-5,"d":"0.0025%"}]
["Greenbrix"]
["  16. Greenbrix Housing – Wohngebäude in der Schweiz","CH0224042157","Wohnen","2023-06-30",{"v":11055,"d":"11,055.00"},"* ","2023-05-31",{"v":359.834807,"d":"359.83"},{"v":0.0051162533688171,"d":"0.51%"},{"v":0.0027210884353743,"d":"0.27%"},{"v":1.3921777874333E-5,"d":"0.0014%"}]
["Helvetia"]
["  17. Immobilien Romandie","CH0301200108","Gemischt","2023-06-30",{"v":1416.05,"d":"1,416.05"},"* ","2023-05-31",{"v":602.9871,"d":"602.99"},{"v":0.0085734751661427,"d":"0.86%"},{"v":0.0021230671243055,"d":"0.21%"},{"v":1.8202063266287E-5,"d":"0.0018%"}]
["  18. Immobilien Schweiz","CH0188230780","Gemischt","2023-06-30",{"v":1490.75,"d":"1,490.75"},"* ","2023-05-31",{"v":834.4065,"d":"834.41"},{"v":0.011863874710119,"d":"1.19%"},{"v":0.0044469898595154,"d":"0.44%"},{"v":5.2758530530461E-5,"d":"0.0053%"}]
["HIG"]
["  19. CH-Classico","CH0002875208","Wohnen","2023-06-30",{"v":13834,"d":"13,834.00"},"* ","2023-05-31",{"v":1030.935,"d":"1,030.94"},{"v":0.014658183600291,"d":"1.47%"},{"v":0.0036273940800928,"d":"0.36%"},{"v":5.3171008416611E-5,"d":"0.0053%"}]
["IST"]
["  20. Immobilien Schweiz Fokus","CH0002598578","Wohnen","2023-06-30",{"v":314826.36,"d":"314,826.36"},"* ","2023-05-31",{"v":316.878,"d":"316.88"},{"v":0.0045054789127279,"d":"0.45%"},{"v":0.0024671746554721,"d":"0.25%"},{"v":1.1115803384246E-5,"d":"0.0011%"}]
["  21. Immobilien Schweiz Wohnen","CH0245229122","Wohnen","2023-06-30",138.13,"* ","2023-05-31",{"v":327.4198,"d":"327.42"},{"v":0.0046553658016952,"d":"0.47%"},{"v":0.0025402816083611,"d":"0.25%"},{"v":1.1825940126239E-5,"d":"0.0012%"}]
["J. Safra Sarasin"]
["  22. Nachhaltig Immobilien Schweiz","CH0049550269","Gemischt","2023-06-30",{"v":1652.73,"d":"1,652.73"},"* ","2023-05-31",{"v":724.1550251,"d":"724.16"},{"v":0.010296281834441,"d":"1.03%"},{"v":0.0013814414250659,"d":"0.14%"},{"v":1.422371025025E-5,"d":"0.0014%"}]
["Patrimonium"]
["  23. Gesundheitsimmobilien Schweiz","CH0282527719","Geschäft","2023-06-30",{"v":1212.08,"d":"1,212.08"},"* ","2023-05-31",{"v":336.158527,"d":"336.16"},{"v":0.0047796159870113,"d":"0.48%"},{"v":0.0027715039752467,"d":"0.28%"},{"v":1.3246724708155E-5,"d":"0.0013%"}]
["  24. Wohnimmobilien Schweiz","CH0112589673","Wohnen","2023-06-30",{"v":1793.15,"d":"1,793.15"},"* ","2023-05-31",{"v":711.035752,"d":"711.04"},{"v":0.010109747558466,"d":"1.01%"},{"v":-0.0080873119921229,"d":"-0.81%"},{"v":-8.1760682666918E-5,"d":"-0.0082%"}]
["Pensimo"]
["  25. Casareal (Wohnimmobilien)","CH0020488190","Wohnen","2023-06-30",{"v":1387.4,"d":"1,387.40"},null,"2022-12-30",{"v":2232.62,"d":"2,232.62"},{"v":0.031744148631759,"d":"3.17%"},{"v":0.0021670037561399,"d":"0.22%"},{"v":6.8789689320484E-5,"d":"0.0069%"}]
["  26. Proreal (Geschäftsimmobilien)","CH0020488224","Geschäft","2023-06-30",{"v":1334.8,"d":"1,334.80"},null,"2022-12-30",514.51,{"v":0.0073154777402901,"d":"0.73%"},{"v":0.0026290092390897,"d":"0.26%"},{"v":1.9232458567578E-5,"d":"0.0019%"}]
["Prisma"]
["  27. Previous Responsible Residential Real Estate","CH0298011104","Wohnen","2023-06-30",{"v":1120.36,"d":"1,120.36"},"* ","2023-03-31",{"v":110.017759,"d":"110.02"},{"v":0.0015642698237179,"d":"0.16%"},{"v":0.00032142857142858,"d":"0.03%"},{"v":5.0280101476649E-7,"d":"0.0001%"}]
["SFP"]
["  28. Swiss Real Estate","CH0437532747","Gemischt","2023-06-30",{"v":1159.83,"d":"1,159.83"},null,"2023-05-31",{"v":538.011,"d":"538.01"},{"v":0.0076496229315877,"d":"0.76%"},{"v":0.0021947826387509,"d":"0.22%"},{"v":1.678925960324E-5,"d":"0.0017%"}]
["Swiss Life"]
["  29. Geschäftsimmobilien Schweiz ESG","CH0136837587","Geschäft","2023-06-30",173.65,null,"2023-05-31",{"v":1895.7303,"d":"1,895.73"},{"v":0.026954136578965,"d":"2.70%"},{"v":0.0021931090206036,"d":"0.22%"},{"v":5.9113360073909E-5,"d":"0.0059%"}]
["  30. Immobilien Schweiz Alter und Gesundheit ESG","CH0385556482","Gemischt","2023-06-30",131.54,null,"2023-05-31",{"v":444.6612,"d":"444.66"},{"v":0.0063223438039507,"d":"0.63%"},{"v":0.0022095238095237,"d":"0.22%"},{"v":1.3969369166823E-5,"d":"0.0014%"}]
["  31. Immobilien Schweiz ESG","CH0106150136","Gemischt","2023-06-30",199.02,null,"2023-05-31",{"v":3728.1128,"d":"3,728.11"},{"v":0.053007572645217,"d":"5.30%"},{"v":0.0024681408351383,"d":"0.25%"},{"v":0.00013083015461722,"d":"0.0131%"}]
["Swiss Prime"]
["  32. Immobilien Schweiz","CH0263627355","Gemischt","2023-06-30",{"v":1326.62,"d":"1,326.62"},null,"2023-05-31",{"v":2698.1,"d":"2,698.10"},{"v":0.038362501197405,"d":"3.84%"},{"v":-0.0048160595330974,"d":"-0.48%"},{"v":-0.00018475608960522,"d":"-0.0185%"}]
["Swisscanto"]
["  33. Immobilien Responsible Schweiz","CH0002875893","Gemischt","2023-06-30",268.63,null,"2023-05-31",{"v":8469.1059,"d":"8,469.11"},{"v":0.12041662104062,"d":"12.04%"},{"v":0.0034740381023535,"d":"0.35%"},{"v":0.00041833192965177,"d":"0.0418%"}]
["Tellco"]
["  34. Immobilien Schweiz","CH0024559798","Gemischt","2023-06-30",{"v":196.237,"d":"196.24"},null,"2023-05-31",{"v":1062.4647923,"d":"1,062.46"},{"v":0.015106484884478,"d":"1.51%"},{"v":0.0026891733563876,"d":"0.27%"},{"v":4.062395666001E-5,"d":"0.0041%"}]
["  35. Kommerzielle Immobilien Schweiz","CH0598652672","Geschäft","2023-06-30",{"v":117.8084,"d":"117.81"},null,"2023-05-31",{"v":32.8174624,"d":"32.82"},{"v":0.000466609814542,"d":"0.05%"},{"v":0.0040987833201935,"d":"0.41%"},{"v":1.9125325248834E-6,"d":"0.0002%"}]
["Terra Helvetica"]
["  36. Wohnen Schweiz","CH0544073437","Wohnen","2023-06-30",{"v":1075.78,"d":"1,075.78"},"* ","2023-03-31",{"v":123.272129,"d":"123.27"},{"v":0.001752724953252,"d":"0.18%"},{"v":0.0016573556797022,"d":"0.17%"},{"v":2.9048886562278E-6,"d":"0.0003%"}]
["Turidomus"]
["  37. Casareal (Wohnimmobilien)","CH0020488026","Wohnen","2023-06-30",{"v":1695,"d":"1,695.00"},null,"2022-12-30",{"v":4541.13,"d":"4,541.13"},{"v":0.064567327031085,"d":"6.46%"},{"v":0.0021580394359535,"d":"0.22%"},{"v":0.00013933883800719,"d":"0.0139%"}]
["  38. Proreal (Geschäftsimmobilien)","CH0020488067","Geschäft","2023-06-30",{"v":1245.1,"d":"1,245.10"},null,"2022-12-30",{"v":1304.05,"d":"1,304.05"},{"v":0.018541425331335,"d":"1.85%"},{"v":0.002738181525328,"d":"0.27%"},{"v":5.0769788295511E-5,"d":"0.0051%"}]
["  39. Urban & Mixed-use","CH0307702511","Gemischt","2023-06-30",{"v":1035.8,"d":"1,035.80"},null,"2022-12-30",{"v":1289.1,"d":"1,289.10"},{"v":0.018328861159177,"d":"1.83%"},{"v":0.0019830713422007,"d":"0.20%"},{"v":3.6347439299938E-5,"d":"0.0036%"}]
["UBS 1"]
["  40. Immobilien Schweiz","CH0002875497","Gemischt","2023-06-30",{"v":2016.46,"d":"2,016.46"},null,"2023-05-31",{"v":2625.9157,"d":"2,625.92"},{"v":0.037336160329689,"d":"3.73%"},{"v":0.0019378304249316,"d":"0.19%"},{"v":7.2351147436994E-5,"d":"0.0072%"}]
["  41. Kommerzielle Immobilien Schweiz","CH0100770533","Geschäft","2023-06-30",{"v":1730.22,"d":"1,730.22"},null,"2023-05-31",{"v":645.9914,"d":"645.99"},{"v":0.009184924893819,"d":"0.92%"},{"v":0.0026134170863008,"d":"0.26%"},{"v":2.4004039653896E-5,"d":"0.0024%"}]
["Zürich"]
["  42. Immobilien – Geschäft Schweiz","CH0032598069","Geschäft","2023-06-30",{"v":2053.7741,"d":"2,053.77"},null,"2023-05-31",{"v":754.9531341,"d":"754.95"},{"v":0.010734179797226,"d":"1.07%"},{"v":0.00066604719892083,"d":"0.07%"},{"v":7.1494703866549E-6,"d":"0.0007%"}]
["  43. Immobilien – Traditionell Schweiz","CH0023842187","Wohnen","2023-06-30",{"v":3133.3858,"d":"3,133.39"},null,"2023-05-31",{"v":728.3905589,"d":"728.39"},{"v":0.010356504091019,"d":"1.04%"},{"v":-0.00066627865526847,"d":"-0.07%"},{"v":-6.9003176190468E-6,"d":"-0.0007%"}]
["  44. Immobilien – Wohnen Schweiz","CH0018192903","Wohnen","2023-06-30",{"v":3316.371,"d":"3,316.37"},null,"2023-05-31",{"v":2900.4277402,"d":"2,900.43"},{"v":0.041239265652277,"d":"4.12%"},{"v":-0.0023424580608796,"d":"-0.23%"},{"v":-9.6601250251932E-5,"d":"-0.0097%"}]
["Gesamtsumme",{"$nulls":6},{"$f":"SUM(H2:H71)","v":{"v":70331.7019429,"d":"70,331.70"}},{"$f":"SUM(I2:I71)","v":{"v":1,"d":"100.00%"}},null,{"$f":"SUM(K2:K71)","v":{"v":0.00063150732054597,"d":"0.0632%"}}]
[]
["* Kein offizieller Handelskurs."]

{"sheet":"KGAST Immo-Index Gemischt","index":1,"n_rows":34,"n_cols":11,"rows_kept":34,"merged":[[0,3,0,5],[0,6,0,7]]}
["2023-06-30","ISIN","Kategoriserung","NAV",null,null,"Nettovermögen",null,"Gewicht","Perf.","Beitrag"]
[1291]
["  1. Immobilien Schweiz","CH0427260721","Gemischt","2023-06-30",{"v":120.4227,"d":"120.42"},"* ","2023-05-31",{"v":1056.94,"d":"1,056.94"},{"v":0.026023515960395,"d":"2.60%"},{"v":0,"d":"0.00%"},{"v":0,"d":"0.0000%"}]
["avenirplus"]
["  2. Immobilien","CH0371634939","Gemischt","2023-06-30",{"v":1419.137,"d":"1,419.14"},null,"2023-05-31",{"v":178.7902964,"d":"178.79"},{"v":0.0044020967433621,"d":"0.44%"},{"v":0.0020993331280841,"d":"0.21%"},{"v":9.2414675263711E-6,"d":"0.0009%"}]
["AXA"]
["  3. Immobilien Schweiz ","CH0436698515","Gemischt","2023-06-30",{"v":1052.72,"d":"1,052.72"},"* ","2023-05-31",{"v":8589.7912005,"d":"8,589.79"},{"v":0.21149409465312,"d":"21.15%"},{"v":-0.0039832344620744,"d":"-0.40%"},{"v":-0.00084243056634754,"d":"-0.0842%"}]
["CSA"]
["  4. Real Estate Switzerland","CH0013123002","Gemischt","2023-06-30",{"v":2013.83,"d":"2,013.83"},null,"2023-05-31",{"v":6514.262481,"d":"6,514.26"},{"v":0.1603913312435,"d":"16.04%"},{"v":0.0030382571361687,"d":"0.30%"},{"v":0.00048731010673016,"d":"0.0487%"}]
["Ecoreal"]
["  5. SUISSECORE Plus","CH0108524155","Gemischt","2023-06-30",192.36,"* ","2023-03-31",{"v":1258,"d":"1,258.00"},{"v":0.030973927638444,"d":"3.10%"},{"v":0.0025015634771735,"d":"0.25%"},{"v":7.7483246124944E-5,"d":"0.0077%"}]
["Helvetia"]
["  6. Immobilien Romandie","CH0301200108","Gemischt","2023-06-30",{"v":1416.05,"d":"1,416.05"},"* ","2023-05-31",{"v":602.9871,"d":"602.99"},{"v":0.014846485534432,"d":"1.48%"},{"v":0.0021230671243055,"d":"0.21%"},{"v":3.152008534963E-5,"d":"0.0032%"}]
["  7. Immobilien Schweiz","CH0188230780","Gemischt","2023-06-30",{"v":1490.75,"d":"1,490.75"},"* ","2023-05-31",{"v":834.4065,"d":"834.41"},{"v":0.020544393125634,"d":"2.05%"},{"v":0.0044469898595154,"d":"0.44%"},{"v":9.1360707899591E-5,"d":"0.0091%"}]
["J. Safra Sarasin"]
["  8. Nachhaltig Immobilien Schweiz","CH0049550269","Gemischt","2023-06-30",{"v":1652.73,"d":"1,652.73"},"* ","2023-05-31",{"v":724.1550251,"d":"724.16"},{"v":0.017829829369207,"d":"1.78%"},{"v":0.0013814414250659,"d":"0.14%"},{"v":2.463086489248E-5,"d":"0.0025%"}]
["SFP"]
["  9. Swiss Real Estate","CH0437532747","Gemischt","2023-06-30",{"v":1159.83,"d":"1,159.83"},null,"2023-05-31",{"v":538.011,"d":"538.01"},{"v":0.01324667232328,"d":"1.32%"},{"v":0.0021947826387509,"d":"0.22%"},{"v":2.9073566436359E-5,"d":"0.0029%"}]
["Swiss Life"]
["  10. Immobilien Schweiz Alter und Gesundheit ESG","CH0385556482","Gemischt","2023-06-30",131.54,null,"2023-05-31",{"v":444.6612,"d":"444.66"},{"v":0.01094825423881,"d":"1.09%"},{"v":0.0022095238095237,"d":"0.22%"},{"v":2.419042841337E-5,"d":"0.0024%"}]
["  11. Immobilien Schweiz ESG","CH0106150136","Gemischt","2023-06-30",199.02,null,"2023-05-31",{"v":3728.1128,"d":"3,728.11"},{"v":0.091791968279138,"d":"9.18%"},{"v":0.0024681408351383,"d":"0.25%"},{"v":0.00022655550524747,"d":"0.0227%"}]
["Swiss Prime"]
["  12. Immobilien Schweiz","CH0263627355","Gemischt","2023-06-30",{"v":1326.62,"d":"1,326.62"},null,"2023-05-31",{"v":2698.1,"d":"2,698.10"},{"v":0.066431442099591,"d":"6.64%"},{"v":-0.0048160595330974,"d":"-0.48%"},{"v":-0.00031993778002114,"d":"-0.0320%"}]
["Swisscanto"]
["  13. Immobilien Responsible Schweiz","CH0002875893","Gemischt","2023-06-30",268.63,null,"2023-05-31",{"v":8469.1059,"d":"8,469.11"},{"v":0.20852263379087,"d":"20.85%"},{"v":0.0034740381023535,"d":"0.35%"},{"v":0.00072441557499259,"d":"0.0724%"}]
["Tellco"]
["  14. Immobilien Schweiz","CH0024559798","Gemischt","2023-06-30",{"v":196.237,"d":"196.24"},null,"2023-05-31",{"v":1062.4647923,"d":"1,062.46"},{"v":0.026159544988151,"d":"2.62%"},{"v":0.0026891733563876,"d":"0.27%"},{"v":7.034755139736E-5,"d":"0.0070%"}]
["Turidomus"]
["  15. Urban & Mixed-use","CH0307702511","Gemischt","2023-06-30",{"v":1035.8,"d":"1,035.80"},null,"2022-12-30",{"v":1289.1,"d":"1,289.10"},{"v":0.03173965828197,"d":"3.17%"},{"v":0.0019830713422007,"d":"0.20%"},{"v":6.2942006750216E-5,"d":"0.0063%"}]
["UBS 1"]
["  16. Immobilien Schweiz","CH0002875497","Gemischt","2023-06-30",{"v":2016.46,"d":"2,016.46"},null,"2023-05-31",{"v":2625.9157,"d":"2,625.92"},{"v":0.06465415173009,"d":"6.47%"},{"v":0.0019378304249316,"d":"0.19%"},{"v":0.00012528878232071,"d":"0.0125%"}]
["Gesamtsumme",{"$nulls":6},{"$f":"SUM(H2:H31)","v":{"v":40614.8039953,"d":"40,614.80"}},{"$f":"SUM(I2:I31)","v":{"v":1,"d":"100.00%"}},null,{"$f":"SUM(K2:K31)","v":{"v":0.00082199154771257,"d":"0.0822%"}}]
[]
["* Kein offizieller Handelskurs."]

{"sheet":"KGAST Immo-Index Wohnen","index":2,"n_rows":33,"n_cols":11,"rows_kept":33,"merged":[[0,3,0,5],[0,6,0,7]]}
["2023-06-30","ISIN","Kategoriserung","NAV",null,null,"Nettovermögen",null,"Gewicht","Perf.","Beitrag"]
["Adimora"]
["  1. Omega (Wohnimmobilien)","CH0149835834","Wohnen","2023-06-30",{"v":1402.4,"d":"1,402.40"},null,"2022-09-30",379.14,{"v":0.0186706224811,"d":"1.87%"},{"v":0.0020721686316543,"d":"0.21%"},{"v":3.8688678238795E-5,"d":"0.0039%"}]
["ASSETIMMO"]
["  2. Anlagegruppe W","CH0010493457","Wohnen","2023-06-30",594.07,null,"2023-05-31",{"v":1837.409,"d":"1,837.41"},{"v":0.090482591608313,"d":"9.05%"},{"v":0.0043691792184755,"d":"0.44%"},{"v":0.00039533465888884,"d":"0.0395%"}]
["Avadis"]
["  3. Immobilien Schweiz Wohnen","CH0009359354","Wohnen","2023-06-30",{"v":173031.1696472,"d":"173,031.17"},null,"2023-05-31",{"v":3344.7078,"d":"3,344.71"},{"v":0.1647090168365,"d":"16.47%"},{"v":0.0026502262840462,"d":"0.27%"},{"v":0.0004365161656395,"d":"0.0437%"}]
["  4. Immobilien Schweiz Wohnen Mittelzentren","CH0547737087","Wohnen","2023-06-30",{"v":1170.7987814,"d":"1,170.80"},null,"2023-05-31",{"v":289.1185,"d":"289.12"},{"v":0.014237543824977,"d":"1.42%"},{"v":0.0023962169520548,"d":"0.24%"},{"v":3.4116243869034E-5,"d":"0.0034%"}]
["CSA"]
["  5. Real Estate Switzerland Residential","CH0025226090","Wohnen","2023-06-30",{"v":2241.49,"d":"2,241.49"},null,"2023-05-31",{"v":1074.4312,"d":"1,074.43"},{"v":0.052910005056484,"d":"5.29%"},{"v":-0.0068235492203874,"d":"-0.68%"},{"v":-0.00036103402375387,"d":"-0.0361%"}]
["Greenbrix"]
["  6. Greenbrix Housing – Wohngebäude in der Schweiz","CH0224042157","Wohnen","2023-06-30",{"v":11055,"d":"11,055.00"},"* ","2023-05-31",{"v":359.834807,"d":"359.83"},{"v":0.017719944709228,"d":"1.77%"},{"v":0.0027210884353743,"d":"0.27%"},{"v":4.8217536623752E-5,"d":"0.0048%"}]
["HIG"]
["  7. CH-Classico","CH0002875208","Wohnen","2023-06-30",{"v":13834,"d":"13,834.00"},"* ","2023-05-31",{"v":1030.935,"d":"1,030.94"},{"v":0.050768049236569,"d":"5.08%"},{"v":0.0036273940800928,"d":"0.36%"},{"v":0.00018415572125859,"d":"0.0184%"}]
["IST"]
["  8. Immobilien Schweiz Fokus","CH0002598578","Wohnen","2023-06-30",{"v":314826.36,"d":"314,826.36"},"* ","2023-05-31",{"v":316.878,"d":"316.88"},{"v":0.015604551117176,"d":"1.56%"},{"v":0.0024671746554721,"d":"0.25%"},{"v":3.8499153026315E-5,"d":"0.0038%"}]
["  9. Immobilien Schweiz Wohnen","CH0245229122","Wohnen","2023-06-30",138.13,"* ","2023-05-31",{"v":327.4198,"d":"327.42"},{"v":0.016123678532039,"d":"1.61%"},{"v":0.0025402816083611,"d":"0.25%"},{"v":4.0958684034065E-5,"d":"0.0041%"}]
["Patrimonium"]
["  10. Wohnimmobilien Schweiz","CH0112589673","Wohnen","2023-06-30",{"v":1793.15,"d":"1,793.15"},"* ","2023-05-31",{"v":711.035752,"d":"711.04"},{"v":0.035014717772214,"d":"3.50%"},{"v":-0.0080873119921229,"d":"-0.81%"},{"v":-0.00028317494694002,"d":"-0.0283%"}]
["Pensimo"]
["  11. Casareal (Wohnimmobilien)","CH0020488190","Wohnen","2023-06-30",{"v":1387.4,"d":"1,387.40"},null,"2022-12-30",{"v":2232.62,"d":"2,232.62"},{"v":0.10994462510881,"d":"10.99%"},{"v":0.0021670037561399,"d":"0.22%"},{"v":0.00023825041557818,"d":"0.0238%"}]
["Prisma"]
["  12. Previous Responsible Residential Real Estate","CH0298011104","Wohnen","2023-06-30",{"v":1120.36,"d":"1,120.36"},"* ","2023-03-31",{"v":110.017759,"d":"110.02"},{"v":0.00541778774201,"d":"0.54%"},{"v":0.00032142857142858,"d":"0.03%"},{"v":1.7414317742176E-6,"d":"0.0002%"}]
["Terra Helvetica"]
["  13. Wohnen Schweiz","CH0544073437","Wohnen","2023-06-30",{"v":1075.78,"d":"1,075.78"},"* ","2023-03-31",{"v":123.272129,"d":"123.27"},{"v":0.0060704947591931,"d":"0.61%"},{"v":0.0016573556797022,"d":"0.17%"},{"v":1.0060968967751E-5,"d":"0.0010%"}]
["Turidomus"]
["  14. Casareal (Wohnimmobilien)","CH0020488026","Wohnen","2023-06-30",{"v":1695,"d":"1,695.00"},null,"2022-12-30",{"v":4541.13,"d":"4,541.13"},{"v":0.2236264278831,"d":"22.36%"},{"v":0.0021580394359535,"d":"0.22%"},{"v":0.00048259465029314,"d":"0.0483%"}]
["Zürich"]
["  15. Immobilien – Traditionell Schweiz","CH0023842187","Wohnen","2023-06-30",{"v":3133.3858,"d":"3,133.39"},null,"2023-05-31",{"v":728.3905589,"d":"728.39"},{"v":0.035869349432978,"d":"3.59%"},{"v":-0.00066627865526847,"d":"-0.07%"},{"v":-2.389898190556E-5,"d":"-0.0024%"}]
["  16. Immobilien – Wohnen Schweiz","CH0018192903","Wohnen","2023-06-30",{"v":3316.371,"d":"3,316.37"},null,"2023-05-31",{"v":2900.4277402,"d":"2,900.43"},{"v":0.14283059389931,"d":"14.28%"},{"v":-0.0023424580608796,"d":"-0.23%"},{"v":-0.00033457467601966,"d":"-0.0335%"}]
["Gesamtsumme",{"$nulls":6},{"$f":"SUM(H2:H30)","v":{"v":20306.7680461,"d":"20,306.77"}},{"$f":"SUM(I2:I30)","v":{"v":1,"d":"100.00%"}},null,{"$f":"SUM(K2:K30)","v":{"v":0.00094645167957307,"d":"0.0946%"}}]
[]
["* Kein offizieller Handelskurs."]

{"sheet":"KGAST Immo-Index Geschäft","index":3,"n_rows":28,"n_cols":11,"rows_kept":28,"merged":[[0,3,0,5],[0,6,0,7]]}
["2023-06-30","ISIN","Kategoriserung","NAV",null,null,"Nettovermögen",null,"Gewicht","Perf.","Beitrag"]
["ASSETIMMO"]
["  1. Anlagegruppe G","CH0010493499","Geschäft","2023-06-30",441.28,null,"2023-05-31",{"v":789.772,"d":"789.77"},{"v":0.083927853097342,"d":"8.39%"},{"v":0.0052244753387052,"d":"0.52%"},{"v":0.00043847899873754,"d":"0.0438%"}]
["Avadis"]
["  2. Immobilien Schweiz Geschäft","CH0141268083","Geschäft","2023-06-30",{"v":138716.8157128,"d":"138,716.82"},null,"2023-05-31",{"v":911.3374,"d":"911.34"},{"v":0.096846420776267,"d":"9.68%"},{"v":0.002270229678472,"d":"0.23%"},{"v":0.00021986361870007,"d":"0.0220%"}]
["CSA"]
["  3. Real Estate Switzerland Commercial","CH0113543620","Geschäft","2023-06-30",{"v":1682.24,"d":"1,682.24"},null,"2023-05-31",{"v":1447.5138,"d":"1,447.51"},{"v":0.15382506035004,"d":"15.38%"},{"v":-0.020153304909019,"d":"-2.02%"},{"v":-0.0031000833438827,"d":"-0.3100%"}]
["DAI"]
["  4. Gewerbeimmobilien Schweiz DAGSIS","CH0347818491","Geschäft","2023-06-30",180.19,null,"2023-05-31",{"v":245.295878,"d":"245.30"},{"v":0.026067214859691,"d":"2.61%"},{"v":0.0027825699816348,"d":"0.28%"},{"v":7.2533849573401E-5,"d":"0.0073%"}]
["Ecoreal"]
["  5. SUISSESELECT","CH0181111045","Geschäft","2023-06-30",181.25,"* ","2023-05-31",{"v":532,"d":"532.00"},{"v":0.056534819983218,"d":"5.65%"},{"v":0.0033213396069747,"d":"0.33%"},{"v":0.00018777133678345,"d":"0.0188%"}]
["Patrimonium"]
["  6. Gesundheitsimmobilien Schweiz","CH0282527719","Geschäft","2023-06-30",{"v":1212.08,"d":"1,212.08"},"* ","2023-05-31",{"v":336.158527,"d":"336.16"},{"v":0.035723048514603,"d":"3.57%"},{"v":0.0027715039752467,"d":"0.28%"},{"v":9.9006570966154E-5,"d":"0.0099%"}]
["Pensimo"]
["  7. Proreal (Geschäftsimmobilien)","CH0020488224","Geschäft","2023-06-30",{"v":1334.8,"d":"1,334.80"},null,"2022-12-30",514.51,{"v":0.05467618464204,"d":"5.47%"},{"v":0.0026290092390897,"d":"0.26%"},{"v":0.0001437441945821,"d":"0.0144%"}]
["Swiss Life"]
["  8. Geschäftsimmobilien Schweiz ESG","CH0136837587","Geschäft","2023-06-30",173.65,null,"2023-05-31",{"v":1895.7303,"d":"1,895.73"},{"v":0.20145633693089,"d":"20.15%"},{"v":0.0021931090206036,"d":"0.22%"},{"v":0.00044181570978088,"d":"0.0442%"}]
["Tellco"]
["  9. Kommerzielle Immobilien Schweiz","CH0598652672","Geschäft","2023-06-30",{"v":117.8084,"d":"117.81"},null,"2023-05-31",{"v":32.8174624,"d":"32.82"},{"v":0.0034874611449061,"d":"0.35%"},{"v":0.0040987833201935,"d":"0.41%"},{"v":1.4294347570564E-5,"d":"0.0014%"}]
["Turidomus"]
["  10. Proreal (Geschäftsimmobilien)","CH0020488067","Geschäft","2023-06-30",{"v":1245.1,"d":"1,245.10"},null,"2022-12-30",{"v":1304.05,"d":"1,304.05"},{"v":0.13857938345698,"d":"13.86%"},{"v":0.002738181525328,"d":"0.27%"},{"v":0.00037945550757326,"d":"0.0379%"}]
["UBS 1"]
["  11. Kommerzielle Immobilien Schweiz","CH0100770533","Geschäft","2023-06-30",{"v":1730.22,"d":"1,730.22"},null,"2023-05-31",{"v":645.9914,"d":"645.99"},{"v":0.068648510356592,"d":"6.86%"},{"v":0.0026134170863008,"d":"0.26%"},{"v":0.00017940718991502,"d":"0.0179%"}]
["Zürich"]
["  12. Immobilien – Geschäft Schweiz","CH0032598069","Geschäft","2023-06-30",{"v":2053.7741,"d":"2,053.77"},null,"2023-05-31",{"v":754.9531341,"d":"754.95"},{"v":0.080227705887424,"d":"8.02%"},{"v":0.00066604719892083,"d":"0.07%"},{"v":5.3435438782163E-5,"d":"0.0053%"}]
["Gesamtsumme",{"$nulls":6},{"$f":"SUM(H2:H25)","v":{"v":9410.1299015,"d":"9,410.13"}},{"$f":"SUM(I2:I25)","v":{"v":1,"d":"100.00%"}},null,{"$f":"SUM(K2:K25)","v":{"v":-0.00087027658091809,"d":"-0.0870%"}}]
[]
["* Kein offizieller Handelskurs."]