[TR] Tennis trigger

Hi,

I would like a tennis trigger which has the running average points scored and conceded in a match of the past n completed service games and then back or lay the server based on the expected outcome based on the previous n service games points scored and conceded; after the game is complete green up or spread loss and then back or lay the next server at the start of the game.

So as an example if n = 3 and the game was this one...

flashscores.co.uk/match/p2BUu8Pr/#point-by-point;1

And Ozaki was P1 you would effectively generate a table that looked like

,Game,Server,P1,P2,Server Score,Server Concede
,1,1,15,40,,
,2,2,40,15,,
,3,1,30,40,,
,4,2,40,15,,
,5,1,40,40,,
,6,2,40,40,,
,7,1,40,15,28.3333333333,40
,8,2,40,40,23.3333333333,40
,9,1,30,40,36.6666666667,31.6666666667
,10,2,40,40,31.6666666667,40
,11,1,30,40,36.6666666667,31.6666666667
,12,2,15,40,40,40
,13,1,40,15,33.3333333333,31.6666666667
,14,2,30,40,40,31.6666666667
,15,1,40,30,33.3333333333,31.6666666667
,16,2,40,30,40,28.3333333333
,17,1,30,40,36.6666666667,28.3333333333
,18,2,15,40,36.6666666667,28.3333333333
,19,1,40,15,36.6666666667,28.3333333333
,20,2,40,40,36.6666666667,28.3333333333
,21,1,40,30,36.6666666667,28.3333333333
,22,2,40,15,36.6666666667,31.6666666667
,23,1,40,15,36.6666666667,28.3333333333
,24,2,30,40,31.6666666667,31.6666666667
,25,1,40,30,40,20
,26,2,40,30,31.6666666667,36.6666666667
,27,1,40,30,40,25

(deuce games record both scores as 40)

Such at the start of game 7 you would say Ozaki has scored an average of 28.3 points on her serve and conceded 40 so you expect her to be broken.

Trigger at 0-0 in game 7 to lay Ozaki, after the game is complete either green up or spread loss.  (this bet would be a loss as Ozaki held 40-15).

At the start of game 8 you would lay Bertens as you expect her to concede 40 points and score only 23.3

Trigger at 0-0 in game 8 to lay Bertens

Game 9 you expect Ozaki to hold so back and again spread the loss...

Over the course of the match you got it wrong 9 times but right 12 times.

Hopefully you can offer me some insights on how to get this going - I can't see how to do it myself without creating hundreds of variables and storing the score from every game in them and then having a trigger for every game computing the average from (current game - 2) + (cg - 4) + (cg - 6) scored / 3 etc... but then it doesn't have the flexibility to change n should I desire without reprogramming it all.

Thanks in advance for any assistance.

Ok I've figured this out.  Excel is my friend.

Looks intricate.
If you have the exact number of points scored by each player in each game, you can also import them from a text file (it's faster than using Excel). Put the numbers of points scored in each game next to the player's name and separate them with the tab character, then import the file for auto-trading and check the corresponding trigger variable, e.g.
s_1_imported_7

That would be the average number of points the first player in the list scored in the 7th game.