Frequency of Values (one asset, from a table)

Last updated 9 November 2026

Function reference › Risk and Performance Measures › Frequency

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

GIA_RPM_FrequencyValuesFromTable1

Returns the frequency of times (quantity or probability) in which the value meets a chosen criteria, during a specified period, given historical values.

GIA_RPM_FrequencyValuesFromTable1(HistoricalData, SingleDatesColumn, AssetName, Condition, Value1, Value2, OT, StartDate, EndDate, ExcludeFromDate, ExcludeToDate)

Returns: Frequency of times (quantity or probability) in which the value meets a chosen criteria, 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).
`AssetName`	Required	Which asset to calculate the volatility for.
`Condition`	Required	The criteria that defines which changes will be chosen (Below, Above, BelowOrAbove, Between, Equal)
`Value1`	Required	The lower value to which the condition is related if the condition is "BelowOrAbove" or "Between".The value to which the condition is related if the condition is "Below" or "Equal".
`Value2`	Required	The upper value to which the condition is related if the condition is "BelowOrAbove" or "Between".The value to which the condition is related if the condition is "Above".
`OT`	Required	Output type (Quantity, Probability)
`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.