Tracking Error

Last updated 9 November 2026

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

GIA_RPM_TrackingError

Returns the tracking error during a specified period, given historical prices of the reference index and the values of the portfolio/fund.

GIA_RPM_TrackingError(HDatesI, HRatesI, HDatesF, HRatesF, StartDate, EndDate, PriceChangeCalc, ScalingFactor, ExcludeFromDate, ExcludeToDate)

Returns: Tracking error during a specified period

Argument	Use	Description
`HDatesI`	Required	The array of dates of historical prices of the reference index.
`HRatesI`	Required	The array of historical prices of the reference index.
`HDatesF`	Required	The array of dates of historical prices of the fund.
`HRatesF`	Required	The array of historical prices of the fund.
`StartDate`	Required	The first date in the required period.
`EndDate`	Required	The last date in the required period.
`PriceChangeCalc`	Required	Calculation type of the price change (Discrete, Continuous, Absolute). See the documentation for full description.
`ScalingFactor`	Required	The scaling factor in the square root of time rule. See the documentation for full description.
`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.