Starting Prices

[throwmeadisc]

Does anyone have a good website to use for an Excel Web Query to get the starting prices of the next horse race?

Can't seem to find one.

Cheers,

Al

[tamrood2000]

Hi try sportinglife site -

a link to one of todays races is http://www.sportinglife.com/racing/live ... _1450.html

You seem to be able to set up a web query to get prices watch some though 15-8 comes through as a date.

What i can't work out is how to get the query to change to the next race.

My system is looking for steamers against Sun prices and then backing using Gruss.

Got almost of working except this SP price switching.

Any excel wizards got any good ideas?

Steve

[Frinck]

It can definitely be done. The key is understanding how the URL is formed - specifically the day, meeting and time elements. If you can build up the URL dynamically by specifying these three values is cells, then automating the whole process should be straightforward...

Try playing around in Excel by creating a 'refresh' button with code behind it that's based on a macro (carry out all the mouse-clicks and keystrokes required to execute one single query). Then take a look at the VBA that's automatically generated and tweak the code to dynamically create the URL based on the cells mentioned above.

Once you have that working, then automating the whole process shouldn't be too difficult depending on how you decide to trigger each refresh (ie. the code behind your Refresh button).

Hope that makes some kind of sense - it's hard to explain sometimes without being in front of Excel. See how you get on with it. There may be better ways of doing it, but it's certainly a starter for 10.

Good luck