{"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-06-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-06-30","ISIN","Kategoriserung","NAV",null,null,"Nettovermögen",null,"Gewicht","Perf.","Beitrag"]
[1291]
["  1. Immobilien Schweiz","CH0427260721","Gemischt","2021-06-30",{"v":114.9148,"d":"114.91"},null,"2021-05-31",650.37,{"v":0.012959921534764,"d":"1.30%"},{"v":0.015449815492938,"d":"1.54%"},{"v":0.00020022839651506,"d":"0.0200%"}]
["Adimora"]
["  2. Omega (Wohnimmobilien)","CH0149835834","Wohnen","2021-06-30",{"v":1328.15,"d":"1,328.15"},null,"2020-09-30",294.87,{"v":0.0058758738302135,"d":"0.59%"},{"v":0.0021882663648369,"d":"0.22%"},{"v":1.2857977066682E-5,"d":"0.0013%"}]
["ASSETIMMO"]
["  3. Anlagegruppe G","CH0010493499","Geschäft","2021-06-30",419.66,null,"2021-05-31",{"v":765.642,"d":"765.64"},{"v":0.015256946420837,"d":"1.53%"},{"v":-0.00088333062135337,"d":"-0.09%"},{"v":-1.3476927961873E-5,"d":"-0.0013%"}]
["  4. Anlagegruppe W","CH0010493457","Wohnen","2021-06-30",557.41,null,"2021-05-31",{"v":1673.697,"d":"1,673.70"},{"v":0.033351756374018,"d":"3.34%"},{"v":0.00038341553530041,"d":"0.04%"},{"v":1.2787581523353E-5,"d":"0.0013%"}]
["Avadis"]
["  5. Immobilien Schweiz Geschäft","CH0141268083","Geschäft","2021-06-30",{"v":128717.0349774,"d":"128,717.03"},null,"2021-05-31",{"v":845.407,"d":"845.41"},{"v":0.016846423397359,"d":"1.68%"},{"v":0.0025478375512229,"d":"0.25%"},{"v":4.2921950135592E-5,"d":"0.0043%"}]
["  6. Immobilien Schweiz Wohnen","CH0009359354","Wohnen","2021-06-30",{"v":152138.6052296,"d":"152,138.61"},null,"2021-05-31",{"v":2468.0373,"d":"2,468.04"},{"v":0.049180573754742,"d":"4.92%"},{"v":0.0067108616409985,"d":"0.67%"},{"v":0.000330044025893,"d":"0.0330%"}]
["CSA"]
["  7. Real Estate Switzerland","CH0013123002","Gemischt","2021-06-30",{"v":1955.42,"d":"1,955.42"},null,"2021-05-31",{"v":6069.6253,"d":"6,069.63"},{"v":0.12094940977201,"d":"12.09%"},{"v":0.0039533403158565,"d":"0.40%"},{"v":0.00047815417783072,"d":"0.0478%"}]
["  8. Real Estate Switzerland Commercial","CH0113543620","Geschäft","2021-06-30",{"v":1628.02,"d":"1,628.02"},null,"2021-05-31",{"v":1313.8455,"d":"1,313.85"},{"v":0.026180996338704,"d":"2.62%"},{"v":0.0031795718669509,"d":"0.32%"},{"v":8.324435940729E-5,"d":"0.0083%"}]
["  9. Real Estate Switzerland Residential","CH0025226090","Wohnen","2021-06-30",{"v":2026.29,"d":"2,026.29"},null,"2021-05-31",{"v":925.525,"d":"925.53"},{"v":0.018442934604091,"d":"1.84%"},{"v":0.0074278469684541,"d":"0.74%"},{"v":0.0001369912958884,"d":"0.0137%"}]
["DAI"]
["  10. Gewerbeimmobilien Schweiz DAGSIS","CH0347818491","Geschäft","2021-06-30",160.62,"* ","2021-05-31",{"v":190.9,"d":"190.90"},{"v":0.0038040638728516,"d":"0.38%"},{"v":0.028955797565663,"d":"2.90%"},{"v":0.00011014970342914,"d":"0.0110%"}]
["Ecoreal"]
["  11. Suissecore Plus","CH0108524155","Gemischt","2021-06-30",165.77,"* ","2021-03-31",{"v":1005,"d":"1,005.00"},{"v":0.020026632751262,"d":"2.00%"},{"v":0.0028433151845131,"d":"0.28%"},{"v":5.694202899633E-5,"d":"0.0057%"}]
["  12. Suisseselect","CH0181111045","Geschäft","2021-06-30",162.37,"* ","2021-03-31",{"v":466,"d":"466.00"},{"v":0.0092859809573015,"d":"0.93%"},{"v":0.0038330757341576,"d":"0.38%"},{"v":3.5593868275282E-5,"d":"0.0036%"}]
["Greenbrix"]
["  13. Housing","CH0224042157","Wohnen","2021-06-30",{"v":10678,"d":"10,678.00"},"* ","2021-05-31",{"v":308.525,"d":"308.53"},{"v":0.0061479769846597,"d":"0.61%"},{"v":0.0021586109807599,"d":"0.22%"},{"v":1.3271090628545E-5,"d":"0.0013%"}]
["Helvetia"]
["  14. Immobilien Romandie","CH0301200108","Gemischt","2021-06-30",{"v":1311.03,"d":"1,311.03"},null,"2021-05-31",{"v":334.5077,"d":"334.51"},{"v":0.0066657341894221,"d":"0.67%"},{"v":0.0026231263383298,"d":"0.26%"},{"v":1.7485062916579E-5,"d":"0.0017%"}]
["  15. Immobilien Schweiz","CH0188230780","Gemischt","2021-06-30",{"v":1364.55,"d":"1,364.55"},null,"2021-05-31",{"v":868.402,"d":"868.40"},{"v":0.017304644710907,"d":"1.73%"},{"v":0.0022328150362465,"d":"0.22%"},{"v":3.8638070907416E-5,"d":"0.0039%"}]
["HIG"]
["  16. CH-Classico","CH0002875208","Wohnen","2021-06-30",{"v":12910,"d":"12,910.00"},"* ","2021-03-31",{"v":781.032,"d":"781.03"},{"v":0.015563622916401,"d":"1.56%"},{"v":0.0038880248833593,"d":"0.39%"},{"v":6.051175317419E-5,"d":"0.0061%"}]
["IST"]
["  17. Immobilien Schweiz Fokus","CH0002598578","Wohnen","2021-06-30",{"v":285535.34,"d":"285,535.34"},null,"2021-05-31",{"v":287.3009,"d":"287.30"},{"v":0.0057250443914497,"d":"0.57%"},{"v":0.0027992371521233,"d":"0.28%"},{"v":1.6025756958101E-5,"d":"0.0016%"}]
["  18. Immobilien Schweiz Wohnen","CH0245229122","Wohnen","2021-06-30",127.29,null,"2021-05-31",{"v":247.2834,"d":"247.28"},{"v":0.0049276157584909,"d":"0.49%"},{"v":0.0029942478922072,"d":"0.30%"},{"v":1.4754503098468E-5,"d":"0.0015%"}]
["J. Safra Sarasin"]
["  19. Nachhaltig Immobilien Schweiz","CH0049550269","Gemischt","2021-06-30",{"v":1530.48,"d":"1,530.48"},"* ","2021-03-31",{"v":666.793004,"d":"666.79"},{"v":0.013287182698725,"d":"1.33%"},{"v":0.0022395976582448,"d":"0.22%"},{"v":2.9757943256735E-5,"d":"0.0030%"}]
["Patrimonium"]
["  20. Gesundheitsimmobilien Schweiz","CH0282527719","Geschäft","2021-06-30",{"v":1203.91,"d":"1,203.91"},"* ","2021-05-31",{"v":249.452825,"d":"249.45"},{"v":0.0049708458856117,"d":"0.50%"},{"v":0.0080212336623882,"d":"0.80%"},{"v":3.9872316348212E-5,"d":"0.0040%"}]
["  21. Wohnimmobilien Schweiz","CH0112589673","Wohnen","2021-06-30",{"v":1713.3,"d":"1,713.30"},"* ","2021-05-31",{"v":527.125152,"d":"527.13"},{"v":0.010504021724435,"d":"1.05%"},{"v":0.029200631949492,"d":"2.92%"},{"v":0.00030672407236469,"d":"0.0307%"}]
["Pensimo"]
["  22. Casareal (Wohnimmobilien)","CH0020488190","Wohnen","2021-06-30",{"v":1355.6,"d":"1,355.60"},null,"2020-12-31",{"v":1928.45,"d":"1,928.45"},{"v":0.038428218834996,"d":"3.84%"},{"v":0.002329106436467,"d":"0.23%"},{"v":8.9503411830551E-5,"d":"0.0090%"}]
["  23. Proreal (Geschäftsimmobilien)","CH0020488224","Geschäft","2021-06-30",{"v":1318.45,"d":"1,318.45"},null,"2020-12-31",511.96,{"v":0.010201825774464,"d":"1.02%"},{"v":0.0027760876178886,"d":"0.28%"},{"v":2.8321162212345E-5,"d":"0.0028%"}]
["SFP"]
["  24. Swiss Real Estate","CH0437532747","Gemischt","2021-06-30",{"v":1091.45,"d":"1,091.45"},null,"2021-05-31",{"v":219.217,"d":"219.22"},{"v":0.0043683366684909,"d":"0.44%"},{"v":0.002470700613542,"d":"0.25%"},{"v":1.0792852086999E-5,"d":"0.0011%"}]
["Swiss Life"]
["  25. Geschäftsimmobilien Schweiz","CH0136837587","Geschäft","2021-06-30",160.07,null,"2021-05-31",{"v":1502.462,"d":"1,502.46"},{"v":0.029939556912165,"d":"2.99%"},{"v":0.002442384769539,"d":"0.24%"},{"v":7.3123917809017E-5,"d":"0.0073%"}]
["  26. Immobilien Schweiz","CH0106150136","Gemischt","2021-06-30",182.56,null,"2021-05-31",{"v":3090.6221,"d":"3,090.62"},{"v":0.061586819671277,"d":"6.16%"},{"v":0.0026912725874664,"d":"0.27%"},{"v":0.00016574691953054,"d":"0.0166%"}]
["  27. Immobilien Schweiz Alter und Gesundheit","CH0385556482","Gemischt","2021-06-30",120.15,null,"2021-05-31",{"v":290.8939,"d":"290.89"},{"v":0.0057966420944102,"d":"0.58%"},{"v":0.002586782376502,"d":"0.26%"},{"v":1.499465161271E-5,"d":"0.0015%"}]
["Swiss Prime"]
["  28. Immobilien Schweiz","CH0263627355","Gemischt","2021-06-30",{"v":1213.36,"d":"1,213.36"},null,"2021-05-31",{"v":1925.6,"d":"1,925.60"},{"v":0.038371426891373,"d":"3.84%"},{"v":0.0028514517608746,"d":"0.29%"},{"v":0.00010941427277668,"d":"0.0109%"}]
["Swisscanto"]
["  29. Immobilien Responsible Schweiz","CH0002875893","Gemischt","2021-06-30",242.79,null,"2021-05-31",{"v":7485.3206,"d":"7,485.32"},{"v":0.14915996684742,"d":"14.92%"},{"v":0.0032644628099172,"d":"0.33%"},{"v":0.00048692716450188,"d":"0.0487%"}]
["Tellco"]
["  30. Immobilien Schweiz","CH0024559798","Gemischt","2021-06-30",{"v":181.0298,"d":"181.03"},null,"2021-05-31",{"v":1098.8882,"d":"1,098.89"},{"v":0.021897542702582,"d":"2.19%"},{"v":0.0031925086601161,"d":"0.32%"},{"v":6.9908094713256E-5,"d":"0.0070%"}]
["Turidomus"]
["  31. Casareal (Wohnimmobilien)","CH0020488026","Wohnen","2021-06-30",{"v":1602.95,"d":"1,602.95"},null,"2020-12-31",{"v":3725.29,"d":"3,725.29"},{"v":0.074233845494476,"d":"7.42%"},{"v":0.0023135844927309,"d":"0.23%"},{"v":0.0001717462737718,"d":"0.0172%"}]
["  32. Proreal (Geschäftsimmobilien)","CH0020488067","Geschäft","2021-06-30",{"v":1180.3,"d":"1,180.30"},null,"2020-12-31",{"v":1055.5,"d":"1,055.50"},{"v":0.021032946138265,"d":"2.10%"},{"v":0.0030167835139154,"d":"0.30%"},{"v":6.345184515899E-5,"d":"0.0063%"}]
["UBS 1"]
["  33. Immobilien Schweiz","CH0002875497","Gemischt","2021-06-30",{"v":1882.27,"d":"1,882.27"},null,"2021-05-31",{"v":2297.049706,"d":"2,297.05"},{"v":0.045773304351697,"d":"4.58%"},{"v":0.0030534920651839,"d":"0.31%"},{"v":0.00013976842163516,"d":"0.0140%"}]
["  34. Kommerzielle Immobilien Schweiz","CH0100770533","Geschäft","2021-06-30",{"v":1670.1,"d":"1,670.10"},null,"2021-05-31",{"v":690.418666,"d":"690.42"},{"v":0.013757971212535,"d":"1.38%"},{"v":0.0013790622376784,"d":"0.14%"},{"v":1.8973098566274E-5,"d":"0.0019%"}]
["Zürich"]
["  35. Immobilien – Geschäft Schweiz","CH0032598069","Geschäft","2021-06-30",{"v":1900.8523,"d":"1,900.85"},null,"2021-05-31",{"v":688.1791926,"d":"688.18"},{"v":0.013713345231105,"d":"1.37%"},{"v":0.017112141286944,"d":"1.71%"},{"v":0.0002346647011113,"d":"0.0235%"}]
["  36. Immobilien – Traditionell Schweiz","CH0023842187","Wohnen","2021-06-30",{"v":2817.3321,"d":"2,817.33"},null,"2021-05-31",{"v":666.8073906,"d":"666.81"},{"v":0.013287469380471,"d":"1.33%"},{"v":0.010030749785398,"d":"1.00%"},{"v":0.00013328328063664,"d":"0.0133%"}]
["  37. Immobilien – Wohnen Schweiz","CH0018192903","Wohnen","2021-06-30",{"v":3045.7086,"d":"3,045.71"},null,"2021-05-31",{"v":2067.174364,"d":"2,067.17"},{"v":0.041192578926021,"d":"4.12%"},{"v":0.012003557037754,"d":"1.20%"},{"v":0.00049445747067069,"d":"0.0494%"}]
["Gesamtsumme",{"$nulls":6},{"$f":"SUM(H2:H60)","v":{"v":50183.1742002,"d":"50,183.17"}},{"$f":"SUM(I2:I60)","v":{"v":1,"d":"100.00%"}},null,{"$f":"SUM(K2:K60)","v":{"v":0.0043285565452767,"d":"0.4329%"}}]
[]
["* 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-06-30","ISIN","Kategoriserung","NAV",null,null,"Nettovermögen",null,"Gewicht","Perf.","Beitrag"]
[1291]
["  1. Immobilien Schweiz","CH0427260721","Gemischt","2021-06-30",{"v":114.9148,"d":"114.91"},null,"2021-05-31",650.37,{"v":0.025012028258122,"d":"2.50%"},{"v":0.015449815492938,"d":"1.54%"},{"v":0.00038643122169214,"d":"0.0386%"}]
["CSA"]
["  2. Real Estate Switzerland","CH0013123002","Gemischt","2021-06-30",{"v":1955.42,"d":"1,955.42"},null,"2021-05-31",{"v":6069.6253,"d":"6,069.63"},{"v":0.23342657182806,"d":"23.34%"},{"v":0.0039533403158565,"d":"0.40%"},{"v":0.00092281467720003,"d":"0.0923%"}]
["Ecoreal"]
["  3. Suissecore Plus","CH0108524155","Gemischt","2021-06-30",165.77,"* ","2021-03-31",{"v":1005,"d":"1,005.00"},{"v":0.038650442670192,"d":"3.87%"},{"v":0.0028433151845131,"d":"0.28%"},{"v":0.00010989539053231,"d":"0.0110%"}]
["Helvetia"]
["  4. Immobilien Romandie","CH0301200108","Gemischt","2021-06-30",{"v":1311.03,"d":"1,311.03"},null,"2021-05-31",{"v":334.5077,"d":"334.51"},{"v":0.012864547941879,"d":"1.29%"},{"v":0.0026231263383298,"d":"0.26%"},{"v":3.3745334537048E-5,"d":"0.0034%"}]
["  5. Immobilien Schweiz","CH0188230780","Gemischt","2021-06-30",{"v":1364.55,"d":"1,364.55"},null,"2021-05-31",{"v":868.402,"d":"868.40"},{"v":0.033397136035503,"d":"3.34%"},{"v":0.0022328150362465,"d":"0.22%"},{"v":7.4569627507641E-5,"d":"0.0075%"}]
["J. Safra Sarasin"]
["  6. Nachhaltig Immobilien Schweiz","CH0049550269","Gemischt","2021-06-30",{"v":1530.48,"d":"1,530.48"},"* ","2021-03-31",{"v":666.793004,"d":"666.79"},{"v":0.025643626640783,"d":"2.56%"},{"v":0.0022395976582448,"d":"0.22%"},{"v":5.7431406173602E-5,"d":"0.0057%"}]
["SFP"]
["  7. Swiss Real Estate","CH0437532747","Gemischt","2021-06-30",{"v":1091.45,"d":"1,091.45"},null,"2021-05-31",{"v":219.217,"d":"219.22"},{"v":0.0084306806873946,"d":"0.84%"},{"v":0.002470700613542,"d":"0.25%"},{"v":2.0829687946923E-5,"d":"0.0021%"}]
["Swiss Life"]
["  8. Immobilien Schweiz","CH0106150136","Gemischt","2021-06-30",182.56,null,"2021-05-31",{"v":3090.6221,"d":"3,090.62"},{"v":0.11885961422018,"d":"11.89%"},{"v":0.0026912725874664,"d":"0.27%"},{"v":0.0003198836215076,"d":"0.0320%"}]
["  9. Immobilien Schweiz Alter und Gesundheit","CH0385556482","Gemischt","2021-06-30",120.15,null,"2021-05-31",{"v":290.8939,"d":"290.89"},{"v":0.011187241796078,"d":"1.12%"},{"v":0.002586782376502,"d":"0.26%"},{"v":2.8938959919762E-5,"d":"0.0029%"}]
["Swiss Prime"]
["  10. Immobilien Schweiz","CH0263627355","Gemischt","2021-06-30",{"v":1213.36,"d":"1,213.36"},null,"2021-05-31",{"v":1925.6,"d":"1,925.60"},{"v":0.074055017319127,"d":"7.41%"},{"v":0.0028514517608746,"d":"0.29%"},{"v":0.00021116430953623,"d":"0.0211%"}]
["Swisscanto"]
["  11. Immobilien Responsible Schweiz","CH0002875893","Gemischt","2021-06-30",242.79,null,"2021-05-31",{"v":7485.3206,"d":"7,485.32"},{"v":0.28787159673464,"d":"28.79%"},{"v":0.0032644628099172,"d":"0.33%"},{"v":0.00093974612157171,"d":"0.0940%"}]
["Tellco"]
["  12. Immobilien Schweiz","CH0024559798","Gemischt","2021-06-30",{"v":181.0298,"d":"181.03"},null,"2021-05-31",{"v":1098.8882,"d":"1,098.89"},{"v":0.042261209328409,"d":"4.23%"},{"v":0.0031925086601161,"d":"0.32%"},{"v":0.00013491927676793,"d":"0.0135%"}]
["UBS 1"]
["  13. Immobilien Schweiz","CH0002875497","Gemischt","2021-06-30",{"v":1882.27,"d":"1,882.27"},null,"2021-05-31",{"v":2297.049706,"d":"2,297.05"},{"v":0.088340286539637,"d":"8.83%"},{"v":0.0030534920651839,"d":"0.31%"},{"v":0.00026974636398485,"d":"0.0270%"}]
["Gesamtsumme",{"$nulls":6},{"$f":"SUM(H2:H25)","v":{"v":26002.28951,"d":"26,002.29"}},{"$f":"SUM(I2:I25)","v":{"v":1,"d":"100.00%"}},null,{"$f":"SUM(K2:K25)","v":{"v":0.0035101159988778,"d":"0.3510%"}}]
[]
["* 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-06-30","ISIN","Kategoriserung","NAV",null,null,"Nettovermögen",null,"Gewicht","Perf.","Beitrag"]
["Adimora"]
["  1. Omega (Wohnimmobilien)","CH0149835834","Wohnen","2021-06-30",{"v":1328.15,"d":"1,328.15"},null,"2020-09-30",294.87,{"v":0.018543979684296,"d":"1.85%"},{"v":0.0021882663648369,"d":"0.22%"},{"v":4.0579167013365E-5,"d":"0.0041%"}]
["ASSETIMMO"]
["  2. Anlagegruppe W","CH0010493457","Wohnen","2021-06-30",557.41,null,"2021-05-31",{"v":1673.697,"d":"1,673.70"},{"v":0.10525656447135,"d":"10.53%"},{"v":0.00038341553530041,"d":"0.04%"},{"v":4.0357002010666E-5,"d":"0.0040%"}]
["Avadis"]
["  3. Immobilien Schweiz Wohnen","CH0009359354","Wohnen","2021-06-30",{"v":152138.6052296,"d":"152,138.61"},null,"2021-05-31",{"v":2468.0373,"d":"2,468.04"},{"v":0.15521156289648,"d":"15.52%"},{"v":0.0067108616409985,"d":"0.67%"},{"v":0.0010416033236814,"d":"0.1042%"}]
["CSA"]
["  4. Real Estate Switzerland Residential","CH0025226090","Wohnen","2021-06-30",{"v":2026.29,"d":"2,026.29"},null,"2021-05-31",{"v":925.525,"d":"925.53"},{"v":0.058205028647568,"d":"5.82%"},{"v":0.0074278469684541,"d":"0.74%"},{"v":0.00043233804558862,"d":"0.0432%"}]
["Greenbrix"]
["  5. Housing","CH0224042157","Wohnen","2021-06-30",{"v":10678,"d":"10,678.00"},"* ","2021-05-31",{"v":308.525,"d":"308.53"},{"v":0.019402724360218,"d":"1.94%"},{"v":0.0021586109807599,"d":"0.22%"},{"v":4.1882933860624E-5,"d":"0.0042%"}]
["HIG"]
["  6. CH-Classico","CH0002875208","Wohnen","2021-06-30",{"v":12910,"d":"12,910.00"},"* ","2021-03-31",{"v":781.032,"d":"781.03"},{"v":0.049118057248229,"d":"4.91%"},{"v":0.0038880248833593,"d":"0.39%"},{"v":0.00019097222880338,"d":"0.0191%"}]
["IST"]
["  7. Immobilien Schweiz Fokus","CH0002598578","Wohnen","2021-06-30",{"v":285535.34,"d":"285,535.34"},null,"2021-05-31",{"v":287.3009,"d":"287.30"},{"v":0.018067969114797,"d":"1.81%"},{"v":0.0027992371521233,"d":"0.28%"},{"v":5.0576530409554E-5,"d":"0.0051%"}]
["  8. Immobilien Schweiz Wohnen","CH0245229122","Wohnen","2021-06-30",127.29,null,"2021-05-31",{"v":247.2834,"d":"247.28"},{"v":0.01555132209402,"d":"1.56%"},{"v":0.0029942478922072,"d":"0.30%"},{"v":4.6564513401054E-5,"d":"0.0047%"}]
["Patrimonium"]
["  9. Wohnimmobilien Schweiz","CH0112589673","Wohnen","2021-06-30",{"v":1713.3,"d":"1,713.30"},"* ","2021-05-31",{"v":527.125152,"d":"527.13"},{"v":0.033150195373451,"d":"3.32%"},{"v":0.029200631949492,"d":"2.92%"},{"v":0.00096800665415391,"d":"0.0968%"}]
["Pensimo"]
["  10. Casareal (Wohnimmobilien)","CH0020488190","Wohnen","2021-06-30",{"v":1355.6,"d":"1,355.60"},null,"2020-12-31",{"v":1928.45,"d":"1,928.45"},{"v":0.12127763971303,"d":"12.13%"},{"v":0.002329106436467,"d":"0.23%"},{"v":0.00028246853125515,"d":"0.0282%"}]
["Turidomus"]
["  11. Casareal (Wohnimmobilien)","CH0020488026","Wohnen","2021-06-30",{"v":1602.95,"d":"1,602.95"},null,"2020-12-31",{"v":3725.29,"d":"3,725.29"},{"v":0.23427850265579,"d":"23.43%"},{"v":0.0023135844927309,"d":"0.23%"},{"v":0.00054202311072465,"d":"0.0542%"}]
["Zürich"]
["  12. Immobilien – Traditionell Schweiz","CH0023842187","Wohnen","2021-06-30",{"v":2817.3321,"d":"2,817.33"},null,"2021-05-31",{"v":666.8073906,"d":"666.81"},{"v":0.041934624426442,"d":"4.19%"},{"v":0.010030749785398,"d":"1.00%"},{"v":0.00042063572496629,"d":"0.0421%"}]
["  13. Immobilien – Wohnen Schweiz","CH0018192903","Wohnen","2021-06-30",{"v":3045.7086,"d":"3,045.71"},null,"2021-05-31",{"v":2067.174364,"d":"2,067.17"},{"v":0.13000182931432,"d":"13.00%"},{"v":0.012003557037754,"d":"1.20%"},{"v":0.0015604843731869,"d":"0.1560%"}]
["Gesamtsumme",{"$nulls":6},{"$f":"SUM(H2:H25)","v":{"v":15901.1175066,"d":"15,901.12"}},{"$f":"SUM(I2:I25)","v":{"v":1,"d":"100.00%"}},null,{"$f":"SUM(K2:K25)","v":{"v":0.0056584921390556,"d":"0.5658%"}}]
[]
["* 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-06-30","ISIN","Kategoriserung","NAV",null,null,"Nettovermögen",null,"Gewicht","Perf.","Beitrag"]
["ASSETIMMO"]
["  1. Anlagegruppe G","CH0010493499","Geschäft","2021-06-30",419.66,null,"2021-05-31",{"v":765.642,"d":"765.64"},{"v":0.092471440684532,"d":"9.25%"},{"v":-0.00088333062135337,"d":"-0.09%"},{"v":-8.1682855157309E-5,"d":"-0.0082%"}]
["Avadis"]
["  2. Immobilien Schweiz Geschäft","CH0141268083","Geschäft","2021-06-30",{"v":128717.0349774,"d":"128,717.03"},null,"2021-05-31",{"v":845.407,"d":"845.41"},{"v":0.10210516567115,"d":"10.21%"},{"v":0.0025478375512229,"d":"0.25%"},{"v":0.00026014737527078,"d":"0.0260%"}]
["CSA"]
["  3. Real Estate Switzerland Commercial","CH0113543620","Geschäft","2021-06-30",{"v":1628.02,"d":"1,628.02"},null,"2021-05-31",{"v":1313.8455,"d":"1,313.85"},{"v":0.1586814545465,"d":"15.87%"},{"v":0.0031795718669509,"d":"0.32%"},{"v":0.0005045390886829,"d":"0.0505%"}]
["DAI"]
["  4. Gewerbeimmobilien Schweiz DAGSIS","CH0347818491","Geschäft","2021-06-30",160.62,"* ","2021-05-31",{"v":190.9,"d":"190.90"},{"v":0.023056203848113,"d":"2.31%"},{"v":0.028955797565663,"d":"2.90%"},{"v":0.00066761077125863,"d":"0.0668%"}]
["Ecoreal"]
["  5. Suisseselect","CH0181111045","Geschäft","2021-06-30",162.37,"* ","2021-03-31",{"v":466,"d":"466.00"},{"v":0.056281775763336,"d":"5.63%"},{"v":0.0038330757341576,"d":"0.38%"},{"v":0.00021573230895374,"d":"0.0216%"}]
["Patrimonium"]
["  6. Gesundheitsimmobilien Schweiz","CH0282527719","Geschäft","2021-06-30",{"v":1203.91,"d":"1,203.91"},"* ","2021-05-31",{"v":249.452825,"d":"249.45"},{"v":0.030127999914551,"d":"3.01%"},{"v":0.0080212336623882,"d":"0.80%"},{"v":0.00024166372709502,"d":"0.0242%"}]
["Pensimo"]
["  7. Proreal (Geschäftsimmobilien)","CH0020488224","Geschäft","2021-06-30",{"v":1318.45,"d":"1,318.45"},null,"2020-12-31",511.96,{"v":0.061832656480252,"d":"6.18%"},{"v":0.0027760876178886,"d":"0.28%"},{"v":0.00017165287203599,"d":"0.0172%"}]
["Swiss Life"]
["  8. Geschäftsimmobilien Schweiz","CH0136837587","Geschäft","2021-06-30",160.07,null,"2021-05-31",{"v":1502.462,"d":"1,502.46"},{"v":0.18146186561574,"d":"18.15%"},{"v":0.002442384769539,"d":"0.24%"},{"v":0.000443199696832,"d":"0.0443%"}]
["Turidomus"]
["  9. Proreal (Geschäftsimmobilien)","CH0020488067","Geschäft","2021-06-30",{"v":1180.3,"d":"1,180.30"},null,"2020-12-31",{"v":1055.5,"d":"1,055.50"},{"v":0.12747942986738,"d":"12.75%"},{"v":0.0030167835139154,"d":"0.30%"},{"v":0.00038457784238726,"d":"0.0385%"}]
["UBS 1"]
["  10. Kommerzielle Immobilien Schweiz","CH0100770533","Geschäft","2021-06-30",{"v":1670.1,"d":"1,670.10"},null,"2021-05-31",{"v":690.418666,"d":"690.42"},{"v":0.083386241507797,"d":"8.34%"},{"v":0.0013790622376784,"d":"0.14%"},{"v":0.00011499481680533,"d":"0.0115%"}]
["Zürich"]
["  11. Immobilien – Geschäft Schweiz","CH0032598069","Geschäft","2021-06-30",{"v":1900.8523,"d":"1,900.85"},null,"2021-05-31",{"v":688.1791926,"d":"688.18"},{"v":0.083115766100658,"d":"8.31%"},{"v":0.017112141286944,"d":"1.71%"},{"v":0.0014222887326871,"d":"0.1422%"}]
["Gesamtsumme",{"$nulls":6},{"$f":"SUM(H2:H23)","v":{"v":8279.7671836,"d":"8,279.77"}},{"$f":"SUM(I2:I23)","v":{"v":1,"d":"100.00%"}},null,{"$f":"SUM(K2:K23)","v":{"v":0.0043447243768514,"d":"0.4345%"}}]
[]
["* Kein offizieller Handelskurs."]