Daily Ratings/Rankings

Samples developed by Cymatic and others. Please share your spreadsheets here.
Forum rules
Users can post their spreadsheets here, to share with others and for discussion purposes.
If you download a spreadsheet from here, please carefully test any strategies yourself before using it with real money. Cymatic accepts no liability for any spreadsheets in this forum.
Now bring on the robots! Happy automated trading... :)

Daily Ratings/Rankings

Postby nig299 » Thu Aug 06, 2015 10:49 pm

I've seen a few posts where people are asking for something along the lines of the above.

Hopefully, these spreadsheet will go someway to addressing this. File to big to post here, (even with zipping). So here is the dropbox link for horse racing 06/08/15

https://www.dropbox.com/s/la3fsrh781gas ... .xlsm?dl=0

and the link for racing 07/08/15

https://www.dropbox.com/s/gg2owwullqx8e ... .xlsm?dl=0


and the link to the readme.

https://www.dropbox.com/s/emgu7i6xmg52j ... .docx?dl=0


They do contain a small macro, so don't be worried if a warning message pops up.
I intend to post a sheet daily for each days ratings, and any suggestions/feedback will be welcome.
nig299
 
Posts: 99
Joined: Thu Nov 28, 2013 2:07 am

Re: Daily Ratings/Rankings

Postby nig299 » Fri Aug 07, 2015 9:21 pm

Link for the Daily Ratings/Rankings for racing Saturday 08/08/15

https://www.dropbox.com/s/lblhkkbf5t3co ... .xlsm?dl=0
nig299
 
Posts: 99
Joined: Thu Nov 28, 2013 2:07 am

Re: Daily Ratings/Rankings

Postby nig299 » Sat Aug 08, 2015 11:39 pm

Link for the Daily Ratings/Rankings for racing Sunday 09/08/15

https://www.dropbox.com/s/q5y278gr04rwf ... .xlsm?dl=0

You'll see a couple of changes, I've added two more paramaters (weight lbs and course record), and separated the win and place % and added and included an overall % on which the rankings are now based.
nig299
 
Posts: 99
Joined: Thu Nov 28, 2013 2:07 am

Re: Daily Ratings/Rankings

Postby nig299 » Tue Aug 11, 2015 8:00 am

Link for the Daily Ratings/Rankings for racing Tuesday 11/08/15

https://www.dropbox.com/s/abjogo7pfi696 ... .xlsm?dl=0
nig299
 
Posts: 99
Joined: Thu Nov 28, 2013 2:07 am

Re: Daily Ratings/Rankings

Postby nig299 » Tue Aug 11, 2015 11:50 pm

Link for the Daily Ratings/Rankings for racing Wednesday 12/08/15

https://www.dropbox.com/s/h7t4348g70mwn ... .xlsm?dl=0

Don't forget, the rankings shown are only for example. Have you tried creating your own?
nig299
 
Posts: 99
Joined: Thu Nov 28, 2013 2:07 am

Re: Daily Ratings/Rankings

Postby Gavin » Wed Aug 12, 2015 12:29 am

Good work nig299 :)
User avatar
Gavin
Site Admin
 
Posts: 3832
Joined: Wed Jan 23, 2013 9:11 pm
Location: United Kingdom

Re: Daily Ratings/Rankings

Postby nig299 » Wed Aug 12, 2015 11:47 pm

Link for the Daily Ratings/Rankings for racing Thursday 13/08/15

https://www.dropbox.com/s/nq376bhf50n5o ... .xlsm?dl=0
nig299
 
Posts: 99
Joined: Thu Nov 28, 2013 2:07 am

Re: Daily Ratings/Rankings

Postby nig299 » Thu Aug 13, 2015 10:17 pm

Link for the Daily Ratings/Rankings for racing Friday 14/08/15

https://www.dropbox.com/s/l5h8t4cd6kc61 ... .xlsm?dl=0
nig299
 
Posts: 99
Joined: Thu Nov 28, 2013 2:07 am

Re: Daily Ratings/Rankings

Postby nig299 » Fri Aug 14, 2015 9:26 pm

Creating my own ratings (see attached) using the sheet supplied. Encouraging results with the favs but a few things need to be sorted. (Rankings and results are shown with the fav being highlighted in orange).

Needs a bit of tweaking with regards to the ratings and how many paramaters are assessed.

For example the 5:40 at Catterick, one paramater cannot be assessed, (weight,insufficient info), but still quite reliable as it shows the fav ranked 5th, and it came 2nd at 11/4, Similarly, the 2:40 at Nottingham, one paramater cannot be assessed, (distance,insufficient info), fav ranked 11th, placed 6th at 3/1

However, if 2 or more paramaters cannot be assessed, (and this is where it needs tweaking), a horse is still ranked, but shouldn't be. The 8:05 at Newmarket and the 03:00 at Newcastle for instance. My way of thinking is that if you have insufficient info then it can't be acted upon.

There is a difference between "-" and zero. A "-" means insufficient info and a zero means that the horse has been assessed, but according to the ratings, it's just not very good at that particular paramater.
You do not have the required permissions to view the files attached to this post.
nig299
 
Posts: 99
Joined: Thu Nov 28, 2013 2:07 am

Re: Daily Ratings/Rankings

Postby nig299 » Sat Aug 15, 2015 12:20 am

Link for the Daily Ratings/Rankings for racing Saturday 15/08/15

https://www.dropbox.com/s/7936rib8vg592 ... .xlsm?dl=0

and list of my rankings for the same date.

Rankings 15_08_15.xlsx
You do not have the required permissions to view the files attached to this post.
nig299
 
Posts: 99
Joined: Thu Nov 28, 2013 2:07 am

Next

Return to Excel - Sample Spreadsheets

Who is online

Users browsing this forum: No registered users and 0 guests

cron