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 is1000
.allocations (bool, optional):
Flag to indicate that the response shall include geography (country and region) and PECCS allocations. Default value isfalse
.riskProfiles (bool, optional):
Flag to indicate that the response shall include risk profiles. Default value isfalse
.
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 isfalse
.
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 } }