I know this is a little late, but the way I would approach this is to have a complete column available for data then in a neighbouring column put the formula as shown below:
Say using column D, enter this formula in E2:
Sum(D : D)/COUNT(D : D)
Add whatever you want into the D column and it will continuously update the average.