Summary

The ewrEs function retrieves the expected shortfall for a list of instruments when the calculation level is “portfolio” or the asset contributions to the expected shortfall when the calculation level is “contributions”. “Positions” level is also possible. Though, the measure will always be expressed in a relative term when using weights in the parameters instead of quantities.

Examples

=ewrEs("portfolio", C11, D11, "EUR", 10, 0.95, "historicalInnovations", TRUE)

Retrieves the expected shortfall of a portfolio containing one unique asset whose ID is in cell C11 and weight in cell D11. The weight must be equal to 100%. The currency is EUR. The RiskHorizon is 10 days, the CondifenceLevel is 95%, the ScenarioType is historical innovation and Annualized is set at TRUE. These are the default parameters.

=ewrEs("portfolio", C11:C50, D11:D50, "EUR", 10, 0.95, "historicalInnovations", TRUE)

Retrieves the expected shortfall of a portfolio where C11:C50 are the asset IDs within the portfolio and D11:D50 are the weights of each asset that sum up to 100%. The currency is EUR. The rest are the default parameters.

=ewrEs("portfolio", {"CHF", "EUR"}, {0.5, 0.5}, "EUR", 10, 0.95, "historicalInnovations", TRUE)

This example can be copied and pasted to Excel and will give an instantaneous result.

=ewrEs("contributions", C11:C50, D11:D50, "EUR", 10, 0.95, "historicalInnovations", TRUE)

Retrieves the contributions to the expected shortfall of each asset of the portfolio. C11:C50 stands for the asset IDs contained in the portfolio and D11:D50 for the weights. The weight must sum up to 100%. The currency is EUR and the rest are the default parameters.

Syntax

ewrEs(CalculationsLevel, AssetIDs[], Weights[], Currency, 
	RiskHorizon, ConfidenceLevel, ScenarioType, 
	Annualized)
Argument name Default Description
CalculationsLevel   The granularity at which the results should be calculated (individual asset, portfolio).
AssetIDs   Single or multiple asset identifiers (ISIN, FIGI, currency ISO, Edgelab ID).
Weights   Asset weights in the same orders as the specified asset ids and must sum up to 100%.
Currency (Optional) 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”.
RiskHorizon (Optional) 10d The time interval over which the risks are estimated (i.e. between now and now + risk-horizon).
ConfidenceLevel (Optional) 95 The confidence level for the tail statistics estimators VaR and ES. It is number in percent between 85 and 99 [%].
ScenarioType (Optional) historicalInnovation How the possible scenarios for the asset prices are computed.
Annualized (Optional) true Whether the result should be expressed as an annualized figure. True or False.