Jump to content
Xtreme .Net Talk

Recommended Posts

  • 1 month later...
Posted (edited)

Sorry, didn't see your reply. I'll make sure I subscribe to instant email notifications of replies now.

 

Betting prices from here hxxps://www.sportingindex.com/. So I'm looking to get the data continuously and use it for analytical purposes. I suppose I could be wrong about the data being in Adobe Acrobat - I just believe this to be the case because an Excel web query returns no results and occasionally I get a message that Adobe Acrobat has crashed.

 

Also I am looking at a website where an Excel web query does return results. How can I get this data into vb? Again I need the data continuously so I don't want to have to keep manually refreshing the spreadsheet. And it would be simpler if I could bypass the need for a spreadsheet altogether if possible.

 

Thanks.

Edited by rbulph
Posted (edited)
Doesn't look like it uses flash, all the prices are in the html itself. Parsing that is another matter entirely - if you search around these forums or at the sister site (http://www.xtremevbtalk.com/) you should find plenty of topics on parsing html.

 

Thanks. But I just ran a WebRequest on this page hxxps://www.sportingindex.com/spread-betting/horse-racing/indices/mm4.uk.meeting.4856484/9-25-kempton-50-30-20-10, and while I could find the names of the horses in it, the prices were absent. For instance:

 

"<li class="hide" key="MM4.uk.173823415" meetingKey=mm4.uk.meeting.4856484>

<a href="#" class="info">Info</a>

<span class="markets">Forceful Beacon</span>

<span class="sofar"></span>

<span class="price"></span>

<span class="indicator"></span>

</li>"

Edited by rbulph
Posted
Thanks. But I just ran a WebRequest on this page hxxps://www.sportingindex.com/spread-betting/horse-racing/indices/mm4.uk.meeting.4856484/9-25-kempton-50-30-20-10, and while I could find the names of the horses in it, the prices were absent. For instance:

 

"<li class="hide" key="MM4.uk.173823415" meetingKey=mm4.uk.meeting.4856484>

<a href="#" class="info">Info</a>

<span class="markets">Forceful Beacon</span>

<span class="sofar"></span>

<span class="price"></span>

<span class="indicator"></span>

</li>"

 

So I don't really know how the price itself is delivered. Somebody here has done it, but it's quite involved and he used JSON, certainly wasn't just able to look at the html.

 

Grateful for any further pointers for how to do this, otherwise I suppose I should be reading through the article I've referenced.

  • 2 weeks later...
Posted
Grief, parsing html is tedious. Anyway I'm looking at another site now - sports.spreadex.com/en-GB/spread-betting/Horse-Racing. Again I can do a WebRequest but this doesn't contain the prices. Any idea how I can got hold of the prices on this page?

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

×
×
  • Create New...