ECB logo

Documentation for banking groups which have to report data on securities holdings directly to the ECB

Certain banking groups must provide statistics on their securities holdings in respect of so-called Securities Holdings Statistics Group (SHSG) data directly to the ECB, as provided for in the SHS Regulation. The ECB has prepared a range of material to facilitate this.

Banking groups subject to direct reporting of SHSG data – the group reporting agent will be sent a notification by the relevant national central bank – have to comply with the instructions contained in the documentation below. For other banking groups, the relevant national central bank is responsible for collecting the required data and, as such, will provide its own data reporting instructions. ?

Only SHSG data must be reported to the ECB, i.e. “Securities Holdings Statistics by Sector” data are not covered by the direct reporting. Data are processed via the ESCB Securities Holdings Statistics Database, which is jointly operated by the ECB and the Deutsche Bundesbank on behalf of the Eurosystem.

Please send an email if you have any questions to both of the following addresses:

[email protected]
[email protected]


Guidance notes

This document explains the methodology behind the reporting requirements and provides guidance on the approach that may be followed in cases where the relevant ECB legal act leaves scope for interpretation. It also aims to clarify the requirements and definitions laid down in the SHS Regulation. Note that the Guidance notes are also applicable to banking groups for which the relevant national central bank is responsible for collecting the required data.

Guidance notes to reporting agents on SHS regulation last update: 26 September 2018

Excel views of the reporting templates

The reporting templates specify and describe the attributes of the input fields for the SHSG data collection. All attributes flagged as mandatory have to be filled in the files to be submitted (except where stated otherwise in the respective templates). Some attributes are coded, i.e. only values from the corresponding code list (to be found in the code list repository) can be reported, while other attributes only have to comply with certain formats, e.g. the format for securities with an international securities identification number (ISIN).

SHSG_Stage_4_Reporting_Templates-Direct_reporting.xlsx last update: 18 February 2019

Code list repository

The specific code lists for the SHSG data collection are defined in the code list repository.

SHSG_Stage_4_Codelists_Repository-Direct_reporting.xlsx last update: 18 February 2019

Reporting format documentation

This documentation provides guidance and more detailed information on the requirements for the direct reporting on securities holdings, including any additional requirements which may not be included in the guidance notes on the SHS Regulation. The material complements the reporting templates and the code list repository.

SHSG_Stage_4_Reporting_format_documentation-Direct_reporting.docx last update: 18 February 2019

SDMX 2.1 Data Structure Definitions in XML (including example files)

The Data Structure Definitions (DSDs) specify the characteristics of the expected XML reporting files. They outline, in particular, which fields involve mandatory or optional attributes. They also specify the level at which the specific attributes are to be assigned in the XML reporting files and restrict the expected values to certain codes or patterns.

The XML Schema files (XSDs) are derived from the DSDs. last update: 07 May 2018

CSV reporting files

Examples of CSV reporting files have been created for all four input feeds.

SHSG_Stage_4_Example_ENTITY-Direct_reporting.csv last update: 07 May 2018
SHSG_Stage_4_Example_GROUP-Direct_reporting.csv last update: 07 May 2018
SHSG_Stage_4_Example_ISIN-Direct_reporting.csv last update: 07 May 2018
SHSG_Stage_4_Example_NonISIN-Direct_reporting.csv last update: 07 May 2018

Data validation checks

There are currently four main types of data validation check:

  1. Technical checks are performed at the data reception stage and are necessary to ensure that input files are successfully uploaded into the ESCB Securities Holdings Statistics Database.
  2. Formal checks are required to ensure the successful processing of input files.
  3. Plausibility checks lead to validation warnings which need to be addressed in order to ensure that uploaded data are plausible.
  4. FINREP/COREP checks cover benchmark comparisons at banking group level for data obtained from supervisory reporting and the information on securities holdings issued by reporting banks.
  5. SHSG_Stage_4_Data_validation_rules-(excl.FINREP_and_COREP)-Direct_reporting.xlsx last update: 18 February 2019
    SHSG_Stage_4_Data_validation_rules-FINREP_and_COREP-Direct_reporting.xlsx last update: 18 February 2019

In the event of future updates, changes in the material on direct reporting will be clearly indicated.

北京pk赛车10官网 篮球比分图片 辽宁十一选五 甘肃11选5 河南11选5结果 3d开奖试机号开机 今日涨停股票推荐 竞彩足球比分即时比分直播 宁夏11选5电子走势图 双色球开奖走势图表 谁有好股票推荐 河北十一选五直播开 广西体彩11选5走 浩广配资 福彩30选5开奖结果查 趣操盘 股票分析方法报纸