{"text_format":"1","workbook":"xlsx","n_sheets":4,"sheets":["Meldebogen 1","Meldebogen 2","Meldebogen 3","Ländercodes"],"not_rendered":{"charts":0,"images":3,"macros":1,"external_links":0,"defined_names":10,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Meldebogen 1","index":0,"n_rows":44,"n_cols":8,"rows_kept":44,"cut":false,"hidden":false,"merged":[[4,2,4,5],[2,1,2,7],[43,2,43,5],[42,1,42,2],[7,1,7,6],[8,1,8,6],[10,1,10,6]]}
[]
[]
[null,"Meldebogen 1: Zusätzliche Informationen zu den verwalteten Kundenvermögen (AuM)"]
[]
["Bank/Wertpapierfirma: ","Bank:"]
[]
[]
[null,"Verwaltete Kundenvermögen (AuM) "]
[null,"nach Domizil des Vertragspartners (VP)"]
[]
[null,"Stichtag: 31. Dezember 2019"]
[]
[]
[null,"Domizil","Total pro Domizil","Total pro Domizil","Anteil am Total der AuM ","Anteil am Total der AuM ","Anteil am Total der AuM "]
[]
[null,null,null,"davon Fonds",null,"davon Fonds","davon                                   Rechtsträger ohne bestimmten WB i.S. Art. 12 SPV"]
[]
[null,null,"in TCHF","in TCHF","in %","in %","in %"]
[null,"01","02","03","04","05","05"]
[null,null,null,null,{"$f":"IF($C$42 = 0,0,C20/$C$42)","v":0},{"$f":"IF($D$42 = 0,0,D20/$D$42)","v":0},null,"001"]
[null,null,null,null,0,0,null,"002"]
[null,null,null,null,0,0,null,"003"]
[null,null,null,null,0,0,null,"004"]
[null,null,null,null,0,0,null,"005"]
[null,null,null,null,0,0,null,"006"]
[null,null,null,null,0,0,null,"007"]
[null,null,null,null,0,0,null,"008"]
[null,null,null,null,0,0,null,"009"]
[null,null,null,null,0,0,null,"010"]
[null,null,null,null,0,0,null,"011"]
[null,null,null,null,0,0,null,"012"]
[null,null,null,null,0,0,null,"013"]
[null,null,null,null,0,0,null,"014"]
[null,null,null,null,0,0,null,"015"]
[null,null,null,null,0,0,null,"016"]
[null,null,null,null,0,0,null,"017"]
[null,null,null,null,0,0,null,"018"]
[null,null,null,null,0,0,null,"019"]
[null,null,null,null,0,0,null,"020"]
[null,null,null,null,0,0,null,"021"]
[null,"übrige Länder",null,null,0,0,null,"022"]
[null,"Total",{"$f":"SUM(C20:C41)","v":0},{"$f":"SUM(D20:D41)","v":0},{"$f":"SUM(E20:E41)","v":0},{"$f":"SUM(F20:F41)","v":0},null,"023"]
[]
[null,"Bemerkungen:"]

{"sheet":"Meldebogen 2","index":1,"n_rows":43,"n_cols":8,"rows_kept":43,"cut":false,"hidden":false,"merged":[[4,2,4,5],[2,1,2,7],[42,2,42,5],[41,1,41,2],[7,1,7,6],[8,1,8,6],[10,1,10,6]]}
[]
[]
[null,"Meldebogen 2: Zusätzliche Informationen zu den verwalteten Kundenvermögen (AuM)"]
[]
[null,"Bank:"]
[]
[]
[null,"Neugeld - Zufluss (Bar und Unbar)"]
[null,"nach Domizil des Vertragspartners (VP)"]
[]
[null,"Stichtag: 31. Dezember 2019"]
[]
[]
[null,"Domizil","Total pro Domizil","Total pro Domizil","Anteil am Total des Neugeld - Zuflusses","Anteil am Total des Neugeld - Zuflusses","Anteil am Total der AuM "]
[]
[null,null,null,"davon Fonds",null,"davon Fonds","davon                                   Rechtsträger ohne bestimmten WB i.S. Art. 12 SPV"]
[]
[null,null,"in TCHF","in TCHF","in %","in %","in %"]
[null,"01","02","03","04","05","05"]
[null,null,null,null,{"$f":"IF($C$41 = 0,0,C20/$C$41)","v":0},{"$f":"IF($D$41 = 0,0,D20/$D$41)","v":0},null,"001"]
[null,null,null,null,0,0,null,"002"]
[null,null,null,null,0,0,null,"003"]
[null,null,null,null,0,0,null,"004"]
[null,null,null,null,0,0,null,"005"]
[null,null,null,null,0,0,null,"006"]
[null,null,null,null,0,0,null,"007"]
[null,null,null,null,0,0,null,"008"]
[null,null,null,null,0,0,null,"009"]
[null,null,null,null,0,0,null,"010"]
[null,null,null,null,0,0,null,"011"]
[null,null,null,null,0,0,null,"012"]
[null,null,null,null,0,0,null,"013"]
[null,null,null,null,0,0,null,"014"]
[null,null,null,null,0,0,null,"015"]
[null,null,null,null,0,0,null,"016"]
[null,null,null,null,0,0,null,"017"]
[null,null,null,null,0,0,null,"018"]
[null,null,null,null,0,0,null,"019"]
[null,null,null,null,0,0,null,"020"]
[null,"übrige Länder",null,null,0,0,null,"021"]
[null,"Total",{"$f":"SUM(C20:C40)","v":0},{"$f":"SUM(D20:D40)","v":0},{"$f":"SUM(E20:E40)","v":0},{"$f":"SUM(F20:F40)","v":0},null,"022"]
[]
[null,"Bemerkungen:"]

{"sheet":"Meldebogen 3","index":2,"n_rows":44,"n_cols":7,"rows_kept":44,"cut":false,"hidden":false,"merged":[[4,2,4,5],[2,1,2,6],[43,2,43,5],[42,1,42,2],[7,1,7,5],[10,1,10,5],[8,1,8,5]]}
[]
[]
["Anhang 3 b zur Konsolidierten erweiterten Frühinformation","Meldebogen 3: Zusätzliche Informationen zu den verwalteten Kundenvermögen (AuM)"]
[]
[null,"Bank:"]
[]
[]
[null,"Geld - Abfluss (Bar und Unbar)"]
[null,"nach Domizil des Vertragspartners (VP)"]
[]
[null,"Stichtag: 31. Dezember 2019"]
[]
[]
[null,"Domizil","Total pro Domizil","Total pro Domizil","Anteil am Total des Geld - Abflusses","Anteil am Total des Geld - Abflusses"]
[]
[null,null,null,"davon Fonds",null,"davon Fonds"]
[]
[null,null,"in TCHF","in TCHF","in %","in %"]
[null,"01","02","03","04","05"]
[null,null,null,null,{"$f":"IF($C$42 = 0,0,C20/$C$42)","v":0},{"$f":"IF($D$42 = 0,0,D20/$D$42)","v":0},"001"]
[null,null,null,null,0,0,"002"]
[null,null,null,null,0,0,"003"]
[null,null,null,null,0,0,"004"]
[null,null,null,null,0,0,"005"]
[null,null,null,null,0,0,"006"]
[null,null,null,null,0,0,"007"]
[null,null,null,null,0,0,"008"]
[null,null,null,null,0,0,"009"]
[null,null,null,null,0,0,"010"]
[null,null,null,null,0,0,"011"]
[null,null,null,null,0,0,"012"]
[null,null,null,null,0,0,"013"]
[null,null,null,null,0,0,"014"]
[null,null,null,null,0,0,"015"]
[null,null,null,null,0,0,"016"]
[null,null,null,null,0,0,"017"]
[null,null,null,null,0,0,"018"]
[null,null,null,null,0,0,"019"]
[null,null,null,null,0,0,"020"]
[null,null,null,null,0,0,"021"]
[null,"übrige Länder",null,null,0,0,"022"]
[null,"Total",{"$f":"SUM(C20:C41)","v":0},{"$f":"SUM(D20:D41)","v":0},{"$f":"SUM(E20:E41)","v":0},{"$f":"SUM(F20:F41)","v":0},"023"]
[]
[null,"Bemerkungen:"]

{"sheet":"Ländercodes","index":3,"n_rows":254,"n_cols":2,"rows_kept":254,"cut":false,"hidden":false,"merged":[[0,0,0,1]]}
["Liste der Ländercodes"]
[]
["Name des Landes","Ländercode"]
[]
["Afghanistan","AF"]
["Ägypten","EG"]
["Åland","AX"]
["Albanien","AL"]
["Algerien","DZ"]
["Amerikanisch-Samoa","AS"]
["Amerikanische Jungferninseln","VI"]
["Andorra","AD"]
["Angola","AO"]
["Anguilla","AI"]
["Antarktika","AQ"]
["Antigua und Barbuda","AG"]
["Äquatorialguinea","GQ"]
["Argentinien","AR"]
["Armenien","AM"]
["Aruba","AW"]
["Aserbaidschan","AZ"]
["Äthiopien","ET"]
["Australien","AU"]
["Bahamas","BS"]
["Bahrain","BH"]
["Bangladesch","BD"]
["Barbados","BB"]
["Belarus (Weissrussland)","BY"]
["Belgien","BE"]
["Belize","BZ"]
["Benin","BJ"]
["Bermuda","BM"]
["Bhutan","BT"]
["Bolivien","BO"]
["Bonaire, Sint Eustatius und Saba (Niederlande)","BQ"]
["Bosnien und Herzegowina","BA"]
["Botswana","BW"]
["Bouvetinsel","BV"]
["Brasilien","BR"]
["Britische Jungferninseln","VG"]
["Britisches Territorium im Indischen Ozean","IO"]
["Brunei Darussalam","BN"]
["Bulgarien","BG"]
["Burkina Faso","BF"]
["Burundi","BI"]
["Chile","CL"]
["China, Volksrepublik","CN"]
["Cookinseln","CK"]
["Costa Rica","CR"]
["Côte d'Ivoire (Elfenbeinküste)","CI"]
["Curaçao","CW"]
["Dänemark","DK"]
["Deutschland","DE"]
["Dominica","DM"]
["Dominikanische Republik","DO"]
["Dschibuti","DJ"]
["Ecuador","EC"]
["El Salvador","SV"]
["Eritrea","ER"]
["Estland","EE"]
["Falklandinseln","FK"]
["Färöer","FO"]
["Fidschi","FJ"]
["Finnland","FI"]
["Frankreich","FR"]
["Französisch-Guayana","GF"]
["Französisch-Polynesien","PF"]
["Französische Süd- und Antarktisgebiete","TF"]
["Gabun","GA"]
["Gambia","GM"]
["Georgien","GE"]
["Ghana","GH"]
["Gibraltar","GI"]
["Grenada","GD"]
["Griechenland","GR"]
["Grönland","GL"]
["Guadeloupe","GP"]
["Guam","GU"]
["Guatemala","GT"]
["Guernsey (Kanalinsel)","GG"]
["Guinea","GN"]
["Guinea-Bissau","GW"]
["Guyana","GY"]
["Haiti","HT"]
["Heard und McDonaldinseln","HM"]
["Honduras","HN"]
["Hongkong","HK"]
["Indien","IN"]
["Indonesien","ID"]
["Insel Man","IM"]
["Irak","IQ"]
["Iran, Islamische Republik","IR"]
["Irland","IE"]
["Island","IS"]
["Israel","IL"]
["Italien","IT"]
["Jamaika","JM"]
["Japan","JP"]
["Jemen","YE"]
["Jersey (Kanalinsel)","JE"]
["Jordanien","JO"]
["Kaimaninseln","KY"]
["Kambodscha","KH"]
["Kamerun","CM"]
["Kanada","CA"]
["Kap Verde","CV"]
["Kasachstan","KZ"]
["Katar","QA"]
["Kenia","KE"]
["Kirgisistan","KG"]
["Kiribati","KI"]
["Kokosinseln","CC"]
["Kolumbien","CO"]
["Komoren","KM"]
["Kongo, Demokratische Republik (ehem. Zaire)","CD"]
["Republik Kongo","CG"]
["Korea, Demokratische Volksrepublik (Nordkorea)","KP"]
["Korea, Republik (Südkorea)","KR"]
["Kosovo","KO"]
["Kroatien","HR"]
["Kuba","CU"]
["Kuwait","KW"]
["Laos, Demokratische Volksrepublik","LA"]
["Lesotho","LS"]
["Lettland","LV"]
["Libanon","LB"]
["Liberia","LR"]
["Libysch-Arabische Dschamahirija (Libyen)","LY"]
["Liechtenstein","LI"]
["Litauen","LT"]
["Luxemburg","LU"]
["Macao","MO"]
["Madagaskar","MG"]
["Malawi","MW"]
["Malaysia","MY"]
["Malediven","MV"]
["Mali","ML"]
["Malta","MT"]
["Marokko","MA"]
["Marshallinseln","MH"]
["Martinique","MQ"]
["Mauretanien","MR"]
["Mauritius","MU"]
["Mayotte","YT"]
["Mazedonien, ehem. jugoslawische Republik","MK"]
["Mexiko","MX"]
["Mikronesien","FM"]
["Moldawien (Republik Moldau)","MD"]
["Monaco","MC"]
["Mongolei","MN"]
["Montenegro","ME"]
["Montserrat","MS"]
["Mosambik","MZ"]
["Myanmar (Burma)","MM"]
["Namibia","NA"]
["Nauru","NR"]
["Nepal","NP"]
["Neukaledonien","NC"]
["Neuseeland","NZ"]
["Nicaragua","NI"]
["Niederlande","NL"]
["Niger","NE"]
["Nigeria","NG"]
["Niue","NU"]
["Nördliche Marianen","MP"]
["Norfolkinsel","NF"]
["Norwegen","NO"]
["Oman","OM"]
["Österreich","AT"]
["Osttimor (Timor-Leste)","TL"]
["Pakistan","PK"]
["Palästinensische Autonomiegebiete","PS"]
["Palau","PW"]
["Panama","PA"]
["Papua-Neuguinea","PG"]
["Paraguay","PY"]
["Peru","PE"]
["Philippinen","PH"]
["Pitcairninseln","PN"]
["Polen","PL"]
["Portugal","PT"]
["Puerto Rico","PR"]
["Réunion","RE"]
["Ruanda","RW"]
["Rumänien","RO"]
["Russische Föderation","RU"]
["Salomonen","SB"]
["Saint-Barthélemy","BL"]
["Saint-Martin (franz. Teil)","MF"]
["Sambia","ZM"]
["Samoa","WS"]
["San Marino","SM"]
["São Tomé und Príncipe","ST"]
["Saudi-Arabien","SA"]
["Schweden","SE"]
["Schweiz (Confoederatio Helvetica)","CH"]
["Senegal","SN"]
["Serbien","RS"]
["Seychellen","SC"]
["Sierra Leone","SL"]
["Simbabwe","ZW"]
["Singapur","SG"]
["Sint Maarten (niederl. Teil)","SX"]
["Slowakei","SK"]
["Slowenien","SI"]
["Somalia","SO"]
["Spanien","ES"]
["Sri Lanka","LK"]
["St. Helena","SH"]
["St. Kitts und Nevis","KN"]
["St. Lucia","LC"]
["Saint-Pierre und Miquelon","PM"]
["St. Vincent und die Grenadinen","VC"]
["Südafrika","ZA"]
["Sudan","SD"]
["Südgeorgien und die Südlichen Sandwichinseln","GS"]
["Südsudan","SS"]
["Suriname","SR"]
["Svalbard und Jan Mayen","SJ"]
["Swasiland","SZ"]
["Syrien, Arabische Republik","SY"]
["Tadschikistan","TJ"]
["Republik China (Taiwan)","TW"]
["Tansania, Vereinigte Republik","TZ"]
["Thailand","TH"]
["Togo","TG"]
["Tokelau","TK"]
["Tonga","TO"]
["Trinidad und Tobago","TT"]
["Tschad","TD"]
["Tschechische Republik","CZ"]
["Tunesien","TN"]
["Türkei","TR"]
["Turkmenistan","TM"]
["Turks- und Caicosinseln","TC"]
["Tuvalu","TV"]
["Uganda","UG"]
["Ukraine","UA"]
["Ungarn","HU"]
["United States Minor Outlying Islands","UM"]
["Uruguay","UY"]
["Usbekistan","UZ"]
["Vanuatu","VU"]
["Vatikanstadt","VA"]
["Venezuela","VE"]
["Vereinigte Arabische Emirate","AE"]
["Vereinigte Staaten von Amerika","US"]
["Vereinigtes Königreich Großbritannien und Nordirland","GB"]
["Vietnam","VN"]
["Wallis und Futuna","WF"]
["Weihnachtsinsel","CX"]
["Westsahara","EH"]
["Zentralafrikanische Republik","CF"]
["Zypern","CY"]