3 months moving average is calculated by taking the average of
every 3 months combination as shown in the below table:
- Average period = January, February, March
- Average period = February, March, April
- Average period = March, April, May
- Average period = April, May, June
- Average period = May, June, July
- Average period = June, July, August
- Average period =July, August, September
- Average period =August, September, October
- Average period =September, October, November
- Average period =October, November, December
|
IBM |
|
|
3MA |
Amazon |
|
|
3MA |
|
January |
$172.64 |
|
|
January |
$607.61 |
|
|
|
February |
$175.29 |
|
|
February |
$618.80 |
|
|
|
March |
$186.43 |
(0.5*172.64+0.5*175.29+2*186.43)/3= |
$182.28 |
March |
$579.71 |
(0.5*607.61+0.5*618.8+2*579.71)/3= |
$590.88 |
|
April |
$202.46 |
(0.5*175.29+0.5*186.43+2*202.46)/3= |
$195.26 |
April |
$546.10 |
(0.5*618.8+0.5*579.71+2*546.1)/3= |
$563.82 |
|
May |
$194.29 |
(0.5*186.43+0.5*202.46+2*194.29)/3= |
$194.34 |
May |
$518.62 |
(0.5*579.71+0.5*546.1+2*518.62)/3= |
$533.38 |
|
June |
$206.79 |
(0.5*202.46+0.5*194.29+2*206.79)/3= |
$203.99 |
June |
$500.38 |
(0.5*546.1+0.5*518.62+2*500.38)/3= |
$511.04 |
|
July |
$229.17 |
(0.5*194.29+0.5*206.79+2*229.17)/3= |
$219.63 |
July |
$605.19 |
(0.5*518.62+0.5*500.38+2*605.19)/3= |
$573.29 |
|
August |
$209.08 |
(0.5*206.79+0.5*229.17+2*209.08)/3= |
$212.05 |
August |
$538.71 |
(0.5*500.38+0.5*605.19+2*538.71)/3= |
$543.40 |
|
September |
$218.63 |
(0.5*229.17+0.5*209.08+2*218.63)/3= |
$218.80 |
September |
$513.74 |
(0.5*605.19+0.5*538.71+2*513.74)/3= |
$533.14 |
|
October |
$214.11 |
(0.5*209.08+0.5*218.63+2*214.11)/3= |
$214.03 |
October |
$597.69 |
(0.5*538.71+0.5*513.74+2*597.69)/3= |
$573.87 |
|
November |
$194.54 |
(0.5*218.63+0.5*214.11+2*194.54)/3= |
$201.82 |
November |
$595.04 |
(0.5*513.74+0.5*597.69+2*595.04)/3= |
$581.93 |
|
December |
$174.50 |
(0.5*214.11+0.5*194.54+2*174.5)/3= |
$184.44 |
December |
$651.40 |
(0.5*597.69+0.5*595.04+2*651.4)/3= |
$633.06 |
