Skip to main content
Skip table of contents

2.2.9 Private Equity Custom Benchmarks

Please note that this endpoint is in beta stage. Endpoint signature and parameters may change.

Purpose

To generate custom benchmarks based on an existing private equity index, with the option to modify the weightage of constituents by constraints. This function returns the computed index level and total returns in timeseries by default.

The computation may take a little longer if complex constraints are supplied, and/or the benchmark is based on an index containing large number of constituents.

Endpoint

POST

/compute-service/v2.1/pe-custom-index/metrics

Parameters

  • externalTicker (string, required):
    Ticker of the index to be used as a base reference. List of tickers can be obtained from 2.2.7 Index / Segment Catalogue.

  • startDate (date, optional):
    Start date of the benchmark. This date must be on or after 2013-06-30.

  • endDate (date, optional):
    End date of the benchmark. This date may not be later than the latest release date.

  • currencyCode (string, optional):
    The reporting currency.
    Supported currencies are: "EUR", "GBP", "LCU", "USD". Default value is "USD" if omitted.

  • constraints (list of EqualityConstraint objects, RangeConstraint objects or Constraint objects, optional):
    Constraints to be submitted. Please refer to the Constraints section below for more information.

  • initialIndexValue (float, optional):
    Initial index pricing level. Default value is 1000.

  • allocations (bool, optional):
    Flag to indicate that the response shall include geography (country and region) and PECCS allocations. Default value is false.

  • riskProfiles (bool, optional):
    Flag to indicate that the response shall include risk profiles. Default value is false.
    Risk profiles include the following metrics:

    • Annualised Total Returns

    • Volatility

    • Maximum Drawdown

    • Sharpe Ratio

    • Value-at-Risk (97.5% and 99.5%)

  • includeConstituents (bool, optional):
    Flag to indicate that the response shall include list of constituents. Default value is false.

Constraints

  • EqualityConstraint (object)
    A constraint that sets a specific goal.

    • criteria (list of ColumnAndValue, required): List of filtering criteria.

    • target (float, required): Desired value for the criteria, represented as a percentage.
      Acceptable values include: 0 to 1, 0.5 represents 50%.

  • RangeConstraint (object)
    A constraint that sets the goal to be within a value range.

    • criteria (list of ColumnAndValue, required): List of filtering criteria.

    • lower (float, required): Lower bound of the target range, represented as a percentage.
      Acceptable values include: 0 to 1, 0.5 represents 50%.

    • upper (float, required): Upper bound of the target range, represented as a percentage.
      Acceptable values include: 0 to 1, 0.5 represents 50%.

  • ColumnAndValue (object)

    • column (string, required): Name of the field.
      Supported values are: "CustomerModel", "Geography", "IndustrialClass", "IndustrialSubclass", "LifecyclePhase", "RevenueModel", "ValueChainType.

    • value (string, required): Value of the field to be filtered.
      Acceptable values differ from column to column:

      • CustomerModel: See 4.5 Customer Model for the complete definitions.
        Acceptable values include "CM01", "CM02".

      • Geography: Country/Region ISO codes. Supported values could be obtained by referencing 2.3.10 private_equity_region_tree .

      • IndustrialClass and IndustrialSubclass: See 4.2 Activity Classification for the complete definitions.
        Acceptable values include "AC01", "AC02".

      • LifecyclePhase: See 4.3 Lifecycle Phases for the complete definitions.
        Acceptable values include "LP01", "LP02".

      • RevenuModel: See 4.4 Revenue Model for the complete definitions.
        Acceptable values include "RM01", "RM02".

      • ValueChainType: See 4.6 Value Chain Types for the complete definitions.
        Acceptable values include "VC01", "VC02".

  • Constraint (object)
    A wrapper for EqualityConstraint and RangeConstraint.

    • criteria (list of EqualityConstraint, RangeConstraint or Constraint, required): List of one or more constraints.

    • type (str, optional): Operation to be applied to the list of criteria.
      Supported values are " & " for AND operation and " | " for OR operation. Default value is " & ".

    • start_date (date, optional): Effective date for the constraint. Default value would be the start date of the benchmark if left omitted.

Example

  • Request

    JSON
    {
        "externalTicker": "PEPBBHCT",
        "startDate": "2013-06-30",
        "constraints": [
            {
                "criteria": [
                    {
                        "criteria": [
                            {
                                "criteria": [
                                    {
                                        "column": "Geography",
                                        "value": "ITA"
                                    }
                                ],
                                "type": " & "
                            },
                                                    {
                                "criteria": [
                                    {
                                        "column": "ActivityClass",
                                        "value": "AC05"
                                    }
                                ],
                                "type": " & "
                            }
                        ],
                        "type": " & ",
                        "target": 1
                    }
                    
                ],
                "type": " & ",
                "startDate": "2013-06-30"
            }
        ],
        "initialIndexValue": 1000,
        "allocations": true,
        "riskProfiles": true,
        "includeConstituents": true
    }
  • Response

    JSON
    {
        "data": {
            "results": [
                {
                    "metrics": [
                        {
                            "values": [
                                {
                                    "valueDate": "2013-06-30",
                                    "value": 1000.0,
                                    "typeId": "T01414",
                                    "reportDate": "2025-06-30",
                                    "unitId": 1,
                                    "currencyId": 991
                                },
    							...
                                {
                                    "valueDate": "2017-10-31",
                                    "value": 0.0007144389629745659,
                                    "typeId": "T02798",
                                    "reportDate": "2025-06-30",
                                    "unitId": 1,
                                    "currencyId": 991
                                },
                                ...
                                {
                                    "valueDate": "2020-03-31",
                                    "value": {
                                        "dom": 5.024620576651193e-05,
                                        "blr": 0.0001507386172995358,
                                        "can": 0.00010049241153302386,
                                        "chl": 0.00010049241153302386,
                                        "pry": 0.0,
                                        "fra": 0.012812782470460513,
                                        "phl": 5.024620576651193e-05,
                                        "est": 0.00025123102883255964,
                                        "gbr": 0.07039493427888412,
                                        "srb": 0.00045221585189860744,
                                        "tto": 0.0,
                                        "ltu": 0.0005527082634316313,
                                        "kwt": 5.024620576651193e-05,
                                        "lbn": 0.0,
                                        "hkg": 0.00020098482306604772,
                                        "omn": 0.0,
                                        "khm": 0.0,
                                        "mex": 0.0012561551441627984,
                                        "fin": 0.002009848230660478,
                                        "pan": 0.00010049241153302386,
                                        "jor": 0.0,
                                        "sen": 0.0,
                                        "bhr": 5.024620576651193e-05,
                                        "esp": 0.012260074207028883,
                                        "bih": 0.0005527082634316313,
                                        "che": 0.0001507386172995358,
                                        "chn": 0.135865740392658,
                                        "aus": 0.011255150091698647,
                                        "bel": 0.004974374370884674,
                                        "nzl": 0.0001507386172995358,
                                        "cze": 0.0017586172018279184,
                                        "vnm": 0.009898502536002829,
                                        "qat": 0.0,
                                        "zaf": 0.00035172344036558354,
                                        "lva": 0.0004019696461320955,
                                        "bgr": 0.0013566475556958224,
                                        "irq": 0.0,
                                        "bhs": 5.024620576651193e-05,
                                        "sau": 0.00035172344036558354,
                                        "mlt": 0.0,
                                        "nld": 0.03075067792910522,
                                        "svn": 0.0001507386172995358,
                                        "rus": 0.021103406421934957,
                                        "per": 5.024620576651193e-05,
                                        "egy": 0.0003014772345990716,
                                        "hun": 0.00291427993445769,
                                        "bmu": 5.024620576651193e-05,
                                        "dnk": 0.005024620576651186,
                                        "mne": 5.024620576651193e-05,
                                        "idn": 0.0,
                                        "pol": 0.006582252955413051,
                                        "arm": 5.024620576651193e-05,
                                        "jpn": 0.043513214193799214,
                                        "are": 0.0001507386172995358,
                                        "nor": 0.0037182192267218787,
                                        "sgp": 0.0,
                                        "kaz": 0.0009546779095637264,
                                        "cyp": 0.0005024620576651194,
                                        "pak": 0.00020098482306604772,
                                        "grc": 0.0008541854980307027,
                                        "mda": 0.0,
                                        "isr": 0.00020098482306604772,
                                        "tur": 0.00020098482306604772,
                                        "bra": 0.009144809449505152,
                                        "cym": 0.00035172344036558354,
                                        "swe": 0.004974374370884674,
                                        "gab": 0.0,
                                        "isl": 0.0012561551441627984,
                                        "rou": 0.002663048905625131,
                                        "alb": 0.00010049241153302386,
                                        "twn": 0.00035172344036558354,
                                        "lka": 0.0,
                                        "lux": 0.0005527082634316313,
                                        "prt": 0.002462064082559084,
                                        "deu": 0.04024721081897595,
                                        "ita": 0.5134157433570962,
                                        "irn": 5.024620576651193e-05,
                                        "col": 0.0009044317037972145,
                                        "mys": 0.0,
                                        "ind": 5.024620576651193e-05,
                                        "kor": 0.016531001697182385,
                                        "mkd": 0.0001507386172995358,
                                        "ecu": 0.0,
                                        "usa": 0.007989146716875381,
                                        "hrv": 0.0005527082634316313,
                                        "geo": 0.0,
                                        "irl": 0.005878806074681886,
                                        "nam": 0.0,
                                        "aut": 0.004421666107453044,
                                        "ukr": 0.002261079259493037,
                                        "kgz": 5.024620576651193e-05,
                                        "lbr": 0.0,
                                        "svk": 0.00035172344036558354,
                                        "lie": 0.0,
                                        "vgb": 0.0
                                    },
                                    "typeId": "T02814",
                                    "reportDate": "2025-06-30",
                                    "unitId": 1,
                                    "currencyId": 991
                                },
                                ...
                                {
                                    "valueDate": "2016-11-30",
                                    "value": {
                                        "eur": 0.7566562877187653,
                                        "afr": 0.0016075554898840401,
                                        "amr": 0.02592183227438015,
                                        "oce": 0.012659499482836841,
                                        "asi": 0.20315482503410692
                                    },
                                    "typeId": "T02813",
                                    "reportDate": "2025-06-30",
                                    "unitId": 1,
                                    "currencyId": 991
                                },
                                ...
                                {
                                    "valueDate": "2016-04-30",
                                    "value": {
                                        "rm02": 0.5976540045378352,
                                        "rm04": 0.21047149908652568,
                                        "rm01": 0.0793443287901591,
                                        "rm03": 0.11253016758548806
                                    },
                                    "typeId": "T02900",
                                    "reportDate": "2025-06-30",
                                    "unitId": 1,
                                    "currencyId": 991
                                },
    							...
                                {
                                    "valueDate": "2015-10-31",
                                    "value": {
                                        "lp01": 0.20298457388102578,
                                        "lp03": 0.5486753864440924,
                                        "lp02": 0.2483400396749081
                                    },
                                    "typeId": "T02901",
                                    "reportDate": "2025-06-30",
                                    "unitId": 1,
                                    "currencyId": 991
                                },
    							...
                                {
                                    "valueDate": "2018-02-28",
                                    "value": {
                                        "cm02": 0.1798192752869231,
                                        "cm01": 0.820180724713151
                                    },
                                    "typeId": "T02902",
                                    "reportDate": "2025-06-30",
                                    "unitId": 1,
                                    "currencyId": 991
                                },
                                ...
                                {
                                    "valueDate": "2015-01-31",
                                    "value": {
                                        "vc03": 0.7020170122784631,
                                        "vc01": 0.020615446251139348,
                                        "vc02": 0.27736754147040255
                                    },
                                    "typeId": "T02903",
                                    "reportDate": "2025-06-30",
                                    "unitId": 1,
                                    "currencyId": 991
                                },
                                ...
                                {
                                    "valueDate": "2020-03-31",
                                    "value": {
                                        "ac07": 0.029494522784942426,
                                        "ac09": 0.012260074207028883,
                                        "ac06": 0.10848155824990531,
                                        "ac05": 0.5547181244971694,
                                        "ac04": 0.019947743689305186,
                                        "ac10": 0.09833182468506853,
                                        "ac03": 0.010802934239800041,
                                        "ac01": 0.008190131539941428,
                                        "ac11": 0.004371419901686532,
                                        "ac02": 0.08210230022248298,
                                        "ac08": 0.07129936598268145
                                    },
                                    "typeId": "T02904",
                                    "reportDate": "2025-06-30",
                                    "unitId": 1,
                                    "currencyId": 991
                                },
                                ...
                                {
                                    "valueDate": "2020-03-31",
                                    "value": {
                                        "ac06012": 0.009044317037972129,
                                        "ac06011": 0.006331021926580492,
                                        "ac02002": 0.0757210320901351,
                                        "ac08005": 0.005828559868915374,
                                        "ac07006": 0.0026128026998586194,
                                        "ac09001": 0.012260074207028883,
                                        "ac08001": 0.0052758516054837445,
                                        "ac11004": 0.0027635413171581548,
                                        "ac03001": 0.01075268803403353,
                                        "ac06010": 0.0009044317037972145,
                                        "ac04002": 0.005828559868915374,
                                        "ac06002": 0.002462064082559084,
                                        "ac06001": 0.013516229351191678,
                                        "ac01002": 0.006381268132347004,
                                        "ac06019": 0.007084715013078169,
                                        "ac07007": 0.013817706585790748,
                                        "ac07008": 0.002964526140224202,
                                        "ac11001": 0.0,
                                        "ac07002": 0.0018591096133609424,
                                        "ac07004": 0.00035172344036558354,
                                        "ac06007": 0.0006029544691981432,
                                        "ac06003": 0.00909456324373864,
                                        "ac04001": 0.0069339763957786335,
                                        "ac08006": 0.014671892083821449,
                                        "ac04005": 0.0016581247902948944,
                                        "ac10001": 0.05316048570096948,
                                        "ac06014": 0.002009848230660478,
                                        "ac08007": 0.027434428348515442,
                                        "ac11002": 0.0008541854980307027,
                                        "ac06008": 0.013064013499293071,
                                        "ac04006": 0.0013566475556958224,
                                        "ac08004": 0.0017586172018279184,
                                        "ac01001": 0.0018088634075944304,
                                        "ac06018": 0.0012059089383962864,
                                        "ac06005": 0.012762536264694,
                                        "ac11005": 0.00020098482306604772,
                                        "ac06009": 0.0008039392922641908,
                                        "ac06017": 0.0013566475556958224,
                                        "ac11003": 0.0005527082634316313,
                                        "ac03002": 5.024620576651193e-05,
                                        "ac08009": 0.0101999797706019,
                                        "ac10002": 0.0451713389840941,
                                        "ac05002": 0.14677224674746697,
                                        "ac05001": 0.39774179598607606,
                                        "ac06015": 0.003215757169056761,
                                        "ac08003": 0.006130037103514445,
                                        "ac06013": 0.006180283309280957,
                                        "ac02001": 0.0023615716710260605,
                                        "ac07001": 0.0008039392922641908,
                                        "ac04003": 0.0021103406421935015,
                                        "ac06016": 0.0026128026998586194,
                                        "ac06020": 0.007436438453443751,
                                        "ac04004": 0.0020600944364269898,
                                        "ac02003": 0.00401969646132095,
                                        "ac06006": 0.008441362568773987,
                                        "ac07003": 0.0011054165268632623,
                                        "ac06004": 0.00035172344036558354,
                                        "ac07005": 0.0059792984862149096,
                                        "ac05003": 0.01020408176362122
                                    },
                                    "typeId": "T02905",
                                    "reportDate": "2025-06-30",
                                    "unitId": 1,
                                    "currencyId": 991
                                },
    							...
                                {
                                    "valueDate": "2023-05-31",
                                    "value": {
                                        "threeYears": 0.06410094849059766,
                                        "fiveYears": 0.10388950705521194,
                                        "tenYears": null
                                    },
                                    "typeId": "T02800",
                                    "reportDate": "2025-06-30",
                                    "unitId": 1,
                                    "currencyId": 991
                                },
                                {
                                    "valueDate": "2023-05-31",
                                    "value": {
                                        "threeYears": 0.18807801773840627,
                                        "fiveYears": 0.16492126903838777,
                                        "tenYears": null
                                    },
                                    "typeId": "T02801",
                                    "reportDate": "2025-06-30",
                                    "unitId": 1,
                                    "currencyId": 991
                                },
                                {
                                    "valueDate": "2023-05-31",
                                    "value": {
                                        "threeYears": 0.33363726919072256,
                                        "fiveYears": 0.6402657770615794,
                                        "tenYears": null
                                    },
                                    "typeId": "T02802",
                                    "reportDate": "2025-06-30",
                                    "unitId": 1,
                                    "currencyId": 991
                                },
                                {
                                    "valueDate": "2023-05-31",
                                    "value": {
                                        "threeYears": 0.29833777293140906,
                                        "fiveYears": 0.21325031352175522,
                                        "tenYears": null
                                    },
                                    "typeId": "T02803",
                                    "reportDate": "2025-06-30",
                                    "unitId": 1,
                                    "currencyId": 991
                                },
                                {
                                    "valueDate": "2023-05-31",
                                    "value": {
                                        "threeYears": 0.4042687721723285,
                                        "fiveYears": 0.30692866261778073,
                                        "tenYears": null
                                    },
                                    "typeId": "T02804",
                                    "reportDate": "2025-06-30",
                                    "unitId": 1,
                                    "currencyId": 991
                                },
                                {
                                    "valueDate": "2023-05-31",
                                    "value": {
                                        "threeYears": 0.1210990457297897,
                                        "fiveYears": 0.1552840383939765,
                                        "tenYears": null
                                    },
                                    "typeId": "T02805",
                                    "reportDate": "2025-06-30",
                                    "unitId": 1,
                                    "currencyId": 991
                                },
                                {
                                    "typeId": "T02931",
                                    "valueDate": "2023-05-31",
                                    "reportDate": "2025-06-30",
                                    "value": [
                                        {
                                            "name": "Company XYZ",
                                            "companyCode": "821881900067869",
                                            "countryCode": "BRA",
                                            "activityClass": "AC08",
                                            "subActivityClass": "AC08007",
                                            "lifeCyclePhase": "LP03",
                                            "customerModel": "CM01",
                                            "revenueModel": "RM02",
                                            "valueChainType": "VC03",
                                            "industrialClass": "Professional and other services",
                                            "industrialSubclass": "Other professional, scientific and technical activities"
                                        },
                                        ...
                                    ]
                                }
                            ],
                            "asOfReportDate": "2025-06-30"
                        }
                    ]
                }
            ]
        },
        "metadata": {
            "datumCount": 1206
        }
    }

JavaScript errors detected

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

If this problem persists, please contact our support.