{"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-06-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-06-30","ISIN","Kategoriserung","NAV",null,null,"Nettovermögen",null,"Gewicht","Perf.","Beitrag"]
["Adimora"]
["  1. Omega (Wohnimmobilien)","CH0149835834","Wohnen","2020-06-30",{"v":1257.75,"d":"1,257.75"},null,"2019-09-30",{"v":248.5,"d":"248.50"},{"v":0.005362755662128081,"d":"0.54%"},{"v":0.00199163513244383,"d":"0.20%"},{"v":1.068065258340636E-5,"d":"0.0011%"}]
["ASSETIMMO"]
["  2. Anlagegruppe G","CH0010493499","Geschäft","2020-06-30",417.89,null,"2020-05-29",{"v":750.194,"d":"750.19"},{"v":0.0161895658800584,"d":"1.62%"},{"v":0.00432930661266684,"d":"0.43%"},{"v":7.008959462074229E-5,"d":"0.0070%"}]
["  3. Anlagegruppe W","CH0010493457","Wohnen","2020-06-30",548.68,null,"2020-05-29",{"v":1625.55,"d":"1,625.55"},{"v":0.03508019101236338,"d":"3.51%"},{"v":0.00253388854434289,"d":"0.25%"},{"v":8.8889294139588e-05,"d":"0.0089%"}]
["Avadis"]
["  4. Immobilien Schweiz Geschäft","CH0141268083","Geschäft","2020-06-30",{"v":127816.93,"d":"127,816.93"},null,"2020-05-29",832.79,{"v":0.01797202932741909,"d":"1.80%"},{"v":0.0028343185646964,"d":"0.28%"},{"v":5.093845636797208E-5,"d":"0.0051%"}]
["  5. Immobilien Schweiz Wohnen","CH0009359354","Wohnen","2020-06-30",{"v":148000.41,"d":"148,000.41"},null,"2020-05-29",{"v":2459.6758,"d":"2,459.68"},{"v":0.05308104757927331,"d":"5.31%"},{"v":0.00273800920063771,"d":"0.27%"},{"v":0.0001453363966515384,"d":"0.0145%"}]
["CSA"]
["  6. Real Estate Switzerland","CH0013123002","Gemischt","2020-06-30",{"v":1932.29,"d":"1,932.29"},null,"2020-05-29",{"v":5892.6711,"d":"5,892.67"},{"v":0.1271668221592898,"d":"12.72%"},{"v":0.00993581702625868,"d":"0.99%"},{"v":0.001263506276785481,"d":"0.1264%"}]
["  7. Real Estate Switzerland Commercial","CH0113543620","Geschäft","2020-06-30",{"v":1565.24,"d":"1,565.24"},null,"2020-05-29",{"v":1318.4857,"d":"1,318.49"},{"v":0.02845358814128735,"d":"2.85%"},{"v":0.00443423408392318,"d":"0.44%"},{"v":0.0001261698703460088,"d":"0.0126%"}]
["  8. Real Estate Switzerland Residential","CH0025226090","Wohnen","2020-06-30",{"v":1907.17,"d":"1,907.17"},null,"2020-05-29",{"v":854.9003,"d":"854.90"},{"v":0.01844918078221326,"d":"1.84%"},{"v":0.00701202287355662,"d":"0.70%"},{"v":0.0001293660776432606,"d":"0.0129%"}]
["DAI"]
["  9. Gewerbeimmobilien Schweiz DAGSIS","CH0347818491","Geschäft","2020-06-30",{"v":147.1,"d":"147.10"},null,"2020-05-29",{"v":135.72166,"d":"135.72"},{"v":0.002928942054882987,"d":"0.29%"},{"v":0.0232331663884251,"d":"2.32%"},{"v":6.804859810315217E-5,"d":"0.0068%"}]
["Ecoreal"]
["  10. Suissecore Plus","CH0108524155","Gemischt","2020-06-30",160.07,null,"2020-03-31",{"v":904,"d":"904.00"},{"v":0.01950877713707761,"d":"1.95%"},{"v":0.00269356051115022,"d":"0.27%"},{"v":5.254807171726248E-5,"d":"0.0053%"}]
["  11. Suisseselect","CH0181111045","Geschäft","2020-06-30",155.86,null,"2020-03-31",{"v":427,"d":"427.00"},{"v":0.009214875926473604,"d":"0.92%"},{"v":0.00405849384783874,"d":"0.41%"},{"v":3.739851725619043E-5,"d":"0.0037%"}]
["Greenbrix"]
["  12. Greenbrix Housing","CH0224042157","Wohnen","2020-06-30",{"v":10653,"d":"10,653.00"},"* ","2020-05-29",{"v":269.585734,"d":"269.59"},{"v":0.005817796464537041,"d":"0.58%"},{"v":0.002729668674698704,"d":"0.27%"},{"v":1.588065676501963E-5,"d":"0.0016%"}]
["Helvetia"]
["  13. Immobilien Romandie","CH0301200108","Gemischt","2020-06-30",{"v":1265.35,"d":"1,265.35"},null,"2020-05-29",{"v":277.0307,"d":"277.03"},{"v":0.005978462595606865,"d":"0.60%"},{"v":-0.000126431241159741,"d":"-0.01%"},{"v":-7.558644461896626E-7,"d":"-0.0001%"}]
["  14. Immobilien Schweiz","CH0188230780","Gemischt","2020-06-30",{"v":1315.71,"d":"1,315.71"},null,"2020-05-29",{"v":816.9554,"d":"816.96"},{"v":0.01763031065213727,"d":"1.76%"},{"v":0.00295005488474209,"d":"0.30%"},{"v":5.201038405885806E-5,"d":"0.0052%"}]
["HIG"]
["  15. CH-Classico","CH0002875208","Wohnen","2020-06-30",{"v":12804,"d":"12,804.00"},"* ","2020-03-31",{"v":746.125,"d":"746.13"},{"v":0.01610175480243587,"d":"1.61%"},{"v":0.00392033871726527,"d":"0.39%"},{"v":6.312433276790134E-5,"d":"0.0063%"}]
["IST"]
["  16. Immobilien Schweiz Fokus","CH0002598578","Wohnen","2020-06-30",{"v":275097.96,"d":"275,097.96"},null,"2020-05-29",{"v":276.6263,"d":"276.63"},{"v":0.005969735439108818,"d":"0.60%"},{"v":0.00342527648838975,"d":"0.34%"},{"v":2.04479944414865E-5,"d":"0.0020%"}]
["  17. Immobilien Schweiz Wohnen","CH0245229122","Wohnen","2020-06-30",123.06,null,"2020-05-29",{"v":224.3589,"d":"224.36"},{"v":0.004841778516393674,"d":"0.48%"},{"v":0.0027705345501956,"d":"0.28%"},{"v":1.341431466406347E-5,"d":"0.0013%"}]
["J. Safra Sarasin"]
["  18. Nachhaltig Immobilien Schweiz","CH0049550269","Gemischt","2020-06-30",{"v":1476.38,"d":"1,476.38"},"* ","2020-05-29",{"v":646.2315,"d":"646.23"},{"v":0.01394600255803027,"d":"1.39%"},{"v":0.00239671385409257,"d":"0.24%"},{"v":3.342457754004158E-5,"d":"0.0033%"}]
["Patrimonium"]
["  19. Gesundheitsimmobilien Schweiz","CH0282527719","Geschäft","2020-06-30",{"v":1183.89,"d":"1,183.89"},null,"2020-05-29",{"v":195.915408,"d":"195.92"},{"v":0.004227953575654459,"d":"0.42%"},{"v":0.04025873436537597,"d":"4.03%"},{"v":0.0001702120599114144,"d":"0.0170%"}]
["  20. Wohnimmobilien Schweiz","CH0112589673","Wohnen","2020-06-30",{"v":1622.76,"d":"1,622.76"},null,"2020-05-29",{"v":474.786306,"d":"474.79"},{"v":0.01024612857465745,"d":"1.02%"},{"v":0.01827263371903309,"d":"1.83%"},{"v":0.0001872237544828342,"d":"0.0187%"}]
["Pensimo"]
["  21. Casareal (Wohnimmobilien)","CH0020488190","Wohnen","2020-06-30",{"v":1317,"d":"1,317.00"},null,"2019-12-31",{"v":1844.89,"d":"1,844.89"},{"v":0.03981365912878662,"d":"3.98%"},{"v":0.00266463646745341,"d":"0.27%"},{"v":0.0001060889280173242,"d":"0.0106%"}]
["  22. Proreal (Geschäftsimmobilien)","CH0020488224","Geschäft","2020-06-30",{"v":1316.55,"d":"1,316.55"},null,"2019-12-31",511.63,{"v":0.01104123412239272,"d":"1.10%"},{"v":0.00289468672633775,"d":"0.29%"},{"v":3.196091385647763E-5,"d":"0.0032%"}]
["Swiss Life"]
["  23. Geschäftsimmobilien Schweiz","CH0136837587","Geschäft","2020-06-30",152.49,null,"2020-05-29",{"v":1240.5012,"d":"1,240.50"},{"v":0.02677064319588201,"d":"2.68%"},{"v":0.00197122018529483,"d":"0.20%"},{"v":5.27708322410483E-5,"d":"0.0053%"}]
["  24. Immobilien Schweiz","CH0106150136","Gemischt","2020-06-30",173.49,null,"2020-05-29",{"v":2651.7962,"d":"2,651.80"},{"v":0.05722710296321823,"d":"5.72%"},{"v":0.00265849852626721,"d":"0.27%"},{"v":0.0001521381688902576,"d":"0.0152%"}]
["  25. Immobilien Schweiz Alter und Gesundheit","CH0385556482","Gemischt","2020-06-30",112.95,null,"2020-05-29",{"v":235.7072,"d":"235.71"},{"v":0.005086680569031614,"d":"0.51%"},{"v":0.00248513357592972,"d":"0.25%"},{"v":1.264108067212976E-5,"d":"0.0013%"}]
["Swiss Prime"]
["  26. SPA Immobilien Schweiz","CH0263627355","Gemischt","2020-06-30",{"v":1162.82,"d":"1,162.82"},null,"2020-05-29",{"v":1622.9,"d":"1,622.90"},{"v":0.03502300267230448,"d":"3.50%"},{"v":0.00262983177699017,"d":"0.26%"},{"v":9.210460535323797E-5,"d":"0.0092%"}]
["Swisscanto"]
["  27. Immobilien Schweiz","CH0002875893","Gemischt","2020-06-30",232.35,null,"2020-05-29",{"v":7207.323417,"d":"7,207.32"},{"v":0.155537683956962,"d":"15.55%"},{"v":-0.00343126742440492,"d":"-0.34%"},{"v":-0.0005336913882289115,"d":"-0.0534%"}]
["Tellco"]
["  28. Immobilien Schweiz","CH0024559798","Gemischt","2020-06-30",{"v":175.276,"d":"175.28"},null,"2020-05-29",{"v":1024.4958,"d":"1,024.50"},{"v":0.022109137433708,"d":"2.21%"},{"v":0.00635300669749883,"d":"0.64%"},{"v":0.000140459498192269,"d":"0.0140%"}]
["Turidomus"]
["  29. Casareal (Wohnimmobilien)","CH0020488026","Wohnen","2020-06-30",{"v":1537.75,"d":"1,537.75"},null,"2020-03-31",{"v":3475.76,"d":"3,475.76"},{"v":0.07500865843138149,"d":"7.50%"},{"v":0.00237924516002863,"d":"0.24%"},{"v":0.0001784639875331051,"d":"0.0178%"}]
["  30. Proreal (Geschäftsimmobilien)","CH0020488067","Geschäft","2020-06-30",{"v":1149.8,"d":"1,149.80"},null,"2019-12-31",{"v":1028.71,"d":"1,028.71"},{"v":0.02220008200075565,"d":"2.22%"},{"v":0.0030970556161396,"d":"0.31%"},{"v":6.875488863919993E-5,"d":"0.0069%"}]
["UBS 1"]
["  31. Immobilien Schweiz","CH0002875497","Gemischt","2020-06-30",{"v":1830.2,"d":"1,830.20"},null,"2020-05-29",{"v":2236.53879,"d":"2,236.54"},{"v":0.04826563806696816,"d":"4.83%"},{"v":0.00254168583886605,"d":"0.25%"},{"v":0.0001226760887786471,"d":"0.0123%"}]
["  32. Kommerzielle Immobilien Schweiz","CH0100770533","Geschäft","2020-06-30",{"v":1652.16,"d":"1,652.16"},null,"2020-05-29",{"v":687.900666,"d":"687.90"},{"v":0.01484524423168281,"d":"1.48%"},{"v":0.00157617788986153,"d":"0.16%"},{"v":2.339874572757286E-5,"d":"0.0023%"}]
["Zürich"]
["  33. Immobilien – Geschäft Schweiz","CH0032598069","Geschäft","2020-06-30",{"v":1818.0272,"d":"1,818.03"},null,"2020-05-29",{"v":614.8378714,"d":"614.84"},{"v":0.01326851217763029,"d":"1.33%"},{"v":-0.000403021794736835,"d":"-0.04%"},{"v":-5.347499591316111E-6,"d":"-0.0005%"}]
["  34. Immobilien – Traditionell Schweiz","CH0023842187","Wohnen","2020-06-30",{"v":2602.6453,"d":"2,602.65"},null,"2020-05-29",{"v":627.425325,"d":"627.43"},{"v":0.01354015579157465,"d":"1.35%"},{"v":0.00253757851905911,"d":"0.25%"},{"v":3.435920848141365E-5,"d":"0.0034%"}]
["  35. Immobilien – Wohnen Schweiz","CH0018192903","Wohnen","2020-06-30",{"v":2852.9856,"d":"2,852.99"},null,"2020-05-29",{"v":1950.5968505,"d":"1,950.60"},{"v":0.04209486641669247,"d":"4.21%"},{"v":0.004622413242687529,"d":"0.46%"},{"v":0.0001945798679736818,"d":"0.0195%"}]
["Gesamtsumme",{"$nulls":6},{"$f":"SUM(H2:H56)","v":{"v":46338.1171279,"d":"46,338.12"}},{"$f":"SUM(I2:I56)","v":{"v":0.9999999999999997,"d":"100.00%"}},null,{"$f":"SUM(K2:K56)","v":{"v":0.003269311942936169,"d":"0.3269%"}}]
[]
["* 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-06-30","ISIN","Kategoriserung","NAV",null,null,"Nettovermögen",null,"Gewicht","Perf.","Beitrag"]
["CSA"]
["  1. Real Estate Switzerland","CH0013123002","Gemischt","2020-06-30",{"v":1932.29,"d":"1,932.29"},null,"2020-05-29",{"v":5892.6711,"d":"5,892.67"},{"v":0.2505850815600417,"d":"25.06%"},{"v":0.00993581702625868,"d":"0.99%"},{"v":0.002489767519890683,"d":"0.2490%"}]
["Ecoreal"]
["  2. Suissecore Plus","CH0108524155","Gemischt","2020-06-30",160.07,null,"2020-03-31",{"v":904,"d":"904.00"},{"v":0.03844248387293799,"d":"3.84%"},{"v":0.00269356051115022,"d":"0.27%"},{"v":0.0001035471565106749,"d":"0.0104%"}]
["Helvetia"]
["  3. Immobilien Romandie","CH0301200108","Gemischt","2020-06-30",{"v":1265.35,"d":"1,265.35"},null,"2020-05-29",{"v":277.0307,"d":"277.03"},{"v":0.01178069493037469,"d":"1.18%"},{"v":-0.000126431241159741,"d":"-0.01%"},{"v":-1.489447881771541E-6,"d":"-0.0001%"}]
["  4. Immobilien Schweiz","CH0188230780","Gemischt","2020-06-30",{"v":1315.71,"d":"1,315.71"},null,"2020-05-29",{"v":816.9554,"d":"816.96"},{"v":0.0347409234396124,"d":"3.47%"},{"v":0.00295005488474209,"d":"0.30%"},{"v":0.0001024876308934795,"d":"0.0102%"}]
["J. Safra Sarasin"]
["  5. Nachhaltig Immobilien Schweiz","CH0049550269","Gemischt","2020-06-30",{"v":1476.38,"d":"1,476.38"},"* ","2020-05-29",{"v":646.2315,"d":"646.23"},{"v":0.02748091152315766,"d":"2.75%"},{"v":0.00239671385409257,"d":"0.24%"},{"v":6.586388137064411E-5,"d":"0.0066%"}]
["Swiss Life"]
["  6. Immobilien Schweiz","CH0106150136","Gemischt","2020-06-30",173.49,null,"2020-05-29",{"v":2651.7962,"d":"2,651.80"},{"v":0.1127672927575423,"d":"11.28%"},{"v":0.00265849852626721,"d":"0.27%"},{"v":0.0002997916816070693,"d":"0.0300%"}]
["  7. Immobilien Schweiz Alter und Gesundheit","CH0385556482","Gemischt","2020-06-30",112.95,null,"2020-05-29",{"v":235.7072,"d":"235.71"},{"v":0.01002341840125594,"d":"1.00%"},{"v":0.00248513357592972,"d":"0.25%"},{"v":2.490953361455292E-5,"d":"0.0025%"}]
["Swiss Prime"]
["  8. SPA Immobilien Schweiz","CH0263627355","Gemischt","2020-06-30",{"v":1162.82,"d":"1,162.82"},null,"2020-05-29",{"v":1622.9,"d":"1,622.90"},{"v":0.06901361402366268,"d":"6.90%"},{"v":0.00262983177699017,"d":"0.26%"},{"v":0.0001814941952043626,"d":"0.0181%"}]
["Swisscanto"]
["  9. Immobilien Schweiz","CH0002875893","Gemischt","2020-06-30",232.35,null,"2020-05-29",{"v":7207.323417,"d":"7,207.32"},{"v":0.3064905024613615,"d":"30.65%"},{"v":-0.00343126742440492,"d":"-0.34%"},{"v":-0.001051650876985166,"d":"-0.1052%"}]
["Tellco"]
["  10. Immobilien Schweiz","CH0024559798","Gemischt","2020-06-30",{"v":175.276,"d":"175.28"},null,"2020-05-29",{"v":1024.4958,"d":"1,024.50"},{"v":0.04356655228915121,"d":"4.36%"},{"v":0.00635300669749883,"d":"0.64%"},{"v":0.0002767785984799106,"d":"0.0277%"}]
["UBS 1"]
["  11. Immobilien Schweiz","CH0002875497","Gemischt","2020-06-30",{"v":1830.2,"d":"1,830.20"},null,"2020-05-29",{"v":2236.53879,"d":"2,236.54"},{"v":0.09510852474090183,"d":"9.51%"},{"v":0.00254168583886605,"d":"0.25%"},{"v":0.0002417359904893915,"d":"0.0242%"}]
["Gesamtsumme",{"$nulls":6},{"$f":"SUM(H2:H21)","v":{"v":23515.650107,"d":"23,515.65"}},{"$f":"SUM(I2:I21)","v":{"v":0.9999999999999999,"d":"100.00%"}},null,{"$f":"SUM(K2:K21)","v":{"v":0.002733235863193831,"d":"0.2733%"}}]
[]
["* 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-06-30","ISIN","Kategoriserung","NAV",null,null,"Nettovermögen",null,"Gewicht","Perf.","Beitrag"]
["Adimora"]
["  1. Omega (Wohnimmobilien)","CH0149835834","Wohnen","2020-06-30",{"v":1257.75,"d":"1,257.75"},null,"2019-09-30",{"v":248.5,"d":"248.50"},{"v":0.01648011254919178,"d":"1.65%"},{"v":0.00199163513244383,"d":"0.20%"},{"v":3.282237113959879E-5,"d":"0.0033%"}]
["ASSETIMMO"]
["  2. Anlagegruppe W","CH0010493457","Wohnen","2020-06-30",548.68,null,"2020-05-29",{"v":1625.55,"d":"1,625.55"},{"v":0.1078038106814434,"d":"10.78%"},{"v":0.00253388854434289,"d":"0.25%"},{"v":0.0002731628409222191,"d":"0.0273%"}]
["Avadis"]
["  3. Immobilien Schweiz Wohnen","CH0009359354","Wohnen","2020-06-30",{"v":148000.41,"d":"148,000.41"},null,"2020-05-29",{"v":2459.6758,"d":"2,459.68"},{"v":0.1631216660705164,"d":"16.31%"},{"v":0.00273800920063771,"d":"0.27%"},{"v":0.0004466286225244261,"d":"0.0447%"}]
["CSA"]
["  4. Real Estate Switzerland Residential","CH0025226090","Wohnen","2020-06-30",{"v":1907.17,"d":"1,907.17"},null,"2020-05-29",{"v":854.9003,"d":"854.90"},{"v":0.05669558616634936,"d":"5.67%"},{"v":0.00701202287355662,"d":"0.70%"},{"v":0.000397550747028142,"d":"0.0398%"}]
["Greenbrix"]
["  5. Greenbrix Housing","CH0224042157","Wohnen","2020-06-30",{"v":10653,"d":"10,653.00"},"* ","2020-05-29",{"v":269.585734,"d":"269.59"},{"v":0.01787848385503612,"d":"1.79%"},{"v":0.002729668674698704,"d":"0.27%"},{"v":4.880233733019863E-5,"d":"0.0049%"}]
["HIG"]
["  6. CH-Classico","CH0002875208","Wohnen","2020-06-30",{"v":12804,"d":"12,804.00"},"* ","2020-03-31",{"v":746.125,"d":"746.13"},{"v":0.04948178662279966,"d":"4.95%"},{"v":0.00392033871726527,"d":"0.39%"},{"v":0.0001939853638968202,"d":"0.0194%"}]
["IST"]
["  7. Immobilien Schweiz Fokus","CH0002598578","Wohnen","2020-06-30",{"v":275097.96,"d":"275,097.96"},null,"2020-05-29",{"v":276.6263,"d":"276.63"},{"v":0.01834540264815489,"d":"1.83%"},{"v":0.00342527648838975,"d":"0.34%"},{"v":6.2838076360768e-05,"d":"0.0063%"}]
["  8. Immobilien Schweiz Wohnen","CH0245229122","Wohnen","2020-06-30",123.06,null,"2020-05-29",{"v":224.3589,"d":"224.36"},{"v":0.01487911437993104,"d":"1.49%"},{"v":0.0027705345501956,"d":"0.28%"},{"v":4.122310046591113E-5,"d":"0.0041%"}]
["Patrimonium"]
["  9. Wohnimmobilien Schweiz","CH0112589673","Wohnen","2020-06-30",{"v":1622.76,"d":"1,622.76"},null,"2020-05-29",{"v":474.786306,"d":"474.79"},{"v":0.03148704933478876,"d":"3.15%"},{"v":0.01827263371903309,"d":"1.83%"},{"v":0.0005753513193877197,"d":"0.0575%"}]
["Pensimo"]
["  10. Casareal (Wohnimmobilien)","CH0020488190","Wohnen","2020-06-30",{"v":1317,"d":"1,317.00"},null,"2019-12-31",{"v":1844.89,"d":"1,844.89"},{"v":0.1223500798425691,"d":"12.24%"},{"v":0.00266463646745341,"d":"0.27%"},{"v":0.000326018484544346,"d":"0.0326%"}]
["Turidomus"]
["  11. Casareal (Wohnimmobilien)","CH0020488026","Wohnen","2020-06-30",{"v":1537.75,"d":"1,537.75"},null,"2020-03-31",{"v":3475.76,"d":"3,475.76"},{"v":0.230506704201122,"d":"23.05%"},{"v":0.00237924516002863,"d":"0.24%"},{"v":0.0005484319603246706,"d":"0.0548%"}]
["Zürich"]
["  12. Immobilien – Traditionell Schweiz","CH0023842187","Wohnen","2020-06-30",{"v":2602.6453,"d":"2,602.65"},null,"2020-05-29",{"v":627.425325,"d":"627.43"},{"v":0.0416098188016629,"d":"4.16%"},{"v":0.00253757851905911,"d":"0.25%"},{"v":0.0001055881823730416,"d":"0.0106%"}]
["  13. Immobilien – Wohnen Schweiz","CH0018192903","Wohnen","2020-06-30",{"v":2852.9856,"d":"2,852.99"},null,"2020-05-29",{"v":1950.5968505,"d":"1,950.60"},{"v":0.1293603848464346,"d":"12.94%"},{"v":0.004622413242687529,"d":"0.46%"},{"v":0.0005979571559933147,"d":"0.0598%"}]
["Gesamtsumme",{"$nulls":6},{"$f":"SUM(H2:H25)","v":{"v":15078.7805155,"d":"15,078.78"}},{"$f":"SUM(I2:I25)","v":{"v":1,"d":"100.00%"}},null,{"$f":"SUM(K2:K25)","v":{"v":0.003650360562291177,"d":"0.3650%"}}]
[]
["* Kein offizieller Handelskurs."]

{"sheet":"KGAST Immo-Index Geschäft","index":3,"n_rows":24,"n_cols":11,"rows_kept":24,"merged":[[0,3,0,5],[0,6,0,7]]}
["2020-06-30","ISIN","Kategoriserung","NAV",null,null,"Nettovermögen",null,"Gewicht","Perf.","Beitrag"]
["ASSETIMMO"]
["  1. Anlagegruppe G","CH0010493499","Geschäft","2020-06-30",417.89,null,"2020-05-29",{"v":750.194,"d":"750.19"},{"v":0.09687814705268066,"d":"9.69%"},{"v":0.00432930661266684,"d":"0.43%"},{"v":0.0004194152026580809,"d":"0.0419%"}]
["Avadis"]
["  2. Immobilien Schweiz Geschäft","CH0141268083","Geschäft","2020-06-30",{"v":127816.93,"d":"127,816.93"},null,"2020-05-29",832.79,{"v":0.107544384631178,"d":"10.75%"},{"v":0.0028343185646964,"d":"0.28%"},{"v":0.000304815045888998,"d":"0.0305%"}]
["CSA"]
["  3. Real Estate Switzerland Commercial","CH0113543620","Geschäft","2020-06-30",{"v":1565.24,"d":"1,565.24"},null,"2020-05-29",{"v":1318.4857,"d":"1,318.49"},{"v":0.1702658932642178,"d":"17.03%"},{"v":0.00443423408392318,"d":"0.44%"},{"v":0.0007549988272418206,"d":"0.0755%"}]
["DAI"]
["  4. Gewerbeimmobilien Schweiz DAGSIS","CH0347818491","Geschäft","2020-06-30",{"v":147.1,"d":"147.10"},null,"2020-05-29",{"v":135.72166,"d":"135.72"},{"v":0.01752675032820034,"d":"1.75%"},{"v":0.0232331663884251,"d":"2.32%"},{"v":0.0004072019066234628,"d":"0.0407%"}]
["Ecoreal"]
["  5. Suisseselect","CH0181111045","Geschäft","2020-06-30",155.86,null,"2020-03-31",{"v":427,"d":"427.00"},{"v":0.05514169507020136,"d":"5.51%"},{"v":0.00405849384783874,"d":"0.41%"},{"v":0.000223792230201812,"d":"0.0224%"}]
["Patrimonium"]
["  6. Gesundheitsimmobilien Schweiz","CH0282527719","Geschäft","2020-06-30",{"v":1183.89,"d":"1,183.89"},null,"2020-05-29",{"v":195.915408,"d":"195.92"},{"v":0.02530001800348967,"d":"2.53%"},{"v":0.04025873436537597,"d":"4.03%"},{"v":0.00101854670424172,"d":"0.1019%"}]
["Pensimo"]
["  7. Proreal (Geschäftsimmobilien)","CH0020488224","Geschäft","2020-06-30",{"v":1316.55,"d":"1,316.55"},null,"2019-12-31",511.63,{"v":0.06607059824067242,"d":"6.61%"},{"v":0.00289468672633775,"d":"0.29%"},{"v":0.0001912536837284688,"d":"0.0191%"}]
["Swiss Life"]
["  8. Geschäftsimmobilien Schweiz","CH0136837587","Geschäft","2020-06-30",152.49,null,"2020-05-29",{"v":1240.5012,"d":"1,240.50"},{"v":0.1601951730787327,"d":"16.02%"},{"v":0.00197122018529483,"d":"0.20%"},{"v":0.0003157799587595968,"d":"0.0316%"}]
["Turidomus"]
["  9. Proreal (Geschäftsimmobilien)","CH0020488067","Geschäft","2020-06-30",{"v":1149.8,"d":"1,149.80"},null,"2019-12-31",{"v":1028.71,"d":"1,028.71"},{"v":0.1328449956338802,"d":"13.28%"},{"v":0.0030970556161396,"d":"0.31%"},{"v":0.0004114283398039494,"d":"0.0411%"}]
["UBS 1"]
["  10. Kommerzielle Immobilien Schweiz","CH0100770533","Geschäft","2020-06-30",{"v":1652.16,"d":"1,652.16"},null,"2020-05-29",{"v":687.900666,"d":"687.90"},{"v":0.08883374417601976,"d":"8.88%"},{"v":0.00157617788986153,"d":"0.16%"},{"v":0.0001400177834438578,"d":"0.0140%"}]
["Zürich"]
["  11. Immobilien – Geschäft Schweiz","CH0032598069","Geschäft","2020-06-30",{"v":1818.0272,"d":"1,818.03"},null,"2020-05-29",{"v":614.8378714,"d":"614.84"},{"v":0.07939860052072713,"d":"7.94%"},{"v":-0.000403021794736835,"d":"-0.04%"},{"v":-3.199936648145645E-5,"d":"-0.0032%"}]
["Gesamtsumme",{"$nulls":6},{"$f":"SUM(H2:H23)","v":{"v":7743.6865054,"d":"7,743.69"}},{"$f":"SUM(I2:I23)","v":{"v":1,"d":"100.00%"}},null,{"$f":"SUM(K2:K23)","v":{"v":0.00415525031611031,"d":"0.4155%"}}]