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

{"sheet":"KGAST Immo-Index","index":0,"n_rows":57,"n_cols":11,"rows_kept":57,"merged":[[0,3,0,5],[0,6,0,7]]}
["2019-12-31","ISIN","Kategoriserung","NAV",null,null,"Nettovermögen",null,"Gewicht","Perf.","Beitrag"]
["Adimora"]
["  1. Omega (Wohnimmobilien)","CH0149835834","Wohnen","2019-12-31",{"v":1242.75,"d":"1,242.75"},null,"2019-09-30",{"v":248.5,"d":"248.50"},{"v":0.005595640143251884,"d":"0.56%"},{"v":0.00201568603515625,"d":"0.20%"},{"v":1.127905369451254E-5,"d":"0.0011%"}]
["ASSETIMMO"]
["  2. Anlagegruppe G","CH0010493499","Geschäft","2019-12-31",{"v":425.179992675781,"d":"425.18"},null,"2019-11-29",{"v":740.887023925781,"d":"740.89"},{"v":0.01668304697260974,"d":"1.67%"},{"v":0.00207405090332031,"d":"0.21%"},{"v":3.460148864367639E-5,"d":"0.0035%"}]
["  3. Anlagegruppe W","CH0010493457","Wohnen","2019-12-31",{"v":556.549987792969,"d":"556.55"},null,"2019-11-29",{"v":1599.251953125,"d":"1,599.25"},{"v":0.0360114222457957,"d":"3.60%"},{"v":0.00239547729492188,"d":"0.24%"},{"v":8.626454434764828E-5,"d":"0.0086%"}]
["Avadis"]
["  4. Immobilien Schweiz Geschäft","CH0141268083","Geschäft","2019-12-31",{"v":125586.84375,"d":"125,586.84"},null,"2019-11-29",{"v":845.173095703125,"d":"845.17"},{"v":0.01903132596504174,"d":"1.90%"},{"v":0.00287406921386719,"d":"0.29%"},{"v":5.469734805519777E-5,"d":"0.0055%"}]
["  5. Immobilien Schweiz Wohnen","CH0009359354","Wohnen","2019-12-31",{"v":143500.640625,"d":"143,500.64"},null,"2019-11-29",{"v":2442.88500976563,"d":"2,442.89"},{"v":0.05500807012471964,"d":"5.50%"},{"v":0.00342216491699219,"d":"0.34%"},{"v":0.0001882466877322618,"d":"0.0188%"}]
["CSA"]
["  6. Real Estate Switzerland","CH0013123002","Gemischt","2019-12-31",{"v":1840.92004394531,"d":"1,840.92"},null,"2019-11-29",{"v":5666.6357421875,"d":"5,666.64"},{"v":0.1275994142300616,"d":"12.76%"},{"v":0.00385528564453125,"d":"0.39%"},{"v":0.000491932189931753,"d":"0.0492%"}]
["  7. Real Estate Switzerland Commercial","CH0113543620","Geschäft","2019-12-31",{"v":1528.2099609375,"d":"1,528.21"},null,"2019-11-29",{"v":1300.05041503906,"d":"1,300.05"},{"v":0.02927410177321464,"d":"2.93%"},{"v":0.00342742919921875,"d":"0.34%"},{"v":0.0001003349111984172,"d":"0.0100%"}]
["  8. Real Estate Switzerland Residential","CH0025226090","Wohnen","2019-12-31",{"v":1840.67004394531,"d":"1,840.67"},null,"2019-11-29",{"v":739.020629882813,"d":"739.02"},{"v":0.01664102013385739,"d":"1.66%"},{"v":0.00357673645019531,"d":"0.36%"},{"v":5.952054328120177E-5,"d":"0.0060%"}]
["Ecoreal"]
["  9. Suissecore Plus","CH0108524155","Gemischt","2019-12-31",{"v":157.529998779297,"d":"157.53"},null,"2019-09-30",{"v":891,"d":"891.00"},{"v":0.02006324091604599,"d":"2.01%"},{"v":0.00267326354980469,"d":"0.27%"},{"v":5.363433063181582E-5,"d":"0.0054%"}]
["  10. Suisseselect","CH0181111045","Geschäft","2019-12-31",{"v":152.110000610352,"d":"152.11"},null,"2019-09-30",{"v":418,"d":"418.00"},{"v":0.009412384627280836,"d":"0.94%"},{"v":0.00402641296386719,"d":"0.40%"},{"v":3.789814748418781E-5,"d":"0.0038%"}]
["Greenbrix"]
["  11. Greenbrix Housing","CH0224042157","Wohnen","2019-12-31",{"v":10489,"d":"10,489.00"},"* ","2019-11-29",{"v":237.736404418945,"d":"237.74"},{"v":0.005353269086837076,"d":"0.54%"},{"v":0.003208570120501797,"d":"0.32%"},{"v":1.717633923903138E-5,"d":"0.0017%"}]
["Helvetia"]
["  12. Immobilien Romandie","CH0301200108","Gemischt","2019-12-31",{"v":1239.81005859375,"d":"1,239.81"},null,"2019-11-29",{"v":236.167694091797,"d":"236.17"},{"v":0.00531794539074161,"d":"0.53%"},{"v":0.00218254089355469,"d":"0.22%"},{"v":1.160663328498424E-5,"d":"0.0012%"}]
["  13. Immobilien Schweiz","CH0188230780","Gemischt","2019-12-31",{"v":1291.06005859375,"d":"1,291.06"},null,"2019-11-29",{"v":615.739196777344,"d":"615.74"},{"v":0.0138650099286156,"d":"1.39%"},{"v":0.00243026733398438,"d":"0.24%"},{"v":3.36956807148836E-5,"d":"0.0034%"}]
["HIG"]
["  14. CH-Classico","CH0002875208","Wohnen","2019-12-31",{"v":12504,"d":"12,504.00"},"* ","2019-11-29",{"v":753.283996582031,"d":"753.28"},{"v":0.01696219786939086,"d":"1.70%"},{"v":0.00401473999023438,"d":"0.40%"},{"v":6.809881410851187E-5,"d":"0.0068%"}]
["IST"]
["  15. Immobilien Schweiz Fokus","CH0002598578","Wohnen","2019-12-31",{"v":274574.6,"d":"274,574.60"},"* ","2019-11-29",{"v":276.217102050781,"d":"276.22"},{"v":0.006219764605585725,"d":"0.62%"},{"v":0.003000036565765196,"d":"0.30%"},{"v":1.865952124720932E-5,"d":"0.0019%"}]
["  16. Immobilien Schweiz Wohnen","CH0245229122","Wohnen","2019-12-31",{"v":121.5,"d":"121.50"},"* ","2019-11-29",{"v":210.340805053711,"d":"210.34"},{"v":0.004736384114778528,"d":"0.47%"},{"v":0.003054569470816615,"d":"0.31%"},{"v":1.446761431906327E-5,"d":"0.0014%"}]
["J. Safra Sarasin"]
["  17. Nachhaltig Immobilien Schweiz","CH0049550269","Gemischt","2019-12-31",{"v":1454.08,"d":"1,454.08"},"* ","2019-11-29",{"v":634.619567871094,"d":"634.62"},{"v":0.01429015182966864,"d":"1.43%"},{"v":0.005323632165264769,"d":"0.53%"},{"v":7.607551192694117E-5,"d":"0.0076%"}]
["Patrimonium"]
["  18. Gesundheitsimmobilien Schweiz","CH0282527719","Geschäft","2019-12-31",{"v":1195.31994628906,"d":"1,195.32"},null,"2019-11-29",{"v":170.401245117188,"d":"170.40"},{"v":0.003837038421077832,"d":"0.38%"},{"v":0.0102091979980469,"d":"1.02%"},{"v":3.917308496689685E-5,"d":"0.0039%"}]
["  19. Wohnimmobilien Schweiz","CH0112589673","Wohnen","2019-12-31",{"v":1580.14001464844,"d":"1,580.14"},null,"2019-11-29",{"v":463.878723144531,"d":"463.88"},{"v":0.01044546641781877,"d":"1.04%"},{"v":0.0148423767089844,"d":"1.48%"},{"v":0.000155035547474312,"d":"0.0155%"}]
["Pensimo"]
["  20. Casareal (Wohnimmobilien)","CH0020488190","Wohnen","2019-12-31",{"v":1296.02001953125,"d":"1,296.02"},null,"2018-12-31",{"v":1688.65002441406,"d":"1,688.65"},{"v":0.03802445820730217,"d":"3.80%"},{"v":0.0325025177001953,"d":"3.25%"},{"v":0.001235890625923175,"d":"0.1236%"}]
["  21. Proreal (Geschäftsimmobilien)","CH0020488224","Geschäft","2019-12-31",{"v":1293.56994628906,"d":"1,293.57"},null,"2018-12-31",{"v":414.040008544922,"d":"414.04"},{"v":0.00932321486006567,"d":"0.93%"},{"v":0.0171500396728516,"d":"1.72%"},{"v":0.0001598935047286458,"d":"0.0160%"}]
["Swiss Life"]
["  22. Geschäftsimmobilien Schweiz","CH0136837587","Geschäft","2019-12-31",{"v":150.399993896484,"d":"150.40"},null,"2019-11-29",{"v":1223.68115234375,"d":"1,223.68"},{"v":0.0275544441794584,"d":"2.76%"},{"v":0.00186515808105469,"d":"0.19%"},{"v":5.13933942302872E-5,"d":"0.0051%"}]
["  23. Immobilien Schweiz","CH0106150136","Gemischt","2019-12-31",{"v":169.720001220703,"d":"169.72"},null,"2019-11-29",{"v":2556.25830078125,"d":"2,556.26"},{"v":0.05756097209002983,"d":"5.76%"},{"v":0.00242164611816406,"d":"0.24%"},{"v":0.0001393923046195705,"d":"0.0139%"}]
["  24. Immobilien Schweiz Alter und Gesundheit","CH0385556482","Gemischt","2019-12-31",{"v":110.779998779297,"d":"110.78"},null,"2019-11-29",{"v":191.968994140625,"d":"191.97"},{"v":0.004322693802305703,"d":"0.43%"},{"v":0.00189926147460938,"d":"0.19%"},{"v":8.209925805251957E-6,"d":"0.0008%"}]
["Swiss Prime"]
["  25. SPA Immobilien Schweiz","CH0263627355","Gemischt","2019-12-31",{"v":1143.56994628906,"d":"1,143.57"},null,"2019-11-29",{"v":1595.31994628906,"d":"1,595.32"},{"v":0.03592288262690344,"d":"3.59%"},{"v":0.00333396911621094,"d":"0.33%"},{"v":0.0001197657812433666,"d":"0.0120%"}]
["Swisscanto"]
["  26. Immobilien Schweiz","CH0002875893","Gemischt","2019-12-31",{"v":228.630004882813,"d":"228.63"},null,"2019-11-29",{"v":7042.036132812505,"d":"7,042.04"},{"v":0.1585702216297622,"d":"15.86%"},{"v":0.00364356994628906,"d":"0.36%"},{"v":0.0005777616939065971,"d":"0.0578%"}]
["Tellco"]
["  27. Immobilien Schweiz","CH0024559798","Gemischt","2019-12-31",{"v":171.898803710938,"d":"171.90"},null,"2019-11-29",{"v":964.839416503906,"d":"964.84"},{"v":0.02172593227678463,"d":"2.17%"},{"v":0.00263175964355469,"d":"0.26%"},{"v":5.717743178464406E-5,"d":"0.0057%"}]
["Turidomus"]
["  28. Casareal (Wohnimmobilien)","CH0020488026","Wohnen","2019-12-31",{"v":1515.76000976563,"d":"1,515.76"},null,"2018-12-31",{"v":3299.05004882813,"d":"3,299.05"},{"v":0.07428690900531096,"d":"7.43%"},{"v":0.0385591125488281,"d":"3.86%"},{"v":0.002864437285240337,"d":"0.2864%"}]
["  29. Proreal (Geschäftsimmobilien)","CH0020488067","Geschäft","2019-12-31",{"v":1128.31005859375,"d":"1,128.31"},null,"2018-12-31",{"v":989.630004882813,"d":"989.63"},{"v":0.02228415848003552,"d":"2.23%"},{"v":0.0446466827392578,"d":"4.46%"},{"v":0.0009949137537694872,"d":"0.0995%"}]
["UBS 1"]
["  30. Immobilien Schweiz","CH0002875497","Gemischt","2019-12-31",{"v":1797.18005371094,"d":"1,797.18"},null,"2019-11-29",{"v":2192.43774414063,"d":"2,192.44"},{"v":0.04936858210339603,"d":"4.94%"},{"v":0.003288163117608045,"d":"0.33%"},{"v":0.0001623319508409914,"d":"0.0162%"}]
["  31. Kommerzielle Immobilien Schweiz","CH0100770533","Geschäft","2019-12-31",{"v":1627.02001953125,"d":"1,627.02"},null,"2019-11-29",{"v":676.864990234375,"d":"676.86"},{"v":0.015241420164657,"d":"1.52%"},{"v":0.00305166825799752,"d":"0.31%"},{"v":4.651175812328708E-5,"d":"0.0047%"}]
["Zürich"]
["  32. Immobilien – Geschäft Schweiz","CH0032598069","Geschäft","2019-12-31",{"v":1790.65344238281,"d":"1,790.65"},null,"2019-11-29",{"v":604.020629882813,"d":"604.02"},{"v":0.01360113514657769,"d":"1.36%"},{"v":0.00449020385742188,"d":"0.45%"},{"v":6.107186950047947E-5,"d":"0.0061%"}]
["  33. Immobilien – Traditionell Schweiz","CH0023842187","Wohnen","2019-12-31",{"v":2523.09936523438,"d":"2,523.10"},null,"2019-11-29",{"v":601.936767578125,"d":"601.94"},{"v":0.01355421143001785,"d":"1.36%"},{"v":0.0227769470214844,"d":"2.28%"},{"v":0.0003087235556595149,"d":"0.0309%"}]
["  34. Immobilien – Wohnen Schweiz","CH0018192903","Wohnen","2019-12-31",{"v":2787.82641601563,"d":"2,787.83"},null,"2019-11-29",{"v":1879.05212402344,"d":"1,879.05"},{"v":0.04231186920099912,"d":"4.23%"},{"v":0.0227138519287109,"d":"2.27%"},{"v":0.0009610655318584773,"d":"0.0961%"}]
["Gesamtsumme",{"$nulls":6},{"$f":"SUM(H2:H54)","v":{"v":44409.57489013673,"d":"44,409.57"}},{"$f":"SUM(I2:I54)","v":{"v":1,"d":"100.00%"}},null,{"$f":"SUM(K2:K54)","v":{"v":0.00930093835951662,"d":"0.9301%"}}]
[]
["* 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]]}
["2019-12-31","ISIN","Kategoriserung","NAV",null,null,"Nettovermögen",null,"Gewicht","Perf.","Beitrag"]
["CSA"]
["  1. Real Estate Switzerland","CH0013123002","Gemischt","2019-12-31",{"v":1840.92004394531,"d":"1,840.92"},null,"2019-11-29",{"v":5666.6357421875,"d":"5,666.64"},{"v":0.2508801539946759,"d":"25.09%"},{"v":0.00385528564453125,"d":"0.39%"},{"v":0.0009672146561934635,"d":"0.0967%"}]
["Ecoreal"]
["  2. Suissecore Plus","CH0108524155","Gemischt","2019-12-31",{"v":157.529998779297,"d":"157.53"},null,"2019-09-30",{"v":891,"d":"891.00"},{"v":0.03944743007655633,"d":"3.94%"},{"v":0.00267326354980469,"d":"0.27%"},{"v":0.0001054533769571273,"d":"0.0105%"}]
["Helvetia"]
["  3. Immobilien Romandie","CH0301200108","Gemischt","2019-12-31",{"v":1239.81005859375,"d":"1,239.81"},null,"2019-11-29",{"v":236.167694091797,"d":"236.17"},{"v":0.01045590190687734,"d":"1.05%"},{"v":0.00218254089355469,"d":"0.22%"},{"v":2.282043349075625E-5,"d":"0.0023%"}]
["  4. Immobilien Schweiz","CH0188230780","Gemischt","2019-12-31",{"v":1291.06005859375,"d":"1,291.06"},null,"2019-11-29",{"v":615.739196777344,"d":"615.74"},{"v":0.02726075074104291,"d":"2.73%"},{"v":0.00243026733398438,"d":"0.24%"},{"v":6.625091202584708E-5,"d":"0.0066%"}]
["J. Safra Sarasin"]
["  5. Nachhaltig Immobilien Schweiz","CH0049550269","Gemischt","2019-12-31",{"v":1454.08,"d":"1,454.08"},"* ","2019-11-29",{"v":634.619567871094,"d":"634.62"},{"v":0.02809664537464576,"d":"2.81%"},{"v":0.005323632165264769,"d":"0.53%"},{"v":0.0001495762050525018,"d":"0.0150%"}]
["Swiss Life"]
["  6. Immobilien Schweiz","CH0106150136","Gemischt","2019-12-31",{"v":169.720001220703,"d":"169.72"},null,"2019-11-29",{"v":2556.25830078125,"d":"2,556.26"},{"v":0.1131737604687823,"d":"11.32%"},{"v":0.00242164611816406,"d":"0.24%"},{"v":0.0002740667977172559,"d":"0.0274%"}]
["  7. Immobilien Schweiz Alter und Gesundheit","CH0385556482","Gemischt","2019-12-31",{"v":110.779998779297,"d":"110.78"},null,"2019-11-29",{"v":191.968994140625,"d":"191.97"},{"v":0.008499083583871109,"d":"0.85%"},{"v":0.00189926147460938,"d":"0.19%"},{"v":1.614198202033142E-5,"d":"0.0016%"}]
["Swiss Prime"]
["  8. SPA Immobilien Schweiz","CH0263627355","Gemischt","2019-12-31",{"v":1143.56994628906,"d":"1,143.57"},null,"2019-11-29",{"v":1595.31994628906,"d":"1,595.32"},{"v":0.07062993493936397,"d":"7.06%"},{"v":0.00333396911621094,"d":"0.33%"},{"v":0.0002354780217678275,"d":"0.0235%"}]
["Swisscanto"]
["  9. Immobilien Schweiz","CH0002875893","Gemischt","2019-12-31",{"v":228.630004882813,"d":"228.63"},null,"2019-11-29",{"v":7042.036132812505,"d":"7,042.04"},{"v":0.3117735442712732,"d":"31.18%"},{"v":0.00364356994628906,"d":"0.36%"},{"v":0.001135968715954833,"d":"0.1136%"}]
["Tellco"]
["  10. Immobilien Schweiz","CH0024559798","Gemischt","2019-12-31",{"v":171.898803710938,"d":"171.90"},null,"2019-11-29",{"v":964.839416503906,"d":"964.84"},{"v":0.04271653806693967,"d":"4.27%"},{"v":0.00263175964355469,"d":"0.26%"},{"v":0.0001124196609969395,"d":"0.0112%"}]
["UBS 1"]
["  11. Immobilien Schweiz","CH0002875497","Gemischt","2019-12-31",{"v":1797.18005371094,"d":"1,797.18"},null,"2019-11-29",{"v":2192.43774414063,"d":"2,192.44"},{"v":0.09706625657597127,"d":"9.71%"},{"v":0.003288163117608045,"d":"0.33%"},{"v":0.0003191696848373881,"d":"0.0319%"}]
["Gesamtsumme",{"$nulls":6},{"$f":"SUM(H2:H21)","v":{"v":22587.02273559571,"d":"22,587.02"}},{"$f":"SUM(I2:I21)","v":{"v":0.9999999999999998,"d":"100.00%"}},null,{"$f":"SUM(K2:K21)","v":{"v":0.003404560447014271,"d":"0.3405%"}}]
[]
["* 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-12-31","ISIN","Kategoriserung","NAV",null,null,"Nettovermögen",null,"Gewicht","Perf.","Beitrag"]
["Adimora"]
["  1. Omega (Wohnimmobilien)","CH0149835834","Wohnen","2019-12-31",{"v":1242.75,"d":"1,242.75"},null,"2019-09-30",{"v":248.5,"d":"248.50"},{"v":0.01720937535407951,"d":"1.72%"},{"v":0.00201568603515625,"d":"0.20%"},{"v":3.468869757498021E-5,"d":"0.0035%"}]
["ASSETIMMO"]
["  2. Anlagegruppe W","CH0010493457","Wohnen","2019-12-31",{"v":556.549987792969,"d":"556.55"},null,"2019-11-29",{"v":1599.251953125,"d":"1,599.25"},{"v":0.1107530267487843,"d":"11.08%"},{"v":0.00239547729492188,"d":"0.24%"},{"v":0.0002653063609205884,"d":"0.0265%"}]
["Avadis"]
["  3. Immobilien Schweiz Wohnen","CH0009359354","Wohnen","2019-12-31",{"v":143500.640625,"d":"143,500.64"},null,"2019-11-29",{"v":2442.88500976563,"d":"2,442.89"},{"v":0.1691771632994403,"d":"16.92%"},{"v":0.00342216491699219,"d":"0.34%"},{"v":0.0005789521529996034,"d":"0.0579%"}]
["CSA"]
["  4. Real Estate Switzerland Residential","CH0025226090","Wohnen","2019-12-31",{"v":1840.67004394531,"d":"1,840.67"},null,"2019-11-29",{"v":739.020629882813,"d":"739.02"},{"v":0.05117941011694808,"d":"5.12%"},{"v":0.00357673645019531,"d":"0.36%"},{"v":0.0001830552616647828,"d":"0.0183%"}]
["Greenbrix"]
["  5. Greenbrix Housing","CH0224042157","Wohnen","2019-12-31",{"v":10489,"d":"10,489.00"},"* ","2019-11-29",{"v":237.736404418945,"d":"237.74"},{"v":0.01646396385905381,"d":"1.65%"},{"v":0.003208570120501797,"d":"0.32%"},{"v":5.282578250318151E-5,"d":"0.0053%"}]
["HIG"]
["  6. CH-Classico","CH0002875208","Wohnen","2019-12-31",{"v":12504,"d":"12,504.00"},"* ","2019-11-29",{"v":753.283996582031,"d":"753.28"},{"v":0.05216719132958277,"d":"5.22%"},{"v":0.00401473999023438,"d":"0.40%"},{"v":0.0002094377092090842,"d":"0.0209%"}]
["IST"]
["  7. Immobilien Schweiz Fokus","CH0002598578","Wohnen","2019-12-31",{"v":274574.6,"d":"274,574.60"},"* ","2019-11-29",{"v":276.217102050781,"d":"276.22"},{"v":0.01912886836381479,"d":"1.91%"},{"v":0.003000036565765196,"d":"0.30%"},{"v":5.738730455315343E-5,"d":"0.0057%"}]
["  8. Immobilien Schweiz Wohnen","CH0245229122","Wohnen","2019-12-31",{"v":121.5,"d":"121.50"},"* ","2019-11-29",{"v":210.340805053711,"d":"210.34"},{"v":0.01456673588108079,"d":"1.46%"},{"v":0.003054569470816615,"d":"0.31%"},{"v":4.449510671179835E-5,"d":"0.0044%"}]
["Patrimonium"]
["  9. Wohnimmobilien Schweiz","CH0112589673","Wohnen","2019-12-31",{"v":1580.14001464844,"d":"1,580.14"},null,"2019-11-29",{"v":463.878723144531,"d":"463.88"},{"v":0.03212500227511213,"d":"3.21%"},{"v":0.0148423767089844,"d":"1.48%"},{"v":0.0004768113855441951,"d":"0.0477%"}]
["Pensimo"]
["  10. Casareal (Wohnimmobilien)","CH0020488190","Wohnen","2019-12-31",{"v":1296.02001953125,"d":"1,296.02"},null,"2018-12-31",{"v":1688.65002441406,"d":"1,688.65"},{"v":0.1169441131260245,"d":"11.69%"},{"v":0.0325025177001953,"d":"3.25%"},{"v":0.003800978106812252,"d":"0.3801%"}]
["Turidomus"]
["  11. Casareal (Wohnimmobilien)","CH0020488026","Wohnen","2019-12-31",{"v":1515.76000976563,"d":"1,515.76"},null,"2018-12-31",{"v":3299.05004882813,"d":"3,299.05"},{"v":0.2284691774735518,"d":"22.85%"},{"v":0.0385591125488281,"d":"3.86%"},{"v":0.008809568728140866,"d":"0.8810%"}]
["Zürich"]
["  12. Immobilien – Traditionell Schweiz","CH0023842187","Wohnen","2019-12-31",{"v":2523.09936523438,"d":"2,523.10"},null,"2019-11-29",{"v":601.936767578125,"d":"601.94"},{"v":0.04168593872303127,"d":"4.17%"},{"v":0.0227769470214844,"d":"2.28%"},{"v":0.0009494784178353285,"d":"0.0949%"}]
["  13. Immobilien – Wohnen Schweiz","CH0018192903","Wohnen","2019-12-31",{"v":2787.82641601563,"d":"2,787.83"},null,"2019-11-29",{"v":1879.05212402344,"d":"1,879.05"},{"v":0.130130033449496,"d":"13.01%"},{"v":0.0227138519287109,"d":"2.27%"},{"v":0.002955754311250049,"d":"0.2956%"}]
["Gesamtsumme",{"$nulls":6},{"$f":"SUM(H2:H25)","v":{"v":14439.8035888672,"d":"14,439.80"}},{"$f":"SUM(I2:I25)","v":{"v":1,"d":"100.00%"}},null,{"$f":"SUM(K2:K25)","v":{"v":0.01841873932571986,"d":"1.8419%"}}]
[]
["* 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-12-31","ISIN","Kategoriserung","NAV",null,null,"Nettovermögen",null,"Gewicht","Perf.","Beitrag"]
["ASSETIMMO"]
["  1. Anlagegruppe G","CH0010493499","Geschäft","2019-12-31",{"v":425.179992675781,"d":"425.18"},null,"2019-11-29",{"v":740.887023925781,"d":"740.89"},{"v":0.1003538204416907,"d":"10.04%"},{"v":0.00207405090332031,"d":"0.21%"},{"v":0.0002081389319387329,"d":"0.0208%"}]
["Avadis"]
["  2. Immobilien Schweiz Geschäft","CH0141268083","Geschäft","2019-12-31",{"v":125586.84375,"d":"125,586.84"},null,"2019-11-29",{"v":845.173095703125,"d":"845.17"},{"v":0.1144794636015057,"d":"11.45%"},{"v":0.00287406921386719,"d":"0.29%"},{"v":0.000329021901957117,"d":"0.0329%"}]
["CSA"]
["  3. Real Estate Switzerland Commercial","CH0113543620","Geschäft","2019-12-31",{"v":1528.2099609375,"d":"1,528.21"},null,"2019-11-29",{"v":1300.05041503906,"d":"1,300.05"},{"v":0.176093009734025,"d":"17.61%"},{"v":0.00342742919921875,"d":"0.34%"},{"v":0.0006035463233407088,"d":"0.0604%"}]
["Ecoreal"]
["  4. Suisseselect","CH0181111045","Geschäft","2019-12-31",{"v":152.110000610352,"d":"152.11"},null,"2019-09-30",{"v":418,"d":"418.00"},{"v":0.05661847972765804,"d":"5.66%"},{"v":0.00402641296386719,"d":"0.40%"},{"v":0.000227969380769894,"d":"0.0228%"}]
["Patrimonium"]
["  5. Gesundheitsimmobilien Schweiz","CH0282527719","Geschäft","2019-12-31",{"v":1195.31994628906,"d":"1,195.32"},null,"2019-11-29",{"v":170.401245117188,"d":"170.40"},{"v":0.02308100345032344,"d":"2.31%"},{"v":0.0102091979980469,"d":"1.02%"},{"v":0.0002356385342179556,"d":"0.0236%"}]
["Pensimo"]
["  6. Proreal (Geschäftsimmobilien)","CH0020488224","Geschäft","2019-12-31",{"v":1293.56994628906,"d":"1,293.57"},null,"2018-12-31",{"v":414.040008544922,"d":"414.04"},{"v":0.05608209528765556,"d":"5.61%"},{"v":0.0171500396728516,"d":"1.72%"},{"v":0.0009618101591199366,"d":"0.0962%"}]
["Swiss Life"]
["  7. Geschäftsimmobilien Schweiz","CH0136837587","Geschäft","2019-12-31",{"v":150.399993896484,"d":"150.40"},null,"2019-11-29",{"v":1223.68115234375,"d":"1,223.68"},{"v":0.1657487237251001,"d":"16.57%"},{"v":0.00186515808105469,"d":"0.19%"},{"v":0.0003091475714803717,"d":"0.0309%"}]
["Turidomus"]
["  8. Proreal (Geschäftsimmobilien)","CH0020488067","Geschäft","2019-12-31",{"v":1128.31005859375,"d":"1,128.31"},null,"2018-12-31",{"v":989.630004882813,"d":"989.63"},{"v":0.1340462831802385,"d":"13.40%"},{"v":0.0446466827392578,"d":"4.46%"},{"v":0.005984721877524816,"d":"0.5985%"}]
["UBS 1"]
["  9. Kommerzielle Immobilien Schweiz","CH0100770533","Geschäft","2019-12-31",{"v":1627.02001953125,"d":"1,627.02"},null,"2019-11-29",{"v":676.864990234375,"d":"676.86"},{"v":0.09168197781805364,"d":"9.17%"},{"v":0.00305166825799752,"d":"0.31%"},{"v":0.000279782981537787,"d":"0.0280%"}]
["Zürich"]
["  10. Immobilien – Geschäft Schweiz","CH0032598069","Geschäft","2019-12-31",{"v":1790.65344238281,"d":"1,790.65"},null,"2019-11-29",{"v":604.020629882813,"d":"604.02"},{"v":0.08181514303374948,"d":"8.18%"},{"v":0.00449020385742188,"d":"0.45%"},{"v":0.0003673666708456647,"d":"0.0367%"}]
["Gesamtsumme",{"$nulls":6},{"$f":"SUM(H2:H21)","v":{"v":7382.748565673826,"d":"7,382.75"}},{"$f":"SUM(I2:I21)","v":{"v":1,"d":"100.00%"}},null,{"$f":"SUM(K2:K21)","v":{"v":0.009507144332732986,"d":"0.9507%"}}]