ThoroTech    ThoroTech Racing    ThoroTech Racing  Hop To Forum Categories  EquiSim - Using    fv formula
Go
New
Find
Notify
Tools
Reply
  
fv formula
 Login/Join 
ALWN1X
Posted
Could someone write a fv formula showing;
The number of races from the total number of form past performances, that were within 1 length of winner including the wins?
THANKS,
THORNY
 
Posts: 22 | Registered: October 07, 2008Reply With QuoteReport This Post
Graded Stakes
Posted Hide Post
Here you go Thorny

This is for a Horse type template which your question suggests you want.

This will give you the raw number as you requested:

#hADDExt("ppFinish", 0, 10000, 0, 50, 0, 0, 10, 0, 10000, 1, 1)+
Abs($ppFinish[0]>1 and $ppBtnLengthsFinish[0]<=1) +
Abs($ppFinish[1]>1 and $ppBtnLengthsFinish[1]<=1) +
Abs($ppFinish[2]>1 and $ppBtnLengthsFinish[2]<=1) +
Abs($ppFinish[3]>1 and $ppBtnLengthsFinish[3]<=1) +
Abs($ppFinish[4]>1 and $ppBtnLengthsFinish[4]<=1) +
Abs($ppFinish[5]>1 and $ppBtnLengthsFinish[5]<=1) +
Abs($ppFinish[6]>1 and $ppBtnLengthsFinish[6]<=1) +
Abs($ppFinish[7]>1 and $ppBtnLengthsFinish[7]<=1) +
Abs($ppFinish[8]>1 and $ppBtnLengthsFinish[8]<=1) +
Abs($ppFinish[9]>1 and $ppBtnLengthsFinish[9]<=1)

This puts it in the form of the number as a percentage of the horses running lines (just added the divisor).
This may be more revealing because, for example, 2 wins or finishes within 1 length for a runner with 4 starts is likely more meaningful than a horse that accomplished the same from 10 starts.

(#hADDExt("ppFinish", 0, 10000, 0, 50, 0, 0, 10, 0, 10000, 1, 1)+
Abs($ppFinish[0]>1 and $ppBtnLengthsFinish[0]<=1) +
Abs($ppFinish[1]>1 and $ppBtnLengthsFinish[1]<=1) +
Abs($ppFinish[2]>1 and $ppBtnLengthsFinish[2]<=1) +
Abs($ppFinish[3]>1 and $ppBtnLengthsFinish[3]<=1) +
Abs($ppFinish[4]>1 and $ppBtnLengthsFinish[4]<=1) +
Abs($ppFinish[5]>1 and $ppBtnLengthsFinish[5]<=1) +
Abs($ppFinish[6]>1 and $ppBtnLengthsFinish[6]<=1) +
Abs($ppFinish[7]>1 and $ppBtnLengthsFinish[7]<=1) +
Abs($ppFinish[8]>1 and $ppBtnLengthsFinish[8]<=1) +
Abs($ppFinish[9]>1 and $ppBtnLengthsFinish[9]<=1)) /
(Abs($hrRaces>9) * 10 + Abs($hrRaces<10) * $hrRaces + 0.0000000001)
 
Posts: 62 | Location: Lehigh Valley, PA | Registered: August 12, 2002Reply With QuoteReport This Post
ALWN1X
Posted Hide Post
THANKS, SMICK
I do apppreciate the help!
 
Posts: 22 | Registered: October 07, 2008Reply With QuoteReport This Post
  Powered by Social Strata  
 

ThoroTech    ThoroTech Racing    ThoroTech Racing  Hop To Forum Categories  EquiSim - Using    fv formula

© 2002