ELASSETMEASURE
Summary
The ELASSETMEASURE function retrieves a number of different measures such as the probability of hitting the barrier, the yield-to-call, the probability of autocall on the next observation etc. Note: The expected-time-to-maturity measure is only applicable to structured products.
Examples
=ELASSETMEASURE("ytm", C11:C50)
Retrieves the yield-to-maturity for each bond in the range C11:C50.
Syntax
ELASSETMEASURE(assetMeasure, assetIds[], isNormalized)
| Argument name | Default | Description |
|---|---|---|
| assetMeasure | The name of the measure to be returned. | |
| assetIds | Single or multiple asset identifiers (ISIN, FIGI, currency ISO, Edgelab ID). | |
| isNormalized (Optional) | False | True: the fund's asset class' weights are renormalized, False, the fund asset class' weights are not |