The currency conversion benchmark allows you to convert the vendor-supplied index returns from your base currency to another base currency.
When using the currency conversion process in Performance reports, the Currency Process and Currency Type options must be set on the underlying PERFORM database fields. PACE prompts you to set them when creating or editing PERFORM database fields.
| Custom index builds for Linked, Blended, and Floating custom benchmark types can convert the component base currency to match the target base currency. This automatic conversion eliminates the need to create a Currency Conversion type of custom benchmark solely to align the base currency of a source entity with the base currency of a Linked, Blended, or Floating type target index. |
Anchor | ||||
---|---|---|---|---|
|
...
The weight columns are copied from the source to the target index, there is no conversion required.
This data is described in the following table.
Data | Stored | Notes |
---|---|---|
Source Index |
Base currency | RULES..ENTITY.BASE_CURRENCY | For the source entity, entered in the Entity Details tab. |
Total Local return | PERFORM..PERF_SEC_RETURNS | Return is in percent format. |
Target Index |
Base currency | RULES..ENTITY.BASE_CURRENCY | For the target entity, entered in the Entity Details tab. |
Exchange Rates |
Exchange rate at begin of period | SECURITY..FX_RATES.SPOT_RATE |
Exchange rate at end of period | SECURITY..FX_RATES.SPOT_RATE |
Anchor | ||||
---|---|---|---|---|
|
Anchor | ||||
---|---|---|---|---|
|
For this example, assume the following currency conversion:
Source Index (USD BASE_CURRENCY) Target Custom Benchmark (INR BASE_CURRENCY)
Data for the currency conversion benchmark source index is listed in the following table.
Perf Rollup Returns ID | Description | ABAL | Return |
---|---|---|---|
1 | Total | 100.000000000000 | 2.337512614320 |
2 | Total – Canada | 0.186961567780 | 1.167482994596 |
3 | Total - Canada - Foreign Govt. | 0.186961567780 | 1.167482994596 |
4 | Total – UK | 21.654973670853 | 3.475919376493 |
5 | Total - UK - Petroleum | 16.356854652918 | 3.800720520895 |
6 | Total – US | 60.189112766022 | 2.149367889086 |
7 | Total - US - Capital Goods | 16.928285677007 | 0.954101703137 |
8 | Total - US - Technology | 17.933412208518 | 2.922672275580 |
9 | Total - US - Petroleum | 2.960736862858 | 3.768148149908 |
10 | Total - US - Basic Industries | 16.596291716438 | 2.654587081941 |
11 | Total – Australia | 17.968951995345 | 1.607967908012 |
12 | Total - Australia - Unknown | 17.968951995345 | 1.607967908012 |
13 | Total - UK - Unknown | 5.298119017935 | 2.473162531641 |
14 | Total - US - Unknown | 5.770386301202 | 0.968905089765 |
Resulting target data for the currency conversion benchmark is listed in the following table.
Perf Rollup Returns ID | Description | ABAL (%) | Return | New Wt (%) | New Return |
---|---|---|---|---|---|
1 | Total | 100.00 | 2.337513 | 100.00 | 3.720452 |
2 | Total - Canada | 0.19 | 1.167483 | 0.19 | 2.534611 |
3 | Total - Canada - Foreign Govt. | 0.19 | 1.167483 | 0.19 | 2.534611 |
4 | Total - UK | 21.65 | 3.475919 | 21.65 | 4.874243 |
5 | Total - UK - Petroleum | 16.36 | 3.800721 | 16.36 | 5.203433 |
6 | Total - US | 60.19 | 2.149368 | 60.19 | 3.529765 |
7 | Total - US - Capital Goods | 16.93 | 0.954102 | 16.93 | 2.318346 |
8 | Total - US - Technology | 17.93 | 2.922672 | 17.93 | 4.313519 |
9 | Total - US - Petroleum | 2.96 | 3.768148 | 2.96 | 5.170420 |
10 | Total - US - Basic Industries | 16.60 | 2.654587 | 16.60 | 4.041811 |
11 | Total - Australia | 17.97 | 1.607968 | 17.97 | 2.981049 |
12 | Total - Australia - Unknown | 17.97 | 1.607968 | 17.97 | 2.981049 |
13 | Total - UK - Unknown | 5.30 | 2.473163 | 5.30 | 3.857935 |
14 | Total - US - Unknown | 5.77 | 0.968905 | 5.77 | 2.333350 |
Effective_date | INR | USD | SPOT_RATE |
4/30/2000 | 1457 | 1454 | 43.66 |
5/31/2000 | 1457 | 1454 | 44.25 |
Complete the following:
Retrieve the begin and end exchange rates listed in the following table.
Effective Date
INR
USD
Spot Rate
4/30/2000
1457
1454
43.66
5/31/2000
1457
1454
44.25
- Calculate the Currency Return:
...
((1.013513 * 1.023375) –1)*100 = 3.7204
- Weights are copied from the source data.
...
You can create a custom benchmark with a type of Currency Conversion. In this example, the custom benchmark converts the Domestic Equity Index from USD to British Pounds.
To configure a currency conversion benchmark:
- Verify that the base currency value was updated for the source entity. See the following figure.
...
- In the Entity Info tab, create the custom benchmark entity as shown in the previous figure.
- Set the entity Type to Custom Benchmark.
- Enter the entity ID and name information for the custom benchmark.
...
- In the Entity Details tab:
- Populate the base currency field for the custom benchmark entity. See the previous figure.
This value is the target base currency. Ensure that the base currency exists on the correct asof date.
- Enter the Inception Date for the custom benchmark.
This field is not required, but as a best practice, Eagle recommends entering an inception date that matches the effective date of the earliest definition (that is, the earliest date associated with data entered in the Custom Index Attribute tab) for the custom benchmark.
- Also, be sure you defined the Base Currency for the source index associated with this Custom Benchmark.
...
- In the Custom Index Attributes tab, define the following information. See the previous figure.
- Effective Date. The effective date of the custom index attributes definition when you save it in the database. In the Select Historical Date section, select one of the following options to identify the date for the attributes you are defining:
- AsOf today
- Use earliest holding date
- Use this value <DATE>
For additional information about the historical date options, see Set Up the Custom Index Attribute for Historical Date.When you edit the entity, additional options become available. For details, see Delete Custom Index Attributes.
...
- source
...
- data
...
Ensure that the Source Rule includes a Foreign Exchange Source. The Foreign Exchange Source within the Source Rule is used to determine the spot rate.
...
- .
...
- In the Exchange Rate Source Rule field, select a current source rule to use for the exchange rates.
...
- Target Base Currency. Identifies the base currency to convert to. Displays the base currency you entered for the custom benchmark on the Entity Details tab.
- Source Base Currency. Identifies the base currency to convert from. Displays the base currency associated with the source entity selected on this tab.
If you do not indicate the currency, the fields display a value of Not Specified.
- Click the Finish button.
...