OZmium Sports Betting and Horse Racing Forums

OZmium Sports Betting and Horse Racing Forums (http://forums.ozmium.com.au/index.php)
-   General Topics (http://forums.ozmium.com.au/forumdisplay.php?f=59)
-   -   Excel Formula Help (http://forums.ozmium.com.au/showthread.php?t=15977)

wise one 19th May 2009 09:55 PM

1 Attachment(s)
I have a xcel spreedsheet that I got a few years back from someone in this forum ( my apoligies for not remembering who ) This works on the Unitab site, but because they have change the layout of the second page it does not collect the data from there. ( you need to have a untab acct to get the detailed form history that this picks up ) So if someone out there can fix this and return it to me I would be very grateful.

This will not only collect data for todays races but for last month and the the 2 previous years.

In the options tab at the top click on "enable content"
Click in the purple and yellow boxes selecting "day, month , year , track "
Leave on race 01
If you want just 1 day click on the "get data day " and watch the numbers in race number move.
If you want raw data without scratching removed click on the "data" at the bottom and you can copy and paste
If you want the scratching removed click on the "blue" tab
If you want a whole month click on "get data month" tab it will however remove scratching automatically once it has collected the data
Once again is some can correct this so it collects the data of the last 3 race results it would be muchly appreciated

Wise One

kennedy22384 19th May 2009 10:31 PM

Quote:
Originally Posted by Brendon
'K.

When you say "opening prices" you mean prices from a particular time, say 10.30 am on the day, right?

BTW, tried your excel program. Superb!


The opening prices on IAS only appear after the previous race is run.

kennedy22384 19th May 2009 10:41 PM

Quote:
Originally Posted by wise one
I have a xcel spreedsheet that I got a few years back from someone in this forum ( my apoligies for not remembering who ) This works on the Unitab site, but because they have change the layout of the second page it does not collect the data from there. ( you need to have a untab acct to get the detailed form history that this picks up ) So if someone out there can fix this and return it to me I would be very grateful.

This will not only collect data for todays races but for last month and the the 2 previous years.

In the options tab at the top click on "enable content"
Click in the purple and yellow boxes selecting "day, month , year , track "
Leave on race 01
If you want just 1 day click on the "get data day " and watch the numbers in race number move.
If you want raw data without scratching removed click on the "data" at the bottom and you can copy and paste
If you want the scratching removed click on the "blue" tab
If you want a whole month click on "get data month" tab it will however remove scratching automatically once it has collected the data
Once again is some can correct this so it collects the data of the last 3 race results it would be muchly appreciated

Wise One


Spreadsheet looks very interesting. Let me take a look at it.

It is simply a data mining spreadsheet to put together form and data so users can test their systems. I am a bit bust atm with work but when I get the time, i will be able to come up with something pretty good

wise one 19th May 2009 11:15 PM

The person that supplied me with this was OZDOC

I haven't been around for awhile so I'm not too sure if he/she still posts here or maybe use a different nic

Wise One

kennedy22384 20th May 2009 06:11 PM

Ok, I worked today on making an improvement on OZDOC's spreadsheet.
I decided that one meeting for a month was just not enough.
I think every race meeting going back to the beginning of 2008 should suffice.
I have come up with a way to extract each horse's last 3 starts data from UNItab. It doesnt show 4th or worse just unplaced, but i have been able to put in days since last start, barrier, weight etc.

I am just testing it out now and I will release this when I am happy. All I would like now is some systems to test to see if they are good or not.

wise one 20th May 2009 06:20 PM

you can email me I can can send you some old data

owllieathotmaildotcom

wise one

kennedy22384 20th May 2009 06:33 PM

Nah, thats cool, all I need right now is some systems people want tested out.

I have been able to sort out dead heats which ozdoc did not

wise one 20th May 2009 06:43 PM

could you send it too me me so as I can test it out

Thanks

Wise One

kennedy22384 20th May 2009 07:34 PM

I havent included code to remove the scratchings. Just filter all the scratchings and delete it when it is finished.

kennedy22384 20th May 2009 07:53 PM

Found some issues with it. Still needs work


All times are GMT +10. The time now is 07:45 PM.

Powered by: vBulletin Version 3.0.3
Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.