Getting data from Racing Post for use in Excel

Discussion regarding the spreadsheet functionality of Bet Angel.
Post Reply
Zapata
Posts: 213
Joined: Thu Jan 21, 2010 11:58 pm

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.
Zapata
Posts: 213
Joined: Thu Jan 21, 2010 11:58 pm

Sorted - all to do with passwords.
User avatar
gstar1975
Posts: 615
Joined: Thu Nov 24, 2011 11:59 am

Zapata wrote:
Fri Sep 24, 2010 9:34 am
Sorted - all to do with passwords.
What do you mean "its to do with passwords" can you elaborate please?
spreadbetting
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.
User avatar
Derek27
Posts: 23468
Joined: Wed Aug 30, 2017 11:44 am
Location: UK

The thing that has always put me off extracting database information from websites is, it's a lot of work, and all your hard work gets undone when they redesign or even make minor changes to the website.
Post Reply

Return to “Bet Angel - Spreadsheet / Excel chat”