Running average of cell "Last Price Matched"

[Castillo]

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