|
|
To advertise on these forums, e-mail us. |
|
|
Thread Tools | Search this Thread | Display Modes |
#1
|
|||
|
|||
NSW TAB Live Odds help needed
Hi everyone,
I am having trouble trying to get info from NSW TAB live odds. By trouble I mean I wouldn't have a clue where to start. I have been trying to understand how it all works, but it is going way over my head at the moment. I can get the fields etc from Tatts (UniTab?) xml feed mainly thanks to their example they give you. Why can't the NSW TAB do that?! It would make it a little easier! Any help people could give me, even if it's just getting the Access Key, would be greatly appreciated. Cheers, Chris. |
#2
|
|||
|
|||
You need to use a web query to pull the data in, you will also need a way to manipulate the race number and venue.
I would set it up in a drop down list then add today's markets with the variables needed. Here is a simple web query macro Code:
Code:
Code:
This is the formula i have in cell AL4 =IF(AK2="","","http://www.tab.com.au/Racing/Betting/StandardBets/PlaceStandardBet.aspx?State=1"&"&MeetingCode="&AN2&"&RacingCode="&AO2&"&FromDate="&TEXT(AS1,"yyyy-mm-dd")&"T00:00:00&BetType=Win&RaceNumber="&AL3) The parts in red are the variables like what state meeting codes date and race number. There is a lot more involved but this would work if you stuck it in a sheet and added the variables at the correct locations with the same sheet names. You can run multiple macros pulling in different info, you only need the first 2 macros once you don't need them for each query. |
#3
|
|||
|
|||
Hi Shaun,
Just wondering if this VBA code you have uploaded is doing a simple screen scrape of a race, or is actually using the Live Odds WSDL and methods? Only reason I ask is that I didn't even know you could call SOAP Web services through VBA (if in fact, you are using the SOAP services). Neurokahuna |
#4
|
|||
|
|||
Thanks Shaun for your reply, I will give it a go and have a play around with a few things to get the info I need.
It would be a lot easier to do it your way than through the Live Odds SOAP web service. Although if anyone knows how to go about it I would still like to know just out of interest. Cheers, Chris. |
#5
|
|||
|
|||
My way is simple screen scrap, downloads to a temp txt file then pastes it in excel.
It has only been in the last 12 months i have changed the way i get web info using the CreateObject("MSXML2.XMLHTTP") method, the speed difference is huge. I have used the xml feeds before but unless you know what to look for can be a bit harder to get the info and not all sites use xml. I started a thread here http://forums.ozmium.com.au/showthread.php?t=23333 to try and help people understand the web query. |
Thread Tools | Search this Thread |
Display Modes | |
|
|