How to auto refresh

[samhayer]

Hi everyone I need a bit of help here if any one can help please thanks in advance
i have a market sheet for horese races and i want this to auto refresh just after the race starts as i want to place bets in play and want the sheet to show the last odds availble at the start of the race is there a code i could put in to the market sheet or any other way to do this Thanks all

[Captain Sensible]

You can't force something to auto refresh when the race starts if you don't know exactley when it's going to start. Best you can do is to simply set off your logging routine and speed up refreshes at the off time. From there you'd simply collect the price at each refresh and then dump the last price vailable before the inplay flag switched to "In Play" or the first price available when the market indicator went to "In Play" . I'd have thought the first prices when the market goes inplay wouldn't be the most reliable as the market is forming at that point.

[samhayer]

Thanks for that I will try