Set Up Portfolio Turnover Reports

You must set up the Portfolio Turnover rules and establish the Eagle data warehouse information before you can submit the monthly Portfolio Turnover reports. As part of your monthly cycle, you must transfer the Eagle Accounting holdings and transactions to the Eagle data warehouse and then calculate monthly market value averages for accounting date, month end date, or both.

You can also define a group of Portfolio Turnover exclude rules to filter the information used by the reports and market value calculations and link the group to specific portfolio and master fund entities.

Transfer Holdings and Transactions to the Eagle Data Warehouse

The Transfer Data – Batch panel in the Global Process Center allows you to transfer holdings and transactions from Eagle Accounting to the Eagle data warehouse by accounting date or month end accounting date.

To copy holdings and transactions to the Eagle data warehouse:

Content on this page:

  1. From any Eagle window, click the Eagle Navigator button to access the Eagle Navigator.
  2. Enter global process center in the Start Search text box. To clear the information you entered, click X to the right of the text box.
    As you type, the Eagle Navigator uses type-ahead to show you all centers and components that match the text you entered.
  3. Click the Global Process Center link.
    You see the Global Process Center main window.
  4. Double click Eagle STAR to Eagle PACE Direct Processing and Transfer Data – Batch in the left pane.
    You see the Transfer Data – Batch panel.
  5. Click the Date Type drop down and select the type of date for the data transfer. Options include:
    –  Accounting Date. Select this option to calculate market values by accounting date.
    –  Month End Accounting Date. Select this option to calculate market values by month end date.
  6. Click the Position Valuation Election drop down and select Valuation Price.
  7. Complete the remaining fields on the Transfer Data - Batch panel. For example, you can specify entity and security filters to restrict the scope of processing.
  8. Click Submit.

    When calculating market value monthly averages for both date types, you must submit the panel twice, that is, you must transfer holdings and transactions for each Date Type selection.

Add Portfolio Turnover Exclude Rules

Portfolio Turnover exclude rules allow you to filter the Eagle data warehouse holdings and transactions used for Portfolio Turnover reporting, including the calculation of monthly market value averages. You can set up a group of exclude rules in Eagle Accounting and then set the portfolio entity or the master fund entity to reference this group.

To set up a group of Portfolio Turnover exclude rules:

  1. From any Eagle window, click the Eagle Navigator button to access the Eagle Navigator.
  2. Enter portfolio turnover in the Start Search text box. To clear the information you entered, click X to the right of the text box.
    As you type, the Eagle Navigator uses type-ahead to show you all centers and components that match the text you entered.
  3. Click the Add Portfolio Turnover Exclude Rules link.
    You see the Add Portfolio Turnover Exclude Rules panel.
  4. Click the Group Name drop down and select the name of the group.
    You must use a value already stored on the Code Values table under code category PTGROUP.
  5. Complete the fields on the Add Portfolio Turnover Exclude Rules panel.
  6. Click Submit to add the exclude rule.
  7. Repeat steps 4 – 6 for each exclude rule you want to add to the group.

Add Portfolio Turnover Exclude Rules Panel Options

A definition of the options on the Add Portfolio Turnover Exclude Rules panel follows.

Add Portfolio Turnover Exclude Rules

  • Group Name. Specifies the group for this exclude rule. You must use a value listed in the Code Values table under code category PTGROUP.
    NOTE: You can add additional values for code category PTGROUP and source Eagle PACE using the Add Code Values panel.
  • Turnover Exclude Type. Specifies the filter type to use for excluding records.
    Options include:
    –  Process Security Type (Default)
    –  Security Type
    –  Message Type
    –  Broker
    –  Primary Asset ID
  • Turnover Exclude Subtype. Specifies the filter subtype to use for excluding records. To use this option, you must select Security Type or Message Type as your turnover exclusion type. For example, you can filter messages by several subtypes, including MTOPEN, MTADJUST, MTACTION, and MTCLOSE.
  • Turnover Exclude Type Value. Specifies the value for the filter type and subtype combination. To use this option, you must select Process Security Type or Primary Asset ID as your turnover exclusion type. For example, you can exclude the BUY sub message type for MTOPEN message type records.
  • Broker Name. Specifies the broker name to use for excluding records. To use this option, you must select Broker as your turnover exclusion type.
  • Broker Code. Specifies the broker code to use for excluding records. Specifies the broker name to use for excluding records. To use this option, you must select Broker as your turnover exclusion type.
  • Exclude from Market Value. Indicates whether to filter report results for the Portfolio Turnover Summary, Monthly Market Value, and Market Value Detail reports. Default is Yes.
  • Exclude from Trade. Indicates whether to filter report results for the Portfolio Turnover Trade Detail report. Default is Yes.
  • Report End Date. Specifies the ending date for your report results.

Assign Portfolio Turnover Exclude Rules to an Entity

You can assign the group of Portfolio Turnover exclude rules to your portfolio entity and master fund entity for Portfolio Turnover reporting. The following table defines the option on the Add Entity and the Master Fund Setup panels that assigns a group of exclude rules to an entity.

Portfolio Turnover

  • Group name. Specifies the group name of the Portfolio Turnover reporting rules used to exclude transactions from the Portfolio Turnover reports for the entity. You can add additional values using the Add Code Values panel for the PTGROUP code category under the source Eagle PACE, and then use the Portfolio Turnover Exclude Rules panels to manage the transactions to exclude for this group.

    When the group name is not specified, the exclude rules that are not assigned to any group are used.

Calculate Monthly Market Value Averages

The Calculate Monthly Market Averages panel allows you to compute the market value averages to use in monthly Portfolio Turnover reporting. You can perform this task only after the holdings and transactions have transferred from Eagle Accounting to the Eagle data warehouse using STAR to PACE Direct global processing. The portfolio turnover exclude rules filter the transactions used for the calculations.

To calculate monthly market value averages:

  1. From any Eagle window, click the Eagle Navigator button to access the Eagle Navigator.
  2. Enter monthly market value in the Start Search text box. To clear the information you entered, click X to the right of the text box.
    As you type, the Eagle Navigator uses type-ahead to show you all centers and components that match the text you entered.
  3. Click the Calculate Monthly Market Value Averages link.
    You see the Calculate Monthly Market Averages panel.
  4. Complete the fields on the Calculate Monthly Market Averages panel.
  5. Click Submit.

Calculate Monthly Market Averages Panel Options

The following table describes each option on the Calculate Monthly Market Averages panel.

  • Entity ID. Specifies a portfolio, sector portfolio, composite portfolio, or Master Fund by the entity ID of the entity.
  • Effective Date. Specifies the effective date for your report results. The default is today's date.
  • Report Type. Specifies the type of date for controlling your report results.
    Options include:
    –  Accounting Date (Default)
    –  Month End Accounting Date     

    This option matches the value that select as the Date Type (tag 1257) option on the S2P Transfer Data - Batch panel.