ELCURRENTNPV

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".