Calling Shaun

[Try Try Again]

Hi Shaun,

I had a look at your rating of various form information on a 10, 8, 6, 4, 2 basis and totaling for each horse to give an overall rating. It certainly zeroes in on the main chances and not always the prepost favourite. At Caulfield the top rated (on my 11 form factors) gave Magnifique Soliel, Stratcombe and Classy Chloe.

When you calculate your odds are you totaling all the ratings for the race and dividing by each horse's individual rating to give a price? Or do you have another approach?

I would have thought that if you calculated the price (as above) the favourites price would always be quite high. Do you agree?

[Shaun]

Once i have a rated market this is the process i use to create a price, works great with the ratings i am using.

http://www.racebase.co.nz/market.htm

Not sure if you have downloaded any of the sheets i use.

[Try Try Again]

Hi Shaun,

That's some very detailed information - well done and a bit further advanced than I am with Excel!

I only used information from the Sportsman to put together a simple approach to your rating system.

I'll run up some prices based on my figures and see how they "look".

Thanks for the prompt reply.

[Shaun]

Np, take a look at that site i have found it one of the best ways to price a market.

[evajb001]

I use that same site to provide the odds on my points based ratings as well. I've only recently started using my spreadsheet again since putting it together last spring carnival. I've given it a bit of a facelift and adjusted some of the scoring recently which seems to have improved the ratings.

I've also added to mine an indicator that shows when a horse is a 'SPECIAL' bet due to certain system criteria being met and it being in my top 5 ratings. I started backtesting this last night on previous races i'd completed ratings on and so far there were 20 'SPECIAL' bets placed for 8 winners and 6 place getters. I didn't have time to work out the POT or winnings but seems like the odds varied from $1.80 through to $7 on the winners.

I'll start to post my ratings again in an old thread i created for interest's sake. Although Shaun are you able to help me get cells from excel to paste into the forum better?

Note my spreadsheet is not automated, but is a pretty simple copy/paste of form from ozeform and takes me about 1-2 mins per race.

[Shaun]

I think i used ozeform a few years a go, the key to automating any input is some type of url that can be manipulated such as a numbered system or the ability to import a page with a list of urls, that can be used with a look up feature.

I have a handy bit of code that will display urls in text form so they can be used to open webpage.

Formatting to forum has always been an issue, 2 ways i can do it is copy your info you need displayed in to a text document like note pad the align everything manully.

Or you can use a list feature in BBcode and paste it to the forum, but it need to be suited to this forum.

example, this is not suited but gives an idea.

here is the code





Mackay Race 5 (http://www.tabonline.com.au/2012/05/15/QR05.html)
Hillross Mackay Plate (C6)
$12000
Class 6


No Horse
Rated Price
Win
Place


5. Il Cardinale
$2.89




8. Hussana
$3.08




9. Massuri
$3.08




4. Heritage Star
$10.29




3. Sir Nick
$11.91







Mackay Race 6 (http://www.tabonline.com.au/2012/05/15/QR06.html)
A1 Battery Pro Plate
$50000
Open


No Horse
Rated Price
Win
Place


2. Blackjack Davey
$2.50




3. Maximum Command
$4.36




1. Craiglea Tequila
$4.70




7. Craiglea Carina
$5.98




8. Avaladyluck
$5.98







Mackay Race 7 (http://www.tabonline.com.au/2012/05/15/QR07.html)
Affordable Rv Transport Hcp-C2
$10000
Class 2


No Horse
Rated Price
Win
Place


9. Sweet Vamp
$1.93




8. Sheza Falvelon
$3.88




12. Craiglea Marlena
$5.33




1. Brother Bob
$7.97




3. Jazzshinko
$11.29







Mackay Race 8 (http://www.tabonline.com.au/2012/05/15/QR08.html)
B B Print (Bm79)
$10000
Benchmark 79


No Horse
Rated Price
Win
Place


9. You Done It Again
$2.82




5. Impala
$3.47




1. Jad
$4.81




4. Pegunny Roy
$5.83




3. Carmenator
$6.47






If you learn this stuff for this forum you can add it to an excel sheet that links to your info so it automatically prints it out, you then just need to copy pate it.

I did have some formatted for the forum some time ago but changed it to suit other needs.

[Lord Greystoke]

Hi Shaun,

took a quick look at that link and also your XL file(hope you dont mind?) - it opens ok but I keep getting following error message...

Run-time error '438'

Object doesn't support this property or method.

Any ideas what might be happening here??


Cheers LG