Average of Values (one asset)

Last updated 9 November 2026

1 GIAnalyzer function for Excel. Optional arguments are shown in [brackets].

GIA_RPM_AverageValues1

Returns the average value during a specified period, given historical values.

GIA_RPM_AverageValues1(HDates, HRates, StartDate, EndDate, ExcludeFromDate, ExcludeToDate)

Returns: Average value during a specified period

Argument	Use	Description
`HDates`	Required	The array of dates of historical prices of the asset.
`HRates`	Required	The array of historical prices of the asset.
`StartDate`	Required	The first date in the required period.
`EndDate`	Required	The last date in the required period.
`ExcludeFromDate`	Required	The first date in the period excluded from the required period.
`ExcludeToDate`	Required	The last date in the period excluded from the required period.