Page Comparison

Button

Description

Regular Field

Click to access the New Regular Field dialog box, and add a new regular field.

Foreign Exchange Rates

Click to access the Foreign Exchange Rates options and set up on the fly currency conversion. In the Foreign Exchange Rates fields enter a Name, From currency, To currency, and the field from the FX_RATES table that you want to appear in the report.

The Process field indicates how data is retrieved from the database:

• Fetch as of Effective Date (single period)

• Begin Date Quantity or End Date Quantity (multi period)

New Detail Calculation

Click to access the New Detail Calculation Field dialog box, where you can create a new field calculated on the fly. This field is derived from existing database fields and is calculated at the security level.

You can copy the entire formula and paste it into a separate application when editing a detail calculation field. If you add logic or arguments to the formula, they are added to the end of the existing formula by default. For example:

• Price * Quantity = Market Value

• Market Value - Cost = Unrealized Gain/Loss

Cash Adjustment Fields

Click to access the Cash Adjustment fields. In these fields you can indicate the cash activity that has taken place in an entity or security. and link cash data to positions data. They can be used in position, lot level position, and performance calculation reports.

Trade Adjustment Fields

Click to access the Trade Adjustment fields. These fields are used to positions data to trades data and performs calculations that join this data. These fields also summarize transactions from the trades database and incorporate them into a position report.

Compound Security Rollup Fields

Click to access the Compound Security Rollup field. Use these fields to creates the contribution for each of the securities in the option entity and swap entity. These fields calculate a sum for all the securities in the option entity and swap entity and include this total as the security level value in the master portfolio.

Compound Security Rollup fields use the Custom Fields Designer. For example:

IF Inst Investment Type = Swap

THEN ((Inst Sec Mkt Value * Security Par Value) / Fund Mkt Value) * Inst Sec Mod Duration