Skip to main content
Skip table of contents

1.2.8 PRIVATEMETRICS.TAXONOMIES

TAXONOMIES(taxonomy, pillar)

You can see the taxonomy of our TICCS®, PECCS®, and TICCS®+ classification using TAXONOMIES function, as well as the mapping between TICCS® and PECCS® taxonomy into NACE taxonomy or EU taxonomy.

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 taxonomy, and a pillar as an optional parameter.

taxf1.png

Parameters

TAXONOMY: Text

Choose between these options: "TICCS", "PECCS", "TICCS+", "TICCS-NACE", or "PECCS-NACE".

PILLAR: Text (Optional)

Available only if the taxonomy is either "TICCS", "PECCS", or "TICCS+".
Select a specific pillar to be displayed. If no pillar is specified, displays the entire taxonomy.
The available pillars are:

Taxonomy

Pillar

“TICCS”

"Business Risk"

"Geo Economic Exposure"

"Industrial Activity"

"Corporate Structure"

“PECCS”

"Activity Class"

"Life Cycle Phase"

"Revenue Model"

"Customer Model"

"Value Chain"

“TICCS+”

“Environment”

“Social”

“Governance”

“TICCS-NACE”

N/A

“TICCS-EU”

N/A

Returns

A table of taxonomy or mapping.

taxf2.png

Example of TICCS® taxonomy

taxf3.png

Example of TICCS® taxonomy mapping to NACE taxonomy

Examples

Query the entire TICCS® taxonomy:

CODE
=PRIVATEMETRICS.TAXONOMIES("TICCS")

Query only the Industrial Activity pillar from TICCS® taxonomy:

CODE
=PRIVATEMETRICS.TAXONOMIES("TICCS","Industrial Activity")

Query only the Activity Class pillar from PECCS® taxonomy:

CODE
=PRIVATEMETRICS.TAXONOMIES("PECCS","Activity Class")

Query the mapping between TICCS® and NACE taxonomy:

CODE
=PRIVATEMETRICS.TAXONOMIES("TICCS-NACE")

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.