I have been trying to get data from the Racing Post website using visual basic but am having problems connecting.
My plan was to put things such as the betting forecast, jockeys, etc into a seperate file and have the info available to the Bet Angel spreadsheet for formulas.
Sometimes everything is fine but mostly it seems blocked.
I can browse the site normally using IE or Google Chrome when the VB program is sitting waiting for a connection.
The same connection routines have been used to access many other sites without problem.
Im using :
Set ie = CreateObject("InternetExplorer.Application")
ie.Navigate "http://www.racingpost.com/horses2/cards/home.sd/"
Do Until ie.ReadyState = 4 'THIS IS THE POINT WHERE IT OFTEN WAITS....and waits
DoEvents
Loop
The available racecards are then lifted from this page, opened as above then required data stored.
I've seen it going all the way through but usually it stops before completion.
Could anyone please advise if Racing Post have some sort of blocking in place and if so how to get past it.
Getting data from Racing Post for use in Excel
-
- Posts: 3140
- Joined: Sun Jan 31, 2010 8:06 pm
Parts of the racing post site are restricted to members only so they're password protected.