...
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:
- Calculate Total Constrained Weight = 10% - 17.97% = -7.97%.
- Calculate the Sum of the Total Source Weight at all Constrained Levels = 17.97%.
- 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:
- From any Eagle window, click the Eagle Navigator button to access the Eagle Navigator.
- Enter Entities in the Start Search text box.
- Click the Entities (Performance Center) link. You see a list of entities.
- Click the Create link.
...
- In the Entity Info tab:
- Set the entity Type to Custom Benchmark.
- Enter the entity ID and name information for the custom benchmark.
- In the Entity Details tab, enter the Inception Date for the custom benchmark.
...
- 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.
- 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.
- You can constrain individual securities for a level displayed in the grid by clicking the ellipsis button located next to a level.
...
- 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.
- Click the Finish button.
...