Smartgambler
Pro-Punter

Go Back   OZmium Sports Betting and Horse Racing Forums > Public Forums > General Topics
User Name
Password
Register FAQ Search Today's Posts Mark all topics as read

To advertise on these
forums, e-mail us.

Reply
 
Thread Tools Search this Thread Display Modes
  #31  
Old 19th May 2009, 09:55 PM
wise one wise one is offline
Member
 
Join Date: Jan 1970
Posts: 114
Default

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
Attached Files
File Type: xls THEMBOY$_DATA_V_3-9.XLS (550.5 KB, 1057 views)
Reply With Quote
  #32  
Old 19th May 2009, 10:31 PM
kennedy22384 kennedy22384 is offline
Member
 
Join Date: Oct 2005
Posts: 52
Default

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.
Reply With Quote
  #33  
Old 19th May 2009, 10:41 PM
kennedy22384 kennedy22384 is offline
Member
 
Join Date: Oct 2005
Posts: 52
Default

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

Last edited by kennedy22384 : 19th May 2009 at 11:10 PM.
Reply With Quote
  #34  
Old 19th May 2009, 11:15 PM
wise one wise one is offline
Member
 
Join Date: Jan 1970
Posts: 114
Default

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
Reply With Quote
  #35  
Old 20th May 2009, 06:11 PM
kennedy22384 kennedy22384 is offline
Member
 
Join Date: Oct 2005
Posts: 52
Default

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.
Reply With Quote
  #36  
Old 20th May 2009, 06:20 PM
wise one wise one is offline
Member
 
Join Date: Jan 1970
Posts: 114
Default

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

owllieathotmaildotcom

wise one

Last edited by wise one : 20th May 2009 at 06:25 PM.
Reply With Quote
  #37  
Old 20th May 2009, 06:33 PM
kennedy22384 kennedy22384 is offline
Member
 
Join Date: Oct 2005
Posts: 52
Default

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
Reply With Quote
  #38  
Old 20th May 2009, 06:43 PM
wise one wise one is offline
Member
 
Join Date: Jan 1970
Posts: 114
Default

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

Thanks

Wise One
Reply With Quote
  #39  
Old 20th May 2009, 07:34 PM
kennedy22384 kennedy22384 is offline
Member
 
Join Date: Oct 2005
Posts: 52
Default

I havent included code to remove the scratchings. Just filter all the scratchings and delete it when it is finished.
Reply With Quote
  #40  
Old 20th May 2009, 07:53 PM
kennedy22384 kennedy22384 is offline
Member
 
Join Date: Oct 2005
Posts: 52
Default

Found some issues with it. Still needs work
Reply With Quote
Reply


Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is On
Forum Jump



All times are GMT +10. The time now is 07:38 AM.


Powered by: vBulletin Version 3.0.3
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
©2008 OZmium Pty. Ltd. All rights reserved . ACN 091184655