ewrBenchmarkMeasure
Summary
The ewrBenchmarkMeasure function allows retrieving benchmark measures. As of now, only tracking-error is available. The benchmark can be composed of one position (e.g. an Index) or multiple ones (e.g. a portfolio benchmark). You can specify the amounts in weights or quantities. Bear in mind that if the amount scheme "weight" is selected, the sum of the weights must be equal to 1.
Examples
=ewrBenchmarkMeasure("tracking-error", C11:C20, B11:B20, D9, "weight", 1, "CHF", 10, "historicalInnovations")
This function retrieves the tracking error of a portfolio whose assets are in C11:C20 and weights in B11:B20. The benchmark is one position in D9 and could be an Index for example. The amount scheme for the benchmark is "weight" but it could have been "quantity". The amount is 1 as the benchmark is one position. Then you have the portfolio currency ("CHF" in this example), the time horizon (10 days), and finally the scenario type "historicalInnovation".
=ewrBenchmarkMeasure("tracking-error", C11:C20, B11:B20, D9:D18, "weight", E9:E18, "CHF", 10, "historicalInnovations")
This function retrieves the tracking error of a portfolio whose assets are in C11:C20 and weights in B11:B20. The benchmark is a portfolio whose instruments are in D9:D18. The amount scheme for the benchmark is "weight". In E9:E18, the weights must sum up to 1. Then, you have the portfolio currency ("CHF" in this example), the time horizon (10 days), and finally the scenario type "historicalInnovation".
=ewrBenchmarkMeasure("tracking-error", C11:C20, B11:B20, D9:D18, "quantity", F9:F18, "CHF", 10, "historicalInnovations")
This function retrieves the tracking error of a portfolio whose assets are in C11:C20 and weights in B11:B20. The benchmark is a portfolio whose instruments are in D9:D18. The amount scheme for the benchmark is "quantity". F9:F18 represents the quantities. Then, you have the portfolio currency ("CHF" in this example), the time horizon (10 days), and finally the scenario type "historicalInnovation".
Syntax
ewrBenchmarkMeasure(Measure, AssetIDs[], Weights[], BenchmarkAssetids[], BenchmarkAmountScheme, BenchmarkAmounts, Currency, RiskHorizon, ConfidenceLevel, Annualized, ScalingHorizon, LiquidityAdjusted)
| Argument name | Default | Description |
|---|---|---|
| Measure | The name of the measure to be returned. | |
| 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%. | |
| BenchmarkAssetids | Single or multiple asset identifiers (ISIN, FIGI, currency ISO, Edgelab ID). | |
| BenchmarkAmountScheme (Optional) | weight | weight or quantity |
| BenchmarkAmounts | Weight scheme: Asset weights in the same orders as the specified asset ids and must sum up to 100%. Quantity scheme: Asset quantities in the same orders as the specified asset ids. | |
| Currency | 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) | 10 | The time interval over which the risks are estimated (i.e. between now and now + risk-horizon). |
| ScenarioType (Optional) | historicalInnovations | How the possible scenarios for the asset prices are computed. |
| ConfidenceLevel (Optional) | 0.95 | The confidence level for the tail statistics estimators VaR and ES. It is number in percent between 85 and 99 [%]. |
| Annualized (Optional) | FALSE | Whether the result should be expressed as an annualized figure. True or False. |
| ScalingHorizon (Optional) | RiskHorizon | If used, the value should be >=1. The value is used as a factorization that will be multiplied by the time horizon such that the risk horizon can be something different than the default choices. For instance, when using this parameter, risk measures with risk horizon of 20 or 60 days can be queried. |
| LiquidityAdjusted (Optional) | false | If true, then risk computations will account for the liquidity risk. |