How Do I Get One Month's Return Value?

Formula

=ALLOCATOR_RETURNS_VALUE( [Text] ID, [Date] Date, [Text] Time Unit, [Text] Show Estimate)

Arguments                                                                                           

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

Date - Required - Date - Eg: 2021-06-30                 The date in YYYY-MM-DD format.

Time Unit - Optional - Text - Default: Monthly        The periodicity of the returns.

Show Estimate - Optional - Text – Default: No      Whether to show the return if it is an Estimate.

Example

Returns of Fund "fdedb7" for June 2021.

=ALLOCATOR_RETURNS_VALUE( "fdedb7","2021-06-30")

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.