Average of Values (difference between two assets, from a table)

Last updated 9 November 2026

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

GIA_RPM_AverageValuesFromTable2

Returns the average of the differences beween two values, during a specified period, given historical values.

GIA_RPM_AverageValuesFromTable2(HistoricalData, SingleDatesColumn, AssetName1, AssetName2, StartDate, EndDate, ExcludeFromDate, ExcludeToDate)

Returns: Average of the differences beween two values, during a specified period

Argument	Use	Description
`HistoricalData`	Required	The array of historical data of the assets.
`SingleDatesColumn`	Required	Whether the historical data table has only one shared column for dates (Yes, No).
`AssetName1`	Required	The first asset.
`AssetName2`	Required	The second 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.