Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

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.

Anchor
_Toc347318594
_Toc347318594
Note:

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
_Toc12285191
_Toc12285191
Calculate Returns

...

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
_Toc347318595
_Toc347318595
Anchor
_Toc12285192
_Toc12285192
Currency Conversion Benchmark Example

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:

  1. 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


  2. Calculate the Currency Return:

...

((1.013513 * 1.023375) –1)*100 = 3.7204

  1. 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:

  1. Verify that the base currency value was updated for the source entity. See the following figure.

...

  1. 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.

...

  1. 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.

...

  1. 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.

...

  1. source

...

  1. 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.

...

  1. .

...

  1. 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.

  1. Click the Finish button.

...