Set Up the Performance Calculation Report for Multicurrency Conversion
- Tom Fahey (Unlicensed)
- Jacob Mathews (Deactivated)
- Pamela Totas (Deactivated)
The Performance Calculation report allows you to perform on-the-fly currency conversion for composites. It is common for global firms to have composites that include constituents with different base currencies. The report allows you to create a composite of constituents in different currencies and have the holdings and transactions converted on the fly to the composite's currency. This section describes the setup needed to support multicurrency conversion.
Set Up Data to Support Currency Conversion
The report identifies the base currency for the portfolio, benchmark, and composite, as needed. It finds the base currency in either the ENTITY_HISTORY table if you select the Use Entity History check box for the report profile, or in the ENTITY_DETAILS table if you clear the Use Entity History check box for the report profile. It identifies the FX rates in the FX_RATE table.
On this page
Enable Cross Currency Calculations
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 Performance Analysis and Reporting.
Set Up PACE System Parameters for Currency Conversion
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:
|
Define Holdings Fields for Conversion
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.
Begin Market Value
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
End Market Value
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.
Define Cash Fields for Conversion
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.
Cash Field Example
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.
Set Up the Report Profile for Currency Conversion
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 Define the Performance Calculation Report Profile.