log current prices

[4ofkind]

Hi,

I would like to collect data about odds changes for particular time period.
BA feature log current price transfers odds to excel, which is nice, but is there a way to set it to automaticly coppy odds values from Back Odds 1 and Lay Odds 1 columns to any columns bellow with some ineterval like 10 seconds? Or only way is manully copy-paste?

[Captain Sensible]

Have a look at http://rapidshare.com/files/368485592/R ... arkets.xls or search the forum there's plenty of examples of recording odds

[4ofkind]

Thanks a lot m8. That form works almost perfectly. Only thing which is not working is refresh rate (I put 5 seconds but it steal records with 1-2 seconds interval), but anyway its great..will add some filters later to analize collected data.

[Captain Sensible]

Thanks a lot m8. That form works almost perfectly. Only thing which is not working is refresh rate (I put 5 seconds but it steal records with 1-2 seconds interval), but anyway its great..will add some filters later to analize collected data.

Did you look at the instructions and set the refresh rates correctly on the relevant status sheets? I just tried it and it worked fine at 5 seconds, you can't amend the refresh rate on the sheet W1 as that needs to be set on the sheet Status W1 along with any other bits and pieces like speeding up the refresh if in play etc