You create new custom fields using the Fields toolbox in the workspace. The contents of the Fields toolbox changes based on the type of report or report rule you are creating.
The buttons on the Fields toolbox are described in the following table.
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:
|
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:
|
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 |
0 Comments