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 Processes area allows you to transfer holdings and transactions from Eagle Accounting to the Eagle data warehouse by accounting date or month end accounting date. For general information about this process, see Transfer Data Using the S2P Batch Mode.
To copy holdings and transactions to the Eagle data warehouse
...
:
...
...
In Accounting Center, in the left navigation pane, click Processing and Exceptions > Global Processes > STAR to PACE Direct Processing > Transfer Data - Batch.
You see the Transfer Data - Batch panel.Click the Date Type list 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.Click the Position Valuation Election list and select Valuation Price.
Complete the remaining options on the Transfer Data - Batch panel.
For example, you can specify entity and security filters to restrict the scope of processing.Click Submit.
...
NOTE: 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
...
Create 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:
- In Accounting Center, in the left navigation pane, click Reports > Compliance Reports > Portfolio Turnover > Create Portfolio Turnover Exclude Rules.
You see the Create Portfolio Turnover Exclude Rules panel. - Click the Group Name box and select the name of the group.
You must use a value already stored on the Code Values table under code category, PTGROUP. - Complete the options on the Create Portfolio Turnover Exclude Rules panel.
- Click Submit to add the exclude rule.
- Repeat for each exclude rule you want to add to the group.
Create Portfolio Turnover Exclude Rules Panel Options
A definition of the options on the Create Portfolio Turnover Exclude Rules panel follows.
...
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 Codes workspace.
...
- Process Security Type (Default)
- Security Type
- Message Type
- Broker
- Primary Asset ID
...
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 defines the option on the Create/Edit Entity panel and the Create Master Fund panel that assigns a group of exclude rules to an entity.
Group name (tag 5336). 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 code values using the Codes workspace 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. If you do not specify a group name, the system uses portfolio turnover exclude rules that are not assigned to a group.
Calculate Monthly Market Value Averages
...
.
...
To calculate monthly market value averages:
...
...
Calculate Monthly Averages Panel Options
The following table describes each option on the Calculate Monthly Averages panel.
...