Simple Moving Average Formula Issues

[Mathman]

Hi

I'm trying to find a way to get a simple Moving Average without excess cell recalculation and I'm running into something that seems odd. I'm hoping someone can highlight my mistake.

Example. 10 Moving average is simple if you use the average function but this creates many duplicates that can slow down recalculation times. Bellow is an example of what I have to overcome so many recalculation but what is odd is that I get the impression excel might automatically be rounding numbers when the average function is used? But the results seem random.

Please help......

A	B	C	D	E	F	G	H
Prices	10 Day Avg.	Formula		Formula		Formula
1.000	1.003	AVERAGE(A3:A12)	10.030	SUM(A5:A14)	1.003	D5/10	TRUE
1.010	0.998		9.980	SUM(D5-A5+A15)	0.998		TRUE
1.030	0.993		9.930		0.993		TRUE
1.060	0.985		9.850		0.985		TRUE
1.030	0.974		9.740		0.974		TRUE
1.030	0.968		9.680		0.968		TRUE
1.040	0.968		9.680		0.968		TRUE
0.980	0.968		9.680		0.968		TRUE
0.920	0.964		9.640		0.964		TRUE
0.930	0.968		9.680		0.968		TRUE
0.950	0.971		9.710		0.971		TRUE
0.960	0.975		9.750		0.975		TRUE
0.950	0.978		9.780		0.978		TRUE
0.950	0.984		9.840		0.984		TRUE
0.970	0.989		9.890		0.989		TRUE
1.030	0.993		9.930		0.993		TRUE
1.040	0.994		9.940		0.994		TRUE
0.940	0.996000000000000		9.960		0.996000000000001		FALSE
0.960	1.006		10.060		1.006		TRUE
0.960	1.017		10.170		1.017		TRUE
0.990	1.030		10.300		1.030		TRUE
0.990	1.038		10.380		1.038		TRUE
1.010	1.044		10.440		1.044		TRUE
1.000	1.045		10.450		1.045		TRUE
1.010	1.053		10.530		1.053		TRUE
1.040	1.052		10.520		1.052		TRUE
1.060	1.053		10.530		1.053		TRUE
1.040	1.050		10.500		1.050		TRUE
1.070	1.052		10.520		1.052		TRUE
1.090	1.052		10.520		1.052		TRUE
1.070	1.046		10.460		1.046		TRUE
1.050	1.044		10.440		1.044		TRUE
1.020	1.044		10.440		1.044		TRUE
1.080	1.043		10.430		1.043		TRUE
1.000	1.037		10.370		1.037		TRUE
1.050	1.037		10.370		1.037		TRUE
1.030	1.034		10.340		1.034		TRUE
1.060	1.031		10.310		1.031		TRUE
1.070	1.026		10.260		1.026		TRUE
1.030	1.024		10.240		1.024		TRUE
1.050	1.027		10.270		1.027		TRUE
1.050	1.021		10.210		1.021		TRUE
1.010	1.015		10.150		1.015		TRUE
1.020	1.018		10.180		1.018		TRUE
1.000	1.021		10.210		1.021		TRUE
1.020	1.028		10.280		1.028		TRUE
1.000	1.035		10.350		1.035		TRUE
1.010	1.044		10.440		1.044		TRUE
1.050	1.051		10.510		1.051		TRUE
1.060	1.053		10.530		1.053		TRUE
0.990	1.050		10.500		1.050		TRUE
0.990	1.056		10.560		1.056		TRUE
1.040	1.062		10.620		1.062		TRUE
1.050	1.064		10.640		1.064		TRUE
1.070	1.064		10.640		1.064		TRUE
1.090	1.064		10.640		1.064		TRUE
1.090	1.062		10.620		1.062		TRUE
1.080	1.055		10.550		1.055		TRUE
1.070	1.055		10.550		1.055		TRUE
1.030	1.061		10.610		1.061		TRUE
1.050	1.064		10.640		1.064		TRUE
1.050	1.062		10.620		1.062		TRUE
1.060	1.060		10.600		1.060		TRUE
1.050	1.055		10.550		1.055		TRUE
1.070	1.051		10.510		1.051		TRUE
1.070	1.042		10.420		1.042		TRUE
1.020	1.037		10.370		1.037		TRUE
1.080	1.036		10.360		1.036		TRUE
1.130	1.027		10.270		1.027		TRUE
1.060	1.013		10.130		1.013		TRUE
1.030	1.006		10.060		1.006		TRUE
1.030	1.004		10.040		1.004		TRUE
1.010	1.002		10.020		1.002		TRUE
1.010	1.004		10.040		1.004		TRUE
0.980	1.004		10.040		1.004		TRUE
1.020	1.005		10.050		1.005		TRUE
1.010	0.998		9.980		0.998		TRUE
0.990	0.989		9.890		0.989		TRUE
0.990	0.981		9.810		0.981		TRUE
0.990	0.977		9.770		0.977		TRUE
1.010	0.978		9.780		0.978		TRUE
1.010	0.976		9.760		0.976		TRUE
1.030	0.973		9.730		0.973		TRUE
1.010	0.969000000000000		9.690		0.969000000000001		FALSE
0.990	0.968000000000000		9.680		0.968000000000001		FALSE
0.950	0.968000000000000		9.680		0.968000000000001		FALSE
0.920	0.972000000000000		9.720		0.972000000000001		FALSE
0.910	0.983000000000000		9.830		0.983000000000001		FALSE

<colgroup><col width="64" style="width: 48pt;"><col width="138" style="width: 104pt;"><col width="110" span="3" style="width: 83pt;"><col width="138" style="width: 104pt;"><col width="64" span="2" style="width: 48pt;"></colgroup><tbody>
</tbody>