EquiSim Formula View Master Variable and Custom Function List

     

VARIABLE NAME

Category

Description

hrAge

Horse

The age of the horse, in years.

hrAuctionPlaceS

Horse

The auction horse that sold the horse, if available

hrAuctionPrice

Horse

The price the horse sold at auction, if available.

hrBestDistSpeed

Horse

The horse’s best speed figure at the distance of the upcoming race.

hrBestOffSpeed

Horse

The horse’s best speed figure on an “off” track.

hrBestSpeed

Horse

The horse’s best overall speed figure.

hrBestTurfSpeed

Horse

The horse’s best speed figure on turf courses.

hrBlinkersOffB

Horse

Returns ‘1’ if the horse is running with blinkers off.

hrBlinkersOnB

Horse

Returns ‘1’ if the horse is running with blinkers on.

hrBreederLocS

Horse

The location of the Breeder.

hrBreederS

Horse

The name of the Breeder.

hrButeB

Horse

Returns ‘1’ if the horse is medicated with bute.

hrClaimingTag

Horse

The claiming price of the horse in the race.

hrColorS

Horse

The horse’s color.

hrCurYear

Horse

The year in which the race the horse is in took place.

hrCurYrEarnings

Horse

The horse’s race earnings from the current year.

hrCurYrPlaces

Horse

The number of times the horse placed in races in the current year.

hrCurYrRaces

Horse

The number of races the horse has had in the current year.

hrCurYrShows

Horse

The number of times the horse showed in races in the current year.

hrCurYrWins

Horse

The number of times the horse won in races in the current year.

hrDamS

Horse

The horse’s Dam.

hrDamSireS

Horse

The horse’s Dam’s Sire.

hrDaysOff Horse The days since this horse's last race

hrDirtPed

Horse

The BRIS pedigree rating for Dirt races.

hrDistEarnings

Horse

The horse’s earnings from races at the distance of the upcoming race.

hrDistPed

Horse

The BRIS pedigree rating for the distance of the upcoming race.

hrDistPlaces

Horse

The number of times the horse placed in races of the same distance as the upcoming race.

hrDistRaces

Horse

The number of races the horse has had at the same distance as the upcoming race.

hrDistShows

Horse

The number of times the horse showed in races of the same distance as the upcoming race.

hrDistWins

Horse

The number of times the horse won in races of the same distance as the upcoming race.

hrEarlySpeedPts

Horse

The horse’s Quirin Style Speed points.

hrEarnings

Horse

The horse’s total earnings from races.

hrFirstLasixB

Horse

Returns ‘1’ if the horse is getting Lasix for the first time AND the horse is not a first time starter.

hrFirstStartB

Horse

Returns ‘1’ if this is the horse’s first race.

hrFrontWrapsB

Horse

Returns ‘1’ if the horse is racing with front bandages on.

hrJMeetPlaces

Horse

The number of places the horse’s jockey has had at the meet.

hrJMeetRaces

Horse

The number of races the horse’s jockey has had at the meet.

hrJMeetShows

Horse

The number of shows the horse’s jockey has had at the meet.

hrJMeetWins

Horse

The number of wins the horse’s jockey has had at the meet.

hrJockeyS

Horse

The name of the horse’s jockey.

hrJockeyWghtAlw

Horse

The jockey’s apprentice weight allowance, if any.

hrJYearPlaces

Horse

The number of places the horse’s jockey has had in the current year.

hrJYearRaces

Horse

The number of races the horse’s jockey has had in the current year.

hrJYearShows

Horse

The number of shows the horse’s jockey has had in the current year.

hrJYearWins

Horse

The number of wins the horse’s jockey has had in the current year.

hrLasixB

Horse

Returns ‘1’ if the horse is racing with Lasix.

hrLasixOffB

Horse

Returns ‘1’ if the horse had Lasix in his last race but now has no lasix.

hrLasixOnB

Horse

Returns ‘1’ if the horse did not have lasix in his last race but now has lasix.

hrMaleB

Horse

Returns ‘1’ if the horse is male.

hrMLFavoriteB

Horse

Returns ‘1’ if the horse is the favorite in the race.

hrMLOdds

Horse

The morning line odds of the horse.

hrMonthFoaled

Horse

The month the horse was foaled in, as a digit.

hrMudPed

Horse

The BRIS pedigree for races run in the mud.

hrMyContenderB

Horse

Returns ‘1’ if the horse’s “contender” flag was set by the user.

hrMyFinish

Horse

The finish position of the horse as set by the User in the EquiSim Selections and Wagers screen.

hrNameS

Horse

The horse’s name.

hrNasalB

Horse

Returns ‘1’ if the horse is wearing a nasal strip.

hrNasalOffB

Horse

Returns ‘1’ if the horse wore a nasal strip in his last start but is not wearing one in the upcoming race.

hrNasalOnB

Horse

Returns ‘1’ if the horse is wearing a nasal strip and did NOT where one in his last start.

hrNumPastPerfs

Horse

The number of past performances the horse has in the racing card.

hrNumPPsSelected

Horse

The number of past performances selected in EquiSim’s Form View.

hrNumWrks

Horse

The number of workouts the horse has in the raceing card.

hrOffEarnings

Horse

The horses life earnings from all races run on off tracks.

hrOffPlaces

Horse

The number of places the horse had in races run on off tracks.

hrOffRaces

Horse

The number of races the horse had on off tracks.

hrOffShows

Horse

The number of shows the horse had in races run on off tracks.

hrOffWins

Horse

The number of wins the horse had in races run on off tracks.

hrOwnerS

Horse

The owner of the horse.

hrPlaces

Horse

The number of places the horse has had in all his races.

hrPost

Horse

The horse’s post position.

hrPowerDif

Horse

The EquiSim “Power Difference” for the horse.

hrPowerMove

Horse

The EquiSim “Power Move” for the horse.

hrPrevYear

Horse

The previous year in the racing card.

hrPrevYrEarnings

Horse

The horse’s earnings from all races in the previous year.

hrPrevYrPlaces

Horse

The number of places the horse had in races from the previous year.

hrPrevYrRaces

Horse

The number of races the horse had in races from the previous year.

hrPrevYrShows

Horse

The number of shows the horse had in races from the previous year.

hrPrevYrWins

Horse

The number of wins the horse had in races from the previous year.

hrPrimePower

Horse

The BRIS/TSN Prime Power rating for the horse.

hrProgNum

Horse

The horse’s program number as a digit (note, entries not supported. 1A is 1).

hrProgNumS

Horse

The horse’s program number as text (i.e., “1A”).

hrPTFavoriteB

Horse

Returns ‘1’ if the horse was the post time favorite in the upcoming race. Requires results file for this info to be available.

hrPTOdds

Horse

The horses Post Time odds in the upcoming race. Requires results file for this info to be available.

hrRaces

Horse

The number of races the horse has had in his career.

hrRaceStyle

Horse

The horse’s Quirin Running Style, AS A NUMBER:

E = 0, EP = 1, P = 2, S = 3, NA = 4

hrRaceStyleS

Horse

The horse’s Quirin Running Style. EG: E, EP, P, S, NA

hrSexS

Horse

The horse’s sex, as a single text character.

hrShows

Horse

The number of shows the horse has had in his career.

hrSimBtnLengths

Horse

The final beaten lengths of the horse in the last simulation run.

hrSimBtnLengths1 Horse 1st call btn lenghtsin simulation
hrSimBtnLengths2 Horse 2nd call btn lengths in simulation
hrSimBtnLengths3 Horse 3rd call btn lengths in simulation
hrSimCall1 Horse 1st Call positionins imulation
hrSimCall2 Horse 2nd call position in simulation
hrSimCall3 Horse 3rd Call position insimulation

hrSimFinish

Horse

The simulation finish position of the last simulation run.

hrSimFract1 Horse 1st call split time in simulation
hrSimFract2 Horse 2nd call split time in simulation
hrSimFract3 Horse 3rd call split time in simulation
hrSimFractFinish Horse Finish time in simulation

hrSireS

Horse

The horse’s sire’s name.

hrSireSireS

Horse

The horse’s sire’s sire’s name.

hrStudFee

Horse

The stud fee of the horse’s sire, if available.

hrTrackEarnings

Horse

The earnings of the horse from races run on the upcoming race’s track.

hrTrackPlaces

Horse

The number of places the horse had on the track of the upcoming race.

hrTrackRaces

Horse

The number of races the horse had on the track of the upcoming race.

hrTrackShows

Horse

The number of shows the horse had on the track of the upcoming race.

hrTrackWins

Horse

The number of wins the horse had on the track of the upcoming race.

hrTrainerS

Horse

The horse’s trainer.

hrTrMeetPlaces

Horse

The number of places the horse’s trainer has at the meet of upcoming race.

hrTrMeetRaces

Horse

The number of races the horse’s trainer has at the meet of upcoming race.

hrTrMeetShows

Horse

The number of shows the horse’s trainer has at the meet of upcoming race.

hrTrMeetWins

Horse

The number of wins the horse’s trainer has at the meet of upcoming race.

hrTrYearPlaces

Horse

The number of places the horse’s trainer has on the year.

hrTrYearRaces

Horse

The number of races the horse’s trainer has on the year.

hrTrYearShows

Horse

The number of shows the horse’s trainer has on the year.

hrTrYearWins

Horse

The number of wins the horse’s trainer has on the year.

hrTurfEarnings

Horse

The horse’s earnings from races run on the turf.

hrTurfPed

Horse

The BRIS Turf Pedigree rating for the horse.

hrTurfPlaces

Horse

The number of places the horse had from races run on the turf.

hrTurfRaces

Horse

The number of races the horse had from races run on the turf.

hrTurfShows

Horse

The number of shows the horse had from races run on the turf.

hrTurfWins

Horse

The number of wins the horse had from races run on the turf.

hrWeight

Horse

The weight the horse is carrying in the upcoming race.

hrWins

Horse

The number of wins the horse has had.

hrProfVal Horse the Profiler Value for the horse - race must be profiled.
hrProfRank Horse The Profiler Value Rank for the horse - rce must be profield.
hrCompVal Horse the Profiler "Comp" val for the horse.
hrCompRank Horse The Profiler "Comp" val rank for the horse.
hrTrainerVal Horse The Profiler "Trainer" value for the horse.
hrTrainerRank Horse The Profiler "Trainer" value rank for the horse.
hrSireVal horse THe Profiler "Sire" value for the horse
hrSireRank Horse The Profiler Sire value rank for the horse
hrOwnerVal Horse The Profiler Owner Value for the horse
hrOwnerRank Horse The Profiler Owner value rank for the horse
hrJockeyVal Horse The Profiler Jockey Value for the horse
hrJockeyRank horse The Profiler Jockey Value rank for the horse

ppAge

Paceline

The number of days from the date of the past perf to the upcoming race.

ppAgeRestrS

Paceline

A text indicator of the age restrictions for the past perf:

A - 2 year olds
B - 3 year olds
C - 4 year olds
D - 5 year olds
E - 3 & 4 year olds
F - 4 & 5 year olds
G - 3, 4, and 5 year olds
H - all ages

ppAgeRestrUpOrOnlyS

Paceline

A text indicator whether the past perf was age restricted as “that age only” or “that age and up”.  Empty if no restriction:

O - That age Only
U - That age and Up

ppApproxDistB

Paceline

Returns ‘1’ if the distance of the race was approximate. Common for turf races with moveable rails.

ppBarShoesB

Paceline

Returns ‘1’ if the horse wore bar shoes in the race.

ppBarShoesOffB

Paceline

Returns ‘1’ if the horse wore bar shoes the race previous to this one, but did not in this one.

ppBarShoesOnB

Paceline

Returns ‘1’ if the horse did not wear bar shoes in the race previous to this one, but did in this race.

ppBlinkersB

Paceline

Returns ‘1’ if the horse wore blinkers in this race.

ppBlinkersOffB

Paceline

Returns ‘1’ if the horse wore blinkers in the race previous to this one, but did not in this race.

ppBlinkersOnB

Paceline

Returns ‘1’ if the horse did not wear blinkers in the race previous to this one, but did in this race.

ppBtnLengths1

Paceline

The horse’s beaten lengths at the first call.

ppBtnLengths2

Paceline

The horse’s beaten lengths at the second call.

ppBtnLengthsStretch

Paceline

The horse’s beaten lengths at the stretch call.

ppBtnLengthsFinish

Paceline

The horse’s beaten lengths at the finish.

ppButeB

Paceline

Returns ‘1’ if the horse was medicated with Bute in the race.

ppCall1

Paceline

The position of the horse at the first call.

ppCall2

Paceline

The position of the horse at the second call.

ppCall3

Paceline

The position of the horse at the third call.

ppCallStart

Paceline

The position of the horse at the start call.

ppClaimedB

Paceline

Returns ‘1’ if the horse was claimed from this race.

ppClass

Paceline

The class indicator of the race as a number:
Maiden Claiming = 0, Maiden Special Weight = 1, Claiming = 2, Handicap = 3, Starter Allowance = 4, Optional Claiming/Allowance = 5, NonGraded Stakes = 6, Graded Stakes = 7

ppClassificationS

Paceline

The classification of the race as text

ppClassS

Paceline

The class of the race as text.

ppDate

Paceline

The date of the race as a number. This number is the number of days since midnight, 30 December 1899

ppDateS

Paceline

The date of the race as text.

ppDaysSinceLast

Paceline

The number of days between this race and the previous race.

ppDistCat

Paceline

The EquiSim distance category of the race, as a number:

Juvenile Sprint = 0, Super Sprint = 1, Sprint = 2, Long Sprint = 3, Route = 4, Long Route = 5, Super Route = 6

ppDistFurs

Paceline

The distance, in furlongs, of the race.

ppDistYds

Paceline

The distance, in yards, of the race.

ppDRFSpeed

Paceline

The DRF Speed figure for the race.

ppDRFVar

Paceline

The DRF track variant for the race.

ppE1 Paceline Returns the E1 pace figure for the race,dependant on the distance of the race.
ppE2 Paceline Returns the E2 pace figure for the race, dependant on the distance of the race.

ppFavoriteB

Paceline

Returns ‘1’ if the horse was the favorite in the race.

ppFinalTime

Paceline

The winner’s final time of the race

ppFinish

Paceline

The horse’s finish position in the race.

ppFormOrder Paceline Returns the order the paceline appears on the form. This is useful for creating a column that, when sorted on, will show past performance lines in the same order as they appear on the Form.

ppFractOne

Paceline

The fractional time (seconds) of the leader of the race at the first call.

ppFractThree

Paceline

The fractional time (seconds) of the leader of the race at the third call.

ppFractTwo

Paceline

The fractional time (seconds) of the leader of the race at the second call.

ppFrontWrapsB

Paceline

Returns ‘1’ if the horse wore front wraps in the race.

ppFrontWrapsOffB

Paceline

Returns ‘1’ if the horse wore front wraps in the race previous to this one, but did not in this race.

ppFrontWrapsOnB

Paceline

Returns ‘1’ if the horse did not wear front wraps in the race previous to this one, but did so in this race.

ppFVIncIndex Paceline Returns the index of the past performance. The index is based only on those past performances that met the paceline inclusion filters for paceline based formula views.

ppHFinalTime

Paceline

The horse’s final time in the race, as calculated by EquiSim using beaten lengths.

ppHFract10

Paceline

The horse’s 10 furlong fractional time as calculated by EquiSim using beaten lengths.

ppHFract12

Paceline

The horse’s 12 furlong fractional time as calculated by EquiSim using beaten lengths.

ppHFract14

Paceline

The horse’s 14 furlong fractional time as calculated by EquiSim using beaten lengths.

ppHFract16

Paceline

The horse’s 16 furlong fractional time as calculated by EquiSim using beaten lengths.

ppHFract2

Paceline

The horse’s 2 furlong fractional time as calculated by EquiSim using beaten lengths.

ppHFract3

Paceline

The horse’s 3 furlong fractional time as calculated by EquiSim using beaten lengths.

ppHFract4

Paceline

The horse’s 4 furlong fractional time as calculated by EquiSim using beaten lengths.

ppHFract5

Paceline

The horse’s 5 furlong fractional time as calculated by EquiSim using beaten lengths.

ppHFract6

Paceline

The horse’s 6 furlong fractional time as calculated by EquiSim using beaten lengths.

ppHFract7

Paceline

The horse’s 7 furlong fractional time as calculated by EquiSim using beaten lengths.

ppHFract8

Paceline

The horse’s 8 furlong fractional time as calculated by EquiSim using beaten lengths.

ppIndex Paceline Returns the index of the paceline, starting at 0, as the paceline appears on the form of each horse.

ppIsMultiSelPPB

Paceline

returns 1 if the past perf is an EquiSim selected pace line (multiple selection)

ppIsSelPPB

Paceline

returns 1 if the past perf is the selected paceline in EquiSim’s Form View

ppJockeyS

Paceline

The jockey on the horse in this race.

ppJockeyWghtAlw

Paceline

The jockey’s weight allowance in this race.

ppLasixB

Paceline

Returns 1 if the horse was medicated with Lasix in the race.

ppLasixOffB

Paceline

Returns 1 if the horse had lasix in his previous race, but did not in this race.

ppLasixOnB

Paceline

Returns 1 if the horse did not have lasix in his previous race, but did so in this race. Does NOT return 1 for first time starters that have lasix.

ppNasalB

Paceline

Returns 1 if the horse wore a nasal strip in this race.

ppNasalOffB

Paceline

Returns 1 if the horse wore a nasal strip in his previous race but did not in this race.

ppNasalOnB

Paceline

Returns 1 if the horse wore a nasal strip in this race but did not in the race previous to this one.

ppNumStarters Paceline The numberof starters in the race.

ppPace10

Paceline

The horse’s 10 furlong Pace Figure for this race.

ppPace2

Paceline

The horse’s 2 furlong Pace Figure for this race.

ppPace4

Paceline

The horse’s 4 furlong Pace Figure for this race.

ppPace6

Paceline

The horse’s 6 furlong Pace Figure for this race.

ppPace8

Paceline

The horse’s 8 furlong Pace Figure for this race.

ppPaceLate

Paceline

The horse’s late Pace Figure for this race.

ppPost

Paceline

The horse’s post position in this race.

ppPowerDif

Paceline

The EquiSim Power Difference for this horse in the race.

ppPowerMove

Paceline

The EquiSim Power Move for this horse in the race.

ppPrimePower

Paceline

The Bris/TSN Prime Power for this horse in the race.

ppPurse

Paceline

The purse of this race.

ppRaceIndexS

Paceline

The race index as text. (DayMonthYearTrackRaceNumber)

ppRaceNum

Paceline

The number of the race on the card.

ppSexRestrS

Paceline

Text sex restrictions of the race:

N - No Sex Restrictions
M - Mares and Fillies Only
C - Colts and/or Geldings Only
F - Fillies Only

ppSpeedFig

Paceline

The horse’s speed figure in the race.

ppStateBredB

Paceline

Returns ‘1’ if the race was State Bred restricted.

ppSurfaceS

Paceline

The surface the race was run over, as text:

D- dirt, T- turf, d- inner dirt,  t- inner turf, s- steeplechase, h- hunt

ppTrackS

Paceline

The track of the race.

ppTrackCondS

Paceline

The track condition, as text, of the race.

ppTrainerS

Paceline

The horse’s trainer in the race.

ppTripTroubleB Paceline Returns a 1 if any of the following words appear in the comment line, otherwise a zero is returned: stumbled , rider, clipped , fell ,bobbled ,awk , stopped, distanced ,through after, factor, showed little,showed nothing, tripped, gave way, veered , hop, eased

ppTurfB

Paceline

Returns ‘1’ if the race was run on the turf.

ppWeight

Paceline

The weight carried by the horse in the race.

rrAgeRestrS

Race

Text age restrictions of the race.  See ppAgeRestrS for more info.

rrAgeRestrUpOrOnlyS

Race

Text age restriction qualifier. See ppAgeRestrUpOrOnlyS for more info.

rrApproxDistB

Race

Returns ‘1’ if the race is run at an approx distance.

rrClass

Race

See “ppClass”

rrClassificationS

Race

See ppClassificationS

rrClassS

Race

See ppClassS

rrDate

Race

See ppDate

rrDateS

Race

See ppDateS

rrDistCat

Race

See ppDistCat

rrDistFurs

Race

See ppDistFurs

rrDistYds

Race

See ppDistYds

rrE1Par

Race

The BRIS/TSN early pace figure PAR for this race class.

rrE2Par

Race

The BRIS/TSN second early pace figure PAR for this race class.

rrExactaPO

Race

The race’s exacta payout.

rrLatePar

Race

The BRIS/TSN Late Pace figure PAR for this race class.

rrNumStarters Race The number of Non-Scratched horses in the race (starters).

rrOddsConf

Race

The user selected Odds Confidence for this race as a number

rrOddsConfS

Race

The user selected odds confidence for this race as text.

rrOddsTempl

Race

The user selected odds template for this race as a number.

rrOddsTemplS

Race

The user selected odds template for this race as text.

rrPlacePO

Race

The place payout of the race.

rrPlaceShowPO

Race

The place-show payout of the race.

rrPostTime

Race

The post time of the race as a number, days since midnight, 1899

rrPostTimeS

Race

The post time of the race as text.

rrPurse

Race

The purse of the race.

rrQuinellaPO

Race

The quinella payout of the race.

rrRaceFract1

Race

The leader’s fractional time at the first call in the race.

rrRaceFract2

Race

The leader’s fractional time at the second call in the race.

rrRaceFract3

Race

The leader’s fractional time at the third call in the race.

rrRaceNum

Race

The race number on the card.

rrRaceTime

Race

The winner of the race’s running time.

rrSelConf

Race

The user selected “Selection confidence” as a number.

rrSelConfS

Race

The user selected “Selection confidence” as text.

rrSexRestrS

Race

See ppSexRestrS

rrShowPO

Race

The Show payout of the race.

rrSpeedPar

Race

The BRIS/TSN Speed Figure PAR for this race class.

rrSuperPO

Race

The superfecta payout for this race.

rrSurfaceS

Race

The surface this race was run on, as text.

rrTrackCondS

Race

The track condition of this race

rrTrackRecord

Race

The track record for this race distance.

rrTrackS

Race

The track this race was run on.

rrTrifectaPO

Race

The trifecta payout.

rrTurfB

Race

returns ‘1’ if this race is on the turf.

rrUserCommentS

Race

User entered comments about the race.

rrWinPlacePO

Race

The Win-Place payout.

rrWinPO

Race

The Win payout.

rrWinShowPO

Race

The Win-Show payout.

wkAge

Workout

The number of days past from this workout to the date of the upcoming race

wkBulletB

Workout

Returns ‘1’ if this was the fastest workout of the distance on the day.

wkDate

Workout

The date of the workout, as a number (days since midnight 1899)

wkDateS

Workout

The date of the workout as text.

wkDescrS

Workout

The description of the workout.

wkDistFurs

Workout

The distance in furlongs of the workout.

wkDistYds

Workout

The distance in yards of the workout.

wkRank

Workout

The rank of the workout against other workouts run at the distance that day.

wkSpeedFig

Workout

The EquiSim calculated  “Speed figure” for the workout.

wkTime

Workout

The time of the workout in seconds.

wkTotalWrksOnDay

Workout

The total number of workouts at the distance on the day.

wkTrackCondS

Workout

The track condition, as text, of the workout.

wkTrackS

Workout

The track the workout was run on.

wkTrackTypeS

Workout

The type of track the workout was run on:

MT-main dirt
IM-inner dirt
TT-Training Trk
T-main turf
IT-inner turf
WC-wood chip
HC-hillside course
TN-trf trn trk
IN-inner trf trn track
TR-training race
-if blank, track type unknown  

 


Profiler and Profiler Connection Based Variables

Profiler based variables must be prefixed with one of the following:

pr

Profiler variable

tr

Trainer variable in the Profiler

jk

Jockey variable in the profiler

sr

Sire variable in the Profiler

ow

Owner variable in the Profiler

hz

“Has” this variable. Returns ‘1’ if the horse has this type of Profiler ability and ‘0’ otherwise.

 

Profiler based variables must be followed by one of the following:

_WP

Returns the Win Percentage of the Profiler based variable.

_PP

Returns the Place Percentage of the Profiler based variable.

_SP

Returns the Show Percentage of the Profiler based variable.

_ROI

Returns the ROI of the Profiler based variable.

_ST

Returns the number of starts of the Profiler based variable.

_R

Returns the number of races of the Profiler based variable.

 

Variable Name

Description

DomE1

EquiSim Dominant E1 Ability

BestE1

EquiSim Best E1 Ability

StrongE1

EquiSim Strong E1 Ability

WeakE1

EquiSim Weak E1 Ability

DomE2

EquiSim Dominant E2 Ability

BestE2

EquiSim Best E2 ability

StrongE2

EquiSim Strong E2 Ability

WeakE2

EquiSim Weak E2 Ability

DomLate

EquiSim Dominant Late Ability

BestLate

EquiSim Best Late Ability

StrongLate

EquiSim Strong Late Ability

WeakLate

EquiSim Weak Late Ability

DomE2Late

EquiSim Dominant E2+Late ability

BestE2Late

EquiSim Best E2+Late Ability

StrongE2Late

EquiSim Strong E2+Late Ability

WeakE2Late

EquiSim Weak E2+Late Ability

DomSpeed

EquiSim Dominant Speed Ability

BestSpeed

EquiSim Best Speed Ability

StrongSpeed

EquiSim Strong Speed Ability

WeakSpeed

EquiSim Weak Speed Ability

DomPower

EquiSim Dominant Prime Power ability

BestPower

EquiSim Best Prime Power ability

StrongPower

EquiSim Strong Prime Power Ability

WeakPower

EquiSim Weak Prime Power Ability

DomTrnr

EquiSim Dominant Trainer Win Percentage Ability

BestTrnr

EquiSim Best Trainer Win Percentage Ability

StrongTrnr

EquiSim Strong Trainer Win Percentage Ability

WeakTrnr

EquiSim Weak Trainer Win Percentage Ability

RecentWork

EquiSim Had a Recent Workout Ability

ClassUp

EquiSim Moving Up in Class ability

ClassDown

EquiSim Moving down in class ability

PurseUp

EquiSim Moving up in Purse ability

PurseDown

EquiSim moving down in purse ability

EDistCutter

A speed horse cutting back in distance ability

MLFave

The morning line favorite ability

PTFave

The post time favorite ability.

FirstStart

The horse’s first start ability.

FirstAfterClaim

The horse running first off the claim ability

SecondAfterClaim

The horse running second off the claim ability.

DomTrackWins

The horse has a dominant number of wins at the track ability.

DomDistWins

The horse has a dominant number of wins at the distance ability.

FirstLasix

The horse has first lasix ability (first time starters not included).

OwnerTrainer

The horse’s owner is the horse’s trainer (concluded by looking for similarities in the trainer and owner’s names…)

FirstStartOddsLessThan3

The horse is a first time starter with Morning Line odds of less than 3

SimWinner

The horse won the simulation

Jockey

The horse’s jockey connection ability.

Owner

The horse’s owner connection ability.

RunStyle

The horse’s running style connection ability.

Surface

The surface of the upcoming race connection ability.

TurfDirt

The horse has shifted from a turf race to a dirt race connection ability.

DirtTurf

The horse has shifted from a dirt race to a turf race connection ability.

DistCat

The EquiSim distance category of the upcoming race connection ability.

Class

The class of the upcoming race connection ability.

OddsLow

The horse’s odds were low connection ability.

OddsMed

The horse’s odds were medium connection ability.

OddsHigh

The horse’s odds were high connection ability.

OddsLongshot

The horse was a longshot on the board connection ability.

Trainer

The horse’s trainer connection ability.

Sire

The horse’s sire connection ability.

ShortLayoff

The horse had a short layoff connection ability.

RegLayoff

The horse had a regular layoff connection ability.

MedLongLayoff

The horse had a medium long layoff connection ability.

LongLayoff

The horse had a long layoff connection ability.

SprintRoute

The horse is shifting from a sprint to a route connection ability.

RouteSprint

The horse is shifting from a route to a sprint connection ability.

Shipper

The horse is shipping in from a different track connection ability.

OffTrack

The horse is running on an off track connection ability.

NoRecentWork

The horse has no recent workout connection ability.

FirstAfterLayoff

The horse’s first race after a layoff connection ability.

SecondAfterLayoff

The horse’s second race after a layoff connection ability.

ThirdAfterLayoff

The horse’s third race after a layoff connection ability.

 

Formula View Custom Functions

What’s a function?

A function is a piece of, well, functionality that is wrapped up and exposed via a more simpler interface.  The interface is the function.  For example, the hAdd function in EquiSim will add up the piece of information you are interested it (e.g, a pace figure) for each of the past performances that a horse has.  Typically functions have parameters that let you customize what the function does.  The hAdd function has a parameter that let you tell the function what piece of information you are interested in looking at from the past performances of a horse as well as parameters that let you specify which past performances you are interested in.

Functions prefixed with ‘h’ look at the values in the past performances of one horse (at a time).  Whereas the functions prefixed with ‘r’ look across all of the horses in a race.   For example, hADD will attempt to add up the values specified by the variable parameter from the past performances of each horse individually. On the other hand, rADD will attempt to add up the values specified by the variable parameter from the past performances of ALL the horses in the race.

The Functions

 

#hADD(“Variable”, MinPPAge, MaxPPAge, MinPPDistance,  MaxPPDistance, PPOnSameTrack, PPOnSameSurface, MaxPPsToUse, MinVariableValueToUse,MaxVariableValueToUse)

Gets the average from the results returned by the variable in each past performance of a horse.  For example, you could use $ppSpeedFig in this function. For each row in the spreadsheet, it would return the total, added Speed Figures of the past performances for the horse represented by the row in the Formula View spreadsheet.

See the Parameters Section below for a description of the parameters used by this function.


Example:
Add the speed figures for a horse’s past performances if the past performances are between 0 and 100 days old and run on the same surface as the upcoming race:

#hADD(“$ppSpeedFig”, 0, 100, 0, 100, 0, 1, 10, 0, 1000) 

#rADD(“Variable”, MinPPAge, MaxPPAge, MinPPDistance,  MaxPPDistance, PPOnSameTrack, PPOnSameSurface, MaxPPsToUse, MinVariableValueToUse,MaxVariableValueToUse)

The rADD function works like the hADD function except that it will add up values for all of the horses in a race, after the same function is run for each horse. For example, if you do an rADD(“$ppSpeedFig”), internally the program will do an hADD($ppSpeedFig) for each horse. Then the rADD method will add up the values returned for hADD function run on each horse.

  See the Parameters Section below for a description of the parameters used by this function.

  Example:

Add the speed figures of each horse and compare the values of the speed figures for each horse as  a percentage of the TOTAL speed figures of all the horses:

#hADD(“$ppSpeedFig, 0, 1000, 0, 100, 0, 1, 10, 0, 1000) / rADD(“$ppSpeedFig, 0, 1000, 0, 100, 0, 1, 10, 0, 1000)

 

The above example does an hADD on the horse and then it divides that number by the TOTAL of all the speed figures of each horse by using the rADD method.

 

#hAVG(“Variable”, MinPPAge, MaxPPAge, MinPPDistance,  MaxPPDistance, PPOnSameTrack, PPOnSameSurface, MaxPPsToUse, MinVariableValueToUse,MaxVariableValueToUse)

Gets the average from the results returned by the variable in each past performance of a horse. For example, you could use $ppSpeedFig in this function. For each row in the spreadsheet, it would return the total, added Speed Figures of the past performances for the horse represented by the row in the Formula View spreadsheet.

See the Parameters Section below for a description of the parameters used by this function.


Example:
Average the speed figures for a horse’s past performances if the past performances are between 0 and 100 days old and run on the same surface as the upcoming race:

#hAVG(“$ppSpeedFig”, 0, 100, 0, 100, 0, 1, 10, 0, 1000)

#rAVG(“Variable”, MinPPAge, MaxPPAge, MinPPDistance,  MaxPPDistance, PPOnSameTrack, PPOnSameSurface, MaxPPsToUse, MinVariableValueToUse,MaxVariableValueToUse)

The rAVG function works like the hAVG function except that it will average values for all of the horses in a race, after the same function is run for each horse. For example, if you do an rAVG(“$ppSpeedFig”), internally the program will do an hAVG($ppSpeedFig) for each horse. Then the rAVG method will give you the average speed figure for all the horses in the race.

 

See the Parameters Section below for a description of the parameters used by this function.

 

Example:

Individually compare each speed figure in a Past Perf based Formula View against the average of all speed figures from all past performances of each horse in the race.  Display the result as the difference between the speed figure of a past performance and the average speed figure of all past perfs.

 

#hAVG(“$ppSpeedFig, 0, 1000, 0, 100, 0, 1, 10, 0, 1000) - $ppSpeedFig

 

In a past perf based view, each row in the spread sheet represents a past performance. This means that the variable $ppSpeedFig returns the value of the speed figure for that past performance. The hAVG function returns the average of all the speed figures in all the past performances irregardless of what row the function is being called from.  Thus, the results will display a positive number of the Speed Figure for the rows past performance was LESS than average, and a negative number if it was greater than average.

 

#hDEV(“Variable”, MinPPAge, MaxPPAge, MinPPDistance,  MaxPPDistance, PPOnSameTrack, PPOnSameSurface, MaxPPsToUse, MinVariableValueToUse,MaxVariableValueToUse)

This method returns the standard deviation of all values from the past performances of a horse where the value in question is specified by the particular “Variable” used.

 See the Parameters Section below for a description of the parameters used by this function.

 #rDEV(“Variable”, MinPPAge, MaxPPAge, MinPPDistance,  MaxPPDistance, PPOnSameTrack, PPOnSameSurface, MaxPPsToUse, MinVariableValueToUse,MaxVariableValueToUse)

 This method works like the hDEV function except that it works on ALL the past performance of ALL the horses in the race.

 

See the Parameters Section below for a description of the parameters used by this function.

 

#hMED(“Variable”, MinPPAge, MaxPPAge, MinPPDistance,  MaxPPDistance, PPOnSameTrack, PPOnSameSurface, MaxPPsToUse, MinVariableValueToUse,MaxVariableValueToUse)


This method works the same way hAVG works except that it returns the MEDIAN value instead of the average value.

See the Parameters Section below for a description of the parameters used by this function.

 #rMED(“Variable”, MinPPAge, MaxPPAge, MinPPDistance,  MaxPPDistance, PPOnSameTrack, PPOnSameSurface, MaxPPsToUse, MinVariableValueToUse,MaxVariableValueToUse)

 This method works the same as rAVG except that it returns the MEDIAN value instead of the average value.

See the Parameters Section below for a description of the parameters used by this function.

#hMIN(“Variable”, MinPPAge, MaxPPAge, MinPPDistance,  MaxPPDistance, PPOnSameTrack, PPOnSameSurface, MaxPPsToUse, MinVariableValueToUse,MaxVariableValueToUse)

This method returns the minimum value from the set of values obtained from each past performance of a horse. The value obtained is specified by the “Variable” parameter.

See the Parameters Section below for a description of the parameters used by this function.


Example:

Return the lowest speed figure from all the past performances of a horse:

#hMIN(“$ppSpeedFig”, 0, 1000, 0, 100, 0, 0, 10, 0, 1000)

#rMIN(“Variable”, MinPPAge, MaxPPAge, MinPPDistance,  MaxPPDistance, PPOnSameTrack, PPOnSameSurface, MaxPPsToUse, MinVariableValueToUse,MaxVariableValueToUse)

Works the same as hMIN except it returns the minimum value from ALL the past performances of all the horses.

See the Parameters Section below for a description of the parameters used by this function.

#hMAX(“Variable”, MinPPAge, MaxPPAge, MinPPDistance,  MaxPPDistance, PPOnSameTrack, PPOnSameSurface, MaxPPsToUse, MinVariableValueToUse,MaxVariableValueToUse)

  Works the same as the hMIN, except it returns the maximum value.

See the Parameters Section below for a description of the parameters used by this function.

#rMAX(“Variable”, MinPPAge, MaxPPAge, MinPPDistance,  MaxPPDistance, PPOnSameTrack, PPOnSameSurface, MaxPPsToUse, MinVariableValueToUse,MaxVariableValueToUse)

  Works the same as rMIN, except it returns the maximum value.

#COLRANK(ColumnNumber)

  This function will display the ranking of the value of the corresponding row in the column specified by the ColumnNumber ranking.

This column MUST appear  to the RIGHT of the column specified by ColumnNumber.

The first column that can be ranked is the SECOND column displayed in the view. Its ColumnNumber is 1. The first column itself is a non-rankable index column.

For example, you could have a column that displays the Speed Figure of a horse’s past performance. ($ppSpeedFig).  Lets say this column was column 2 in your view.  You could then have another column that you used to display the ranking of the speed figure value for the past performance.  You would do this for the expression for the new column: #COLRANK(2).

Then when your formula view was displayed you would see a column of speed figures AND a column that showed the ranking of the speed figure values next to it.   

#COLTOPGAP(ColumnNumber)

This function will return the difference between the value of the column specified by “ColumnNumber” and the highest (or lowest, depending on whether the column is ranked ascending or descending) value.

For example, you could have your second column display the $ppSpeedFig of each past performance.  You could then have another column that used the COLTOPGAP(2) function. This column would display the difference between the highest speed figure overall and the speed figure presented in each row.

  #COLNEXTGAP(ColumnNumber)

  This function works the same as  the COLTOPGAP function, except that it returns the difference between the value in each cell and the NEXT greatest (or lowest, depending on the ranking order) value.

  #COLVAL(ColumnNumber)

  This function gets the value of the column specified by ColumnNumber. It allows you to use the value of one column in the expression of a number.  ColumnNumber must be a column appearing to  the left of the column in which the #COLVAL function appears. ColumnNumber must be at least 1 - you cannot get the value of the first column (the automatic, text, column inserted into every Formula View).

  #COLMIN(ColumnNumber)  / #hCOLMIN

This function gets the minimum value appearing in the column specified. ColumnNumber must be a column appearing to the left of the column in which the COLMIN function is used. ColumnNumber must be at least 1 - you cannot get the value of the first column (the automatic, text column inserted into every Formula View).

The hCOLMIN version finds the min value for the values associated with the HORSE represented by the row in question.

  #COLMAX(ColumnNumber) / #hCOLMAX

This function gets the maximum value appearing in the column specified. ColumnNumber must be a column appearing to the left of the column in which the COLMAX function is used. ColumnNumber must be at least 1 - you cannot get the value of the first column (the automatic, text column inserted into every Formula View).

The hCOLMAX version finds the max value for the values associated with the HORSE represented by the row in question.

  #COLAVG(ColumnNumber) ./ #hCOLAVG

This function gets the average of all values appearing in the column specified. ColumnNumber must be a column appearing to the left of the column in which the COLAVG function is used. ColumnNumber must be at least 1 - you cannot get the value of the first column (the automatic, text column inserted into every Formula View).

The hCOLAVG version finds the avg value for the values associated with the HORSE represented by the row in question.

  #COLMED(ColumnNumber) / #hCOLMED

This function gets the median of all values appearing in the column specified. ColumnNumber must be a column appearing to the left of the column in which the COLMED function is used. ColumnNumber must be at least 1 - you cannot get the value of the first column (the automatic, text column inserted into every Formula View).

The hCOLMED version finds the median value for the values associated with the HORSE represented by the row in question.

  #COLDEV(ColumnNumber) /#hCOLDEV

This function gets the standard deviation of all values appearing in the column specified. ColumnNumber must be a column appearing to the left of the column in which the COLDEV function is used. ColumnNumber must be at least 1 - you cannot get the value of the first column (the automatic, text column inserted into every Formula View).

The hCOLDEV version finds the std deviation of values associated with the HORSE represented by the row in question.

  #COLADD(ColumnNumber) / #hCOLADD

This function gets adds all the values appearing in the column specified. ColumnNumber must be a column appearing to the left of the column in which the COLADD function is used. ColumnNumber must be at least 1 - you cannot get the value of the first column (the automatic, text column inserted into every Formula View).

The hCOLADD version adds the values associates with the HORSE represented by the row in question.

  #COLVALOFRANK(ColumnNumber,Rank)

This function gets the value of the field in the column specified that has the rank specified. NOTE - if there are ties in the ranking the rank you are looking for may not be available. For example, if the following values are present: 80, 80, 79, there will be no ranking of 2 since the rankings would be 1, 1, 3

#GREATER(Value or “Variable” or Function, Value or “Variable” or Function)

This function exists because the < and > operators will not work in the Formula View.  It takes TWO  parameters that can be a specific value (5), a variable that is surrounded by quotes (“$ppSpeedFig”), or a function .

  The function returns 1 if the FIRST value is greater than the second. Otherwise it returns 0.

#LESSER(Value or “Variable” or Function, Value or “Variable” or Function)

  Works the same as GREATER except it returns 1 if the FIRST value is less than the second value.

#EQUAL(Value or “Variable” or Function, Value or “Variable” or Function, Accuracy)

Compares the two values for equality, returning 1 if equal otherwise 0.  The third parameter, Accuracy, allows you to define to what degree the two values must be equal. A default value of .00001 is supplied.


PARAMETERS for the Add, Avg, Dev, Med, Min, and Max

“Variable” :  the name of the variable that you would like to use in this function. This MUST be surrounded by quotes. NOTE that the variable name does NOT have the $ preceeding it. (“ppSpeedFig”)

You may alternatively pass a function as this parameter. The function would then add the results of the values returned by the function passed into it.

  MinPPAge: The minimum age, in days passed since the upcoming race, of the past performance. If a past performance is “too young” it will not be used by the function.

  MaxPPAge: The maximum age, in days passed since the upcoming race, of the past performance. If a past performance is “too old” it will not be used by the function.

  MinPPDistance: The minimum distance of a past performance, in furlongs. If a past performance is too short it will not be used by the function.   Note - be careful with exact distances.  If the minimum distance you want is something like 8 furlongs, you should use 7.9 to avoid problems with comparing floating point numbers.

  MaxPPDistance: The maximum distance of a past performance, in furlongs. If a past performance is too long it will not be used by the function.  Note - be careful with exact distances.  If the max distance you want is something like 8 furlongs, you should use 8.1 to avoid problems with comparing floating point numbers.

  PPOnSameTrack: If the value of this parameter is 1, only past performances run at the same track as the upcoming race will be used by the function.

  PPOnSameSurface: If the value of this parameter is 1, only past performances run on the same surface as the upcoming race will be used by the function.

  MaxPPsToUse: This parameter is a number that specifies the maximum number of past performances, starting from the most recent past performance, the function can use.

  MinVariableValueToUse: This parameter lets you specify the minimum acceptable value returned from a variable in a past performance. For example, perhaps you are looking for some information about the Standard Deviation of the speed figures for all the horses in a race. But, you are leary that a bogus value might come into your formula due to a horse being pulled up, or some problem with the data card. If you set the MinVariableValueToUse as 1, then any past performances that had speed figures of 0 would be ignored.

  MinVariableValueToUse: Works the same as the MinVariableValueToUse function except you specify the maximum value that should be considered valid and useable by the function.