EBA欧洲银行-CSV-guide_5页_724kb

报告摘要

EBA Stress Test Dataset Summary

Core Content

The EBA Stress Test dataset is a comprehensive collection of bank-by-bank data from the 2016 EU-wide Stress Test Exercise. It includes 16,800 data points per bank for a sample of 51 banks, structured across 10 Transparency templates. The dataset is designed to provide detailed insights into various risk factors and financial metrics that banks are exposed to under different scenarios.

Main Tools for Data Exploitation

The EBA has developed several tools to facilitate the use of the stress test data:

Interactive maps: Visual tools to explore the data geographically.
Excel aggregation tools: Standard analytical tools for data manipulation.
CSV files: Complete datasets in CSV format, compatible with analytical software.

The dataset is divided into three CSV files, each representing a specific category of data:

CSV Name	Stress Test Category	Transparency Templates Included
TRA_CR.csv	Credit Risk	TRA_CR_STA, TRA_CR_IRB, TRA_CR_SEC, TRA_NPE, TRA_FORB
TRA_SOV.csv	Sovereign Risk	TRA_MR_SOV
TRA_OTH.csv	Summary Results, Capital, Risk Exposure, P&L	TRA_SUM, TRA_CAP, TRA_P&L, TRA_REA

Each CSV file contains a structured database with specific columns and metadata to support analysis.

Key Information

Data Dictionary and Metadata

To understand the database structure and the meaning of each column, users can refer to:

Data Dictionary: Provides a mapping of item codes to their corresponding financial concepts (e.g., "CET1 Ratio - fully loaded").
Metadata: Explains the possible values each column can take, including scenario codes and their meanings.

Example: CET1 Ratio - Fully Loaded

An example is provided to demonstrate how to use the dataset:

Download TRA_OTH.csv which includes the "CET1 Ratio - fully loaded" data.
Import into Excel using the text import wizard.
Use Pivot Tables to analyze the data:
- Row Labels: Bank Name
- Columns: Period and Scenario
- Values: Amount, aggregated by sum.

Scenario Codes and Labels

Code	Label
0	No breakdown by scenario
1	Actual figures
2	Baseline scenario
3	Adverse scenario

Item Code for CET1 Ratio - Fully Loaded

The item code associated with the financial concept "CET1 Ratio - fully loaded" is 1690850, as found in the Data Dictionary file.

Conclusion

The EBA Stress Test dataset is a valuable resource for financial analysts and regulators, offering detailed, structured data across multiple risk categories. The inclusion of metadata and data dictionaries ensures clarity in data interpretation, while the CSV format and Excel tools make the dataset accessible and easy to analyze. The example provided illustrates the practical application of the dataset, particularly in analyzing capital ratios under different scenarios.

展开完整摘要