You can use the Performance Calculation report to calculate single-period returns for portfolios, GIPS composites, benchmarks, and retail funds. This procedure provides step-by-step instructions for calculating single-period returns You can use the Performance Calculation report to calculate single-period returns for portfolios, GIPS composites, benchmarks, and retail funds. This procedure provides step-by-step instructions for calculating single-period returns for portfolios using the Performance Returns report profile.
To define the Performance Calculation report profile:
From any Eagle window, click the Eagle Navigator button to access the Eagle Navigator.
Enter Reporting in the Start Search text box and click the General Reporting (Performance Center) link.
You see the Performance Center with the General Reporting workspace.Click
...
The Reports Explorer appears.
- In the report categories area, expand the Performance Calculations folder, select the Performance Returns folder, and click Compose.
- Under Pick a type of Report, select the Double click here to build your report link.
...
- Complete the options for Step 1 and click Next.
...
- Complete the options for Step 2 and click Next.
The following table describes each option.
...
Selection
...
Description
...
1. Do you want to commit returns on the server side?
...
Determines whether to commit the returns. Options include:
- Yes. Automatically commits returns as they are calculated.
- No. Calculates, but does not commit, returns. You can commit them after reviewing the report.
...
2. Returns will be committed with the entities you chose in the screen.
...
Calculates returns for one entity, but stores the returns to a different entity.
...
3. Would you like to calculate to-date returns?
...
Determines whether to calculate to-date returns.
Note: To ensure backwards compatibility, Eagle does not recommend setting this option. See "Appendix B: Using the MPC" for detailed information about how to store to-date returns.
...
4. What calculated end date returns do you want to commit?
...
Specifies the end-date returns you want to commit.
Note: To ensure backwards compatibility, Eagle does not recommend setting this option. See "Appendix B: Using the MPC" for information.
...
5. Specify additional options if you wish.
Allows you to set several additional options.
The Do not update Business Calendar check box determines whether to update the Eagle PACE business calendar. Options include:
...
6. Select Commit Source
...
Specifies the source that the report uses to commit performance results to the PERFORM database. The default source, Eagle PACE (source instance 4), appears, but you can select a different performance source. A performance source is a source that has a feedback type of Performance.
...
- Complete the options for Step 3 and click Next.
The following table describes each option.
Selection | Description |
---|---|
1. Would you like to schedule this report? | Determines whether to schedule the report. Options include:
|
2. Specify your report options by clicking on the button below. | Displays the Report Options dialog box, which allows you to identify the number of result levels, customize the report location on the server, place the report in a personal or public folder, publish the report to various groups and users, return or generate the result when submitted, send the result as an email or via Portal, and save the result as a file. |
...
Selection | Description |
---|---|
Do not return the Result when submitted. | Determines whether to display the results when you submit the report. Options include:
|
Do not generate the result when submitted. | Note this option is only available when the first option is enabled.
|
...
- Complete the options in Step 4 and click Finish.
The following table describes each option.
...
Selection
...
Description
...
1. What name do you want for your report?
...
Specifies a name for the report.
...
2. Type in any comments or remarks you wish.
...
Allows you to add comments.
...
3. Would you like to create Advanced Report components with the current profile.
...
Determines whether to create an Advanced Report.
...
4. Do you want to submit the report now?
...
Determines whether to submit the report.
Step 1 Options
The following table describes each option for Step 1.
...
Selections
...
Description
...
1. What is the period you want to run the Performance Calculations for?
...
Defines the periodicity of the calculation period. The selection controls the dates that are available in the date ranges. For example, if monthly returns are calculated, the holdings data is retrieved for calendar month- end dates. Options include:
- Daily
- Monthly
- Quarterly
...
2. Which entities are you interested in?
...
Specifies the entities on which the calculation is performed.
...
3. Specify the date period you want to run the Calculations for.
...
Defines the holding's begin and end date for the single-period calculation. For portfolios and composites, Eagle Performance retrieves the cash flows for dates greater than the begin date and less than or equal to the end date. If the date range includes multiple periods, Eagle Performance calculates single-period returns for each period. Options include:
- Between. Allows you to specify a start date and end date.
- Date Range (Date Rule). Allows you to select a Date Rule and to select the Use Business Calendar check box.
- Date Range. Allows you to specify a start date and end date and select the Use Business Calendar check box.
- Current day. Uses the Eagle PACE business calendar to identify the date for each calculation.
- Prior day. Uses the Eagle PACE business calendar to identify the date for each calculation.
- Prior Month. Uses the Eagle PACE business calendar to identify the dates for each calculation.
- Link Period Override. If the report includes fields with fixed date linking options (for example, Performance Link Analysis fields, Performance Risk Analysis fields), you can use the Link Period Override option to override the field level date range with a different date range. This option does not affect other linking options you select using Performance Link Analysis fields, Performance Analysis fields, or Performance Risk Analysis fields. They use the profile To date as the end effective date. You can use this option to obtain a report with Beginning Market Value, Ending Market Value, Cash Flows, and Linked Return for the period selected in the profile. For more information about the Link Period Override option and how to use it with Advanced Reports, see the Performance Analysis and Reporting User Guide.
- Between (Date Rule). Allows you to specify a Date Rule.
For information about using standard date rules in reports, see the PACE Reporting Reference Guide.
...
Use Business Calendar
Specifies whether to use the business calendar to select the begin and end dates of the report for each calculation in the date range. Options include:
...
4. Specify the rules you would like to use for your calculations.
...
Allows you to select one or more report rules, and optionally override the field rule and/or source rule associated with those report rules. You can select more than one rule to calculate returns for the same portfolio more than one way, for example, by country and by sector.
For more information, see "Working with Report Rule Overrides."
...
5. Specify additional options if you wish.
...
Lets you specify additional options. Options include:
- Show Missing Entities. When you select this check box, if there are no holdings and cash flows for one of the entities you select, this option displays a row for that entity to let you know that you are missing accounting data for the period.
- Monthly Composites. If you select this check box, this option determines composite constituents based on whether the portfolio was in the composite for the entire month when calculating daily composite returns. If you clear this check box, this option determines composite constituents based on whether the portfolio was in the composite on the effective date of the return when calculating daily composite returns.
- Enumerate Composites. This option is used to process composite (COMP) entities. If you select this check box and report on composites of composites, Eagle Performance looks through multiple levels of composites to find the portfolios used for gathering the position, cash, and/or performance data used to calculate the composite returns. It looks through to the lowest level in the composite entity structure to perform calculations.
Otherwise, if you leave this check box cleared and report on composites of composites, Eagle Performance does not look through composites of composites. Instead, it looks only for the direct constituents of the top level composites specified in the report profile.
...
6. What data would you like to use for your calculations?
...
Lot level holdings are not currently supported.
Determines whether to use security level data or lot level holdings. Select the Security option.
...
7. Would you like to rollup securities at the last level?
...
Determines whether to rollup securities at the last level. Options include:
- Yes. If selected, Eagle Performance combines multiple holdings of the same security into one row. For example, when calculating returns for composites you may have multiple holdings of the same security in multiple funds. This option must be enabled when you are committing returns.
- No. If selected, Eagle Performance calculates separate returns for each holding of the same security within a composite. For reporting only, the separate returns cannot be stored.
...
8. Enable significant cash flow processing?
...
Determines whether to enable significant cash flow processing. This option is available only if you select a period of Monthly.
If you select this check box, this option calculates multiple sub-period returns over the holding period and links them together. The dates breaking the sub-periods are those when there were large cash flows. See "Chapter 4: Processing Significant Cash Flows (SCF)" for detailed information about entering related criteria.
If cleared, this option calculates a single-period return for the period.
...
9. Convert constituents and benchmark to composite currency
Allows you to perform on the fly currency conversion for multicurrency composites. Options include:
...
10. Disable DQM processing
...
Stops the Performance Calculation from running any Data Quality Rules that would normally be processed. This can reduce processing time re-running Performance Calculations when the Data Quality Rules are not required.
...
the Reports tab.
The Reports Explorer appears.In the report categories area, expand the Performance Calculations folder, select the Performance Returns folder, and click Compose.
Under Pick a type of Report, select the Double click here to build your report link.
You see the Creating a Performance Calculation Report - Step 1 of 4 dialog box. See the following figure.Complete the options for Step 1 and click Next.
Refer to Step 1 Options for more information.
After clicking Next, you see the Step 2 of 4 dialog box. See the following figure.Complete the options for Step 2 and click Next.
Refer to Step 2 Options for more information.
After clicking Next, the Step 3 of 4 dialog box appears. See the following figure.Complete the options for Step 3 and click Next.
Refer to Step 3 Options for more information.
After clicking Next, the Step 4 of 4 dialog box appears. See the following figure.Complete the options in Step 4 and click Finish.
Refer to Step 4 Options for more information.
Step 1 Options
Anchor | ||||
---|---|---|---|---|
|
The following table describes each option for Step 1.
Selections | Description |
---|---|
1. What is the period you want to run the Performance Calculations for? | Defines the periodicity of the calculation period. The selection controls the dates that are available in the date ranges. For example, if monthly returns are calculated, the holdings data is retrieved for calendar month- end dates. Options include:
|
2. Which entities are you interested in? | Specifies the entities on which the calculation is performed. |
3. Specify the date period you want to run the Calculations for. | Defines the holding's begin and end date for the single-period calculation. For portfolios and composites, Eagle Performance retrieves the cash flows for dates greater than the begin date and less than or equal to the end date. If the date range includes multiple periods, Eagle Performance calculates single-period returns for each period. Options include:
|
Use Business Calendar | Specifies whether to use the business calendar to select the begin and end dates of the report for each calculation in the date range. Options include:
|
4. Specify the rules you would like to use for your calculations. | Allows you to select one or more report rules, and optionally override the field rule and/or source rule associated with those report rules. You can select more than one rule to calculate returns for the same portfolio more than one way, for example, by country and by sector. |
5. Specify additional options if you wish. | Lets you specify additional options. Options include:
|
6. What data would you like to use for your calculations? | Lot level holdings are not currently supported. |
7. Would you like to rollup securities at the last level? | Determines whether to rollup securities at the last level. Options include:
|
8. Enable significant cash flow processing? | Determines whether to enable significant cash flow processing. This option is available only if you select a period of Monthly. |
9. Convert constituents and benchmark to composite currency | Allows you to perform on the fly currency conversion for multicurrency composites. Options include:
|
10. Disable DQM processing | Stops the Performance Calculation from running any Data Quality Rules that would normally be processed. This can reduce processing time re-running Performance Calculations when the Data Quality Rules are not required. |
Step 2 Options
Anchor | ||||
---|---|---|---|---|
|
The following table describes each option for Step 2.
Selection | Description |
---|---|
1. Do you want to commit returns on the server side? | Determines whether to commit the returns. Options include:
|
2. Returns will be committed with the entities you chose in the screen. | Calculates returns for one entity, but stores the returns to a different entity. |
3. Would you like to calculate to-date returns? | Determines whether to calculate to-date returns. |
4. What calculated end date returns do you want to commit? | Specifies the end-date returns you want to commit. |
5. Specify additional options if you wish. | Allows you to set several additional options.
|
6. Select Commit Source | Specifies the source that the report uses to commit performance results to the PERFORM database. The default source, Eagle PACE (source instance 4), appears, but you can select a different performance source. A performance source is a source that has a feedback type of Performance. |
Step 3 Options
Anchor | ||||
---|---|---|---|---|
|
The following table describes each option for Step 3.
Selection | Description |
---|---|
1. Would you like to schedule this report? | Determines whether to schedule the report. Options include:
|
2. Specify your report options by clicking on the button below. | Displays the Report Options dialog box, which allows you to identify the number of result levels, customize the report location on the server, place the report in a personal or public folder, publish the report to various groups and users, return or generate the result when submitted, send the result as an email or via Portal, and save the result as a file. |
Eagle Performance displays the Report Options dialog box when you click the Options button. See the following figure.
Two of these options determine whether you can review report results and audit returns after creating the Performance Calculation report. You can review results within the report itself, or can use the Commit Journal to audit returns prior to commitment and track the status of report
The following table describes each option.
Selection | Description |
---|---|
Do not return the Result when submitted. | Determines whether to display the results when you submit the report. Options include:
|
Do not generate the result when submitted. | Note this option is only available when the first option is enabled.
|
Step 4 Options
Anchor | ||||
---|---|---|---|---|
|
The following table describes each option for Step 4.
Selection | Description |
---|---|
1. What name do you want for your report? | Specifies a name for the report. |
2. Type in any comments or remarks you wish. | Allows you to add comments. |
3. Would you like to create Advanced Report components with the current profile. | Determines whether to create an Advanced Report. |
4. Do you want to submit the report now? | Determines whether to submit the report. |