I want to look at each race and find the 3 individual horses with best TG#, 2nd best TG# and 3rd best TG # and then run a query and find out what percentage of races they win. You can exclude maiden races because there may be lots of FTS. Also, I would only look at the horses last 5 starts and would go back no more than 1yr. He can also break it down to sprints, routes, turf, and dirt.
Thus:
top tg horse based on last 5 races within 1 yr: what % of them win.
2nd best tg horse based on last 5 races within 1yr, what is their winning %
3rd best TG horse based on last 5 races within 1 yr, what is their winning %.
Then you would add these three #\'s.
I know there will be ties. I would consider # within 1/4 pt of each other as equivalent.
I really don\'t want and exact # like 68.5% but is it 60%, 70%, 80%? You don\'t have to do the distance/surface breakdown if it\'s too much work. But if the top 3 TG horses win 80% of races then you can just play thoses races in which they look strong or use some other filters.