Hi all,
Lots of people have their own idea of what averages to use and which is best,some say 10 and 20 seconds, others might say 5 seconds or even 30 seconds.
So, I've created a Datacapture Plus sheet.
As well as capturing data, it gives the LTP, book %, wom, min/max, overround, etc.all one one sheet.
But you'll also see a list of averages from 5 secs to 120, which should suit almost everyone but the most ardent swing trader.
If you look at "Chance Coffey" for example, his 5,10, 15 sec av is 4, rising to 4.10 for a 20sec av, and 4.2 for a 25 sec av.
It should suit bot makers as you can put your formulas in from row 19 onwards, and just reference any of the cells above.
A couple of sheets are hidden, but only to protect the formulas. If you want to look, go ahead, but please bear in mind that there are a number of array formulas in there.
Hasn't been fully tested, so please ensure that you are fully satisfied with it before using.
Any comments, problems etc, please let me know.
Whilst building, I've been putting in race meetings, prices by hand, so if you see anything odd (race 1) for example, just ignore it.
To use:just connect in the normal way.
Nigel.
