Using race times to compile figures

0 votes
Hi - Thinking of buying smartform

I manually calculate jump times extrapolating from previous races & going & use a length for weight/going formula to assess the quickest horses in the race (to narrow the field - hard to explain lol) - My question is

Can racetimes/going/distances etc all be exported from a set historical period & then a formula run through them to produce in effect a speed rating (or in my case a list of expected times) ?

I have another question but will put  up separately

Many thanks
asked Mar 6, 2017 in Smartform by craigdh34 Plater (170 points)

1 Answer

0 votes
 
Best answer

Hi

 

It's basically one answer to both your questions ...

 

What you get with Smartform is data - a MySQL database to be specific. There are four main tables in it. "Historic races" and "Historic runners" give full details of all past UK and Irish races, and individual runner performances within them, going back at least 10 years. "Daily races" and "Daily runners" give details for declarations made before races are run. Both are updated overnight - the 'historic' tables with the previous day's results and the 'daily' tables with the following day's declarations.

 

What you don't get is any kind of graphical user interface / dashboard / control panel for querying the data. It's not that kind of service. It's designed for people who purely want the data to use as an input to their own programs, solutions and analyses.

 

You can therefore do virtually anything with the data. All of the analyses and extracts that you ask about are completely feasible. The only limitation is your own programming and analytical skills. These will need to begin in MySQL but extend to whatever other products you intend to use.

 

For what it's worth I use MySQL Workbench (open source GUI for MySQL) to manage the database, a combination of R and MS Excel for my data analysis, and a bot written in MS Visual Basic to automate my Betfair betting.

 

For what it's worth I can heartily recommend the Smartform data service and have subscribed to it for several years now.

 

Good luck

answered Mar 6, 2017 by SlightReturn Listed class (2,850 points)
...