Bet Angel - Spreadsheet / Excel chat : 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

Thu Sep 23, 2010 6:29 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

Fri Sep 24, 2010 9:34 am

Sorted - all to do with passwords.

User avatar
gstar1975
Posts: 51
Joined: Thu Nov 24, 2011 11:59 am

Tue Jan 23, 2018 2:52 pm

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: 1107
Joined: Sun Jan 31, 2010 8:06 pm

Tue Jan 23, 2018 3:21 pm

Parts of the racing post site are restricted to members only so they're password protected.

Derek27
Posts: 837
Joined: Wed Aug 30, 2017 11:44 am
Location: UK

Tue Jan 23, 2018 4:25 pm

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
  • Information
  • Who is online

    Users browsing this forum: No registered users and 3 guests