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.
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.
To Generate the Index Levels
The user must provide a PECCS Ticker as a mandatory input. (Refer to the provided documentation for a comprehensive list of available tickers.)
Optionally, the user can also provide the following inputs:
A Start Date
An End Date
A Currency Code
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:
Specifying OR Values:
Input multiple PECCS Values separated by commas within a single cell under the PECCS Value column.
Specifying AND Values:
Input each PECCS Value in separate rows under the PECCS Value column.
Equality or Range Conditions:
Each row must specify either an Equality Value or a Lower Bound and Upper Bound condition.
For Equality, the ratio should be entered in the Equality column.
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.
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.