CRIF File Formats
Download sample file: crif.csv
This document describes the CRIF file format as used in the FRTB Accelerator. It is based on the ISDA Risk Data Standards document.
In the FRTB accelerator, the CRIF file format can be used as an alternative way to load SA sensitivities, for both SBM and DRC. However, some functionality in the accelerator is not available when using the CRIF file format. This includes:
- Base currency and jurisdictional support in FX
- Control over which Delta sensitivities are used when Delta stripping in the Curvature calculations.
Note: The CRIF files are only for loading the sensitivities and descriptions of the risk-factors. Other files, for example configuration and booking, still need to be loaded.
Full details on each risk factor are explained in the relevant section of the FRTB Interpretation and Implementation guide:
Column | Type | KeyOptional | RiskDataStandards | Description |
---|---|---|---|---|
ValuationDate | Date “YYYY-MM-DD” | K | Y | The as-of date of the sensitivities. |
TradeID | String | K | Y | The identifier of the trade (or position) the sensitivities belong to. |
Risk Factor | String | K+O | The [MAR10.9] Risk Factor minus the tenors or maturities. In the FRTB accelerator, the tenors are specified independently of the risk factor and a single risk factor can have multiple tenors. This field is optional, if it is not provided it will be generated from the other fields. This generation depends on the risk-type, and is mainly based on the qualifier field. See risk-class specific documentation for details on how the risk factor is generated. |
|
RiskType | String | K | Y | The combination of risk class and risk measure. See Risk Type table below |
Qualifier | String | Y | Mostly maps to the “underlying” field in the accelerator:
|
|
Bucket | Integer | O | Y | The [MAR10.11] bucket, category, or asset class:
|
Label1 | String | O | Y | This field has multiple uses depending on the risk type:
|
Label2 | String | O | Y | This field has multiple uses depending on the risk type:
|
Amount | Y | The amount of the sensitivity, in the units of the currency specified in the “AmountCurrency” field.
|
||
AmountCurrency | ISO Ccy code | Y | The currency used in the “Amount field”, and other monetary values on the row. | |
Label3 | O | This field has multiple uses depending on the risk type:
|
||
EndDate | Date “YYYY-MM-DD” | O | Y | For DRC, this is the final maturity date of the trade. |
CreditQuality | String | O | The Issuer’s or Obligor’s Credit Rating
|
Note: For Curvature, the accelerator data model requires the shifted up and down PV values to be provided in pairs. In the CRIF files, we require them to be on adjacent rows.
RiskType combinations
This table presents the combinations of risk class and risk measure valid for the RiskType field.
RiskType | Risk Class | Risk Measure |
---|---|---|
GIRR_DELTA | GIRR | Delta |
GIRR_VEGA | GIRR | Vega |
GIRR_CURVATURE | GIRR | Curvature |
CSR_NS_DELTA | CSR non-Sec | Delta |
CSR_NS_VEGA | CSR non-Sec | Vega |
CSR_NS_CURVATURE | CSR non-Sec | Curvature |
CSR_SNC_DELTA | CSR Sec non-CTP | Delta |
CSR_SNC_VEGA | CSR Sec non-CTP | Vega |
CSR_SNC_CURVATURE | CSR Sec non-CTP | Curvature |
EQ_DELTA | Equity | Delta |
EQ_VEGA | Equity | Vega |
EQ_CURVATURE | Equity | Curvature |
COMM_DELTA | Commodity | Delta |
COMM_VEGA | Commodity | Vega |
COMM_CURVATURE | Commodity | Curvature |
FX_DELTA | FX | Delta |
FX_VEGA | FX | Vega |
FX_CURVATURE | FX | Curvature |
DRC_NS_M2M | DRC non-Sec | DRC |
DRC_SNC_M2M | DRC Sec non-CTP | DRC |