Summary

The elAssetCurrency function retrieves the trading currency of the instrument as saved in the EdgeLab database. This function can also be used as a parameter inside other UDFs (see example below).

Examples

=ELASSETCURRENCY("US0378331005")

Retrieves the currency for the Apple share.

=ELASSETCURRENCY(A10)

Retrieves the currency for the identifier in a cell.

=ELASSETCURRENCY(B2:B10)

Retrieves the currencies for a list of cells.

=ELCURRENTNPV("US0378331005",ELASSETCURRENCY(B2))

Retrieves the NPV of “US0378331005” using ELASSETCURRENCY as one of its parameter.

Syntax

ELASSETCURRENCY(assetIds[])
Argument name Description
assetIds Single or multiple asset identifiers (ISIN, FIGI, currency ISO, Edgelab ID).