Calculate Monthly Averages

Owned by Nancy Cohn (Deactivated)
Last updated: Oct 03, 2023
2 min read

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:

  1. 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.

  2. Complete the options on the Calculate Monthly Averages panel.

  3. Click Submit.

Calculate Monthly Averages Panel Options

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

Option

Tag

Description

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:

  • Accounting Date (Default)

  • Month End Accounting Date

Show/Hide Cash

7002

Indicates whether to include or exclude cash transactions in your report results. Options include Hide Cash (Default) or Show Cash.

Â