The Calculate Monthly 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:
- In Accounting Center, in the left navigation pane, click Fund Accounting > Valuation > Month End Valuations > Calculate Monthly Averages.
You see the Calculate Monthly Averages panel. - Complete the options on the Calculate Monthly Averages panel.
- Click Submit.
Calculate Monthly Averages Panel Options
The following table describes each option on the Calculate Monthly Averages panel.
Option | Tag | Description |
---|---|---|
Entity ID | 1163 | Specifies a portfolio, sector portfolio, composite portfolio, or Master Fund by the entity ID of the entity. |
Turnover Exclude Group Name | 7010 | Specifies the group name for the set of portfolio turnover exclude rules to use to exclude transactions from processing. The system uses the group of portfolio turnover exclude rules that you specify for the Calculate Monthly Averages panel. If you do not specify a group name, the system uses the portfolio turnover Group Name defined at the entity level to exclude transactions for the selected entity. If you do not specify an entity-level group, the system uses portfolio turnover exclude rules that are not assigned to a group. |
Value Short Positions | 7009 | Indicates whether to value short positions as negative. Options include Negative (Default) or Positive. |
Effective Date | 1109 | Specifies the effective date for your report results. The default is today's date. |
Report Type | 1257 | Specifies the type of date for controlling your report results. This option matches the value that you select as the Date Type (tag 1257) option on the STAR to PACE Direct Processing panel, Transfer Data - Batch. Options include:
|
Show/Hide Cash | 7002 | Indicates whether to include or exclude cash transactions in your report results. Options include Hide Cash (Default) or Show Cash. |
Add Comment