List of Runners

[AndrewP]

Hi All,

I need to put a list of all declared runners into an Excel lookup table the night before racing. In order to avoid differences in spelling, punctuation etc. affecting my lookup table I would like to get the names of runners from Betfair itself. Does anyone have any code for this or can anyone advise on the best way of going about it?

Andrew

[Ian]

You can download a CSV file of tomorrow's decalared runners from the Sporting Life site from the bottom of this page ....

http://horses.sportinglife.com/Abc/0,12527,h_1,00.html

You just need to have a macro to edit out the suffixes. I've found the spelling is usually pretty much the same as Betfair's.

[alrodopial]

http://www.mediafire.com/?8mylsgwgjaj

The file isn't mine , i downloaded it from here but don't remember from who.
In the quick pick list you have all today's races, you log the first race and wait.If a race is suspended you have to manually pick the next race.

Thank Ian, I'll check it .It may be simpler.

[AndrewP]

Thanks for these solutions guys.

I ended up with a neat little utility from the SmarterSIG.com forum which downloads all runners and current prices direct from Betfair and so avoids any variations in spelling and punctuation.

Andrew

[Roger]

Got a link, please Andrew? Do you have to subscribe to get it?

[AndrewP]

Here it is Roger. http://www.smartersig.com/home.php

This particular utility is not in the downloads area of the site but on the discussion group forum (hosted byYahoo). You have to subscribe (pay) to gain access to both the members areas of the site and the forum.

Andrew

[Roger]

Thanks Andrew. Duly noted.