elBeta
Summary
The elBeta function allows retrieving benchmark measures. 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
=elBeta(C11:C20, B11:B20, D9, "weight", 1, "CHF", 10, "historicalInnovations")
This function retrieves the beta 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".
=elBeta(C11:C20, B11:B20, D9:D18, "weight", E9:E18, "CHF", 10, "historicalInnovations")
This function retrieves the beta 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".
=elBeta(C11:C20, B11:B20, D9:D18, "quantity", F9:F18, "CHF", 10, "historicalInnovations")
This function retrieves the beta 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
elBeta(AssetIDs[], Quantities[], BenchmarkAssetids[], BenchmarkAmountScheme, BenchmarkAmounts, Currency, RiskHorizon, ScenarioType, ConfidenceLevel, Annualized)
| Argument name | Default | Description |
|---|---|---|
| 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) | 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. |