{"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":"2020-04-30","creator":"Fundo SA","last_modified_by":"Unknown Creator","company":"Fundo SA"},"read":"whole","date_system":"1900"}

{"sheet":"KGAST Immo-Index","index":0,"n_rows":59,"n_cols":11,"rows_kept":59,"merged":[[0,3,0,5],[0,6,0,7]]}
["2020-04-30","ISIN","Kategoriserung","NAV",null,null,"Nettovermögen",null,"Gewicht","Perf.","Beitrag"]
["Adimora"]
["  1. Omega (Wohnimmobilien)","CH0149835834","Wohnen","2020-04-30",{"v":1252.75,"d":"1,252.75"},null,"2019-09-30",{"v":248.5,"d":"248.50"},{"v":0.005417334721576203,"d":"0.54%"},{"v":0.00199960007998401,"d":"0.20%"},{"v":1.083250294256393E-5,"d":"0.0011%"}]
["ASSETIMMO"]
["  2. Anlagegruppe G","CH0010493499","Geschäft","2020-04-30",{"v":428.8,"d":"428.80"},null,"2020-03-31",{"v":747.278,"d":"747.28"},{"v":0.01629076481315904,"d":"1.63%"},{"v":0.0019628002617067,"d":"0.20%"},{"v":3.197551743867086E-5,"d":"0.0032%"}]
["  3. Anlagegruppe W","CH0010493457","Wohnen","2020-04-30",562.95,null,"2020-03-31",{"v":1617.456,"d":"1,617.46"},{"v":0.0352607667984779,"d":"3.53%"},{"v":0.00251095202478901,"d":"0.25%"},{"v":8.853809378825117E-5,"d":"0.0089%"}]
["Avadis"]
["  4. Immobilien Schweiz Geschäft","CH0141268083","Geschäft","2020-04-30",{"v":127130.4237,"d":"127,130.42"},null,"2020-03-31",{"v":828.1716,"d":"828.17"},{"v":0.01805425659598921,"d":"1.81%"},{"v":0.00301039157275262,"d":"0.30%"},{"v":5.435038190887931E-5,"d":"0.0054%"}]
["  5. Immobilien Schweiz Wohnen","CH0009359354","Wohnen","2020-04-30",{"v":145318.17,"d":"145,318.17"},null,"2020-03-31",{"v":2413.4721,"d":"2,413.47"},{"v":0.05261402900155104,"d":"5.26%"},{"v":0.00341380423945625,"d":"0.34%"},{"v":0.0001796139952603691,"d":"0.0180%"}]
["CSA"]
["  6. Real Estate Switzerland","CH0013123002","Gemischt","2020-04-30",{"v":1896.05,"d":"1,896.05"},null,"2020-03-31",{"v":5796.6741,"d":"5,796.67"},{"v":0.1263683053182756,"d":"12.64%"},{"v":0.00948765593138212,"d":"0.95%"},{"v":0.001198939001491644,"d":"0.1199%"}]
["  7. Real Estate Switzerland Commercial","CH0113543620","Geschäft","2020-04-30",{"v":1552.06,"d":"1,552.06"},null,"2020-03-31",{"v":1317.5825,"d":"1,317.58"},{"v":0.02872348259875725,"d":"2.87%"},{"v":0.0041861036885591,"d":"0.42%"},{"v":0.0001202394764549209,"d":"0.0120%"}]
["  8. Real Estate Switzerland Residential","CH0025226090","Wohnen","2020-04-30",{"v":1881.86,"d":"1,881.86"},null,"2020-03-31",{"v":728.7099,"d":"728.71"},{"v":0.01588597763873771,"d":"1.59%"},{"v":0.00666524018401615,"d":"0.67%"},{"v":0.0001058838565200966,"d":"0.0106%"}]
["DAI"]
["  9. Gewerbeimmobilien Schweiz DAGSIS","CH0347818491","Geschäft","2020-04-30",143.34,"* ","2020-02-28",{"v":135.702778,"d":"135.70"},{"v":0.00295833952142353,"d":"0.30%"},{"v":0.00293870696893372,"d":"0.29%"},{"v":8.693692968079374E-6,"d":"0.0009%"}]
["Ecoreal"]
["  10. Suissecore Plus","CH0108524155","Gemischt","2020-04-30",159.21,null,"2020-03-31",{"v":904,"d":"904.00"},{"v":0.01970732631108606,"d":"1.97%"},{"v":0.002645002833931986,"d":"0.26%"},{"v":5.212593394204504E-5,"d":"0.0052%"}]
["  11. Suisseselect","CH0181111045","Geschäft","2020-04-30",{"v":154.6,"d":"154.60"},null,"2020-03-31",{"v":427,"d":"427.00"},{"v":0.009308659662426715,"d":"0.93%"},{"v":0.004026496947655334,"d":"0.40%"},{"v":3.748128971752349E-5,"d":"0.0037%"}]
["Greenbrix"]
["  12. Greenbrix Housing","CH0224042157","Wohnen","2020-04-30",{"v":10595,"d":"10,595.00"},"* ","2020-02-28",{"v":252.321146,"d":"252.32"},{"v":0.0055006362382845,"d":"0.55%"},{"v":0.002175558077941675,"d":"0.22%"},{"v":1.196695360201855E-5,"d":"0.0012%"}]
["Helvetia"]
["  13. Immobilien Romandie","CH0301200108","Gemischt","2020-04-30",{"v":1260.4,"d":"1,260.40"},null,"2020-03-31",{"v":277.0307,"d":"277.03"},{"v":0.006039307968018353,"d":"0.60%"},{"v":0.009288917360666282,"d":"0.93%"},{"v":5.609863263053589E-5,"d":"0.0056%"}]
["  14. Immobilien Schweiz","CH0188230780","Gemischt","2020-04-30",{"v":1309.1,"d":"1,309.10"},null,"2020-03-31",{"v":816.9554,"d":"816.96"},{"v":0.01780974186880956,"d":"1.78%"},{"v":-0.004471550898112575,"d":"-0.45%"},{"v":-7.963716724862852E-5,"d":"-0.0080%"}]
["HIG"]
["  15. CH-Classico","CH0002875208","Wohnen","2020-04-30",{"v":12704,"d":"12,704.00"},"* ","2020-03-31",{"v":746.125,"d":"746.13"},{"v":0.01626562925205651,"d":"1.63%"},{"v":0.00395131974079343,"d":"0.40%"},{"v":6.427070196007799E-5,"d":"0.0064%"}]
["IST"]
["  16. Immobilien Schweiz Fokus","CH0002598578","Wohnen","2020-04-30",{"v":273221.44,"d":"273,221.44"},null,"2020-03-31",274.73,{"v":0.005989152386553844,"d":"0.60%"},{"v":0.00344294952644675,"d":"0.34%"},{"v":2.062034937310298E-5,"d":"0.0021%"}]
["  17. Immobilien Schweiz Wohnen","CH0245229122","Wohnen","2020-04-30",122.39,null,"2020-03-31",211.98,{"v":0.004621193618831885,"d":"0.46%"},{"v":0.00262144671090358,"d":"0.26%"},{"v":1.211421281253546E-5,"d":"0.0012%"}]
["J. Safra Sarasin"]
["  18. Nachhaltig Immobilien Schweiz","CH0049550269","Gemischt","2020-04-30",{"v":1469.43,"d":"1,469.43"},"* ","2020-03-31",{"v":643.1693,"d":"643.17"},{"v":0.01402118060660709,"d":"1.40%"},{"v":0.002428591894234389,"d":"0.24%"},{"v":3.405172556880238E-5,"d":"0.0034%"}]
["Patrimonium"]
["  19. Gesundheitsimmobilien Schweiz","CH0282527719","Geschäft","2020-04-30",{"v":1223.91,"d":"1,223.91"},null,"2020-03-31",{"v":196.356109,"d":"196.36"},{"v":0.004280590611989141,"d":"0.43%"},{"v":0.00369854026570437,"d":"0.37%"},{"v":1.583193673943795E-5,"d":"0.0016%"}]
["  20. Wohnimmobilien Schweiz","CH0112589673","Wohnen","2020-04-30",{"v":1591.41,"d":"1,591.41"},null,"2020-03-31",{"v":472.941457,"d":"472.94"},{"v":0.01031018984418084,"d":"1.03%"},{"v":0.00249456675800808,"d":"0.25%"},{"v":2.571945685404603E-5,"d":"0.0026%"}]
["Pensimo"]
["  21. Casareal (Wohnimmobilien)","CH0020488190","Wohnen","2020-04-30",{"v":1310,"d":"1,310.00"},null,"2019-12-31",{"v":1844.89,"d":"1,844.89"},{"v":0.04021885977661457,"d":"4.02%"},{"v":0.00267891312667423,"d":"0.27%"},{"v":0.000107742831395443,"d":"0.0108%"}]
["  22. Proreal (Geschäftsimmobilien)","CH0020488224","Geschäft","2020-04-30",{"v":1308.9,"d":"1,308.90"},null,"2019-12-31",511.63,{"v":0.01115360548732407,"d":"1.12%"},{"v":0.00295007854105212,"d":"0.30%"},{"v":3.290401220351593E-5,"d":"0.0033%"}]
["Swiss Life"]
["  23. Geschäftsimmobilien Schweiz","CH0136837587","Geschäft","2020-04-30",151.93,null,"2020-03-31",{"v":1236.3561,"d":"1,236.36"},{"v":0.02695273572942672,"d":"2.70%"},{"v":0.00164820675105482,"d":"0.16%"},{"v":4.442368098863757E-5,"d":"0.0044%"}]
["  24. Immobilien Schweiz","CH0106150136","Gemischt","2020-04-30",{"v":172.6,"d":"172.60"},null,"2020-03-31",{"v":2638.7656,"d":"2,638.77"},{"v":0.05752545878060709,"d":"5.75%"},{"v":0.00243930770124279,"d":"0.24%"},{"v":0.0001403222946210596,"d":"0.0140%"}]
["  25. Immobilien Schweiz Alter und Gesundheit","CH0385556482","Gemischt","2020-04-30",112.38,null,"2020-03-31",{"v":194.7054,"d":"194.71"},{"v":0.004244604925144399,"d":"0.42%"},{"v":0.00205082478823004,"d":"0.21%"},{"v":8.704940996729447E-6,"d":"0.0009%"}]
["Swiss Prime"]
["  26. SPA Immobilien Schweiz","CH0263627355","Gemischt","2020-04-30",{"v":1156.95,"d":"1,156.95"},null,"2020-03-31",{"v":1615.94,"d":"1,615.94"},{"v":0.03522771778665533,"d":"3.52%"},{"v":0.0018617942500867,"d":"0.19%"},{"v":6.558676241887186E-5,"d":"0.0066%"}]
["Swisscanto"]
["  27. Immobilien Schweiz","CH0002875893","Gemischt","2020-04-30",{"v":232.2,"d":"232.20"},null,"2020-03-31",{"v":7149.699116,"d":"7,149.70"},{"v":0.1558644397180261,"d":"15.59%"},{"v":0.00419495740172127,"d":"0.42%"},{"v":0.0006538446850602722,"d":"0.0654%"}]
["Tellco"]
["  28. Immobilien Schweiz","CH0024559798","Gemischt","2020-04-30",{"v":173.8285,"d":"173.83"},null,"2020-03-31",{"v":1025.7377,"d":"1,025.74"},{"v":0.02236122518084392,"d":"2.24%"},{"v":0.00222147654102334,"d":"0.22%"},{"v":4.967493716778515E-5,"d":"0.0050%"}]
["Turidomus"]
["  29. Casareal (Wohnimmobilien)","CH0020488026","Wohnen","2020-04-30",{"v":1530.45,"d":"1,530.45"},null,"2020-03-31",{"v":3475.76,"d":"3,475.76"},{"v":0.07577205364935896,"d":"7.58%"},{"v":0.00242344850171938,"d":"0.24%"},{"v":0.0001836296698887394,"d":"0.0184%"}]
["  30. Proreal (Geschäftsimmobilien)","CH0020488067","Geschäft","2020-04-30",{"v":1142.65,"d":"1,142.65"},null,"2019-12-31",{"v":1028.71,"d":"1,028.71"},{"v":0.02242602173614751,"d":"2.24%"},{"v":0.00316052851060111,"d":"0.32%"},{"v":7.087808107645441E-5,"d":"0.0071%"}]
["UBS 1"]
["  31. Immobilien Schweiz","CH0002875497","Gemischt","2020-04-30",{"v":1820.94,"d":"1,820.94"},null,"2020-03-31",{"v":2223.582868,"d":"2,223.58"},{"v":0.04847441721174404,"d":"4.85%"},{"v":0.00328931056711679,"d":"0.33%"},{"v":0.0001594474127694177,"d":"0.0159%"}]
["  32. Kommerzielle Immobilien Schweiz","CH0100770533","Geschäft","2020-04-30",{"v":1646.96,"d":"1,646.96"},null,"2020-03-31",{"v":684.731309,"d":"684.73"},{"v":0.01492723821004436,"d":"1.49%"},{"v":0.00304514117274479,"d":"0.30%"},{"v":4.545554766877532E-5,"d":"0.0045%"}]
["Zürich"]
["  33. Immobilien – Geschäft Schweiz","CH0032598069","Geschäft","2020-04-30",{"v":1813.5429,"d":"1,813.54"},null,"2020-03-31",{"v":611.5942595,"d":"611.59"},{"v":0.01333284031189552,"d":"1.33%"},{"v":0.00269718332520008,"d":"0.27%"},{"v":3.596111456680002E-5,"d":"0.0036%"}]
["  34. Immobilien – Traditionell Schweiz","CH0023842187","Wohnen","2020-04-30",{"v":2590.7756,"d":"2,590.78"},null,"2020-03-31",{"v":630.8943581,"d":"630.89"},{"v":0.01375358515807509,"d":"1.38%"},{"v":0.00200670091523891,"d":"0.20%"},{"v":2.759933192452558E-5,"d":"0.0028%"}]
["  35. Immobilien – Wohnen Schweiz","CH0018192903","Wohnen","2020-04-30",{"v":2832.9586,"d":"2,832.96"},null,"2020-03-31",{"v":1942.1128257,"d":"1,942.11"},{"v":0.04233833096130013,"d":"4.23%"},{"v":0.00192812975728285,"d":"0.19%"},{"v":8.163379580017259E-5,"d":"0.0082%"}]
["Gesamtsumme",{"$nulls":6},{"$f":"SUM(H2:H56)","v":{"v":45871.2656263,"d":"45,871.27"}},{"$f":"SUM(I2:I56)","v":{"v":1,"d":"100.00%"}},null,{"$f":"SUM(K2:K56)","v":{"v":0.003757519643272172,"d":"0.3758%"}}]
[]
["* Kein offizieller Handelskurs."]

{"sheet":"KGAST Immo-Index Gemischt","index":1,"n_rows":24,"n_cols":11,"rows_kept":24,"merged":[[0,3,0,5],[0,6,0,7]]}
["2020-04-30","ISIN","Kategoriserung","NAV",null,null,"Nettovermögen",null,"Gewicht","Perf.","Beitrag"]
["CSA"]
["  1. Real Estate Switzerland","CH0013123002","Gemischt","2020-04-30",{"v":1896.05,"d":"1,896.05"},null,"2020-03-31",{"v":5796.6741,"d":"5,796.67"},{"v":0.2489310887277167,"d":"24.89%"},{"v":0.00948765593138212,"d":"0.95%"},{"v":0.00236177252047293,"d":"0.2362%"}]
["Ecoreal"]
["  2. Suissecore Plus","CH0108524155","Gemischt","2020-04-30",159.21,null,"2020-03-31",{"v":904,"d":"904.00"},{"v":0.03882117578593143,"d":"3.88%"},{"v":0.002645002833931986,"d":"0.26%"},{"v":0.0001026821199703604,"d":"0.0103%"}]
["Helvetia"]
["  3. Immobilien Romandie","CH0301200108","Gemischt","2020-04-30",{"v":1260.4,"d":"1,260.40"},null,"2020-03-31",{"v":277.0307,"d":"277.03"},{"v":0.01189674502522084,"d":"1.19%"},{"v":0.009288917360666282,"d":"0.93%"},{"v":0.0001105078814001941,"d":"0.0111%"}]
["  4. Immobilien Schweiz","CH0188230780","Gemischt","2020-04-30",{"v":1309.1,"d":"1,309.10"},null,"2020-03-31",{"v":816.9554,"d":"816.96"},{"v":0.0350831517617986,"d":"3.51%"},{"v":-0.004471550898112575,"d":"-0.45%"},{"v":-0.0001568760987690903,"d":"-0.0157%"}]
["J. Safra Sarasin"]
["  5. Nachhaltig Immobilien Schweiz","CH0049550269","Gemischt","2020-04-30",{"v":1469.43,"d":"1,469.43"},"* ","2020-03-31",{"v":643.1693,"d":"643.17"},{"v":0.02762011997280362,"d":"2.76%"},{"v":0.002428591894234389,"d":"0.24%"},{"v":6.707799948373221E-5,"d":"0.0067%"}]
["Swiss Life"]
["  6. Immobilien Schweiz","CH0106150136","Gemischt","2020-04-30",{"v":172.6,"d":"172.60"},null,"2020-03-31",{"v":2638.7656,"d":"2,638.77"},{"v":0.1133185655038372,"d":"11.33%"},{"v":0.00243930770124279,"d":"0.24%"},{"v":0.0002764188495272957,"d":"0.0276%"}]
["  7. Immobilien Schweiz Alter und Gesundheit","CH0385556482","Gemischt","2020-04-30",112.38,null,"2020-03-31",{"v":194.7054,"d":"194.71"},{"v":0.008361385575077538,"d":"0.84%"},{"v":0.00205082478823004,"d":"0.21%"},{"v":1.71477368013181E-5,"d":"0.0017%"}]
["Swiss Prime"]
["  8. SPA Immobilien Schweiz","CH0263627355","Gemischt","2020-04-30",{"v":1156.95,"d":"1,156.95"},null,"2020-03-31",{"v":1615.94,"d":"1,615.94"},{"v":0.06939456946849341,"d":"6.94%"},{"v":0.0018617942500867,"d":"0.19%"},{"v":0.0001291984104236831,"d":"0.0129%"}]
["Swisscanto"]
["  9. Immobilien Schweiz","CH0002875893","Gemischt","2020-04-30",{"v":232.2,"d":"232.20"},null,"2020-03-31",{"v":7149.699116,"d":"7,149.70"},{"v":0.3070350953526046,"d":"30.70%"},{"v":0.00419495740172127,"d":"0.42%"},{"v":0.001287999145837605,"d":"0.1288%"}]
["Tellco"]
["  10. Immobilien Schweiz","CH0024559798","Gemischt","2020-04-30",{"v":173.8285,"d":"173.83"},null,"2020-03-31",{"v":1025.7377,"d":"1,025.74"},{"v":0.04404905261278429,"d":"4.40%"},{"v":0.00222147654102334,"d":"0.22%"},{"v":9.785393703360315E-5,"d":"0.0098%"}]
["UBS 1"]
["  11. Immobilien Schweiz","CH0002875497","Gemischt","2020-04-30",{"v":1820.94,"d":"1,820.94"},null,"2020-03-31",{"v":2223.582868,"d":"2,223.58"},{"v":0.09548905021373182,"d":"9.55%"},{"v":0.00328931056711679,"d":"0.33%"},{"v":0.0003140931419119738,"d":"0.0314%"}]
["Gesamtsumme",{"$nulls":6},{"$f":"SUM(H2:H21)","v":{"v":23286.26018400001,"d":"23,286.26"}},{"$f":"SUM(I2:I21)","v":{"v":0.9999999999999999,"d":"100.00%"}},null,{"$f":"SUM(K2:K21)","v":{"v":0.004607875644093604,"d":"0.4608%"}}]
[]
["* 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]]}
["2020-04-30","ISIN","Kategoriserung","NAV",null,null,"Nettovermögen",null,"Gewicht","Perf.","Beitrag"]
["Adimora"]
["  1. Omega (Wohnimmobilien)","CH0149835834","Wohnen","2020-04-30",{"v":1252.75,"d":"1,252.75"},null,"2019-09-30",{"v":248.5,"d":"248.50"},{"v":0.01672286627940828,"d":"1.67%"},{"v":0.00199960007998401,"d":"0.20%"},{"v":3.34390447498667E-5,"d":"0.0033%"}]
["ASSETIMMO"]
["  2. Anlagegruppe W","CH0010493457","Wohnen","2020-04-30",562.95,null,"2020-03-31",{"v":1617.456,"d":"1,617.46"},{"v":0.1088470841079541,"d":"10.88%"},{"v":0.00251095202478901,"d":"0.25%"},{"v":0.0002733098062332469,"d":"0.0273%"}]
["Avadis"]
["  3. Immobilien Schweiz Wohnen","CH0009359354","Wohnen","2020-04-30",{"v":145318.17,"d":"145,318.17"},null,"2020-03-31",{"v":2413.4721,"d":"2,413.47"},{"v":0.1624151758445983,"d":"16.24%"},{"v":0.00341380423945625,"d":"0.34%"},{"v":0.0005544536158503221,"d":"0.0554%"}]
["CSA"]
["  4. Real Estate Switzerland Residential","CH0025226090","Wohnen","2020-04-30",{"v":1881.86,"d":"1,881.86"},null,"2020-03-31",{"v":728.7099,"d":"728.71"},{"v":0.04903870508724738,"d":"4.90%"},{"v":0.00666524018401615,"d":"0.67%"},{"v":0.0003268547477196385,"d":"0.0327%"}]
["Greenbrix"]
["  5. Greenbrix Housing","CH0224042157","Wohnen","2020-04-30",{"v":10595,"d":"10,595.00"},"* ","2020-02-28",{"v":252.321146,"d":"252.32"},{"v":0.01698001120332013,"d":"1.70%"},{"v":0.002175558077941675,"d":"0.22%"},{"v":3.694100053692325E-5,"d":"0.0037%"}]
["HIG"]
["  6. CH-Classico","CH0002875208","Wohnen","2020-04-30",{"v":12704,"d":"12,704.00"},"* ","2020-03-31",{"v":746.125,"d":"746.13"},{"v":0.05021065836106036,"d":"5.02%"},{"v":0.00395131974079343,"d":"0.40%"},{"v":0.0001983983655802925,"d":"0.0198%"}]
["IST"]
["  7. Immobilien Schweiz Fokus","CH0002598578","Wohnen","2020-04-30",{"v":273221.44,"d":"273,221.44"},null,"2020-03-31",274.73,{"v":0.01848802033376996,"d":"1.85%"},{"v":0.00344294952644675,"d":"0.34%"},{"v":6.365332085309119E-5,"d":"0.0064%"}]
["  8. Immobilien Schweiz Wohnen","CH0245229122","Wohnen","2020-04-30",122.39,null,"2020-03-31",211.98,{"v":0.01426524424108236,"d":"1.43%"},{"v":0.00262144671090358,"d":"0.26%"},{"v":3.739557759602159E-5,"d":"0.0037%"}]
["Patrimonium"]
["  9. Wohnimmobilien Schweiz","CH0112589673","Wohnen","2020-04-30",{"v":1591.41,"d":"1,591.41"},null,"2020-03-31",{"v":472.941457,"d":"472.94"},{"v":0.03182670721689948,"d":"3.18%"},{"v":0.00249456675800808,"d":"0.25%"},{"v":7.93938458401333E-5,"d":"0.0079%"}]
["Pensimo"]
["  10. Casareal (Wohnimmobilien)","CH0020488190","Wohnen","2020-04-30",{"v":1310,"d":"1,310.00"},null,"2019-12-31",{"v":1844.89,"d":"1,844.89"},{"v":0.124152308934477,"d":"12.42%"},{"v":0.00267891312667423,"d":"0.27%"},{"v":0.0003325932501114848,"d":"0.0333%"}]
["Turidomus"]
["  11. Casareal (Wohnimmobilien)","CH0020488026","Wohnen","2020-04-30",{"v":1530.45,"d":"1,530.45"},null,"2020-03-31",{"v":3475.76,"d":"3,475.76"},{"v":0.2339020913453365,"d":"23.39%"},{"v":0.00242344850171938,"d":"0.24%"},{"v":0.0005668496728198851,"d":"0.0567%"}]
["Zürich"]
["  12. Immobilien – Traditionell Schweiz","CH0023842187","Wohnen","2020-04-30",{"v":2590.7756,"d":"2,590.78"},null,"2020-03-31",{"v":630.8943581,"d":"630.89"},{"v":0.04245618505810631,"d":"4.25%"},{"v":0.00200670091523891,"d":"0.20%"},{"v":8.519686541365448E-5,"d":"0.0085%"}]
["  13. Immobilien – Wohnen Schweiz","CH0018192903","Wohnen","2020-04-30",{"v":2832.9586,"d":"2,832.96"},null,"2020-03-31",{"v":1942.1128257,"d":"1,942.11"},{"v":0.1306949419867399,"d":"13.07%"},{"v":0.00192812975728285,"d":"0.19%"},{"v":0.0002519968067709889,"d":"0.0252%"}]
["Gesamtsumme",{"$nulls":6},{"$f":"SUM(H2:H25)","v":{"v":14859.8927868,"d":"14,859.89"}},{"$f":"SUM(I2:I25)","v":{"v":1,"d":"100.00%"}},null,{"$f":"SUM(K2:K25)","v":{"v":0.002840475920075549,"d":"0.2840%"}}]
[]
["* 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]]}
["2020-04-30","ISIN","Kategoriserung","NAV",null,null,"Nettovermögen",null,"Gewicht","Perf.","Beitrag"]
["ASSETIMMO"]
["  1. Anlagegruppe G","CH0010493499","Geschäft","2020-04-30",{"v":428.8,"d":"428.80"},null,"2020-03-31",{"v":747.278,"d":"747.28"},{"v":0.09673360549220794,"d":"9.67%"},{"v":0.0019628002617067,"d":"0.20%"},{"v":0.0001898687461759384,"d":"0.0190%"}]
["Avadis"]
["  2. Immobilien Schweiz Geschäft","CH0141268083","Geschäft","2020-04-30",{"v":127130.4237,"d":"127,130.42"},null,"2020-03-31",{"v":828.1716,"d":"828.17"},{"v":0.107205116214114,"d":"10.72%"},{"v":0.00301039157275262,"d":"0.30%"},{"v":0.0003227293784069339,"d":"0.0323%"}]
["CSA"]
["  3. Real Estate Switzerland Commercial","CH0113543620","Geschäft","2020-04-30",{"v":1552.06,"d":"1,552.06"},null,"2020-03-31",{"v":1317.5825,"d":"1,317.58"},{"v":0.1705583541311762,"d":"17.06%"},{"v":0.0041861036885591,"d":"0.42%"},{"v":0.000713974955343086,"d":"0.0714%"}]
["DAI"]
["  4. Gewerbeimmobilien Schweiz DAGSIS","CH0347818491","Geschäft","2020-04-30",143.34,"* ","2020-02-28",{"v":135.702778,"d":"135.70"},{"v":0.01756644647808269,"d":"1.76%"},{"v":0.00293870696893372,"d":"0.29%"},{"v":5.162263868454281E-5,"d":"0.0052%"}]
["Ecoreal"]
["  5. Suisseselect","CH0181111045","Geschäft","2020-04-30",{"v":154.6,"d":"154.60"},null,"2020-03-31",{"v":427,"d":"427.00"},{"v":0.05527427482834072,"d":"5.53%"},{"v":0.004026496947655334,"d":"0.40%"},{"v":0.000222561698880176,"d":"0.0223%"}]
["Patrimonium"]
["  6. Gesundheitsimmobilien Schweiz","CH0282527719","Geschäft","2020-04-30",{"v":1223.91,"d":"1,223.91"},null,"2020-03-31",{"v":196.356109,"d":"196.36"},{"v":0.02541789586203659,"d":"2.54%"},{"v":0.00369854026570437,"d":"0.37%"},{"v":9.400911131522284E-5,"d":"0.0094%"}]
["Pensimo"]
["  7. Proreal (Geschäftsimmobilien)","CH0020488224","Geschäft","2020-04-30",{"v":1308.9,"d":"1,308.90"},null,"2019-12-31",511.63,{"v":0.06622945487218726,"d":"6.62%"},{"v":0.00295007854105212,"d":"0.30%"},{"v":0.0001953820936040195,"d":"0.0195%"}]
["Swiss Life"]
["  8. Geschäftsimmobilien Schweiz","CH0136837587","Geschäft","2020-04-30",151.93,null,"2020-03-31",{"v":1236.3561,"d":"1,236.36"},{"v":0.1600437631313712,"d":"16.00%"},{"v":0.00164820675105482,"d":"0.16%"},{"v":0.0002637852108573445,"d":"0.0264%"}]
["Turidomus"]
["  9. Proreal (Geschäftsimmobilien)","CH0020488067","Geschäft","2020-04-30",{"v":1142.65,"d":"1,142.65"},null,"2019-12-31",{"v":1028.71,"d":"1,028.71"},{"v":0.1331644010741508,"d":"13.32%"},{"v":0.00316052851060111,"d":"0.32%"},{"v":0.0004208698861919746,"d":"0.0421%"}]
["UBS 1"]
["  10. Kommerzielle Immobilien Schweiz","CH0100770533","Geschäft","2020-04-30",{"v":1646.96,"d":"1,646.96"},null,"2020-03-31",{"v":684.731309,"d":"684.73"},{"v":0.08863706453685127,"d":"8.86%"},{"v":0.00304514117274479,"d":"0.30%"},{"v":0.0002699123746524029,"d":"0.0270%"}]
["Zürich"]
["  11. Immobilien – Geschäft Schweiz","CH0032598069","Geschäft","2020-04-30",{"v":1813.5429,"d":"1,813.54"},null,"2020-03-31",{"v":611.5942595,"d":"611.59"},{"v":0.07916962337948134,"d":"7.92%"},{"v":0.00269718332520008,"d":"0.27%"},{"v":0.0002135349880415074,"d":"0.0214%"}]
["Gesamtsumme",{"$nulls":6},{"$f":"SUM(H2:H23)","v":{"v":7725.112655499999,"d":"7,725.11"}},{"$f":"SUM(I2:I23)","v":{"v":0.9999999999999999,"d":"100.00%"}},null,{"$f":"SUM(K2:K23)","v":{"v":0.00295825108215315,"d":"0.2958%"}}]
[]
["* Kein offizieller Handelskurs."]