Investment Studio > Expressions > Functions > Lookup > ASSET_NAV

float asset_nav(integer asset_index, date quote_date, boolean allow_old = FALSE)

Returns the NAV (Net Asset Value) of the asset identified by asset_index on the specified quote_date (if available).

When no quote is available for quote_date, allow_old = FALSE (default) causes the function to fail with an #N/A error condition; allow_old = TRUE causes the first available, preceding quote to be used instead.

With allow_old = FALSE, this function is equivalent to (but more efficient than) the expression

=asset_units(asset_index, quote_date) * asset_close(asset_index, quote_date)

Asset indices are references to entries in Investment Studio's internal table of assets in the selected portfolio. The table is automatically created and maintained behind the scene, and may be rearranged at any time. Asset indices should therefore never be specified using constants, but rather obtained through the interface methods provided by the object hosting the expression (if need be with the aid of the transaction_asset function). See e.g. the discussion of lookup cells in Grid objects.

See also asset_ask, asset_ask_size, asset_bid, asset_bid_size, asset_close, asset_currency, asset_high, asset_low, asset_open, asset_open_interest, asset_quotes, asset_units, asset_volume.