{"text_format":"5","workbook":"xlsx","n_sheets":4,"sheets":["KGAST Immo-Index","KGAST Immo-Index Mixte","KGAST Immo-Index Résidentiel","KGAST Immo-Index Commercial"],"props":{"title":"KGAST Immo-Index","subject":"Données mensuelles","description":"2023-04-28","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-04-28","ISIN","Classification","VNI",null,null,"Fortune nette",null,"Poids","Perf.","Contrib."]
[1291]
["  1. Immobilier Suisse","CH0427260721","Mixte","2023-04-28",{"v":120.1445,"d":"120.14"},null,"2023-03-31",{"v":1052.6,"d":"1,052.60"},{"v":0.015152111633637,"d":"1.52%"},{"v":0.0018002378081625,"d":"0.18%"},{"v":2.7277404236372E-5,"d":"0.0027%"}]
["Adimora"]
["  2. Omega (Habitation)","CH0149835834","Résidentiel","2023-04-28",{"v":1396.6,"d":"1,396.60"},null,"2022-09-30",379.14,{"v":0.0054576967554408,"d":"0.55%"},{"v":0.0021167438022458,"d":"0.21%"},{"v":1.1552545781616E-5,"d":"0.0012%"}]
["ASSETIMMO"]
["  3. Groupe d'investissement G","CH0010493499","Commercial","2023-04-28",450.61,null,"2023-03-31",{"v":785.873,"d":"785.87"},{"v":0.011312593032359,"d":"1.13%"},{"v":0.0024917128300963,"d":"0.25%"},{"v":2.8187733200386E-5,"d":"0.0028%"}]
["  4. Groupe d'investissement W","CH0010493457","Résidentiel","2023-04-28",{"v":607.3,"d":"607.30"},null,"2023-03-31",{"v":1828.265,"d":"1,828.27"},{"v":0.026317761139911,"d":"2.63%"},{"v":0.0025091617418864,"d":"0.25%"},{"v":6.603551938437E-5,"d":"0.0066%"}]
["Avadis"]
["  5. Immobilier Suisse commerces","CH0141268083","Commercial","2023-04-28",{"v":138137.58,"d":"138,137.58"},null,"2023-03-31",{"v":907.4088,"d":"907.41"},{"v":0.013062093325997,"d":"1.31%"},{"v":0.0024062816432202,"d":"0.24%"},{"v":3.1431075392375E-5,"d":"0.0031%"}]
["  6. Immobilier Suisse habitation","CH0009359354","Résidentiel","2023-04-28",{"v":171369.45,"d":"171,369.45"},null,"2023-03-31",{"v":2863.483,"d":"2,863.48"},{"v":0.041219659962968,"d":"4.12%"},{"v":0.0024015130187145,"d":"0.24%"},{"v":9.8989550028053E-5,"d":"0.0099%"}]
["  7. Immobilier Suisse habitation centres de taille moyenne","CH0547737087","Résidentiel","2023-04-28",{"v":1165.24,"d":"1,165.24"},null,"2023-03-31",{"v":287.7472,"d":"287.75"},{"v":0.0041421030749253,"d":"0.41%"},{"v":0.0023914801369509,"d":"0.24%"},{"v":9.905757228887E-6,"d":"0.0010%"}]
["avenirplus"]
["  8. Immobilier","CH0371634939","Mixte","2023-04-28",{"v":1413.11,"d":"1,413.11"},null,"2023-03-31",{"v":168.9986128,"d":"169.00"},{"v":0.0024327245364576,"d":"0.24%"},{"v":0.0024858009968742,"d":"0.25%"},{"v":6.0472690778468E-6,"d":"0.0006%"}]
["AXA"]
["  9. Immobilier Suisse ","CH0436698515","Mixte","2023-04-28",{"v":1054.69,"d":"1,054.69"},"* ","2023-03-31",{"v":8551.8022285,"d":"8,551.80"},{"v":0.12310266201312,"d":"12.31%"},{"v":0.0018332763402862,"d":"0.18%"},{"v":0.00022568119769491,"d":"0.0226%"}]
["CSF"]
["  10. Real Estate Switzerland","CH0013123002","Mixte","2023-04-28",{"v":2001.01,"d":"2,001.01"},null,"2023-03-31",{"v":6480.673,"d":"6,480.67"},{"v":0.093288885385801,"d":"9.33%"},{"v":0.0028566989590591,"d":"0.29%"},{"v":0.0002664982617734,"d":"0.0266%"}]
["  11. Real Estate Switzerland Commercial","CH0113543620","Commercial","2023-04-28",{"v":1722.47,"d":"1,722.47"},null,"2023-03-31",{"v":1462.0355,"d":"1,462.04"},{"v":0.02104591023023,"d":"2.10%"},{"v":-0.0027731783286824,"d":"-0.28%"},{"v":-5.8364062157868E-5,"d":"-0.0058%"}]
["  12. Real Estate Switzerland Residential","CH0025226090","Résidentiel","2023-04-28",{"v":2245.01,"d":"2,245.01"},null,"2023-03-31",{"v":1025.8502,"d":"1,025.85"},{"v":0.014767049923797,"d":"1.48%"},{"v":0.0045102083734168,"d":"0.45%"},{"v":6.6602472216971E-5,"d":"0.0067%"}]
["DAI"]
["  13. Immobilier commercial Suisse DAGSIS","CH0347818491","Commercial","2023-04-28",179.19,"* ","2023-03-31",{"v":243.543668,"d":"243.54"},{"v":0.0035057959768205,"d":"0.35%"},{"v":0.0043719522448296,"d":"0.44%"},{"v":1.5327172590775E-5,"d":"0.0015%"}]
["Ecoreal"]
["  14. SUISSECORE Plus","CH0108524155","Mixte","2023-04-28",191.41,"* ","2023-03-31",{"v":1258,"d":"1,258.00"},{"v":0.018108831878315,"d":"1.81%"},{"v":0.0024615062323246,"d":"0.25%"},{"v":4.4575002528591E-5,"d":"0.0045%"}]
["  15. SUISSESELECT","CH0181111045","Commercial","2023-04-28",180.06,"* ","2023-03-31",{"v":532,"d":"532.00"},{"v":0.0076581069628488,"d":"0.77%"},{"v":0.0032315578337421,"d":"0.32%"},{"v":2.4747615547429E-5,"d":"0.0025%"}]
["Greenbrix"]
["  16. Greenbrix Housing – Immeubles d'habitation en Suisse","CH0224042157","Résidentiel","2023-04-28",{"v":10999,"d":"10,999.00"},"* ","2023-03-31",{"v":357.980418,"d":"357.98"},{"v":0.0051531058865589,"d":"0.52%"},{"v":0.0025521830279829,"d":"0.26%"},{"v":1.3151669385074E-5,"d":"0.0013%"}]
["Helvetia"]
["  17. Immobilier Romandie","CH0301200108","Mixte","2023-04-28",{"v":1410.06,"d":"1,410.06"},"* ","2023-03-31",{"v":602.9871313,"d":"602.99"},{"v":0.0086799623096179,"d":"0.87%"},{"v":0.00063867836157683,"d":"0.06%"},{"v":5.5437041064554E-6,"d":"0.0006%"}]
["  18. Immobilier Suisse","CH0188230780","Mixte","2023-04-28",{"v":1477.58,"d":"1,477.58"},"* ","2023-03-31",{"v":834.406507,"d":"834.41"},{"v":0.012011229851697,"d":"1.20%"},{"v":0.0075073129819923,"d":"0.75%"},{"v":9.0172061795341E-5,"d":"0.0090%"}]
["HIG"]
["  19. CH-Classico","CH0002875208","Résidentiel","2023-04-28",{"v":13734,"d":"13,734.00"},"* ","2023-03-31",{"v":1014.93253,"d":"1,014.93"},{"v":0.014609890742133,"d":"1.46%"},{"v":0.0036539023677287,"d":"0.37%"},{"v":5.3383114374937E-5,"d":"0.0053%"}]
["IST"]
["  20. Immobilier Résidentiel Suisse","CH0245229122","Résidentiel","2023-04-28",136.98,null,"2023-03-31",{"v":297.0903,"d":"297.09"},{"v":0.0042765964192196,"d":"0.43%"},{"v":0.0018284209756461,"d":"0.18%"},{"v":7.819418597274E-6,"d":"0.0008%"}]
["  21. Immobilier Suisse Focus","CH0002598578","Résidentiel","2023-04-28",{"v":313276.73,"d":"313,276.73"},null,"2023-03-31",{"v":315.3144,"d":"315.31"},{"v":0.0045389312070047,"d":"0.45%"},{"v":0.002102973168963,"d":"0.21%"},{"v":9.5452505440998E-6,"d":"0.0010%"}]
["J. Safra Sarasin"]
["  22. Immobilier Durable Suisse","CH0049550269","Mixte","2023-04-28",{"v":1647.49,"d":"1,647.49"},"* ","2023-03-31",{"v":722,"d":"722.00"},{"v":0.010393145163866,"d":"1.04%"},{"v":-0.00073997246332025,"d":"-0.07%"},{"v":-7.690641228551E-6,"d":"-0.0008%"}]
["Patrimonium"]
["  23. Immobilier de la Santé Suisse","CH0282527719","Commercial","2023-04-28",{"v":1251.23,"d":"1,251.23"},null,"2023-03-31",{"v":320.941444,"d":"320.94"},{"v":0.0046199321559458,"d":"0.46%"},{"v":0.0039234879727843,"d":"0.39%"},{"v":1.8126248248933E-5,"d":"0.0018%"}]
["  24. Immobilier résidentiel Suisse","CH0112589673","Résidentiel","2023-04-28",{"v":1848,"d":"1,848.00"},null,"2023-03-31",{"v":645.88991,"d":"645.89"},{"v":0.0092975451447458,"d":"0.93%"},{"v":0.0027891429625691,"d":"0.28%"},{"v":2.5932182609636E-5,"d":"0.0026%"}]
["Pensimo"]
["  25. Casareal (Habitation)","CH0020488190","Résidentiel","2023-04-28",{"v":1381.4,"d":"1,381.40"},null,"2022-12-30",{"v":2232.62,"d":"2,232.62"},{"v":0.032138426254503,"d":"3.21%"},{"v":0.0021764364480557,"d":"0.22%"},{"v":6.9947242283448E-5,"d":"0.0070%"}]
["  26. Proreal (Commercial)","CH0020488224","Commercial","2023-04-28",{"v":1327.8,"d":"1,327.80"},null,"2022-12-30",514.51,{"v":0.0074063394989762,"d":"0.74%"},{"v":0.0026429056860229,"d":"0.26%"},{"v":1.957425677446E-5,"d":"0.0020%"}]
["Prisma"]
["  27. Previous Responsible Residential Real Estate","CH0298011104","Résidentiel","2023-04-28",{"v":1119.63,"d":"1,119.63"},"* ","2023-03-31",{"v":110.01775902,"d":"110.02"},{"v":0.0015836988090002,"d":"0.16%"},{"v":0.00032163821061948,"d":"0.03%"},{"v":5.0937805108701E-7,"d":"0.0001%"}]
["SFP"]
["  28. Swiss Real Estate","CH0437532747","Mixte","2023-04-28",{"v":1182.76,"d":"1,182.76"},null,"2023-03-31",528.59,{"v":0.0076090202246095,"d":"0.76%"},{"v":0.0024239342317145,"d":"0.24%"},{"v":1.8443764592239E-5,"d":"0.0018%"}]
["Swiss Life"]
["  29. Immeubles commerciaux Suisse ESG","CH0136837587","Commercial","2023-04-28",172.89,null,"2023-03-31",{"v":1887.36,"d":"1,887.36"},{"v":0.027168429995117,"d":"2.72%"},{"v":-0.015657029483999,"d":"-1.57%"},{"v":-0.00042537690946752,"d":"-0.0425%"}]
["  30. Immobilier Suisse Age et Santé ESG","CH0385556482","Mixte","2023-04-28",130.95,null,"2023-03-31",{"v":442.6306,"d":"442.63"},{"v":0.0063716399996803,"d":"0.64%"},{"v":0.0022962112514351,"d":"0.23%"},{"v":1.463063145736E-5,"d":"0.0015%"}]
["  31. Immobilier Suisse ESG","CH0106150136","Mixte","2023-04-28",198.08,null,"2023-03-31",{"v":3711.4373,"d":"3,711.44"},{"v":0.053425909453584,"d":"5.34%"},{"v":0.0022262699858329,"d":"0.22%"},{"v":0.00011894049868234,"d":"0.0119%"}]
["Swiss Prime"]
["  32. Immobilier Suisse","CH0263627355","Mixte","2023-04-28",{"v":1325.92,"d":"1,325.92"},null,"2023-03-31",{"v":2685.3,"d":"2,685.30"},{"v":0.038654726743116,"d":"3.87%"},{"v":0,"d":"0.00%"},{"v":0,"d":"0.0000%"}]
["Swisscanto"]
["  33. Immeubles Responsible suisses","CH0002875893","Mixte","2023-04-28",266.67,null,"2023-03-31",{"v":8407.8932,"d":"8,407.89"},{"v":0.1210311004846,"d":"12.10%"},{"v":0.003273137697517,"d":"0.33%"},{"v":0.00039615145756813,"d":"0.0396%"}]
["Tellco"]
["  34. Immobilier commercial Suisse","CH0598652672","Commercial","2023-04-28",{"v":116.8051,"d":"116.81"},null,"2023-03-31",{"v":32.524997,"d":"32.52"},{"v":0.00046819531201567,"d":"0.05%"},{"v":0.0045002743335585,"d":"0.45%"},{"v":2.1070073457565E-6,"d":"0.0002%"}]
["  35. Immobilier Suisse","CH0024559798","Mixte","2023-04-28",{"v":195.2513,"d":"195.25"},null,"2023-03-31",{"v":1054.1760914,"d":"1,054.18"},{"v":0.015174799371464,"d":"1.52%"},{"v":0.0054714793026169,"d":"0.55%"},{"v":8.3028600682332E-5,"d":"0.0083%"}]
["Terra Helvetica"]
["  36. Résidentiel Suisse","CH0544073437","Résidentiel","2023-04-28",{"v":1073,"d":"1,073.00"},"* ","2023-03-31",{"v":123.272129,"d":"123.27"},{"v":0.0017744946417671,"d":"0.18%"},{"v":0.0037418147801684,"d":"0.37%"},{"v":6.6398302778938E-6,"d":"0.0007%"}]
["Turidomus"]
["  37. Casareal (Habitation)","CH0020488026","Résidentiel","2023-04-28",{"v":1687.7,"d":"1,687.70"},null,"2022-12-30",{"v":4541.13,"d":"4,541.13"},{"v":0.065369284346243,"d":"6.54%"},{"v":0.0021971496437054,"d":"0.22%"},{"v":0.00014362609981063,"d":"0.0144%"}]
["  38. Proreal (Commercial)","CH0020488067","Commercial","2023-04-28",{"v":1238.3,"d":"1,238.30"},null,"2022-12-30",{"v":1304.05,"d":"1,304.05"},{"v":0.018771718768615,"d":"1.88%"},{"v":0.0027938616026237,"d":"0.28%"},{"v":5.2445584282884E-5,"d":"0.0052%"}]
["  39. Urban & Mixed-use","CH0307702511","Mixte","2023-04-28",{"v":1031.65,"d":"1,031.65"},null,"2022-12-30",{"v":1289.1,"d":"1,289.10"},{"v":0.018556514447008,"d":"1.86%"},{"v":0.0020397260939247,"d":"0.20%"},{"v":3.7850206729853E-5,"d":"0.0038%"}]
["UBS 1"]
["  40. Immeubles commerciaux suisses","CH0100770533","Commercial","2023-04-28",{"v":1721.22,"d":"1,721.22"},null,"2023-03-31",{"v":677.3490403,"d":"677.35"},{"v":0.0097503973718052,"d":"0.98%"},{"v":0.002615437488714,"d":"0.26%"},{"v":2.5501554816077E-5,"d":"0.0026%"}]
["  41. Immeubles suisses","CH0002875497","Mixte","2023-04-28",{"v":2008.67,"d":"2,008.67"},null,"2023-03-31",{"v":2613.179118,"d":"2,613.18"},{"v":0.037616551125426,"d":"3.76%"},{"v":0.0029509277197468,"d":"0.30%"},{"v":0.00011100372343729,"d":"0.0111%"}]
["Zurich"]
["  42. Immobiliers – Commercial Suisse","CH0032598069","Commercial","2023-04-28",{"v":2048.3107,"d":"2,048.31"},null,"2023-03-31",{"v":751.9885574,"d":"751.99"},{"v":0.010824828585353,"d":"1.08%"},{"v":0.0019385646550518,"d":"0.19%"},{"v":2.0984630092559E-5,"d":"0.0021%"}]
["  43. Immobiliers – Habitat Suisse","CH0018192903","Résidentiel","2023-04-28",{"v":3325.4437,"d":"3,325.44"},null,"2023-03-31",{"v":2897.3330311,"d":"2,897.33"},{"v":0.041706929058569,"d":"4.17%"},{"v":0.0014554250079533,"d":"0.15%"},{"v":6.0701307556774E-5,"d":"0.0061%"}]
["  44. Immobiliers – Traditionnel Suisse","CH0023842187","Résidentiel","2023-04-28",{"v":3129.0581,"d":"3,129.06"},null,"2023-03-31",{"v":725.4404894,"d":"725.44"},{"v":0.010442670795125,"d":"1.04%"},{"v":0.0020117678637064,"d":"0.20%"},{"v":2.1008229516898E-5,"d":"0.0021%"}]
["Total",{"$nulls":6},{"$f":"SUM(H2:H71)","v":{"v":69468.86516222,"d":"69,468.87"}},{"$f":"SUM(I2:I71)","v":{"v":1,"d":"100.00%"}},null,{"$f":"SUM(K2:K71)","v":{"v":0.0018581946174478,"d":"0.1858%"}}]
[]
["* Cours non officiel."]

{"sheet":"KGAST Immo-Index Mixte","index":1,"n_rows":34,"n_cols":11,"rows_kept":34,"merged":[[0,3,0,5],[0,6,0,7]]}
["2023-04-28","ISIN","Classification","VNI",null,null,"Fortune nette",null,"Poids","Perf.","Contrib."]
[1291]
["  1. Immobilier Suisse","CH0427260721","Mixte","2023-04-28",{"v":120.1445,"d":"120.14"},null,"2023-03-31",{"v":1052.6,"d":"1,052.60"},{"v":0.026052021910057,"d":"2.61%"},{"v":0.0018002378081625,"d":"0.18%"},{"v":4.6899834821562E-5,"d":"0.0047%"}]
["avenirplus"]
["  2. Immobilier","CH0371634939","Mixte","2023-04-28",{"v":1413.11,"d":"1,413.11"},null,"2023-03-31",{"v":168.9986128,"d":"169.00"},{"v":0.0041827432675611,"d":"0.42%"},{"v":0.0024858009968742,"d":"0.25%"},{"v":1.0397467384172E-5,"d":"0.0010%"}]
["AXA"]
["  3. Immobilier Suisse ","CH0436698515","Mixte","2023-04-28",{"v":1054.69,"d":"1,054.69"},"* ","2023-03-31",{"v":8551.8022285,"d":"8,551.80"},{"v":0.21165850183104,"d":"21.17%"},{"v":0.0018332763402862,"d":"0.18%"},{"v":0.00038802852362727,"d":"0.0388%"}]
["CSF"]
["  4. Real Estate Switzerland","CH0013123002","Mixte","2023-04-28",{"v":2001.01,"d":"2,001.01"},null,"2023-03-31",{"v":6480.673,"d":"6,480.67"},{"v":0.16039771516997,"d":"16.04%"},{"v":0.0028566989590591,"d":"0.29%"},{"v":0.00045820798596151,"d":"0.0458%"}]
["Ecoreal"]
["  5. SUISSECORE Plus","CH0108524155","Mixte","2023-04-28",191.41,"* ","2023-03-31",{"v":1258,"d":"1,258.00"},{"v":0.031135705455872,"d":"3.11%"},{"v":0.0024615062323246,"d":"0.25%"},{"v":7.6640733027451E-5,"d":"0.0077%"}]
["Helvetia"]
["  6. Immobilier Romandie","CH0301200108","Mixte","2023-04-28",{"v":1410.06,"d":"1,410.06"},"* ","2023-03-31",{"v":602.9871313,"d":"602.99"},{"v":0.014924029979204,"d":"1.49%"},{"v":0.00063867836157683,"d":"0.06%"},{"v":9.5316550152413E-6,"d":"0.0010%"}]
["  7. Immobilier Suisse","CH0188230780","Mixte","2023-04-28",{"v":1477.58,"d":"1,477.58"},"* ","2023-03-31",{"v":834.406507,"d":"834.41"},{"v":0.020651697323065,"d":"2.07%"},{"v":0.0075073129819923,"d":"0.75%"},{"v":0.00015503875541362,"d":"0.0155%"}]
["J. Safra Sarasin"]
["  8. Immobilier Durable Suisse","CH0049550269","Mixte","2023-04-28",{"v":1647.49,"d":"1,647.49"},"* ","2023-03-31",{"v":722,"d":"722.00"},{"v":0.017869617916645,"d":"1.79%"},{"v":-0.00073997246332025,"d":"-0.07%"},{"v":-1.3223025188372E-5,"d":"-0.0013%"}]
["SFP"]
["  9. Swiss Real Estate","CH0437532747","Mixte","2023-04-28",{"v":1182.76,"d":"1,182.76"},null,"2023-03-31",528.59,{"v":0.01308268882903,"d":"1.31%"},{"v":0.0024239342317145,"d":"0.24%"},{"v":3.1711577295554E-5,"d":"0.0032%"}]
["Swiss Life"]
["  10. Immobilier Suisse Age et Santé ESG","CH0385556482","Mixte","2023-04-28",130.95,null,"2023-03-31",{"v":442.6306,"d":"442.63"},{"v":0.010955179640188,"d":"1.10%"},{"v":0.0022962112514351,"d":"0.23%"},{"v":2.5155406751291E-5,"d":"0.0025%"}]
["  11. Immobilier Suisse ESG","CH0106150136","Mixte","2023-04-28",198.08,null,"2023-03-31",{"v":3711.4373,"d":"3,711.44"},{"v":0.091858679324911,"d":"9.19%"},{"v":0.0022262699858329,"d":"0.22%"},{"v":0.0002045022207193,"d":"0.0205%"}]
["Swiss Prime"]
["  12. Immobilier Suisse","CH0263627355","Mixte","2023-04-28",{"v":1325.92,"d":"1,325.92"},null,"2023-03-31",{"v":2685.3,"d":"2,685.30"},{"v":0.066461613561728,"d":"6.65%"},{"v":0,"d":"0.00%"},{"v":0,"d":"0.0000%"}]
["Swisscanto"]
["  13. Immeubles Responsible suisses","CH0002875893","Mixte","2023-04-28",266.67,null,"2023-03-31",{"v":8407.8932,"d":"8,407.89"},{"v":0.20809672987252,"d":"20.81%"},{"v":0.003273137697517,"d":"0.33%"},{"v":0.00068112925127577,"d":"0.0681%"}]
["Tellco"]
["  14. Immobilier Suisse","CH0024559798","Mixte","2023-04-28",{"v":195.2513,"d":"195.25"},null,"2023-03-31",{"v":1054.1760914,"d":"1,054.18"},{"v":0.026091030429613,"d":"2.61%"},{"v":0.0054714793026169,"d":"0.55%"},{"v":0.00014275653297958,"d":"0.0143%"}]
["Turidomus"]
["  15. Urban & Mixed-use","CH0307702511","Mixte","2023-04-28",{"v":1031.65,"d":"1,031.65"},null,"2022-12-30",{"v":1289.1,"d":"1,289.10"},{"v":0.031905435535107,"d":"3.19%"},{"v":0.0020397260939247,"d":"0.20%"},{"v":6.507834939899E-5,"d":"0.0065%"}]
["UBS 1"]
["  16. Immeubles suisses","CH0002875497","Mixte","2023-04-28",{"v":2008.67,"d":"2,008.67"},null,"2023-03-31",{"v":2613.179118,"d":"2,613.18"},{"v":0.064676609953485,"d":"6.47%"},{"v":0.0029509277197468,"d":"0.30%"},{"v":0.00019085600113099,"d":"0.0191%"}]
["Total",{"$nulls":6},{"$f":"SUM(H2:H31)","v":{"v":40403.773789,"d":"40,403.77"}},{"$f":"SUM(I2:I31)","v":{"v":1,"d":"100.00%"}},null,{"$f":"SUM(K2:K31)","v":{"v":0.0024727112696139,"d":"0.2473%"}}]
[]
["* Cours non officiel."]

{"sheet":"KGAST Immo-Index Résidentiel","index":2,"n_rows":33,"n_cols":11,"rows_kept":33,"merged":[[0,3,0,5],[0,6,0,7]]}
["2023-04-28","ISIN","Classification","VNI",null,null,"Fortune nette",null,"Poids","Perf.","Contrib."]
["Adimora"]
["  1. Omega (Habitation)","CH0149835834","Résidentiel","2023-04-28",{"v":1396.6,"d":"1,396.60"},null,"2022-09-30",379.14,{"v":0.019299069870051,"d":"1.93%"},{"v":0.0021167438022458,"d":"0.21%"},{"v":4.0851186536539E-5,"d":"0.0041%"}]
["ASSETIMMO"]
["  2. Groupe d'investissement W","CH0010493457","Résidentiel","2023-04-28",{"v":607.3,"d":"607.30"},null,"2023-03-31",{"v":1828.265,"d":"1,828.27"},{"v":0.093062757756946,"d":"9.31%"},{"v":0.0025091617418864,"d":"0.25%"},{"v":0.00023350951135817,"d":"0.0234%"}]
["Avadis"]
["  3. Immobilier Suisse habitation","CH0009359354","Résidentiel","2023-04-28",{"v":171369.45,"d":"171,369.45"},null,"2023-03-31",{"v":2863.483,"d":"2,863.48"},{"v":0.14575765809121,"d":"14.58%"},{"v":0.0024015130187145,"d":"0.24%"},{"v":0.00035003891348339,"d":"0.0350%"}]
["  4. Immobilier Suisse habitation centres de taille moyenne","CH0547737087","Résidentiel","2023-04-28",{"v":1165.24,"d":"1,165.24"},null,"2023-03-31",{"v":287.7472,"d":"287.75"},{"v":0.01464697293272,"d":"1.46%"},{"v":0.0023914801369509,"d":"0.24%"},{"v":3.5027944835058E-5,"d":"0.0035%"}]
["CSF"]
["  5. Real Estate Switzerland Residential","CH0025226090","Résidentiel","2023-04-28",{"v":2245.01,"d":"2,245.01"},null,"2023-03-31",{"v":1025.8502,"d":"1,025.85"},{"v":0.052218058463907,"d":"5.22%"},{"v":0.0045102083734168,"d":"0.45%"},{"v":0.00023551432452748,"d":"0.0236%"}]
["Greenbrix"]
["  6. Greenbrix Housing – Immeubles d'habitation en Suisse","CH0224042157","Résidentiel","2023-04-28",{"v":10999,"d":"10,999.00"},"* ","2023-03-31",{"v":357.980418,"d":"357.98"},{"v":0.018222000050356,"d":"1.82%"},{"v":0.0025521830279829,"d":"0.26%"},{"v":4.6505879264422E-5,"d":"0.0047%"}]
["HIG"]
["  7. CH-Classico","CH0002875208","Résidentiel","2023-04-28",{"v":13734,"d":"13,734.00"},"* ","2023-03-31",{"v":1014.93253,"d":"1,014.93"},{"v":0.051662324760926,"d":"5.17%"},{"v":0.0036539023677287,"d":"0.37%"},{"v":0.00018876909076632,"d":"0.0189%"}]
["IST"]
["  8. Immobilier Résidentiel Suisse","CH0245229122","Résidentiel","2023-04-28",136.98,null,"2023-03-31",{"v":297.0903,"d":"297.09"},{"v":0.015122557518105,"d":"1.51%"},{"v":0.0018284209756461,"d":"0.18%"},{"v":2.7650401371518E-5,"d":"0.0028%"}]
["  9. Immobilier Suisse Focus","CH0002598578","Résidentiel","2023-04-28",{"v":313276.73,"d":"313,276.73"},null,"2023-03-31",{"v":315.3144,"d":"315.31"},{"v":0.016050204770357,"d":"1.61%"},{"v":0.002102973168963,"d":"0.21%"},{"v":3.3753149988423E-5,"d":"0.0034%"}]
["Patrimonium"]
["  10. Immobilier résidentiel Suisse","CH0112589673","Résidentiel","2023-04-28",{"v":1848,"d":"1,848.00"},null,"2023-03-31",{"v":645.88991,"d":"645.89"},{"v":0.032877234007097,"d":"3.29%"},{"v":0.0027891429625691,"d":"0.28%"},{"v":9.1699305859632E-5,"d":"0.0092%"}]
["Pensimo"]
["  11. Casareal (Habitation)","CH0020488190","Résidentiel","2023-04-28",{"v":1381.4,"d":"1,381.40"},null,"2022-12-30",{"v":2232.62,"d":"2,232.62"},{"v":0.11364532724923,"d":"11.36%"},{"v":0.0021764364480557,"d":"0.22%"},{"v":0.00024734183237644,"d":"0.0247%"}]
["Prisma"]
["  12. Previous Responsible Residential Real Estate","CH0298011104","Résidentiel","2023-04-28",{"v":1119.63,"d":"1,119.63"},"* ","2023-03-31",{"v":110.01775902,"d":"110.02"},{"v":0.0056001488059118,"d":"0.56%"},{"v":0.00032163821061948,"d":"0.03%"},{"v":1.8012218411363E-6,"d":"0.0002%"}]
["Terra Helvetica"]
["  13. Résidentiel Suisse","CH0544073437","Résidentiel","2023-04-28",{"v":1073,"d":"1,073.00"},"* ","2023-03-31",{"v":123.272129,"d":"123.27"},{"v":0.0062748257387797,"d":"0.63%"},{"v":0.0037418147801684,"d":"0.37%"},{"v":2.3479235692347E-5,"d":"0.0023%"}]
["Turidomus"]
["  14. Casareal (Habitation)","CH0020488026","Résidentiel","2023-04-28",{"v":1687.7,"d":"1,687.70"},null,"2022-12-30",{"v":4541.13,"d":"4,541.13"},{"v":0.23115362441047,"d":"23.12%"},{"v":0.0021971496437054,"d":"0.22%"},{"v":0.00050787910351468,"d":"0.0508%"}]
["Zurich"]
["  15. Immobiliers – Habitat Suisse","CH0018192903","Résidentiel","2023-04-28",{"v":3325.4437,"d":"3,325.44"},null,"2023-03-31",{"v":2897.3330311,"d":"2,897.33"},{"v":0.14748070001584,"d":"14.75%"},{"v":0.0014554250079533,"d":"0.15%"},{"v":0.00021464709899351,"d":"0.0215%"}]
["  16. Immobiliers – Traditionnel Suisse","CH0023842187","Résidentiel","2023-04-28",{"v":3129.0581,"d":"3,129.06"},null,"2023-03-31",{"v":725.4404894,"d":"725.44"},{"v":0.036926535558091,"d":"3.69%"},{"v":0.0020117678637064,"d":"0.20%"},{"v":7.4287617553778E-5,"d":"0.0074%"}]
["Total",{"$nulls":6},{"$f":"SUM(H2:H30)","v":{"v":19645.50636652,"d":"19,645.51"}},{"$f":"SUM(I2:I30)","v":{"v":1,"d":"100.00%"}},null,{"$f":"SUM(K2:K30)","v":{"v":0.0023527558179628,"d":"0.2353%"}}]
[]
["* Cours non officiel."]

{"sheet":"KGAST Immo-Index Commercial","index":3,"n_rows":28,"n_cols":11,"rows_kept":28,"merged":[[0,3,0,5],[0,6,0,7]]}
["2023-04-28","ISIN","Classification","VNI",null,null,"Fortune nette",null,"Poids","Perf.","Contrib."]
["ASSETIMMO"]
["  1. Groupe d'investissement G","CH0010493499","Commercial","2023-04-28",450.61,null,"2023-03-31",{"v":785.873,"d":"785.87"},{"v":0.083429683944783,"d":"8.34%"},{"v":0.0024917128300963,"d":"0.25%"},{"v":0.0002078828138961,"d":"0.0208%"}]
["Avadis"]
["  2. Immobilier Suisse commerces","CH0141268083","Commercial","2023-04-28",{"v":138137.58,"d":"138,137.58"},null,"2023-03-31",{"v":907.4088,"d":"907.41"},{"v":0.096332141952599,"d":"9.63%"},{"v":0.0024062816432202,"d":"0.24%"},{"v":0.00023180226483262,"d":"0.0232%"}]
["CSF"]
["  3. Real Estate Switzerland Commercial","CH0113543620","Commercial","2023-04-28",{"v":1722.47,"d":"1,722.47"},null,"2023-03-31",{"v":1462.0355,"d":"1,462.04"},{"v":0.1552123048903,"d":"15.52%"},{"v":-0.0027731783286824,"d":"-0.28%"},{"v":-0.00043043140026662,"d":"-0.0430%"}]
["DAI"]
["  4. Immobilier commercial Suisse DAGSIS","CH0347818491","Commercial","2023-04-28",179.19,"* ","2023-03-31",{"v":243.543668,"d":"243.54"},{"v":0.025855031599245,"d":"2.59%"},{"v":0.0043719522448296,"d":"0.44%"},{"v":0.00011303696344046,"d":"0.0113%"}]
["Ecoreal"]
["  5. SUISSESELECT","CH0181111045","Commercial","2023-04-28",180.06,"* ","2023-03-31",{"v":532,"d":"532.00"},{"v":0.056478071976801,"d":"5.65%"},{"v":0.0032315578337421,"d":"0.32%"},{"v":0.00018251215593128,"d":"0.0183%"}]
["Patrimonium"]
["  6. Immobilier de la Santé Suisse","CH0282527719","Commercial","2023-04-28",{"v":1251.23,"d":"1,251.23"},null,"2023-03-31",{"v":320.941444,"d":"320.94"},{"v":0.034071717997313,"d":"3.41%"},{"v":0.0039234879727843,"d":"0.39%"},{"v":0.00013367997577456,"d":"0.0134%"}]
["Pensimo"]
["  7. Proreal (Commercial)","CH0020488224","Commercial","2023-04-28",{"v":1327.8,"d":"1,327.80"},null,"2022-12-30",514.51,{"v":0.054621302279669,"d":"5.46%"},{"v":0.0026429056860229,"d":"0.26%"},{"v":0.00014435895037291,"d":"0.0144%"}]
["Swiss Life"]
["  8. Immeubles commerciaux Suisse ESG","CH0136837587","Commercial","2023-04-28",172.89,null,"2023-03-31",{"v":1887.36,"d":"1,887.36"},{"v":0.20036551489875,"d":"20.04%"},{"v":-0.015657029483999,"d":"-1.57%"},{"v":-0.0031371287743465,"d":"-0.3137%"}]
["Tellco"]
["  9. Immobilier commercial Suisse","CH0598652672","Commercial","2023-04-28",{"v":116.8051,"d":"116.81"},null,"2023-03-31",{"v":32.524997,"d":"32.52"},{"v":0.0034529118827279,"d":"0.35%"},{"v":0.0045002743335585,"d":"0.45%"},{"v":1.5539050721879E-5,"d":"0.0016%"}]
["Turidomus"]
["  10. Proreal (Commercial)","CH0020488067","Commercial","2023-04-28",{"v":1238.3,"d":"1,238.30"},null,"2022-12-30",{"v":1304.05,"d":"1,304.05"},{"v":0.13844028150629,"d":"13.84%"},{"v":0.0027938616026237,"d":"0.28%"},{"v":0.00038678298675685,"d":"0.0387%"}]
["UBS 1"]
["  11. Immeubles commerciaux suisses","CH0100770533","Commercial","2023-04-28",{"v":1721.22,"d":"1,721.22"},null,"2023-03-31",{"v":677.3490403,"d":"677.35"},{"v":0.071908586186994,"d":"7.19%"},{"v":0.002615437488714,"d":"0.26%"},{"v":0.00018807241207388,"d":"0.0188%"}]
["Zurich"]
["  12. Immobiliers – Commercial Suisse","CH0032598069","Commercial","2023-04-28",{"v":2048.3107,"d":"2,048.31"},null,"2023-03-31",{"v":751.9885574,"d":"751.99"},{"v":0.079832450884527,"d":"7.98%"},{"v":0.0019385646550518,"d":"0.19%"},{"v":0.0001547603676109,"d":"0.0155%"}]
["Total",{"$nulls":6},{"$f":"SUM(H2:H25)","v":{"v":9419.5850067,"d":"9,419.59"}},{"$f":"SUM(I2:I25)","v":{"v":1,"d":"100.00%"}},null,{"$f":"SUM(K2:K25)","v":{"v":-0.0018091322332016,"d":"-0.1809%"}}]
[]
["* Cours non officiel."]