Investment Studio > Expressions > Functions > Lookup > ASSET_FIRST_TRADE

float asset_first_trade(integer asset_index)

Returns the date + time of the first transaction in the asset identified by asset_index.

The integral part of the function value (sometimes also referred to as a "serial number") is the number of whole days since December 30, 1899. The fractional part is the fraction of a day since midnight.

Note that the time (fractional part) may not have been recorded in the database. A default time value of 0 (midnight) is common.

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_currency, asset_last_trade, asset_name, asset_percent_bonds, asset_percent_cash, asset_percent_other, asset_percent_stocks, asset_symbol, asset_units.