{"text_format":"1","workbook":"xlsx","n_sheets":16,"sheets":["Cover Sheet","A - Verification Sheet","A - Innovation","A - Cross-border activity","A - Retail Investor Trends","A - Complaints","A - Office of the Arbiter","A - Online & Social presence","A - Branches","A - Additional details","B - Financial Details","B - Statement of c. income","B - Statement of f. position","B - Supervisory Fee Calculator","C - Exposure to Maltese Banks","Confirmations"],"not_rendered":{"charts":0,"images":46,"macros":1,"external_links":16,"defined_names":347,"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":"Cover Sheet","index":0,"n_rows":1036,"n_cols":5,"rows_kept":1036,"cut":false,"hidden":false,"merged":[[0,0,4,3],[5,0,7,3],[34,1,34,2],[33,1,33,2],[35,1,35,2],[32,1,32,2]]}
[]
[]
[]
[]
[]
["MiFID FIRMS QUARTERLY REPORTING"]
[]
[]
[]
[null,"Licence Holder information"]
[]
[null,"Name of Licence Holder",null,null,""]
[]
[null,"Licence Holder Code"]
[]
[null,"Licence Class",null,1]
[]
[null,"LEI Code"]
[]
[null,"Reporting period"]
[]
[null,"Relevant reporting quarter for the Conduct-Related Data (Section A)"]
[]
[null,"Relevant reporting period for Prudential Data (Section B) from:"]
[null,"Relevant reporting period for Prudential Data (Section B) to:"]
[null,null,null,""]
[null,"Currency in which accounts are reported"]
[null,null,null,""]
[null,"Exchange rate as at end of reporting period converting the reporting currency to EURO"]
[]
[null,"Accounting Framework"]
[]
[null,"Important !"]
[null,"Kindly note that \n- Part A is related to Conduct-Related Data with relevant reporting period on a quarterly basis;\n- Part B is related to Prudential Supervision Data with relevant reporting period on a cumulative basis;\n- Part C is related to Exposure to Maltese Banks with relevant reporting period on a quarterly basis.\n\nKindly ensure to compile the latest version of the Return, available on the MFSA website. "]
[null,"A Guidelines document to consult prior to compile this Return is available on the MFSA website via "]
[null,"https://www.mfsa.mt/our-work/securities-and-markets-supervision"]
[]
[null,null,"Version 9: April 2023"]
[]
[]
[]
[]
[null,"EUR"]
[null,"GBP"]
[null,"USD"]
[null,null,"Class 1 minus"]
[null,null,"Class 2"]
[null,null,"Class 3"]
[]
[]
[]
[]
[null,null,"ANNUAL COREP RETURN"]
[null,null,"ANNUAL AUDITED COREP RETURN"]
[null,null,"INTERIM COREP RETURN"]
[]
[]
[]
[]
[null,"Validation Checks"]
[null,null,null,1]
[null,"inputting of exchange rate converting reporting currency to euro",null,1]
[null,"Inputting of currency in which the accounts are reported",null,1]
[null,"Inputting of number of months covered by reporting period",null,1]
[null,"Inputting of starting period covered by the Financial Return",null,1]
[null,"Inputting of end period covered by the Financial Return",null,1]
[null,"Inputting of the licence category covered by the Financial Return",null,1]
[null,"Inputting of the licence number of the licence holder",null,1]
[null,"Inputting of the licence holder code",null,1]
[null,"Inputting of name of licence holder",null,1]
[null,"Inputting of type of document",null,10]
[]
[]
[]
[null,"Level of application ","Individual"]
[null,null,"Consolidated"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Q1"]
[null,"Q2"]
[null,"Q3"]
[null,"Q4"]

{"sheet":"A - Verification Sheet","index":1,"n_rows":339,"n_cols":7,"rows_kept":339,"cut":false,"hidden":false,"merged":[[31,5,31,13],[17,6,17,14],[21,6,21,14],[19,6,19,14],[0,0,0,15],[5,6,5,14],[7,6,7,14],[9,6,9,14],[11,6,11,14],[13,6,13,14],[15,6,15,14]]}
["Validation Sheet"]
[]
[]
["Tab ",null,"Validation",null,"Error",null,"Description of the error"]
[]
["Cover Sheet",null,{"$f":"IF(E37>0, \"ERROR\", \"OK\")","v":"ERROR"},null,{"$f":"IF(C6=\"Ok\", \"No error, please proceed\", \"Please review the tab once again\")","v":"Please review the tab once again"},null,{"$f":"IF(C6=\"ERROR\",(_xlfn.TEXTJOIN(\"; \",TRUE,F34:F37)&\".\"), \"\")","v":"Ensure that the field 'Licence holder name' is filled in; Ensure that the field 'Licence holder code' is filled in; Ensure that the field 'LEI code' is filled in; Ensure that the relevant quarter for Part A is indicated."}]
[]
["A - Innovation",null,{"$f":"IF(E47>0, \"ERROR\", \"OK\")","v":"ERROR"},null,{"$f":"IF(C8=\"Ok\", \"No error, please proceed\", \"Please review the tab once again\")","v":"Please review the tab once again"},null,{"$f":"IF(C8=\"ERROR\",(_xlfn.TEXTJOIN(\"; \",TRUE,F39:F47)&\".\"), \"\")","v":"Ensure that Question 2 if filled in when 'Product' or 'Process' is selected in Question 1; Ensure that Question 3 is filled in; Ensure that Question 4 is filled in; Ensure that Question 5 if filled in; Ensure that Question 6 is filled in."}]
[]
["A - Cross-border activity",null,{"$f":"IF(E222>0, \"ERROR\", \"OK\")","v":"OK"},null,{"$f":"IF(C10=\"Ok\", \"No error, please proceed\", \"Please review the tab once again\")","v":"No error, please proceed"},null,{"$f":"IF(C10=\"ERROR\",(_xlfn.TEXTJOIN(\"; \",TRUE,F49:F222)&\".\"), \"\")","v":""}]
[]
["A - Retail Investor Trends",null,{"$f":"IF(E259>0, \"ERROR\",\"OK\")","v":"ERROR"},null,{"$f":"IF(C12=\"Ok\", \"No error, please proceed\", \"Please review the tab once again\")","v":"Please review the tab once again"},null,{"$f":"IF(C12=\"ERROR\",(_xlfn.TEXTJOIN(\"; \",TRUE,F224:F259)&\".\"), \"\")","v":"Ensure that Question 1 is filled in; Ensure that the sum indicated in Question 2 is equal to 100%; Ensure that Question 3 is replied; Ensure that Question 5 is filled in; Ensure that Question 6 is filled in."}]
[]
["A - Complaints",null,{"$f":"IF(E264>0, \"ERROR\", \"OK\")","v":"OK"},null,{"$f":"IF(C14=\"Ok\", \"No error, please proceed\", \"Please review the tab once again\")","v":"No error, please proceed"},null,{"$f":"IF(C14=\"ERROR\",(_xlfn.TEXTJOIN(\"; \",TRUE,F261:F264)&\".\"), \"\")","v":""}]
[]
["A - Office of the Arbiter",null,{"$f":"IF(E266>0, \"ERROR\", \"OK\")","v":"OK"},null,{"$f":"IF(C16=\"Ok\", \"No error, please proceed\", \"Please review the tab once again\")","v":"No error, please proceed"},null,{"$f":"IF(C16=\"ERROR\",(_xlfn.TEXTJOIN(\"; \",TRUE,F266)&\".\"), \"\")","v":""}]
[]
["A - Online & Social media presence",null,{"$f":"IF(E269>0, \"ERROR\", \"OK\")","v":"ERROR"},null,{"$f":"IF(C18=\"Ok\", \"No error, please proceed\", \"Please review the tab once again\")","v":"Please review the tab once again"},null,{"$f":"IF(C18=\"ERROR\",(_xlfn.TEXTJOIN(\"; \",TRUE,F268:F269)&\".\"), \"\")","v":"Ensure that Question 1 is filled in; Ensure that Question 2 is filled in."}]
[]
["A - Branches ",null,{"$f":"IF(E332>0, \"ERROR\", \"OK\")","v":"ERROR"},null,{"$f":"IF(C20=\"Ok\", \"No error, please proceed\", \"Please review the tab once again\")","v":"Please review the tab once again"},null,{"$f":"IF(C20=\"ERROR\",(_xlfn.TEXTJOIN(\"; \",TRUE,F271:F332)&\".\"), \"\")","v":"Ensure that Question 1 is filled in; Ensure that Question 3 is filled in."}]
[]
["A - Additional details ",null,{"$f":"IF(E338>0, \"ERROR\", \"OK\")","v":"ERROR"},null,{"$f":"IF(C22=\"Ok\", \"No error, please proceed\", \"Please review the tab once again\")","v":"Please review the tab once again"},null,{"$f":"IF(C22=\"ERROR\",(_xlfn.TEXTJOIN(\"; \",TRUE,F334:F338)&\".\"), \"\")","v":"Ensure that Question 2 is replied; Ensure that Question 3 is replied; Ensure that Question 4 is replied if 'Yes' is selected in Question 3."}]
[]
[null,null,null,null,{"$f":"IF(AND(E6=\"No error, please proceed\", E8=\"No error, please proceed\",E10=\"No error, please proceed\",E12=\"No error, please proceed\",E14=\"No error, please proceed\",E16=\"No error, please proceed\",E18=\"No error, please proceed\",E20=\"No error, please proceed\",E22=\"No error, please proceed\"),\"Please proceed with the submission to the LH Portal\",\"Please review the tab(s) with error once again\")","v":"Please review the tab(s) with error once again"}]
[]
[]
[]
[]
[]
[]
[]
["NAME OF THE SHEET","VALIDATION NO.",null,"VALIDATION FORMULA",null,"DESCRIPTION"]
[]
["Cover Sheet",1,null,{"$f":"IF('Cover Sheet'!C12<>\"\", \"OK\", 1)","v":1},null,{"$f":"IF(D34=1, \"Ensure that the field 'Licence holder name' is filled in\", \"\")","v":"Ensure that the field 'Licence holder name' is filled in"}]
[null,2,null,{"$f":"IF('Cover Sheet'!C14<>\"\", \"OK\", 1)","v":1},null,{"$f":"IF(D35=1, \"Ensure that the field 'Licence holder code' is filled in\", \"\")","v":"Ensure that the field 'Licence holder code' is filled in"}]
[null,3,null,{"$f":"IF('Cover Sheet'!C18<>\"\", \"OK\", 1)","v":1},null,{"$f":"IF(D36=1, \"Ensure that the field 'LEI code' is filled in\", \"\")","v":"Ensure that the field 'LEI code' is filled in"}]
[null,4,null,{"$f":"IF('Cover Sheet'!C22<>\"\", \"OK\", 1)","v":1},{"$f":"SUM(D34:D37)","v":4},{"$f":"IF(D37=1, \"Ensure that the relevant quarter for Part A is indicated\", \"\")","v":"Ensure that the relevant quarter for Part A is indicated"}]
[]
["A - Innovation",1,null,{"$f":"IF(AND('A - Innovation'!O4=FALSE, 'A - Innovation'!O5=FALSE,  'A - Innovation'!O6=TRUE), \"OK\", IF('A - Innovation'!A11<>\"\", \"OK\", 1))","v":1},null,{"$f":"IF(D39=1, \"Ensure that Question 2 if filled in when 'Product' or 'Process' is selected in Question 1\", \"\")","v":"Ensure that Question 2 if filled in when 'Product' or 'Process' is selected in Question 1"}]
[null,2,null,{"$f":"IF('A - Innovation'!O6=TRUE,\"OK\",IF(OR('A - Innovation'!O8<>FALSE,'A - Innovation'!O9<>FALSE,'A - Innovation'!O10<>FALSE,'A - Innovation'!O11<>FALSE,'A - Innovation'!O12<>FALSE,'A - Innovation'!O13<>FALSE,'A - Innovation'!O14<>FALSE),\"OK\",1))","v":1},null,{"$f":"IF(D40=1, \"Ensure that Question 3 is filled in\", \"\")","v":"Ensure that Question 3 is filled in"}]
[null,3,null,{"$f":"IF('A - Innovation'!O14=FALSE, \"OK\", IF('A - Innovation'!A24<>\"\", \"OK\", 1))","v":"OK"},null,{"$f":"IF(D41=1, \"Ensure that Question 3.1 is filled in when 'Other financial instruments' is selected in Question 3\", \"\")","v":""}]
[null,4,null,{"$f":"IF('A - Innovation'!O6=TRUE, \"OK\", IF(OR('A - Innovation'!O17<>FALSE,'A - Innovation'!O18<>FALSE,'A - Innovation'!O19<>FALSE,'A - Innovation'!O20<>FALSE,'A - Innovation'!O21<>FALSE,'A - Innovation'!O22<>FALSE,'A - Innovation'!O23<>FALSE, 'A - Innovation'!O24<>FALSE,'A - Innovation'!O25<>FALSE, 'A - Innovation'!O26<>FALSE,'A - Innovation'!O27<>FALSE, 'A - Innovation'!O28<>FALSE, 'A - Innovation'!O29<>FALSE),\"OK\",1))","v":1},null,{"$f":"IF(D42=1, \"Ensure that Question 4 is filled in\", \"\")","v":"Ensure that Question 4 is filled in"}]
[null,5,null,{"$f":"IF('A - Innovation'!O28=FALSE, \"OK\", IF('A - Innovation'!A40<>\"\", \"OK\", 1))","v":"OK"},null,{"$f":"IF(D43=1, \"Ensure that Question 4.1 is filled in when 'Other' is selected in Q4\", \"\")","v":""}]
[null,6,null,{"$f":"IF('A - Innovation'!O6=TRUE,\"OK\", IF(OR('A - Innovation'!O31<>FALSE,'A - Innovation'!O32<>FALSE,'A - Innovation'!O33<>FALSE,'A - Innovation'!O34<>FALSE,'A - Innovation'!O35<>FALSE,'A - Innovation'!O36<>FALSE),\"OK\",1))","v":1},null,{"$f":"IF(D44=1, \"Ensure that Question 5 if filled in\", \"\")","v":"Ensure that Question 5 if filled in"}]
[null,7,null,{"$f":"IF('A - Innovation'!O52=FALSE, \"OK\", IF('A - Innovation'!A52<>\"\", \"OK\", 1))","v":"OK"},null,{"$f":"IF(D45=1, \"Ensure that Question 5.1 is filled in when 'Other' is selected in Question 5\", \"\")","v":""}]
[null,8,null,{"$f":"IF('A - Innovation'!O6=TRUE, \"OK\", IF(OR('A - Innovation'!O38<>FALSE,'A - Innovation'!O39<>FALSE,'A - Innovation'!O40<>FALSE,'A - Innovation'!O41<>FALSE,'A - Innovation'!O42<>FALSE,'A - Innovation'!O43<>FALSE,'A - Innovation'!O44<>FALSE),\"OK\",1))","v":1},null,{"$f":"IF(D46=1, \"Ensure that Question 6 is filled in\", \"\")","v":"Ensure that Question 6 is filled in"}]
[null,9,null,{"$f":"IF('A - Innovation'!O44=FALSE, \"OK\", IF('A - Innovation'!A68<>\"\", \"OK\", 1))","v":"OK"},{"$f":"SUM(D39:D47)","v":5},{"$f":"IF(D47=1, \"Ensure that Question 6.1 is filled in when 'Other' is selected in Question 6\", \"\")","v":""}]
[]
["A - Cross border activity",1,null,{"$f":"IF('A - Cross-border activity'!B10=\"\", \"OK\", IF(AND(SUM('A - Cross-border activity'!C10:Q10)<>0, 'A - Cross-border activity'!R10<>\"\", 'A - Cross-border activity'!S10<>\"\"), \"OK\", 1))","v":"OK"},null,{"$f":"IF(D49=1, \"Ensure that all sections for Retail clients in Austria are filled in\",\"\")","v":""}]
[null,2,null,{"$f":"IF('A - Cross-border activity'!B11=\"\", \"OK\", IF(AND(SUM('A - Cross-border activity'!C11:Q11)<>0, 'A - Cross-border activity'!R11<>\"\", 'A - Cross-border activity'!S11<>\"\"), \"OK\", 1))","v":"OK"},null,{"$f":"IF(D50=1, \"Ensure that all sections for Retail clients in Belgium are filled in\", \"\")","v":""}]
[null,3,null,{"$f":"IF('A - Cross-border activity'!B12=\"\", \"OK\", IF(AND(SUM('A - Cross-border activity'!C12:Q12)<>0, 'A - Cross-border activity'!R12<>\"\", 'A - Cross-border activity'!S12<>\"\"), \"OK\", 1))","v":"OK"},null,{"$f":"IF(D51=1, \"Ensure that all sections for Retail clients in Bulgaria are filled in\", \"\")","v":""}]
[null,4,null,{"$f":"IF('A - Cross-border activity'!B13=\"\", \"OK\", IF(AND(SUM('A - Cross-border activity'!C13:Q13)<>0, 'A - Cross-border activity'!R13<>\"\", 'A - Cross-border activity'!S13<>\"\"), \"OK\", 1))","v":"OK"},null,{"$f":"IF(D52=1, \"Ensure that all sections for Retail clients in Croatia are filled in\", \"\")","v":""}]
[null,5,null,{"$f":"IF('A - Cross-border activity'!B14=\"\", \"OK\", IF(AND(SUM('A - Cross-border activity'!C14:Q14)<>0, 'A - Cross-border activity'!R14<>\"\", 'A - Cross-border activity'!S14<>\"\"), \"OK\", 1))","v":"OK"},null,{"$f":"IF(D53=1, \"Ensure that all sections for Retail clients in Cyprus are filled in\", \"\")","v":""}]
[null,6,null,{"$f":"IF('A - Cross-border activity'!B15=\"\", \"OK\", IF(AND(SUM('A - Cross-border activity'!C15:Q15)<>0, 'A - Cross-border activity'!R15<>\"\", 'A - Cross-border activity'!S15<>\"\"), \"OK\", 1))","v":"OK"},null,{"$f":"IF(D54=1, \"Ensure that all sections for Retail clients in Czech Republic are filled in\", \"\")","v":""}]
[null,7,null,{"$f":"IF('A - Cross-border activity'!B16=\"\", \"OK\", IF(AND(SUM('A - Cross-border activity'!C16:Q16)<>0, 'A - Cross-border activity'!R16<>\"\", 'A - Cross-border activity'!S16<>\"\"), \"OK\", 1))","v":"OK"},null,{"$f":"IF(D55=1, \"Ensure that all sections for Retail clients in Denmark are filled in\", \"\")","v":""}]
[null,8,null,{"$f":"IF('A - Cross-border activity'!B17=\"\", \"OK\", IF(AND(SUM('A - Cross-border activity'!C17:Q17)<>0, 'A - Cross-border activity'!R17<>\"\", 'A - Cross-border activity'!S17<>\"\"), \"OK\", 1))","v":"OK"},null,{"$f":"IF(D56=1, \"Ensure that all sections for Retail clients in Estonia are filled in\", \"\")","v":""}]
[null,9,null,{"$f":"IF('A - Cross-border activity'!B18=\"\", \"OK\", IF(AND(SUM('A - Cross-border activity'!C18:Q18)<>0, 'A - Cross-border activity'!R18<>\"\", 'A - Cross-border activity'!S18<>\"\"), \"OK\", 1))","v":"OK"},null,{"$f":"IF(D57=1, \"Ensure that all sections for Retail clients in Finland are filled in\", \"\")","v":""}]
[null,10,null,{"$f":"IF('A - Cross-border activity'!B19=\"\", \"OK\", IF(AND(SUM('A - Cross-border activity'!C19:Q19)<>0, 'A - Cross-border activity'!R19<>\"\", 'A - Cross-border activity'!S19<>\"\"), \"OK\", 1))","v":"OK"},null,{"$f":"IF(D58=1, \"Ensure that all sections for Retail clients in France are filled in\", \"\")","v":""}]
[null,11,null,{"$f":"IF('A - Cross-border activity'!B20=\"\", \"OK\", IF(AND(SUM('A - Cross-border activity'!C20:Q20)<>0, 'A - Cross-border activity'!R20<>\"\", 'A - Cross-border activity'!S20<>\"\"), \"OK\", 1))","v":"OK"},null,{"$f":"IF(D59=1, \"Ensure that all sections for Retail clients in Germany are filled in\", \"\")","v":""}]
[null,12,null,{"$f":"IF('A - Cross-border activity'!B21=\"\", \"OK\", IF(AND(SUM('A - Cross-border activity'!C21:Q21)<>0, 'A - Cross-border activity'!R21<>\"\", 'A - Cross-border activity'!S21<>\"\"), \"OK\", 1))","v":"OK"},null,{"$f":"IF(D60=1, \"Ensure that all sections for Retail clients in Greece are filled in\", \"\")","v":""}]
[null,13,null,{"$f":"IF('A - Cross-border activity'!B22=\"\", \"OK\", IF(AND(SUM('A - Cross-border activity'!C22:Q22)<>0, 'A - Cross-border activity'!R22<>\"\", 'A - Cross-border activity'!S22<>\"\"), \"OK\", 1))","v":"OK"},null,{"$f":"IF(D61=1, \"Ensure that all sections for Retail clients in Hungary are filled in\", \"\")","v":""}]
[null,14,null,{"$f":"IF('A - Cross-border activity'!B23=\"\", \"OK\", IF(AND(SUM('A - Cross-border activity'!C23:Q23)<>0, 'A - Cross-border activity'!R23<>\"\", 'A - Cross-border activity'!S23<>\"\"), \"OK\", 1))","v":"OK"},null,{"$f":"IF(D62=1, \"Ensure that all sections for Retail clients in Iceland are filled in\", \"\")","v":""}]
[null,15,null,{"$f":"IF('A - Cross-border activity'!B24=\"\", \"OK\", IF(AND(SUM('A - Cross-border activity'!C24:Q24)<>0, 'A - Cross-border activity'!R24<>\"\", 'A - Cross-border activity'!S24<>\"\"), \"OK\", 1))","v":"OK"},null,{"$f":"IF(D63=1, \"Ensure that all sections for Retail clients in Ireland are filled in\", \"\")","v":""}]
[null,16,null,{"$f":"IF('A - Cross-border activity'!B25=\"\", \"OK\", IF(AND(SUM('A - Cross-border activity'!C25:Q25)<>0, 'A - Cross-border activity'!R25<>\"\", 'A - Cross-border activity'!S25<>\"\"), \"OK\", 1))","v":"OK"},null,{"$f":"IF(D64=1, \"Ensure that all sections for Retail clients in Italy are filled in\", \"\")","v":""}]
[null,17,null,{"$f":"IF('A - Cross-border activity'!B26=\"\", \"OK\", IF(AND(SUM('A - Cross-border activity'!C26:Q26)<>0, 'A - Cross-border activity'!R26<>\"\", 'A - Cross-border activity'!S26<>\"\"), \"OK\", 1))","v":"OK"},null,{"$f":"IF(D65=1, \"Ensure that all sections for Retail clients in Latvia are filled in\", \"\")","v":""}]
[null,18,null,{"$f":"IF('A - Cross-border activity'!B27=\"\", \"OK\", IF(AND(SUM('A - Cross-border activity'!C27:Q27)<>0, 'A - Cross-border activity'!R27<>\"\", 'A - Cross-border activity'!S27<>\"\"), \"OK\", 1))","v":"OK"},null,{"$f":"IF(D66=1, \"Ensure that all sections for Retail clients in Liechtenstein are filled in\", \"\")","v":""}]
[null,19,null,{"$f":"IF('A - Cross-border activity'!B28=\"\", \"OK\", IF(AND(SUM('A - Cross-border activity'!C28:Q28)<>0, 'A - Cross-border activity'!R28<>\"\", 'A - Cross-border activity'!S28<>\"\"), \"OK\", 1))","v":"OK"},null,{"$f":"IF(D67=1, \"Ensure that all sections for Retail clients in Lithuania are filled in\", \"\")","v":""}]
[null,20,null,{"$f":"IF('A - Cross-border activity'!B29=\"\", \"OK\", IF(AND(SUM('A - Cross-border activity'!C29:Q29)<>0, 'A - Cross-border activity'!R29<>\"\", 'A - Cross-border activity'!S29<>\"\"), \"OK\", 1))","v":"OK"},null,{"$f":"IF(D68=1, \"Ensure that all sections for Retail clients in Luxembourg are filled in\",\"\")","v":""}]
[null,21,null,{"$f":"IF('A - Cross-border activity'!B30=\"\", \"OK\", IF(AND(SUM('A - Cross-border activity'!C30:Q30)<>0, 'A - Cross-border activity'!R30<>\"\", 'A - Cross-border activity'!S30<>\"\"), \"OK\", 1))","v":"OK"},null,{"$f":"IF(D68=1, \"Ensure that all sections for Retail clients in Netherlands are filled in\", \"\")","v":""}]
[null,22,null,{"$f":"IF('A - Cross-border activity'!B31=\"\", \"OK\", IF(AND(SUM('A - Cross-border activity'!C31:Q31)<>0, 'A - Cross-border activity'!R31<>\"\", 'A - Cross-border activity'!S31<>\"\"), \"OK\", 1))","v":"OK"},null,{"$f":"IF(D70=1, \"Ensure that all sections for Retail clients in Norway are filled in\", \"\")","v":""}]
[null,23,null,{"$f":"IF('A - Cross-border activity'!B32=\"\", \"OK\", IF(AND(SUM('A - Cross-border activity'!C32:Q32)<>0, 'A - Cross-border activity'!R32<>\"\", 'A - Cross-border activity'!S32<>\"\"), \"OK\", 1))","v":"OK"},null,{"$f":"IF(D71=1, \"Ensure that all sections for Retail clients in Poland are filled in\", \"\")","v":""}]
[null,24,null,{"$f":"IF('A - Cross-border activity'!B33=\"\", \"OK\", IF(AND(SUM('A - Cross-border activity'!C33:Q33)<>0, 'A - Cross-border activity'!R33<>\"\", 'A - Cross-border activity'!S33<>\"\"), \"OK\", 1))","v":"OK"},null,{"$f":"IF(D72=1, \"Ensure that all sections for Retail clients in Portugal are filled in\", \"\")","v":""}]
[null,25,null,{"$f":"IF('A - Cross-border activity'!B34=\"\", \"OK\", IF(AND(SUM('A - Cross-border activity'!C34:Q34)<>0, 'A - Cross-border activity'!R34<>\"\", 'A - Cross-border activity'!S34<>\"\"), \"OK\", 1))","v":"OK"},null,{"$f":"IF(D73=1, \"Ensure that all sections for Retail clients in Romania are filled in\", \"\")","v":""}]
[null,26,null,{"$f":"IF('A - Cross-border activity'!B35=\"\", \"OK\", IF(AND(SUM('A - Cross-border activity'!C35:Q35)<>0, 'A - Cross-border activity'!R35<>\"\", 'A - Cross-border activity'!S35<>\"\"), \"OK\", 1))","v":"OK"},null,{"$f":"IF(D74=1, \"Ensure that all sections for Retail clients in Slovakia are filled in\", \"\")","v":""}]
[null,27,null,{"$f":"IF('A - Cross-border activity'!B36=\"\", \"OK\", IF(AND(SUM('A - Cross-border activity'!C36:Q36)<>0, 'A - Cross-border activity'!R36<>\"\", 'A - Cross-border activity'!S36<>\"\"), \"OK\", 1))","v":"OK"},null,{"$f":"IF(D75=1, \"Ensure that all sections for Retail clients in Slovenia are filled in\", \"\")","v":""}]
[null,28,null,{"$f":"IF('A - Cross-border activity'!B37=\"\", \"OK\", IF(AND(SUM('A - Cross-border activity'!C37:Q37)<>0, 'A - Cross-border activity'!R37<>\"\", 'A - Cross-border activity'!S37<>\"\"), \"OK\", 1))","v":"OK"},null,{"$f":"IF(D76=1, \"Ensure that all sections for Retail clients in Spain are filled in\", \"\")","v":""}]
[null,29,null,{"$f":"IF('A - Cross-border activity'!B38=\"\", \"OK\", IF(AND(SUM('A - Cross-border activity'!C38:Q38)<>0, 'A - Cross-border activity'!R38<>\"\", 'A - Cross-border activity'!S38<>\"\"), \"OK\", 1))","v":"OK"},null,{"$f":"IF(D77=1, \"Ensure that all sections for Retail clients in Sweden are filled in\",\"\")","v":""}]
[null,30,null,{"$f":"IF('A - Cross-border activity'!B45=\"\", \"OK\", IF(AND(SUM('A - Cross-border activity'!C45:Q45)<>0, 'A - Cross-border activity'!R45<>\"\", 'A - Cross-border activity'!S45<>\"\"), \"OK\", 1))","v":"OK"},null,{"$f":"IF(D78=1, \"Ensure that all sections for Professional clients in Austria are filled in\",\"\")","v":""}]
[null,31,null,{"$f":"IF('A - Cross-border activity'!B46=\"\", \"OK\", IF(AND(SUM('A - Cross-border activity'!C46:Q46)<>0, 'A - Cross-border activity'!R46<>\"\", 'A - Cross-border activity'!S46<>\"\"), \"OK\", 1))","v":"OK"},null,{"$f":"IF(D79=1, \"Ensure that all sections for Professional clients in Belgium are filled in\", \"\")","v":""}]
[null,32,null,{"$f":"IF('A - Cross-border activity'!B47=\"\", \"OK\", IF(AND(SUM('A - Cross-border activity'!C47:Q47)<>0, 'A - Cross-border activity'!R47<>\"\", 'A - Cross-border activity'!S47<>\"\"), \"OK\", 1))","v":"OK"},null,{"$f":"IF(D80=1, \"Ensure that all sections for Professional clients in Bulgaria are filled in\", \"\")","v":""}]
[null,33,null,{"$f":"IF('A - Cross-border activity'!B48=\"\", \"OK\", IF(AND(SUM('A - Cross-border activity'!C48:Q48)<>0, 'A - Cross-border activity'!R48<>\"\", 'A - Cross-border activity'!S48<>\"\"), \"OK\", 1))","v":"OK"},null,{"$f":"IF(D81=1, \"Ensure that all sections for Professional clients in Croatia are filled in\", \"\")","v":""}]
[null,34,null,{"$f":"IF('A - Cross-border activity'!B49=\"\", \"OK\", IF(AND(SUM('A - Cross-border activity'!C49:Q49)<>0, 'A - Cross-border activity'!R49<>\"\", 'A - Cross-border activity'!S49<>\"\"), \"OK\", 1))","v":"OK"},null,{"$f":"IF(D82=1, \"Ensure that all sections for Professional clients in Cyprus are filled in\", \"\")","v":""}]
[null,35,null,{"$f":"IF('A - Cross-border activity'!B50=\"\", \"OK\", IF(AND(SUM('A - Cross-border activity'!C50:Q50)<>0, 'A - Cross-border activity'!R50<>\"\", 'A - Cross-border activity'!S50<>\"\"), \"OK\", 1))","v":"OK"},null,{"$f":"IF(D83=1, \"Ensure that all sections for Professional clients in Czech Republic are filled in\", \"\")","v":""}]
[null,36,null,{"$f":"IF('A - Cross-border activity'!B51=\"\", \"OK\", IF(AND(SUM('A - Cross-border activity'!C51:Q51)<>0, 'A - Cross-border activity'!R51<>\"\", 'A - Cross-border activity'!S51<>\"\"), \"OK\", 1))","v":"OK"},null,{"$f":"IF(D84=1, \"Ensure that all sections for Professional clients in Denmark are filled in\", \"\")","v":""}]
[null,37,null,{"$f":"IF('A - Cross-border activity'!B52=\"\", \"OK\", IF(AND(SUM('A - Cross-border activity'!C52:Q52)<>0, 'A - Cross-border activity'!R52<>\"\", 'A - Cross-border activity'!S52<>\"\"), \"OK\", 1))","v":"OK"},null,{"$f":"IF(D85=1, \"Ensure that all sections for Professional clients in Estonia are filled in\", \"\")","v":""}]
[null,38,null,{"$f":"IF('A - Cross-border activity'!B53=\"\", \"OK\", IF(AND(SUM('A - Cross-border activity'!C53:Q53)<>0, 'A - Cross-border activity'!R53<>\"\", 'A - Cross-border activity'!S53<>\"\"), \"OK\", 1))","v":"OK"},null,{"$f":"IF(D86=1, \"Ensure that all sections for Professional clients in Finland are filled in\", \"\")","v":""}]
[null,39,null,{"$f":"IF('A - Cross-border activity'!B54=\"\", \"OK\", IF(AND(SUM('A - Cross-border activity'!C54:Q54)<>0, 'A - Cross-border activity'!R54<>\"\", 'A - Cross-border activity'!S54<>\"\"), \"OK\", 1))","v":"OK"},null,{"$f":"IF(D87=1, \"Ensure that all sections for Professional clients in France are filled in\", \"\")","v":""}]
[null,40,null,{"$f":"IF('A - Cross-border activity'!B55=\"\", \"OK\", IF(AND(SUM('A - Cross-border activity'!C55:Q55)<>0, 'A - Cross-border activity'!R55<>\"\", 'A - Cross-border activity'!S55<>\"\"), \"OK\", 1))","v":"OK"},null,{"$f":"IF(D88=1, \"Ensure that all sections for Professional clients in Germany are filled in\", \"\")","v":""}]
[null,41,null,{"$f":"IF('A - Cross-border activity'!B56=\"\", \"OK\", IF(AND(SUM('A - Cross-border activity'!C56:Q56)<>0, 'A - Cross-border activity'!R56<>\"\", 'A - Cross-border activity'!S56<>\"\"), \"OK\", 1))","v":"OK"},null,{"$f":"IF(D89=1, \"Ensure that all sections for Professional clients in Greece are filled in\", \"\")","v":""}]
[null,42,null,{"$f":"IF('A - Cross-border activity'!B57=\"\", \"OK\", IF(AND(SUM('A - Cross-border activity'!C57:Q57)<>0, 'A - Cross-border activity'!R57<>\"\", 'A - Cross-border activity'!S57<>\"\"), \"OK\", 1))","v":"OK"},null,{"$f":"IF(D90=1, \"Ensure that all sections for Professional clients in Hungary are filled in\", \"\")","v":""}]
[null,43,null,{"$f":"IF('A - Cross-border activity'!B58=\"\", \"OK\", IF(AND(SUM('A - Cross-border activity'!C58:Q58)<>0, 'A - Cross-border activity'!R58<>\"\", 'A - Cross-border activity'!S58<>\"\"), \"OK\", 1))","v":"OK"},null,{"$f":"IF(D91=1, \"Ensure that all sections for Professional clients in Iceland are filled in\", \"\")","v":""}]
[null,44,null,{"$f":"IF('A - Cross-border activity'!B59=\"\", \"OK\", IF(AND(SUM('A - Cross-border activity'!C59:Q59)<>0, 'A - Cross-border activity'!R59<>\"\", 'A - Cross-border activity'!S59<>\"\"), \"OK\", 1))","v":"OK"},null,{"$f":"IF(D92=1, \"Ensure that all sections for Professional clients in Ireland are filled in\", \"\")","v":""}]
[null,45,null,{"$f":"IF('A - Cross-border activity'!B60=\"\", \"OK\", IF(AND(SUM('A - Cross-border activity'!C60:Q60)<>0, 'A - Cross-border activity'!R60<>\"\", 'A - Cross-border activity'!S60<>\"\"), \"OK\", 1))","v":"OK"},null,{"$f":"IF(D93=1, \"Ensure that all sections for Professional clients in Italy are filled in\", \"\")","v":""}]
[null,46,null,{"$f":"IF('A - Cross-border activity'!B61=\"\", \"OK\", IF(AND(SUM('A - Cross-border activity'!C61:Q61)<>0, 'A - Cross-border activity'!R61<>\"\", 'A - Cross-border activity'!S61<>\"\"), \"OK\", 1))","v":"OK"},null,{"$f":"IF(D94=1, \"Ensure that all sections for Professional clients in Latvia are filled in\", \"\")","v":""}]
[null,47,null,{"$f":"IF('A - Cross-border activity'!B62=\"\", \"OK\", IF(AND(SUM('A - Cross-border activity'!C62:Q62)<>0, 'A - Cross-border activity'!R62<>\"\", 'A - Cross-border activity'!S62<>\"\"), \"OK\", 1))","v":"OK"},null,{"$f":"IF(D95=1, \"Ensure that all sections for Professional clients in Liechtenstein are filled in\", \"\")","v":""}]
[null,48,null,{"$f":"IF('A - Cross-border activity'!B63=\"\", \"OK\", IF(AND(SUM('A - Cross-border activity'!C63:Q63)<>0, 'A - Cross-border activity'!R63<>\"\", 'A - Cross-border activity'!S63<>\"\"), \"OK\", 1))","v":"OK"},null,{"$f":"IF(D96=1, \"Ensure that all sections for Professional clients in Lithuania are filled in\", \"\")","v":""}]
[null,49,null,{"$f":"IF('A - Cross-border activity'!B64=\"\", \"OK\", IF(AND(SUM('A - Cross-border activity'!C64:Q64)<>0, 'A - Cross-border activity'!R64<>\"\", 'A - Cross-border activity'!S64<>\"\"), \"OK\", 1))","v":"OK"},null,{"$f":"IF(D97=1, \"Ensure that all sections for Professional clients in Luxembourg are filled in\",\"\")","v":""}]
[null,50,null,{"$f":"IF('A - Cross-border activity'!B65=\"\", \"OK\", IF(AND(SUM('A - Cross-border activity'!C65:Q65)<>0, 'A - Cross-border activity'!R65<>\"\", 'A - Cross-border activity'!S65<>\"\"), \"OK\", 1))","v":"OK"},null,{"$f":"IF(D97=1, \"Ensure that all sections for Professional clients in Netherlands are filled in\", \"\")","v":""}]
[null,51,null,{"$f":"IF('A - Cross-border activity'!B66=\"\", \"OK\", IF(AND(SUM('A - Cross-border activity'!C66:Q66)<>0, 'A - Cross-border activity'!R66<>\"\", 'A - Cross-border activity'!S66<>\"\"), \"OK\", 1))","v":"OK"},null,{"$f":"IF(D99=1, \"Ensure that all sections for Professional clients in Norway are filled in\", \"\")","v":""}]
[null,52,null,{"$f":"IF('A - Cross-border activity'!B67=\"\", \"OK\", IF(AND(SUM('A - Cross-border activity'!C67:Q67)<>0, 'A - Cross-border activity'!R67<>\"\", 'A - Cross-border activity'!S67<>\"\"), \"OK\", 1))","v":"OK"},null,{"$f":"IF(D100=1, \"Ensure that all sections for Professional clients in Poland are filled in\", \"\")","v":""}]
[null,53,null,{"$f":"IF('A - Cross-border activity'!B68=\"\", \"OK\", IF(AND(SUM('A - Cross-border activity'!C68:Q68)<>0, 'A - Cross-border activity'!R68<>\"\", 'A - Cross-border activity'!S68<>\"\"), \"OK\", 1))","v":"OK"},null,{"$f":"IF(D101=1, \"Ensure that all sections for Professional clients in Portugal are filled in\", \"\")","v":""}]
[null,54,null,{"$f":"IF('A - Cross-border activity'!B69=\"\", \"OK\", IF(AND(SUM('A - Cross-border activity'!C69:Q69)<>0, 'A - Cross-border activity'!R69<>\"\", 'A - Cross-border activity'!S69<>\"\"), \"OK\", 1))","v":"OK"},null,{"$f":"IF(D102=1, \"Ensure that all sections for Professional clients in Romania are filled in\", \"\")","v":""}]
[null,55,null,{"$f":"IF('A - Cross-border activity'!B70=\"\", \"OK\", IF(AND(SUM('A - Cross-border activity'!C70:Q70)<>0, 'A - Cross-border activity'!R70<>\"\", 'A - Cross-border activity'!S70<>\"\"), \"OK\", 1))","v":"OK"},null,{"$f":"IF(D103=1, \"Ensure that all sections for Professional clients in Slovakia are filled in\", \"\")","v":""}]
[null,56,null,{"$f":"IF('A - Cross-border activity'!B71=\"\", \"OK\", IF(AND(SUM('A - Cross-border activity'!C71:Q71)<>0, 'A - Cross-border activity'!R71<>\"\", 'A - Cross-border activity'!S71<>\"\"), \"OK\", 1))","v":"OK"},null,{"$f":"IF(D104=1, \"Ensure that all sections for Professional clients in Slovenia are filled in\", \"\")","v":""}]
[null,57,null,{"$f":"IF('A - Cross-border activity'!B72=\"\", \"OK\", IF(AND(SUM('A - Cross-border activity'!C72:Q72)<>0, 'A - Cross-border activity'!R72<>\"\", 'A - Cross-border activity'!S72<>\"\"), \"OK\", 1))","v":"OK"},null,{"$f":"IF(D105=1, \"Ensure that all sections for Professional clients in Spain are filled in\", \"\")","v":""}]
[null,58,null,{"$f":"IF('A - Cross-border activity'!B73=\"\", \"OK\", IF(AND(SUM('A - Cross-border activity'!C73:Q73)<>0, 'A - Cross-border activity'!R73<>\"\", 'A - Cross-border activity'!S73<>\"\"), \"OK\", 1))","v":"OK"},null,{"$f":"IF(D106=1, \"Ensure that all sections for Professional clients in Sweden are filled in\",\"\")","v":""}]
[null,59,null,{"$f":"IF('A - Cross-border activity'!B80=\"\", \"OK\", IF(AND(SUM('A - Cross-border activity'!C80:Q80)<>0, 'A - Cross-border activity'!R80<>\"\", 'A - Cross-border activity'!S80<>\"\"), \"OK\", 1))","v":"OK"},null,{"$f":"IF(D107=1, \"Ensure that all sections for Eligible counterparties in Austria are filled in\",\"\")","v":""}]
[null,60,null,{"$f":"IF('A - Cross-border activity'!B81=\"\", \"OK\", IF(AND(SUM('A - Cross-border activity'!C81:Q81)<>0, 'A - Cross-border activity'!R81<>\"\", 'A - Cross-border activity'!S81<>\"\"), \"OK\", 1))","v":"OK"},null,{"$f":"IF(D108=1, \"Ensure that all sections for Eligible counterparties in Belgium are filled in\", \"\")","v":""}]
[null,61,null,{"$f":"IF('A - Cross-border activity'!B82=\"\", \"OK\", IF(AND(SUM('A - Cross-border activity'!C82:Q82)<>0, 'A - Cross-border activity'!R82<>\"\", 'A - Cross-border activity'!S82<>\"\"), \"OK\", 1))","v":"OK"},null,{"$f":"IF(D109=1, \"Ensure that all sections for Eligible counterparties in Bulgaria are filled in\", \"\")","v":""}]
[null,62,null,{"$f":"IF('A - Cross-border activity'!B83=\"\", \"OK\", IF(AND(SUM('A - Cross-border activity'!C83:Q83)<>0, 'A - Cross-border activity'!R83<>\"\", 'A - Cross-border activity'!S83<>\"\"), \"OK\", 1))","v":"OK"},null,{"$f":"IF(D110=1, \"Ensure that all sections for Eligible counterparties in Croatia are filled in\", \"\")","v":""}]
[null,63,null,{"$f":"IF('A - Cross-border activity'!B84=\"\", \"OK\", IF(AND(SUM('A - Cross-border activity'!C84:Q84)<>0, 'A - Cross-border activity'!R84<>\"\", 'A - Cross-border activity'!S84<>\"\"), \"OK\", 1))","v":"OK"},null,{"$f":"IF(D111=1, \"Ensure that all sections for Eligible counterparties in Cyprus are filled in\", \"\")","v":""}]
[null,64,null,{"$f":"IF('A - Cross-border activity'!B85=\"\", \"OK\", IF(AND(SUM('A - Cross-border activity'!C85:Q85)<>0, 'A - Cross-border activity'!R85<>\"\", 'A - Cross-border activity'!S85<>\"\"), \"OK\", 1))","v":"OK"},null,{"$f":"IF(D112=1, \"Ensure that all sections for Eligible counterparties in Czech Republic are filled in\", \"\")","v":""}]
[null,65,null,{"$f":"IF('A - Cross-border activity'!B86=\"\", \"OK\", IF(AND(SUM('A - Cross-border activity'!C86:Q86)<>0, 'A - Cross-border activity'!R86<>\"\", 'A - Cross-border activity'!S86<>\"\"), \"OK\", 1))","v":"OK"},null,{"$f":"IF(D113=1, \"Ensure that all sections for Eligible counterparties in Denmark are filled in\", \"\")","v":""}]
[null,66,null,{"$f":"IF('A - Cross-border activity'!B87=\"\", \"OK\", IF(AND(SUM('A - Cross-border activity'!C87:Q87)<>0, 'A - Cross-border activity'!R87<>\"\", 'A - Cross-border activity'!S87<>\"\"), \"OK\", 1))","v":"OK"},null,{"$f":"IF(D114=1, \"Ensure that all sections for Eligible counterparties in Estonia are filled in\", \"\")","v":""}]
[null,67,null,{"$f":"IF('A - Cross-border activity'!B88=\"\", \"OK\", IF(AND(SUM('A - Cross-border activity'!C88:Q88)<>0, 'A - Cross-border activity'!R88<>\"\", 'A - Cross-border activity'!S88<>\"\"), \"OK\", 1))","v":"OK"},null,{"$f":"IF(D115=1, \"Ensure that all sections for Eligible counterparties in Finland are filled in\", \"\")","v":""}]
[null,68,null,{"$f":"IF('A - Cross-border activity'!B89=\"\", \"OK\", IF(AND(SUM('A - Cross-border activity'!C89:Q89)<>0, 'A - Cross-border activity'!R89<>\"\", 'A - Cross-border activity'!S89<>\"\"), \"OK\", 1))","v":"OK"},null,{"$f":"IF(D116=1, \"Ensure that all sections for Eligible counterparties in France are filled in\", \"\")","v":""}]
[null,69,null,{"$f":"IF('A - Cross-border activity'!B90=\"\", \"OK\", IF(AND(SUM('A - Cross-border activity'!C90:Q90)<>0, 'A - Cross-border activity'!R90<>\"\", 'A - Cross-border activity'!S90<>\"\"), \"OK\", 1))","v":"OK"},null,{"$f":"IF(D117=1, \"Ensure that all sections for Eligible counterparties in Germany are filled in\", \"\")","v":""}]
[null,70,null,{"$f":"IF('A - Cross-border activity'!B91=\"\", \"OK\", IF(AND(SUM('A - Cross-border activity'!C91:Q91)<>0, 'A - Cross-border activity'!R91<>\"\", 'A - Cross-border activity'!S91<>\"\"), \"OK\", 1))","v":"OK"},null,{"$f":"IF(D118=1, \"Ensure that all sections for Eligible counterparties in Greece are filled in\", \"\")","v":""}]
[null,71,null,{"$f":"IF('A - Cross-border activity'!B92=\"\", \"OK\", IF(AND(SUM('A - Cross-border activity'!C92:Q92)<>0, 'A - Cross-border activity'!R92<>\"\", 'A - Cross-border activity'!S92<>\"\"), \"OK\", 1))","v":"OK"},null,{"$f":"IF(D119=1, \"Ensure that all sections for Eligible counterparties in Hungary are filled in\", \"\")","v":""}]
[null,72,null,{"$f":"IF('A - Cross-border activity'!B93=\"\", \"OK\", IF(AND(SUM('A - Cross-border activity'!C93:Q93)<>0, 'A - Cross-border activity'!R93<>\"\", 'A - Cross-border activity'!S93<>\"\"), \"OK\", 1))","v":"OK"},null,{"$f":"IF(D120=1, \"Ensure that all sections for Eligible counterparties in Iceland are filled in\", \"\")","v":""}]
[null,73,null,{"$f":"IF('A - Cross-border activity'!B94=\"\", \"OK\", IF(AND(SUM('A - Cross-border activity'!C94:Q94)<>0, 'A - Cross-border activity'!R94<>\"\", 'A - Cross-border activity'!S94<>\"\"), \"OK\", 1))","v":"OK"},null,{"$f":"IF(D121=1, \"Ensure that all sections for Eligible counterparties in Ireland are filled in\", \"\")","v":""}]
[null,74,null,{"$f":"IF('A - Cross-border activity'!B95=\"\", \"OK\", IF(AND(SUM('A - Cross-border activity'!C95:Q95)<>0, 'A - Cross-border activity'!R95<>\"\", 'A - Cross-border activity'!S95<>\"\"), \"OK\", 1))","v":"OK"},null,{"$f":"IF(D122=1, \"Ensure that all sections for Eligible counterparties in Italy are filled in\", \"\")","v":""}]
[null,75,null,{"$f":"IF('A - Cross-border activity'!B96=\"\", \"OK\", IF(AND(SUM('A - Cross-border activity'!C96:Q96)<>0, 'A - Cross-border activity'!R96<>\"\", 'A - Cross-border activity'!S96<>\"\"), \"OK\", 1))","v":"OK"},null,{"$f":"IF(D123=1, \"Ensure that all sections for Eligible counterparties in Latvia are filled in\", \"\")","v":""}]
[null,76,null,{"$f":"IF('A - Cross-border activity'!B97=\"\", \"OK\", IF(AND(SUM('A - Cross-border activity'!C97:Q97)<>0, 'A - Cross-border activity'!R97<>\"\", 'A - Cross-border activity'!S97<>\"\"), \"OK\", 1))","v":"OK"},null,{"$f":"IF(D124=1, \"Ensure that all sections for Eligible counterparties in Liechtenstein are filled in\", \"\")","v":""}]
[null,77,null,{"$f":"IF('A - Cross-border activity'!B98=\"\", \"OK\", IF(AND(SUM('A - Cross-border activity'!C98:Q98)<>0, 'A - Cross-border activity'!R98<>\"\", 'A - Cross-border activity'!S98<>\"\"), \"OK\", 1))","v":"OK"},null,{"$f":"IF(D125=1, \"Ensure that all sections for Eligible counterparties in Lithuania are filled in\", \"\")","v":""}]
[null,78,null,{"$f":"IF('A - Cross-border activity'!B99=\"\", \"OK\", IF(AND(SUM('A - Cross-border activity'!C99:Q99)<>0, 'A - Cross-border activity'!R99<>\"\", 'A - Cross-border activity'!S99<>\"\"), \"OK\", 1))","v":"OK"},null,{"$f":"IF(D126=1, \"Ensure that all sections for Eligible counterparties in Luxembourg are filled in\",\"\")","v":""}]
[null,79,null,{"$f":"IF('A - Cross-border activity'!B100=\"\", \"OK\", IF(AND(SUM('A - Cross-border activity'!C100:Q100)<>0, 'A - Cross-border activity'!R100<>\"\", 'A - Cross-border activity'!S100<>\"\"), \"OK\", 1))","v":"OK"},null,{"$f":"IF(D126=1, \"Ensure that all sections for Eligible counterparties in Netherlands are filled in\", \"\")","v":""}]
[null,80,null,{"$f":"IF('A - Cross-border activity'!B101=\"\", \"OK\", IF(AND(SUM('A - Cross-border activity'!C101:Q101)<>0, 'A - Cross-border activity'!R101<>\"\", 'A - Cross-border activity'!S101<>\"\"), \"OK\", 1))","v":"OK"},null,{"$f":"IF(D128=1, \"Ensure that all sections for Eligible counterparties in Norway are filled in\", \"\")","v":""}]
[null,81,null,{"$f":"IF('A - Cross-border activity'!B102=\"\", \"OK\", IF(AND(SUM('A - Cross-border activity'!C102:Q102)<>0, 'A - Cross-border activity'!R102<>\"\", 'A - Cross-border activity'!S102<>\"\"), \"OK\", 1))","v":"OK"},null,{"$f":"IF(D129=1, \"Ensure that all sections for Eligible counterparties in Poland are filled in\", \"\")","v":""}]
[null,82,null,{"$f":"IF('A - Cross-border activity'!B103=\"\", \"OK\", IF(AND(SUM('A - Cross-border activity'!C103:Q103)<>0, 'A - Cross-border activity'!R103<>\"\", 'A - Cross-border activity'!S103<>\"\"), \"OK\", 1))","v":"OK"},null,{"$f":"IF(D130=1, \"Ensure that all sections for Eligible counterparties in Portugal are filled in\", \"\")","v":""}]
[null,83,null,{"$f":"IF('A - Cross-border activity'!B104=\"\", \"OK\", IF(AND(SUM('A - Cross-border activity'!C104:Q104)<>0, 'A - Cross-border activity'!R104<>\"\", 'A - Cross-border activity'!S104<>\"\"), \"OK\", 1))","v":"OK"},null,{"$f":"IF(D131=1, \"Ensure that all sections for Eligible counterparties in Romania are filled in\", \"\")","v":""}]
[null,84,null,{"$f":"IF('A - Cross-border activity'!B105=\"\", \"OK\", IF(AND(SUM('A - Cross-border activity'!C105:Q105)<>0, 'A - Cross-border activity'!R105<>\"\", 'A - Cross-border activity'!S105<>\"\"), \"OK\", 1))","v":"OK"},null,{"$f":"IF(D132=1, \"Ensure that all sections for Eligible counterparties in Slovakia are filled in\", \"\")","v":""}]
[null,85,null,{"$f":"IF('A - Cross-border activity'!B106=\"\", \"OK\", IF(AND(SUM('A - Cross-border activity'!C106:Q106)<>0, 'A - Cross-border activity'!R106<>\"\", 'A - Cross-border activity'!S106<>\"\"), \"OK\", 1))","v":"OK"},null,{"$f":"IF(D133=1, \"Ensure that all sections for Eligible counterparties in Slovenia are filled in\", \"\")","v":""}]
[null,86,null,{"$f":"IF('A - Cross-border activity'!B107=\"\", \"OK\", IF(AND(SUM('A - Cross-border activity'!C107:Q107)<>0, 'A - Cross-border activity'!R107<>\"\", 'A - Cross-border activity'!S107<>\"\"), \"OK\", 1))","v":"OK"},null,{"$f":"IF(D134=1, \"Ensure that all sections for Eligible counterparties in Spain are filled in\", \"\")","v":""}]
[null,87,null,{"$f":"IF('A - Cross-border activity'!B108=\"\", \"OK\", IF(AND(SUM('A - Cross-border activity'!C108:Q108)<>0, 'A - Cross-border activity'!R108<>\"\", 'A - Cross-border activity'!S108<>\"\"), \"OK\", 1))","v":"OK"},null,{"$f":"IF(D135=1, \"Ensure that all sections for Eligible counterparties in Sweden are filled in\",\"\")","v":""}]
[null,88,null,{"$f":"IF(AND(SUM('A - Cross-border activity'!C10:Q10)=0, 'A - Cross-border activity'!R10=\"\", 'A - Cross-border activity'!S10=\"\"), \"OK\", IF('A - Cross-border activity'!B10<>\"\", \"OK\", 1))","v":"OK"},null,{"$f":"IF(D136=1, \"Ensure that column B is filled in for each jurisdition where the Company reported clients\",\"\")","v":""}]
[null,89,null,{"$f":"IF(AND(SUM('A - Cross-border activity'!C11:Q11)=0, 'A - Cross-border activity'!R11=\"\", 'A - Cross-border activity'!S11=\"\"), \"OK\", IF('A - Cross-border activity'!B11<>\"\", \"OK\", 1))","v":"OK"},null,{"$f":"IF(D137=1, \"Ensure that column B is filled in for each jurisdition where the Company reported clients\",\"\")","v":""}]
[null,90,null,{"$f":"IF(AND(SUM('A - Cross-border activity'!C12:Q12)=0, 'A - Cross-border activity'!R12=\"\", 'A - Cross-border activity'!S12=\"\"), \"OK\", IF('A - Cross-border activity'!B12<>\"\", \"OK\", 1))","v":"OK"},null,""]
[null,91,null,{"$f":"IF(AND(SUM('A - Cross-border activity'!C13:Q13)=0, 'A - Cross-border activity'!R13=\"\", 'A - Cross-border activity'!S13=\"\"), \"OK\", IF('A - Cross-border activity'!B13<>\"\", \"OK\", 1))","v":"OK"},null,""]
[null,92,null,{"$f":"IF(AND(SUM('A - Cross-border activity'!C14:Q14)=0, 'A - Cross-border activity'!R14=\"\", 'A - Cross-border activity'!S14=\"\"), \"OK\", IF('A - Cross-border activity'!B14<>\"\", \"OK\", 1))","v":"OK"},null,""]
[null,93,null,{"$f":"IF(AND(SUM('A - Cross-border activity'!C15:Q15)=0, 'A - Cross-border activity'!R15=\"\", 'A - Cross-border activity'!S15=\"\"), \"OK\", IF('A - Cross-border activity'!B15<>\"\", \"OK\", 1))","v":"OK"},null,""]
[null,94,null,{"$f":"IF(AND(SUM('A - Cross-border activity'!C16:Q16)=0, 'A - Cross-border activity'!R16=\"\", 'A - Cross-border activity'!S16=\"\"), \"OK\", IF('A - Cross-border activity'!B16<>\"\", \"OK\", 1))","v":"OK"},null,""]
[null,95,null,{"$f":"IF(AND(SUM('A - Cross-border activity'!C17:Q17)=0, 'A - Cross-border activity'!R17=\"\", 'A - Cross-border activity'!S17=\"\"), \"OK\", IF('A - Cross-border activity'!B17<>\"\", \"OK\", 1))","v":"OK"},null,""]
[null,96,null,{"$f":"IF(AND(SUM('A - Cross-border activity'!C18:Q18)=0, 'A - Cross-border activity'!R18=\"\", 'A - Cross-border activity'!S18=\"\"), \"OK\", IF('A - Cross-border activity'!B18<>\"\", \"OK\", 1))","v":"OK"},null,""]
[null,97,null,{"$f":"IF(AND(SUM('A - Cross-border activity'!C19:Q19)=0, 'A - Cross-border activity'!R19=\"\", 'A - Cross-border activity'!S19=\"\"), \"OK\", IF('A - Cross-border activity'!B19<>\"\", \"OK\", 1))","v":"OK"},null,""]
[null,98,null,{"$f":"IF(AND(SUM('A - Cross-border activity'!C20:Q20)=0, 'A - Cross-border activity'!R20=\"\", 'A - Cross-border activity'!S20=\"\"), \"OK\", IF('A - Cross-border activity'!B20<>\"\", \"OK\", 1))","v":"OK"},null,""]
[null,99,null,{"$f":"IF(AND(SUM('A - Cross-border activity'!C21:Q21)=0, 'A - Cross-border activity'!R21=\"\", 'A - Cross-border activity'!S21=\"\"), \"OK\", IF('A - Cross-border activity'!B21<>\"\", \"OK\", 1))","v":"OK"},null,""]
[null,100,null,{"$f":"IF(AND(SUM('A - Cross-border activity'!C22:Q22)=0, 'A - Cross-border activity'!R22=\"\", 'A - Cross-border activity'!S22=\"\"), \"OK\", IF('A - Cross-border activity'!B22<>\"\", \"OK\", 1))","v":"OK"},null,""]
[null,101,null,{"$f":"IF(AND(SUM('A - Cross-border activity'!C23:Q23)=0, 'A - Cross-border activity'!R23=\"\", 'A - Cross-border activity'!S23=\"\"), \"OK\", IF('A - Cross-border activity'!B23<>\"\", \"OK\", 1))","v":"OK"},null,""]
[null,102,null,{"$f":"IF(AND(SUM('A - Cross-border activity'!C24:Q24)=0, 'A - Cross-border activity'!R24=\"\", 'A - Cross-border activity'!S24=\"\"), \"OK\", IF('A - Cross-border activity'!B24<>\"\", \"OK\", 1))","v":"OK"},null,""]
[null,103,null,{"$f":"IF(AND(SUM('A - Cross-border activity'!C25:Q25)=0, 'A - Cross-border activity'!R25=\"\", 'A - Cross-border activity'!S25=\"\"), \"OK\", IF('A - Cross-border activity'!B25<>\"\", \"OK\", 1))","v":"OK"},null,""]
[null,104,null,{"$f":"IF(AND(SUM('A - Cross-border activity'!C26:Q26)=0, 'A - Cross-border activity'!R26=\"\", 'A - Cross-border activity'!S26=\"\"), \"OK\", IF('A - Cross-border activity'!B26<>\"\", \"OK\", 1))","v":"OK"},null,""]
[null,105,null,{"$f":"IF(AND(SUM('A - Cross-border activity'!C27:Q27)=0, 'A - Cross-border activity'!R27=\"\", 'A - Cross-border activity'!S27=\"\"), \"OK\", IF('A - Cross-border activity'!B27<>\"\", \"OK\", 1))","v":"OK"},null,""]
[null,106,null,{"$f":"IF(AND(SUM('A - Cross-border activity'!C28:Q28)=0, 'A - Cross-border activity'!R28=\"\", 'A - Cross-border activity'!S28=\"\"), \"OK\", IF('A - Cross-border activity'!B28<>\"\", \"OK\", 1))","v":"OK"},null,""]
[null,107,null,{"$f":"IF(AND(SUM('A - Cross-border activity'!C29:Q29)=0, 'A - Cross-border activity'!R29=\"\", 'A - Cross-border activity'!S29=\"\"), \"OK\", IF('A - Cross-border activity'!B29<>\"\", \"OK\", 1))","v":"OK"},null,""]
[null,108,null,{"$f":"IF(AND(SUM('A - Cross-border activity'!C30:Q30)=0, 'A - Cross-border activity'!R30=\"\", 'A - Cross-border activity'!S30=\"\"), \"OK\", IF('A - Cross-border activity'!B30<>\"\", \"OK\", 1))","v":"OK"},null,""]
[null,109,null,{"$f":"IF(AND(SUM('A - Cross-border activity'!C31:Q31)=0, 'A - Cross-border activity'!R31=\"\", 'A - Cross-border activity'!S31=\"\"), \"OK\", IF('A - Cross-border activity'!B31<>\"\", \"OK\", 1))","v":"OK"},null,""]
[null,110,null,{"$f":"IF(AND(SUM('A - Cross-border activity'!C32:Q32)=0, 'A - Cross-border activity'!R32=\"\", 'A - Cross-border activity'!S32=\"\"), \"OK\", IF('A - Cross-border activity'!B32<>\"\", \"OK\", 1))","v":"OK"},null,""]
[null,111,null,{"$f":"IF(AND(SUM('A - Cross-border activity'!C33:Q33)=0, 'A - Cross-border activity'!R33=\"\", 'A - Cross-border activity'!S33=\"\"), \"OK\", IF('A - Cross-border activity'!B33<>\"\", \"OK\", 1))","v":"OK"},null,""]
[null,112,null,{"$f":"IF(AND(SUM('A - Cross-border activity'!C34:Q34)=0, 'A - Cross-border activity'!R34=\"\", 'A - Cross-border activity'!S34=\"\"), \"OK\", IF('A - Cross-border activity'!B34<>\"\", \"OK\", 1))","v":"OK"},null,""]
[null,113,null,{"$f":"IF(AND(SUM('A - Cross-border activity'!C35:Q35)=0, 'A - Cross-border activity'!R35=\"\", 'A - Cross-border activity'!S35=\"\"), \"OK\", IF('A - Cross-border activity'!B35<>\"\", \"OK\", 1))","v":"OK"},null,""]
[null,114,null,{"$f":"IF(AND(SUM('A - Cross-border activity'!C36:Q36)=0, 'A - Cross-border activity'!R36=\"\", 'A - Cross-border activity'!S36=\"\"), \"OK\", IF('A - Cross-border activity'!B36<>\"\", \"OK\", 1))","v":"OK"},null,""]
[null,115,null,{"$f":"IF(AND(SUM('A - Cross-border activity'!C37:Q37)=0, 'A - Cross-border activity'!R37=\"\", 'A - Cross-border activity'!S37=\"\"), \"OK\", IF('A - Cross-border activity'!B37<>\"\", \"OK\", 1))","v":"OK"},null,""]
[null,116,null,{"$f":"IF(AND(SUM('A - Cross-border activity'!C38:Q38)=0, 'A - Cross-border activity'!R38=\"\", 'A - Cross-border activity'!S38=\"\"), \"OK\", IF('A - Cross-border activity'!B38<>\"\", \"OK\", 1))","v":"OK"},null,""]
[null,117,null,{"$f":"IF(AND(SUM('A - Cross-border activity'!C45:Q45)=0, 'A - Cross-border activity'!R45=\"\", 'A - Cross-border activity'!S45=\"\"), \"OK\", IF('A - Cross-border activity'!B45<>\"\", \"OK\", 1))","v":"OK"},null,""]
[null,118,null,{"$f":"IF(AND(SUM('A - Cross-border activity'!C46:Q46)=0, 'A - Cross-border activity'!R46=\"\", 'A - Cross-border activity'!S46=\"\"), \"OK\", IF('A - Cross-border activity'!B46<>\"\", \"OK\", 1))","v":"OK"},null,""]
[null,119,null,{"$f":"IF(AND(SUM('A - Cross-border activity'!C47:Q47)=0, 'A - Cross-border activity'!R47=\"\", 'A - Cross-border activity'!S47=\"\"), \"OK\", IF('A - Cross-border activity'!B47<>\"\", \"OK\", 1))","v":"OK"},null,""]
[null,120,null,{"$f":"IF(AND(SUM('A - Cross-border activity'!C48:Q48)=0, 'A - Cross-border activity'!R48=\"\", 'A - Cross-border activity'!S48=\"\"), \"OK\", IF('A - Cross-border activity'!B48<>\"\", \"OK\", 1))","v":"OK"},null,""]
[null,121,null,{"$f":"IF(AND(SUM('A - Cross-border activity'!C49:Q49)=0, 'A - Cross-border activity'!R49=\"\", 'A - Cross-border activity'!S49=\"\"), \"OK\", IF('A - Cross-border activity'!B49<>\"\", \"OK\", 1))","v":"OK"},null,""]
[null,122,null,{"$f":"IF(AND(SUM('A - Cross-border activity'!C50:Q50)=0, 'A - Cross-border activity'!R50=\"\", 'A - Cross-border activity'!S50=\"\"), \"OK\", IF('A - Cross-border activity'!B50<>\"\", \"OK\", 1))","v":"OK"},null,""]
[null,123,null,{"$f":"IF(AND(SUM('A - Cross-border activity'!C51:Q51)=0, 'A - Cross-border activity'!R51=\"\", 'A - Cross-border activity'!S51=\"\"), \"OK\", IF('A - Cross-border activity'!B51<>\"\", \"OK\", 1))","v":"OK"},null,""]
[null,124,null,{"$f":"IF(AND(SUM('A - Cross-border activity'!C52:Q52)=0, 'A - Cross-border activity'!R52=\"\", 'A - Cross-border activity'!S52=\"\"), \"OK\", IF('A - Cross-border activity'!B52<>\"\", \"OK\", 1))","v":"OK"},null,""]
[null,125,null,{"$f":"IF(AND(SUM('A - Cross-border activity'!C53:Q53)=0, 'A - Cross-border activity'!R53=\"\", 'A - Cross-border activity'!S53=\"\"), \"OK\", IF('A - Cross-border activity'!B53<>\"\", \"OK\", 1))","v":"OK"},null,""]
[null,126,null,{"$f":"IF(AND(SUM('A - Cross-border activity'!C54:Q54)=0, 'A - Cross-border activity'!R54=\"\", 'A - Cross-border activity'!S54=\"\"), \"OK\", IF('A - Cross-border activity'!B54<>\"\", \"OK\", 1))","v":"OK"},null,""]
[null,127,null,{"$f":"IF(AND(SUM('A - Cross-border activity'!C55:Q55)=0, 'A - Cross-border activity'!R55=\"\", 'A - Cross-border activity'!S55=\"\"), \"OK\", IF('A - Cross-border activity'!B55<>\"\", \"OK\", 1))","v":"OK"},null,""]
[null,128,null,{"$f":"IF(AND(SUM('A - Cross-border activity'!C56:Q56)=0, 'A - Cross-border activity'!R56=\"\", 'A - Cross-border activity'!S56=\"\"), \"OK\", IF('A - Cross-border activity'!B56<>\"\", \"OK\", 1))","v":"OK"},null,""]
[null,129,null,{"$f":"IF(AND(SUM('A - Cross-border activity'!C57:Q57)=0, 'A - Cross-border activity'!R57=\"\", 'A - Cross-border activity'!S57=\"\"), \"OK\", IF('A - Cross-border activity'!B57<>\"\", \"OK\", 1))","v":"OK"},null,""]
[null,130,null,{"$f":"IF(AND(SUM('A - Cross-border activity'!C58:Q58)=0, 'A - Cross-border activity'!R58=\"\", 'A - Cross-border activity'!S58=\"\"), \"OK\", IF('A - Cross-border activity'!B58<>\"\", \"OK\", 1))","v":"OK"},null,""]
[null,131,null,{"$f":"IF(AND(SUM('A - Cross-border activity'!C59:Q59)=0, 'A - Cross-border activity'!R59=\"\", 'A - Cross-border activity'!S59=\"\"), \"OK\", IF('A - Cross-border activity'!B59<>\"\", \"OK\", 1))","v":"OK"},null,""]
[null,132,null,{"$f":"IF(AND(SUM('A - Cross-border activity'!C60:Q60)=0, 'A - Cross-border activity'!R60=\"\", 'A - Cross-border activity'!S60=\"\"), \"OK\", IF('A - Cross-border activity'!B60<>\"\", \"OK\", 1))","v":"OK"},null,""]
[null,133,null,{"$f":"IF(AND(SUM('A - Cross-border activity'!C61:Q61)=0, 'A - Cross-border activity'!R61=\"\", 'A - Cross-border activity'!S61=\"\"), \"OK\", IF('A - Cross-border activity'!B61<>\"\", \"OK\", 1))","v":"OK"},null,""]
[null,134,null,{"$f":"IF(AND(SUM('A - Cross-border activity'!C62:Q62)=0, 'A - Cross-border activity'!R62=\"\", 'A - Cross-border activity'!S62=\"\"), \"OK\", IF('A - Cross-border activity'!B62<>\"\", \"OK\", 1))","v":"OK"},null,""]
[null,135,null,{"$f":"IF(AND(SUM('A - Cross-border activity'!C63:Q63)=0, 'A - Cross-border activity'!R63=\"\", 'A - Cross-border activity'!S63=\"\"), \"OK\", IF('A - Cross-border activity'!B63<>\"\", \"OK\", 1))","v":"OK"},null,""]
[null,136,null,{"$f":"IF(AND(SUM('A - Cross-border activity'!C64:Q64)=0, 'A - Cross-border activity'!R64=\"\", 'A - Cross-border activity'!S64=\"\"), \"OK\", IF('A - Cross-border activity'!B64<>\"\", \"OK\", 1))","v":"OK"},null,""]
[null,137,null,{"$f":"IF(AND(SUM('A - Cross-border activity'!C65:Q65)=0, 'A - Cross-border activity'!R65=\"\", 'A - Cross-border activity'!S65=\"\"), \"OK\", IF('A - Cross-border activity'!B65<>\"\", \"OK\", 1))","v":"OK"},null,""]
[null,138,null,{"$f":"IF(AND(SUM('A - Cross-border activity'!C66:Q66)=0, 'A - Cross-border activity'!R66=\"\", 'A - Cross-border activity'!S66=\"\"), \"OK\", IF('A - Cross-border activity'!B66<>\"\", \"OK\", 1))","v":"OK"},null,""]
[null,139,null,{"$f":"IF(AND(SUM('A - Cross-border activity'!C67:Q67)=0, 'A - Cross-border activity'!R67=\"\", 'A - Cross-border activity'!S67=\"\"), \"OK\", IF('A - Cross-border activity'!B67<>\"\", \"OK\", 1))","v":"OK"},null,""]
[null,140,null,{"$f":"IF(AND(SUM('A - Cross-border activity'!C68:Q68)=0, 'A - Cross-border activity'!R68=\"\", 'A - Cross-border activity'!S68=\"\"), \"OK\", IF('A - Cross-border activity'!B68<>\"\", \"OK\", 1))","v":"OK"},null,""]
[null,141,null,{"$f":"IF(AND(SUM('A - Cross-border activity'!C69:Q69)=0, 'A - Cross-border activity'!R69=\"\", 'A - Cross-border activity'!S69=\"\"), \"OK\", IF('A - Cross-border activity'!B69<>\"\", \"OK\", 1))","v":"OK"},null,""]
[null,142,null,{"$f":"IF(AND(SUM('A - Cross-border activity'!C70:Q70)=0, 'A - Cross-border activity'!R70=\"\", 'A - Cross-border activity'!S70=\"\"), \"OK\", IF('A - Cross-border activity'!B70<>\"\", \"OK\", 1))","v":"OK"},null,""]
[null,143,null,{"$f":"IF(AND(SUM('A - Cross-border activity'!C71:Q71)=0, 'A - Cross-border activity'!R71=\"\", 'A - Cross-border activity'!S71=\"\"), \"OK\", IF('A - Cross-border activity'!B71<>\"\", \"OK\", 1))","v":"OK"},null,""]
[null,144,null,{"$f":"IF(AND(SUM('A - Cross-border activity'!C72:Q72)=0, 'A - Cross-border activity'!R72=\"\", 'A - Cross-border activity'!S72=\"\"), \"OK\", IF('A - Cross-border activity'!B72<>\"\", \"OK\", 1))","v":"OK"},null,""]
[null,145,null,{"$f":"IF(AND(SUM('A - Cross-border activity'!C73:Q73)=0, 'A - Cross-border activity'!R73=\"\", 'A - Cross-border activity'!S73=\"\"), \"OK\", IF('A - Cross-border activity'!B73<>\"\", \"OK\", 1))","v":"OK"},null,""]
[null,146,null,{"$f":"IF(AND(SUM('A - Cross-border activity'!C80:Q80)=0, 'A - Cross-border activity'!R80=\"\", 'A - Cross-border activity'!S80=\"\"), \"OK\", IF('A - Cross-border activity'!B80<>\"\", \"OK\", 1))","v":"OK"},null,""]
[null,147,null,{"$f":"IF(AND(SUM('A - Cross-border activity'!C81:Q81)=0, 'A - Cross-border activity'!R81=\"\", 'A - Cross-border activity'!S81=\"\"), \"OK\", IF('A - Cross-border activity'!B81<>\"\", \"OK\", 1))","v":"OK"},null,""]
[null,148,null,{"$f":"IF(AND(SUM('A - Cross-border activity'!C82:Q82)=0, 'A - Cross-border activity'!R82=\"\", 'A - Cross-border activity'!S82=\"\"), \"OK\", IF('A - Cross-border activity'!B82<>\"\", \"OK\", 1))","v":"OK"},null,""]
[null,149,null,{"$f":"IF(AND(SUM('A - Cross-border activity'!C83:Q83)=0, 'A - Cross-border activity'!R83=\"\", 'A - Cross-border activity'!S83=\"\"), \"OK\", IF('A - Cross-border activity'!B83<>\"\", \"OK\", 1))","v":"OK"},null,""]
[null,150,null,{"$f":"IF(AND(SUM('A - Cross-border activity'!C84:Q84)=0, 'A - Cross-border activity'!R84=\"\", 'A - Cross-border activity'!S84=\"\"), \"OK\", IF('A - Cross-border activity'!B84<>\"\", \"OK\", 1))","v":"OK"},null,""]
[null,151,null,{"$f":"IF(AND(SUM('A - Cross-border activity'!C85:Q85)=0, 'A - Cross-border activity'!R85=\"\", 'A - Cross-border activity'!S85=\"\"), \"OK\", IF('A - Cross-border activity'!B85<>\"\", \"OK\", 1))","v":"OK"},null,""]
[null,152,null,{"$f":"IF(AND(SUM('A - Cross-border activity'!C86:Q86)=0, 'A - Cross-border activity'!R86=\"\", 'A - Cross-border activity'!S86=\"\"), \"OK\", IF('A - Cross-border activity'!B86<>\"\", \"OK\", 1))","v":"OK"},null,""]
[null,153,null,{"$f":"IF(AND(SUM('A - Cross-border activity'!C87:Q87)=0, 'A - Cross-border activity'!R87=\"\", 'A - Cross-border activity'!S87=\"\"), \"OK\", IF('A - Cross-border activity'!B87<>\"\", \"OK\", 1))","v":"OK"},null,{"$f":"IF(D201=1, \"Ensure that column B is filled in for each jurisdition where the Company reported clients\",\"\")","v":""}]
[null,154,null,{"$f":"IF(AND(SUM('A - Cross-border activity'!C88:Q88)=0, 'A - Cross-border activity'!R88=\"\", 'A - Cross-border activity'!S88=\"\"), \"OK\", IF('A - Cross-border activity'!B88<>\"\", \"OK\", 1))","v":"OK"},null,""]
[null,155,null,{"$f":"IF(AND(SUM('A - Cross-border activity'!C89:Q89)=0, 'A - Cross-border activity'!R89=\"\", 'A - Cross-border activity'!S89=\"\"), \"OK\", IF('A - Cross-border activity'!B89<>\"\", \"OK\", 1))","v":"OK"},null,""]
[null,156,null,{"$f":"IF(AND(SUM('A - Cross-border activity'!C90:Q90)=0, 'A - Cross-border activity'!R90=\"\", 'A - Cross-border activity'!S90=\"\"), \"OK\", IF('A - Cross-border activity'!B90<>\"\", \"OK\", 1))","v":"OK"},null,""]
[null,157,null,{"$f":"IF(AND(SUM('A - Cross-border activity'!C91:Q91)=0, 'A - Cross-border activity'!R91=\"\", 'A - Cross-border activity'!S91=\"\"), \"OK\", IF('A - Cross-border activity'!B91<>\"\", \"OK\", 1))","v":"OK"},null,""]
[null,158,null,{"$f":"IF(AND(SUM('A - Cross-border activity'!C92:Q92)=0, 'A - Cross-border activity'!R92=\"\", 'A - Cross-border activity'!S92=\"\"), \"OK\", IF('A - Cross-border activity'!B92<>\"\", \"OK\", 1))","v":"OK"},null,""]
[null,159,null,{"$f":"IF(AND(SUM('A - Cross-border activity'!C93:Q93)=0, 'A - Cross-border activity'!R93=\"\", 'A - Cross-border activity'!S93=\"\"), \"OK\", IF('A - Cross-border activity'!B93<>\"\", \"OK\", 1))","v":"OK"},null,""]
[null,160,null,{"$f":"IF(AND(SUM('A - Cross-border activity'!C94:Q94)=0, 'A - Cross-border activity'!R94=\"\", 'A - Cross-border activity'!S94=\"\"), \"OK\", IF('A - Cross-border activity'!B94<>\"\", \"OK\", 1))","v":"OK"},null,""]
[null,161,null,{"$f":"IF(AND(SUM('A - Cross-border activity'!C95:Q95)=0, 'A - Cross-border activity'!R95=\"\", 'A - Cross-border activity'!S95=\"\"), \"OK\", IF('A - Cross-border activity'!B95<>\"\", \"OK\", 1))","v":"OK"},null,""]
[null,162,null,{"$f":"IF(AND(SUM('A - Cross-border activity'!C96:Q96)=0, 'A - Cross-border activity'!R96=\"\", 'A - Cross-border activity'!S96=\"\"), \"OK\", IF('A - Cross-border activity'!B96<>\"\", \"OK\", 1))","v":"OK"},null,""]
[null,163,null,{"$f":"IF(AND(SUM('A - Cross-border activity'!C97:Q97)=0, 'A - Cross-border activity'!R97=\"\", 'A - Cross-border activity'!S97=\"\"), \"OK\", IF('A - Cross-border activity'!B97<>\"\", \"OK\", 1))","v":"OK"},null,""]
[null,164,null,{"$f":"IF(AND(SUM('A - Cross-border activity'!C98:Q98)=0, 'A - Cross-border activity'!R98=\"\", 'A - Cross-border activity'!S98=\"\"), \"OK\", IF('A - Cross-border activity'!B98<>\"\", \"OK\", 1))","v":"OK"},null,""]
[null,165,null,{"$f":"IF(AND(SUM('A - Cross-border activity'!C99:Q99)=0, 'A - Cross-border activity'!R99=\"\", 'A - Cross-border activity'!S99=\"\"), \"OK\", IF('A - Cross-border activity'!B99<>\"\", \"OK\", 1))","v":"OK"},null,""]
[null,166,null,{"$f":"IF(AND(SUM('A - Cross-border activity'!C100:Q100)=0, 'A - Cross-border activity'!R100=\"\", 'A - Cross-border activity'!S100=\"\"), \"OK\", IF('A - Cross-border activity'!B100<>\"\", \"OK\", 1))","v":"OK"},null,""]
[null,167,null,{"$f":"IF(AND(SUM('A - Cross-border activity'!C101:Q101)=0, 'A - Cross-border activity'!R101=\"\", 'A - Cross-border activity'!S101=\"\"), \"OK\", IF('A - Cross-border activity'!B101<>\"\", \"OK\", 1))","v":"OK"},null,""]
[null,168,null,{"$f":"IF(AND(SUM('A - Cross-border activity'!C102:Q102)=0, 'A - Cross-border activity'!R102=\"\", 'A - Cross-border activity'!S102=\"\"), \"OK\", IF('A - Cross-border activity'!B102<>\"\", \"OK\", 1))","v":"OK"},null,""]
[null,169,null,{"$f":"IF(AND(SUM('A - Cross-border activity'!C103:Q103)=0, 'A - Cross-border activity'!R103=\"\", 'A - Cross-border activity'!S103=\"\"), \"OK\", IF('A - Cross-border activity'!B103<>\"\", \"OK\", 1))","v":"OK"},null,""]
[null,170,null,{"$f":"IF(AND(SUM('A - Cross-border activity'!C104:Q104)=0, 'A - Cross-border activity'!R104=\"\", 'A - Cross-border activity'!S104=\"\"), \"OK\", IF('A - Cross-border activity'!B104<>\"\", \"OK\", 1))","v":"OK"},null,""]
[null,171,null,{"$f":"IF(AND(SUM('A - Cross-border activity'!C105:Q105)=0, 'A - Cross-border activity'!R105=\"\", 'A - Cross-border activity'!S105=\"\"), \"OK\", IF('A - Cross-border activity'!B105<>\"\", \"OK\", 1))","v":"OK"},null,""]
[null,172,null,{"$f":"IF(AND(SUM('A - Cross-border activity'!C106:Q106)=0, 'A - Cross-border activity'!R106=\"\", 'A - Cross-border activity'!S106=\"\"), \"OK\", IF('A - Cross-border activity'!B106<>\"\", \"OK\", 1))","v":"OK"},null,""]
[null,173,null,{"$f":"IF(AND(SUM('A - Cross-border activity'!C107:Q107)=0, 'A - Cross-border activity'!R107=\"\", 'A - Cross-border activity'!S107=\"\"), \"OK\", IF('A - Cross-border activity'!B107<>\"\", \"OK\", 1))","v":"OK"},null,""]
[null,174,null,{"$f":"IF(AND(SUM('A - Cross-border activity'!C108:Q108)=0, 'A - Cross-border activity'!R108=\"\", 'A - Cross-border activity'!S108=\"\"), \"OK\", IF('A - Cross-border activity'!B108<>\"\", \"OK\", 1))","v":"OK"},{"$f":"SUM(D49:D222)","v":0},""]
[]
["A - RIT",1,null,{"$f":"IF(OR('A - Retail Investor Trends'!F5=\"Yes\", 'A - Retail Investor Trends'!F5=\"No\", 'A - Retail Investor Trends'!F5=\"N/A\"), \"OK\", 1)","v":1},null,{"$f":"IF(D224=1, \"Ensure that Question 1 is filled in\", \"\")","v":"Ensure that Question 1 is filled in"}]
[null,2,null,{"$f":"IF(OR('A - Retail Investor Trends'!F5=\"No\", 'A - Retail Investor Trends'!F5=\"N/A\"), \"OK\", IF(SUM('A - Retail Investor Trends'!B11:B19)=1,\"OK\",1))","v":1},null,{"$f":"IF(D225=1, \"Ensure that the sum indicated in Question 2 is equal to 100%\", \"\")","v":"Ensure that the sum indicated in Question 2 is equal to 100%"}]
[null,3,null,{"$f":"IF(OR('A - Retail Investor Trends'!B19=\"\", 'A - Retail Investor Trends'!B19=0), \"OK\", IF('A - Retail Investor Trends'!A22<>\"\", \"OK\", 1))","v":"OK"},null,{"$f":"IF(D226=1, \"Ensure that Question 2.1 is replied, if a % is included under 'Other' in Question 2\", \"\")","v":""}]
[null,4,null,{"$f":"IF(OR('A - Retail Investor Trends'!F5=\"No\",'A - Retail Investor Trends'!F5=\"N/A\"),\"OK\",IF(OR('A - Retail Investor Trends'!B26=\"Yes\", 'A - Retail Investor Trends'!B26=\"No\", 'A - Retail Investor Trends'!B26=\"N/A\", 'A - Retail Investor Trends'!B27=\"Yes\", 'A - Retail Investor Trends'!B27=\"No\",'A - Retail Investor Trends'!B27=\"N/A\", 'A - Retail Investor Trends'!B28=\"Yes\",'A - Retail Investor Trends'!B28=\"No\",'A - Retail Investor Trends'!B29=\"N/A\"),\"OK\",1))","v":1},null,{"$f":"IF(D227=1, \"Ensure that Question 3 is replied\", \"\")","v":"Ensure that Question 3 is replied"}]
[null,5,null,{"$f":"IF(OR('A - Retail Investor Trends'!F5=\"No\",'A - Retail Investor Trends'!F5=\"N/A\",'A - Retail Investor Trends'!B26=\"No\",'A - Retail Investor Trends'!B26=\"N/A\", 'A - Retail Investor Trends'!B26=\"\"),\"OK\",IF(AND('A - Retail Investor Trends'!F5=\"Yes\",'A - Retail Investor Trends'!B26=\"Yes\", COUNTIF('A - Retail Investor Trends'!B33:F33, \"X\")>=1),\"OK\",1))","v":"OK"},null,{"$f":"IF(D228=1, \"Ensure that Question 3.1 is replied, if 'Yes' is selected for 'Non-Advisory' in Question 3\",\"\")","v":""}]
[null,6,null,{"$f":"IF(OR('A - Retail Investor Trends'!B26=\"No\",'A - Retail Investor Trends'!B26=\"N/A\", 'A - Retail Investor Trends'!B26=\"\"),\"OK\",IF((COUNTIF('A - Retail Investor Trends'!B33:F33,\"X\"))>=1,\"OK\",1))","v":"OK"},null,{"$f":"IF(D229=1, \"Ensure to indicate the change in client's demand for 'Non-Advisory' in Question 3.1, if this is selected in Question 3\", \"\")","v":""}]
[null,7,null,{"$f":"IF(OR('A - Retail Investor Trends'!F5=\"No\",'A - Retail Investor Trends'!F5=\"N/A\",'A - Retail Investor Trends'!B26=\"No\",'A - Retail Investor Trends'!B26=\"N/A\"),\"OK\",IF(AND('A - Retail Investor Trends'!F5=\"Yes\",'A - Retail Investor Trends'!B26=\"\", COUNTIF('A - Retail Investor Trends'!B33:F33, \"X\")>=1),1,\"OK\"))","v":"OK"},null,{"$f":"IF(D230=1, \"Ensure to select 'Non-Advisory' in Question 3, if the change in client's demand for this service was indicated in Question 3.1\", \"\")","v":""}]
[null,8,null,{"$f":"IF(OR('A - Retail Investor Trends'!F5=\"No\",'A - Retail Investor Trends'!F5=\"N/A\",'A - Retail Investor Trends'!B27=\"No\",'A - Retail Investor Trends'!B27=\"N/A\", 'A - Retail Investor Trends'!B27=\"\"),\"OK\",IF(AND('A - Retail Investor Trends'!F5=\"Yes\",'A - Retail Investor Trends'!B27=\"Yes\", COUNTIF('A - Retail Investor Trends'!B34:F34, \"X\")>=1),\"OK\",1))","v":"OK"},null,{"$f":"IF(D231=1, \"Ensure that Question 3.1 is replied, if 'Yes' is selected for 'Advisory' in Question 3\", \"\")","v":""}]
[null,9,null,{"$f":"IF(OR('A - Retail Investor Trends'!B27=\"No\",'A - Retail Investor Trends'!B27=\"N/A\", 'A - Retail Investor Trends'!B27=\"\"),\"OK\",IF((COUNTIF('A - Retail Investor Trends'!B34:F34, \"X\"))>=1,\"OK\",1))","v":"OK"},null,{"$f":"IF(D232=1, \"Ensure to indicate the change in client's demand for 'Advisory' in Question 3.1, if this is selected in Question 3\", \"\")","v":""}]
[null,10,null,{"$f":"IF(OR('A - Retail Investor Trends'!F5=\"No\",'A - Retail Investor Trends'!F5=\"N/A\",'A - Retail Investor Trends'!B27=\"No\",'A - Retail Investor Trends'!B27=\"N/A\"),\"OK\",IF(AND('A - Retail Investor Trends'!F5=\"Yes\",'A - Retail Investor Trends'!B27=\"\", COUNTIF('A - Retail Investor Trends'!B34:F34, \"X\")>=1),1,\"OK\"))","v":"OK"},null,{"$f":"IF(D233=1, \"Ensure to select 'Advisory' in Question 3, if the change in client's demand for this service was indicated in Question 3.1\", \"\")","v":""}]
[null,11,null,{"$f":"IF(OR('A - Retail Investor Trends'!F5=\"No\",'A - Retail Investor Trends'!F5=\"N/A\",'A - Retail Investor Trends'!B28=\"No\",'A - Retail Investor Trends'!B28=\"N/A\", 'A - Retail Investor Trends'!B28=\"\"),\"OK\",IF(AND('A - Retail Investor Trends'!F5=\"Yes\",'A - Retail Investor Trends'!B28=\"Yes\", COUNTIF('A - Retail Investor Trends'!B35:F35, \"X\")>=1),\"OK\",1))","v":"OK"},null,{"$f":"IF(D234=1, \"Ensure that Question 3.1 is replied, if 'Yes' is selected for 'Wealth/portfolio management' in Question 3\", \"\")","v":""}]
[null,12,null,{"$f":"IF(OR('A - Retail Investor Trends'!B28=\"No\",'A - Retail Investor Trends'!B28=\"N/A\", 'A - Retail Investor Trends'!B28=\"\"),\"OK\",IF((COUNTIF('A - Retail Investor Trends'!B35:F35,\"X\"))>=1,\"OK\",1))","v":"OK"},null,{"$f":"IF(D235=1, \"Ensure to indicate the change in client's demand for 'Wealth/portfolio management' in Question 3.1, if this is selected in Question 3\", \"\")","v":""}]
[null,13,null,{"$f":"IF(OR('A - Retail Investor Trends'!F5=\"No\",'A - Retail Investor Trends'!F5=\"N/A\",'A - Retail Investor Trends'!B28=\"No\",'A - Retail Investor Trends'!B28=\"N/A\"),\"OK\",IF(AND('A - Retail Investor Trends'!F5=\"Yes\",'A - Retail Investor Trends'!B28=\"\", COUNTIF('A - Retail Investor Trends'!B35:F35, \"X\")>=1),1,\"OK\"))","v":"OK"},null,{"$f":"IF(D236=1, \"Ensure to select 'Wealth/portfolio management' in Question 3, if the change in client's demand for this service was indicated in Question 3.1\", \"\")","v":""}]
[null,14,null,{"$f":"IF(COUNTIF('A - Retail Investor Trends'!B33:C35,\"X\")= 0,\"OK\",IF('A - Retail Investor Trends'!A38<>\"\",\"OK\",1))","v":"OK"},null,{"$f":"IF(D237=1, \"Ensure to indicate the reason for the increasing in client's demand in Question 3.1.1\", \"\")","v":""}]
[null,15,null,{"$f":"IF(COUNTIF('A - Retail Investor Trends'!E33:F35,\"X\")= 0,\"OK\",IF('A - Retail Investor Trends'!A46<>\"\",\"OK\",1))","v":"OK"},null,{"$f":"IF(D238=1, \"Ensure to indicate the reason for the decrease in client's demand in Question 3.1.1\", \"\")","v":""}]
[null,16,null,{"$f":"IF('A - Retail Investor Trends'!B11=0, \"OK\", IF(OR('A - Retail Investor Trends'!B56=\"X\", 'A - Retail Investor Trends'!B56=\"N/A\", 'A - Retail Investor Trends'!B57=\"X\", 'A - Retail Investor Trends'!B57=\"N/A\",'A - Retail Investor Trends'!B58=\"X\", 'A - Retail Investor Trends'!B58=\"N/A\", 'A - Retail Investor Trends'!B59=\"X\", 'A - Retail Investor Trends'!B59=\"N/A\", 'A - Retail Investor Trends'!B60=\"X\", 'A - Retail Investor Trends'!B60=\"N/A\", 'A - Retail Investor Trends'!B61=\"X\", 'A - Retail Investor Trends'!B61=\"N/A\",'A - Retail Investor Trends'!B62=\"X\",'A - Retail Investor Trends'!B62=\"N/A\",'A - Retail Investor Trends'!B63=\"X\", 'A - Retail Investor Trends'!B63=\"N/A\",'A - Retail Investor Trends'!B64=\"X\", 'A - Retail Investor Trends'!B64=\"N/A\"), \"OK\", 1))","v":"OK"},null,{"$f":"IF(D239=1, \"Ensure that the column 'Shares' in Question 4 is compiled with either X or N/A, since the product was selected in Question 2\", \"\")","v":""}]
[null,17,null,{"$f":"IF('A - Retail Investor Trends'!B12=0, \"OK\", IF(OR('A - Retail Investor Trends'!C56=\"X\", 'A - Retail Investor Trends'!C56=\"N/A\", 'A - Retail Investor Trends'!C57=\"X\", 'A - Retail Investor Trends'!C57=\"N/A\",'A - Retail Investor Trends'!C58=\"X\", 'A - Retail Investor Trends'!C58=\"N/A\", 'A - Retail Investor Trends'!C59=\"X\", 'A - Retail Investor Trends'!C59=\"N/A\", 'A - Retail Investor Trends'!C60=\"X\", 'A - Retail Investor Trends'!C60=\"N/A\", 'A - Retail Investor Trends'!C61=\"X\", 'A - Retail Investor Trends'!C61=\"N/A\",'A - Retail Investor Trends'!C62=\"X\", 'A - Retail Investor Trends'!C62=\"N/A\",'A - Retail Investor Trends'!C63=\"X\", 'A - Retail Investor Trends'!C63=\"N/A\",'A - Retail Investor Trends'!C64=\"X\", 'A - Retail Investor Trends'!C64=\"N/A\"), \"OK\", 1))","v":"OK"},null,{"$f":"IF(D240=1, \"Ensure that the column 'Bonds' in Question 4 is compiled with either X or N/A, since the product was selected in Question 2\", \"\")","v":""}]
[null,18,null,{"$f":"IF('A - Retail Investor Trends'!B13=0, \"OK\", IF(OR('A - Retail Investor Trends'!D56=\"X\", 'A - Retail Investor Trends'!D56=\"N/A\", 'A - Retail Investor Trends'!D57=\"X\", 'A - Retail Investor Trends'!D57=\"N/A\",'A - Retail Investor Trends'!D58=\"X\", 'A - Retail Investor Trends'!D58=\"N/A\", 'A - Retail Investor Trends'!D59=\"X\", 'A - Retail Investor Trends'!D59=\"N/A\", 'A - Retail Investor Trends'!D60=\"X\", 'A - Retail Investor Trends'!D60=\"N/A\", 'A - Retail Investor Trends'!D61=\"X\", 'A - Retail Investor Trends'!D61=\"N/A\",'A - Retail Investor Trends'!D62=\"X\", 'A - Retail Investor Trends'!D62=\"N/A\",'A - Retail Investor Trends'!D63=\"X\", 'A - Retail Investor Trends'!D63=\"N/A\",'A - Retail Investor Trends'!D64=\"X\", 'A - Retail Investor Trends'!D64=\"N/A\"), \"OK\", 1))","v":"OK"},null,{"$f":"IF(D241=1, \"Ensure that the column 'Structured securities' in Question 4 is compiled with either X or N/A, since the product was selected in Question 2\", \"\")","v":""}]
[null,19,null,{"$f":"IF('A - Retail Investor Trends'!B14=0,\"OK\", IF(OR('A - Retail Investor Trends'!E56=\"X\", 'A - Retail Investor Trends'!E56=\"N/A\", 'A - Retail Investor Trends'!E57=\"X\", 'A - Retail Investor Trends'!E57=\"N/A\",'A - Retail Investor Trends'!E58=\"X\", 'A - Retail Investor Trends'!E58=\"N/A\", 'A - Retail Investor Trends'!E59=\"X\", 'A - Retail Investor Trends'!E59=\"N/A\", 'A - Retail Investor Trends'!E60=\"X\", 'A - Retail Investor Trends'!E60=\"N/A\", 'A - Retail Investor Trends'!E61=\"X\", 'A - Retail Investor Trends'!E61=\"N/A\",'A - Retail Investor Trends'!E62=\"X\", 'A - Retail Investor Trends'!E62=\"N/A\",'A - Retail Investor Trends'!E63=\"X\", 'A - Retail Investor Trends'!E63=\"N/A\",'A - Retail Investor Trends'!E64=\"X\", 'A - Retail Investor Trends'!E64=\"N/A\"), \"OK\", 1))","v":"OK"},null,{"$f":"IF(D242=1, \"Ensure that the column 'Money-market securities' in Question 4 is compiled with either X or N/A, since the product was selected in Question 2\", \"\")","v":""}]
[null,20,null,{"$f":"IF('A - Retail Investor Trends'!B15=0, \"OK\", IF(OR('A - Retail Investor Trends'!F56=\"X\", 'A - Retail Investor Trends'!F56=\"N/A\", 'A - Retail Investor Trends'!F57=\"X\", 'A - Retail Investor Trends'!F57=\"N/A\",'A - Retail Investor Trends'!F58=\"X\", 'A - Retail Investor Trends'!F58=\"N/A\", 'A - Retail Investor Trends'!F59=\"X\", 'A - Retail Investor Trends'!F59=\"N/A\", 'A - Retail Investor Trends'!F60=\"X\", 'A - Retail Investor Trends'!F60=\"N/A\", 'A - Retail Investor Trends'!F61=\"X\", 'A - Retail Investor Trends'!F61=\"N/A\",'A - Retail Investor Trends'!F62=\"X\", 'A - Retail Investor Trends'!F62=\"N/A\",'A - Retail Investor Trends'!F63=\"X\", 'A - Retail Investor Trends'!F63=\"N/A\",'A - Retail Investor Trends'!F64=\"X\", 'A - Retail Investor Trends'!F64=\"N/A\"), \"OK\", 1))","v":"OK"},null,{"$f":"IF(D243=1, \"Ensure that the column 'Units in collective investment undertakings' in Question 4 is compiled with either X or N/A, since the product was selected in Question 2\",\"\")","v":""}]
[null,21,null,{"$f":"IF('A - Retail Investor Trends'!B16=0, \"OK\", IF(OR('A - Retail Investor Trends'!G56=\"X\", 'A - Retail Investor Trends'!G56=\"N/A\", 'A - Retail Investor Trends'!G57=\"X\", 'A - Retail Investor Trends'!G57=\"N/A\",'A - Retail Investor Trends'!G58=\"X\", 'A - Retail Investor Trends'!G58=\"N/A\", 'A - Retail Investor Trends'!G59=\"X\", 'A - Retail Investor Trends'!G59=\"N/A\", 'A - Retail Investor Trends'!G60=\"X\", 'A - Retail Investor Trends'!G60=\"N/A\", 'A - Retail Investor Trends'!G61=\"X\", 'A - Retail Investor Trends'!G61=\"N/A\",'A - Retail Investor Trends'!G62=\"X\", 'A - Retail Investor Trends'!G62=\"N/A\",'A - Retail Investor Trends'!G63=\"X\", 'A - Retail Investor Trends'!G63=\"N/A\",'A - Retail Investor Trends'!G64=\"X\", 'A - Retail Investor Trends'!G64=\"N/A\"), \"OK\", 1))","v":"OK"},null,{"$f":"IF(D244=1, \"Ensure that the column 'Derivatives' in Question 4 is compiled with either X or N/A, since the product was selected in Question 2\", \"\")","v":""}]
[null,22,null,{"$f":"IF('A - Retail Investor Trends'!B17=0, \"OK\", IF(OR('A - Retail Investor Trends'!H56=\"X\", 'A - Retail Investor Trends'!H56=\"N/A\", 'A - Retail Investor Trends'!H57=\"X\", 'A - Retail Investor Trends'!H57=\"N/A\",'A - Retail Investor Trends'!H58=\"X\", 'A - Retail Investor Trends'!H58=\"N/A\", 'A - Retail Investor Trends'!H59=\"X\", 'A - Retail Investor Trends'!H59=\"N/A\", 'A - Retail Investor Trends'!H60=\"X\", 'A - Retail Investor Trends'!H60=\"N/A\", 'A - Retail Investor Trends'!H61=\"X\", 'A - Retail Investor Trends'!H61=\"N/A\",'A - Retail Investor Trends'!H62=\"X\", 'A - Retail Investor Trends'!H62=\"N/A\",'A - Retail Investor Trends'!H63=\"X\", 'A - Retail Investor Trends'!H63=\"N/A\",'A - Retail Investor Trends'!H64=\"X\", 'A - Retail Investor Trends'!H64=\"N/A\"), \"OK\", 1))","v":"OK"},null,{"$f":"IF(D245=1, \"Ensure that the column 'CFDs' in Question 4 is compiled with either X or N/A, since the product was selected in Question 2\",\"\")","v":""}]
[null,23,null,{"$f":"IF('A - Retail Investor Trends'!B18=0, \"OK\", IF(OR('A - Retail Investor Trends'!I56=\"X\", 'A - Retail Investor Trends'!I56=\"N/A\", 'A - Retail Investor Trends'!I57=\"X\", 'A - Retail Investor Trends'!I57=\"N/A\",'A - Retail Investor Trends'!I58=\"X\", 'A - Retail Investor Trends'!I58=\"N/A\", 'A - Retail Investor Trends'!I59=\"X\", 'A - Retail Investor Trends'!I59=\"N/A\", 'A - Retail Investor Trends'!I60=\"X\", 'A - Retail Investor Trends'!I60=\"N/A\", 'A - Retail Investor Trends'!I61=\"X\", 'A - Retail Investor Trends'!I61=\"N/A\",'A - Retail Investor Trends'!I62=\"X\", 'A - Retail Investor Trends'!I62=\"N/A\",'A - Retail Investor Trends'!I63=\"X\", 'A - Retail Investor Trends'!I63=\"N/A\",'A - Retail Investor Trends'!I64=\"X\", 'A - Retail Investor Trends'!I64=\"N/A\"), \"OK\", 1))","v":"OK"},null,{"$f":"IF(D246=1, \"Ensure that the column 'ETFs' in Question 4 is compiled with either X or N/A, since the product was selected in Question 2\", \"\")","v":""}]
[null,24,null,{"$f":"IF('A - Retail Investor Trends'!B19=0, \"OK\", IF(OR('A - Retail Investor Trends'!J56=\"X\", 'A - Retail Investor Trends'!J56=\"N/A\", 'A - Retail Investor Trends'!J57=\"X\", 'A - Retail Investor Trends'!J57=\"N/A\",'A - Retail Investor Trends'!J58=\"X\", 'A - Retail Investor Trends'!J58=\"N/A\", 'A - Retail Investor Trends'!J59=\"X\", 'A - Retail Investor Trends'!J59=\"N/A\", 'A - Retail Investor Trends'!J60=\"X\", 'A - Retail Investor Trends'!J60=\"N/A\", 'A - Retail Investor Trends'!J61=\"X\", 'A - Retail Investor Trends'!J61=\"N/A\",'A - Retail Investor Trends'!J62=\"X\", 'A - Retail Investor Trends'!J62=\"N/A\",'A - Retail Investor Trends'!J63=\"X\", 'A - Retail Investor Trends'!J63=\"N/A\",'A - Retail Investor Trends'!J64=\"X\", 'A - Retail Investor Trends'!J64=\"N/A\"), \"OK\", 1))","v":"OK"},null,{"$f":"IF(D247=1, \"Ensure that the column 'Other Financial Instruments' in Question 4 is compiled with either X or N/A, since the product was selected in Question 2\", \"\")","v":""}]
[null,25,null,{"$f":"IF((COUNTIF('A - Retail Investor Trends'!B56:B64,\"X\"))=0, \"OK\", IF('A - Retail Investor Trends'!B11<>\"\", \"OK\", 1))","v":"OK"},null,{"$f":"IF(D248=1, \"Ensure that the column 'Shares' is selected in Question 2, since one or more method of communication were selected in Question 4\", \"\")","v":""}]
[null,26,null,{"$f":"IF((COUNTIF('A - Retail Investor Trends'!C$56:C$64,\"X\"))=0, \"OK\", IF('A - Retail Investor Trends'!B12<>\"\", \"OK\", 1))","v":"OK"},null,{"$f":"IF(D249=1, \"Ensure that the column 'Bonds' is selected in Question 2, since one or more method of communication were selected in Question 4\", \"\")","v":""}]
[null,27,null,{"$f":"IF((COUNTIF('A - Retail Investor Trends'!D$56:D$64,\"X\"))=0, \"OK\", IF('A - Retail Investor Trends'!B13<>\"\", \"OK\", 1))","v":"OK"},null,{"$f":"IF(D250=1, \"Ensure that the column 'Structured Securities' is selected in Question 2, since one or more method of communication were selected in Question 4\", \"\")","v":""}]
[null,28,null,{"$f":"IF((COUNTIF('A - Retail Investor Trends'!E$56:E$64,\"X\"))=0, \"OK\", IF('A - Retail Investor Trends'!B14<>\"\", \"OK\", 1))","v":"OK"},null,{"$f":"IF(D251=1, \"Ensure that the column 'Money-market securities' is selected in Question 2, since one or more method of communication were selected in Question 4\", \"\")","v":""}]
[null,29,null,{"$f":"IF((COUNTIF('A - Retail Investor Trends'!F$56:F$64,\"X\"))=0, \"OK\", IF('A - Retail Investor Trends'!B15<>\"\", \"OK\", 1))","v":"OK"},null,{"$f":"IF(D252=1, \"Ensure that the column 'Units in collective investment undertakings' is selected in Question 2, since one or more method of communication were selected in Question 4\", \"\")","v":""}]
[null,30,null,{"$f":"IF((COUNTIF('A - Retail Investor Trends'!G$56:G$64,\"X\"))=0, \"OK\", IF('A - Retail Investor Trends'!B16<>\"\", \"OK\", 1))","v":"OK"},null,{"$f":"IF(D253=1, \"Ensure that the column 'Derivatives' is selected in Question 2, since one or more method of communication were selected in Question 4\", \"\")","v":""}]
[null,31,null,{"$f":"IF((COUNTIF('A - Retail Investor Trends'!H$56:H$64,\"X\"))=0, \"OK\", IF('A - Retail Investor Trends'!B17<>\"\", \"OK\", 1))","v":"OK"},null,{"$f":"IF(D254=1, \"Ensure that the column 'CFDs' is selected in Question 2, since one or more method of communication were selected in Question 4\", \"\")","v":""}]
[null,32,null,{"$f":"IF((COUNTIF('A - Retail Investor Trends'!I$56:I$64,\"X\"))=0, \"OK\", IF('A - Retail Investor Trends'!B18<>\"\", \"OK\", 1))","v":"OK"},null,{"$f":"IF(D255=1, \"Ensure that the column 'ETFs' is selected in Question 2, since one or more method of communication were selected in Question 4\", \"\")","v":""}]
[null,33,null,{"$f":"IF((COUNTIF('A - Retail Investor Trends'!J$56:J$64,\"X\"))=0, \"OK\", IF('A - Retail Investor Trends'!B19<>\"\", \"OK\", 1))","v":"OK"},null,{"$f":"IF(D256=1, \"Ensure that the column 'Other financial instruments' is selected in Question 2, since one or more method of communication were selected in Question 4\", \"\")","v":""}]
[null,34,null,{"$f":"IF(AND('A - Retail Investor Trends'!J56<>\"X\", 'A - Retail Investor Trends'!J57<>\"X\", 'A - Retail Investor Trends'!J58<>\"X\", 'A - Retail Investor Trends'!J59<>\"X\", 'A - Retail Investor Trends'!J60<>\"X\", 'A - Retail Investor Trends'!J61<>\"X\", 'A - Retail Investor Trends'!J62<>\"X\", 'A - Retail Investor Trends'!J63<>\"X\", 'A - Retail Investor Trends'!J64<>\"X\"), \"OK\", IF('A - Retail Investor Trends'!A67<>\"\",\"OK\", 1))","v":"OK"},null,{"$f":"IF(D257=1, \"Ensure that Question 4.1 is compiled, since 'Other' was replied in Question 4\", \"\")","v":""}]
[null,35,null,{"$f":"IF(OR('A - Retail Investor Trends'!F5=\"No\",'A - Retail Investor Trends'!F5=\"N/A\"),\"OK\",IF('A - Retail Investor Trends'!G69<>\"\", \"OK\", 1))","v":1},null,{"$f":"IF(D258=1, \"Ensure that Question 5 is filled in\", \"\")","v":"Ensure that Question 5 is filled in"}]
[null,36,null,{"$f":"IF(OR('A - Retail Investor Trends'!F5=\"No\",'A - Retail Investor Trends'!F5=\"N/A\"),\"OK\",IF('A - Retail Investor Trends'!A72<>\"\", \"OK\", 1))","v":1},{"$f":"SUM(D224:D259)","v":5},{"$f":"IF(D259=1, \"Ensure that Question 6 is filled in\", \"\")","v":"Ensure that Question 6 is filled in"}]
[]
["A - Complaints",1,null,{"$f":"IF(AND('A - Complaints'!F15<=0, 'A - Complaints'!F21<=0, 'A - Complaints'!F27<=0, 'A - Complaints'!F38<=0),\"OK\",IF('A - Complaints'!C40<>\"\",\"OK\", 1))","v":"OK"},null,{"$f":"IF(D261=1, \"Ensure that you have included comments in the box under Table 1, if at least a complaint is indicated under 'Other' - causes\", \"\")","v":""}]
[null,2,null,{"$f":"IF('A - Complaints'!F54<=0,\"OK\",IF('A - Complaints'!C56<>\"\",\"OK\", 1))","v":"OK"},null,{"$f":"IF(D262=1, \"Ensure that you have included comments in the box under Table 1, if at least a complaint is indicated under 'Other' - products\",\"\")","v":""}]
[null,3,null,{"$f":"IF('A - Complaints'!F62<=0,\"OK\",IF('A - Complaints'!C64<>\"\",\"OK\", 1))","v":"OK"},null,{"$f":"IF(D263=1, \"Ensure that you have included comments in the box under Table 1, if at least a complaint is indicated under 'Other' - crypto assets/ICOs\", \"\")","v":""}]
[null,4,null,{"$f":"IF(AND('A - Complaints'!C39='A - Complaints'!C55,'A - Complaints'!D39='A - Complaints'!D55, 'A - Complaints'!E39='A - Complaints'!E55, 'A - Complaints'!G39='A - Complaints'!G55, 'A - Complaints'!H39='A - Complaints'!H55), \"OK\", 1)","v":"OK"},{"$f":"SUM(D261:D264)","v":0},{"$f":"IF(D264=1, \"Ensure that the number of complaints in table 1 and 2 do tally\", \"\")","v":""}]
[]
["A - Arbiter",1,null,{"$f":"IF('A - Office of the Arbiter'!E4=0, \"OK\", IF('A - Office of the Arbiter'!C8<>\"\", \"OK\", 1))","v":"OK"},{"$f":"SUM(D266)","v":0},{"$f":"IF(D266=1, \"Ensure to include the relevant information on the complaint(s) referred to the Arbiter\", \"\")","v":""}]
[]
["A - Online presence",1,null,{"$f":"IF('A - Online & Social presence'!B9<>\"\", \"OK\", 1)","v":1},null,{"$f":"IF(D268=1, \"Ensure that Question 1 is filled in\", \"\")","v":"Ensure that Question 1 is filled in"}]
[null,2,null,{"$f":"IF('A - Online & Social presence'!B35<>\"\", \"OK\", 1)","v":1},{"$f":"SUM(D268:D269)","v":2},{"$f":"IF(D269=1, \"Ensure that Question 2 is filled in\", \"\")","v":"Ensure that Question 2 is filled in"}]
[]
["A - Branches",1,null,{"$f":"IF(OR('A - Branches'!H4=\"Yes\", 'A - Branches'!H4=\"No\"), \"OK\", 1)","v":1},null,{"$f":"IF(D271=1, \"Ensure that Question 1 is filled in\", \"\")","v":"Ensure that Question 1 is filled in"}]
[null,2,null,{"$f":"IF(OR('A - Branches'!H4=\"No\",'A - Branches'!H4=\"\"), \"OK\",IF((COUNTIF('A - Branches'!B11:B39,\"X\"))>=1,\"OK\",1))","v":"OK"},null,{"$f":"IF(D272=1, \"Ensure that Question 2 is replied in full, if Question 1 was filled in as 'Yes'\", \"\")","v":""}]
[null,3,null,{"$f":"IF('A - Branches'!B11=\"\", \"OK\", IF(AND('A - Branches'!D11<>\"\", 'A - Branches'!F11<>\"\", 'A - Branches'!H11<>\"\"), \"OK\", 1))","v":"OK"},null,{"$f":"IF(D273=1, \"Ensure to include relevant information in relation to the branch in Austria\", \"\")","v":""}]
[null,4,null,{"$f":"IF('A - Branches'!B12=\"\", \"OK\", IF(AND('A - Branches'!D12<>\"\", 'A - Branches'!F12<>\"\", 'A - Branches'!H12<>\"\"), \"OK\", 1))","v":"OK"},null,{"$f":"IF(D274=1, \"Ensure to include relevant information in relation to the branch in Belgium\", \"\")","v":""}]
[null,5,null,{"$f":"IF('A - Branches'!B13=\"\", \"OK\", IF(AND('A - Branches'!D13<>\"\", 'A - Branches'!F13<>\"\", 'A - Branches'!H13<>\"\"), \"OK\", 1))","v":"OK"},null,{"$f":"IF(D275=1, \"Ensure to include relevant information in relation to the branch in Bulgaria\", \"\")","v":""}]
[null,6,null,{"$f":"IF('A - Branches'!B14=\"\", \"OK\", IF(AND('A - Branches'!D14<>\"\", 'A - Branches'!F14<>\"\", 'A - Branches'!H14<>\"\"), \"OK\", 1))","v":"OK"},null,{"$f":"IF(D276=1, \"Ensure to include relevant information in relation to the branch in Croatia\", \"\")","v":""}]
[null,7,null,{"$f":"IF('A - Branches'!B15=\"\", \"OK\", IF(AND('A - Branches'!D15<>\"\", 'A - Branches'!F15<>\"\", 'A - Branches'!H15<>\"\"), \"OK\", 1))","v":"OK"},null,{"$f":"IF(D277=1, \"Ensure to include relevant information in relation to the branch in Cyprus\", \"\")","v":""}]
[null,8,null,{"$f":"IF('A - Branches'!B16=\"\", \"OK\", IF(AND('A - Branches'!D16<>\"\", 'A - Branches'!F16<>\"\", 'A - Branches'!H16<>\"\"), \"OK\", 1))","v":"OK"},null,{"$f":"IF(D278=1, \"Ensure to include relevant information in relation to the branch in Czech Republic\", \"\")","v":""}]
[null,9,null,{"$f":"IF('A - Branches'!B17=\"\", \"OK\", IF(AND('A - Branches'!D17<>\"\", 'A - Branches'!F17<>\"\", 'A - Branches'!H17<>\"\"), \"OK\", 1))","v":"OK"},null,{"$f":"IF(D279=1, \"Ensure to include relevant information in relation to the branch in Denmark\", \"\")","v":""}]
[null,10,null,{"$f":"IF('A - Branches'!B18=\"\", \"OK\", IF(AND('A - Branches'!D18<>\"\", 'A - Branches'!F18<>\"\", 'A - Branches'!H18<>\"\"), \"OK\", 1))","v":"OK"},null,{"$f":"IF(D280=1, \"Ensure to include relevant information in relation to the branch in Estonia\", \"\")","v":""}]
[null,11,null,{"$f":"IF('A - Branches'!B19=\"\", \"OK\", IF(AND('A - Branches'!D19<>\"\", 'A - Branches'!F19<>\"\", 'A - Branches'!H19<>\"\"), \"OK\", 1))","v":"OK"},null,{"$f":"IF(D281=1, \"Ensure to include relevant information in relation to the branch in Finland\", \"\")","v":""}]
[null,12,null,{"$f":"IF('A - Branches'!B20=\"\", \"OK\", IF(AND('A - Branches'!D20<>\"\", 'A - Branches'!F20<>\"\", 'A - Branches'!H20<>\"\"), \"OK\", 1))","v":"OK"},null,{"$f":"IF(D282=1, \"Ensure to include relevant information in relation to the branch in France\", \"\")","v":""}]
[null,13,null,{"$f":"IF('A - Branches'!B21=\"\", \"OK\", IF(AND('A - Branches'!D21<>\"\", 'A - Branches'!F21<>\"\", 'A - Branches'!H21<>\"\"), \"OK\", 1))","v":"OK"},null,{"$f":"IF(D283=1, \"Ensure to include relevant information in relation to the branch in Germany\", \"\")","v":""}]
[null,14,null,{"$f":"IF('A - Branches'!B22=\"\", \"OK\", IF(AND('A - Branches'!D22<>\"\", 'A - Branches'!F22<>\"\", 'A - Branches'!H22<>\"\"), \"OK\", 1))","v":"OK"},null,{"$f":"IF(D284=1, \"Ensure to include relevant information in relation to the branch in Greece\", \"\")","v":""}]
[null,15,null,{"$f":"IF('A - Branches'!B23=\"\", \"OK\", IF(AND('A - Branches'!D23<>\"\", 'A - Branches'!F23<>\"\", 'A - Branches'!H23<>\"\"), \"OK\", 1))","v":"OK"},null,{"$f":"IF(D285=1, \"Ensure to include relevant information in relation to the branch in Hungary\", \"\")","v":""}]
[null,16,null,{"$f":"IF('A - Branches'!B24=\"\", \"OK\", IF(AND('A - Branches'!D24<>\"\", 'A - Branches'!F24<>\"\", 'A - Branches'!H24<>\"\"), \"OK\", 1))","v":"OK"},null,{"$f":"IF(D286=1, \"Ensure to include relevant information in relation to the branch in Iceland\", \"\")","v":""}]
[null,17,null,{"$f":"IF('A - Branches'!B25=\"\", \"OK\", IF(AND('A - Branches'!D25<>\"\", 'A - Branches'!F25<>\"\", 'A - Branches'!H25<>\"\"), \"OK\", 1))","v":"OK"},null,{"$f":"IF(D287=1, \"Ensure to include relevant information in relation to the branch in Ireland\", \"\")","v":""}]
[null,18,null,{"$f":"IF('A - Branches'!B26=\"\", \"OK\", IF(AND('A - Branches'!D26<>\"\", 'A - Branches'!F26<>\"\", 'A - Branches'!H26<>\"\"), \"OK\", 1))","v":"OK"},null,{"$f":"IF(D288=1, \"Ensure to include relevant information in relation to the branch in Italy\", \"\")","v":""}]
[null,19,null,{"$f":"IF('A - Branches'!B27=\"\", \"OK\", IF(AND('A - Branches'!D27<>\"\", 'A - Branches'!F27<>\"\", 'A - Branches'!H27<>\"\"), \"OK\", 1))","v":"OK"},null,{"$f":"IF(D289=1, \"Ensure to include relevant information in relation to the branch in Latvia\", \"\")","v":""}]
[null,20,null,{"$f":"IF('A - Branches'!B28=\"\", \"OK\", IF(AND('A - Branches'!D28<>\"\", 'A - Branches'!F28<>\"\", 'A - Branches'!H28<>\"\"), \"OK\", 1))","v":"OK"},null,{"$f":"IF(D290=1, \"Ensure to include relevant information in relation to the branch in Liechtenstein\", \"\")","v":""}]
[null,21,null,{"$f":"IF('A - Branches'!B29=\"\", \"OK\", IF(AND('A - Branches'!D29<>\"\", 'A - Branches'!F29<>\"\", 'A - Branches'!H29<>\"\"), \"OK\", 1))","v":"OK"},null,{"$f":"IF(D291=1, \"Ensure to include relevant information in relation to the branch in Lithuania\", \"\")","v":""}]
[null,22,null,{"$f":"IF('A - Branches'!B30=\"\", \"OK\", IF(AND('A - Branches'!D30<>\"\", 'A - Branches'!F30<>\"\", 'A - Branches'!H30<>\"\"), \"OK\", 1))","v":"OK"},null,{"$f":"IF(D292=1, \"Ensure to include relevant information in relation to the branch in Luxembourg\", \"\")","v":""}]
[null,23,null,{"$f":"IF('A - Branches'!B31=\"\", \"OK\", IF(AND('A - Branches'!D31<>\"\", 'A - Branches'!F31<>\"\", 'A - Branches'!H31<>\"\"), \"OK\", 1))","v":"OK"},null,{"$f":"IF(D293=1, \"Ensure to include relevant information in relation to the branch in Netherlands\", \"\")","v":""}]
[null,24,null,{"$f":"IF('A - Branches'!B32=\"\", \"OK\", IF(AND('A - Branches'!D32<>\"\", 'A - Branches'!F32<>\"\", 'A - Branches'!H32<>\"\"), \"OK\", 1))","v":"OK"},null,{"$f":"IF(D294=1, \"Ensure to include relevant information in relation to the branch in Norway\", \"\")","v":""}]
[null,25,null,{"$f":"IF('A - Branches'!B33=\"\", \"OK\", IF(AND('A - Branches'!D33<>\"\", 'A - Branches'!F33<>\"\", 'A - Branches'!H33<>\"\"), \"OK\", 1))","v":"OK"},null,{"$f":"IF(D295=1, \"Ensure to include relevant information in relation to the branch in Poland\", \"\")","v":""}]
[null,26,null,{"$f":"IF('A - Branches'!B34=\"\", \"OK\", IF(AND('A - Branches'!D34<>\"\", 'A - Branches'!F34<>\"\", 'A - Branches'!H34<>\"\"), \"OK\", 1))","v":"OK"},null,{"$f":"IF(D296=1, \"Ensure to include relevant information in relation to the branch in Portugal\", \"\")","v":""}]
[null,27,null,{"$f":"IF('A - Branches'!B35=\"\", \"OK\", IF(AND('A - Branches'!D35<>\"\", 'A - Branches'!F35<>\"\", 'A - Branches'!H35<>\"\"), \"OK\", 1))","v":"OK"},null,{"$f":"IF(D297=1, \"Ensure to include relevant information in relation to the branch in Romania\", \"\")","v":""}]
[null,28,null,{"$f":"IF('A - Branches'!B36=\"\", \"OK\", IF(AND('A - Branches'!D36<>\"\", 'A - Branches'!F36<>\"\", 'A - Branches'!H36<>\"\"), \"OK\", 1))","v":"OK"},null,{"$f":"IF(D298=1, \"Ensure to include relevant information in relation to the branch in Slovakia\", \"\")","v":""}]
[null,29,null,{"$f":"IF('A - Branches'!B37=\"\", \"OK\", IF(AND('A - Branches'!D37<>\"\", 'A - Branches'!F37<>\"\", 'A - Branches'!H37<>\"\"), \"OK\", 1))","v":"OK"},null,{"$f":"IF(D299=1, \"Ensure to include relevant information in relation to the branch in Slovenia\", \"\")","v":""}]
[null,30,null,{"$f":"IF('A - Branches'!B38=\"\", \"OK\", IF(AND('A - Branches'!D38<>\"\", 'A - Branches'!F38<>\"\", 'A - Branches'!H38<>\"\"), \"OK\", 1))","v":"OK"},null,{"$f":"IF(D300=1, \"Ensure to include relevant information in relation to the branch in Spain\", \"\")","v":""}]
[null,31,null,{"$f":"IF('A - Branches'!B39=\"\", \"OK\", IF(AND('A - Branches'!D39<>\"\", 'A - Branches'!F39<>\"\", 'A - Branches'!H39<>\"\"), \"OK\", 1))","v":"OK"},null,{"$f":"IF(D301=1, \"Ensure to include relevant information in relation to the branch in Sweden\", \"\")","v":""}]
[null,32,null,{"$f":"IF(OR('A - Branches'!H11=\"No\", 'A - Branches'!H11=\"\"), \"OK\", IF('A - Branches'!$A$42<>\"\", \"OK\", 1))","v":"OK"},null,{"$f":"IF(D302=1, \"Ensure that Question 2.1 is replied to\", \"\")","v":""}]
[null,33,null,{"$f":"IF(OR('A - Branches'!H12=\"No\", 'A - Branches'!H12=\"\"), \"OK\", IF('A - Branches'!$A$42<>\"\", \"OK\", 1))","v":"OK"},null,{"$f":"IF(D303=1, \"Ensure that Question 2.1 is replied to\", \"\")","v":""}]
[null,34,null,{"$f":"IF(OR('A - Branches'!H13=\"No\", 'A - Branches'!H13=\"\"), \"OK\", IF('A - Branches'!$A$42<>\"\", \"OK\", 1))","v":"OK"},null,""]
[null,35,null,{"$f":"IF(OR('A - Branches'!H14=\"No\", 'A - Branches'!H14=\"\"), \"OK\", IF('A - Branches'!$A$42<>\"\", \"OK\", 1))","v":"OK"},null,""]
[null,36,null,{"$f":"IF(OR('A - Branches'!H15=\"No\", 'A - Branches'!H15=\"\"), \"OK\", IF('A - Branches'!$A$42<>\"\", \"OK\", 1))","v":"OK"},null,""]
[null,37,null,{"$f":"IF(OR('A - Branches'!H16=\"No\", 'A - Branches'!H16=\"\"), \"OK\", IF('A - Branches'!$A$42<>\"\", \"OK\", 1))","v":"OK"},null,""]
[null,38,null,{"$f":"IF(OR('A - Branches'!H17=\"No\", 'A - Branches'!H17=\"\"), \"OK\", IF('A - Branches'!$A$42<>\"\", \"OK\", 1))","v":"OK"},null,""]
[null,39,null,{"$f":"IF(OR('A - Branches'!H18=\"No\", 'A - Branches'!H18=\"\"), \"OK\", IF('A - Branches'!$A$42<>\"\", \"OK\", 1))","v":"OK"},null,""]
[null,40,null,{"$f":"IF(OR('A - Branches'!H19=\"No\", 'A - Branches'!H19=\"\"), \"OK\", IF('A - Branches'!$A$42<>\"\", \"OK\", 1))","v":"OK"},null,""]
[null,41,null,{"$f":"IF(OR('A - Branches'!H20=\"No\", 'A - Branches'!H20=\"\"), \"OK\", IF('A - Branches'!$A$42<>\"\", \"OK\", 1))","v":"OK"},null,""]
[null,42,null,{"$f":"IF(OR('A - Branches'!H21=\"No\", 'A - Branches'!H21=\"\"), \"OK\", IF('A - Branches'!$A$42<>\"\", \"OK\", 1))","v":"OK"},null,""]
[null,43,null,{"$f":"IF(OR('A - Branches'!H22=\"No\", 'A - Branches'!H22=\"\"), \"OK\", IF('A - Branches'!$A$42<>\"\", \"OK\", 1))","v":"OK"},null,""]
[null,44,null,{"$f":"IF(OR('A - Branches'!H23=\"No\", 'A - Branches'!H23=\"\"), \"OK\", IF('A - Branches'!$A$42<>\"\", \"OK\", 1))","v":"OK"},null,""]
[null,45,null,{"$f":"IF(OR('A - Branches'!H24=\"No\", 'A - Branches'!H24=\"\"), \"OK\", IF('A - Branches'!$A$42<>\"\", \"OK\", 1))","v":"OK"},null,""]
[null,46,null,{"$f":"IF(OR('A - Branches'!H25=\"No\", 'A - Branches'!H25=\"\"), \"OK\", IF('A - Branches'!$A$42<>\"\", \"OK\", 1))","v":"OK"},null,""]
[null,47,null,{"$f":"IF(OR('A - Branches'!H26=\"No\", 'A - Branches'!H26=\"\"), \"OK\", IF('A - Branches'!$A$42<>\"\", \"OK\", 1))","v":"OK"},null,""]
[null,48,null,{"$f":"IF(OR('A - Branches'!H27=\"No\", 'A - Branches'!H27=\"\"), \"OK\", IF('A - Branches'!$A$42<>\"\", \"OK\", 1))","v":"OK"},null,""]
[null,49,null,{"$f":"IF(OR('A - Branches'!H28=\"No\", 'A - Branches'!H28=\"\"), \"OK\", IF('A - Branches'!$A$42<>\"\", \"OK\", 1))","v":"OK"},null,""]
[null,50,null,{"$f":"IF(OR('A - Branches'!H29=\"No\", 'A - Branches'!H29=\"\"), \"OK\", IF('A - Branches'!$A$42<>\"\", \"OK\", 1))","v":"OK"},null,""]
[null,51,null,{"$f":"IF(OR('A - Branches'!H30=\"No\", 'A - Branches'!H30=\"\"), \"OK\", IF('A - Branches'!$A$42<>\"\", \"OK\", 1))","v":"OK"},null,""]
[null,52,null,{"$f":"IF(OR('A - Branches'!H31=\"No\", 'A - Branches'!H31=\"\"), \"OK\", IF('A - Branches'!$A$42<>\"\", \"OK\", 1))","v":"OK"},null,""]
[null,53,null,{"$f":"IF(OR('A - Branches'!H32=\"No\", 'A - Branches'!H32=\"\"), \"OK\", IF('A - Branches'!$A$42<>\"\", \"OK\", 1))","v":"OK"},null,""]
[null,54,null,{"$f":"IF(OR('A - Branches'!H33=\"No\", 'A - Branches'!H33=\"\"), \"OK\", IF('A - Branches'!$A$42<>\"\", \"OK\", 1))","v":"OK"},null,""]
[null,55,null,{"$f":"IF(OR('A - Branches'!H34=\"No\", 'A - Branches'!H34=\"\"), \"OK\", IF('A - Branches'!$A$42<>\"\", \"OK\", 1))","v":"OK"},null,""]
[null,56,null,{"$f":"IF(OR('A - Branches'!H35=\"No\", 'A - Branches'!H35=\"\"), \"OK\", IF('A - Branches'!$A$42<>\"\", \"OK\", 1))","v":"OK"},null,""]
[null,57,null,{"$f":"IF(OR('A - Branches'!H36=\"No\", 'A - Branches'!H36=\"\"), \"OK\", IF('A - Branches'!$A$42<>\"\", \"OK\", 1))","v":"OK"},null,""]
[null,58,null,{"$f":"IF(OR('A - Branches'!H37=\"No\", 'A - Branches'!H37=\"\"), \"OK\", IF('A - Branches'!$A$42<>\"\", \"OK\", 1))","v":"OK"},null,""]
[null,59,null,{"$f":"IF(OR('A - Branches'!H38=\"No\", 'A - Branches'!H38=\"\"), \"OK\", IF('A - Branches'!$A$42<>\"\", \"OK\", 1))","v":"OK"},null,""]
[null,60,null,{"$f":"IF(OR('A - Branches'!H39=\"No\", 'A - Branches'!H39=\"\"), \"OK\", IF('A - Branches'!$A$42<>\"\", \"OK\", 1))","v":"OK"},null,""]
[null,61,null,{"$f":"IF('A - Branches'!H4=\"No\", \"OK\", IF(OR('A - Branches'!H48=\"Yes\", 'A - Branches'!H48=\"No\"), \"OK\", 1))","v":1},null,{"$f":"IF(D331=1, \"Ensure that Question 3 is filled in\", \"\")","v":"Ensure that Question 3 is filled in"}]
[null,62,null,{"$f":"IF(OR('A - Branches'!H48=\"No\", 'A - Branches'!H48=\"\"), \"OK\", IF('A - Branches'!A51<>\"\", \"OK\", 1))","v":"OK"},{"$f":"SUM(D271:D332)","v":2},{"$f":"IF(D332=1, \"Ensure that Question 3.1 is filled in if Question 3 is replied as 'Yes'\", \"\")","v":""}]
[]
["A - Additional details",1,null,{"$f":"IF(SUM('A - Additional details'!H10:H27,'A - Additional details'!J10:J27,'A - Additional details'!L10:L27)=0,\"OK\",IF(SUM('A - Additional details'!H30:H35)>0,\"OK\",1))","v":"OK"},null,{"$f":"IF(D334=1, \"Ensure that, when clients are indicated in Question 1, then rows 30-35 are filled in accordingly\", \"\")","v":""}]
[null,2,null,{"$f":"IF('A - Additional details'!L28=SUM('A - Additional details'!J39:P267), \"OK\", 1)","v":"OK"},null,{"$f":"IF(D335=1, \"Ensure that the number of clients residing in the rest of the world included in Question 1 does tally with the number of clients reported in Question 1.1\", \"\")","v":""}]
[null,3,null,{"$f":"IF('A - Additional details'!H271<>\"\", \"OK\", 1)","v":1},null,{"$f":"IF(D336=1, \"Ensure that Question 2 is replied\", \"\")","v":"Ensure that Question 2 is replied"}]
[null,4,null,{"$f":"IF('A - Additional details'!P279<>\"\", \"OK\", 1)","v":1},null,{"$f":"IF(D337=1, \"Ensure that Question 3 is replied\",\"\")","v":"Ensure that Question 3 is replied"}]
[null,5,null,{"$f":"IF(OR('A - Additional details'!P279=\"No\", 'A - Additional details'!P279=\"N/A\"), \"OK\", IF('A - Additional details'!B286<>\"\", \"OK\", 1))","v":1},{"$f":"SUM(D334:D338)","v":3},{"$f":"IF(D338=1, \"Ensure that Question 4 is replied if 'Yes' is selected in Question 3\",\"\")","v":"Ensure that Question 4 is replied if 'Yes' is selected in Question 3"}]
[null,{"$f":"COUNTA(B34:B338)","v":297}]

{"sheet":"A - Innovation","index":2,"n_rows":67,"n_cols":15,"rows_kept":67,"cut":false,"hidden":false,"merged":[[18,0,18,1],[18,2,18,5],[67,0,71,10],[59,0,59,4],[60,0,60,4],[61,0,61,4],[62,0,62,4],[63,0,63,4],[64,0,64,4],[58,0,58,4],[34,0,34,1],[34,2,34,5],[35,0,35,1],[35,2,35,5],[48,0,48,1],[48,2,48,4],[51,0,55,10],[36,0,36,1],[31,0,31,1],[31,2,31,5],[32,0,32,1],[32,2,32,5],[33,0,33,1],[33,2,33,5],[39,0,43,10],[46,0,46,1],[46,2,46,4],[47,0,47,1],[47,2,47,4],[23,0,27,10],[30,0,30,1],[30,2,30,5],[0,0,0,10],[2,0,2,10],[7,0,7,1],[7,2,7,5],[6,0,6,10],[7,6,7,7],[10,0,14,10],[20,2,20,5],[19,2,19,5],[20,0,20,1],[19,0,19,1],[17,0,17,1],[17,2,17,5]]}
["Innovation Survey"]
[]
["Kindly refer to the Glossary available on our website for further information regarding certain terms used in this survey. \nFinancial innovation is defined as the act of creating and distributing new financial instruments, processes, business models and markets, including the new application of existing ideas in a different market context.\nIf the Company replies 'No innovations' to Question 1, the rest of the Survey must be left blank. "]
[null,null,null,null,null,null,null,null,null,null,null,null,1,"Product",false]
["Financial innovations and their priority/importance in the market",null,null,null,null,null,null,null,null,null,null,null,1,"Process",false]
[null,null,null,null,null,null,null,null,null,null,null,null,1,"No innovation",false]
["1. Kindly indicate if the Company has made use of innovations related to its product and/or services during the reporting quarter.",null,null,null,null,null,null,null,null,null,null,null,2,"More info on the innovation",{"$f":"A11","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,3,"Equity",false]
[null,null,null,null,null,null,null,null,null,null,null,null,3,"Debt",false]
["2. Kindly provide more information on the innovation. ",null,null,null,null,null,null,null,null,null,null,null,3,"Units in collective investment undertakings",false]
[null,null,null,null,null,null,null,null,null,null,null,null,3,"Derivatives (option, futures, etc)",false]
[null,null,null,null,null,null,null,null,null,null,null,null,3,"CFDs",false]
[null,null,null,null,null,null,null,null,null,null,null,null,3,"ETFs",false]
[null,null,null,null,null,null,null,null,null,null,null,null,3,"Other financial instruments",false]
[null,null,null,null,null,null,null,null,null,null,null,null,3,"The innovation does not apply to products",false]
[null,null,null,null,null,null,null,null,null,null,null,null,3.1,"Other information, if 'Other' was selected in Q3",{"$f":"A24","v":0}]
["3. Does the innovation apply to one or more of the following financial instruments?",null,null,null,null,null,null,null,null,null,null,null,4,"API (incl. payment services)",false]
[null,null,null,null,null,null,null,null,null,null,null,null,4,"Natural Language Processing",false]
[null,null,null,null,null,null,null,null,null,null,null,null,4,"AI/Machine learning/Big data",false]
[null,null,null,null,null,null,null,null,null,null,null,null,4,"Optical Character Recognition",false]
[null,null,null,null,null,null,null,null,null,null,null,null,4,"Automated Advice",false]
[null,null,null,null,null,null,null,null,null,null,null,null,4,"Quantum Computing",false]
["3.1 If the \"Other financial instruments\" was chosen in Question 3, please provide further details in the box below. ",null,null,null,null,null,null,null,null,null,null,null,4,"Cloud Computing",false]
[null,null,null,null,null,null,null,null,null,null,null,null,4,"Smart Contracts",false]
[null,null,null,null,null,null,null,null,null,null,null,null,4,"Data management tools",false]
[null,null,null,null,null,null,null,null,null,null,null,null,4,"Web scraping",false]
[null,null,null,null,null,null,null,null,null,null,null,null,4,"DTL incl. payment services",false]
[null,null,null,null,null,null,null,null,null,null,null,null,4,"Other",false]
[null,null,null,null,null,null,null,null,null,null,null,null,4,"The innovation does not involve new tech",false]
["4. Does the innovation involve use of technology?",null,null,null,null,null,null,null,null,null,null,null,4.0999999999999996,"Other info, if 'Other' was selected in Q4",{"$f":"A40","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,5,"Client services",false]
[null,null,null,null,null,null,null,null,null,null,null,null,5,"Monitoring/research",false]
[null,null,null,null,null,null,null,null,null,null,null,null,5,"Creation of a new business model",false]
[null,null,null,null,null,null,null,null,null,null,null,null,5,"Regulatory compliance/Reporting",false]
[null,null,null,null,null,null,null,null,null,null,null,null,5,"Improved process efficienty, e.g. through authomatisation",false]
[null,null,null,null,null,null,null,null,null,null,null,null,5,"Other",false]
[null,null,null,null,null,null,null,null,null,null,null,null,5.0999999999999996,"More info, if 'Other' was selected in Q5",{"$f":"A52","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,6,"Clearing and settling payments",false]
["4.1. If the \"Other\" filed was chosen in Question 4, please provide further details in the box below. ",null,null,null,null,null,null,null,null,null,null,null,6,"Dealing with asymmetric info/incentive problems",false]
[null,null,null,null,null,null,null,null,null,null,null,null,6,"Managing risk",false]
[null,null,null,null,null,null,null,null,null,null,null,null,6,"Pooling resources and subdiving shares",false]
[null,null,null,null,null,null,null,null,null,null,null,null,6,"Price formation",false]
[null,null,null,null,null,null,null,null,null,null,null,null,6,"Transferring resources across time and space",false]
[null,null,null,null,null,null,null,null,null,null,null,null,6,"Other",false]
[null,null,null,null,null,null,null,null,null,null,null,null,6.1,"More info, if 'Other' was selected in Q6",{"$f":"A68","v":0}]
["5. What is the business purpose of the innovation? "]
[]
[]
[]
[]
["5.1. If the \"Other\" filed was chosen in Question 5, please provide further details in the box below. "]
[]
[]
[]
[]
[]
[]
["6. What is the economic function of the innovation? "]
[]
[]
[]
[]
[]
[]
[]
[]
["6.1. If the \"Other\" filed was chosen in Question 6, please provide further details in the box below. "]

{"sheet":"A - Cross-border activity","index":3,"n_rows":144,"n_cols":19,"rows_kept":144,"cut":false,"hidden":false,"merged":[[41,1,43,1],[41,2,41,16],[41,17,43,17],[110,0,110,17],[112,2,112,9],[112,10,112,16],[77,10,77,16],[41,0,43,0],[0,0,0,18],[2,0,2,18],[5,0,5,18],[7,2,7,9],[7,10,7,16],[6,2,6,16],[6,0,8,0],[6,1,8,1],[6,17,8,17],[6,18,8,18],[3,0,3,17],[112,18,113,18],[75,0,75,18],[77,2,77,9],[40,0,40,18],[42,2,42,9],[42,10,42,16],[111,0,113,0],[111,1,113,1],[111,2,111,16],[111,17,113,17],[41,18,43,18],[76,0,78,0],[76,1,78,1],[76,2,76,16],[76,17,78,17],[76,18,78,18]]}
["Cross-border activity"]
[]
["Please fill in the number of clients per category of client (Retail / Professional / Eligible Counterparty) that are recipients of the below sevices on a cross-border basis during the reporting quarter, per country.\nBefore compiling the Survey, kindly ensure to review the Circular on 'Clarification Note addressed to MiFID II Investment Firms operating on a Freedom of Services (FoS) Cross-Border basis on Conduct Related Disclosures in the Financial Return Reporting and Other Important Regulatory Clarifications' available via:"]
["https://www.mfsa.mt/publication/clarification-note-addressed-to-mifid-ii-investment-firms-operating-on-a-freedom-of-services-fos-cross-border-basis-on-conduct-related-disclosures-in-the-mifid-firms-quarterly-reporting-and-other-im/"]
[]
["Retail Clients"]
["Residence","Total number of clients per jurisdiction","Breakdown for investment services",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Value of the transactions (kindly include the gross notional volume of all orders, i.e. the sum of the total amount of all transactions, across all asset types, opened by clients within the relevant reporting period). To include N/A as relevant, depending on the services provided. ","Type(s) of financial instruments provided\n(in case where different types of financial instruments were provided, please indicate all the applicable ones. The selection allows multiple choices)"]
[null,null,"Investment Services and Activities as per Section A of Annex 1 of MiFID II",null,null,null,null,null,null,null,"Ancillary Services as per Section B of Annex I of MiFID II"]
[null,null,"Reception and Transmission of Orders ","Execution of orders on behalf of clients","Dealing on Own Account","Portfolio Management ","Investment Advice","Underwriting / placing of instruments on a firm commitment basis","Placing of Instruments without a firm commitment basis","Operation of a Multilateral Trading Facility ","Safekeeping and Administration of Financial Instruments ","Granting of credits or loans to an investor ","Advice to undertakings on capital Structure, Industrial Strategy and related Matters","Foreign Exchange Services ","Investment Research and Financial Analysis ","Services Related to Undertakings","Investment and Ancillary Services relating to the underlying of certain derivatives"]
["Austria"]
["Belgium"]
["Bulgaria"]
["Croatia"]
["Cyprus"]
["Czech Republic"]
["Denmark"]
["Estonia"]
["Finland"]
["France"]
["Germany"]
["Greece"]
["Hungary"]
["Iceland"]
["Ireland"]
["Italy"]
["Latvia"]
["Liechtenstein"]
["Lithuania"]
["Luxembourg"]
["Netherlands"]
["Norway"]
["Poland"]
["Portugal"]
["Romania"]
["Slovakia"]
["Slovenia"]
["Spain"]
["Sweden"]
["Total",null,{"$f":"SUM(C10:C38)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[]
["Professional Clients"]
["Residence","Total number of clients per jurisdiction","Breakdown for investment services",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Value of the transactions (kindly include the gross notional volume of all orders, i.e. the sum of the total amount of all transactions, across all asset types, opened by clients within the relevant reporting period). To include N/A as relevant, depending on the services provided. ","Type(s) of financial instruments provided\n(in case where different types of financial instruments were provided, please indicate all the applicable ones. The selection allows multiple choices)"]
[null,null,"Investment Services and Activities as per Section A of Annex 1 of MiFID II",null,null,null,null,null,null,null,"Ancillary Services as per Section B of Annex I of MiFID II"]
[null,null,"Reception and Transmission of Orders ","Execution of orders on behalf of clients","Dealing on Own Account","Portfolio Management ","Investment Advice","Underwriting / placing of instruments on a firm commitment basis","Placing of Instruments without a firm commitment basis","Operation of a Multilateral Trading Facility ","Safekeeping and Administration of Financial Instruments ","Granting of credits or loans to an investor ","Advice to undertakings on capital Structure, Industrial Strategy and related Matters","Foreign Exchange Services ","Investment Research and Financial Analysis ","Services Related to Undertakings","Investment and Ancillary Services relating to the underlying of certain derivatives"]
["Austria"]
["Belgium"]
["Bulgaria"]
["Croatia"]
["Cyprus"]
["Czech Republic"]
["Denmark"]
["Estonia"]
["Finland"]
["France"]
["Germany"]
["Greece"]
["Hungary"]
["Iceland"]
["Ireland"]
["Italy"]
["Latvia"]
["Liechtenstein"]
["Lithuania"]
["Luxembourg"]
["Netherlands"]
["Norway"]
["Poland"]
["Portugal"]
["Romania"]
["Slovakia"]
["Slovenia"]
["Spain"]
["Sweden"]
["Total",null,{"$f":"SUM(C45:C73)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[]
["Eligible Counterparties"]
["Residence","Total number of clients per jurisdiction","Breakdown for investment services",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Value of the transactions (kindly include the gross notional volume of all orders, i.e. the sum of the total amount of all transactions, across all asset types, opened by clients within the relevant reporting period). To include N/A as relevant, depending on the services provided. ","Type(s) of financial instruments provided\n(in case where different types of financial instruments were provided, please indicate all the applicable ones. The selection allows multiple choices)"]
[null,null,"Investment Services and Activities as per Section A of Annex 1 of MiFID II",null,null,null,null,null,null,null,"Ancillary Services as per Section B of Annex I of MiFID II"]
[null,null,"Reception and Transmission of Orders ","Execution of orders on behalf of clients","Dealing on Own Account","Portfolio Management ","Investment Advice","Underwriting / placing of instruments on a firm commitment basis","Placing of Instruments without a firm commitment basis","Operation of a Multilateral Trading Facility ","Safekeeping and Administration of Financial Instruments ","Granting of credits or loans to an investor ","Advice to undertakings on capital Structure, Industrial Strategy and related Matters","Foreign Exchange Services ","Investment Research and Financial Analysis ","Services Related to Undertakings","Investment and Ancillary Services relating to the underlying of certain derivatives"]
["Austria"]
["Belgium"]
["Bulgaria"]
["Croatia"]
["Cyprus"]
["Czech Republic"]
["Denmark"]
["Estonia"]
["Finland"]
["France"]
["Germany"]
["Greece"]
["Hungary"]
["Iceland"]
["Ireland"]
["Italy"]
["Latvia"]
["Liechtenstein"]
["Lithuania"]
["Luxembourg"]
["Netherlands"]
["Norway"]
["Poland"]
["Portugal"]
["Romania"]
["Slovakia"]
["Slovenia"]
["Spain"]
["Sweden"]
["Total",null,{"$f":"SUM(C80:C108)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[]
["All Clients"]
["Residence","Total number of clients per jurisdiction","Breakdown for investment services",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Value of the transactions (kindly include the gross notional volume of all orders, i.e. the sum of the total amount of all transactions, across all asset types, opened by clients within the relevant reporting period). To include N/A as relevant, depending on the services provided. "]
[null,null,"Investment Services and Activities as per Section A of Annex 1 of MiFID II",null,null,null,null,null,null,null,"Ancillary Services as per Section B of Annex I of MiFID II"]
[null,null,"Reception and Transmission of Orders ","Execution of orders on behalf of clients","Dealing on Own Account","Portfolio Management ","Investment Advice","Underwriting / placing of instruments on a firm commitment basis","Placing of Instruments without a firm commitment basis","Operation of a Multilateral Trading Facility ","Safekeeping and Administration of Financial Instruments ","Granting of credits or loans to an investor ","Advice to undertakings on capital Structure, Industrial Strategy and related Matters","Foreign Exchange Services ","Investment Research and Financial Analysis ","Services Related to Undertakings","Investment and Ancillary Services relating to the underlying of certain derivatives"]
["Austria",{"$f":"B10+B45+B80","v":0},{"$f":"C10+C45+C80","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
["Belgium",{"$f":"B11+B46+B81","v":0},{"$f":"C11+C46+C81","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
["Bulgaria",{"$f":"B12+B47+B82","v":0},{"$f":"C12+C47+C82","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
["Croatia",{"$f":"B13+B48+B83","v":0},{"$f":"C13+C48+C83","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
["Cyprus",{"$f":"B14+B49+B84","v":0},{"$f":"C14+C49+C84","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
["Czech Republic",{"$f":"B15+B50+B85","v":0},{"$f":"C15+C50+C85","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
["Denmark",{"$f":"B16+B51+B86","v":0},{"$f":"C16+C51+C86","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
["Estonia",{"$f":"B17+B52+B87","v":0},{"$f":"C17+C52+C87","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
["Finland",{"$f":"B18+B53+B88","v":0},{"$f":"C18+C53+C88","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
["France",{"$f":"B19+B54+B89","v":0},{"$f":"C19+C54+C89","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
["Germany",{"$f":"B20+B55+B90","v":0},{"$f":"C20+C55+C90","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
["Greece",{"$f":"B21+B56+B91","v":0},{"$f":"C21+C56+C91","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
["Hungary",{"$f":"B22+B57+B92","v":0},{"$f":"C22+C57+C92","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
["Iceland",{"$f":"B23+B58+B93","v":0},{"$f":"C23+C58+C93","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
["Ireland",{"$f":"B24+B59+B94","v":0},{"$f":"C24+C59+C94","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
["Italy",{"$f":"B25+B60+B95","v":0},{"$f":"C25+C60+C95","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
["Latvia",{"$f":"B26+B61+B96","v":0},{"$f":"C26+C61+C96","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
["Liechtenstein",{"$f":"B27+B62+B97","v":0},{"$f":"C27+C62+C97","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
["Lithuania",{"$f":"B28+B63+B98","v":0},{"$f":"C28+C63+C98","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
["Luxembourg",{"$f":"B29+B64+B99","v":0},{"$f":"C29+C64+C99","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
["Netherlands",{"$f":"B30+B65+B100","v":0},{"$f":"C30+C65+C100","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
["Norway",{"$f":"B31+B66+B101","v":0},{"$f":"C31+C66+C101","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
["Poland",{"$f":"B32+B67+B102","v":0},{"$f":"C32+C67+C102","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
["Portugal",{"$f":"B33+B68+B103","v":0},{"$f":"C33+C68+C103","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
["Romania",{"$f":"B34+B69+B104","v":0},{"$f":"C34+C69+C104","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
["Slovakia",{"$f":"B35+B70+B105","v":0},{"$f":"C35+C70+C105","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
["Slovenia",{"$f":"B36+B71+B106","v":0},{"$f":"C36+C71+C106","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
["Spain",{"$f":"B37+B72+B107","v":0},{"$f":"C37+C72+C107","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
["Sweden",{"$f":"B38+B73+B108","v":0},{"$f":"C38+C73+C108","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
["Total",{"$f":"SUM(B115:B143)","v":0},{"$f":"SUM(C115:C143)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]

{"sheet":"A - Retail Investor Trends","index":4,"n_rows":72,"n_cols":13,"rows_kept":72,"cut":false,"hidden":false,"merged":[[71,0,71,9],[0,0,0,10],[68,0,68,5],[50,0,50,9],[52,0,52,9],[65,0,65,9],[66,0,66,9],[70,0,70,9],[42,0,42,9],[44,0,44,5],[45,0,45,5],[46,0,46,5],[47,0,47,5],[48,0,48,5],[29,0,29,6],[36,0,36,5],[37,0,37,5],[38,0,38,5],[39,0,39,5],[40,0,40,5],[2,0,2,9],[6,0,6,7],[7,0,7,7],[21,0,21,9],[23,0,23,6]]}
["Retail Investor Trends Survey"]
[]
["Kindly refer to the Glossary available on our website for further information regarding certain terms used in this survey."]
[]
["1. Have you provided products and/or services to retail clients over the reporting quarter? ",null,null,null,null,null,{"$f":"IF(F5=\"\",0,1)","v":0},null,null,null,null,null,1]
[]
["2. Which of the following products and/or services did you provide to retail clients?"]
["Demand' can be taken to be the value of net flows by retail investors into a given asset class, if such information is available."]
[]
[null,"Percentage (%)"]
["Shares",null,{"$f":"IF(OR(AND(B11=\"\", SUM($B$11:$B$19)<1), SUM($B$11:$B$19)>1), 0,1)","v":0},null,null,null,null,null,null,null,null,null,2]
["Bonds",null,0,null,null,null,null,null,null,null,null,null,2]
["Structured securities",null,0,null,null,null,null,null,null,null,null,null,2]
["Money-market securities",null,0,null,null,null,null,null,null,null,null,null,2]
["Units in collective investment undertakings",null,0,null,null,null,null,null,null,null,null,null,2]
["Derivatives (options, futures, etc.)",null,0,null,null,null,null,null,null,null,null,null,2]
["CFDs",null,0,null,null,null,null,null,null,null,null,null,2]
["ETFs",null,0,null,null,null,null,null,null,null,null,null,2]
["Other Financial Instruments",null,0,null,null,null,null,null,null,null,null,null,2]
[]
["2.1. Kindly provide us with the names of products if the ‘Other financial instruments’ field was chosen in question 2 above:"]
[null,null,null,null,null,null,null,null,null,null,null,null,2.1]
[]
["3.  Which of the below distribution channels do you provide to your retail clients. Kindly mark with an \"Yes\", \"No\" or \"N/A\" as appropriate."]
[]
["Non-Advisory",null,null,null,null,null,null,null,null,null,null,null,3]
["Advisory",null,null,null,null,null,null,null,null,null,null,null,3]
["Wealth/portfolio management",null,null,null,null,null,null,null,null,null,null,null,3]
[]
["3.1. How have retail clients' demand for the following distribution channels changed (by annual volume of sales)  over the observed quarter when compared to the previous quarter? Kindly mark with an \"x\" or \"N/A\" as appropriate."]
[]
[null,"Increased significantly","Increased","Remained unchanged","Decreased","Decreased significantly"]
["Non-Advisory",null,null,null,null,null,null,null,null,null,null,null,3.1]
["Advisory",null,null,null,null,null,null,null,null,null,null,null,3.1]
["Wealth/portfolio management",null,null,null,null,null,null,null,null,null,null,null,3.1]
[]
["3.1.1. What are the reasons for the increases in retail investors’ demand for distribution channel marked as “increased/increased significantly” in Question 3.1. above."]
[null,null,null,null,null,null,null,null,null,null,null,null,"3.1.1"]
[null,null,null,null,null,null,null,null,null,null,null,null,"3.1.1"]
[null,null,null,null,null,null,null,null,null,null,null,null,"3.1.1"]
[null,null,null,null,null,null,null,null,null,null,null,null,"3.1.1"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,"3.1.1"]
[]
["3.1.2. What are the reasons for the decreases in retail investors’ demand for distribution channel marked as “decreased/decreased significantly” in Question 3.1. above."]
[null,null,null,null,null,null,null,null,null,null,null,null,"3.1.2"]
[null,null,null,null,null,null,null,null,null,null,null,null,"3.1.2"]
[null,null,null,null,null,null,null,null,null,null,null,null,"3.1.2"]
[null,null,null,null,null,null,null,null,null,null,null,null,"3.1.2"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,"3.1.2"]
[]
["4. Kindly indicate which method of communication and/or media channel are being used to promote the financial instruments mentioned in Question 2 to Retail Clients. Kindly note that all the distribution channels must be selected (mark with an \"x\" or \"N/A\" as appropriate)."]
[]
[null,"Shares","Bonds","Structured securities","Money-market securities","Units in collective investment undertakings","Derivatives (options, futures, etc.)","CFDs","ETFs","Other Financial Instruments"]
["Newspaper",null,null,null,null,null,null,null,null,null,null,null,4]
["Facebook",null,null,null,null,null,null,null,null,null,null,null,4]
["Twitter",null,null,null,null,null,null,null,null,null,null,null,4]
["Instagram",null,null,null,null,null,null,null,null,null,null,null,4]
["TikTok",null,null,null,null,null,null,null,null,null,null,null,4]
["YouTube",null,null,null,null,null,null,null,null,null,null,null,4]
["LinkedIn",null,null,null,null,null,null,null,null,null,null,null,4]
["Emails/Newsletters to clients",null,null,null,null,null,null,null,null,null,null,null,4]
["Others (please specify)",null,null,null,null,null,null,null,null,null,null,null,4]
[]
["4.1. Kindly provide us with the name of the product and/or the name of the method of communication and/or media channel if ‘Other' field was chosen in question 4 above."]
[null,null,null,null,null,null,null,null,null,null,null,null,4.0999999999999996]
[]
["5. Kindly indicate the percentage of retail clients onboarded through digital means (i.e. non face-to-face basis). ",null,null,null,null,null,null,null,null,null,null,null,5]
[]
["6. What makes you market these products to retail investors?"]
[null,null,null,null,null,null,null,null,null,null,null,null,6]

{"sheet":"A - Complaints","index":5,"n_rows":64,"n_cols":11,"rows_kept":64,"cut":false,"hidden":false,"merged":[[63,2,63,7],[59,0,59,1],[60,0,60,1],[61,0,61,1],[63,0,63,1],[27,0,37,0],[51,0,51,1],[53,0,53,1],[55,0,55,1],[57,0,58,1],[39,0,39,1],[39,2,39,7],[41,0,41,1],[41,2,41,7],[43,0,44,1],[43,2,43,5],[57,2,57,4],[45,0,45,1],[46,0,46,1],[47,0,47,1],[48,0,48,1],[49,0,49,1],[50,0,50,1],[55,2,55,7],[21,0,26,0],[0,0,0,8],[4,0,5,1],[4,2,4,5],[6,0,14,0],[15,0,20,0]]}
["Complaints Survey"]
[null,null,null,null,null," "]
["Kindly refer to the Glossary available on our website for further information regarding certain terms used in this survey."]
[]
["1 - Number of complaints by complaint cause",null,"Number of New Complaints received during the current reporting quarter"]
[null,null,"From clients residing in Malta","From clients residing in EU/EEA outside Malta. Please also include the complaints received from clients serviced by EU/EEA branches","From clients residing in the rest of the world (excluding EU/EEA)","Total number of complaints received during the current reporting period","Number of Unresolved Complaints from the previous reporting quarters","Number of complaints referred to the Office of the Arbiter for Financial Services during the reporting period"]
["Execution of orders on behalf of clients / Reception and transmission of orders","Quality or lack of information provided to the client",null,null,null,{"$f":"SUM(C7:E7)","v":0},null,null,null,null,1]
[null,"Lack of appropriatness for the client",null,null,null,{"$f":"SUM(C8:E8)","v":0},null,null,null,null,1]
[null,"Terms of contract/fees/charges",null,null,null,0,null,null,null,null,1]
[null,"General admin/customer services (including custody/safekeeping services)",null,null,null,0,null,null,null,null,1]
[null,"Issue in relation to withdrawal of investor's funds",null,null,null,0,null,null,null,null,1]
[null,"Other, of which: ",{"$f":"SUM(C13:C15)","v":0},{"$f":"SUM(D13:D15)","v":0},{"$f":"SUM(E13:E15)","v":0},0,{"$f":"SUM(G13:G15)","v":0},{"$f":"SUM(H13:H15)","v":0},null,null,1]
[null,"              Incorrect trade execution/Non triggered trading order",null,null,null,0,null,null,null,null,1]
[null,"              Issue in relation to slippage of prices",null,null,null,0,null,null,null,null,1]
[null,"              None of the above (please specify in comments section below)",null,null,null,0,null,null,null,null,1]
["Portfolio management","Quality or lack of information provided to the client",null,null,null,0,null,null,null,null,1]
[null,"Lack of suitability for the client",null,null,null,0,null,null,null,null,1]
[null,"Terms of contract/fees/charges",null,null,null,0,null,null,null,null,1]
[null,"General admin/customer services (including custody/safekeeping services)",null,null,null,0,null,null,null,null,1]
[null,"Issue in relation to withdrawal of investor's funds",null,null,null,0,null,null,null,null,1]
[null,"Other (please specify in comments section below)",null,null,null,0,null,null,null,null,1]
["Investment advice ","Quality or lack of information provided to the client",null,null,null,0,null,null,null,null,1]
[null,"Lack of suitability for the client",null,null,null,0,null,null,null,null,1]
[null,"Terms of contract/fees/charges",null,null,null,0,null,null,null,null,1]
[null,"General admin/customer services (including custody/safekeeping services)",null,null,null,0,null,null,null,null,1]
[null,"Issue in relation to withdrawal of investor's funds",null,null,null,0,null,null,null,null,1]
[null,"Other (please specify in comments section below)",null,null,null,0,null,null,null,null,1]
["Complaint not related to a specific MiFID service","Quality or lack of information provided to the client",null,null,null,0,null,null,null,null,1]
[null,"Terms of contract/fees/charges",null,null,null,0,null,null,null,null,1]
[null,"General admin/customer services (including custody/safekeeping services)",null,null,null,0,null,null,null,null,1]
[null,"Unauthorised business being offered or carried out",null,null,null,0,null,null,null,null,1]
[null,"Complaints from clients of group's entity (not regulated by MFSA)",null,null,null,0,null,null,null,null,1]
[null,"Issue in relation to withdrawal of investor's funds",null,null,null,0,null,null,null,null,1]
[null,"Other, of which: ",{"$f":"SUM(C35:C38)","v":0},{"$f":"SUM(D35:D38)","v":0},0,0,{"$f":"SUM(G35:G38)","v":0},{"$f":"SUM(H35:H38)","v":0},null,null,1]
[null,"              Issue related to trading platform (not related to trading)",null,null,null,0,null,null,null,null,1]
[null,"              Dividend payment ",null,null,null,0,null,null,null,null,1]
[null,"              Charges related to funds deposit/withdrawal",null,null,null,0,null,null,null,null,1]
[null,"              None of the above (please specify in comments section below)",null,null,null,0,null,null,null,null,1]
["Total",null,{"$f":"SUM(C7:C12, C16:C34)","v":0},{"$f":"SUM(D7:D12, D16:D34)","v":0},0,0,{"$f":"SUM(G7:G12, G16:G34)","v":0},0,null,null,1]
["Please provide information on all of the complaints reported under \"Other\" or \"None of the above\" and include any relevant information that can help explain the numbers.",null,null,null,null,null,null,null,null,null,1]
[]
["Kindly include indication of the top 3 countries (outside Malta) where the complaints were received during the reporting period. ",null,null,null,null,null,null,null,null,null,1]
[]
["2 - Number of complaints by financial instruments",null,"Number of New Complaints received during the current reporting quarter"]
[null,null,"From clients residing in Malta","From clients residing in EU/EEA outside Malta. Please also include the complaints received from clients serviced by EU/EEA branches","From clients residing in the rest of the world (excluding EU/EEA)","Total number of complaints received during the current reporting period","Number of Unresolved Complaints from the previous reporting quarters","Number of complaints referred to the Office of the Arbiter for Financial Services during the reporting period"]
["Shares/stock/equities",null,null,null,null,{"$f":"SUM(C46:E46)","v":0},null,null,null,null,2]
["Bonds/debentures/loan stock/debt securities",null,null,null,null,{"$f":"SUM(C47:E47)","v":0},null,null,null,null,2]
["Structured securities (including securities with capital protection and structured funds)",null,null,null,null,0,null,null,null,null,2]
["Money-market securities",null,null,null,null,0,null,null,null,null,2]
["UCITS/AIFs/Other funds (excluding structured funds)",null,null,null,null,0,null,null,null,null,2]
["Options, futures, swaps, warrants, forward rate agreements and any other derivatives",null,null,null,null,0,null,null,null,null,2]
["Financial contracts for differences (CFDs)",null,null,null,null,0,null,null,null,null,2]
["ETFs",null,null,null,null,0,null,null,null,null,2]
["Other investment products/funds (please specify in comments section below)",null,null,null,null,0,null,null,null,null,2]
["Total",null,{"$f":"SUM(C46:C54)","v":0},0,0,0,0,0,null,null,2]
["Please provide information on the \"Other investment products/funds\" and include any relevant information that can help explain the numbers",null,null,null,null,null,null,null,null,null,2]
[]
["3 - Number of complaints involving crypto assets/ICOs",null,"Number of New Complaints received during the current reporting quarter"]
[null,null,"From clients residing in Malta","From clients residing in EU/EEA outside Malta. Please also include the complaints received from clients serviced by EU/EEA branches","From clients residing in the rest of the world (excluding EU/EEA)","Total number of complaints received during the current reporting period","Number of Unresolved Complaints from the previous reporting quarters","Number of complaints referred to the Office of the Arbiter for Financial Services during the reporting period"]
["Complaints involving crypto assets / ICOs",null,null,null,null,{"$f":"SUM(C60:E60)","v":0},null,null,null,null,3]
["                 of which: complaints involving CFDs on cryptocurrencies",null,null,null,null,{"$f":"SUM(C61:E61)","v":0},null,null,null,null,3]
["Complaints not involving crypto assets / ICOs",null,null,null,null,0,null,null,null,null,3]
["Total",null,{"$f":"C60+C62","v":0},{"$f":"D60+D62","v":0},{"$f":"E60+E62","v":0},{"$f":"SUM(F60:F62)","v":0},{"$f":"SUM(G60:G62)","v":0},{"$f":"SUM(H60:H62)","v":0},null,null,3]
["Please include any relevant information that can help explain the numbers",null,null,null,null,null,null,null,null,null,3]

{"sheet":"A - Office of the Arbiter","index":6,"n_rows":57,"n_cols":13,"rows_kept":57,"cut":false,"hidden":false,"merged":[[53,2,53,4],[54,2,54,4],[55,2,55,4],[56,2,56,4],[48,2,48,4],[49,2,49,4],[50,2,50,4],[51,2,51,4],[52,2,52,4],[43,2,43,4],[44,2,44,4],[45,2,45,4],[46,2,46,4],[47,2,47,4],[38,2,38,4],[39,2,39,4],[40,2,40,4],[41,2,41,4],[42,2,42,4],[33,2,33,4],[34,2,34,4],[35,2,35,4],[36,2,36,4],[37,2,37,4],[28,2,28,4],[29,2,29,4],[30,2,30,4],[31,2,31,4],[32,2,32,4],[23,2,23,4],[24,2,24,4],[25,2,25,4],[26,2,26,4],[27,2,27,4],[10,2,10,4],[20,2,20,4],[21,2,21,4],[22,2,22,4],[11,2,11,4],[12,2,12,4],[13,2,13,4],[14,2,14,4],[15,2,15,4],[16,2,16,4],[17,2,17,4],[18,2,18,4],[19,2,19,4],[0,0,1,10],[6,2,6,4],[7,2,7,4],[8,2,8,4],[9,2,9,4]]}
["Office of the Arbiter for Financial Services Survey"]
[]
[]
[null,null,"Please provide details of the",null,{"$f":"'A - Complaints'!H39","v":0},"complaints referred to the Office of the Financial Services Arbiter in the table below."]
[null,null,"In addition please also provide details of unresolved complaints (pending from previous quarters, during current year) referred to the Office of the Financial Services Arbiter and which were resolved during the reporting quarter.  "]
[]
[null,"Complaint Number","Date of Referral to the Arbiter",null,null,"Details of the Nature of the Complaint (including details of the Complainant)","Resolved / Unresolved (during the current reporting quarter)","Manner of Resolution","Details of Resolution (including any decisions taken by the Office of the Financial Services Arbiter and/or of any settlement agreement between the parties)","Appeals lodged from Arbiters decision","Details of any appeals lodged"]
[null,{"$f":"1","v":1},null,null,null,null,null,null,null,null,null,null,1]
[null,{"$f":"SUM(B8+1)","v":2},null,null,null,null,null,null,null,null,null,null,1]
[null,3,null,null,null,null,null,null,null,null,null,null,1]
[null,4,null,null,null,null,null,null,null,null,null,null,1]
[null,5,null,null,null,null,null,null,null,null,null,null,1]
[null,6,null,null,null,null,null,null,null,null,null,null,1]
[null,7,null,null,null,null,null,null,null,null,null,null,1]
[null,8,null,null,null,null,null,null,null,null,null,null,1]
[null,9,null,null,null,null,null,null,null,null,null,null,1]
[null,10,null,null,null,null,null,null,null,null,null,null,1]
[null,11,null,null,null,null,null,null,null,null,null,null,1]
[null,12,null,null,null,null,null,null,null,null,null,null,1]
[null,13,null,null,null,null,null,null,null,null,null,null,1]
[null,14,null,null,null,null,null,null,null,null,null,null,1]
[null,15,null,null,null,null,null,null,null,null,null,null,1]
[null,16,null,null,null,null,null,null,null,null,null,null,1]
[null,17,null,null,null,null,null,null,null,null,null,null,1]
[null,18,null,null,null,null,null,null,null,null,null,null,1]
[null,19,null,null,null,null,null,null,null,null,null,null,1]
[null,20,null,null,null,null,null,null,null,null,null,null,1]
[null,21,null,null,null,null,null,null,null,null,null,null,1]
[null,22,null,null,null,null,null,null,null,null,null,null,1]
[null,23,null,null,null,null,null,null,null,null,null,null,1]
[null,24,null,null,null,null,null,null,null,null,null,null,1]
[null,25,null,null,null,null,null,null,null,null,null,null,1]
[null,26,null,null,null,null,null,null,null,null,null,null,1]
[null,27,null,null,null,null,null,null,null,null,null,null,1]
[null,28,null,null,null,null,null,null,null,null,null,null,1]
[null,29,null,null,null,null,null,null,null,null,null,null,1]
[null,30,null,null,null,null,null,null,null,null,null,null,1]
[null,31,null,null,null,null,null,null,null,null,null,null,1]
[null,32,null,null,null,null,null,null,null,null,null,null,1]
[null,33,null,null,null,null,null,null,null,null,null,null,1]
[null,{"$f":"SUM(B40+1)","v":34},null,null,null,null,null,null,null,null,null,null,1]
[null,35,null,null,null,null,null,null,null,null,null,null,1]
[null,36,null,null,null,null,null,null,null,null,null,null,1]
[null,37,null,null,null,null,null,null,null,null,null,null,1]
[null,38,null,null,null,null,null,null,null,null,null,null,1]
[null,39,null,null,null,null,null,null,null,null,null,null,1]
[null,40,null,null,null,null,null,null,null,null,null,null,1]
[null,41,null,null,null,null,null,null,null,null,null,null,1]
[null,42,null,null,null,null,null,null,null,null,null,null,1]
[null,43,null,null,null,null,null,null,null,null,null,null,1]
[null,44,null,null,null,null,null,null,null,null,null,null,1]
[null,45,null,null,null,null,null,null,null,null,null,null,1]
[null,46,null,null,null,null,null,null,null,null,null,null,1]
[null,47,null,null,null,null,null,null,null,null,null,null,1]
[null,48,null,null,null,null,null,null,null,null,null,null,1]
[null,49,null,null,null,null,null,null,null,null,null,null,1]
[null,50,null,null,null,null,null,null,null,null,null,null,1]

{"sheet":"A - Online & Social presence","index":7,"n_rows":54,"n_cols":15,"rows_kept":54,"cut":false,"hidden":false,"merged":[[0,0,1,13],[31,0,31,12],[5,0,5,12]]}
["Online & Social media Presence"]
[]
[]
["Website"]
[]
["1. Kindly disclose the up-to-date firm’s website link(s) which are utilised to provide information to clients and potential clients about the firm’s products and services.  Furthermore, kindly indicate the identified jurisdiction and target audience (e.g. specific category of clients) which the website(s) is/are intended for."]
[]
[null,"Link",null,"Target audience",null,"Jurisdiction(s)",null,"Language(s) used"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,1]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,1]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,1]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,1]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,1]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,1]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,1]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,1]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,1]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,1]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,1]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,1]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,1]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,1]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,1]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,1]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,1]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,1]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,1]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,1]
[]
["Social media"]
[]
["2. Kindly disclose the up-to-date firm’s links to any social media pages.  Social media includes but is not limited to: websites, microblogs (e.g. Twitter), social and professional networks (such as Facebook and LinkedIn), forums, image and video-sharing platforms (YouTube, Instagram, TikTok). Furthermore, kindly indicate the identified jurisdiction and target audience (e.g. specific category of clients) which the disclosed social media pages are intended for."]
[]
[null,"Link",null,"Social media",null,"Target audience",null,"Jurisdiction(s)",null,"Language(s) used"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,2]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,2]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,2]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,2]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,2]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,2]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,2]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,2]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,2]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,2]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,2]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,2]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,2]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,2]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,2]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,2]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,2]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,2]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,2]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,2]

{"sheet":"A - Branches","index":8,"n_rows":51,"n_cols":12,"rows_kept":51,"cut":false,"hidden":false,"merged":[[0,0,0,8],[50,0,54,9],[41,0,45,9],[3,0,3,5],[7,0,7,8],[47,0,47,5],[40,0,40,8]]}
["Branches"]
[]
[]
["1. Does the licence holder have Branches in other EU Member States?",null,null,null,null,null,null,null,null,null,null,1]
[]
[]
[]
["2. If yes, kindly indicate the jurisdictions where these Branches are situated across EU Member States. Kindly indicate with X under column B where the branches are located. "]
[]
["Jurisdiction",null,null,"Number of clients serviced",null,"Number of employees",null,"Has the branch serviced clients residing outside of the said jurisdiction? "]
["Austria",null,null,null,null,null,null,null,null,null,null,2]
["Belgium",null,null,null,null,null,null,null,null,null,null,2]
["Bulgaria",null,null,null,null,null,null,null,null,null,null,2]
["Croatia",null,null,null,null,null,null,null,null,null,null,2]
["Cyprus",null,null,null,null,null,null,null,null,null,null,2]
["Czech Republic",null,null,null,null,null,null,null,null,null,null,2]
["Denmark",null,null,null,null,null,null,null,null,null,null,2]
["Estonia",null,null,null,null,null,null,null,null,null,null,2]
["Finland",null,null,null,null,null,null,null,null,null,null,2]
["France",null,null,null,null,null,null,null,null,null,null,2]
["Germany",null,null,null,null,null,null,null,null,null,null,2]
["Greece",null,null,null,null,null,null,null,null,null,null,2]
["Hungary",null,null,null,null,null,null,null,null,null,null,2]
["Iceland",null,null,null,null,null,null,null,null,null,null,2]
["Ireland",null,null,null,null,null,null,null,null,null,null,2]
["Italy",null,null,null,null,null,null,null,null,null,null,2]
["Latvia",null,null,null,null,null,null,null,null,null,null,2]
["Liechtenstein",null,null,null,null,null,null,null,null,null,null,2]
["Lithuania",null,null,null,null,null,null,null,null,null,null,2]
["Luxembourg",null,null,null,null,null,null,null,null,null,null,2]
["Netherlands",null,null,null,null,null,null,null,null,null,null,2]
["Norway",null,null,null,null,null,null,null,null,null,null,2]
["Poland",null,null,null,null,null,null,null,null,null,null,2]
["Portugal",null,null,null,null,null,null,null,null,null,null,2]
["Romania",null,null,null,null,null,null,null,null,null,null,2]
["Slovakia",null,null,null,null,null,null,null,null,null,null,2]
["Slovenia",null,null,null,null,null,null,null,null,null,null,2]
["Spain",null,null,null,null,null,null,null,null,null,null,2]
["Sweden",null,null,null,null,null,null,null,null,null,null,2]
[]
["2.1 If any of the branches serviced clients outside the said jurisdiction, please provide more information (e.g. the jurisdictions where clients serviced reside). "]
[null,null,null,null,null,null,null,null,null,null,null,2.1]
[]
[]
[]
[]
[]
["3. Was there any interaction between the branch and the National Competence Authority of the Host Member State in relation to any conduct related matter?",null,null,null,null,null,null,null,null,null,null,3]
[]
["3.1 If yes, please provide more details on the matter. "]
[null,null,null,null,null,null,null,null,null,null,null,3.1]

{"sheet":"A - Additional details","index":9,"n_rows":295,"n_cols":27,"rows_kept":295,"cut":false,"hidden":false,"merged":[[289,1,289,3],[288,1,288,3],[270,0,270,5],[278,0,278,13],[287,1,287,3],[286,1,286,3],[285,1,285,3],[274,0,274,15],[282,0,282,17],[284,1,284,3],[270,7,270,8],[271,7,271,8],[294,1,294,3],[293,1,293,3],[292,1,292,3],[291,1,291,3],[290,1,290,3],[14,1,14,3],[15,1,15,3],[19,1,19,3],[24,1,24,3],[37,0,42,5],[10,1,10,3],[0,0,1,18],[5,0,5,13],[7,7,7,11],[7,13,7,17],[9,1,9,3]]}
["Additional details "]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Afghanistan"]
["Number of clients",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Albania"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Algeria"]
["1. Kindly indicate below the number of clients and the Value in Euro of the clients' assets at the end of the reporting period. \nKindly note that rows 30-35 should also be filled in manually. ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Andorra"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Angola"]
[null,null,null,null,null,null,null,"Number of clients",null,null,null,null,null,"Value in Euro of Clients' assets",null,null,null,null,null,null,null,null,null,null,null,null,"Antigua and Barbuda"]
[null,null,null,null,null,null,null,"Resident in Malta",null,"Resident in the rest of EU/EEA",null,"Resident in the rest of the world",null,"Resident in Malta",null,"Resident in the rest of EU/EEA",null,"Resident in the rest of the world",null,null,null,null,null,null,null,null,"Argentina"]
[null,"of which under Nominee: ",null,null,null,"Retail",null,null,null,null,null,null,null,null,null,null,null,null,null,1,null,null,null,null,null,null,"Armenia"]
[null,"(advisory and non-advisory services)",null,null,null,"Professional",null,null,null,null,null,null,null,null,null,null,null,null,null,1,null,null,null,null,null,null,"Australia"]
[null,null,null,null,null,"     of which CISs",null,null,null,null,null,null,null,null,null,null,null,null,null,1,null,null,null,null,null,null,"Azerbaijan"]
[null,null,null,null,null,"Elective Professional",null,null,null,null,null,null,null,null,null,null,null,null,null,1,null,null,null,null,null,null,"Bahrain"]
[null,null,null,null,null,"Eligible Counterparty",null,null,null,null,null,null,null,null,null,null,null,null,null,1,null,null,null,null,null,null,"Bahamas"]
[null,"of which non Nominee: ",null,null,null,"Retail",null,null,null,null,null,null,null,null,null,null,null,null,null,1,null,null,null,null,null,null,"Bangladesh"]
[null,"(advisory and non-advisory services)",null,null,null,"Professional",null,null,null,null,null,null,null,null,null,null,null,null,null,1,null,null,null,null,null,null,"Barbados"]
[null,null,null,null,null,"      of which CISs",null,null,null,null,null,null,null,null,null,null,null,null,null,1,null,null,null,null,null,null,"Belarus"]
[null,null,null,null,null,"Elective Professional",null,null,null,null,null,null,null,null,null,null,null,null,null,1,null,null,null,null,null,null,"Belize"]
[null,null,null,null,null,"Eligible Counterparty",null,null,null,null,null,null,null,null,null,null,null,null,null,1,null,null,null,null,null,null,"Benin"]
[null,"of which Discretionary Portfolio Management:",null,null,null,"Retail",null,null,null,null,null,null,null,null,null,null,null,null,null,1,null,null,null,null,null,null,"Bermuda"]
[null,null,null,null,null,"Professional",null,null,null,null,null,null,null,null,null,null,null,null,null,1,null,null,null,null,null,null,"Bhutan"]
[null,null,null,null,null,"      of which CISs",null,null,null,null,null,null,null,null,null,null,null,null,null,1,null,null,null,null,null,null,"Bolivia"]
[null,null,null,null,null,"Elective Professional",null,null,null,null,null,null,null,null,null,null,null,null,null,1,null,null,null,null,null,null,"Bosnia and Herzegovina"]
[null,null,null,null,null,"Eligible Counterparty",null,null,null,null,null,null,null,null,null,null,null,null,null,1,null,null,null,null,null,null,"Botswana"]
[null,"of which Management of CISs:",null,null,null,"UCITS",null,null,null,null,null,null,null,null,null,null,null,null,null,1,null,null,null,null,null,null,"Brazil"]
[null,null,null,null,null,"Non-UCITS Retail",null,null,null,null,null,null,null,null,null,null,null,null,null,1,null,null,null,null,null,null,"British Virgin Islands"]
[null,null,null,null,null,"Professional",null,null,null,null,null,null,null,null,null,null,null,null,null,1,null,null,null,null,null,null,"Brunei"]
[null,null,null,null,null,"Total",null,{"$f":"SUM(H10:H11,H13:H16,H18:H21,H23:H27)","v":0},null,{"$f":"SUM(J10:J11,J13:J16,J18:J21,J23:J27)","v":0},null,{"$f":"SUM(L10:L11,L13:L16,L18:L21,L23:L27)","v":0},null,{"$f":"SUM(N10:N11,N13:N16,N18:N21,N23:N27)","v":0},null,{"$f":"SUM(P10:P11,P13:P16,P18:P21,P23:P27)","v":0},null,{"$f":"SUM(R10:R11,R13:R16,R18:R21,R23:R27)","v":0},null,1,null,null,null,null,null,null,"Burkina Faso"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Burundi"]
[null,null,null,null,null,"Total Clients",null,null,null,null,null,null,null,null,null,null,null,null,null,1,null,null,null,null,null,null,"Cabo Verde"]
[null,null,null,null,null,"Retail",null,null,null,null,null,null,null,null,null,null,null,null,null,1,null,null,null,null,null,null,"Cambodia"]
[null,null,null,null,null,"Professional",null,null,null,null,null,null,null,null,null,null,null,null,null,1,null,null,null,null,null,null,"Cameroon"]
[null,null,null,null,null,"   of which CISs",null,null,null,null,null,null,null,null,null,null,null,null,null,1,null,null,null,null,null,null,"Canada"]
[null,null,null,null,null,"Elective Professional",null,null,null,null,null,null,null,null,null,null,null,null,null,1,null,null,null,null,null,null,"Cayman Islands"]
[null,null,null,null,null,"Eligible Counterparty",null,null,null,null,null,null,null,null,null,null,null,null,null,1,null,null,null,null,null,null,"Central African Republic"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Chad"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Channel Islands"]
["1.1 If you have serviced clients in jurisdictions located outside the EU/EEA, kindly indicate the jurisdictions and the number of clients resident in the rest of world as reported in Question 1.  ",null,null,null,null,null,null,"Jurisdiction in the rest of the world",null,"Total number of retail clients",null,"Total number of professional clients",null,"Total number of elective professional clients",null,"Total number of eligible counterparties",null,null,null,null,null,null,null,null,null,null,"Chile"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1.2,null,null,null,null,null,null,"China"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1.2,null,null,null,null,null,null,"Colombia"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1.2,null,null,null,null,null,null,"Comoros"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1.2,null,null,null,null,null,null,"Congo"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1.2,null,null,null,null,null,null,"Costa Rica"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1.2,null,null,null,null,null,null,"Côte d'Ivoire"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1.2,null,null,null,null,null,null,"Cuba"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1.2,null,null,null,null,null,null,"Djibouti"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1.2,null,null,null,null,null,null,"Dominica"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1.2,null,null,null,null,null,null,"Dominican Republic"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1.2,null,null,null,null,null,null,"DR Congo"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1.2,null,null,null,null,null,null,"Ecuador"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1.2,null,null,null,null,null,null,"Egypt"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1.2,null,null,null,null,null,null,"El Salvador"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1.2,null,null,null,null,null,null,"Equatorial Guinea"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1.2,null,null,null,null,null,null,"Eritrea"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1.2,null,null,null,null,null,null,"Eswatini"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1.2,null,null,null,null,null,null,"Ethiopia"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1.2,null,null,null,null,null,null,"Faeroe Islands"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1.2,null,null,null,null,null,null,"Fiji"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1.2,null,null,null,null,null,null,"French Guiana"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1.2,null,null,null,null,null,null,"Gabon"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1.2,null,null,null,null,null,null,"Gambia"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1.2,null,null,null,null,null,null,"Georgia"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1.2,null,null,null,null,null,null,"Ghana"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1.2,null,null,null,null,null,null,"Gibraltar"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1.2,null,null,null,null,null,null,"Grenada"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1.2,null,null,null,null,null,null,"Guatemala"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1.2,null,null,null,null,null,null,"Guinea"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1.2,null,null,null,null,null,null,"Guinea-Bissau"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1.2,null,null,null,null,null,null,"Guyana"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1.2,null,null,null,null,null,null,"Haiti"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1.2,null,null,null,null,null,null,"Holy See"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1.2,null,null,null,null,null,null,"Honduras"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1.2,null,null,null,null,null,null,"Hong Kong"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1.2,null,null,null,null,null,null,"India"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1.2,null,null,null,null,null,null,"Indonesia"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1.2,null,null,null,null,null,null,"Iran"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1.2,null,null,null,null,null,null,"Iraq"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1.2,null,null,null,null,null,null,"Isle of Man"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1.2,null,null,null,null,null,null,"Israel"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1.2,null,null,null,null,null,null,"Jamaica"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1.2,null,null,null,null,null,null,"Japan"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1.2,null,null,null,null,null,null,"Jordan"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1.2,null,null,null,null,null,null,"Kazakhstan"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1.2,null,null,null,null,null,null,"Kenya"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1.2,null,null,null,null,null,null,"Kiribati"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1.2,null,null,null,null,null,null,"Kuwait"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1.2,null,null,null,null,null,null,"Kyrgyzstan"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1.2,null,null,null,null,null,null,"Laos"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1.2,null,null,null,null,null,null,"Lebanon"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1.2,null,null,null,null,null,null,"Lesotho"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1.2,null,null,null,null,null,null,"Liberia"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1.2,null,null,null,null,null,null,"Libya"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1.2,null,null,null,null,null,null,"Macao"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1.2,null,null,null,null,null,null,"Madagascar"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1.2,null,null,null,null,null,null,"Malawi"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1.2,null,null,null,null,null,null,"Malaysia"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1.2,null,null,null,null,null,null,"Maldives"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1.2,null,null,null,null,null,null,"Mali"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1.2,null,null,null,null,null,null,"Marshall Islands"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1.2,null,null,null,null,null,null,"Mauritania"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1.2,null,null,null,null,null,null,"Mauritius"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1.2,null,null,null,null,null,null,"Mayotte"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1.2,null,null,null,null,null,null,"Mexico"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1.2,null,null,null,null,null,null,"Micronesia"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1.2,null,null,null,null,null,null,"Moldova"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1.2,null,null,null,null,null,null,"Monaco"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1.2,null,null,null,null,null,null,"Mongolia"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1.2,null,null,null,null,null,null,"Montenegro"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1.2,null,null,null,null,null,null,"Morocco"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1.2,null,null,null,null,null,null,"Mozambique"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1.2,null,null,null,null,null,null,"Myanmar"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1.2,null,null,null,null,null,null,"Namibia"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1.2,null,null,null,null,null,null,"Nauru"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1.2,null,null,null,null,null,null,"Nepal"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1.2,null,null,null,null,null,null,"New Zealand"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1.2,null,null,null,null,null,null,"Nicaragua"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1.2,null,null,null,null,null,null,"Niger"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1.2,null,null,null,null,null,null,"Nigeria"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1.2,null,null,null,null,null,null,"North Korea"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1.2,null,null,null,null,null,null,"North Macedonia"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1.2,null,null,null,null,null,null,"Oman"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1.2,null,null,null,null,null,null,"Pakistan"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1.2,null,null,null,null,null,null,"Palau"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1.2,null,null,null,null,null,null,"Panama"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1.2,null,null,null,null,null,null,"Papua New Guinea"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1.2,null,null,null,null,null,null,"Paraguay"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1.2,null,null,null,null,null,null,"Peru"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1.2,null,null,null,null,null,null,"Philippines"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1.2,null,null,null,null,null,null,"Qatar"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1.2,null,null,null,null,null,null,"Réunion"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1.2,null,null,null,null,null,null,"Russia"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1.2,null,null,null,null,null,null,"Rwanda"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1.2,null,null,null,null,null,null,"Saint Helena"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1.2,null,null,null,null,null,null,"Saint Kitts and Nevis"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1.2,null,null,null,null,null,null,"Saint Lucia"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1.2,null,null,null,null,null,null,"Saint Vincent and the Grenadines"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1.2,null,null,null,null,null,null,"Samoa"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1.2,null,null,null,null,null,null,"San Marino"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1.2,null,null,null,null,null,null,"Sao Tome & Principe"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1.2,null,null,null,null,null,null,"Saudi Arabia"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1.2,null,null,null,null,null,null,"Senegal"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1.2,null,null,null,null,null,null,"Serbia"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1.2,null,null,null,null,null,null,"Seychelles"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1.2,null,null,null,null,null,null,"Sierra Leone"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1.2,null,null,null,null,null,null,"Singapore"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1.2,null,null,null,null,null,null,"Solomon Islands"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1.2,null,null,null,null,null,null,"Somalia"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1.2,null,null,null,null,null,null,"South Africa"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1.2,null,null,null,null,null,null,"South Korea"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1.2,null,null,null,null,null,null,"South Sudan"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1.2,null,null,null,null,null,null,"Sri Lanka"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1.2,null,null,null,null,null,null,"State of Palestine"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1.2,null,null,null,null,null,null,"Sudan"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1.2,null,null,null,null,null,null,"Suriname"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1.2,null,null,null,null,null,null,"Switzerland"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1.2,null,null,null,null,null,null,"Syria"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1.2,null,null,null,null,null,null,"Taiwan"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1.2,null,null,null,null,null,null,"Tajikistan"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1.2,null,null,null,null,null,null,"Tanzania"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1.2,null,null,null,null,null,null,"Thailand"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1.2,null,null,null,null,null,null,"Timor-Leste"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1.2,null,null,null,null,null,null,"Tonga"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1.2,null,null,null,null,null,null,"Togo"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1.2,null,null,null,null,null,null,"Trinidad and Tobago"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1.2,null,null,null,null,null,null,"Tunisia"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1.2,null,null,null,null,null,null,"Turkey"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1.2,null,null,null,null,null,null,"Turkmenistan"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1.2,null,null,null,null,null,null,"Tuvalu"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1.2,null,null,null,null,null,null,"Uganda"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1.2,null,null,null,null,null,null,"Ukraine"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1.2,null,null,null,null,null,null,"United Arab Emirates"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1.2,null,null,null,null,null,null,"United Kingdom"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1.2,null,null,null,null,null,null,"United States"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1.2,null,null,null,null,null,null,"Uruguay"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1.2,null,null,null,null,null,null,"Uzbekistan"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1.2,null,null,null,null,null,null,"Vanuatu"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1.2,null,null,null,null,null,null,"Venezuela"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1.2,null,null,null,null,null,null,"Vietnam"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1.2,null,null,null,null,null,null,"Western Sahara"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1.2,null,null,null,null,null,null,"Yemen"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1.2,null,null,null,null,null,null,"Zambia"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1.2,null,null,null,null,null,null,"Zimbabwe"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1.2]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1.2]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1.2]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1.2]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1.2]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1.2]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1.2]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1.2]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1.2]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1.2]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1.2]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1.2]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1.2]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1.2]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1.2]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1.2]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1.2]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1.2]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1.2]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1.2]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1.2]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1.2]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1.2]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1.2]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1.2]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1.2]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1.2]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1.2]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1.2]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1.2]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1.2]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1.2]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1.2]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1.2]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1.2]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1.2]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1.2]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1.2]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1.2]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1.2]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1.2]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1.2]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1.2]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1.2]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1.2]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1.2]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1.2]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1.2]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1.2]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1.2]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1.2]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1.2]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1.2]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1.2]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1.2]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1.2]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1.2]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1.2]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1.2]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1.2]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1.2]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1.2]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1.2]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1.2]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1.2]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1.2]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1.2]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1.2]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1.2]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1.2]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1.2]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1.2]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1.2]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1.2]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1.2]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1.2]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1.2]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1.2]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1.2]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1.2]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1.2]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1.2]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1.2]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1.2]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1.2]
[]
["Employees"]
[]
["2. Kindly indicate the total number of employees as at the end of the reporting period, irrespective of their involvement in the provision of investment services. ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2]
[null,"of which outsourced",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2]
[]
[]
["Questions 3 and 4 are only applicable to Investment Firms who utilise Introducing Brokers and/or Affiliates to facilitate the cross-border distribution of financial products. Kindly include N/A in Question 3 if the Company does not make use of Introducing Brokers and/or Affiliates. "]
[]
["Declaration by the Compliance Officers and the Firm's Executive Directors"]
[]
["3. If the Company made use of Introducing Brokers and/or Affiliates during the reporting period, Compliance Officer & Executive Directors are requested to confirm that the promotional and marketing material as carried out by the firm’s Introducing Brokers and/or Affiliates is clear, fair and not misleading in accordance with the requirements of MiFID II and is subject to pre-approval and ongoing monitoring by the Firm. If the Company did not make use of Introducing Brokers and/or Affiliates, kindly include N/A. ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,3]
[]
["Introducing Brokers & Affiliates"]
[]
["4. For the relevant reporting period, kindly disclose the names and websites of the top 10 Introducing Brokers and/or Affiliates which directed the largest client traffic (in terms of numbers of clients onboarded) to the firm. "]
[]
[null,"Name",null,null,null,"Website",null,"Number of retail clients onboarded",null,"Number of professional clients onboarded",null,"Number of elective professional clients onboarded",null,"Number of eligible counterparties onboarded",null,"Total clients onboarded",null,"Number of complaints received"]
[1,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(H286,J286,L286,N286)","v":0},null,null,null,4]
[2,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(H287,J287,L287,N287)","v":0},null,null,null,4]
[3,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,4]
[4,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,4]
[5,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,4]
[6,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,4]
[7,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,4]
[8,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,4]
[9,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,4]
[10,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,4]

{"sheet":"B - Financial Details","index":10,"n_rows":411,"n_cols":16,"rows_kept":411,"cut":false,"hidden":false,"merged":[[287,1,287,3],[288,1,288,3],[289,1,289,3],[290,1,290,3],[347,1,349,11],[281,1,281,3],[282,1,282,3],[283,1,283,3],[284,1,284,3],[285,1,285,3],[286,1,286,3],[275,1,275,3],[276,1,276,3],[277,1,277,3],[278,1,278,3],[279,1,279,3],[280,1,280,3],[269,1,269,3],[270,1,270,3],[271,1,271,3],[272,1,272,3],[273,1,273,3],[274,1,274,3],[263,1,263,3],[264,1,264,3],[265,1,265,3],[266,1,266,3],[267,1,267,3],[268,1,268,3],[257,1,257,3],[258,1,258,3],[259,1,259,3],[260,1,260,3],[261,1,261,3],[262,1,262,3],[251,1,251,3],[252,1,252,3],[253,1,253,3],[254,1,254,3],[255,1,255,3],[256,1,256,3],[245,1,245,3],[246,1,246,3],[247,1,247,3],[248,1,248,3],[249,1,249,3],[250,1,250,3],[239,1,239,3],[240,1,240,3],[241,1,241,3],[242,1,242,3],[243,1,243,3],[244,1,244,3],[233,1,233,3],[234,1,234,3],[235,1,235,3],[236,1,236,3],[237,1,237,3],[238,1,238,3],[227,1,227,3],[228,1,228,3],[229,1,229,3],[230,1,230,3],[231,1,231,3],[232,1,232,3],[221,1,221,3],[222,1,222,3],[223,1,223,3],[224,1,224,3],[225,1,225,3],[226,1,226,3],[204,1,204,3],[215,1,215,3],[217,1,217,3],[218,1,218,3],[219,1,219,3],[220,1,220,3],[198,1,198,3],[199,1,199,3],[200,1,200,3],[201,1,201,3],[202,1,202,3],[203,1,203,3],[192,1,192,3],[193,1,193,3],[194,1,194,3],[195,1,195,3],[196,1,196,3],[197,1,197,3],[186,1,186,3],[187,1,187,3],[188,1,188,3],[189,1,189,3],[190,1,190,3],[191,1,191,3],[180,1,180,3],[181,1,181,3],[182,1,182,3],[183,1,183,3],[184,1,184,3],[185,1,185,3],[174,1,174,3],[175,1,175,3],[176,1,176,3],[177,1,177,3],[178,1,178,3],[179,1,179,3],[168,1,168,3],[169,1,169,3],[170,1,170,3],[171,1,171,3],[172,1,172,3],[173,1,173,3],[162,1,162,3],[163,1,163,3],[164,1,164,3],[165,1,165,3],[166,1,166,3],[167,1,167,3],[156,1,156,3],[157,1,157,3],[158,1,158,3],[159,1,159,3],[160,1,160,3],[161,1,161,3],[150,1,150,3],[151,1,151,3],[152,1,152,3],[153,1,153,3],[154,1,154,3],[155,1,155,3],[144,1,144,3],[145,1,145,3],[146,1,146,3],[147,1,147,3],[148,1,148,3],[149,1,149,3],[138,1,138,3],[139,1,139,3],[140,1,140,3],[141,1,141,3],[142,1,142,3],[143,1,143,3],[132,1,132,3],[133,1,133,3],[134,1,134,3],[135,1,135,3],[136,1,136,3],[137,1,137,3],[126,1,126,3],[127,1,127,3],[128,1,128,3],[129,1,129,3],[130,1,130,3],[131,1,131,3],[120,1,120,3],[121,1,121,3],[122,1,122,3],[123,1,123,3],[124,1,124,3],[125,1,125,3],[114,1,114,3],[115,1,115,3],[116,1,116,3],[117,1,117,3],[118,1,118,3],[119,1,119,3],[97,1,97,3],[98,1,98,3],[99,1,99,3],[110,1,110,3],[112,1,112,3],[113,1,113,3],[91,1,91,3],[92,1,92,3],[93,1,93,3],[94,1,94,3],[95,1,95,3],[96,1,96,3],[85,1,85,3],[86,1,86,3],[87,1,87,3],[88,1,88,3],[89,1,89,3],[90,1,90,3],[79,1,79,3],[80,1,80,3],[81,1,81,3],[82,1,82,3],[83,1,83,3],[84,1,84,3],[73,1,73,3],[74,1,74,3],[75,1,75,3],[76,1,76,3],[77,1,77,3],[78,1,78,3],[67,1,67,3],[68,1,68,3],[69,1,69,3],[70,1,70,3],[71,1,71,3],[72,1,72,3],[61,1,61,3],[62,1,62,3],[63,1,63,3],[64,1,64,3],[65,1,65,3],[66,1,66,3],[55,1,55,3],[56,1,56,3],[57,1,57,3],[58,1,58,3],[59,1,59,3],[60,1,60,3],[49,1,49,3],[50,1,50,3],[51,1,51,3],[52,1,52,3],[53,1,53,3],[54,1,54,3],[43,1,43,3],[44,1,44,3],[45,1,45,3],[46,1,46,3],[47,1,47,3],[48,1,48,3],[37,1,37,3],[38,1,38,3],[39,1,39,3],[40,1,40,3],[41,1,41,3],[42,1,42,3],[31,1,31,3],[32,1,32,3],[33,1,33,3],[34,1,34,3],[35,1,35,3],[36,1,36,3],[25,1,25,3],[26,1,26,3],[27,1,27,3],[28,1,28,3],[29,1,29,3],[30,1,30,3],[19,1,19,3],[20,1,20,3],[21,1,21,3],[22,1,22,3],[23,1,23,3],[24,1,24,3],[13,1,13,3],[14,1,14,3],[15,1,15,3],[16,1,16,3],[17,1,17,3],[18,1,18,3],[0,0,0,12],[7,1,7,3],[9,1,9,3],[10,1,10,3],[11,1,11,3],[12,1,12,3]]}
["Financial Details"]
[null,null,null,null,null,null,null,null,null,null,null,0]
[]
[null,"1a. Clients' Money - Retail",null,null,null,null,null,null,null,null,null,"Insert Yes/ No"]
[null,"As at Reporting Date, has the licence holder held or controlled Retail Clients' Money ?",null,null,null,null,null,null,null,null,null,null,null,null,null,"1a"]
[null,"If NO, skip section below"]
[]
[null,"Name of Bank",null,null,null,"Account No.",null,"Currency",null,"Equivalent in €"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"1a"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"1a"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"1a"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"1a"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"1a"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"1a"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"1a"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"1a"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"1a"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"1a"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"1a"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"1a"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"1a"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"1a"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"1a"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"1a"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"1a"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"1a"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"1a"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"1a"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"1a"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"1a"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"1a"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"1a"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"1a"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"1a"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"1a"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"1a"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"1a"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"1a"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"1a"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"1a"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"1a"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"1a"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"1a"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"1a"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"1a"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"1a"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"1a"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"1a"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"1a"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"1a"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"1a"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"1a"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"1a"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"1a"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"1a"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"1a"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"1a"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"1a"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"1a"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"1a"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"1a"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"1a"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"1a"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"1a"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"1a"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"1a"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"1a"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"1a"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"1a"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"1a"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"1a"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"1a"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"1a"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"1a"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"1a"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"1a"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"1a"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"1a"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"1a"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"1a"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"1a"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"1a"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"1a"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"1a"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"1a"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"1a"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"1a"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"1a"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"1a"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"1a"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"1a"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"1a"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"1a"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"1a"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"1a"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"1a"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"1a"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"1a"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"1a"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"1a"]
[null,"Total Equivalent in €",null,null,null,null,null,null,null,{"$f":"SUM(J10:J100)","v":0},null,null,null,null,null,"1a"]
[]
[null,"Total number of clients pertaining to Total Clients' Money",null,null,null,null,null,null,null,null,null,null,null,null,null,"1a"]
[]
[]
[null,"1b. Clients' Money - Professional & Elective Professional",null,null,null,null,null,null,null,null,null,"Insert Yes/ No"]
[null,"As at Reporting Date, has the licence holder held or controlled Professional Clients' Money ?",null,null,null,null,null,null,null,null,null,null,null,null,null,"1b"]
[null,"If NO, skip section below"]
[]
[null,"Name of Bank",null,null,null,"Account No.",null,"Currency",null,"Equivalent in €"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"1b"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"1b"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"1b"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"1b"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"1b"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"1b"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"1b"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"1b"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"1b"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"1b"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"1b"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"1b"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"1b"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"1b"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"1b"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"1b"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"1b"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"1b"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"1b"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"1b"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"1b"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"1b"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"1b"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"1b"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"1b"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"1b"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"1b"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"1b"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"1b"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"1b"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"1b"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"1b"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"1b"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"1b"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"1b"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"1b"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"1b"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"1b"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"1b"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"1b"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"1b"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"1b"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"1b"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"1b"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"1b"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"1b"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"1b"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"1b"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"1b"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"1b"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"1b"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"1b"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"1b"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"1b"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"1b"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"1b"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"1b"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"1b"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"1b"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"1b"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"1b"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"1b"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"1b"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"1b"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"1b"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"1b"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"1b"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"1b"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"1b"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"1b"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"1b"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"1b"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"1b"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"1b"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"1b"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"1b"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"1b"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"1b"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"1b"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"1b"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"1b"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"1b"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"1b"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"1b"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"1b"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"1b"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"1b"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"1b"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"1b"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"1b"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"1b"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"1b"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"1b"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"1b"]
[null,"Total Equivalent in €",null,null,null,null,null,null,null,{"$f":"SUM(J113:J205)","v":0},null,null,null,null,null,"1b"]
[]
[null,"Total number of clients pertaining to Total Clients' Money",null,null,null,null,null,null,null,null,null,null,null,null,null,"1b"]
[]
[]
[null,"1c. Clients' Money - Eligible Counterparty",null,null,null,null,null,null,null,null,null,"Insert Yes/ No"]
[null,"As at Reporting Date, has the licence holder held or controlled Eligible Counterparty's' Money ?",null,null,null,null,null,null,null,null,null,null,null,null,null,"1c"]
[null,"If NO, skip section below"]
[]
[null,"Name of Bank",null,null,null,"Account No.",null,"Currency",null,"Equivalent in €"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"1c"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"1c"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"1c"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"1c"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"1c"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"1c"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"1c"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"1c"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"1c"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"1c"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"1c"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"1c"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"1c"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"1c"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"1c"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"1c"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"1c"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"1c"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"1c"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"1c"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"1c"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"1c"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"1c"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"1c"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"1c"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"1c"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"1c"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"1c"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"1c"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"1c"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"1c"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"1c"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"1c"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"1c"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"1c"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"1c"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"1c"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"1c"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"1c"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"1c"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"1c"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"1c"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"1c"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"1c"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"1c"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"1c"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"1c"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"1c"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"1c"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"1c"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"1c"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"1c"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"1c"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"1c"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"1c"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"1c"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"1c"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"1c"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"1c"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"1c"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"1c"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"1c"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"1c"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"1c"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"1c"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"1c"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"1c"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"1c"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"1c"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"1c"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"1c"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"1c"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"1c"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"1c"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"1c"]
[null,"Total Equivalent in €",null,null,null,null,null,null,null,{"$f":"SUM(J218:J291)","v":0},null,null,null,null,null,"1c"]
[]
[null,"Total number of clients pertaining to Total Clients' Money",null,null,null,null,null,null,null,null,null,null,null,null,null,"1c"]
[]
[]
[null,"2. Clients' Instruments",null,null,null,null,null,null,null,null,null,"Insert Yes/ No"]
[null,"As at reporting date, has the licence holder held or controlled Customers' Assets?",null,null,null,null,null,null,null,null,null,null,null,null,null,2]
[]
[null,"Value of Clients' Holdings at end of reporting period:",null,null,null,null,null,null,null,"No. of clients",null,"Total Equivalent in €"]
[null,null,null,null,"Retail",null,null,null,null,null,null,null,null,null,null,2]
[null,null,null,null,"Professional",null,null,null,null,null,null,null,null,null,null,2]
[null,null,null,null,null,"of which CISs",null,null,null,null,null,null,null,null,null,2]
[null,null,null,null,"Eligible Counterparty",null,null,null,null,null,null,null,null,null,null,2]
[null,null,null,null,"Total",null,null,null,null,{"$f":"SUM(J302:J305)","v":0},null,{"$f":"SUM(L302:L305)","v":0},null,null,null,2]
[]
[]
[]
[null,"3. Discretionary Portfolio Management"]
[null,null,null,null,null,null,null,null,null,null,null,"Insert Yes/ No"]
[null,"Does the licence holder provide Discretionary Portfolio Management Services?",null,null,null,null,null,null,null,null,null,null,null,null,null,3]
[]
[]
[null,"Value of AUM at the end of reporting period",null,null,null,null,null,"",null,"",null,""]
[]
[null,null,null,null,null,null,null,null,null,"No. of clients",null," Equivalent in €"]
[]
[null,"    - Retail",null,null,null,null,null,null,null,null,null,null,null,null,null,3]
[null,"    - Professional",null,null,null,null,null,null,null,null,null,null,null,null,null,3]
[null,"of which CISs",null,null,null,null,null,null,null,null,null,null,null,null,null,3]
[null,"    - Eligible Counterparty",null,null,null,null,null,null,null,null,null,null,null,null,null,3]
[]
[null,"Total Value",null,null,null,null,null,null,null,{"$f":"SUM(J319:J322)","v":0},null,{"$f":"SUM(L319:L322)","v":0},null,null,null,3]
[]
[]
[]
[null,"4. Investment Services Activities & Ancillary Services (for each of the below items, pick one of the options)"]
[]
[null,null,null,null,null,null,null,null,null,null,null,"Choose from options"]
[null,"1. Reception and transmission of orders",null,null,null,null,null,null,null,null,null,null,null,null,null,4]
[null,"2. Execution of orders",null,null,null,null,null,null,null,null,null,null,null,null,null,4]
[null,"3. Dealing on own account",null,null,null,null,null,null,null,null,null,null,null,null,null,4]
[null,"4. Portfolio management",null,null,null,null,null,null,null,null,null,null,null,null,null,4]
[null,"5. Investment advice",null,null,null,null,null,null,null,null,null,null,null,null,null,4]
[null,"6. Underwriting or placing on firm commitment",null,null,null,null,null,null,null,null,null,null,null,null,null,4]
[null,"7. Placing without firm commitment",null,null,null,null,null,null,null,null,null,null,null,null,null,4]
[null,"8. Safekeeping and administration",null,null,null,null,null,null,null,null,null,null,null,null,null,4]
[null,"9. Granting credits or loans",null,null,null,null,null,null,null,null,null,null,null,null,null,4]
[null,"10. Advice on capital structure",null,null,null,null,null,null,null,null,null,null,null,null,null,4]
[null,"11. Foreign exchange services",null,null,null,null,null,null,null,null,null,null,null,null,null,4]
[null,"12. Research and financial analysis",null,null,null,null,null,null,null,null,null,null,null,null,null,4]
[null,"13. Services related to underwriting",null,null,null,null,null,null,null,null,null,null,null,null,null,4]
[null,"14. Investment services regarding certain financial instruments",null,null,null,null,null,null,null,null,null,null,null,null,null,4]
[]
[null,"5. Other Details"]
[null,"   Input any other details or comments:"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,5]
[]
[]
[]
[]
[null,"Austria",null,"Reception and Transmission of Orders "]
[null,"Belgium",null,"Execution of orders on behalf of clients"]
[null,"Bulgaria",null,"Dealing on Own Account"]
[null,"Croatia",null,"Portfolio Management "]
[null,"Cyprus",null,"Investment Advice"]
[null,"Czech Republic",null,"Underwriting / placing of instruments on a firm commitment basis"]
[null,"Denmark",null,"Placing of Instruments without a firm commitment basis"]
[null,"Estonia",null,"Operation of a Multilateral Trading Facility "]
[null,"Finland",null,"Safekeeping and Administration of Financial Instruments "]
[null,"France",null,"Granting of credits or loans to an investor "]
[null,"Germany",null,"Advice to undertakings on capital Structure, Industrial Strategy and related Matters"]
[null,"Greece",null,"Foreign Exchange Services "]
[null,"Gibraltar",null,"Investment Research and Financial Analysis "]
[null,"Hungary",null,"Services Related to Undertakings"]
[null,"Iceland",null,"Investment and Ancillary Services relating to the underlying of certain derivatives"]
[null,"Ireland"]
[null,"Italy"]
[null,"Latvia"]
[null,"Liechtenstein"]
[null,"Lithuania"]
[null,"Luxembourg"]
[null,"Netherlands"]
[null,"Norway"]
[null,"Poland"]
[null,"Portugal"]
[null,"Romania"]
[null,"Slovakia"]
[null,"Slovenia"]
[null,"Spain"]
[null,"Sweden"]
[null,"UK"]
[]
[]
[]
[]
[]
[]
[null,null,null,"YES"]
[null,null,null,"NO"]
[null,null,null,"N/A"]
[]
[null,null,null,"AUD"]
[null,null,null,"CAD"]
[null,null,null,"CHF"]
[null,null,null,"DKK"]
[null,null,null,"EUR"]
[null,null,null,"FIM"]
[null,null,null,"GBP"]
[null,null,null,"HKD"]
[null,null,null,"JPY"]
[null,null,null,"CNY"]
[null,null,null,"CHF"]
[null,null,null,"NOK"]
[null,null,null,"NZD"]
[null,null,null,"SEK"]
[null,null,null,"USD"]
[null,"Not Licenced"]
[null,"Licenced & used"]
[null,"Licenced & not used"]

{"sheet":"B - Statement of c. income","index":11,"n_rows":124,"n_cols":16,"rows_kept":124,"cut":false,"hidden":false,"merged":[[123,1,123,10],[0,0,0,12],[70,1,70,5],[71,1,71,5],[117,1,117,10],[120,1,120,10],[104,6,105,6],[4,2,4,9]]}
["Statement of comprehensive income"]
[]
[]
[null,"Revenue","(Activities shall pertain to Section A and B of the list of services and activities and financial instruments in Annex I of MiFID II)"]
[null,null,"Note: Commission and fees not arising from activities licensed in terms of the Investment Services Act should not be included in Sections 1.0 - 15.0 but should be listed in Section 17.0 b) if these are not related to investment services activities.\t "]
[]
[]
[1,"Fees relating to reception and transmission of orders",null,null,null,null,null,null,null,null,0]
[]
[]
[]
[2,"Fees relating to execution of orders",null,null,null,null,null,null,null,null,0]
[]
[]
[]
[3,"Profit/loss generated by dealing on own account",null,null,null,null,null,null,null,null,0]
[]
[]
[]
[4,"Fees relating to portfolio management",null,null,null,null,null,null,null,null,0]
[]
[]
[]
[5,"Fees relating to investment advice",null,null,null,null,null,null,null,null,0]
[]
[]
[]
[6,"Fees relating to underwriting or placing on firm commitment",null,null,null,null,null,null,null,null,0]
[]
[]
[]
[7,"Fees relating to the placing without firm commitment",null,null,null,null,null,null,null,null,0]
[]
[]
[]
[8,"Fees generated from safekeeping and administration (Under MiFID II)",null,null,null,null,null,null,null,null,0]
[]
[]
[]
[9,"Fees relating to granting credits or loans*",null,null,null,null,null,null,null,null,0]
[]
[]
[]
[10,"Fees relating to advice on capital structures",null,null,null,null,null,null,null,null,0]
[]
[]
[]
[11,"Fees relating to foreign exchange services",null,null,null,null,null,null,null,null,0]
[]
[]
[]
[12,"Fees relating to research and financial analysis",null,null,null,null,null,null,null,null,0]
[]
[]
[]
[13,"Fees relating to services related to underwriting",null,null,null,null,null,null,null,null,0]
[]
[]
[]
[14,"Fees relating to investment services regarding certain financial instruments",null,null,null,null,null,null,null,null,0]
[]
[]
[15,"Non-ISA related revenue**",null,null,null,null,null,null,null,null,0]
[]
[]
[16,"Total Revenue",null,null,null,null,null,null,null,null,{"$f":"SUM(K3:K63)","v":0}]
[]
[null,"Operating Expenses"]
[]
[17,"Commissions and fees"]
[17.100000000000001,"a) Commissions and fees that are directly related to the acquisition of gross revenue, derived from investment services activities, paid or payable to third parties",null,null,null,null,0]
[17.2,"b) Other Commissions and fees paid or payable to third parties, not related to investment services activities",null,null,null,null,0,"Total Commissions and Fees",null,null,{"$f":"SUM(G71:G72)","v":0}]
[]
[]
[18,"Exceptional Items of expenditure"]
[18.100000000000001,"a) Allowed by MFSA***",null,null,null,null,0]
[18.2,"b) Other",null,null,null,null,0,"Total Exceptional items",null,null,{"$f":"SUM(G76:G77)","v":0}]
[]
[19,"Total Operating Expenses ",null,null,null,null,null,null,null,null,{"$f":"+K72+K77","v":0}]
[]
[20,"Gross Profit ",null,null,null,null,null,null,null,null,{"$f":"K66-K79","v":0}]
[]
[]
[21,"Administrative Expenses",null,null,null,null,null,null,null,null,0]
[]
[22,"Operating Profit (loss)",null,null,null,null,null,null,null,null,{"$f":"K81-K84","v":0}]
[]
[23,"k) Finance Income",null,null,null,null,0]
[]
[24,"l)  Finance Cost",null,null,null,null,0]
[]
[25,"m) Fair Value through Profit or Loss",null,null,null,null,0]
[]
[26,"Profit (Loss) before tax ",null,null,null,null,null,null,null,null,{"$f":"+K86+G88+G90+G92","v":0}]
[]
[27,"Tax (expense) income",null,null,null,null,null,null,null,null,0]
[]
[28,"Profit (Loss) after tax ",null,null,null,null,null,null,null,null,{"$f":"K94-K96","v":0}]
[]
[]
[29,"Other Comprehensive Income"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"gain","losses"]
[29.1,"n) Fair value movements on Intangible Assets",null,null,null,null,0,null,null,null,null,null,null,0,0]
[29.2,"o) Gain/Loss on revaluation of available for sale Financial Assets",null,null,null,null,0,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,0,0]
[29.3,"p)  Gain/Loss on revaluation of property",null,null,null,null,0,null,null,null,null,null,null,0,0]
[29.4,"q) Other items of income and expense included in other comprehensive income",null,null,null,null,0,null,null,null,null,null,null,0,0]
[29.5,"r) Tax income/expense relating to components of other comprehensive income",null,null,null,null,0,"Other Comprehensive Income",null,null,{"$f":"+G104+G105+G107+G108+G109","v":0},null,null,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,0,0]
[30,"Total Comprehensive Income",null,null,null,null,null,null,null,null,{"$f":"+K98+K109","v":0}]
[]
[null,null,null,null,null,null,null,null,null,"VALIDATION SHEET 2",0]
[]
[31,"Additonal Details*"]
[]
[31.1,"* Details of credits or loans granted:"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,31.1]
[]
[31.2,"** Details of 'Non-ISA related revenue':"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,31.2]
[]
[31.3,"*** Details of 'Exceptional Items of expenditure Allowed by the MFSA':"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,31.3]

{"sheet":"B - Statement of f. position","index":12,"n_rows":68,"n_cols":10,"rows_kept":68,"cut":false,"hidden":false,"merged":[[0,0,0,10],[66,1,66,9],[67,1,70,9]]}
["Statement of financial position"]
[]
[]
[null,"Assets"]
[null,null,null,null,null,null,"",null,null,""]
[1,"Non-current"]
[1.1000000000000001,"a) Intangible assets",null,null,null,null,0]
[1.2,"b) Property, Plant and Equipment",null,null,null,null,0]
[1.3,"c) Investment Property",null,null,null,null,0,"Total Non-current assets",null,{"$f":"SUM(G7:G9)","v":0}]
[]
[2,"Current Assets"]
["2.1.1","a) Inventories",null,null,null,null,0]
["2.1.2","b) Deferred Tax Asset",null,null,null,null,0]
["2.1.3","c) Financial Instruments - Long Positions",null,null,null,null,0]
["2.1.4","d) Trading Book Debtors",null,null,null,null,0]
["2.1.5","e) Non-Trading Book Debtors",null,null,null,null,0]
["2.1.6","f) Amounts due from group companies**",null,null,null,null,0]
["2.1.7","g) Amounts due from other connected persons*",null,null,null,null,0]
["2.1.8","h) Amounts receivable from government bodies",null,null,null,null,0]
["2.1.9","i) Amounts receivable from financial institutions",null,null,null,null,0]
["2.1.10","j) Bank and cash balances",null,null,null,null,0]
["2.1.11","k) Other receivables",null,null,null,null,0,"Total Current Assets",null,{"$f":"SUM(G12:G22)","v":0}]
[]
[9,"Total Assets",null,null,null,null,null,null,null,{"$f":"+J9+J22","v":0}]
[]
[null,"Equity"]
[]
[3,"Equity and Other Reserves"]
[3.1,"a) Called up ordinary share capital ",null,null,null,null,0]
[3.2,"b) Preference share capital",null,null,null,null,0]
[3.3,"c) Investor Compensation Scheme Reserve",null,null,null,null,0]
[3.4,"d) Share premium account",null,null,null,null,0]
[3.5,"e) Revenue reserves",null,"i) as per the previous year's audited accounts",null,null,0]
[3.6,"e) Revenue reserves",null,"ii) retained profits/ (loss) for the year/ period",null,null,0]
[3.7,"f) Other Comprehensive Income  i) as per the previous year's audited accounts",null,null,null,null,0]
[3.8,"f) Other Comprehensive Income  ii) other comprehensive income for the year/period",null,null,null,null,0]
[3.9,"g) Other reserves",null,null,null,null,0,"Total Equity and other reserves",null,{"$f":"SUM(G29:G37)","v":0}]
[]
[4,"Minority Interest",null,null,null,null,null,null,null,0]
[]
[null,"Liabilities"]
[]
[5,"Non-current"]
[5.0999999999999996,"a) Loans: ","i) subordinated",null,null,null,0]
[5.2,"a) Loans:        ","ii) other",null,null,null,0]
[5.3,"a) Loans:        ","iii) total",null,null,null,{"$f":"+G44+G45","v":0}]
[5.4,"b) Amounts due to group companies**",null,null,null,null,0]
[5.5,"c) Amounts due to other connected persons* ",null,null,null,null,0]
[5.6,"d) Other Payables",null,null,null,null,0,"Total Non-current liabilities",null,{"$f":"SUM(G46:G49)","v":0}]
[]
[6,"Current"]
[6.1,"a) Loans/overdrafts",null,null,null,null,0]
[6.2,"b) Taxation",null,null,null,null,0]
[6.3,"c) Amounts due to group companies**",null,null,null,null,0]
[6.4,"d) Amounts due to other connected persons* ",null,null,null,null,0]
[6.5,"e) Financial instruments - Short Positions ",null,null,null,null,0]
[6.6,"f) Other payables",null,null,null,null,0]
[6.7,"g) Deferred Tax Liability",null,null,null,null,0]
[6.8,"h) Provisions for liabilities",null,null,null,null,0]
[6.9,"i) Financial Liabilities",null,null,null,null,0,"Total Current liabilities",null,{"$f":"SUM(G52:G60)","v":0}]
[]
[7,"Total Liabilities",null,null,null,null,null,null,null,{"$f":"+J49+J60","v":0}]
[]
[]
[10,"Total Equity and Liabilities",null,null,null,null,null,null,null,{"$f":"+J62+J39+J37","v":0}]
[]
[8,"* Details of 'Amounts due to/ from other connected persons' and/or **'Amounts due to/ from group Companies' and/or Any other details or comments:"]
[8]

{"sheet":"B - Supervisory Fee Calculator","index":13,"n_rows":57,"n_cols":18,"rows_kept":57,"cut":false,"hidden":false,"merged":[[54,1,54,7],[33,2,33,3],[36,2,36,3],[42,2,42,3],[44,2,44,3],[49,1,50,7],[52,1,53,7],[31,2,31,3],[0,0,0,9],[2,3,2,4],[3,3,3,4],[11,3,12,3],[28,2,28,3]]}
["ANNUAL SUPERVISORY FEE CALCULATOR",null,null,null,null,null,null,null,null,null,null,"Category 1A",null,2000,350,{"$f":"IF($E$21<50000,0,IF($E$21<=1000000,(ROUNDUP((($E$21-50000)/50000),0)*$O$1),(19*$O$1)))","v":0},{"$f":"N1+P1","v":2000},"EUR"]
[null,null,null,null,null,null,null,null,null,null,null,"Category 1B",null,2750,350,{"$f":"IF($E$21<50000,0,IF($E$21<=1000000,(ROUNDUP((($E$21-50000)/50000),0)*$O$2),(19*$O$2)))","v":0},{"$f":"N2+P2","v":2750},"GBP"]
[null,null,null,"(To be signed and submitted in hard copy on an Annual basis together with the Audited Financial Statements)",null,null,null,null,null,null,null,"Category 2",null,4500,400,{"$f":"IF($E$21<250000,0,IF($E$21<=5000000,(ROUNDUP((($E$21-250000)/250000),0)*$O$3),(19*$O$3)))","v":0},{"$f":"N3+P3","v":4500},"USD"]
[null,null,null,null,null,null,null,null,null,null,null,"Category 3",null,6000,400,{"$f":"IF($E$21<250000,0,IF($E$21<=50000000,(ROUNDUP((($E$21-250000)/250000),0)*$O$4),(199*$O$4)))","v":0},{"$f":"N4+P4","v":6000}]
[null,null,null,null,null,null,null,null,null,null,null,"Category 4A",null,15000,"N/A","N/A",{"$f":"N5","v":15000}]
[null,null,1,"Name of Licence Holder",{"$f":"'Cover Sheet'!C12","v":0},null,null,null,null,null,null,"Category 4B",null,5000,"N/A","N/A",{"$f":"N6","v":5000}]
[]
[null,null,2,"Licence Class",{"$f":"'Cover Sheet'!C16","v":0},""]
[]
[null,null,3,"Gross revenue indicated in the Annual Audited Financial Statements and that is derived from activities for which an investment services licence was issued in terms of Article 3 of the Investment Services Act",{"$f":"'B - Statement of c. income'!K66-'B - Statement of c. income'!K63","v":0},null,null,null,null,null,null,{"$f":"IF(OR('B - Financial Details'!L333=\"Licenced & not used\",'B - Financial Details'!L333=\"Licenced & used\",'B - Financial Details'!L336=\"Licenced & used\",'B - Financial Details'!L336=\"Licenced & not used\"),('B - Supervisory Fee Calculator'!Q4),IF(OR('B - Financial Details'!L332=\"Licenced & used\",'B - Financial Details'!L332=\"Licenced & not used\",'B - Financial Details'!L334=\"Licenced & used\",'B - Financial Details'!L334=\"Licenced & not used\",'B - Financial Details'!L5=\"Yes\",'B - Financial Details'!L108=\"Yes\",'B - Financial Details'!L213=\"Yes\",'B - Financial Details'!L299=\"Yes\"),'B - Supervisory Fee Calculator'!Q3,IF('A - Additional details'!H31=0,'B - Supervisory Fee Calculator'!Q2,'B - Supervisory Fee Calculator'!Q1)))","v":2750}]
[]
[null,null,4,"Commission that are directly related to the acquisition of the said gross revenue, paid or payable to third parties"]
[null,null,null,null,{"$f":"'B - Statement of c. income'!G71","v":0}]
[]
[null,null,5,"Currency in which accounts are reported",{"$f":"'Cover Sheet'!C27","v":0}]
[]
[null,null,6,"Revenue in reported currency (as defined in Subsidiary Legislation 370.03 Investment Services Act (Fees) Regulations)",{"$f":"E10-E13","v":0}]
[]
[null,null,7,"Exchange rate as at end of reporting period converting the reporting currency to EURO",{"$f":"IF(ISBLANK( 'Cover Sheet'!C29), 1, 'Cover Sheet'!C29)","v":1}]
[]
[null,null,8,"Revenue in EURO",{"$f":"E17*E19","v":0}]
[]
[null,null,9,"Annual Supervisory Fee due in EURO",{"$f":"L10","v":2750}]
[]
[null,"Signed on behalf of licence holder by :"]
[]
[null,"We confirm that the above computation is in line with the provision set out in the Subsidiary Legislation 370.03 Investment Services Act (Fees) Regulations."]
[]
[null,"Signed:",null,null,null,"Date:"]
[null,null,"(Director/ Authorised Signatory)"]
[]
[null,"Name:"]
[]
[null,"Signed:",null,null,null,"Date:"]
[null,null,"(Director/ Authorised Signatory)"]
[]
[null,"Name:"]
[]
[null,"This Section must be filled only if the return is an Annual Return.  It should be completed by the Audit Partner/ Manager in charge "]
[]
[null,"We confirm that we have checked the above fee computation ad endorsed the Licence Holder's declarations set out above. "]
[]
[null,"Signed:",null,null,null,"Date:"]
[]
[null,"Name:"]
[]
[]
[null,"Notes:"]
[]
[null,"1. Please ensure that the figures reported above are consistent with figures reported in audited financial statements and other data/ information submitted to the Malta Financial Services Authority."]
[]
[]
[null,"2. Please ensure that you send your remittance to the Malta Financial Services Authority as soon as possible. Cheques are to be sent payable to the 'Malta Financial Services Authority' and are to be sent to the:"]
[]
[null,"Malta Financial Services Authority\nFinance Department\nTriq L- Imdina, Zone 1\nCentral Business District\nBirkirkara  CBD 1010"]
[]
[null,"3. The Authroity reserves the right to carry out random or full checks of data / information and fee computation submitted."]

{"sheet":"C - Exposure to Maltese Banks","index":14,"n_rows":28,"n_cols":10,"rows_kept":28,"cut":false,"hidden":false,"merged":[[20,1,20,9],[21,1,22,1],[21,2,22,2],[21,3,22,3],[21,4,22,4],[21,5,21,9],[11,1,11,9],[12,1,13,1],[12,2,13,2],[12,3,13,3],[12,4,13,4],[12,5,12,9],[0,0,0,10],[2,1,2,9],[3,1,4,1],[3,2,4,2],[3,3,4,3],[3,4,4,4],[3,5,3,9]]}
["Exposure to Maltese Banks"]
[]
[null,"Please list the top 5 banks to which the clients' assets and money held under nominee, including discretionary portfolio management are exposed. Please rank the banks in descending order (from largest to smallest) of total exposure."]
[null,null,"Ranking ","Name of Maltese Bank","LEI code of Bank","Exposure in Euro"]
[null,null,null,null,null,"Through Equity","Through Bond","Through Deposit","Other Exposure","Total"]
[null,"Bank 1",1,null,null,null,null,null,null,{"$f":"SUM(F6:I6)","v":0}]
[null,"Bank 2",2,null,null,null,null,null,null,{"$f":"SUM(F7:I7)","v":0}]
[null,"Bank 3",3,null,null,null,null,null,null,0]
[null,"Bank 4",4,null,null,null,null,null,null,0]
[null,"Bank 5",5,null,null,null,null,null,null,0]
[]
[null,"Please list the top 5 banks which make up the counterparties of clients' non-nominee transactions. Please rank the banks in descending order (from largest to smallest) of total transactions."]
[null,null,"Ranking ","Name of Maltese Bank","LEI code of Bank","Transactions in Euro"]
[null,null,null,null,null,"Through Equity","Through Bond","Through Deposit","Other Transactions","Total"]
[null,"Bank 1",1,null,null,null,null,null,null,{"$f":"SUM(F15:I15)","v":0}]
[null,"Bank 2",2,null,null,null,null,null,null,{"$f":"SUM(F16:I16)","v":0}]
[null,"Bank 3",3,null,null,null,null,null,null,0]
[null,"Bank 4",4,null,null,null,null,null,null,0]
[null,"Bank 5",5,null,null,null,null,null,null,0]
[]
[null,"Please list the top 5 banks to which the licence holder's assets and money are exposed. Please rank the banks in descending order (from largest to smallest) of total exposure."]
[null,null,"Ranking ","Name of Maltese Bank","LEI code of Bank","Exposure in Euro"]
[null,null,null,null,null,"Through Equity","Through Bond","Through Deposit","Other Exposure","Total"]
[null,"Bank 1",1,null,null,null,null,null,null,{"$f":"SUM(F24:I24)","v":0}]
[null,"Bank 2",2,null,null,null,null,null,null,{"$f":"SUM(F25:I25)","v":0}]
[null,"Bank 3",3,null,null,null,null,null,null,0]
[null,"Bank 4",4,null,null,null,null,null,null,0]
[null,"Bank 5",5,null,null,null,null,null,null,0]

{"sheet":"Confirmations","index":15,"n_rows":75,"n_cols":13,"rows_kept":75,"cut":false,"hidden":false,"merged":[[38,2,38,5],[45,2,45,5],[43,2,43,5],[0,0,0,13],[5,2,5,10],[7,2,7,10],[19,2,19,9],[25,2,27,12],[40,2,40,5]]}
["Confirmations"]
[null,null,null,null,null,null,null,null,null,null,null,null,0]
[]
[]
[]
[null,1,"Did the Licence Holder, carry out all due diligence checks on the suitability assessment of the subject persons as per Rule R1-2.4.2?  "]
[]
[null,2,"In relation to Point 1 above, can the Licence Holder confirm that there is no adverse information to declare as per Rule R1-2.4.3? "]
[]
[null,3,"Are there any individuals within the Licence Holder who earn at least EUR 1 million annually as per Rule R1-2.3.3? "]
[]
[null,4,"Does the Licence Holder have an Internal capital adequacy assessment process and internal risk-management process in place as per Rule R3-3.1.1.4?"]
[]
[null,5,"Does the Licence Holder fall under Prudential consolidation as per Article 7 of the Investment Firms Regulation as per Rule R3-2.2.3?"]
[]
[null,6,"Does the Licence Holder have a Risk Management function in place as per Rule R1-1.5.4.6?"]
[]
[null,7,"Does the Licence Holder have an Internal Audit function in place as per Rule R1-1.5.5.3?"]
[]
[null,8,"Does the Company have a propriety trading platform? If in the affirmative please confirm that an independent IT Auditor has certified the adequacy of the systems in place as per Rule R1-1.12.1."]
[]
[]
[]
[null,null,"Please insert additional information in the box below as necessary"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"By signing the below, the signatories declare that the information within this Return provided is correct and assume any liability connected to this document."]
[]
[]
[null,"Signed on behalf of licence holder by :"]
[]
[null,"Name:"]
[]
[null,"Signed:",null,null,null,null,null,"Date:"]
[null,null,"(Director/ Authorised Signatory)"]
[]
[null,"Name:"]
[]
[null,"Signed:",null,null,null,null,null,"Date:"]
[null,null,"(Non-Executive Director or Compliance Officer or Internal Auditor)"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,"Yes & independently certified"]
[null,null,"Yes & not independently certified"]
[null,null,"No"]
[null,null,"N/A"]
[]
[null,null,"Yes"]
[null,null,"No",null,null,null,"Add confirmation and signature similar to Rep Sheet",null,null,null,"Yes, independent function"]
[null,null,"N/A",null,null,null,null,null,null,null,"Yes, non-independent function"]
[null,null,null,null,"YES",null,"No adverse information",null,null,null,"No"]
[null,null,null,null,"NO",null,"There are adverse material findings"]
[null,null,null,null,"N/A"]