Skip to main content
Skip table of contents

1.7.1 Indices Catalogue task pane

Access to view all available indices, as well as their categories and Index ids used for other query functions.

 

Open the PrivateMetrics tab, and click Indices Catalogue

image-20240925-053445.png

Select Indices Catalogue ribbon button

image-20240925-053539.png

The task pane will be displayed on the right side of Excel

Select one of our product:

infraMetricsĀ® indices catalogue - Catalogue of available indices for private infrastructure equity and debt.

privateMetricsĀ® indices catalogue - Catalogue of available indices for private equity.

After selecting the product, you will see this layout.

image-20240925-060730.png

Initial layout of Indices Catalogue pane

Select 1 of the app. Choose Market Indices if you want to see indices available for Market Indices query, etc.

image-20240925-061045.png

Choose an app

image-20240925-061222.png

Once a product is chosen, click on Query button

Click on Query button to execute the function. This will build the custom function into your current active cell in your excel sheet, and will display the table.

image-20240925-061503.png

Indices catalogue query result shown in the active spreadsheet

 

Note that the table will only show if it has enough space to display the data on the sheet. Otherwise it will show #SPILL! error. The blue border indicates how much space required to show the data. Clear the entire cell within the blue border to see the data.

tax8.png

 

JavaScript errors detected

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

If this problem persists, please contact our support.