About the Performance Query Tool

Owned by Pamela Totas (Deactivated), created
Last updated: Apr 08, 2024 by Kinga Huszno
3 min read

The Performance Query Tool allows middle-office personnel to easily query and analyze basic performance data. It presents query results in a spreadsheet format. With the Performance Query Tool you can:

  • Allow performance analysts with a minimal knowledge of Eagle’s performance data to easily submit queries set up by an administrator and modify the data set to derive additional data.

  • Display results quickly and with a minimum number of clicks and windows to navigate.

  • Create a rolling series and perform time series analysis on economic and market indices. For example, in a case where you do not store a quarterly series in Eagle Performance, you can use the Query Tool to produce a series of monthly returns and dynamically derive a quarterly return series.

  • Use information provided by the Performance Query Tool as the basis for Advanced Reports, and also make that information available in Eagle’s Portal views.

  • Analyze performance data associated with portfolios, retail funds, and GIPS composites.

Configure the Performance Query Tool

An administrator or report developer can use the Query Tool wizard to create performance query report profiles and define default report parameters for each report profile. You can set up, secure, and administer multiple queries applicable to different business units, and can grant individuals or business groups customized access to queries according to their requirements.

The Performance Query Tool extracts data from the PERFORM database using Performance Analysis fields created with the Effect of Return. It supports all the options available in the Performance Analysis fields, such as Frequency, Preliminary/Final status, Use Fund Inception date, and so on. In addition, the Query Tool supports both percentage returns and unit values.

In many cases, the Performance Analysis fields that point to underlying PERFORM database fields that you use in queries are already available for use in existing Performance Analysis reports. Otherwise, you can create those field attributes for use in performance queries.

Submit Queries and Work with Query Results

After query report profiles are available, performance analysts can select query report profiles, choose the report parameter values, and submit queries for processing. Eagle Performance displays a spreadsheet with the query results.

Performance analysts can use statistical operations to manipulate the query results to derive new data, using:

  • Series derivation operations to perform a statistical operation across the results of two columns to create a third column.

  • Rolling operations to apply a statistical operation to a single time series at fixed intervals to create a new time series. A time series is a set of data collected sequentially, usually at fixed intervals of time. For example, the total return of a fund for 12 calendar months.

Rolling operations are the same operations as Series Derivation, but applied to a single time series of data at specified intervals. For example, given the 12 monthly returns, calculate quarterly returns by geometrically linking every 3 returns or calculate an annual return by linking all 12.

For examples of queries that use statistical operations, see “About Performance Queries.”

You can distribute Performance Query Tool results by sending reports directly to a printer or saving reports as a .CSV file that opens in Excel. You can also use the information provided by the Performance Query Tool as the basis for presentation quality Advanced Reports, and can make that information available in Eagle’s Portal views.

Use the Performance Toolkit

The Performance Toolkit is a collection of prebuilt components and a documented workflow for use in new installations of Eagle Performance. It is available on your Eagle Applications Installation DVD on the navigation path for 2017 under the following directory:

MODULES\PACE\PERFORMANCE_TOOLKIT_2.0\

The Performance Toolkit includes Query Tool views for daily and monthly frequency performance as part of the Calculation Toolkit. It also provides Query Tool views for trend reporting of daily and monthly performance statistics and for quarterly returns as part of the Retail Fund Toolkit.

For more information, see the Performance Toolkit Implementation.