The ‘Cell Reference’ column of the table below identifies the items to be reported by identifying the columns and lines as showed in the template in Annex I. Information in columns C0100-C0180, as well as in Rows R0270-R0460 shall be reported for each issuer CSD.
Information in columns C0020, C0040, C0060, C0110, C0130 and C0150 for aggregated volumes shall be reported as a whole number expressed using up to 20 numerical characters without decimal places.
Information in columns C0030, C0050, C0070, C0120, C0140 and C0160 for aggregate values shall be reported as a value expressed using up to 20 numerical characters including decimals. The decimal mark is not counted as a numerical character and at least one character before and two characters after the decimal mark shall be populated. A full stop shall be used as the decimal mark.
Information in columns C0080, C0090, C00170 and C00180 for rates shall be reported as a percentage value up to two decimal places.
Where no activity needs to be reported, information in columns C0020-C0090 and C0110-C0180 shall be completed with a zero value.
No. | Cell Reference | Item | Instruction
1 | C0010, R0010 | Country code | Identify the ISO 3166 2 character code of the place of establishment of the settlement internaliser.
2 | C0010, R0020 | Reporting timestamp |
For reporting from the settlement internaliser to the competent authority, identify the ISO 8601 in UTC time format (YYYY-MM-DDThh:mm:ssZ) code of the date when the report from the settlement internaliser to the competent authority is made.
For reporting from the competent authority to ESMA, identify the ISO 8601 in UTC time format (YYYY-MM-DDThh:mm:ssZ) code of the date when the report from the competent authority to ESMA is made.
3 | C0010, R0030 | Reporting period | Identify the ISO 8601 (YYYY-MM-DD) code of the date identifying the last day of the reporting period.
4 | C0010, R0040 | Settlement internaliser identifier | Insert identification code of the settlement internaliser, using a Legal Entity Identifier (LEI).
5 | C0010, R0050 | Name of person responsible |
For reporting from the settlement internaliser to the competent authority, indicate the name of the person responsible for the report at the settlement internaliser.
For reporting from the competent authority to ESMA, the name of the liaison at the competent authority.
6 | C0010, R0060 | Function of person responsible |
For reporting from the settlement internaliser to the competent authority, the function of the person responsible for the report at the settlement internaliser.
For reporting from the competent authority to ESMA, the function of the liaison at the competent authority.
7 | C0010, R0070 | Phone number |
For reporting from the settlement internaliser to the competent authority, the phone number of the person responsible for the report at the settlement internaliser.
For reporting from the competent authority to ESMA, the phone number of the liaison at the competent authority.
8 | C0010, R0080 | Email address |
For reporting from the settlement internaliser to the competent authority, the email address of the person responsible for the report at the settlement internaliser.
For reporting from the competent authority to ESMA, the email address of the liaison at the competent authority.
9 | C0100, R0270 | Issuer CSD identifier |
Insert identification code of the CSD, using an LEI.
If information on the issuer CSD is not available the first two characters of the ISIN codes shall be used.
10 | C0100, R0280 | Issuer CSD Country Code | Identify the ISO 3166 2 character code of the place of establishment of the issuer CSD.
11 |
C0020, R0090
C0110, R0290
Overall total | Aggregated volume of internalised settlement instructions settled by the settlement internaliser during the period covered by the report.
12 |
C0030, R0090
C0120, R0290
Overall total | Aggregated value, expressed in euros, of internalised settlement instructions settled during the period covered by the report.
13 |
C0040, R0090
C0130, R0290
Overall total | Aggregated volume of failed internalised settlement instructions during the period covered by the report
14 |
C0050, R0090
C0140, R0290
Overall total | Aggregated value, expressed in euros, of failed internalised settlement instructions during the period covered by the report
15 |
C0060, R0090
C0150, R0290
Overall total | Aggregated total of the volume of internalised settlement instructions settled by the settlement internaliser and volume of failed internalised settlement instructions during the period covered by the report.
16 |
C0070, R0090
C0160, R0290
Overall total | Aggregated total value, expressed in euros, of internalised settlement instructions settled by the settlement internaliser and of failed internalised settlement instructions during the period covered by the report.
17 |
C0080, R0090
C0170, R0290
Overall total | The rate of failed internalised settlement instructions compared to the aggregated total volume of internalised settlement instructions settled by the settlement internaliser and failed internalised settlement instructions during the period covered by the report.
18 |
C0090, R0090
C0180, R0290
Overall total | The rate of failed internalised settlement instructions compared to the total value, expressed in euros, of internalised settlement instructions settled by the settlement internaliser and failed internalised settlement instructions during the period covered by the report.
19 |
C0020, R0100
C0110, R0300
Transferable securities referred to in point (a) of Article 4(1)(44) of Directive 2014/65/EU | Aggregated volume of internalised settlement instructions settled in transferable securities referred to in point (a) of Article 4(1)(44) of Directive 2014/65/EU by the settlement internaliser during the period covered by the report.
20 |
C0030, R0100
C0120, R0300
Transferable securities referred to in point (a) of Article 4(1)(44) of Directive 2014/65/EU | Aggregated value, expressed in euros, of internalised settlement instructions settled in transferable securities referred to in point (a) of Article 4(1)(44) of Directive 2014/65/EU during the period covered by the report.
21 |
C0040, R0100
C0130, R0300
Transferable securities referred to in point (a) of Article 4(1)(44) of Directive 2014/65/EU | Aggregated volume of failed internalised settlement instructions in transferable securities referred to in point (a) of Article 4(1)(44) of Directive 2014/65/EU during the period covered by the report
22 |
C0050, R0100
C0140, R0300
Transferable securities referred to in point (a) of Article 4(1)(44) of Directive 2014/65/EU | Aggregated value, expressed in euros, of failed internalised settlement instructions in transferable securities referred to in point (a) of Article 4(1)(44) of Directive 2014/65/EU during the period covered by the report
23 |
C0060, R0100
C0150, R0300
Transferable securities referred to in point (a) of Article 4(1)(44) of Directive 2014/65/EU | Aggregated total of the volume of internalised settlement instructions settled by the settlement internaliser and volume of failed internalised settlement instructions in transferable securities referred to in point (a) of Article 4(1)(44) of Directive 2014/65/EU during the period covered by the report.
24 |
C0070, R0100
C0160, R0300
Transferable securities referred to in point (a) of Article 4(1)(44) of Directive 2014/65/EU | Aggregated total value, expressed in euros, of internalised settlement instructions settled by the settlement internaliser and failed internalised settlement instructions in transferable securities referred to in point (a) of Article 4(1)(44) of Directive 2014/65/EU during the period covered by the report.
25 |
C0080, R0100
C0170, R0300
Transferable securities referred to in point (a) of Article 4(1)(44) of Directive 2014/65/EU | The rate of failed internalised settlement instructions compared to the aggregated total volume of internalised settlement instructions settled by the settlement internaliser and failed internalised settlement instructions in transferable securities referred to in point (a) of Article 4(1)(44) of Directive 2014/65/EU during the period covered by the report.
26 |
C0090, R0100
C0180, R0300
Transferable securities referred to in point (a) of Article 4(1)(44) of Directive 2014/65/EU | The rate of failed internalised settlement instructions compared to the total value, expressed in euros, of internalised settlement instructions settled by the settlement internaliser and failed internalised settlement instructions in transferable securities referred to in point (a) of Article 4(1)(44) of Directive 2014/65/EU during the period covered by the report.
27 |
C0020, R0110
C0110, R0310
Sovereign debt referred to in Article 4(1)(61) of Directive 2014/65/EU | Aggregated volume of internalised settlement instructions settled in sovereign debt referred to in Article 4(1)(61) of Directive 2014/65/EU by the settlement internaliser during the period covered by the report.
28 |
C0030, R0110
C0120, R0310
Sovereign debt referred to in Article 4(1)(61) of Directive 2014/65/EU | Aggregated value, expressed in euros, of internalised settlement instructions settled in sovereign debt referred to in Article 4(1)(61) of Directive 2014/65/EU during the period covered by the report.
29 |
C0040, R0110
C0130, R0310
Sovereign debt referred to in Article 4(1)(61) of Directive 2014/65/EU | Aggregated volume of failed internalised settlement instructions in sovereign debt referred to in Article 4(1)(61) of Directive 2014/65/EU during the period covered by the report
30 |
C0050, R0110
C0140, R0310
Sovereign debt referred to in Article 4(1)(61) of Directive 2014/65/EU | Aggregated value, expressed in euros, of failed internalised settlement instructions in sovereign debt referred to in Article 4(1)(61) of Directive 2014/65/EU during the period covered by the report
31 |
C0060, R0110
C0150, R0310
Sovereign debt referred to in Article 4(1)(61) of Directive 2014/65/EU | Aggregated total of the volume of internalised settlement instructions settled by the settlement internaliser and volume of failed internalised settlement instructions in sovereign debt referred to in Article 4(1)(61) of Directive 2014/65/EU during the period covered by the report.
32 |
C0070, R0110
C0160, R0310
Sovereign debt referred to in Article 4(1)(61) of Directive 2014/65/EU | Aggregated total value, expressed in euros, of internalised settlement instructions settled by the settlement internaliser and of failed internalised settlement instructions in sovereign debt referred to in Article 4(1)(61) of Directive 2014/65/EU during the period covered by the report.
33 |
C0080, R0110
C0170, R0310
Sovereign debt referred to in Article 4(1)(61) of Directive 2014/65/EU | The rate of failed internalised settlement instructions compared to the aggregated total volume of internalised settlement instructions settled by the settlement internaliser and failed internalised settlement instructions in sovereign debt referred to in Article 4(1)(61) of Directive 2014/65/EU during the period covered by the report.
34 |
C0090, R0110
C0180, R0310
Sovereign debt referred to in Article 4(1)(61) of Directive 2014/65/EU | The rate of failed internalised settlement instructions compared to the total value, expressed in euros, of internalised settlement instructions settled by the settlement internaliser and failed internalised settlement instructions in sovereign debt referred to in Article 4(1)(61) of Directive 2014/65/EU during the period covered by the report.
35 |
C0020, R0120
C0110, R0320
Transferable securities referred to in point (b) of Article 4(1)(44) of Directive 2014/65/EU other than sovereign debt referred to in Article 4(1)(61) of Directive 2014/65/EU | Aggregated volume of internalised settlement instructions settled in transferable securities referred to in point (b) of Article 4(1)(44) of Directive 2014/65/EU other than sovereign debt referred to in Article 4(1)(61) of Directive 2014/65/EU by the settlement internaliser during the period covered by the report.
36 |
C0030, R0120
C0120, R0320
Transferable securities referred to in point (b) of Article 4(1)(44) of Directive 2014/65/EU other than sovereign debt referred to in Article 4(1)(61) of Directive 2014/65/EU | Aggregated value, expressed in euros, of internalised settlement instructions settled in transferable securities referred to in point (b) of Article 4(1)(44) of Directive 2014/65/EU other than sovereign debt referred to in Article 4(1)(61) of Directive 2014/65/EU during the period covered by the report.
37 |
C0040, R0120
C0130, R0320
Transferable securities referred to in point (b) of Article 4(1)(44) of Directive 2014/65/EU other than sovereign debt referred to in Article 4(1)(61) of Directive 2014/65/EU | Aggregated volume of failed internalised settlement instructions in transferable securities referred to in point (b) of Article 4(1)(44) of Directive 2014/65/EU other than sovereign debt referred to in Article 4(1)(61) of Directive 2014/65/EU during the period covered by the report
38 |
C0050, R0120
C0140, R0320
Transferable securities referred to in point (b) of Article 4(1)(44) of Directive 2014/65/EU other than sovereign debt referred to in Article 4(1)(61) of Directive 2014/65/EU | Aggregated value, expressed in euros, of failed internalised settlement instructions in transferable securities referred to in point (b) of Article 4(1)(44) of Directive 2014/65/EU other than sovereign debt referred to in Article 4(1)(61) of Directive 2014/65/EU during the period covered by the report
39 |
C0060, R0120
C0150, R0320
Transferable securities referred to in point (b) of Article 4(1)(44) of Directive 2014/65/EU other than sovereign debt referred to in Article 4(1)(61) of Directive 2014/65/EU | Aggregated total of the volume of internalised settlement instructions settled by the settlement internaliser and volume of failed internalised settlement instructions in transferable securities referred to in point (b) of Article 4(1)(44) of Directive 2014/65/EU other than sovereign debt referred to in Article 4(1)(61) of Directive 2014/65/EU during the period covered by the report.
40 |
C0070, R0120
C0160, R0320
Transferable securities referred to in point (b) of Article 4(1)(44) of Directive 2014/65/EU other than sovereign debt referred to in Article 4(1)(61) of Directive 2014/65/EU | Aggregated total value, expressed in euros, of internalised settlement instructions settled by the settlement internaliser and of failed internalised settlement instructions in transferable securities referred to in point (b) of Article 4(1)(44) of Directive 2014/65/EU other than sovereign debt referred to in Article 4(1)(61) of Directive 2014/65/EU during the period covered by the report.
41 |
C0080, R0120
C0170, R0320
Transferable securities referred to in point (b) of Article 4(1)(44) of Directive 2014/65/EU other than sovereign debt referred to in Article 4(1)(61) of Directive 2014/65/EU | The rate of failed internalised settlement instructions compared to the aggregated total volume of internalised settlement instructions settled by the settlement internaliser and failed internalised settlement instructions in transferable securities referred to in point (b) of Article 4(1)(44) of Directive 2014/65/EU other than sovereign debt referred to in Article 4(1)(61) of Directive 2014/65/EU during the period covered by the report.
42 |
C0090, R0120
C0180, R0320
Transferable securities referred to in point (b) of Article 4(1)(44) of Directive 2014/65/EU other than sovereign debt referred to in Article 4(1)(61) of Directive 2014/65/EU | The rate of failed internalised settlement instructions compared to the total value, expressed in euros, of internalised settlement instructions settled by the settlement internaliser and failed internalised settlement instructions in transferable securities referred to in point (b) of Article 4(1)(44) of Directive 2014/65/EU other than sovereign debt referred to in Article 4(1)(61) of Directive 2014/65/EU during the period covered by the report.
43 |
C0020, R0130
C0110, R0330
Transferable securities referred to in point (c) of Article 4(1)(44) of Directive 2014/65/EU | Aggregated volume of internalised settlement instructions settled in transferable securities referred to in point (c) of Article 4(1)(44) of Directive 2014/65/EU by the settlement internaliser during the period covered by the report.
44 |
C0030, R0130
C0120, R0330
Transferable securities referred to in point (c) of Article 4(1)(44) of Directive 2014/65/EU | Aggregated value, expressed in euros, of internalised settlement instructions settled in transferable securities referred to in point (c) of Article 4(1)(44) of Directive 2014/65/EU during the period covered by the report.
45 |
C0040, R0130
C0130, R0330
Transferable securities referred to in point (c) of Article 4(1)(44) of Directive 2014/65/EU | Aggregated volume of failed internalised settlement instructions in transferable securities referred to in point (c) of Article 4(1)(44) of Directive 2014/65/EU during the period covered by the report
46 |
C0050, R0130
C0140, R0330
Transferable securities referred to in point (c) of Article 4(1)(44) of Directive 2014/65/EU | Aggregated value, expressed in euros, of failed internalised settlement instructions in transferable securities referred to in point (c) of Article 4(1)(44) of Directive 2014/65/EU during the period covered by the report
47 |
C0060, R0130
C0150, R0330
Transferable securities referred to in point (c) of Article 4(1)(44) of Directive 2014/65/EU | Aggregated total of the volume of internalised settlement instructions settled by the settlement internaliser and volume of failed internalised settlement instructions in transferable securities referred to in point (c) of Article 4(1)(44) of Directive 2014/65/EU during the period covered by the report.
48 |
C0070, R0130
C0160, R0330
Transferable securities referred to in point (c) of Article 4(1)(44) of Directive 2014/65/EU | Aggregated total value, expressed in euros, of internalised settlement instructions settled by the settlement internaliser and failed internalised settlement instructions in transferable securities referred to in point (c) of Article 4(1)(44) of Directive 2014/65/EU during the period covered by the report.
49 |
C0080, R0130
C0170, R0330
Transferable securities referred to in point (c) of Article 4(1)(44) of Directive 2014/65/EU | The rate of failed internalised settlement instructions compared to the aggregated total volume of internalised settlement instructions settled by the settlement internaliser and failed internalised settlement instructions in transferable securities referred to in point (c) of Article 4(1)(44) of Directive 2014/65/EU during the period covered by the report.
50 |
C0090, R0130
C0180, R0330
Transferable securities referred to in point (c) of Article 4(1)(44) of Directive 2014/65/EU | The rate of failed internalised settlement instructions compared to the total value, expressed in euros, of internalised settlement instructions settled by the settlement internaliser and failed internalised settlement instructions in transferable securities referred to in point (c) of Article 4(1)(44) of Directive 2014/65/EU during the period covered by the report.
51 |
C0020, R0140
C0110, R0340
Exchange-traded funds as defined in point (46) of Article 4(1) of Directive 2014/65/EU | Aggregated volume of internalised settlement instructions settled in exchange-traded funds as defined in point (46) of Article 4(1) of Directive 2014/65/EU by the settlement internaliser during the period covered by the report.
52 |
C0030, R0140
C0120, R0340
Exchange-traded funds as defined in point (46) of Article 4(1) of Directive 2014/65/EU | Aggregated value, expressed in euros, of internalised settlement instructions settled in exchange-traded funds as defined in point (46) of Article 4(1) of Directive 2014/65/EU during the period covered by the report.
53 |
C0040, R0140
C0130, R0340
Exchange-traded funds as defined in point (46) of Article 4(1) of Directive 2014/65/EU | Aggregated volume of failed internalised settlement instructions in exchange-traded funds as defined in point (46) of Article 4(1) of Directive 2014/65/EU during the period covered by the report
54 |
C0050, R0140
C0140, R0340
Exchange-traded funds as defined in point (46) of Article 4(1) of Directive 2014/65/EU | Aggregated value, expressed in euros, of failed internalised settlement instructions in exchange-traded funds as defined in point (46) of Article 4(1) of Directive 2014/65/EU during the period covered by the report
55 |
C0060, R0140
C0150, R0340
Exchange-traded funds as defined in point (46) of Article 4(1) of Directive 2014/65/EU | Aggregated total of the volume of internalised settlement instructions settled by the settlement internaliser and volume of failed internalised settlement instructions in exchange-traded funds as defined in point (46) of Article 4(1) of Directive 2014/65/EU during the period covered by the report.
56 |
C0070, R0140
C0160, R0340
Exchange-traded funds as defined in point (46) of Article 4(1) of Directive 2014/65/EU | Aggregated total value, expressed in euros, of internalised settlement instructions settled by the settlement internaliser and failed internalised settlement instructions in exchange-traded funds as defined in point (46) of Article 4(1) of Directive 2014/65/EU during the period covered by the report.
57 |
C0080, R0140
C0170, R0340
Exchange-traded funds as defined in point (46) of Article 4(1) of Directive 2014/65/EU | The rate of failed internalised settlement instructions compared to the aggregated total volume of internalised settlement instructions settled by the settlement internaliser and failed internalised settlement instructions in exchange-traded funds as defined in point (46) of Article 4(1) of Directive 2014/65/EU during the period covered by the report.
58 |
C0090, R0140
C0180, R0340
Exchange-traded funds as defined in point (46) of Article 4(1) of Directive 2014/65/EU | The rate of failed internalised settlement instructions compared to the total value, expressed in euros, of internalised settlement instructions settled by the settlement internaliser and failed internalised settlement instructions in exchange-traded funds as defined in point (46) of Article 4(1) of Directive 2014/65/EU during the period covered by the report.
59 |
C0020, R0150
C0110, R0350
Units in collective investment undertakings, other than ETFs | Aggregated volume of internalised settlement instructions settled for units in collective investment undertakings, other than ETFs by the settlement internaliser during the period covered by the report.
60 |
C0030, R0150
C0120, R0350