Column Average

Advanced automation available in Guardian - Chat with others and share files here.
Post Reply
Safeway
Posts: 164
Joined: Sat Mar 18, 2023 7:00 pm

An idea which came to me as I was driving along……..can I get an SV of the average of the figures in a column? This might be each runner’s speed or maybe stride frequency at any moment.

I was thinking I could make an SV of each runner and then make an SV of the average of those but then thought races have different numbers of runners and thought there might be an easier way.

Thanks all - hope you’re all trading well in the pouring rain!
User avatar
Dallas
Posts: 23596
Joined: Sun Aug 09, 2015 10:57 pm

You can get an average of any stored value over whatever interval you want then display it throughout BA or used by an automation or servant rule

There are a few examples that do this in the customization area like this one
viewtopic.php?p=246361
Safeway
Posts: 164
Joined: Sat Mar 18, 2023 7:00 pm

Sorry Dallas, you must think we’re going over old ground.
I shouldn’t have termed this as ‘columns’ as I appreciate they only display data….SV’s or anything else.
Basically, I have an SV of speed and average speed for all runners thanks to your help previously. The question is……can I get an average of those runners speeds at any moment giving me a figure which shows the average speed the race is being run. If there were two horses in the race and horse A was doing 30mph and horse B 35mph the average would be 32.5mph in that instant.
I could I think arrange the bot to get the average but as each race has different numbers of runners the divisor would vary race by race and that bit is throwing me😞
Thanks mate - it’s a pleasure dealing with you as always.
User avatar
Dabbla
Posts: 826
Joined: Wed Apr 15, 2009 1:50 pm

You can create a Sv to do this
Action > Store value calculated from a range of values
For the MARKET
Calculate > the average
Using > a stored value (across all selections)
Then add in the SV you want. You will need to save the Speed as a SV first.
Post Reply

Return to “Bet Angel - Automation”