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.
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.
Examples
Query the list of Private Infrastructure indices available in Market Indices app.
=PRIVATEMETRICS.INDICES_CATALOGUE("PI", "Indices")
Query the list of Private Equity indices available in Market Indices app.
=PRIVATEMETRICS.INDICES_CATALOGUE("pe", "Indices")
Query the list of Private Equity indices available in Benchmark app.
=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.