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.

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


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,

Python
 

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

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

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.



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

Pyton
 

Okay thanks Shaun

Unstable, a question, maybe a dumb one.

Do you mean that you add up all the different weights of the horses in a handicap race and then divide by the number of horses?

Also is that before or after scratchings?

Thanks

Hi Peter, I could be wrong here, but I think he means the handicap rating, not the weights carried.

free turorial python
 

try
tutorialspoint,com.python/index.html
that gives examples of the language elements.
i have not tried:
learnpython.org,
freecodecamp.org
i might have used:
pythonguides.com
The best books are from O'Reilly
the cookbooks are good as is Python in a nutshell
Zed Shaw Learn Python The Hard Way third ed gives you a good intro with exercises
HTH