Configure Dynamic Mutual Fund Performance Fields

Owned by Kavitha Thangaswamy (Unlicensed)
Last updated: Oct 30, 2023 by Pamela Totas (Deactivated)
3 min read

After the underlying codes are set for each of the distribution types you can configure dynamic mutual fund performance fields.

Existing Fields

You may have numerous dynamic mutual fund fields already in production. Upgrading to version 7.2 (or later) does not affect these fields. Existing fields remain unchanged. However, you can enable audit logging for any existing dynamic return field without effecting the return calculation:

  1. From the field selector or field rule interface, highlight the dynamic mutual fund field.

  2. Right-click and choose edit.
    The field category is set to Performance and the effect is set to Total Return.

  3. Click the category box and choose Audit Daily from the drop down list.
    This setting instructs Eagle Performance to perform the audit logging function whenever a report (containing this field) is executed.
    NOTE: An existing field might be included in numerous reports that are run on a frequent or ad hoc basis. Since the logging of the time series data is a more specialized application, best practices dictate that new fields be used. Once a field is enabled, it writes out data each time a report is run. This can have the effect of making the report run longer (depending on the amount of funds and Audit Daily fields in the report.

New Fields

Once you have determined the return type and frequency that needs to be audited, you can create a new dynamic field as required. Be sure to set the category to Audit Daily. Once this field is included in a report, it writes information to the audit tables.

Best practices include establishing a naming convention to properly segregate audit fields. For example, a) Audit 12 Month No Load b) Audit 12 Month Load Adj.

Performance Analysis Reports

To use this function you must run a Performance Analysis report with the Audit Daily dynamic fields you have configured. Once you have determined your auditing needs, create Performance Analysis reports to suit your particular needs. Eagle suggests creating separate reports so that auditing can be scheduled separately from existing production reports.

Audit Tables

At this time the audit tables are not accessible via OLAP reports or the query tool. Advanced reports may be used to execute the underlying performance analysis report (that triggers the logging) and then display the data and dates required. If you want to schedule assistance, contact your client executive.

Scheduling Reports

When logging numerous funds and/or fields simultaneously it is suggested that an overnight workflow be considered. See A Note On Volumes for more information.

Ad Hoc Analysis

Audit logging supports ad hoc analysis for any day to day period. Here are some general guidelines for doing this:

  1. Set up a rule with a dynamic performance field that has the category Audit Daily enabled.

  2. For the period option on the dynamic field, choose the second option that allows you to specify a hard coded begin and end date (set these to any date, because Eagle overrides them anyway).

  3. Set up a performance analysis report and set the report rule.

  4. For the date option in the report, click the blue link and choose Link Period Override.

  5. When you submit the report it allows you to choose any begin and end date. These dates are inherited by any dynamic field set to use specific dates.

  6. Since the field has auditing enabled, it uses the dates specified in the profile as the performance period.
    Note: The dynamic calculations always look to the end of the prior day for a starting NAV. Therefore you do not have to make this adjustment when choosing dates for the report. For example, if you want a 1 year audit as of 12/31/05 you would choose 1/1/05 as the begin date and 12/31/05 as the end date. PACE automatically goes back one day to 12/31/04 to get the NAV to foot the calculation.