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 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.
The Creating a Performance Calculation Report - Step 1 of 4 dialog box appears. See the following figure.
Creating the Performance Calculation Report - Step 1 of 4 Dialog Box
- Complete the options for Step 1 and click Next.
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:
- 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:
- Selected (Check mark).Default. If you set the Date Period to Date Range (Date Rule), Eagle Performance uses the selected date rule and that date rule's business calendar, if defined, to select the begin and end date of the date range. Eagle Performance then uses the entity level business calendar of the portfolio or composite, if one is defined, to select the end effective dates within that range to run the calculation. If none is defined, it uses the Eagle PACE business calendar.
If you set the Date Period to Date Range, Eagle Performance uses the entity level business calendar of the portfolio or composite, if defined, to select the begin and end dates of the report for each calculation in the date range. Otherwise, it uses the Eagle PACE business calendar. If the report includes multiple entities that use entity level business calendars, those entities must share the same entity level business calendar.
- Cleared (No check mark). The business calendar is not used.
For more information about setting up business calendars, see the "Performing Business Calendar Checks" section of the Performance Analysis and Reporting User Guide.
|
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:
- Selected (Check mark). If you run the report for a composite where constituents or benchmarks have different base currencies than the composite, the report converts constituent cash flows and market values as well as Performance Analysis benchmark returns to the composite currency for that effective date. The report retrieves the base currencies of the constituents and composites, along with the relevant exchange rates from the effective date, and uses those converted values in the calculation of the base returns. The report also retrieves the base currency of the benchmarks and converts Benchmark Performance Analysis return fields to the composite currency.
Otherwise, if you select this option and run the report for a profile portfolio rather than a composite, the report does not check holdings and cash, but does convert the benchmark returns to the currency of the profile portfolio.
- Cleared (No check mark). Default. The report does not perform on the fly currency conversion for multicurrency composites.
For more information, see "Setting Up the Performance Calculation Report for Multicurrency Conversion."
|
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. |
After clicking Next, the Creating a Performance Calculation Report - Step 2 of 4 dialog box appears. See the following figure.
Creating the Performance Calculation Report - Step 2 of 4 Dialog Box
- 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:
- Do not update Business Calendar. If you select this check box, the Eagle PACE business calendar is automatically updated. If cleared, the Eagle PACE business calendar is not automatically updated.
You can either select options to assign a Preliminary status to committed returns or to assign a Final status to committed returns.
The Commit Returns as options determine how a Performance status is assigned to committed returns. Options include:
- Preliminary. Automatically calculates and stores returns, but you control reporting of numbers before they are finalized by configuring certain reports to only show preliminary figures.
- Final. Automatically commits all the returns as final.
- Out-of-tolerance preliminary (Commit Tolerance Field). Commits returns as final, unless they fail a tolerance check that uses a Commit Tolerance field. These portfolio/dates are committed in a preliminary status. For more information about tolerance checks, see "Using Tolerance Checks and Reference Fields."
- Material Difference Check (using Materiality Check Field). Commits first time returns as preliminary. If returns were previously committed for that entity/effective date/source/frequency/performance model, Eagle overwrites only those returns that are materially different from the prior returns. If there is no material difference between the returns, Eagle does not overwrite prior returns for that entity but commits the new returns to the alternate commit source. If there is a material difference from a prior return that has a Preliminary status, Eagle overwrites the prior return. If there is a material difference from a prior return that has a Final status, Eagle commits the new Preliminary return to the alternate commit source and does not overwrite the prior return.
The system identifies material differences using the Materiality Check field in the report's Field Rule or Report Rule. For more information, see "Using Tolerance Checks and Reference Fields."
- Select Alternate Commit Source. This field appears only if you select the Only when materially different option. It specifies the alternate performance source used to commit returns that have a non-material difference and to commit returns with a material difference when the prior returns have a Final status. Choose a source that differs from the source specified in the Select Commit Source field.
In the Security Commit Options area, you determine the level at which to store committed returns. Options include:
- None. Limits the returns stored to the total and segment levels.
- Rollup Relations with Security Level. Stores returns at both the total portfolio/segment and security levels.
- Rollup Relations Only. Stores returns at both the total portfolio/segment and security relationship only level.
|
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. |
After clicking Next, the Creating a Performance Calculation Report - Step 3 of 4 dialog box appears. See the following figure.
Creating the Performance Calculation Report - Step 3 of 4 Dialog Box
- 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:
- Yes. Schedules the report daily, weekly, monthly, or by the specified minutes. You also have the option of using the business calendar with the source, scheduling the time, and indicating whether the schedule should depend on other events.
- No. Does not schedule the report.
|
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.
Report Options Dialog Box
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 returns. 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:
- Selected. Results are not viewable in general reporting, but Eagle Performance creates an XML file. You can view results in the Commit Journal.
- Cleared (Default). Results are viewable in general reporting.
|
Do not generate the result when submitted. |
Note this option is only available when the first option is enabled.
Determines whether to generate the result when you submit the report. Options include:
- Selected. Eagle Performance does not create an XML file. You cannot view results in the Commit Journal.
- Cleared (Default). Eagle Performance creates an XML file.
|
After clicking Next, the Creating a Performance Calculation Report - Step 4 of 4 dialog box appears. See the following figure.
Creating the Performance Calculation Report - Step 4 of 4 Dialog Box
- 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. |
0 Comments