Skip to main content
Skip table of contents

1.2.7 PRIVATEMETRICS.INDICES_CATALOGUE

INDICES_CATALOGUE(product, app)

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

 

If you're new to using Excel custom functions, don't worry! You can easily use our intuitive task pane UI instead.

 

It accepts 2 parameters, a product, and an app.

image-20240925-063801.png

Example of INDICES_CATALOGUE custom function

Parameters

PRODUCT: Text

Product is either “Private Infra” or “Private Equity” (as well as “PI” or “PE”).

APP: Text

Available apps: “Indices”, “Benchmarks”, or “Climate”.

Returns

A table of index records.

image-20240925-062515.png

Indices catalogue query result shown in the active spreadsheet

Examples

Query the list of Private Infrastructure indices available in Market Indices app.

CODE
=PRIVATEMETRICS.INDICES_CATALOGUE("PI", "Indices")

 

Query the list of Private Equity indices available in Market Indices app.

CODE
=PRIVATEMETRICS.INDICES_CATALOGUE("pe", "Indices")

 

Query the list of Private Equity indices available in Benchmark app.

CODE
=PRIVATEMETRICS.TAXONOMIES("Private Equity","benchmark")

 

 

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.

taxf4.png

 

JavaScript errors detected

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

If this problem persists, please contact our support.