How Do I Get a Cash Flow Value for a Specific Month?

Formula

=ALLOCATOR_CASHFLOWS_VALUE( [Text] ID, [Date] Date, [Text] Metrics)

Arguments

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

Date - Required - Date - Eg: 2021-12-31                              The date in YYYY-MM-DD format.

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

Example

Net contributions of the Private Equity fund with Allocator ID "014c6f" in December 2021.

=ALLOCATOR_CASHFLOWS_VALUE( "014c6f","2021-12-31","Net Contributions")

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.