Folks,

I've created a new FV function derived from a request I received. This is the description of it. Putting it out here to see if it should do anything else before I release it.
Note also the description of the PPOnSameSurface parameter -- this will be changed in the next iteration of 6.0 for ALL functions that use PPOnSameSurface in order to support AW tracks.

#hCALCON(STRING “Variable”, STRING Calculation, BOOL HighestValues, int NumPaceLinesToUse, int NumPacelinesToSelectFrom, MinPPAge, MaxPPAge, MinPPDistance, MaxPPDistance, PPOnSameTrack, PPOnSameSurface, MinVariableValueToUse,MaxVariableValueToUse, MinFinishPositionofPP, MaxFinishPositionOfPP) (NEW IN VERSION 6)

My scientific sounding definition of this function… The CALCON function performs a calculation on a subset of the values returned by querying the selected ‘variable’ of each horse. The subset is determined by looking at the X highest or lowest values from the superset, where X is set by the parameter “NumPaceLinesToUse”.
Perhaps an example is better… Say you want to know the average of the best (highest) TWO speed figures of the last FOUR pacelines for each horse in a race. This is the function for you:

#hCALCON(“ppSpeedFig”, “AVG”, true, 2, 4, 0, 10000, 0, 99, 0, 0, 0, 999, 0, 99)

If you wanted the “worst” speed figures, change HighestValues from true to false.

Parameter Description:
Variable: The name of the formula view variable to use, in quotes “”, with no leading $

Calculation: This tells the function which calculation to perform. You can use ADD, MED, AVG, MAX, MIN, and DEV (corresponding to the above functions). You must put the parameter in quotes “”.

HighestValue: the word true if you want to use the highest values in the calculation, false if you want the lowest. Note – don’t use quotes around the word true or false.

NumPaceLinesToUse: This is the number of pacelines you want to select FROM the total number of pacelines to be evaluated. If you want to know the average of the highest THREE speed figures for a horse’s last TEN races, you would set this parameter to THREE.

NumPaclinesToSelectFrom: This is the maximum number of pacelines to evaluate – in chronological order (starting from the most recent). So, if you want the median of the horse’s lowest TWO E2 figure in its last FIVE races, you would set this parameter to FIVE.

MinPPAge: A filter for selecting which pacelines to evaluate, minimum age of the paceline in days.

MaxPPAge: A filter for selecting which pacelines to evaluate, maximum age of the paceline in days.

MinPPDistance: A filter for selecting which pacelines to evaluate, the minimum paceline distance in FURLONGS

MaxPPDistance: A filter for selecting which pacelines to evaluate, the maximum paceline distance in FURLONGS.

PPOnSameTrack: A filter for selecting which pacelines to evaluate, 1 if the paceline has to be on the same track, 0 if not

PPOnSameSurface: A filter for selecting which pacelines to evaluate, 1 if the paceline has to be on the same surface, 0 if not, 2 means that the surface has to be the same AND to consider All Weather surfaces SEPARATE FROM DIRT surfaces (otherwise dirt and aw are considered the same).

MinVariableValueToUse: A filter for selecting which pacelines to evaluate, the minimum value of the variable for it to be included in the evaluation set.

MaxVariableValueToUse: A filter for selecting which pacelines to evaluate,the maximum value fo the variable for it to be included in the evaluation set.

MinFinishPostionofPP: A filter for selecting which pacelines to evaluate, the minimum finish position of the horse in the past performance for the paceline to be included in the evaluation set.

MaxFinishPositionOfPP A filter for selecting which pacelines to evaluate, the maximum finish position of the horse in the past performance for the paceline to be included in the evaluation set.


#rCALCON(STRING “Variable”, STRING Calculation, BOOL HighestValues, int NumPaceLinesToUse, int NumPacelinesToSelectFrom, MinPPAge, MaxPPAge, MinPPDistance, MaxPPDistance, PPOnSameTrack, PPOnSameSurface, MinVariableValueToUse,MaxVariableValueToUse, MinFinishPositionofPP, MaxFinishPositionOfPP) (NEW IN VERSION 6)
Works the same as hCALCON except it returns the calculated value from ALL the past performances of all the horses.

Nathan,

Would a CALCON FV function
to include ppBtnLengths be a possibility?

thorny

Hi Nathan
Can you add off or fast to this selection? Same surface can have different conditions.

PPOnSameSurface: A filter for selecting which pacelines to evaluate, 1 if the paceline has to be on the same surface, 0 if not, 2 means that the surface has to be the same AND to consider All Weather surfaces SEPARATE FROM DIRT surfaces (otherwise dirt and aw are considered the same).

Brilliant Jerry -- will do.

Hi Nathan
I know you are working on a re do for the pace line selection.
Would be nice to put this fast or off feature in that process also.
Thanks Jerry

Good idea. Very useful function.
Can't think of much else to add to it. Along with Jerry's good idea, you have it well covered.
Thanks Nathan.

I'm only a year behind in this post, lol .. Haven't really been into cappin' too too much and I also haven't upgraded to V6 which I guess is the next step. This is an awesome function though. I only have one question. What if I only wanted to look at races of 1/2 furlong to today's distance?

I'd basically only want to look at races that are 1/2 a furlong from today's race, on the same surface, etc? Maybe purse or class level designations as well?

Can this function do those things?

Hope everyone is doing well,
Mitch