Trades attributes
Download sample file: trade-attributes.csv
Trades attributes is a snapshot of all hedge trades in the CVA portfolio. The Solution expects that eligibility of hedges (see fields IsBaEligible and IsSaEligible) is evaluated by the upstream system.
Field | Key | Null | FieldType | Description | Example |
---|---|---|---|---|---|
AsOfDate | Y | N | String with format ‘YYYY-MM-DD’ | Risk value date | 2018-09-28 |
TradeDate | N | Y | String with format ‘YYYY-MM-DD’ | This field shall contain trade date to be used for analytical purposes | 2018-09-27 |
TradeId | Y | N | String | Primary trade identifier. Must match Trade Attributes file. Note: If coming from multiple systems, Trade Ids may need to prepend source system to the id for uniqueness. | MX-283749 |
LegalEntity | N | Y | String | Balance sheet legal entity code | ActiveBank |
CounterpartyId | N | Y | String | Identifier of the trade counterparty. May contain book for internal counterparties. | US_RATES_LIN |
ProductId | N | Y | String | Internal products taxonomy | CDS |
Book | N | N | String | The book to map the trade to (must match the node in the organisational hierarchy). | CVA_RATES |
ReferenceName | N | Y | String | For BA eligible trades, this field must contain reference name identifier, which matches credit spread reference data. | Deutsche_Bank_USD |
HedgedCVACounterpartyId | N | Y | String | This field is used for BA-CVA eligible trades: to map hedges to counterparties (BA-CVA) and should contain Counterparty key for single name hedges - the counterparty which a trade is intended to hedge, not the counterparty of the trade (see the second term in the K_hedged formula, which loops over counterparties and subtracts SNH from SCVA) It can be empty for BA-CVA eligible trades only if HedgedCVANettingSet has been provided. | DB |
HedgedCVANettingSetId | N | Y | String | This field is optional and allows to map hedge trades via NettingSetId. This is useful when some of the netting sets are carved out from SA-CVA calculation - sensitivities of corresponding hedges will be also be moved out of the official capital calculation. | NS236342 |
IsSaEligible | N | Y | String, ‘Y’ or ‘N’ | The attribute contains ‘Y’ for trades eligible for BA-CVA according to para [MAR50.37], [MAR50.39] and ‘N’ for the rest. | Y |
IsBaEligible | N | N | String, ‘Y’ or ‘N’ | The attribute contains ‘Y’ for trades eligible for BA-CVA according to para [MAR50.17], [MAR50.19] and ‘N’ for the rest. | Y |