Help Required - You Get A Bonus

[Chrome Prince]

This is a serious request for help from someone that has a database which is able to print out every Metropolitan race in 2004.

What is needed is an excel spreadsheet of all horses that had a spell of more than 30 days but are NOT first starters.

Here's the tricky part, if the horse has had a spell of more than thirty days, I need the prizemoney WON, last time it was first up after 30 days or if it was it's first start.

Failing that, I need the horse's average prizemoney WON first up only over all first up starts. I'm sure there are people out there that can help me.

So I'd need it in excel format with columns:

DATE TRACK RACE TAB HORSE (PRIZEMONEY WON FIRST UP LAST TIME)

or

DATE TRACK RACE TAB HORSE (AVERAGE PRIZEMONEY WON FIRST UP)

I have been working out a ratings method that I'm only willing to share as compensation to the person that can help me with what I need.

This is not some dark lure to get someone to pay for something, if they can genuinely give me what I want, I'm prepared to offer my ratings method for FREE to that person only.

A BRIEF SYNOPSIS

Public results for favourites for 2004
30.10% Strike Rate
-14.44% LOT

My initial ratings based on my rated top pick (favourite) for 2004
20.95% Strike Rate
-13.68% LOT

Note the small improvement on loss, BUT I have not factored in horses first up at all!
Therefore, I'm confident that I can greatly improve the results by rating the first up horses which were not even in the equation or given a nil rating.

Examples:
Ascot 1/1/2004 Josie's Show first up would be rated favourite given the rest of the field strength and won paying $7.40 (this is a further winner to my results)
Eagle Farm 1/1/2004 Show Poker first up would be rated third favourite and won paying $21.20
Eagle Farm 1/1/2004 Royal Shiraz first up would be rated favourite and won paying $2.40

Note: I'll only give this to the person that helps because it will take me months to complete manually, so please no fishing.

Thanks in advance.

[Adrian]

If you are able to provide an XL sheet containg a sample of say 50 rows of data (but obviously containing results of say 5 to 10 horses), I will see what I can do. I really need to see the exact format of your data before I can assist with a potential solution.

It should be a relatively easy task to get XL do a sort and get a few formulae running to help you out.

If you have the ability to add the horses for a race meeting yet to be run as a "blank" row containing a horse's name, race date etc. , I think I can get it to spit out the selections for you.

Cheers,
Adrian.

[Chrome Prince]

Hi Adrian,

Thanks for the reply, I think we are on the wrong track here.
I don't need a formula to extract data, I need the data.

What I need are the horses that have had a break of more than 30 days and the prizemoney they won last time they had a similar break and were first up.

[marcus25]

[QUOTE=Chrome Prince]This is a serious request for help from someone that has a database which is able to print out every Metropolitan race in 2004.


Hi Chrome!
If no one else can supply the data you want, I can do it for you but it will take a few days because I am busy at the moment, and would have to write a few lines of code to extract the records you want.
I can save it in Excel for you.
Your kind offer is a lot more then some people offered in the past for sometimes quite serious programming.
But please don't take it the wrong way, I have my own rating which has been working very nicely for the last few years and any new idea just may confuse me.
Let me know if you want me to go ahead!

Cheers!

[laish]

Hey there CP,

Rules I applied ,

Venue: SMBAW
Career Starts: 1 +
Days to Last Start: 30 +
Runs this Preparation: 0
Last Start Finish Posn: 1

I have enclosed an example sheet for you to look at. This is just to show what I can give you, not actuals.

I have the data for ALL metros last year, I am missing a couple I think but close enough maybe.

Also I will also need a couple of days to upload all data for the spreadsheet, so mail me at laish at optusnet dot com dot au and I can let you know and send it when ready if you like.

[Chrome Prince]

Thankyou Marcus,

Your offer is greatly appreciated.
As you are busy for a few days, I'll see if anyone else can help, otherwise I'll post back for your assistance.

There's no worries if you have your own successful ratings, perhaps I can help you out in return in some other way. We can discuss that later.

Thanks again.

[Chrome Prince]

Hey there CP,

Rules I applied ,

Venue: SMBAW
Career Starts: 1 +
Days to Last Start: 30 +
Runs this Preparation: 0
Last Start Finish Posn: 1

I have enclosed an example sheet for you to look at. This is just to show what I can give you, not actuals.

I have the data for ALL metros last year, I am missing a couple I think but close enough maybe.

Also I will also need a couple of days to upload all data for the spreadsheet, so mail me at laish at optusnet dot com dot au and I can let you know and send it when ready if you like.

Hi Laish,

Thanks for the effort, greatly appreciated.

I know it's just an example, but I need the horse prizemoney won, not the race prizemoney and not that the horse was a winner per se.

So you should output prizemoney won by the horse (whether it's $0 or $800 or $100,000)

Your initial rules would be

Venue: SMBAW
Career Starts: 1 +
Days to Last Start: 30 +
Runs this Preparation: 0
Last Start Finish Posn: 1 +

And I would need it for the horse last career first up not current race.

Thankyou.

[laish]

Hey CP, The 1st 2nd etc was just if yu wanted them, but can be ommitted. The prize was supposed to be horse but does seem to be race, will work on looking fr it for ya, I will post here if I hav it all organised. Catch ya then.

Laish

[Chrome Prince]

Thankyou laish,

When we get it sorted, I'm quite prepared to share my method with you.

A -13% POT is pretty damn good when I haven't included the win dividends for first uppers (as they are not rated yet), but have included the outlay!

[KennyVictor]

Not sure if you got your stats or not Chrome. If not I can probably provide what you need. If you still need them could you just post a list of the tracks you want as I'm not 100% sure which ones they are.

KV

[laish]

Hy CP, her is th info in spreadsheet for ya. So far I have not been able to resolve the dilema where the prizemoney is for race not horse so it may not even be helpful at all, also it seems I may be missing more dates than I thought.

If it is helpfull then good, if not then sorry but here it is just in case.
Laish

Also to let all know it lwet me only do 19k the other day today it let me do 68k. who knows?

[laish]

Just workd it out I can get you avg prizemoney by horse, maybe even total (maybe not though), if you still wish it all redone (not a prob if so) then email me at laish at optusnet dot com dot au

[KennyVictor]

Hell, I've written the program I may as well send the data.
This should cover Flemington, Caulfield, Eagle Farm, Moonee Valley, Randwick, Rosehill Gardens, Cantbury, W Farm, Ascot and Belmont. The only data missing will be the odd TAB number because I keep my Tab data and results in different files which need to match horse names to sync with each other. It's a comma delimited CSV file, easy enough to read into excel.
If the format's right and you want other tracks let me know. If it's crap, ah well, I had a try.

Don't feel obliged to share your system with me, you and others on this forum provide inspiration enough, no other rewards needed.

KV

[Chrome Prince]

Hell, I've written the program I may as well send the data.
This should cover Flemington, Caulfield, Eagle Farm, Moonee Valley, Randwick, Rosehill Gardens, Cantbury, W Farm, Ascot and Belmont. The only data missing will be the odd TAB number because I keep my Tab data and results in different files which need to match horse names to sync with each other. It's a comma delimited CSV file, easy enough to read into excel.
If the format's right and you want other tracks let me know. If it's crap, ah well, I had a try.

Don't feel obliged to share your system with me, you and others on this forum provide inspiration enough, no other rewards needed.

KV

I really appreciate ALL attempts at helping with this complex problem. I'm really thankful to everyone who took the time out to help with something that takes a fair bit of time.

There are a few tracks missing, so if you could see your way clear to doing just those tracks, that would be very helpful.

KennyVictor you are the closest so far, the format, and information is exactly what I require.

Missing:

DOOMBEN
CHELTENHAM
MORPHETTVILLE
SANDOWN HILLSIDE
SANDOWN LAKESIDE
VICTORIA PARK

KeenyVictor and Laish, please contact me at racestats at hotmail dot com and I'll give you the rating system rules.

Thankyou all.

[KennyVictor]

Sent the data to your hotmail address just prior to posting this message. Best of luck with it.

KV

[KennyVictor]

Received the details of your system Chrome Prince, thank's very much. I've only checked out your predictions for Belmont but If I understand it correctly you would have picked up Lemonade Dash at $40+ in Race 8. Nice going.

KV

[Chrome Prince]

Hi KV,

Thanks for all your help.

It needs some fine tuning or course, but backing the top selection on Saturday over SMBAP (40 top selections in all) returned $39.80 on the TAB.

I've identified that it needs adjustment and will experiment and get back to you via email.

Lemonade Dash was not in the picks unfortunately.

[KennyVictor]

Lemonade Dash, I was just going on the prices you had next to each selection. I think L.D. was priced at about $19 and you may have been backing the overs.

Anyway, I just discovered the data I sent you didn't have Royal Randwick, I just had Kensington track. Here are the 2004 results for R.R.