Hello all I am looking for some help with excel.
I would like to copy the ltp cell k9 and runner volume cell k10 for runner 1 into a column, listing 10 mins from the off so the column would list all the values from 10 mins out at selected refresh rate.
Many thanks for youre guidance if able to help
Rollox
Excel Data Listing
Hi Rollox,
To do what you want might require a basic working knowledge of VBA and I am researching something similar myself to record the race result at end of each race. Even if I had the solution it would probably be too much to outline in a post. However I can attach 2 utube video links to get you started which I hope will provide the solution to us both.
As another solution you could setup an automation file with (restricted) refresh rate from 3660 primed to trigger once from 10 mins
from start of race on the selection Row1 ( which is not necessarily the FAV btw).
The Rule which would be a stored value rule would store a value for the LTP of the Row 1 selection. If you also tick the "Note value.. in log file" then you will see the Name of selection and its price 10 mins from off recorded in the log in guardian for that race and each race after that. You could easily do the same for all runners by row2 row3 etc using multiple rule file by copying the file and changing selection to Row2 etc.
The URL's for the videos are.
https://www.youtube.com/watch?v=tcLNWvhaUH8
https://www.youtube.com/watch?v=HsiwC9xg06c
Hope this help us both
To do what you want might require a basic working knowledge of VBA and I am researching something similar myself to record the race result at end of each race. Even if I had the solution it would probably be too much to outline in a post. However I can attach 2 utube video links to get you started which I hope will provide the solution to us both.
As another solution you could setup an automation file with (restricted) refresh rate from 3660 primed to trigger once from 10 mins
from start of race on the selection Row1 ( which is not necessarily the FAV btw).
The Rule which would be a stored value rule would store a value for the LTP of the Row 1 selection. If you also tick the "Note value.. in log file" then you will see the Name of selection and its price 10 mins from off recorded in the log in guardian for that race and each race after that. You could easily do the same for all runners by row2 row3 etc using multiple rule file by copying the file and changing selection to Row2 etc.
The URL's for the videos are.
https://www.youtube.com/watch?v=tcLNWvhaUH8
https://www.youtube.com/watch?v=HsiwC9xg06c
Hope this help us both
Forget to mention that you would also have to do similar file using "the volume of a selection" in the stored value section. The (restrict)
refresh can be much lower than stated say 610 (for 10mins & 10sec before race is off.) Anything greater than 600 will do.
refresh can be much lower than stated say 610 (for 10mins & 10sec before race is off.) Anything greater than 600 will do.
-
spreadbetting
- Posts: 3140
- Joined: Sun Jan 31, 2010 8:06 pm
Maybe have a look at this thread viewtopic.php?f=19&t=20046 it had some code to grab at set times, the uploaded sheet has disappeared and dont think I kept a copy but the original poster should have one.