ELCURRENTNPV
Introduced in version: 18.10
Last modified in version : 20.04
Purpose : retrieve the current valuation of the product
Last modified in version : 20.04
Purpose : retrieve the current valuation of the product
Summary
The ELCURRENTNPV function retrieves the current valuation (Edgelab valuation) as saved in the Edgelab database.
Examples
=ELCURRENTNPV("US0378331005")
Retrieves the price of an Apple share.
=ELCURRENTNPV(A10)
Retrieves the price for the identifier in a cell.
=ELCURRENTNPV("US0378331005", "CHF")
Retrieves the price of an Apple share converted to Swiss Francs.
Syntax
ELCURRENTNPV(assetIds[], currency)
| Argument name | Description |
|---|---|
| assetIds | A single asset identifier representing the instrument (ISIN, FIGI, currency ISO, Edgelab ID). |
| 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”. |