Investment Studio > Expressions > Functions > Lookup > PORTFOLIO_PERCENT_OTHER

float portfolio_percent_other(integer portfolio_index, date quote_date, boolean allow_old = FALSE)

Returns the residual component (not cash, not bonds, not stocks), expressed as a percentage, of the portfolio identified by portfolio_index, on the specified quote_date.

The portfolio's residual component is computed by adding up the residual component of each asset in the portfolio, weighted by the asset's fraction of the total portfolio value. To compute this fraction, the NAV (Net Asset Value) of each asset (see function asset_nav) on the specified quote_date is converted to the portfolio currency using the latest known currency conversion rate on quote_date.

Use of this function therefore requires that the residual component, NAV on quote_date and conversion rate to the portfolio currency be known for all assets in the portfolio, without exception. If an asset's NAV is not 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 asset NAV to be used instead.

Portfolio indices are references to entries in Investment Studio's internal table of loaded portfolios. The table is automatically created and maintained behind the scene, and may be rearranged at any time. Portfolio indices should therefore never be specified using constants, but rather obtained through the interface methods provided by the object hosting the expression. See e.g. the discussion of lookup cells in Grid objects.

See also asset_nav, currency_convert, portfolio_nav, portfolio_percent_bonds, portfolio_percent_cash, portfolio_percent_stocks.