Type FundHorizon
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.
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.
filter_list benchmarkId string(100)* = Unique index identifier.
link benchmarkMapping BenchmarkMapping* Link to the Benchmark mapping.
filter_list calculation string(100) = Calculations shown by either individual quarter, calendar year, rolling year or multi-year period.
capitalizationGp decimal The total amount of capital committed from G.P.s across all funds.
capitalizationLp decimal The total amount of capital committed from L.P.s across all funds.
filter_list currency string(3) = Currency used to calculate the index.
filter_list dataModeType string(50) = Denotes if the index performance is Preliminary or Published.
filter_list endDate date =< >= The ending date for the calculation.
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.
irrMedian string Breakpoint return separating the highest-performing 50% of funds in a selected sample from the lower 50%.
irrPooled decimal 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%.
filter_list 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 decimal The total amount of capital committed from L.P.s and G.P.s across all funds.
filter_list vintageYearType string(50) = Denotes if the vintageYear is defined by Legal Since Inception or First Cash Flow.
29 rows of 29 total
API Open API Specification