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