Summary

The elBenchmarkMeasure 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

=elBenchmarkMeasure("tracking-error", C11:C20, B11:B20, D9, "weight", 1, "CHF", 10, "historicalInnovation")

This function retrieves the tracking error of a portfolio whose assets are in C11:C20 and quantities 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”.

=elBenchmarkMeasure("tracking-error", C11:C20, B11:B20, D9:D18, "weight", E9:E18, "CHF", 10, "historicalInnovation")

This function retrieves the tracking error of a portfolio whose assets are in C11:C20 and quantities 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”.

=elBenchmarkMeasure("tracking-error", C11:C20, B11:B20, D9:D18, "quantity", F9:F18, "CHF", 10, "historicalInnovation")

This function retrieves the tracking error of a portfolio whose assets are in C11:C20 and quantities 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

elBenchmarkMeasure(Measure, AssetIDs[], Quantities[], BenchmarkAssetids[], BenchmarkAmountScheme, BenchmarkAmounts, Currency, RiskHorizon, ScenarioType)
Argument name Default Description
Measure   tracking-error
AssetIDs   Single or multiple asset identifiers (ISIN, FIGI, currency ISO, Edgelab ID).
Quantities   Asset quantities in the same orders as the specified asset ids.
BenchmarkAssetids   Single or multiple asset identifiers (ISIN, FIGI, currency ISO, Edgelab ID).
BenchmarkAmountScheme (Optional) quantity 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) historicalInnovation How the possible scenarios for the asset prices are computed.