| key |
id |
string(500)* |
= |
The id field uniquely identifies the entity record. |
| timeline |
asOfDate |
date |
=< >= |
The ending date for the calculation. |
| link |
batch |
Batch* |
= |
The Batch for which this BatchRun is an instance. |
| link |
batchRun |
BatchRun* |
= |
The BatchRun in which the data is calculated. |
| filter_list |
benchmarkId |
string(100)* |
= |
Unique index identifier. |
| link |
benchmarkMapping |
BenchmarkMapping* |
|
Link to the Benchmark mapping. |
|
capitalizationGp |
string |
|
The total amount of capital committed from G.P.s across all funds. |
|
capitalizationLp |
string |
|
The total amount of capital committed from L.P.s across all funds. |
| filter_list |
currency |
string(3) |
= |
Currency used to calculate the index. |
|
dataModeType |
string(50) |
|
Denotes if the index performance is Preliminary or Published. |
|
dpi5Percentile |
string |
|
Distributed to Paid-In ratio of the lowest-performing 5% of funds from the upper 95%. |
|
dpi95Percentile |
string |
|
Distributed to Paid-In ratio of the highest-performing 5% of funds from the lower 95%. |
|
dpiAverageLp |
string |
|
Distributed to Paid-In ratio of arithmetic average of individual performance metrics. |
|
dpiMedianLp |
string |
|
Distributed to Paid-In ratio of the highest-performing 50% of funds from the lower 50%. |
|
dpiPooledLp |
string |
|
Distributed to Paid-In ratio of pooling cash flows and NAVs. |
|
dpiQuartileLowerLp |
string |
|
Distributed to Paid-In ratio of the lowest-performing 25% of funds from the upper 75%. |
|
dpiQuartileUpperLp |
string |
|
Distributed to Paid-In ratio of the highest-performing 25% of funds from the lower 75%. |
|
dpiStandardDeviationLp |
string |
|
Standard deviation of the Distributed to Paid-In ratio metrics. |
|
firstTransaction |
string(10) |
|
The quarter during which the first cash flow occurred. |
|
fundCount |
long |
|
The total number of funds in the benchmark sample. |
|
irr5Percentile |
string |
|
Breakpoint return separating the lowest-performing 5% of funds from the upper 95%. |
|
irr95Percentile |
string |
|
Breakpoint return separating the highest-performing 5% of funds from the lower 95%. |
|
irrAverage |
string |
|
Arithmetic average of individual performance metrics. Individual IRRs over 1,000% are excluded from the calculation. |
|
irrEqualWeighted |
string |
|
IRR of the sum of all cash flows, with each fund's cash flows equally weighted by committed capital (i.e. equivalent of $1 capital committed for each fund). This calculation is only provided for the IRR return metric. |
|
irrMedian |
string |
|
Breakpoint return separating the highest-performing 50% of funds in a selected sample from the lower 50%. |
|
irrPooled |
string |
|
Aggregate performance metric that is measured after combining (pooling) cash flows and NAVs. |
|
irrQuartileLower |
string |
|
Breakpoint return separating the lowest-performing 25% of funds from the upper 75%. |
|
irrQuartileUpper |
string |
|
Breakpoint return separating the highest-performing 25% of funds from the lower 75%. |
|
percentUpdated |
string |
|
The percent of active funds updated, as a percentage of the prior quarter's NAV. |
| filter_list |
performanceQuarter |
string(10) |
= |
Index captures the performance during this year and quarter. |
|
reportType |
string(50) |
|
Denotes the report type. |
|
runDate |
date |
|
Date at which the data is sent by Cambridge. |
|
rvpi5Percentile |
string |
|
Residual Value to Paid-In ratio of the lowest-performing 5% of funds from the upper 95%. |
|
rvpi95Percentile |
string |
|
Residual Value to Paid-In ratio of the highest-performing 5% of funds from the lower 95%. |
|
rvpiAverageLp |
string |
|
Residual Value to Paid-In ratio of arithmetic average of individual performance metrics. |
|
rvpiMedianLp |
string |
|
Residual Value to Paid-In ratio of the highest-performing 50% from the lower 50%. |
|
rvpiPooledLp |
string |
|
Residual Value to Paid-In ratio of pooling cash flows and NAVs. |
|
rvpiQuartileLowerLp |
string |
|
Residual Value to Paid-In ratio of the lowest-performing 25% of funds from the upper 75%. |
|
rvpiQuartileUpperLp |
string |
|
Residual Value to Paid-In ratio of the highest-performing 25% of funds from the lower 75%. |
|
rvpiStandardDeviationLp |
string |
|
Standard deviation of the Residual Value to Paid-In ratio metrics. |
|
standardDeviation |
string |
|
Standard deviation of the individual return metrics. Individual IRRs over 1,000% are excluded from the calculation. |
|
totalCapitalization |
string |
|
The total amount of capital committed from L.P.s and G.P.s across all funds. |
|
tvpi5Percentile |
string |
|
Total Value to Paid-In ratio of the lowest-performing 5% of funds from the upper 95%. |
|
tvpi95Percentile |
string |
|
Total Value to Paid-In ratio of the highest-performing 5% of funds from the lower 95%. |
|
tvpiAverageLp |
string |
|
Total Value to Paid-In ratio of arithmetic average of individual performance metrics. |
|
tvpiMedianLp |
string |
|
Total Value to Paid-In ratio of the highest-performing 50% of funds from the lower 50%. |
|
tvpiPooledLp |
string |
|
Total Value to Paid-In ratio of pooling cash flows and NAVs. |
|
tvpiQuartileLowerLp |
string |
|
Total Value to Paid-In ratio of the lowest-performing 25% of funds from the upper 75%. |
|
tvpiQuartileUpperLp |
string |
|
Total Value to Paid-In ratio of the highest-performing 25% of funds from the lower 75%. |
|
tvpiStandardDeviationLp |
string |
|
Standard deviation of the Total Value to Paid-In ratio metrics. |
| filter_list |
vintageYear |
string(10) |
= |
Vintage year is determined by the legal inception date of the fund. |
| filter_list |
vintageYearType |
string(50) |
= |
Denotes if the vintageYear is defined by Legal Since Inception or First Cash Flow. |