[arauch]

Hi,

I am german racing fan who is new to this forum. I have been particularly interested in French racing for a while. However I quickly noticed that resarching form is very cumbersome since data is not as easily available as for UK
races.

Therefore I set our to build my own database, thinking this might easily give me an
edge over other punters. This database contains all french race results since January
2015. Buildig on this database I created a dashboard in Excel (using thousands of lines of code in sql) which helps me analyse races in detail. One major advantage is that I do not have to click 1000 of times to get all info but have it all available in one excel file.

To give you a quick idea. the dashboard contains all typical info that you can also find elsewhere (race conditions, runners, jockey, trainer, weight, draw etc.). But it also contains detailed information that can really give you an edge in your bets.

More specifically the dashboard contains:

*Horse data: e.g.results in the last 365 days, results on todays going, course, distance, today’s jockey-

*Ratings: I do individual ratings for french races (like for example racing post ratings). The scale relates not to the UK official ratings scale but to the french valeur rating scale

*trainer stats: trainer results in the last year, trainer form (last 15 runs), results on today’s course, class, racetype (seller, handicap etc.) agetype.

*jockey stats: jockey stats in the last year, jockey form (last 15 runs), results on today#s course,

*trainer-jockey combination stats

*forecasted odds based on a regression model

*sire stats: results since Jan 2015, median earning per run of sire’s runners, median

*rating os sire’s runners, going preferences of progeny

*damsire stats: see sire stats

*draw stats for particular draws on the course of the rase

*horse performance info for each of last 5 outings of the horse: race conditions, rating (my calculation), speed rating (my calucation), postion/runners, lenghtsback, sp, form frank stats (i.e. which runner in the race did run sine and how did it do), detailed results of the first 6, information how the horse performed in comparison to an opponent in today’s race (if the opponent has also run in that race), comments in running (these are currently in french and by Paris turf – for copyright reasons these will not be part of the commercial version, I plan to do English comments in running myself)

*performance stats of the horse’s last run on today’s course/going

*Links to the video replays provided by france galop (registration free, if the link does not work please read comment in excel)

I am doing these dashboards for a while now. And they help me a lot. If I have the time to use them I make an average 15 percent ROI (I only bet win only). However,since I have a time-consuming job I cannot use it as much as I want to. Still I am producing these dashboards nearly every day. That is why I was thinking that my dashbboards might be useful to someone else

If you are interested, please check out the link below. Unfortunately, you need MS excel to view it. It shows one dashboard for the 5th race in Pornichet on 9.11.17. For optimal viewing you need to download instead of viewing it online and put the zoom to about 160%. I provided detailed explanations as comments in the cells which you can see b< hovering over the cell

https://www.dropbox.com/s/z9iijw63lvossgh/09-11-2017%20Pornichet%20Race5.xlsx?dl=0

If you are interested in daily versions of the dashboard for each major rracecard in France please drop me a message. I will put you an a list and inform you when I plan to go live with the daily dashboard. Also pleas indicate your what your willingness to pay would be for one excel doc incl. 8 to 16 races of any particular day.

I plan to “go live” with the daily dashboard in January 2018 – in case enough people are interested in purchasing it.

I also welcome any feedback what you think of the dashboard and help me further improve it. Also please share the excel to anyone who might be interested.

Best

[Author]

Posts