Last traded price 1hr before race

[vanbuuts]

Hello, does anyone have some code / or a file that will grab the last traded price (Column O) from each race (Courses in separate tabs) 1hr before the scheduled off - is this even do-able via GRUSS?

[brumbie]

It would be easier to go here around 1 hour before the race:

https://www.winningwarlock.com/in-running-exchange-betting-horse-ratings.html

[Captain Sensible]

D2 contains the time to the off so it's simple enough to track the time and copying cells is easy enough, there's plenty of examples on the forum.

But it all comes down to the details as how you do it. If you each market open in a tab at least an an hour before the off it's easy, if not you then have to code your sheet to loop through the markets every hour. If you're just saving the data and not using it to bet with then you can simply set up a separate sheet and have it auto select the markets each hour collecting the data as it goes.

[brumbie]

I believe I added to Osknows excellent Record Playback sheet to record the WOM at 10am sometime back...could maybe start from there.

http://www.gruss-software.co.uk/forum/viewtopic.php?f=12&t=7844&p=41246&hilit=osknows+record+playback#p41246