...
For example, in year 1, Custom Index 3 is equal to 100 basis points above the S&P 500. In year 2, Custom Index 3 is equal to 125 basis points above the S&P 500.
Note: | Eagle Performance offers two approaches to linking data to reflect benchmark changes over time. You can create linked benchmarks or can configure the entity's benchmark assignments to process across changes. For more information, see Link Data Across Benchmark Assignment Changes. |
Anchor | ||||
---|---|---|---|---|
|
Anchor | ||||
---|---|---|---|---|
|
A linked benchmark has a one to one relationship with its underlying source entity. Note that you can only create a linked benchmark at the Total level.
An example of a linked benchmark is defined in the following table.
Date | 1/31/2000 | 5/31/2000 | 8/31/2000 |
---|---|---|---|
Benchmark Assignment | Benchmark1 | Benchmark2 | Benchmark3 |
Data results in the database for the linked benchmark are in the following table.
Date | Benchmark 1 Return | Benchmark 2 Return | Benchmark 3 Return | Linked Custom Benchmark |
---|---|---|---|---|
January 2000 | 1.783789832176 |
1.783789832176 | ||
February 2000 | 2.476630811445 |
2.476630811445 | |||
March 2000 | 2.173112358870 |
2.173112358870 | ||
April 2000 | 2.608787321871 |
2.608787321871 | |||
May 2000 |
3.884952900351 |
3.884952900351 | |
June 2000 |
1.925400872419 |
1.925400872419 | ||
July 2000 |
-.538051121508
-.538051121508 |
August 2000
1.244881581082
1.244881581082
8 month linked
16.597637401914*
*The linking is accomplished in a Performance Analysis report and not by the custom index builder.
...
You can create a custom benchmark with a type of Linked. In the following linked benchmark example, the current index is the Domestic Equity Large Cap index, which has been in place since the "as-of" date 8/6/2009. The History prior to then is linked to the Domestic Equity index, which was in place since the "as-of" date 4/1/2004.
For an example of a Linked benchmark for a Hurdle Based benchmark that includes a basis points adjustment, see Configure a Hurdle Based Benchmark.
To create a linked 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, in the:
- Type list box, select Custom Benchmark.
- ID and Name fields, enter the entity ID and name for the custom benchmark.
- In the Entity Details tab, enter the Inception Date associated with the "first link" of the custom benchmark.
- In the Entity Details tab, enter the Inception Date for the custom benchmark.
...
- In the Custom Index Attributes tab, shown in the previous figure, enter the following data to define the linked custom benchmark's "first link." This custom benchmark begins with the Domestic Equity index, which was in effect since the "as-of" date, 4/1/2004.
The previous figure shows how this tab appears after you choose a date, set the Type to Linked, and select a target dictionary.
The grid at the bottom of the tab shows the structure of the target dictionary selected. See Editing Entity Dialog Box Options for a description of the fields in this dialog box.
For more information about the currency conversion process, see Calculate Returns Using Currency Conversion.
- In the target dictionary grid area, select the Total Level node of the target dictionary that you want to assign, and double-click the corresponding button for that row.
...
- In the Custom Index Attributes Dialog box, assign the source entity, source, source dictionary, source dictionary node, and weight data, and click OK.
...
- Click Finish.
Additional tabs are available in the entity setup but these tabs are not required for the custom benchmark setup. The custom index attributes information is saved in the database in the RULESDBO.CUSTOM_INDEX_ATTRIBUTES table.
- When the Linked benchmark's source entity changes, edit the Linked Benchmark and repeat this process to assign a different source entity as of the appropriate date.
...
-.538051121508 | ||||
August 2000 | 1.244881581082 | 1.244881581082 | ||
8 month linked | 16.597637401914* | |||
*The linking is accomplished in a Performance Analysis report and not by the custom index builder. |
Anchor | ||||
---|---|---|---|---|
|
Anchor | ||||
---|---|---|---|---|
|
...
If you calculate a hurdle based return without compounding, Eagle Performance applies a simple Nth root offset to each observation in the period. If you link the returns for a year, the system may not create an annual return adjusted by exactly the specified number of bps, due to compounding effects.
The system can calculate the CIDX effective dates in any order. For example, a monthly index with 100bps adjustment has added to the return of the source index for every month in the year.
Anchor | ||||
---|---|---|---|---|
|
...
Adjusted for Compounding
If you calculate a hurdle based return adjusted for compounding, Eagle Performance adjusts for compounding effects by calculating a running return for the period that is adjusted by the specified bps, and then backing into the return for the observation date being calculated.
This methodology uses the same approach as the noncompounded method to calculate the Nth root offset to apply. However, the adjustment is not the same for each observation and the system must calculate the observations in order, as it does for floating benchmarks.
In order to adjust for compounding, the entity build accesses the unadjusted (source) returns and adjusted (target) returns for the prior year or back to the entity's last definition change (whichever is more recent). The system takes returns from the stored returns in the PERF_SEC_RETURNS table for each of the specified advanced fields with a CIDX return process type. The system only needs to calculate the return for the current day—no prior returns are adjusted.
Note that the system considers only the most recent definition when calculating for any period.
It must calculate every period from the definition forward in sequence. This is necessary because the current day is adjusted based on the returns of prior days within the annual period (one year or a portion of the year if the last definition is less than a year prior to the effective date for the calculation). The numerator in the equation is the linked unadjusted returns for the year plus the appropriate portion of the yearly bps adjustment (using the appropriate Nth root for each period). The denominator in the equation is the linked adjusted returns for the prior periods in the year. The appropriate portion of adjustment is based on the number of observations in the year (12 for monthly) and the number of periods that have passed for the year.
The adjustment uses only prior performance data for the frequency being calculated. This means a daily calculation requires prior daily returns and a monthly calculation requires prior monthly returns. Neither frequency uses prior data stored under the other frequency.
This solution states each daily return using a running adjustment that can be calculated without knowing future periods and does not restate prior periods. It applies a cumulative 12th root adjustment and backs into each daily return by unlinking the cumulative adjusted return for the prior day. This provides an adjusted daily (or monthly) return series that links to the required adjustment over the period. It calculates a rolling adjustment that works for any annual period.
Anchor | ||||
---|---|---|---|---|
|
...