New Posts For Thread: rolling averageshttps://community.betfair.com/general_betting/go/thread/view/94082/29124623/rolling-averagesI am using microsoft excel to calculate the average time of a greyhound over the last 10 races.I would like to add the next time but automatically drop the first one so that the average is taken over the last 10 racesFor example C1 =30.42C2=30.84C3=3As feix mentions above, a weighted average would be better, including all results but taking more notice of the most recent.In Excel, this is fairly straight forward, you just need a ratio in a cell (say $E$1) to show the weight you want attributed thttps://community.betfair.com/general_betting/go/thread/view/94082/29124623/rolling-averages?post_id=519905981#519905981As feix mentions above, a weighted average would be better, including all results but taking more notice of the most recent.In Excel, this is fairly straight forward, you just need a ratio in a cell (say $E$1) to show the weight you want attributed tMon, 21 May 2012 05:03:00 -0500I thought Excel already had formulaes that do ARIMA modelling ... perhaps you also need to consider the weighting of the recent clocks versus older clocks ....I run a greyhound system and find that I need to put in a stop-profit flag in with the softhttps://community.betfair.com/general_betting/go/thread/view/94082/29124623/rolling-averages?post_id=519905627#519905627I thought Excel already had formulaes that do ARIMA modelling ... perhaps you also need to consider the weighting of the recent clocks versus older clocks ....I run a greyhound system and find that I need to put in a stop-profit flag in with the softMon, 21 May 2012 04:44:55 -0500Also, check your returns against certain tracks. I had a filter that was useless except at Nott and Pbar where it had exceptional strike rates and returns.https://community.betfair.com/general_betting/go/thread/view/94082/29124623/rolling-averages?post_id=519905007#519905007Also, check your returns against certain tracks. I had a filter that was useless except at Nott and Pbar where it had exceptional strike rates and returns.Mon, 21 May 2012 03:57:07 -0500cheeky....you might have incorporated this already but you'll find that results from certain grades will have less 'credibility'. Some really random A7, A8, etc.https://community.betfair.com/general_betting/go/thread/view/94082/29124623/rolling-averages?post_id=519904983#519904983cheeky....you might have incorporated this already but you'll find that results from certain grades will have less 'credibility'. Some really random A7, A8, etc.Mon, 21 May 2012 03:56:08 -0500Sunset,I make allowances for "Bumped -.10", "Crowded -.20", "Baulked -40"Its in its early days but so far so good.https://community.betfair.com/general_betting/go/thread/view/94082/29124623/rolling-averages?post_id=519904399#519904399Sunset,I make allowances for "Bumped -.10", "Crowded -.20", "Baulked -40"Its in its early days but so far so good.Mon, 21 May 2012 02:59:05 -0500so how are you using this? your pick is the one with the best average? is your system working?https://community.betfair.com/general_betting/go/thread/view/94082/29124623/rolling-averages?post_id=519862325#519862325so how are you using this? your pick is the one with the best average? is your system working?Sat, 19 May 2012 16:01:47 -0500CORRECTION, it didn't post right:=IF(AND(C10"",C11=""),AVERAGE(C1:C10),"")Copy the cell and bring it down through Dhttps://community.betfair.com/general_betting/go/thread/view/94082/29124623/rolling-averages?post_id=519824329#519824329CORRECTION, it didn't post right:=IF(AND(C10"",C11=""),AVERAGE(C1:C10),"")Copy the cell and bring it down through DFri, 18 May 2012 15:06:40 -0500Try this:COLUMN Din D10, put the following:=IF(AND(C10"",C11=""),AVERAGE(C1:C10),"")Copy this down column DAs you fill in D11, it will automatically blank D10 and D11 will bring up the average.This also allows you to keep all the data and if you wanthttps://community.betfair.com/general_betting/go/thread/view/94082/29124623/rolling-averages?post_id=519824281#519824281Try this:COLUMN Din D10, put the following:=IF(AND(C10"",C11=""),AVERAGE(C1:C10),"")Copy this down column DAs you fill in D11, it will automatically blank D10 and D11 will bring up the average.This also allows you to keep all the data and if you wantFri, 18 May 2012 15:05:34 -0500So you need a weighted average where recent data is more important than older data, as opposed to arithmetic average where each data has the same importance?I understand you already have a formula to calculate this, but you need your times arranged ahttps://community.betfair.com/general_betting/go/thread/view/94082/29124623/rolling-averages?post_id=519823235#519823235So you need a weighted average where recent data is more important than older data, as opposed to arithmetic average where each data has the same importance?I understand you already have a formula to calculate this, but you need your times arranged aFri, 18 May 2012 14:36:03 -0500Thanks for your response.It's not quite what I need.With greyhound data the most recent data is the most useful.What I do at present is to delete the entry for C1 (The oldest), drag (C2:C9) up and drop it in the C1.That then leaves C10 free for my lahttps://community.betfair.com/general_betting/go/thread/view/94082/29124623/rolling-averages?post_id=519818963#519818963Thanks for your response.It's not quite what I need.With greyhound data the most recent data is the most useful.What I do at present is to delete the entry for C1 (The oldest), drag (C2:C9) up and drop it in the C1.That then leaves C10 free for my laFri, 18 May 2012 13:02:12 -0500