Here is a working version (i hope!) try it out, better to turn it on before bed time cause this will take a while.

Attached Files

UNITAB Data Grabber V1.1.zip (92.1 KB, 878 views)

OH MY GOD

Kennedy91210!!!

Ain't seen or heard of you for ages

Good to see you back

You always been helpful BIG Time to many.

I been running that Greyhound Spreadsheet you gave away about 3 years ago and have been having varying degrees of success with it.

home.alphalink.com.au/~ackd/raker/raker.htm

Thats my new program which grabs ratings for all races. 30 Day free trial. Try it out. Been finding good results with odds on rated dogs and top 2 which are only ones under $10 been producing good quinellas.

Just please remember not to bet on the tab's and bet with the online bookies

Kennedy91210

Are you able to help me import just one table from
betchoice.com/racing/?eventid=271668

All i am interested in is the table under the heading "flucs" now this table is normally only updated about 10 minutes before the race and each race has it's own id the only way i can get the id is to do a properties on the page this gives me the event id.

I have been trying to setup a web query directly from excel but this has to be done for each race and i have to import lots of unneeded data, also when the race is finished they add results to this page and it is stuffing up my formulas, any help would be grateful.

Ill see what I can do.

BTW, its 22384, not 91210 lol. Hate that show lol

Hi,

Just to let you know I have come across another issue but I can explain it on here.

When you open up the spreadsheet, go to the Dates tab and remove the following 2 rows with these dates:

21/03/08
25/12/08

The program does not like non race days . Just do this then run it to your hearts content

I had a go at the Greyhound Program Kennedy.

But there ain't no instructions.
How do I select what race I wish to have handicapped?
When I ran it last night, it automatically did Cannington Race 7 and 8
Maybe I wanted to do else where.

Can't see any user input.
The only control seems to be is "get ratings"

Why did you choose qtab in preference to grv databases?

When you press get ratings, you get every race yet to run which is at least 10m from jump. Cannington R7 and R8 was all that was left. You dont select a race to have handicapped, the program does all the races Unitab covers as per above what I just said. While the program is running any races done you can select the race from the list of races and the odds for each runner will appear (Unless the ratings say they are really bad then they wont). Alternatively you can go open Export.txt which is in the same folder as the program. It updates after every qualifying race.

I only use Qtab to get races and race fields, the form comes from GRV.

I followed the number 1 rule of programming K.I.S.S. (Keep it simple stupid).

Happy Raking

Need some help with this formula

=IF(BF7="","",IF(ISNUMBER(FIND(",",U7)),LEFT(U7,FIND(",",U7)-1),U7))

it checks to see if the cell is a number then it will remove eveything after "," problem is sometimes there is no bet fluctuation so there is just one set of numbers in the cell and it can't find "," so it returns nothing.

I need it to return the number in cell U7 if it can't find ","

try adding IF(ISNUMBER(U7),U7,