elAssetCurrency

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