SP Prices via Excel

[asmith1999]

Gary et al,

Apologies if I have asked this question previously....

Am I right in saying that it is not possible currently to display the current SP price via the triggered betting excel spreadsheet?

I presume that there are many systemites using the software that have based their systems on many attributes including SP. In that case how do people using the Excel triggered betting use SP? Do they use the BF price and factor it down to SP?

My betting is based heavily on the SP just before the off and I am keen to be able to utilise it.

I recently had a program written which writes the SP of the races just before and just after 'current time' to an Excel spreadsheet but it suffers badly from memory leak.

Any thoughts or help would be greatly appreciated.

Bet Regards,
Alan.

[Ian]

I currently use a web query to Hills mobile betting site to pick up the latest show. Its crude, and doesn't auto update or anything like that, but it does the job that I want it for. There is/was a product from another API vendor which linked the prices from Ladbrokes to Betfair prices but I don't think it puts them in Excel.

[GaryRussell]

Is it the Betfair SP you want in Excel?

[throwmeadisc]

Ian,

Can you post a link to the page that you use for this?

Thanks,

Al

[Ian]

http://mobile.willhill.com/WHMobile/app ... ileDesktop

This gives you the start menu and then you can drill down to a particular race and import the whole page. Pretty easy then to extract the name and odds although sometimes the names are truncated on the Hills site.

[asmith1999]

Guys,

Thanks for the replies.

Gary,

I guess the Betfair SP would be a compromise.

Regards,
Alan.