How Do I Get an Array of Cash Flow Data for a Specific Time Period?

Formula

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

Arguments

ID - Required - Text - Eg: fdedb7                                          The Fund, Company, Series, Portfolio ID.

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.

Metrics - Optional - Text - Eg: Investment Income              The selected Metric.

Example

Cash Flow Metrics for Private Equity fund "014c6f" for the year 2021.

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

Remarks

[ID] If a Fund ID is given, the Default series will be used.

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

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

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

[Metric] If you don't specify the Metric, Cash Flows Array will give all metrics during the timer period.