Investment Studio > Expressions > Functions > Lookup

Result type Function name Arguments
float asset_ask (integer asset_index, date quote_date)
float asset_ask_size (integer asset_index, date quote_date)
float asset_bid (integer asset_index, date quote_date)
float asset_bid_size (integer asset_index, date quote_date)
float asset_close (integer asset_index, date quote_date)
string asset_currency (integer asset_index)
float array[*][2] asset_fee_flows (integer asset_index, date start_date, date end_date, float start_flow = 0, float end_flow = 0)
float asset_fees (integer asset_index, date start_date, date end_date)
float asset_first_trade (integer asset_index)
string asset_flag (integer asset_index, date quote_date)
float array[*][2] asset_flows (integer asset_index, date start_date, date end_date, float start_flow = 0, float end_flow = 0)
float asset_high (integer asset_index, date quote_date)
float asset_investment (integer asset_index, date start_date, date end_date)
float asset_last_trade (integer asset_index)
float asset_low (integer asset_index, date quote_date)
string asset_name (integer asset_index)
float asset_nav ((integer asset_index, date quote_date, boolean allow_old = FALSE)
float asset_open (integer asset_index, date quote_date)
float asset_open_interest (integer asset_index, date quote_date)
float asset_percent_bonds (integer asset_index)
float asset_percent_cash (integer asset_index)
float asset_percent_other (integer asset_index)
float asset_percent_stocks (integer asset_index)
float asset_principal (integer asset_index, date start_date, date end_date)
float array[*][2] asset_principal_flows (integer asset_index, date start_date, date end_date, float start_flow = 0, float end_flow = 0)
float array[*][*] asset_quotes (integer asset_index, string fields, date start_date, date end_date = start_date, integer max_quotes = -1)
float array[*][2]   (integer asset_index, date start_date, date end_date)
string asset_symbol (integer asset_index)
float asset_units (integer asset_index, date quote_date)
float array[*][2]   (integer asset_index, date start_date, date end_date)
float asset_volume (integer asset_index, date quote_date)
float portfolio_converted_currency_part (string currency_code, integer porfolio_index, date quote_date, boolean allow_old = FALSE)
string portfolio_currency (integer porfolio_index)
float portfolio_currency_part (string currency_code, integer porfolio_index, date quote_date, boolean allow_old = FALSE)
float array[*][2] portfolio_fee_flows (integer portfolio_index, date start_date, date end_date, float start_flow = 0, float end_flow = 0)
float portfolio_fees (integer portfolio_index, date start_date, date end_date)
float portfolio_first_trade (integer porfolio_index)
array[*][2] portfolio_flags (integer portfolio_index, date quote_date)
float array[*][2] portfolio_flows (integer portfolio_index, date start_date, date end_date, float start_flow = 0, float end_flow = 0)
float portfolio_investment (integer portfolio_index, date start_date, date end_date)
float portfolio_last_trade (integer porfolio_index)
string portfolio_name (integer porfolio_index)
float portfolio_nav (integer portfolio_index, date quote_date, boolean allow_old = FALSE)
float portfolio_percent_bonds (integer portfolio_index, date quote_date, boolean allow_old = FALSE)
float portfolio_percent_cash (integer portfolio_index, date quote_date, boolean allow_old = FALSE)
float portfolio_percent_other (integer portfolio_index, date quote_date, boolean allow_old = FALSE)
float portfolio_percent_stocks (integer portfolio_index, date quote_date, boolean allow_old = FALSE)
float portfolio_principal (integer portfolio_index, date start_date, date end_date)
float array[*][2] portfolio_principal_flows (integer portfolio_index, date start_date, date end_date, float start_flow = 0, float end_flow = 0)
float array[*][2] portfolio_quotes (integer portfolio_index, date start_date, date end_date = start_date, integer max_quotes = -1)
string portfolio_symbol (integer porfolio_index)
integer transaction_asset (integer transaction_number)