How do I do this?

[drewrell]

I am trying to automatically load selections from a website into excel. Which is working fine
However I am not sure how to automatically link these with BA to then select the correct race and place the bet when my criteria is matched. eg lay if between 2 & 6

Eyesnack had a spreadsheet available for download which would automatically load all runners from the racing post site.

Need something similar but only want to load the selections from the website.

Just dont understand what I need to do to get BA to confirm details and then lay bets.

Any suggestions?

Is this an impossible task?
I have limited experience.

[Ian]

I don't know how Eyesnack's spreadsheet works but you could possibly let that sheet do all the work and do a lookup from it to your spreadsheet to decide which horses you are interested in.

[Captain Sensible]

Shouldn't be a problem as excel can easily link to websites via web queries pull down the data then use a vlookup command to place the bet using auto select of markets

Hav a look at the thread
http://gruss-software.co.uk/forum/viewt ... p&start=15

which was using vlookup to allow people to enter their bets for the day then lt the sheet bet for you. As you've already managed to get the runners onto your sheet it shouldn't be a roblem with vlookup

[drewrell]

Thanks for your help.
Not sure how to do all of that but I will read through the thread and give it a try on the weekend