Record SP odds and switch to next market

[vanbuuts]

Hi all, I have lost all my previous Excel sheets when my computer was recently wiped.

I am looking for a simple VBA code that will copy the SP odds and Horse name into "sheet2" once a race has gone in play and then change to the next market.

Does anyone have code that does this / or can provide some?

Thanks in advance

[Captain Sensible]

If you're simply collecting past prices why not wait until the next morning as betfair stick them all up on their website for download, you can then easily import those into a database. Unless you're using them to bet on the next race it's easier to look on the promo or timeform site for the data.

http://www.betfairpromo.com/betfairsp/prices/

[vanbuuts]

Super, cheers mate - didn't know this existed