Skip to main content
Skip table of contents

1.9.1 Custom Indices Table Template

This feature is designed to provide users with access to view the Index Levels and Total Returns associated with a PECCS® Index.

To generate these

  • users can navigate to the Ribbon Bar and select the Custom Indices menu item.

Fig 1. Custom Indices menu Item on PrivateMetrics Ribbon Bar

  • Upon clicking, a new sheet is created and named "Custom Indices - {a number representing the current time in milliseconds since January 1, 1970}".

  • In the newly created sheet, a table template is provided where users can input the required PECCS Ticker (mandatory) along with optional values such as Start Date, End Date, and Currency to generate the Index Levels.

    • Start Date and End Date must be valid dates.

    • The Start Date cannot be later than the End Date.

    • Supported currencies are limited to USD, EUR, GBP, and LCL.

  • On the right side of the table template, a list of supported Geographies for PECCS and the corresponding PECCS Taxonomies is also displayed.

    Fig 2. Table Template and PECCS Taxonomies and Geographies

  • To Generate the Index Levels

    1. The user must provide a PECCS Ticker as a mandatory input. (Refer to the provided documentation for a comprehensive list of available tickers.)

    2. Optionally, the user can also provide the following inputs:

      • A Start Date

      • An End Date

      • A Currency Code

    3. The user can input PECCS Values to define the criteria for generating the Index Levels. These values can be grouped to represent either an AND or OR combination, as outlined below:

      1. Specifying OR Values:

        1. Input multiple PECCS Values separated by commas within a single cell under the PECCS Value column.

      2. Specifying AND Values:

        1. Input each PECCS Value in separate rows under the PECCS Value column.

      3. Equality or Range Conditions:

        1. Each row must specify either an Equality Value or a Lower Bound and Upper Bound condition.

        2. For Equality, the ratio should be entered in the Equality column.

        3. For Lower Bound and Upper Bound, the ratios must be provided in the Lower Bound and Upper Bound columns.

    Note:

  • Users cannot specify both Equality Values and Lower/Upper Bound Values in the same row. Only one condition type is supported per row.

Fig 3. Sample Table to generate Custom Indices

  • Once the user has specified all the required values, they can proceed to generate the Index Levels using the Custom Indices custom function. Please refer to this section on how to use the custom function.

JavaScript errors detected

Please note, these errors can depend on your browser setup.

If this problem persists, please contact our support.