Market Risk Accelerator Reference Guide v1.9.1Market data
Download sample file: MarketData.csv
The file is used to provide market prices for the greek-based PL calculations.
For information on how the labels and dates fields are used for the pillars (tenors and maturities), please see Labels and dates for pillars.
File pattern match
The pattern match for the Market Data file is **MarketData*.csv
For information on the glob patterns used and how to customize them, see note on File name patterns.
| Field | Key | Null | FieldType | Description | Example |
|---|---|---|---|---|---|
| AsOfDate | Y | N | String with format ‘YYYY-MM-DD’ | Indicates value date | 2019-01-01 |
| MarketDataSet | Y | N | String | String defining the market data set, for example “Trader marks” or “Official EOD” | Official EOD |
| RiskFactorId | Y | N | String | Identifier of the risk factor. Must match risk factor identifier in the sensitivities files | USD.OIS |
| Quote | Double or list of doubles (delimited by semicolons) | Market data quote(s) to be used by the greek-based calculation (configured in greek-based-pl-formula-rules.properties file). For example, stock price, swap rates or implied rates, implied volatility levels. Can be a single value or list of values: Single value for a sensitivity without tenor/moneyness/underlying swap structure. List of values, corresponding to different tenors, swap maturities, moneyness for a sensitivity with corresponding axes. For example, a sensitivity to four tenors and two underlying swap instruments will be published as a list of eight values, the first four corresponding to different tenors and the first underlying maturity and the second four corresponding to tenors and the second underlying maturity. Must correspond to sensitivities to the same risk factor. |
1568.2 ;4568.2 ;16.2 ;2453.1 | ||
| TenorLabels | N | Y | Array (delimited by semicolons) | List of tenor labels, such as 3M, 5Y, and so on, if applicable. | 1Y;3Y;5Y;10Y |
| MaturityLabels | N | Y | Array (delimited by semicolons) | List of underlying maturities for volatility cubes, if applicable. | 0.5Y;1Y;3Y;5Y;10Y |
| MoneynessLabels | N | N | Array (delimited by semicolons) | List of moneyness labels, if applicable | 45p;ATM;45c |
| TenorDates | N | N | Array (delimited by semicolons) | List of explicit tenor dates, which are used to sort tenors and to re-bucket sensitivities (if supported) | 2019-03-16; 2019-04-27; 2019-10-27; 2020-10-27 |
| MaturityDates | N | N | Array (delimited by semicolons) | List of explicit maturity dates, which are used to sort tenors and to re-bucket sensitivities (if supported) | 2019-03-16; 2019-04-27; 2019-10-27; 2020-10-27 |