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

{"sheet":"KGAST Immo-Index","index":0,"n_rows":67,"n_cols":11,"rows_kept":67,"merged":[[0,3,0,5],[0,6,0,7]]}
["2022-06-30","ISIN","Kategoriserung","NAV",null,null,"Nettovermögen",null,"Gewicht","Perf.","Beitrag"]
[1291]
["  1. Immobilien Schweiz","CH0427260721","Gemischt","2022-06-30",{"v":119.0438,"d":"119.04"},"* ","2022-05-31",723.97,{"v":0.012947903397673,"d":"1.29%"},{"v":0.015719948737814,"d":"1.57%"},{"v":0.00020354037767358,"d":"0.0204%"}]
["Adimora"]
["  2. Omega (Wohnimmobilien)","CH0149835834","Wohnen","2022-06-30",{"v":1389.3,"d":"1,389.30"},null,"2021-09-30",346.56,{"v":0.0061980819667908,"d":"0.62%"},{"v":0.0020917484131562,"d":"0.21%"},{"v":1.2964828118647E-5,"d":"0.0013%"}]
["ASSETIMMO"]
["  3. Anlagegruppe G","CH0010493499","Geschäft","2022-06-30",432.43,null,"2022-05-31",{"v":787.956,"d":"787.96"},{"v":0.014092266488414,"d":"1.41%"},{"v":0.0054070153733359,"d":"0.54%"},{"v":7.6197101547998E-5,"d":"0.0076%"}]
["  4. Anlagegruppe W","CH0010493457","Wohnen","2022-06-30",573.56,null,"2022-05-31",{"v":1762.652,"d":"1,762.65"},{"v":0.03152430048167,"d":"3.15%"},{"v":0.0030219173896067,"d":"0.30%"},{"v":9.5263831820745E-5,"d":"0.0095%"}]
["Avadis"]
["  5. Immobilien Schweiz Geschäft","CH0141268083","Geschäft","2022-06-30",{"v":130551.6954528,"d":"130,551.70"},null,"2022-05-31",{"v":856.9831,"d":"856.98"},{"v":0.01532678756335,"d":"1.53%"},{"v":0.0031022376130219,"d":"0.31%"},{"v":4.7547336865819E-5,"d":"0.0048%"}]
["  6. Immobilien Schweiz Wohnen","CH0009359354","Wohnen","2022-06-30",{"v":161044.8004169,"d":"161,044.80"},null,"2022-05-31",{"v":2691.0316,"d":"2,691.03"},{"v":0.048127984856949,"d":"4.81%"},{"v":0.002376367107698,"d":"0.24%"},{"v":0.00011436976017384,"d":"0.0114%"}]
["avenirplus"]
["  7. Immobilien","CH0371634939","Gemischt","2022-06-30",{"v":1359.235,"d":"1,359.24"},null,"2022-05-31",{"v":158.8790457,"d":"158.88"},{"v":0.0028414858842743,"d":"0.28%"},{"v":0.00291007613863,"d":"0.29%"},{"v":8.2689402700807E-6,"d":"0.0008%"}]
["CSA"]
["  8. Real Estate Switzerland","CH0013123002","Gemischt","2022-06-30",{"v":1996.14,"d":"1,996.14"},null,"2022-05-31",{"v":6632.1518,"d":"6,632.15"},{"v":0.11861328622057,"d":"11.86%"},{"v":0.0044280294262684,"d":"0.44%"},{"v":0.00052522312173106,"d":"0.0525%"}]
["  9. Real Estate Switzerland Commercial","CH0113543620","Geschäft","2022-06-30",{"v":1693.25,"d":"1,693.25"},null,"2022-05-31",{"v":1560.015,"d":"1,560.02"},{"v":0.027900221720404,"d":"2.79%"},{"v":0.0031755623885443,"d":"0.32%"},{"v":8.8598894727362E-5,"d":"0.0089%"}]
["  10. Real Estate Switzerland Residential","CH0025226090","Wohnen","2022-06-30",{"v":2155.25,"d":"2,155.25"},null,"2022-05-31",{"v":983.0467,"d":"983.05"},{"v":0.017581382801775,"d":"1.76%"},{"v":0.0075357738893849,"d":"0.75%"},{"v":0.0001324893254569,"d":"0.0132%"}]
["DAI"]
["  11. Gewerbeimmobilien Schweiz DAGSIS","CH0347818491","Geschäft","2022-06-30",173.05,"* ","2022-05-31",{"v":229.142682,"d":"229.14"},{"v":0.0040981218984484,"d":"0.41%"},{"v":0.033813250492861,"d":"3.38%"},{"v":0.00013857082230252,"d":"0.0139%"}]
["Ecoreal"]
["  12. Suissecore Plus","CH0108524155","Gemischt","2022-06-30",176.78,"* ","2022-03-31",{"v":1094,"d":"1,094.00"},{"v":0.019565736587226,"d":"1.96%"},{"v":0.0033486576990749,"d":"0.33%"},{"v":6.5518954460886E-5,"d":"0.0066%"}]
["  13. Suisseselect","CH0181111045","Geschäft","2022-06-30",171.95,"* ","2022-03-31",{"v":503,"d":"503.00"},{"v":0.008995946529593,"d":"0.90%"},{"v":0.0042048706418265,"d":"0.42%"},{"v":3.7826791457727E-5,"d":"0.0038%"}]
["Greenbrix"]
["  14. Greenbrix Housing – Wohngebäude in der Schweiz","CH0224042157","Wohnen","2022-06-30",{"v":10867,"d":"10,867.00"},"* ","2022-05-31",{"v":342.388296,"d":"342.39"},{"v":0.0061234727697306,"d":"0.61%"},{"v":0.0023983027395997,"d":"0.24%"},{"v":1.4685941519509E-5,"d":"0.0015%"}]
["Helvetia"]
["  15. Immobilien Romandie","CH0301200108","Gemischt","2022-06-30",{"v":1377.21,"d":"1,377.21"},"* ","2022-05-31",{"v":556.1646,"d":"556.16"},{"v":0.0099467733663072,"d":"0.99%"},{"v":0.0033439699261268,"d":"0.33%"},{"v":3.3261710998931E-5,"d":"0.0033%"}]
["  16. Immobilien Schweiz","CH0188230780","Gemischt","2022-06-30",{"v":1413.56,"d":"1,413.56"},"* ","2022-05-31",{"v":898.9954,"d":"899.00"},{"v":0.01607816013668,"d":"1.61%"},{"v":0.0024679450811302,"d":"0.25%"},{"v":3.9680016222944E-5,"d":"0.0040%"}]
["HIG"]
["  17. CH-Classico","CH0002875208","Wohnen","2022-06-30",{"v":13204,"d":"13,204.00"},"* ","2022-05-31",{"v":900.776,"d":"900.78"},{"v":0.016110005429703,"d":"1.61%"},{"v":0.0038011251330394,"d":"0.38%"},{"v":6.1236146532246E-5,"d":"0.0061%"}]
["IST"]
["  18. Immobilien Schweiz Fokus","CH0002598578","Wohnen","2022-06-30",{"v":302511.65,"d":"302,511.65"},null,"2022-05-31",{"v":305.0335,"d":"305.03"},{"v":0.0054553977251185,"d":"0.55%"},{"v":0.00065806032435756,"d":"0.07%"},{"v":3.589980796491E-6,"d":"0.0004%"}]
["  19. Immobilien Schweiz Wohnen","CH0245229122","Wohnen","2022-06-30",133.03,null,"2022-05-31",{"v":288.5367,"d":"288.54"},{"v":0.0051603592942847,"d":"0.52%"},{"v":0.0026379258365994,"d":"0.26%"},{"v":1.361264510853E-5,"d":"0.0014%"}]
["J. Safra Sarasin"]
["  20. Nachhaltig Immobilien Schweiz","CH0049550269","Gemischt","2022-06-30",{"v":1594.9,"d":"1,594.90"},"* ","2022-05-31",{"v":698.1840181,"d":"698.18"},{"v":0.012486731798497,"d":"1.25%"},{"v":0.0022874954438621,"d":"0.23%"},{"v":2.856334209779E-5,"d":"0.0029%"}]
["Patrimonium"]
["  21. Gesundheitsimmobilien Schweiz","CH0282527719","Geschäft","2022-06-30",{"v":1214.13,"d":"1,214.13"},"* ","2022-05-31",{"v":259.282573,"d":"259.28"},{"v":0.0046371613573823,"d":"0.46%"},{"v":0.007033550367022,"d":"0.70%"},{"v":3.2615707967157E-5,"d":"0.0033%"}]
["  22. Wohnimmobilien Schweiz","CH0112589673","Wohnen","2022-06-30",{"v":1794.32,"d":"1,794.32"},"* ","2022-05-31",{"v":593.066902,"d":"593.07"},{"v":0.010606755743267,"d":"1.06%"},{"v":0.015771656306964,"d":"1.58%"},{"v":0.00016728610611473,"d":"0.0167%"}]
["Pensimo"]
["  23. Casareal (Wohnimmobilien)","CH0020488190","Wohnen","2022-06-30",{"v":1374.7,"d":"1,374.70"},null,"2021-12-31",{"v":2090.15,"d":"2,090.15"},{"v":0.037381466478785,"d":"3.74%"},{"v":0.0021870671429614,"d":"0.22%"},{"v":8.1755777091462E-5,"d":"0.0082%"}]
["  24. Proreal (Geschäftsimmobilien)","CH0020488224","Geschäft","2022-06-30",{"v":1324.95,"d":"1,324.95"},null,"2021-12-31",511.53,{"v":0.0091485020442997,"d":"0.91%"},{"v":0.002648605698286,"d":"0.26%"},{"v":2.4230774645313E-5,"d":"0.0024%"}]
["SFP"]
["  25. Swiss Real Estate","CH0437532747","Gemischt","2022-06-30",{"v":1145.96,"d":"1,145.96"},null,"2022-05-31",{"v":326.959,"d":"326.96"},{"v":0.0058475262055054,"d":"0.58%"},{"v":0.0054662069086537,"d":"0.55%"},{"v":3.1963788143067E-5,"d":"0.0032%"}]
["Swiss Life"]
["  26. Geschäftsimmobilien Schweiz ESG","CH0136837587","Geschäft","2022-06-30",170.48,null,"2022-05-31",{"v":1859.8782,"d":"1,859.88"},{"v":0.033263150772874,"d":"3.33%"},{"v":0.0028235294117647,"d":"0.28%"},{"v":9.3919484535173E-5,"d":"0.0094%"}]
["  27. Immobilien Schweiz Alter und Gesundheit ESG","CH0385556482","Gemischt","2022-06-30",{"v":128.1,"d":"128.10"},null,"2022-05-31",{"v":393.7117,"d":"393.71"},{"v":0.0070413705790759,"d":"0.70%"},{"v":0.0023474178403755,"d":"0.23%"},{"v":1.6529038918018E-5,"d":"0.0017%"}]
["  28. Immobilien Schweiz ESG","CH0106150136","Gemischt","2022-06-30",195.11,null,"2022-05-31",{"v":3304.2275,"d":"3,304.23"},{"v":0.0590947393869,"d":"5.91%"},{"v":0.0023117230042125,"d":"0.23%"},{"v":0.00013661066846864,"d":"0.0137%"}]
["Swiss Prime"]
["  29. Immobilien Schweiz","CH0263627355","Gemischt","2022-06-30",{"v":1287.64,"d":"1,287.64"},null,"2022-05-31",{"v":2289.7,"d":"2,289.70"},{"v":0.040950335524472,"d":"4.10%"},{"v":0.00316302840493,"d":"0.32%"},{"v":0.00012952707445532,"d":"0.0130%"}]
["Swisscanto"]
["  30. Immobilien Responsible Schweiz","CH0002875893","Gemischt","2022-06-30",254.64,null,"2022-05-31",{"v":7856.6585,"d":"7,856.66"},{"v":0.14051308104826,"d":"14.05%"},{"v":0.0034283012176379,"d":"0.34%"},{"v":0.00048172116685179,"d":"0.0482%"}]
["Tellco"]
["  31. Immobilien Schweiz","CH0024559798","Gemischt","2022-06-30",{"v":189.1082,"d":"189.11"},null,"2022-05-31",{"v":1146.1587796,"d":"1,146.16"},{"v":0.020498574742953,"d":"2.05%"},{"v":0.0041982268253207,"d":"0.42%"},{"v":8.6057666366705E-5,"d":"0.0086%"}]
["  32. Kommerzielle Immobilien Schweiz","CH0598652672","Geschäft","2022-06-30",{"v":110.7254,"d":"110.73"},null,"2022-05-31",{"v":23.9316948,"d":"23.93"},{"v":0.00042800844290922,"d":"0.04%"},{"v":0.013409262101605,"d":"1.34%"},{"v":5.7392773926697E-6,"d":"0.0006%"}]
["Turidomus"]
["  33. Casareal (Wohnimmobilien)","CH0020488026","Wohnen","2022-06-30",{"v":1678.95,"d":"1,678.95"},null,"2021-12-31",{"v":3899.57,"d":"3,899.57"},{"v":0.069742193257267,"d":"6.97%"},{"v":0.0021787142601326,"d":"0.22%"},{"v":0.00015194831098253,"d":"0.0152%"}]
["  34. Proreal (Geschäftsimmobilien)","CH0020488067","Geschäft","2022-06-30",{"v":1219.65,"d":"1,219.65"},null,"2021-12-31",{"v":1193.43,"d":"1,193.43"},{"v":0.021344000928056,"d":"2.13%"},{"v":0.002919167831593,"d":"0.29%"},{"v":6.2306720906672E-5,"d":"0.0062%"}]
["  35. Urban & Mixed-use","CH0307702511","Gemischt","2022-06-30",{"v":1031.6,"d":"1,031.60"},null,"2021-12-31",872.92,{"v":0.015611812414736,"d":"1.56%"},{"v":0.0020398251578435,"d":"0.20%"},{"v":3.1845367723113E-5,"d":"0.0032%"}]
["UBS 1"]
["  36. Immobilien Schweiz","CH0002875497","Gemischt","2022-06-30",{"v":1956.79,"d":"1,956.79"},null,"2022-05-31",{"v":2387.4649,"d":"2,387.46"},{"v":0.042698820241909,"d":"4.27%"},{"v":0.0032402446589797,"d":"0.32%"},{"v":0.00013835462423358,"d":"0.0138%"}]
["  37. Kommerzielle Immobilien Schweiz","CH0100770533","Geschäft","2022-06-30",{"v":1701.3,"d":"1,701.30"},null,"2022-05-31",{"v":702.077,"d":"702.08"},{"v":0.012556356166316,"d":"1.26%"},{"v":0.0023330623210436,"d":"0.23%"},{"v":2.9294761461236E-5,"d":"0.0029%"}]
["Zürich"]
["  38. Immobilien – Geschäft Schweiz","CH0032598069","Geschäft","2022-06-30",{"v":2007.9524,"d":"2,007.95"},null,"2022-05-31",{"v":737.705226,"d":"737.71"},{"v":0.013193552222062,"d":"1.32%"},{"v":0.0022880962738507,"d":"0.23%"},{"v":3.0188117678156E-5,"d":"0.0030%"}]
["  39. Immobilien – Traditionell Schweiz","CH0023842187","Wohnen","2022-06-30",{"v":3025.7383,"d":"3,025.74"},null,"2022-05-31",{"v":711.518476,"d":"711.52"},{"v":0.012725213051518,"d":"1.27%"},{"v":0.0017877796880124,"d":"0.18%"},{"v":2.2749877419134E-5,"d":"0.0023%"}]
["  40. Immobilien – Wohnen Schweiz","CH0018192903","Wohnen","2022-06-30",{"v":3237.8079,"d":"3,237.81"},null,"2022-05-31",{"v":2434.6648885,"d":"2,434.66"},{"v":0.043542972474003,"d":"4.35%"},{"v":0.0016006763525775,"d":"0.16%"},{"v":6.9698206360072E-5,"d":"0.0070%"}]
["Gesamtsumme",{"$nulls":6},{"$f":"SUM(H2:H64)","v":{"v":55914.0717817,"d":"55,914.07"}},{"$f":"SUM(I2:I64)","v":{"v":1,"d":"100.00%"}},null,{"$f":"SUM(K2:K64)","v":{"v":0.0035653523875981,"d":"0.3565%"}}]
[]
["* Kein offizieller Handelskurs."]

{"sheet":"KGAST Immo-Index Gemischt","index":1,"n_rows":32,"n_cols":11,"rows_kept":32,"merged":[[0,3,0,5],[0,6,0,7]]}
["2022-06-30","ISIN","Kategoriserung","NAV",null,null,"Nettovermögen",null,"Gewicht","Perf.","Beitrag"]
[1291]
["  1. Immobilien Schweiz","CH0427260721","Gemischt","2022-06-30",{"v":119.0438,"d":"119.04"},"* ","2022-05-31",723.97,{"v":0.024675065307076,"d":"2.47%"},{"v":0.015719948737814,"d":"1.57%"},{"v":0.00038789076172944,"d":"0.0388%"}]
["avenirplus"]
["  2. Immobilien","CH0371634939","Gemischt","2022-06-30",{"v":1359.235,"d":"1,359.24"},null,"2022-05-31",{"v":158.8790457,"d":"158.88"},{"v":0.0054150735922393,"d":"0.54%"},{"v":0.00291007613863,"d":"0.29%"},{"v":1.5758276449701E-5,"d":"0.0016%"}]
["CSA"]
["  3. Real Estate Switzerland","CH0013123002","Gemischt","2022-06-30",{"v":1996.14,"d":"1,996.14"},null,"2022-05-31",{"v":6632.1518,"d":"6,632.15"},{"v":0.22604359129721,"d":"22.60%"},{"v":0.0044280294262684,"d":"0.44%"},{"v":0.0010009276738835,"d":"0.1001%"}]
["Ecoreal"]
["  4. Suissecore Plus","CH0108524155","Gemischt","2022-06-30",176.78,"* ","2022-03-31",{"v":1094,"d":"1,094.00"},{"v":0.03728679564891,"d":"3.73%"},{"v":0.0033486576990749,"d":"0.33%"},{"v":0.00012486071532356,"d":"0.0125%"}]
["Helvetia"]
["  5. Immobilien Romandie","CH0301200108","Gemischt","2022-06-30",{"v":1377.21,"d":"1,377.21"},"* ","2022-05-31",{"v":556.1646,"d":"556.16"},{"v":0.018955754833051,"d":"1.90%"},{"v":0.0033439699261268,"d":"0.33%"},{"v":6.3387474088756E-5,"d":"0.0063%"}]
["  6. Immobilien Schweiz","CH0188230780","Gemischt","2022-06-30",{"v":1413.56,"d":"1,413.56"},"* ","2022-05-31",{"v":898.9954,"d":"899.00"},{"v":0.030640454999187,"d":"3.06%"},{"v":0.0024679450811302,"d":"0.25%"},{"v":7.5618960198835E-5,"d":"0.0076%"}]
["J. Safra Sarasin"]
["  7. Nachhaltig Immobilien Schweiz","CH0049550269","Gemischt","2022-06-30",{"v":1594.9,"d":"1,594.90"},"* ","2022-05-31",{"v":698.1840181,"d":"698.18"},{"v":0.023796201835676,"d":"2.38%"},{"v":0.0022874954438621,"d":"0.23%"},{"v":5.4433703280332E-5,"d":"0.0054%"}]
["SFP"]
["  8. Swiss Real Estate","CH0437532747","Gemischt","2022-06-30",{"v":1145.96,"d":"1,145.96"},null,"2022-05-31",{"v":326.959,"d":"326.96"},{"v":0.011143741698878,"d":"1.11%"},{"v":0.0054662069086537,"d":"0.55%"},{"v":6.0913997862657E-5,"d":"0.0061%"}]
["Swiss Life"]
["  9. Immobilien Schweiz Alter und Gesundheit ESG","CH0385556482","Gemischt","2022-06-30",{"v":128.1,"d":"128.10"},null,"2022-05-31",{"v":393.7117,"d":"393.71"},{"v":0.013418873585452,"d":"1.34%"},{"v":0.0023474178403755,"d":"0.23%"},{"v":3.1499703252235E-5,"d":"0.0031%"}]
["  10. Immobilien Schweiz ESG","CH0106150136","Gemischt","2022-06-30",195.11,null,"2022-05-31",{"v":3304.2275,"d":"3,304.23"},{"v":0.11261796670019,"d":"11.26%"},{"v":0.0023117230042125,"d":"0.23%"},{"v":0.00026034154430846,"d":"0.0260%"}]
["Swiss Prime"]
["  11. Immobilien Schweiz","CH0263627355","Gemischt","2022-06-30",{"v":1287.64,"d":"1,287.64"},null,"2022-05-31",{"v":2289.7,"d":"2,289.70"},{"v":0.078039831807413,"d":"7.80%"},{"v":0.00316302840493,"d":"0.32%"},{"v":0.00024684220472281,"d":"0.0247%"}]
["Swisscanto"]
["  12. Immobilien Responsible Schweiz","CH0002875893","Gemischt","2022-06-30",254.64,null,"2022-05-31",{"v":7856.6585,"d":"7,856.66"},{"v":0.26777844604458,"d":"26.78%"},{"v":0.0034283012176379,"d":"0.34%"},{"v":0.00091802517263183,"d":"0.0918%"}]
["Tellco"]
["  13. Immobilien Schweiz","CH0024559798","Gemischt","2022-06-30",{"v":189.1082,"d":"189.11"},null,"2022-05-31",{"v":1146.1587796,"d":"1,146.16"},{"v":0.039064523031215,"d":"3.91%"},{"v":0.0041982268253207,"d":"0.42%"},{"v":0.000164001728508,"d":"0.0164%"}]
["Turidomus"]
["  14. Urban & Mixed-use","CH0307702511","Gemischt","2022-06-30",{"v":1031.6,"d":"1,031.60"},null,"2021-12-31",872.92,{"v":0.029751727292364,"d":"2.98%"},{"v":0.0020398251578435,"d":"0.20%"},{"v":6.0688321820264E-5,"d":"0.0061%"}]
["UBS 1"]
["  15. Immobilien Schweiz","CH0002875497","Gemischt","2022-06-30",{"v":1956.79,"d":"1,956.79"},null,"2022-05-31",{"v":2387.4649,"d":"2,387.46"},{"v":0.08137195232655,"d":"8.14%"},{"v":0.0032402446589797,"d":"0.32%"},{"v":0.00026366503391685,"d":"0.0264%"}]
["Gesamtsumme",{"$nulls":6},{"$f":"SUM(H2:H29)","v":{"v":29340.1452434,"d":"29,340.15"}},{"$f":"SUM(I2:I29)","v":{"v":1,"d":"100.00%"}},null,{"$f":"SUM(K2:K29)","v":{"v":0.0037288552719772,"d":"0.3729%"}}]
[]
["* 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]]}
["2022-06-30","ISIN","Kategoriserung","NAV",null,null,"Nettovermögen",null,"Gewicht","Perf.","Beitrag"]
["Adimora"]
["  1. Omega (Wohnimmobilien)","CH0149835834","Wohnen","2022-06-30",{"v":1389.3,"d":"1,389.30"},null,"2021-09-30",346.56,{"v":0.019975796796962,"d":"2.00%"},{"v":0.0020917484131562,"d":"0.21%"},{"v":4.1784341251576E-5,"d":"0.0042%"}]
["ASSETIMMO"]
["  2. Anlagegruppe W","CH0010493457","Wohnen","2022-06-30",573.56,null,"2022-05-31",{"v":1762.652,"d":"1,762.65"},{"v":0.10159966001777,"d":"10.16%"},{"v":0.0030219173896067,"d":"0.30%"},{"v":0.00030702577938583,"d":"0.0307%"}]
["Avadis"]
["  3. Immobilien Schweiz Wohnen","CH0009359354","Wohnen","2022-06-30",{"v":161044.8004169,"d":"161,044.80"},null,"2022-05-31",{"v":2691.0316,"d":"2,691.03"},{"v":0.15511167017487,"d":"15.51%"},{"v":0.002376367107698,"d":"0.24%"},{"v":0.00036860227102366,"d":"0.0369%"}]
["CSA"]
["  4. Real Estate Switzerland Residential","CH0025226090","Wohnen","2022-06-30",{"v":2155.25,"d":"2,155.25"},null,"2022-05-31",{"v":983.0467,"d":"983.05"},{"v":0.056663034167602,"d":"5.67%"},{"v":0.0075357738893849,"d":"0.75%"},{"v":0.00042699981337354,"d":"0.0427%"}]
["Greenbrix"]
["  5. Greenbrix Housing – Wohngebäude in der Schweiz","CH0224042157","Wohnen","2022-06-30",{"v":10867,"d":"10,867.00"},"* ","2022-05-31",{"v":342.388296,"d":"342.39"},{"v":0.019735338834701,"d":"1.97%"},{"v":0.0023983027395997,"d":"0.24%"},{"v":4.7331317194194E-5,"d":"0.0047%"}]
["HIG"]
["  6. CH-Classico","CH0002875208","Wohnen","2022-06-30",{"v":13204,"d":"13,204.00"},"* ","2022-05-31",{"v":900.776,"d":"900.78"},{"v":0.051920932408762,"d":"5.19%"},{"v":0.0038011251330394,"d":"0.38%"},{"v":0.00019735796110978,"d":"0.0197%"}]
["IST"]
["  7. Immobilien Schweiz Fokus","CH0002598578","Wohnen","2022-06-30",{"v":302511.65,"d":"302,511.65"},null,"2022-05-31",{"v":305.0335,"d":"305.03"},{"v":0.017582199943058,"d":"1.76%"},{"v":0.00065806032435756,"d":"0.07%"},{"v":1.1570148197448E-5,"d":"0.0012%"}]
["  8. Immobilien Schweiz Wohnen","CH0245229122","Wohnen","2022-06-30",133.03,null,"2022-05-31",{"v":288.5367,"d":"288.54"},{"v":0.016631320659239,"d":"1.66%"},{"v":0.0026379258365994,"d":"0.26%"},{"v":4.3872190463777E-5,"d":"0.0044%"}]
["Patrimonium"]
["  9. Wohnimmobilien Schweiz","CH0112589673","Wohnen","2022-06-30",{"v":1794.32,"d":"1,794.32"},"* ","2022-05-31",{"v":593.066902,"d":"593.07"},{"v":0.034184510391724,"d":"3.42%"},{"v":0.015771656306964,"d":"1.58%"},{"v":0.00053914634892011,"d":"0.0539%"}]
["Pensimo"]
["  10. Casareal (Wohnimmobilien)","CH0020488190","Wohnen","2022-06-30",{"v":1374.7,"d":"1,374.70"},null,"2021-12-31",{"v":2090.15,"d":"2,090.15"},{"v":0.12047671882263,"d":"12.05%"},{"v":0.0021870671429614,"d":"0.22%"},{"v":0.00026349067322877,"d":"0.0263%"}]
["Turidomus"]
["  11. Casareal (Wohnimmobilien)","CH0020488026","Wohnen","2022-06-30",{"v":1678.95,"d":"1,678.95"},null,"2021-12-31",{"v":3899.57,"d":"3,899.57"},{"v":0.22477209694001,"d":"22.48%"},{"v":0.0021787142601326,"d":"0.22%"},{"v":0.00048971417288311,"d":"0.0490%"}]
["Zürich"]
["  12. Immobilien – Traditionell Schweiz","CH0023842187","Wohnen","2022-06-30",{"v":3025.7383,"d":"3,025.74"},null,"2022-05-31",{"v":711.518476,"d":"711.52"},{"v":0.04101208591257,"d":"4.10%"},{"v":0.0017877796880124,"d":"0.18%"},{"v":7.332057415751E-5,"d":"0.0073%"}]
["  13. Immobilien – Wohnen Schweiz","CH0018192903","Wohnen","2022-06-30",{"v":3237.8079,"d":"3,237.81"},null,"2022-05-31",{"v":2434.6648885,"d":"2,434.66"},{"v":0.1403346349301,"d":"14.03%"},{"v":0.0016006763525775,"d":"0.16%"},{"v":0.00022463033158021,"d":"0.0225%"}]
["Gesamtsumme",{"$nulls":6},{"$f":"SUM(H2:H25)","v":{"v":17348.9950625,"d":"17,349.00"}},{"$f":"SUM(I2:I25)","v":{"v":1,"d":"100.00%"}},null,{"$f":"SUM(K2:K25)","v":{"v":0.0030348459227695,"d":"0.3035%"}}]
[]
["* 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]]}
["2022-06-30","ISIN","Kategoriserung","NAV",null,null,"Nettovermögen",null,"Gewicht","Perf.","Beitrag"]
["ASSETIMMO"]
["  1. Anlagegruppe G","CH0010493499","Geschäft","2022-06-30",432.43,null,"2022-05-31",{"v":787.956,"d":"787.96"},{"v":0.085415919030625,"d":"8.54%"},{"v":0.0054070153733359,"d":"0.54%"},{"v":0.0004618451873262,"d":"0.0462%"}]
["Avadis"]
["  2. Immobilien Schweiz Geschäft","CH0141268083","Geschäft","2022-06-30",{"v":130551.6954528,"d":"130,551.70"},null,"2022-05-31",{"v":856.9831,"d":"856.98"},{"v":0.092898587078738,"d":"9.29%"},{"v":0.0031022376130219,"d":"0.31%"},{"v":0.00028819349103225,"d":"0.0288%"}]
["CSA"]
["  3. Real Estate Switzerland Commercial","CH0113543620","Geschäft","2022-06-30",{"v":1693.25,"d":"1,693.25"},null,"2022-05-31",{"v":1560.015,"d":"1,560.02"},{"v":0.16910857322815,"d":"16.91%"},{"v":0.0031755623885443,"d":"0.32%"},{"v":0.00053701482472371,"d":"0.0537%"}]
["DAI"]
["  4. Gewerbeimmobilien Schweiz DAGSIS","CH0347818491","Geschäft","2022-06-30",173.05,"* ","2022-05-31",{"v":229.142682,"d":"229.14"},{"v":0.024839499632178,"d":"2.48%"},{"v":0.033813250492861,"d":"3.38%"},{"v":0.00083990422318016,"d":"0.0840%"}]
["Ecoreal"]
["  5. Suisseselect","CH0181111045","Geschäft","2022-06-30",171.95,"* ","2022-03-31",{"v":503,"d":"503.00"},{"v":0.054526150283016,"d":"5.45%"},{"v":0.0042048706418265,"d":"0.42%"},{"v":0.00022927540853688,"d":"0.0229%"}]
["Patrimonium"]
["  6. Gesundheitsimmobilien Schweiz","CH0282527719","Geschäft","2022-06-30",{"v":1214.13,"d":"1,214.13"},"* ","2022-05-31",{"v":259.282573,"d":"259.28"},{"v":0.028106720757784,"d":"2.81%"},{"v":0.007033550367022,"d":"0.70%"},{"v":0.00019769003610169,"d":"0.0198%"}]
["Pensimo"]
["  7. Proreal (Geschäftsimmobilien)","CH0020488224","Geschäft","2022-06-30",{"v":1324.95,"d":"1,324.95"},null,"2021-12-31",511.53,{"v":0.055450818398154,"d":"5.55%"},{"v":0.002648605698286,"d":"0.26%"},{"v":0.00014686735358397,"d":"0.0147%"}]
["Swiss Life"]
["  8. Geschäftsimmobilien Schweiz ESG","CH0136837587","Geschäft","2022-06-30",170.48,null,"2022-05-31",{"v":1859.8782,"d":"1,859.88"},{"v":0.2016143106189,"d":"20.16%"},{"v":0.0028235294117647,"d":"0.28%"},{"v":0.00056926393586512,"d":"0.0569%"}]
["Tellco"]
["  9. Kommerzielle Immobilien Schweiz","CH0598652672","Geschäft","2022-06-30",{"v":110.7254,"d":"110.73"},null,"2022-05-31",{"v":23.9316948,"d":"23.93"},{"v":0.0025942409288113,"d":"0.26%"},{"v":0.013409262101605,"d":"1.34%"},{"v":3.4786856569142E-5,"d":"0.0035%"}]
["Turidomus"]
["  10. Proreal (Geschäftsimmobilien)","CH0020488067","Geschäft","2022-06-30",{"v":1219.65,"d":"1,219.65"},null,"2021-12-31",{"v":1193.43,"d":"1,193.43"},{"v":0.12937006666453,"d":"12.94%"},{"v":0.002919167831593,"d":"0.29%"},{"v":0.00037765293697814,"d":"0.0378%"}]
["UBS 1"]
["  11. Kommerzielle Immobilien Schweiz","CH0100770533","Geschäft","2022-06-30",{"v":1701.3,"d":"1,701.30"},null,"2022-05-31",{"v":702.077,"d":"702.08"},{"v":0.076106473185386,"d":"7.61%"},{"v":0.0023330623210436,"d":"0.23%"},{"v":0.00017756114497634,"d":"0.0178%"}]
["Zürich"]
["  12. Immobilien – Geschäft Schweiz","CH0032598069","Geschäft","2022-06-30",{"v":2007.9524,"d":"2,007.95"},null,"2022-05-31",{"v":737.705226,"d":"737.71"},{"v":0.079968640193723,"d":"8.00%"},{"v":0.0022880962738507,"d":"0.23%"},{"v":0.00018297594765217,"d":"0.0183%"}]
["Gesamtsumme",{"$nulls":6},{"$f":"SUM(H2:H25)","v":{"v":9224.9314758,"d":"9,224.93"}},{"$f":"SUM(I2:I25)","v":{"v":1,"d":"100.00%"}},null,{"$f":"SUM(K2:K25)","v":{"v":0.0040430313465258,"d":"0.4043%"}}]
[]
["* Kein offizieller Handelskurs."]