Greyhound form and ratings

[Ian1506]

Because BA does not show recent form or ratings for Aus greyhounds, does anyone know of a method where the race currently on sheet one can be automatically downloaded from Tattsbet and put onto Sheet 4.

For example if BA is showing Sale Greyhounds Race 11 on Sheet One, this page (https://tatts.com/racing/2013/9/22/VG/11) is to be automatically downloaded to Sheet 4.

I can mine this manually but it is very time consuming.
Any help gratefully accepted.
Cheers Ian

[Captain Sensible]

I'm assuming the last two entries in the url, /VG/11, refer to the course and race number. It shouldn't be too hard to parse out those details from BA so you can set up some vba to pull down the racecard on each market refresh. I used to have something similar before Gary set up his sportinglife spreadsheet that does the same just gets live shows from the bookies for horseracing.

Have a search of the forum as there's plenty of examples showing how to grab an external site using vba and on parsing a string to get the race/course you'd need.

[Ian1506]

Hi Captain. Yes the VG relates to the meeting name and 11 is the race number.
I think I can parse out the name and race number from BA but the next bit about getting the race card is a mystery to me.
I've looked on the forum, searching for "External Sites", "Parsing" etc but nothing seems to be jumping out at me.
Am I searching using the wrong terminology?
Cheers Ian

[alrodopial]

modify the getpage function:

http://gruss-software.co.uk/forum/viewtopic.php?t=7953