OZmium Sports Betting and Horse Racing Forums

5th April 2022, 11:52 AM

Unstable

Member

Join Date: Mar 2022

Posts: 20

Quote:

Originally Posted by Shaun

Not sure this will help you but the way i use to rate races was like this, each class from my perceived lowest to highest was give a number like this.
G1 3
GROUP1 3
GP1 3
G2 5
GROUP2 5
GP2 5
GP2 5
G3 7
GROUP3 7
GP3 7
Listed 9
LR 9
Quality 10
Open 12
HCP 12
HANDICAP 12
100 12
96 13
95 13
94 13
93 13
92 13
91 13
90 13
Class 6 13
Cl6 13
C6 13
3MW 15
2MW 15
WELTER 16
Flying 16
90 18
89 18
88 18
87 18
86 18
85 18
1MW 18
0MW 18
One Metro Win 18
No Metro Wins 18
Set Weights plus Penalties 20
Class 5 21
Cl5 21
C5 21
84 21
83 21
82 21
81 21
80 21
79 21
78 24
77 24
76 24
75 24
74 24
73 24
72 24
71 24
Class 4 25
Cl4 25
C4 25
Class 3 27
Cl3 27
C3 27
70 30
69 30
68 30
67 30
66 30
65 30
64 32
63 32
62 32
61 32
60 32
59 32
Class 2 34
Cl2 34
C2 34
Class 1 36
Cl1 36
C1 36
58 39
57 39
56 39
55 39
54 39
53 39
52 39
51 39
50 39
MAIDEN 42
MDN 42

I also included these special penalties.

3Y 5
3YO 5
3F 5
2Y 8
2YO 8
2F 8
FM 3
MARES 3
F&M 3
C&G 3
CG&E 3
WFA -2

I also used this race value component.
IF(AU3="","",IF(AU3<10000,14,IF(AU3<25000,12,IF(AU3<40000,10,IF(AU3<70000,6,0)))))

So if the last race was 50k Open it would get a score of 18
If todays race was a 75k Open the score would be 12
I would calculate 18-12 to get 6, the lower the better

Hi Shaun,

I am very new to this forum, I am a full time Horse Racing Analysis. I'm retired and can spend more time on my projects and Systems.

I was given your Consensus speadsheet from a friend. I would love to discuss the spreadsheet and it's workings a little more in detail, I think it is a great spreadsheet and you shure have a gift.

I was a member of cyberhorse forum many years ago, it was manly for Bet Selector Users, as usual, a lot of bad and insulting post spoilt the forum and it stopped.

I did a Class Rating some years ago, members may be interested in.

It was based on Benchmark ratings, for example, Benchmark 58 would be Rated a 58, it was to gauge the actual official Handicap of the horse.

If you looked at a horse's official Hcp and deducted the Benchmark or Class as listed below, you could get an indication of the Race strength.

Code:

Class B	45
Class 1	        58
Class 2	        64
Class 3	        66
Class 4	        70
Class 5	        76
Class 6	        80
Benchmark 58	58
Benchmark 58+	58
Benchmark 59	59
Benchmark 60	60
Benchmark 60+	60
Benchmark 61	61
Benchmark 62	62
Benchmark 62+	62
Open	        80
Listed Race     105
Group III       110
Group II        118
Group I	        125

You will see in this table, Class 1 =BM58 to Group I 125 as well.

Just another way of looking at Class Ratings.

Last edited by Unstable : 5th April 2022 at 11:56 AM.

5th April 2022, 03:22 PM

Shaun

Member

Join Date: Jan 1970

Location: Western Australia

Posts: 3,403

My original ratings were started from the cyberhorse VFG, buck then i would copy and paste the data to excel before i started to use vba to import data.

I now use python to import the same data from the TAB.
The ratings i listed may look a little strange as they are used to look up this data from imported form, i have always had issues with comparing country, provincial and metro form, incorporating the race prizemoney helps.

__________________
One Drive

"If the corporates are treating you poorly , just go elsewhere."
"If they need you , they will soon find out."
"If you need them , you will soon find out." --moeee
_______________________________________________

5th April 2022, 04:06 PM

Unstable

Member

Join Date: Mar 2022

Posts: 20

I agree Shaun, prize$ is a good indicator to Race Class. My point is this, a horse 14 days ago, ran in a BM64 Ballarat, $35,000.Today the horse is at Hamilton, BM64 $35,000. Has the horse gone up in class or not?

The Ballarat race had an average HCP of 63.9 (SUM all horses HCP/Field size).

The Hamilton race had an average HCP of 61.1.

Looking at those figures, the horse is going down in Class but still in a BM64 race.

I would think a Country Bm64 would have a Average of around 59 in most cases.

6th April 2022, 04:00 PM

Chrome Prince Chrome Prince is offline

Member

Join Date: Jan 1970

Posts: 4,437

Thanks for all the input guys, it gives me some indication of where to start.

Quote:

"I agree Shaun, prize$ is a good indicator to Race Class. My point is this, a horse 14 days ago, ran in a BM64 Ballarat, $35,000.Today the horse is at Hamilton, BM64 $35,000. Has the horse gone up in class or not?"

My way around this is to look at the average career prizemoney of all runners (add them up and divide by the number of runners to give you a figure) and compare them, because many times race prizemoney will steer you wrong, in other words,

__________________
RaceCensus - powerful system testing software.
Now with over 426,000 Metropolitan, Provincial and Country races!
http://www.propun.com.au/horse_raci...ng_systems.html
*RaceCensus now updated to 31/10/2025
Video overview of RaceCensus here:
http://www.youtube.com/watch?v=W821YP_b0Pg

7th April 2022, 09:53 AM

Unstable

Member

Join Date: Mar 2022

Posts: 20

Python

Quote:

Originally Posted by Shaun

Hi Shaun,

I read you are using python, can you recommend a free web site that is good to learn from?

I have done small bits and pieces of python but I'm not advanced by any means, any help would be much appreciated.

Unstable

7th April 2022, 06:44 PM

Shaun

Member

Join Date: Jan 1970

Location: Western Australia

Posts: 3,403

Quote:

Originally Posted by Unstable

This channel has some good stuff in small amounts so easy to follow.
https://www.youtube.com/c/Codemycom

7th April 2022, 06:59 PM

Unstable

Member

Join Date: Mar 2022

Posts: 20

Pyton

Thanks Shaun,

Also, I have your wonderful Impact Ratings SS, I have added my New Ratings to macro, however, the Prices sheet, give a error #REF! New Ratings will not load to the RacePage.

Code:

New Ratings					
Rating				Rated %	Rated Price
#REF!	#REF!	#REF!	#REF!	#REF!	#REF!
#REF!	#REF!	2.00%	#REF!	#REF!	#REF!
#REF!	#REF!	#REF!	#REF!	#REF!	#REF!
#REF!	#REF!	#REF!	#REF!	#REF!	#REF!
#REF!	#REF!	#REF!	#REF!	#REF!	#REF!
#REF!	#REF!	2.00%	#REF!	#REF!	#REF!
#REF!	#REF!	#REF!	#REF!	#REF!	#REF!

I know it's been a while since you created the SS, are you still using it?

7th April 2022, 07:56 PM

Shaun

Member

Join Date: Jan 1970

Location: Western Australia

Posts: 3,403

Quote:

Originally Posted by Unstable

Thanks Shaun,

Also, I have your wonderful Impact Ratings SS, I have added my New Ratings to macro, however, the Prices sheet, give a error #REF! New Ratings will not load to the RacePage.

Code:

New Ratings					
Rating				Rated %	Rated Price
#REF!	#REF!	#REF!	#REF!	#REF!	#REF!
#REF!	#REF!	2.00%	#REF!	#REF!	#REF!
#REF!	#REF!	#REF!	#REF!	#REF!	#REF!
#REF!	#REF!	#REF!	#REF!	#REF!	#REF!
#REF!	#REF!	#REF!	#REF!	#REF!	#REF!
#REF!	#REF!	2.00%	#REF!	#REF!	#REF!
#REF!	#REF!	#REF!	#REF!	#REF!	#REF!

I know it's been a while since you created the SS, are you still using it?

It would rely on the old Qtab site, that no longer works, with python you can access the JSON data from the TAB

7th April 2022, 08:19 PM

Unstable

Member

Join Date: Mar 2022

Posts: 20

Pyton

Okay thanks Shaun

Thread Tools	Search this Thread
Show Printable Version Email this Page	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Hybrid Mode Switch to Threaded Mode

	To advertise on these forums, e-mail us.