elStressDriver
Summary
After having defined a shock amplitude, the elStressDriver function retrieves on demand the profit and loss of a portfolio. This function supports only positions and portfolio as calculation levels.
Examples
=elStressDriver("pnl","portfolio","fx-USD-AUD", "relative",0.1,D11:D50,E11:E50,"CHF","relative")
Calculates the P&L impact an interest curve stress would have on a portfolio of instruments defined in column C (with corresponding quantities in column D) expressed in CHF.
Syntax
elStressDriver(measure, calculationsLevel, driverId, shockType, shockValue, assetsIds[], quantities[], currency, measureType)
| Argument name | Default | Description |
|---|---|---|
| measure | "pnl" (Profit and Loss). | |
| calculationsLevel | The granularity at which the results should be calculated (individual asset, portfolio). | |
| driverId | The ID of a pre-defined scenario to serve as the basis for the simulation. | |
| shockType | relative or absolute (Check the stress scenarios dedicated tables) | |
| shockValue | any number | |
| assetsIds | Single or multiple asset identifiers (ISIN, FIGI, currency ISO, Edgelab ID). | |
| quantities | 1 | Assets quantities |
| currency | local | The ISO code of the reference currency for deriving the calculation results. Specify "local" to use the instruments native currency where appropriate. It is mandatory to specify a currency when the granularity is "portfolio". |
| measureType (Optional) | relative | Whether the result should be normalized. The input should be "relative" or "absolute". "True" or "False" are still supported for the moment. |