Download selections from website.

[drewrell]

Is there anyway by using an excel sheet, I can retrieve my daily selections from a website and have these automatically loaded into BA as per the criteria I will specify(eg only lay if below 6.00)

I am fine with setting the options in excel, just can not get the data to load from the site and then not sure how to relate the data to betfair.

eg.
Lingfield 2.00 Losing Horse

Have no idea how to do this.

Any suggestions would be appreciated

[Captain Sensible]

You'll need to use a web query to retreive the data into excel- go to data ->import external data->web query in excel. No idea of the website you want to use so you may have to play around with the data you retrieve or set it to log in etc but it shouldn't be too hard

[throwmeadisc]

Also be careful that selection names on Betfair and websites maybe be different.

For example. (Random)

Website name = Bevan's Head
Betfair name = Bevans Head

or

Website name = Mr Long John Silver
Betfair name = MrLongJohnSilver

These don't match.

The most effective way around this is to compare the values when you remove and apostrophes and any spaces from both names and make both uppercase (or lowercase).

The Excel =SUBSTITUTE(), =EXACT() and =UPPER() function should set you free.

Good luck.

Al

[drewrell]

good so far.
I can get the data loaded from the site into excel.

How do I relate this information back to betfair, to then tell it to lay the specific name I have downloaded?

[Smokin Joe]

I haven't worked out the specifics, but could you not have a list of horse on Sheet 2 that you wish to lay (at the maximum lay price)?

And in Sheet 1 (the sheet which interfaces with BA) could you not have a lookup in each of the rows, which returns the maximum lay value when the horse's name appears in Column A.

[Captain Sensible]

Have a look at the thread

http://gruss-software.co.uk/forum/viewt ... t&start=15

might be what you're looking for

[drewrell]

Thanks Captain

That should do the trick