Versions Compared

Key

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

...

For the purposes of example, assume the source index (vendor-supplied index) and constraints listed in the following table.

Dictionary Level

Fixed

Total

 


Australia

10%

Unknown

 


Canada

 


Foreign Gov.

 


UK

 


Petroleum

 


Unknown

 


US

 


Capital Goods

 


Technology

 


Petroleum

 


The following table lists the data for the source index for this example constrained benchmark.

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

In the following table, the resulting target data for the constrained benchmark is listed.

Description

ABAL (%)

Return

Fixed (%)

Wt. Chg. (%)

New Weight (%)

Return Recalc

New Returns

Total

100.00

2.337513

 

 



100.00

2.408385

2.408385

Total – Canada

0.19

1.167483

 


0.02

0.21

 


1.167483

Total – Canada – Foreign Govt.

0.19

1.167483

 


0.02

0.21

 


1.167483

Total – UK

21.65

3.475919

 


2.10

23.76

 


3.475919

Total – UK – Petroleum

16.36

3.800721

 


1.59

17.95

 


3.800721

Total – US

60.19

2.149368

 


5.85

66.04

 


2.149368

Total – US – Capital Goods

16.93

0.954102

 


1.64

18.57

 


0.954102

Total – US – Technology

17.93

2.922672

 


1.74

19.68

 


2.922672

Total – US – Petroleum

2.96

3.768148

 


0.29

3.25

 


3.768148

Total – US – Basic Industries

16.60

2.654587

 


1.61

18.21

 


2.654587

Total – Australia

17.97

1.607968

10

-7.97

10.00

 


1.607968

Total – Australia – Unknown

17.97

1.607968

X

-7.97

10.00

 


1.607968

Total – UK – Unknown

5.30

2.473163

 


0.51

5.81

 


2.473163

Total – US – Unknown

5.77

0.968905

 


0.56

6.33

 


0.968905

Sum of Total Source Weight at Constrained Levels

17.97

 

 

 

 

 

 







Total Constrained Weight

-7.97

 

 

 

 

 

 







Complete the following:

  1. Calculate Total Constrained Weight = 10% - 17.97% = -7.97%.
  2. Calculate the Sum of the Total Source Weight at all Constrained Levels = 17.97%.
  3. Calculate the New Weights for the constrained segments/securities and those below the constraints. For example:

...

For example: Total UK Return = 3.475919
Returns above the constrained node are recalculated — in the example in the following table, only the Total return is recalculated.

Description

Return

New Weight

Target Return

Total

 

 



2.408384642

Total - Australia

1.607968

10.00%

0.160796791

Total - Canada

1.167483

0.21%

0.002394788

Total - UK

3.475919

23.76%

0.825831804

Total - US

2.149368

66.04%

1.41936126

...

You can create a custom benchmark with a type of Constrained. In this example, the custom benchmark constrains the Domestic Equity Index weights, setting the Oil & Gas sector to 10% and capping the Mining sector to <= 5%.
To configure a constrained custom benchmark:

  1. From any Eagle window, click the Eagle Navigator button to access the Eagle Navigator.
  2. Enter Entities in the Start Search text box.
  3. Click the Entities (Performance Center) link. You see a list of entities.
  4. Click the Create link.

...

  1. In the Entity Info tab:
  • Set the entity Type to Custom Benchmark.
  • Enter the entity ID and name information for the custom benchmark.
  1. In the Entity Details tab, enter the Inception Date for the custom benchmark.

...

  1. Select the Custom Index Attributes tab, shown in the previous figure, and define the critical data for the definition of the custom benchmark:
  • 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.

  • Save History. This button allows you to save an "as of" definition to the database. The Finish button serves the same purpose.
  • Type. The type of custom benchmark you are creating. Use a value of Constrained.
  • Source. The source under which the source entity data is stored in the PERFORM database.
  • Source Dictionary. The source dictionary under which the entity data is stored in the PERFORM database. When you select the source dictionary, the system displays the levels and sub levels associated with that dictionary in a grid at the bottom of the tab.
  • Entity. The source entity from the PERFORM database.
  • Date Rule. This option does not apply for this type of benchmark.
  1. In the grid area at the bottom of the tab, enter any constraints that apply to an entire segment level by entering the constrain flag and weight percentage at the desired level:
  • Constrain Flag. Used to indicate Fixed or Cap constraint, as follows:
  • Cap. A cap constraint sets the upper limit that the weight of a segment or security can take in the target custom benchmark. If the cap is not reached, the vendor-supplied benchmark weight for the segment is used for the period.
  • Fixed. A fixed constraint sets the exact weight that a segment or security takes in the target custom benchmark.
  • Weight (%). The weight to set for the Fixed or Cap constraint.

In this example, a cap of 5% applies to the Mining sector, and the Oil & Gas sector have a fixed constraint of 10%.
If you constrain a dictionary level that includes sub levels, the Weight (%) cell for each related sub level displays a solid gray color, indicating that a "parent level" constraint applies to the sub level.

  1. You can constrain individual securities for a level displayed in the grid by clicking the ellipsis button located next to a level.

...

  1. If you are constraining securities within a level, select the securities to constrain, enter the constrain flag and weight information, and click OK.

You can use the arrows to move securities from the Available Securities area to the Selected Securities area. In this case, the selected securities are selected for constraint.
When the Custom Index Attributes tab reappears, the Weight (%) cell for the level with constrained securities displays a solid gray color, indicating that you applied a constraint to part, but not all, of the specified level.

  1. Click the Finish button.

...