The Excel templates on this page will be used for the purpose of data submissions by the firms that are subject to the 2017 Concurrent Stress Testing exercise; they have also been provided directly to participating firms.
Two types of data are collected: (1) actuals data which show the position of the firm at the start of the stress; and (2) projections data that show how the firm expects their position to evolve over the stress.
The Reconciliations template is used to reconcile firms’ data across Stress Testing templates and with some of their non-Stress Testing data submissions and other external data sources.
Data templates and reconciliations template for the 2017 Concurrent Stress Testing exercise:
Download ZIP file
Please save the zip file to a local drive and then “Extract all” to be able to read its entire contents.
The Stress Test Data Framework Dictionary describes and defines the Excel data templates used for data submissions by firms that are subject to the 2017 Concurrent Stress Testing exercise. It also contains the data quality rules that firms’ submissions are expected to meet. The Dictionary below reflects the data requirements as of 31 March 2017. Participating firms have received this dictionary through a separate process, including any clarifications to support their data submissions.
The Stress Test Data Framework Dictionary:
Download ZIP file
Please save the zip file to a local drive and then “Extract all” to be able to read its entire contents.