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 |
|---|---|
| AssetID | A single asset identifier representing the instrument (ISIN, FIGI, currency ISO, Edgelab ID). |
| RefCurrency | 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”. |