Running average of cell "Last Price Matched"

Discuss anything related to using the program (eg. triggered betting tactics)

Moderator: 2020vision

Running average of cell "Last Price Matched"

Postby Castillo » Fri Sep 29, 2006 3:07 pm

Hi all

I’ve created several excel trading spreadsheets using different methods and trigger values. With the additional information showing Last Price Matched (Field O5) it would be nice to calculate the running average of that cell so it then can be compared to the current market situation. Is there a formula I can use to look at cell O5 and return the running average?
For example, I’ve just activated the spreadsheet, in Cell O5 the Values 4.5, 4.7, 4.8, 4.2, 4 have just been displayed, so I’m after a formula that will display the running average of 4.44 so far. So this now tells me that the last bet matched was odds of 4 and the average odds since activating the spreadsheet is 4.44, so the selection odds are shortening in general. I could then determine which way the betting is going on a selection, this is very similar to using WOM but using the odds instead.

I would be grateful for any help.

Cheers
Castillo
Castillo
 
Posts: 346
Joined: Thu Mar 16, 2006 11:01 am

Return to Discussion

Who is online

Users browsing this forum: No registered users and 21 guests

Sports betting software from Gruss Software


The strength of Gruss Software is that it’s been designed by one of you, a frustrated sports punter, and then developed by listening to dozens of like-minded enthusiasts.

Gruss is owned and run by brothers Gary and Mark Russell. Gary discovered Betfair in 2004 and soon realised that using bespoke software to place bets was much more efficient than merely placing them through the website.

Gary built his own software and then enhanced its features after trialling it through other Betfair users and reacting to their improvement ideas, something that still happens today.

He started making a small monthly charge so he could work on it full-time and then recruited Mark to help develop the products and Gruss Software was born.

We think it’s the best of its kind and so do a lot of our customers. But you can never stand still in this game and we’ll continue to improve the software if any more great ideas emerge.