Anchor | ||||
---|---|---|---|---|
|
The Performance Calculation report allows you to use cross currency calculations to arrive at the FX rate of a third currency by triangulation. For a general discussion of triangulation and setup for cross currency calculations, see
...
...
.
Anchor | ||||
---|---|---|---|---|
|
This section describes how to set up the PACE system parameters that support multicurrency conversion for the Performance Calculation report. These parameters can also affect currency conversion in other types of PACE reports.
To change system settings related to currency conversion:
From any Eagle window, click the Eagle Navigator button to access the Eagle Navigator.
Enter System Parameters in the Start Search text box.
Click the System Parameters (System Management Center) link to access the System Management Center.
You see the PACE System Parameters page.For each system setting related to currency conversion processing that you want to edit, select the check box to the left of the Sys Item, click Edit and select a different value, and then click Save.
The new value appears in the corresponding Sys Value cell. The following table describes each setting related to currency conversion.
Sys Item | Name | Description |
---|---|---|
40 | FX rates quotation method | Determines if the FX rate is a multiplier or divisor. Used for cross currency calculations to indicate whether the FX_RATES table contains either multiply by or divide by rates. If set to:
|
112 | Number of days to go back to look for FX rates | Determines how many days to look back for FX rates. |
135 | FX Cross Rate Currency - ISO code of the Currency used for cross rates | If you enable cross currency calculation, identifies the ISO code of the reference currency you use to store FX rates. |
137 | Cross Currency Calculation | Determines whether to enable cross currency calculation. If set to:
|
Anchor | ||||
---|---|---|---|---|
|
When you run the Performance Calculation report to perform multicurrency conversion for composites, after the report finds the exchange rates, it uses underlying holdings fields to convert their underlying holdings amounts to amounts in the composite's base currency. You may need to create underlying holdings fields as Advanced Fields that use the following settings.
Anchor | ||||
---|---|---|---|---|
|
Eagle Performance converts the beginning market value with the FX rate from the previous day's effective date. Ensure that the Advanced Field you select as the Beginning Market Value has:
Currency Process set to End Value
Currency type set to Base Currency
Field Type set to Decimal
Process for Begin Market Value set to Begin Date Holding or Entity
Anchor | ||||
---|---|---|---|---|
|
Eagle Performance converts the ending market value with the FX rate from the end market value's effective date. Ensure that the Advanced Field you select as the Ending Market Value has:
Currency Process set to End Value
Currency type set to Base Currency
Field Type set to Decimal
Process for Begin Market Value set to End Date Holding or Entity
The following figure shows a sample holdings field.
...
...
Anchor | ||||
---|---|---|---|---|
|
When you run the Performance Calculation report to perform multicurrency conversion for composites, after the report finds the exchange rates, it uses cash fields to convert the cash flows using the cash flow's effective date before summing up those flows. After the conversion, the report sums the cash from all effective dates for each security for each field. You may need to create cash fields that use the following settings.
Anchor | ||||
---|---|---|---|---|
|
When you define a Cash field for conversion, the Currency Process option controls whether the FX rate used is from the prior business day (Begin Value) or is from the current business day (End Value). Note that prior to V12.1.1, both Currency Process settings resulted in the current business day FX rate being used.
Ensure that the Advanced Field you select as the cash field has:
Currency Process set to End Value (Eagle recommendation) or Begin Value
Currency type set to Base Currency
Field Type set to Decimal
The following figure shows a sample cash field.
...
...
Anchor | ||||
---|---|---|---|---|
|
You can select the Convert constituents and benchmark to composite currency check box to enable the report profile to perform on-the-fly conversion for composites. For more information, see
...
...