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

{"sheet":"KGAST Immo-Index","index":0,"n_rows":63,"n_cols":11,"rows_kept":63,"merged":[[0,3,0,5],[0,6,0,7]]}
["2021-07-30","ISIN","Kategoriserung","NAV",null,null,"Nettovermögen",null,"Gewicht","Perf.","Beitrag"]
[1291]
["  1. Immobilien Schweiz","CH0427260721","Gemischt","2021-07-30",{"v":115.4505,"d":"115.45"},null,"2021-06-30",660.42,{"v":0.013058772308192,"d":"1.31%"},{"v":0.0046617145920282,"d":"0.47%"},{"v":6.0876269423075E-5,"d":"0.0061%"}]
["Adimora"]
["  2. Omega (Wohnimmobilien)","CH0149835834","Wohnen","2021-07-30",{"v":1331.1,"d":"1,331.10"},null,"2020-09-30",294.87,{"v":0.0058305929416382,"d":"0.58%"},{"v":0.0022211346609944,"d":"0.22%"},{"v":1.2950532076822E-5,"d":"0.0013%"}]
["ASSETIMMO"]
["  3. Anlagegruppe G","CH0010493499","Geschäft","2021-07-30",420.13,null,"2021-06-30",{"v":746.901,"d":"746.90"},{"v":0.014768798788288,"d":"1.48%"},{"v":0.0011199542486775,"d":"0.11%"},{"v":1.6540378950806E-5,"d":"0.0017%"}]
["  4. Anlagegruppe W","CH0010493457","Wohnen","2021-07-30",558.77,null,"2021-06-30",{"v":1625.639,"d":"1,625.64"},{"v":0.032144467999633,"d":"3.21%"},{"v":0.0024398557614682,"d":"0.24%"},{"v":7.8427865448235E-5,"d":"0.0078%"}]
["Avadis"]
["  5. Immobilien Schweiz Geschäft","CH0141268083","Geschäft","2021-07-30",{"v":129261.8506602,"d":"129,261.85"},null,"2021-06-30",{"v":847.561,"d":"847.56"},{"v":0.016759192811096,"d":"1.68%"},{"v":0.0042326618453854,"d":"0.42%"},{"v":7.0935995970982E-5,"d":"0.0071%"}]
["  6. Immobilien Schweiz Wohnen","CH0009359354","Wohnen","2021-07-30",{"v":155036.6185704,"d":"155,036.62"},null,"2021-06-30",{"v":2484.6,"d":"2,484.60"},{"v":0.049129077976038,"d":"4.91%"},{"v":0.019048507355687,"d":"1.90%"},{"v":0.00093583560320468,"d":"0.0936%"}]
["CSA"]
["  7. Real Estate Switzerland","CH0013123002","Gemischt","2021-07-30",{"v":1962.02,"d":"1,962.02"},null,"2021-06-30",{"v":6093.8719,"d":"6,093.87"},{"v":0.12049678328547,"d":"12.05%"},{"v":0.0033752339650817,"d":"0.34%"},{"v":0.00040670483562821,"d":"0.0407%"}]
["  8. Real Estate Switzerland Commercial","CH0113543620","Geschäft","2021-07-30",{"v":1633.38,"d":"1,633.38"},null,"2021-06-30",{"v":1317.0429,"d":"1,317.04"},{"v":0.026042462904245,"d":"2.60%"},{"v":0.0032923428459111,"d":"0.33%"},{"v":8.5740716432695E-5,"d":"0.0086%"}]
["  9. Real Estate Switzerland Residential","CH0025226090","Wohnen","2021-07-30",{"v":2033.6,"d":"2,033.60"},null,"2021-06-30",{"v":932.3997,"d":"932.40"},{"v":0.018436745377982,"d":"1.84%"},{"v":0.0036075783821663,"d":"0.36%"},{"v":6.6512004063113E-5,"d":"0.0067%"}]
["DAI"]
["  10. Gewerbeimmobilien Schweiz DAGSIS","CH0347818491","Geschäft","2021-07-30",{"v":161,"d":"161.00"},"* ","2021-06-30",{"v":197,"d":"197.00"},{"v":0.0038953668040246,"d":"0.39%"},{"v":0.002365832399452,"d":"0.24%"},{"v":9.215784992711E-6,"d":"0.0009%"}]
["Ecoreal"]
["  11. Suissecore Plus","CH0108524155","Gemischt","2021-07-30",167.99,"* ","2021-06-30",{"v":1023,"d":"1,023.00"},{"v":0.020228224571153,"d":"2.02%"},{"v":0.013392049224829,"d":"1.34%"},{"v":0.00027089737918778,"d":"0.0271%"}]
["  12. Suisseselect","CH0181111045","Geschäft","2021-07-30",{"v":163,"d":"163.00"},"* ","2021-06-30",{"v":473,"d":"473.00"},{"v":0.0093528350167696,"d":"0.94%"},{"v":0.0038800270986019,"d":"0.39%"},{"v":3.6289253313819E-5,"d":"0.0036%"}]
["Greenbrix"]
["  13. Greenbrix Housing – Wohngebäude in der Schweiz","CH0224042157","Wohnen","2021-07-30",{"v":10670,"d":"10,670.00"},"* ","2021-06-30",{"v":308.2391,"d":"308.24"},{"v":0.0060949459788955,"d":"0.61%"},{"v":-0.00074920397078082,"d":"-0.07%"},{"v":-4.5663577290831E-6,"d":"-0.0005%"}]
["Helvetia"]
["  14. Immobilien Romandie","CH0301200108","Gemischt","2021-07-30",{"v":1340.23,"d":"1,340.23"},null,"2021-06-30",{"v":360,"d":"360.00"},{"v":0.0071184367992327,"d":"0.71%"},{"v":0.022272564319657,"d":"2.23%"},{"v":0.00015854584146632,"d":"0.0159%"}]
["  15. Immobilien Schweiz","CH0188230780","Gemischt","2021-07-30",{"v":1374.52,"d":"1,374.52"},null,"2021-06-30",{"v":868.402,"d":"868.40"},{"v":0.017171290981465,"d":"1.72%"},{"v":0.00730643801986,"d":"0.73%"},{"v":0.00012546097327705,"d":"0.0125%"}]
["HIG"]
["  16. CH-Classico","CH0002875208","Wohnen","2021-07-30",{"v":12960,"d":"12,960.00"},"* ","2021-03-31",{"v":781.032,"d":"781.03"},{"v":0.015443685917162,"d":"1.54%"},{"v":0.0038729666924864,"d":"0.39%"},{"v":5.9812881166389E-5,"d":"0.0060%"}]
["IST"]
["  17. Immobilien Schweiz Fokus","CH0002598578","Wohnen","2021-07-30",{"v":286395.57,"d":"286,395.57"},null,"2021-06-30",288.11,{"v":0.005696924517297,"d":"0.57%"},{"v":0.0030126918790507,"d":"0.30%"},{"v":1.7163078228826E-5,"d":"0.0017%"}]
["  18. Immobilien Schweiz Wohnen","CH0245229122","Wohnen","2021-07-30",127.69,null,"2021-06-30",{"v":276.8215,"d":"276.82"},{"v":0.0054737120900522,"d":"0.55%"},{"v":0.0031424306701233,"d":"0.31%"},{"v":1.7200760751205E-5,"d":"0.0017%"}]
["J. Safra Sarasin"]
["  19. Nachhaltig Immobilien Schweiz","CH0049550269","Gemischt","2021-07-30",{"v":1534.43,"d":"1,534.43"},"* ","2021-06-30",{"v":671.516616,"d":"671.52"},{"v":0.01327819052953,"d":"1.33%"},{"v":0.002580889655533,"d":"0.26%"},{"v":3.426954458186E-5,"d":"0.0034%"}]
["Patrimonium"]
["  20. Gesundheitsimmobilien Schweiz","CH0282527719","Geschäft","2021-07-30",{"v":1207.6,"d":"1,207.60"},"* ","2021-06-30",{"v":251.4607,"d":"251.46"},{"v":0.0049722419456689,"d":"0.50%"},{"v":0.0030650131654359,"d":"0.31%"},{"v":1.5239987025208E-5,"d":"0.0015%"}]
["  21. Wohnimmobilien Schweiz","CH0112589673","Wohnen","2021-07-30",{"v":1718.39,"d":"1,718.39"},"* ","2021-06-30",{"v":542.839745,"d":"542.84"},{"v":0.010733806713595,"d":"1.07%"},{"v":0.0029708749197457,"d":"0.30%"},{"v":3.1888797158816E-5,"d":"0.0032%"}]
["Pensimo"]
["  22. Casareal (Wohnimmobilien)","CH0020488190","Wohnen","2021-07-30",{"v":1358.8,"d":"1,358.80"},null,"2020-12-31",{"v":1928.45,"d":"1,928.45"},{"v":0.038132081793001,"d":"3.81%"},{"v":0.0023605783416938,"d":"0.24%"},{"v":9.0013766404254E-5,"d":"0.0090%"}]
["  23. Proreal (Geschäftsimmobilien)","CH0020488224","Geschäft","2021-07-30",{"v":1322.1,"d":"1,322.10"},null,"2020-12-31",511.96,{"v":0.010123208065931,"d":"1.01%"},{"v":0.0027684022905683,"d":"0.28%"},{"v":2.8025112397623E-5,"d":"0.0028%"}]
["SFP"]
["  24. Swiss Real Estate","CH0437532747","Gemischt","2021-07-30",{"v":1094.5,"d":"1,094.50"},null,"2021-06-30",{"v":222.825,"d":"222.83"},{"v":0.0044060157771917,"d":"0.44%"},{"v":0.0027944477529891,"d":"0.28%"},{"v":1.2312380888208E-5,"d":"0.0012%"}]
["Swiss Life"]
["  25. Geschäftsimmobilien Schweiz","CH0136837587","Geschäft","2021-07-30",160.53,null,"2021-06-30",{"v":1506.1603,"d":"1,506.16"},{"v":0.029781963625176,"d":"2.98%"},{"v":0.0028737427375525,"d":"0.29%"},{"v":8.5585701677902E-5,"d":"0.0086%"}]
["  26. Immobilien Schweiz","CH0106150136","Gemischt","2021-07-30",183.08,null,"2021-06-30",{"v":3098.8143,"d":"3,098.81"},{"v":0.061274204853079,"d":"6.13%"},{"v":0.0028483786152498,"d":"0.28%"},{"v":0.00017453213476995,"d":"0.0175%"}]
["  27. Immobilien Schweiz Alter und Gesundheit","CH0385556482","Gemischt","2021-07-30",120.48,null,"2021-06-30",{"v":291.6554,"d":"291.66"},{"v":0.0057670292557082,"d":"0.58%"},{"v":0.0027465667915105,"d":"0.27%"},{"v":1.5839531039398E-5,"d":"0.0016%"}]
["Swiss Prime"]
["  28. Immobilien Schweiz","CH0263627355","Gemischt","2021-07-30",{"v":1233.18,"d":"1,233.18"},null,"2021-06-30",{"v":1951.8,"d":"1,951.80"},{"v":0.038593791513173,"d":"3.86%"},{"v":0.016334805828444,"d":"1.63%"},{"v":0.00063042209055112,"d":"0.0630%"}]
["Swisscanto"]
["  29. Immobilien Responsible Schweiz","CH0002875893","Gemischt","2021-07-30",243.57,null,"2021-06-30",{"v":7510.107836,"d":"7,510.11"},{"v":0.14850063329441,"d":"14.85%"},{"v":0.0032127244570144,"d":"0.32%"},{"v":0.00047709161646708,"d":"0.0477%"}]
["Tellco"]
["  30. Immobilien Schweiz","CH0024559798","Gemischt","2021-07-30",{"v":181.4252,"d":"181.43"},null,"2021-06-30",{"v":1102.4196,"d":"1,102.42"},{"v":0.021798622913432,"d":"2.18%"},{"v":0.0021841707829318,"d":"0.22%"},{"v":4.7611915275664E-5,"d":"0.0048%"}]
["Turidomus"]
["  31. Casareal (Wohnimmobilien)","CH0020488026","Wohnen","2021-07-30",{"v":1606.6,"d":"1,606.60"},null,"2020-12-31",{"v":3725.29,"d":"3,725.29"},{"v":0.073661781732816,"d":"7.37%"},{"v":0.0022770516859541,"d":"0.23%"},{"v":0.00016773168428509,"d":"0.0168%"}]
["  32. Proreal (Geschäftsimmobilien)","CH0020488067","Geschäft","2021-07-30",{"v":1183.9,"d":"1,183.90"},null,"2020-12-31",{"v":1055.5,"d":"1,055.50"},{"v":0.020870861226639,"d":"2.09%"},{"v":0.0030500720155893,"d":"0.31%"},{"v":6.365762976862E-5,"d":"0.0064%"}]
["UBS 1"]
["  33. Immobilien Schweiz","CH0002875497","Gemischt","2021-07-30",{"v":1888.01,"d":"1,888.01"},null,"2021-06-30",{"v":2304.01108,"d":"2,304.01"},{"v":0.045558214604755,"d":"4.56%"},{"v":0.0030495093690066,"d":"0.30%"},{"v":0.00013893020227242,"d":"0.0139%"}]
["  34. Kommerzielle Immobilien Schweiz","CH0100770533","Geschäft","2021-07-30",{"v":1672.41,"d":"1,672.41"},null,"2021-06-30",{"v":690.93824,"d":"690.94"},{"v":0.013662222760036,"d":"1.37%"},{"v":0.0013831507095385,"d":"0.14%"},{"v":1.8896913104418E-5,"d":"0.0019%"}]
["Zürich"]
["  35. Immobilien – Geschäft Schweiz","CH0032598069","Geschäft","2021-07-30",{"v":1889.0892,"d":"1,889.09"},null,"2021-06-30",{"v":699.9554205,"d":"699.96"},{"v":0.013840523397527,"d":"1.38%"},{"v":-0.0061883293089108,"d":"-0.62%"},{"v":-8.564971659158E-5,"d":"-0.0086%"}]
["  36. Immobilien – Traditionell Schweiz","CH0023842187","Wohnen","2021-07-30",{"v":2822.624,"d":"2,822.62"},null,"2021-06-30",{"v":673.4959841,"d":"673.50"},{"v":0.013317329437091,"d":"1.33%"},{"v":0.0018783373106777,"d":"0.19%"},{"v":2.5014436760275E-5,"d":"0.0025%"}]
["  37. Immobilien – Wohnen Schweiz","CH0018192903","Wohnen","2021-07-30",{"v":3052.2575,"d":"3,052.26"},null,"2021-06-30",{"v":2254.7907455,"d":"2,254.79"},{"v":0.044584959492602,"d":"4.46%"},{"v":0.0021502057025418,"d":"0.22%"},{"v":9.5866834148585E-5,"d":"0.0096%"}]
["Gesamtsumme",{"$nulls":6},{"$f":"SUM(H2:H60)","v":{"v":50572.9010671,"d":"50,572.90"}},{"$f":"SUM(I2:I60)","v":{"v":1,"d":"100.00%"}},null,{"$f":"SUM(K2:K60)","v":{"v":0.0044918243578385,"d":"0.4492%"}}]
[]
["* Kein offizieller Handelskurs."]

{"sheet":"KGAST Immo-Index Gemischt","index":1,"n_rows":28,"n_cols":11,"rows_kept":28,"merged":[[0,3,0,5],[0,6,0,7]]}
["2021-07-30","ISIN","Kategoriserung","NAV",null,null,"Nettovermögen",null,"Gewicht","Perf.","Beitrag"]
[1291]
["  1. Immobilien Schweiz","CH0427260721","Gemischt","2021-07-30",{"v":115.4505,"d":"115.45"},null,"2021-06-30",660.42,{"v":0.025246528736747,"d":"2.52%"},{"v":0.0046617145920282,"d":"0.47%"},{"v":0.00011769211141015,"d":"0.0118%"}]
["CSA"]
["  2. Real Estate Switzerland","CH0013123002","Gemischt","2021-07-30",{"v":1962.02,"d":"1,962.02"},null,"2021-06-30",{"v":6093.8719,"d":"6,093.87"},{"v":0.23295647018776,"d":"23.30%"},{"v":0.0033752339650817,"d":"0.34%"},{"v":0.00078628259056327,"d":"0.0786%"}]
["Ecoreal"]
["  3. Suissecore Plus","CH0108524155","Gemischt","2021-07-30",167.99,"* ","2021-06-30",{"v":1023,"d":"1,023.00"},{"v":0.03910723312088,"d":"3.91%"},{"v":0.013392049224829,"d":"1.34%"},{"v":0.00052372599100171,"d":"0.0524%"}]
["Helvetia"]
["  4. Immobilien Romandie","CH0301200108","Gemischt","2021-07-30",{"v":1340.23,"d":"1,340.23"},null,"2021-06-30",{"v":360,"d":"360.00"},{"v":0.013762076171571,"d":"1.38%"},{"v":0.022272564319657,"d":"2.23%"},{"v":0.00030651672670333,"d":"0.0307%"}]
["  5. Immobilien Schweiz","CH0188230780","Gemischt","2021-07-30",{"v":1374.52,"d":"1,374.52"},null,"2021-06-30",{"v":868.402,"d":"868.40"},{"v":0.033197262420957,"d":"3.32%"},{"v":0.00730643801986,"d":"0.73%"},{"v":0.00024255374030775,"d":"0.0243%"}]
["J. Safra Sarasin"]
["  6. Nachhaltig Immobilien Schweiz","CH0049550269","Gemischt","2021-07-30",{"v":1534.43,"d":"1,534.43"},"* ","2021-06-30",{"v":671.516616,"d":"671.52"},{"v":0.025670730055187,"d":"2.57%"},{"v":0.002580889655533,"d":"0.26%"},{"v":6.6253321649414E-5,"d":"0.0066%"}]
["SFP"]
["  7. Swiss Real Estate","CH0437532747","Gemischt","2021-07-30",{"v":1094.5,"d":"1,094.50"},null,"2021-06-30",{"v":222.825,"d":"222.83"},{"v":0.0085181517303618,"d":"0.85%"},{"v":0.0027944477529891,"d":"0.28%"},{"v":2.380352996253E-5,"d":"0.0024%"}]
["Swiss Life"]
["  8. Immobilien Schweiz","CH0106150136","Gemischt","2021-07-30",183.08,null,"2021-06-30",{"v":3098.8143,"d":"3,098.81"},{"v":0.11846144010598,"d":"11.85%"},{"v":0.0028483786152498,"d":"0.28%"},{"v":0.00033742303272957,"d":"0.0337%"}]
["  9. Immobilien Schweiz Alter und Gesundheit","CH0385556482","Gemischt","2021-07-30",120.48,null,"2021-06-30",{"v":291.6554,"d":"291.66"},{"v":0.011149399529583,"d":"1.11%"},{"v":0.0027465667915105,"d":"0.27%"},{"v":3.0622570493236E-5,"d":"0.0031%"}]
["Swiss Prime"]
["  10. Immobilien Schweiz","CH0263627355","Gemischt","2021-07-30",{"v":1233.18,"d":"1,233.18"},null,"2021-06-30",{"v":1951.8,"d":"1,951.80"},{"v":0.074613389643533,"d":"7.46%"},{"v":0.016334805828444,"d":"1.63%"},{"v":0.0012187952320291,"d":"0.1219%"}]
["Swisscanto"]
["  11. Immobilien Responsible Schweiz","CH0002875893","Gemischt","2021-07-30",243.57,null,"2021-06-30",{"v":7510.107836,"d":"7,510.11"},{"v":0.28709632248817,"d":"28.71%"},{"v":0.0032127244570144,"d":"0.32%"},{"v":0.00092236137677664,"d":"0.0922%"}]
["Tellco"]
["  12. Immobilien Schweiz","CH0024559798","Gemischt","2021-07-30",{"v":181.4252,"d":"181.43"},null,"2021-06-30",{"v":1102.4196,"d":"1,102.42"},{"v":0.04214328474509,"d":"4.21%"},{"v":0.0021841707829318,"d":"0.22%"},{"v":9.2048131237E-5,"d":"0.0092%"}]
["UBS 1"]
["  13. Immobilien Schweiz","CH0002875497","Gemischt","2021-07-30",{"v":1888.01,"d":"1,888.01"},null,"2021-06-30",{"v":2304.01108,"d":"2,304.01"},{"v":0.088077711064175,"d":"8.81%"},{"v":0.0030495093690066,"d":"0.30%"},{"v":0.00026859380509086,"d":"0.0269%"}]
["Gesamtsumme",{"$nulls":6},{"$f":"SUM(H2:H25)","v":{"v":26158.843732,"d":"26,158.84"}},{"$f":"SUM(I2:I25)","v":{"v":1,"d":"100.00%"}},null,{"$f":"SUM(K2:K25)","v":{"v":0.0049366721599546,"d":"0.4937%"}}]
[]
["* 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]]}
["2021-07-30","ISIN","Kategoriserung","NAV",null,null,"Nettovermögen",null,"Gewicht","Perf.","Beitrag"]
["Adimora"]
["  1. Omega (Wohnimmobilien)","CH0149835834","Wohnen","2021-07-30",{"v":1331.1,"d":"1,331.10"},null,"2020-09-30",294.87,{"v":0.018296067820597,"d":"1.83%"},{"v":0.0022211346609944,"d":"0.22%"},{"v":4.0638030396231E-5,"d":"0.0041%"}]
["ASSETIMMO"]
["  2. Anlagegruppe W","CH0010493457","Wohnen","2021-07-30",558.77,null,"2021-06-30",{"v":1625.639,"d":"1,625.64"},{"v":0.10086750566625,"d":"10.09%"},{"v":0.0024398557614682,"d":"0.24%"},{"v":0.00024610216484472,"d":"0.0246%"}]
["Avadis"]
["  3. Immobilien Schweiz Wohnen","CH0009359354","Wohnen","2021-07-30",{"v":155036.6185704,"d":"155,036.62"},null,"2021-06-30",{"v":2484.6,"d":"2,484.60"},{"v":0.15416424223235,"d":"15.42%"},{"v":0.019048507355687,"d":"1.90%"},{"v":0.0029365987021469,"d":"0.2937%"}]
["CSA"]
["  4. Real Estate Switzerland Residential","CH0025226090","Wohnen","2021-07-30",{"v":2033.6,"d":"2,033.60"},null,"2021-06-30",{"v":932.3997,"d":"932.40"},{"v":0.05785345456338,"d":"5.79%"},{"v":0.0036075783821663,"d":"0.36%"},{"v":0.00020871087201649,"d":"0.0209%"}]
["Greenbrix"]
["  5. Greenbrix Housing – Wohngebäude in der Schweiz","CH0224042157","Wohnen","2021-07-30",{"v":10670,"d":"10,670.00"},"* ","2021-06-30",{"v":308.2391,"d":"308.24"},{"v":0.019125592561331,"d":"1.91%"},{"v":-0.00074920397078082,"d":"-0.07%"},{"v":-1.4328969890485E-5,"d":"-0.0014%"}]
["HIG"]
["  6. CH-Classico","CH0002875208","Wohnen","2021-07-30",{"v":12960,"d":"12,960.00"},"* ","2021-03-31",{"v":781.032,"d":"781.03"},{"v":0.048461404829437,"d":"4.85%"},{"v":0.0038729666924864,"d":"0.39%"},{"v":0.00018768940677551,"d":"0.0188%"}]
["IST"]
["  7. Immobilien Schweiz Fokus","CH0002598578","Wohnen","2021-07-30",{"v":286395.57,"d":"286,395.57"},null,"2021-06-30",288.11,{"v":0.017876623935267,"d":"1.79%"},{"v":0.0030126918790507,"d":"0.30%"},{"v":5.3856759754622E-5,"d":"0.0054%"}]
["  8. Immobilien Schweiz Wohnen","CH0245229122","Wohnen","2021-07-30",127.69,null,"2021-06-30",{"v":276.8215,"d":"276.82"},{"v":0.017176196080304,"d":"1.72%"},{"v":0.0031424306701233,"d":"0.31%"},{"v":5.3975005358799E-5,"d":"0.0054%"}]
["Patrimonium"]
["  9. Wohnimmobilien Schweiz","CH0112589673","Wohnen","2021-07-30",{"v":1718.39,"d":"1,718.39"},"* ","2021-06-30",{"v":542.839745,"d":"542.84"},{"v":0.033682072744719,"d":"3.37%"},{"v":0.0029708749197457,"d":"0.30%"},{"v":0.00010006522516234,"d":"0.0100%"}]
["Pensimo"]
["  10. Casareal (Wohnimmobilien)","CH0020488190","Wohnen","2021-07-30",{"v":1358.8,"d":"1,358.80"},null,"2020-12-31",{"v":1928.45,"d":"1,928.45"},{"v":0.11965629595628,"d":"11.97%"},{"v":0.0023605783416938,"d":"0.24%"},{"v":0.00028245806068171,"d":"0.0282%"}]
["Turidomus"]
["  11. Casareal (Wohnimmobilien)","CH0020488026","Wohnen","2021-07-30",{"v":1606.6,"d":"1,606.60"},null,"2020-12-31",{"v":3725.29,"d":"3,725.29"},{"v":0.23114646621016,"d":"23.11%"},{"v":0.0022770516859541,"d":"0.23%"},{"v":0.00052633245058617,"d":"0.0526%"}]
["Zürich"]
["  12. Immobilien – Traditionell Schweiz","CH0023842187","Wohnen","2021-07-30",{"v":2822.624,"d":"2,822.62"},null,"2021-06-30",{"v":673.4959841,"d":"673.50"},{"v":0.041789019574704,"d":"4.18%"},{"v":0.0018783373106777,"d":"0.19%"},{"v":7.8493874643806E-5,"d":"0.0078%"}]
["  13. Immobilien – Wohnen Schweiz","CH0018192903","Wohnen","2021-07-30",{"v":3052.2575,"d":"3,052.26"},null,"2021-06-30",{"v":2254.7907455,"d":"2,254.79"},{"v":0.13990505782522,"d":"13.99%"},{"v":0.0021502057025418,"d":"0.22%"},{"v":0.00030082465315021,"d":"0.0301%"}]
["Gesamtsumme",{"$nulls":6},{"$f":"SUM(H2:H25)","v":{"v":16116.5777746,"d":"16,116.58"}},{"$f":"SUM(I2:I25)","v":{"v":1,"d":"100.00%"}},null,{"$f":"SUM(K2:K25)","v":{"v":0.005001416235627,"d":"0.5001%"}}]
[]
["* Kein offizieller Handelskurs."]

{"sheet":"KGAST Immo-Index Geschäft","index":3,"n_rows":26,"n_cols":11,"rows_kept":26,"merged":[[0,3,0,5],[0,6,0,7]]}
["2021-07-30","ISIN","Kategoriserung","NAV",null,null,"Nettovermögen",null,"Gewicht","Perf.","Beitrag"]
["ASSETIMMO"]
["  1. Anlagegruppe G","CH0010493499","Geschäft","2021-07-30",420.13,null,"2021-06-30",{"v":746.901,"d":"746.90"},{"v":0.090015407034638,"d":"9.00%"},{"v":0.0011199542486775,"d":"0.11%"},{"v":0.00010081313755488,"d":"0.0101%"}]
["Avadis"]
["  2. Immobilien Schweiz Geschäft","CH0141268083","Geschäft","2021-07-30",{"v":129261.8506602,"d":"129,261.85"},null,"2021-06-30",{"v":847.561,"d":"847.56"},{"v":0.10214680178723,"d":"10.21%"},{"v":0.0042326618453854,"d":"0.42%"},{"v":0.00043235287055296,"d":"0.0432%"}]
["CSA"]
["  3. Real Estate Switzerland Commercial","CH0113543620","Geschäft","2021-07-30",{"v":1633.38,"d":"1,633.38"},null,"2021-06-30",{"v":1317.0429,"d":"1,317.04"},{"v":0.15872806801113,"d":"15.87%"},{"v":0.0032923428459111,"d":"0.33%"},{"v":0.00052258721916173,"d":"0.0523%"}]
["DAI"]
["  4. Gewerbeimmobilien Schweiz DAGSIS","CH0347818491","Geschäft","2021-07-30",{"v":161,"d":"161.00"},"* ","2021-06-30",{"v":197,"d":"197.00"},{"v":0.023742149476067,"d":"2.37%"},{"v":0.002365832399452,"d":"0.24%"},{"v":5.6169946463111E-5,"d":"0.0056%"}]
["Ecoreal"]
["  5. Suisseselect","CH0181111045","Geschäft","2021-07-30",{"v":163,"d":"163.00"},"* ","2021-06-30",{"v":473,"d":"473.00"},{"v":0.057005262447612,"d":"5.70%"},{"v":0.0038800270986019,"d":"0.39%"},{"v":0.00022118196305965,"d":"0.0221%"}]
["Patrimonium"]
["  6. Gesundheitsimmobilien Schweiz","CH0282527719","Geschäft","2021-07-30",{"v":1207.6,"d":"1,207.60"},"* ","2021-06-30",{"v":251.4607,"d":"251.46"},{"v":0.030305672724652,"d":"3.03%"},{"v":0.0030650131654359,"d":"0.31%"},{"v":9.2887285888451E-5,"d":"0.0093%"}]
["Pensimo"]
["  7. Proreal (Geschäftsimmobilien)","CH0020488224","Geschäft","2021-07-30",{"v":1322.1,"d":"1,322.10"},null,"2020-12-31",511.96,{"v":0.061700664191711,"d":"6.17%"},{"v":0.0027684022905683,"d":"0.28%"},{"v":0.00017081226007792,"d":"0.0171%"}]
["Swiss Life"]
["  8. Geschäftsimmobilien Schweiz","CH0136837587","Geschäft","2021-07-30",160.53,null,"2021-06-30",{"v":1506.1603,"d":"1,506.16"},{"v":0.18152021815999,"d":"18.15%"},{"v":0.0028737427375525,"d":"0.29%"},{"v":0.00052164240865621,"d":"0.0522%"}]
["Turidomus"]
["  9. Proreal (Geschäftsimmobilien)","CH0020488067","Geschäft","2021-07-30",{"v":1183.9,"d":"1,183.90"},null,"2020-12-31",{"v":1055.5,"d":"1,055.50"},{"v":0.12720730341111,"d":"12.72%"},{"v":0.0030500720155893,"d":"0.31%"},{"v":0.0003879914363128,"d":"0.0388%"}]
["UBS 1"]
["  10. Kommerzielle Immobilien Schweiz","CH0100770533","Geschäft","2021-07-30",{"v":1672.41,"d":"1,672.41"},null,"2021-06-30",{"v":690.93824,"d":"690.94"},{"v":0.083270857730003,"d":"8.33%"},{"v":0.0013831507095385,"d":"0.14%"},{"v":0.00011517614595314,"d":"0.0115%"}]
["Zürich"]
["  11. Immobilien – Geschäft Schweiz","CH0032598069","Geschäft","2021-07-30",{"v":1889.0892,"d":"1,889.09"},null,"2021-06-30",{"v":699.9554205,"d":"699.96"},{"v":0.084357595025859,"d":"8.44%"},{"v":-0.0061883293089108,"d":"-0.62%"},{"v":-0.00052203257772775,"d":"-0.0522%"}]
["Gesamtsumme",{"$nulls":6},{"$f":"SUM(H2:H23)","v":{"v":8297.4795605,"d":"8,297.48"}},{"$f":"SUM(I2:I23)","v":{"v":1,"d":"100.00%"}},null,{"$f":"SUM(K2:K23)","v":{"v":0.0020995820959531,"d":"0.2100%"}}]
[]
["* Kein offizieller Handelskurs."]