To change system settings that affect rescaling of ABALs and weights:
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 System Parameters.
You see the System Parameters workspace.Click the Performance System Parameters link at the top of the page.
The Performance System Parameters page appears. See the following figure.
In the row for Sys Item 31, click the Edit link, select one of the following values, and then click Save.
Y (Yes). Default value. Allows the use of Average Invested Balances (ABALs) that do not add up to 100%. This option affects ABALs for Blended benchmarks, Floating benchmarks, and Floating active weight benchmarks.
N (No). Does not support the use of Average Invested Balances (ABALs) that do not add up to 100%. This setting provides backward compatibility.
The new value appears in the corresponding Sys Value cell.
For more information about Performance System Parameters, see Performance Calculation.
Anchor | ||||
---|---|---|---|---|
|
Anchor | ||||
---|---|---|---|---|
|
Anchor | ||||
---|---|---|---|---|
|
You can set up an attribute for any historical date during initial entity setup. This applies to all types of benchmarks, and saves setup time for complex custom benchmarks such as floating, blended, and others. For an example of a blended custom benchmark, see the following figure.
Anchor | ||||
---|---|---|---|---|
|
Anchor | ||||
---|---|---|---|---|
|
Anchor | ||||
---|---|---|---|---|
|
You can select multiple historical dates and delete previously defined index attributes. You can access them in the Custom Index Attributes tab on the Editing Entity screen, shown in the following figure.
When you click the Delete History option shown in the previous figure, the Delete Entity History dialog box appears with all of the historical custom index attribute dates. See the following figure.
To delete history, select one or more dates in this dialog box and click Delete Selected, as shown in the previous figure. In this example, if the custom index attribute on 5/1/2003 is deleted, the preceding index attribute (4/30/2003) takes effect when the custom index build runs.
Anchor | ||||
---|---|---|---|---|
|
Anchor | ||||
---|---|---|---|---|
|
Anchor | ||||
---|---|---|---|---|
|
The following describes the Build Security Level check box in the entity Custom Index Attributes tab, which is available for use with Blended and Floating custom benchmarks.
The custom benchmark builder can build both segment and security level returns for a custom benchmark. Both the segment and security levels are created for each entity build dependent upon the source data. The entity build uses whatever source data is available in the database for the indicated source entities to create the blend. The build currently cannot support source entities with duplicate securities due to constraints on the PERFORM database tables. This can be an issue when builds contain source entities with shared securities, for example, two equity benchmarks that both hold IBM. Another possible issue with a custom blend is when one source benchmark contains security level data and another source benchmark does not. In this case, the build creates a custom benchmark with the securities from only one source benchmark, which can be misleading.
This gives you the option to build the security level by entity. In a case where duplicate securities are contained in the underlying source entities, this option must be enabled for the entity build to be successful. The option is located in the window. The option is saved in the custom index attributes table under a column named BUILD_SECURITY_LEVEL. This option is only available to the custom benchmark types that support more than one source entity: blended benchmarks and floating benchmarks. If you assign this check box a value of:
Selected. This option builds the security level for the custom benchmark. By default, this check box is cleared when you create a new custom benchmark. If you select this check box, the Do not build Target Dictionary below assigned level check box becomes unavailable.
Cleared. If the option is not selected, as shown in the previous figure, the security level data is not built in the database.
Anchor | ||||
---|---|---|---|---|
|
Anchor | ||||
---|---|---|---|---|
|
Anchor | ||||
---|---|---|---|---|
|
The following describes the Do not build Target Dictionary below assigned level check box in the entity Custom Index Attributes tab, which you can use with Blended and Floating type custom benchmarks. See the following figure.
This option allows you to build blended or floating custom benchmarks from source nodes with a different number of levels below them than their assigned target nodes. It determines whether the entity build process creates target dictionary nodes below the assigned level, and increases the compatibility between performance models. For example, you can use a 2-level source (fund, investment type) with a 1-level target (fund). When this option is:
Selected. If you select this check box, the entity build process builds the target performance model from the assignment node up to the total level for the model. It does not process levels below the assigned node. For blended, floating, and active weight floating custom benchmarks, the system does not validate that the source performance model(s) and target performance model have compatible structures. For active floating weight custom benchmarks, the system does not confirm that the reference entity structure matches the target performance model below the assigned nodes.
By default, this check box is selected when you create a new custom benchmark. If you select this check box, the system does not process security level data. Therefore, the Build Security Level check box becomes unavailable, and you cannot select it.
Cleared. If you clear this check box, the entity build process builds the target performance model all the way down to its lowest level.
When cleared, each time you assign nodes to the target model or save the custom benchmark, the system validates that the source performance model(s) and target performance model have compatible structures. It counts the levels below the assigned source node and ensures that there are at least that many levels below the assigned target node. If the target has fewer nodes, a warning message appears so you can correct the benchmark before you start the entity build process.
The sample custom benchmark, CIDXBL01, shown in the previous figure illustrates a scenario where the same two-level asset class model is used by both the source and target entities. The top (Total) level of the Asset Class Model from the source entities are assigned to the lowest (equity, cash, or bond) level of the target entity. This assignment can build because you selected the Do not build Target Dictionary below assigned level check box, indicating that only the Total level data is used from the source entities. Otherwise, if you did not select this option, you would need to create another performance model at the Total level, and you would need to calculate performance for each source entity, and then use that new Total level model in the definition of the custom benchmark.
Anchor | ||||
---|---|---|---|---|
|
Anchor | ||||
---|---|---|---|---|
|
You can choose the same entity as the source for two or more different nodes in a target dictionary using the Custom Index Attributes tab of the Creating a new entity dialog box. See the following figure. This applies to both Blended and Floating type custom benchmarks.
The following figure shows how you build a custom blended benchmark where you choose select nodes within a source entity. In this example, the target dictionary lists the Entity Total with the Investment Type and descriptions:
Cash & Cash Equivalents – 30% of Asset Class Blend Cash & Cash Equivalents Node (Total --> Cash & Cash Equivalents)
Fixed Income – 70% of Asset Class Blend Fixed Income Node (Total --> Fixed Income)
Anchor | ||||
---|---|---|---|---|
|
Anchor | ||||
---|---|---|---|---|
|
Anchor | ||||
---|---|---|---|---|
|
Custom index builds can source component values in their base currency and translate those values into the base currency of the target custom benchmark. This process supports converting vendor-supplied data for index returns and non-return data such as market values.
For information on setting up custom benchmarks to perform currency conversions, see Create a Blended Weighted Benchmark, Create an Active Weight Custom Benchmark, Create a Linked Benchmark, and Create a Currency Conversion Benchmark.
Anchor | ||||
---|---|---|---|---|
|
The following describes the logic used to calculate the Linked, Blended, and Floating benchmark returns when there is a currency conversion set. To calculate the currency converted return, the process:
Retrieves the period begin and end exchange rates where the FROM currency equals the base currency of the source index and the TO currency equals the base currency of the target index.
Calculates the Currency Returns for the period.
Currency Return = (End Exchange Rate / Begin Exchange Rate) - 1Converts Currency Returns to growth rates.
Growth Rate = (Currency Return/100) + 1Converts Source Index Returns to growth rates.
Growth Rate = (Return/100) + 1Multiplies the Source Index Return Growth Rate by the Currency Growth Rate over the period, and converts it into the Target Index Return.
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 | ||||
---|---|---|---|---|
|
For this example, assume the following currency conversion: Source Index (USD BASE_CURRENCY) Target Custom Benchmark (INR BASE_CURRENCY)
Data for the 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 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:
((44.25/43.66) – 1) * 100 = 1.351351Convert the Currency Return into a Growth Rate:
(1.351351/100) + 1 = 1.013513Convert Source Index Return to a Growth Rate:. For example, Total Return:
2.337513/100) + 1 = 1.023375Multiply the Source Index Return Growth Rate by the Currency Growth Rate and convert into a return:
((1.013513 * 1.023375) –1)*100 = 3.7204Weights are copied from the source data.
Anchor | ||||
---|---|---|---|---|
|
Eagle Performance can perform currency conversions for source data such as opening market values and closing market values during the custom benchmark build process.
To calculate the currency converted market value, the process multiplies the Source Market Value by the Exchange Rate as specified in the currency process. For example, if you set the Advanced field's Currency Process attribute to Begin Value, the calculation uses the exchange rate associated with the beginning of the period.
A worked example is that a Source Begin Market Value of 100 USD converts to 4,366 INR (100 * 43.66 = 4,366).
Anchor | ||||
---|---|---|---|---|
|
When you set up Advanced field attributes for use with builds for custom benchmarks that require currency conversion, you must define each field attribute's Currency Process setting and its Process setting correctly. You set up these attributes to enable Eagle Performance to calculate base and local returns, weights, as well as non return values that may require currency conversion, such as market values.
Currency conversion occurs for custom benchmarks that have an Exchange Rate Source Rule field value specified at the entity level to indicate currency conversion is needed. If you are setting up a field attribute to store a return or a non return value such as a market value that requires currency conversion, you must specify a value for the Currency Process attribute to enable currency conversion. You must additionally set the Process Attribute to a value of Custom Index for returns or to a value of Custom Index Weighted Field for non return fields such as a weight or market value. However, you do not need to specify a Currency Process attribute for weights, as they do not require currency conversion.
The following table describes how to set the Currency Process and the Process attributes in Advanced fields created for several sample scenarios. Some of these scenarios involve currency conversion, while others do not. The table also indicates whether the system uses the period begin and/or end exchange rates to perform currency conversion in each case.
Example | Description | Currency Process Attribute | Process Attribute | Use Begin Exchange Rate | Use End Exchange Rate |
---|---|---|---|---|---|
Local return | Gross Return in Local Currency | None | Custom Index | – | – |
Base return | Gross Return | Return Value | Custom Index | YES | YES |
Weight | Gross Investment Base | None | Custom Index Weight Field | – | – |
Local begin market value | Gross Begin Market Value in Local Currency | None | Custom Index Weight Field | – | – |
Base begin market value | Gross Begin Market Value | Begin Value | Custom Index Weight Field | YES | – |
Local end market value | Gross End Market Value in Local Currency | None | Custom Index Weight Field | – | – |
Base end market value | Gross End Market Value | End Value | Custom Index Weight Field | – | YES |
Several Advanced field examples follow. For a general discussion about defining Advanced fields for custom benchmark builds, see Set Up Field Attributes for Custom Benchmarks.
Local Return Example
The following example shows the field attribute for a local return. Notice that the Process attribute is set to Custom Index and the Currency Process attribute is set to None.
Base Return Example
The following example shows the field attribute for a base return. Notice that the Process attribute is set to Custom Index and the Currency Process attribute is set to Return Value.
Weight Example
The following example shows the field attribute for a weight. Notice that the Process attribute is set to Custom Index Weight Field and the Currency Process attribute is set to None. Currency conversion does not apply to weights.
Begin Market Value Example
The following example shows the field attribute for a beginning market value. Notice that the Process attribute is set to Custom Index Weight Field, which can apply to non return values such as weights and market values. In this case, the Currency Process attribute is set to Begin Value, so that the currency conversion process uses the beginning exchange rate.
If you are defining a field attribute for a gross ending market value, you set the Currency Process attribute to End Value, so that the currency conversion process uses the ending exchange rate.