Type FundHorizonByVintageYear
Type category Entity
Description The Horizon performance calculation is similar to the Since Inception IRR; however, it is measuring the return between two specific points in time. The calculation takes into account the Net Asset Value at the selected start date, the quarterly cash flows and the Net Asset Value at the end date. All returns greater than one year are annualized. (By Vintage Year)
Timeseries key id, asOfDateavailable from 2024-03-31
Fields
Name Type Filters Description
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.
benchmarkId string(100)* Unique index identifier.
link benchmarkMapping BenchmarkMapping* Link to the Benchmark mapping.
calculation string(100) Calculations shown by either individual quarter, calendar year, rolling year or multi-year period.
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.
currency string(3) Currency used to calculate the index.
dataModeType string(50) Denotes if the index performance is Preliminary or Published.
endDate date The ending date for the calculation.
firstTransaction string(10) The quarter during which the first cash flow occurred.
fundCount string 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.
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%.
performanceQuarter string(10) Index captures the performance during this year and quarter.
reportType string(50) Denotes the report type.
rowNumber long Row Number.
runDate date Date at which the data is sent by Cambridge.
standardDeviation string Standard deviation of the individual return metrics. Individual IRRs over 1,000% are excluded from the calculation.
startDate date The starting date for the calculation.
totalCapitalization string The total amount of capital committed from L.P.s and G.P.s across all funds.
vintageYear string(10) Vintage year is determined by the legal inception date of the fund.
vintageYearType string(50) Denotes if the vintageYear is defined by Legal Since Inception or First Cash Flow.
30 rows of 30 total
API Open API Specification