Skip to content
English
Create a Support Ticket Customer portal
  • There are no suggestions because the search field is empty.

How Do I Get Holdings Source Data For a Private Capital Fund?

How to pull the underlying holdings of a private capital fund.

Formula

=ALLOCATOR_HOLDINGS_SOURCE( [Text] ID, [Text] Company, [Text] Metrics, [Date] Start Date, [Date] End Date) 

Arguments

ID Required - Text - Eg: 014c6f                               The Private Equity ID.

Company - Optional - Text - Eg: Forum                 The Source Asset

Metrics - Optional - Text - Eg: Total Value            The selected Metric.

Start Date - Optional - Date - Eg: 2021-01-01       The start date in YYYY-MM-DD format.

End Date - Optional - Date - Eg: 2021-12-31         The end date in YYYY-MM-DD format.

Example

The Source holdings for Fund “014c6f” for the year 2021.

=ALLOCATOR_HOLDINGS_SOURCE( "014c6f", , ,"2021-01-01","2021-12-31")

Remarks

[Metric] If you don't specify the Metric, Holdings Source will give all metrics during the timer period.

The date field is not format sensitive if you input a cell reference.

[Start Date]   If you don't specify the start date, Holdings Source will return everything before the end date.

[End Date] If you don't specify the end date, Holdings Source will return everything after the start date.