MACD Calculation

	A	B	C	D	E	F	G	H
1	Period	Enter Values For The Period	Enter Fast EMA Period ->	12
2			Enter Slow EMA Period ->	24
3			Enter Signal Line Period ->	9
4		Closed Price	MACD Line Calculation	Signal Line Calculation	Standard error Fast EMA	Standard error Slow EMA	Fast EMA	Slow EMA
5	n	12.520	0.2821	0.6222	0.8380	0.9766	12.2240	12.5061
6	n-1	12.010	-0.1405	0.6418	0.8570	0.9777	12.1541	12.0136
7	n-2	11.850	0.8855	0.6927	0.8557	0.9777	11.8184	11.8468
8	n-3	11.320	0.7706	0.7082	0.8649	0.9779	11.8968	11.3281
9	n-4	12.430	0.8610	0.7242	0.8721	0.9780	12.6338	12.5893
10	n-5	10.859	0.7383	0.7186	0.9219	0.9786	10.2552	10.5674
11	n-6	7.659	0.5111	0.7027	1.0027	0.9939	9.3701	7.7924
12	n-7	11.193	0.7888	0.7397	1.0394	0.9781	9.0424	11.4385
13	n-8	13.019	0.9032	0.7634	1.2631	0.9789	13.0663	12.6242
14	n-9	7.108	0.4582	0.7061	1.2470	0.9984	8.6185	7.0670
15	n-10	4.762	0.3178	0.7038	1.2260	0.9791	3.8853	4.8832
16	n-11	14.194	1.0247	0.8167	1.7310	0.9433	13.6781	14.5199
17	n-12	13.412	0.9148	0.7790	1.7959	0.9393	13.4167	13.6628
18	n-13	11.891	0.8106	0.7382	1.7954	0.9583	11.7222	11.3810
19	n-14	8.876	0.5956	0.8638	1.7956	1.0019	9.0315	8.9041
20	n-15	12.024	0.8439	0.9313	1.7624	1.0027	12.0873	11.8802
21	n-16	14.415	1.0022	0.9351	1.7606	1.0056	14.2194	14.3948
22	n-17	6.247	0.3873	1.1397	1.7669	0.9981	5.9744	6.1834
23	n-18	6.307	0.4371	0.9780	1.7270	0.9779	5.8306	5.5389
24	n-19	18.509	1.3345	0.9465	1.6199	0.9489	19.8737	19.4576
25	n-20	10.607	0.6847	0.8037	1.5454	0.9021	9.9095	10.4949
26	n-21	8.108	0.5482	0.7268	1.6172	0.9011	-11.8493	-5.5130
27	n-22	26.825	1.9404	0.6919	1.5734	0.8875	39.7955	37.2455
28	n-23	18.232	1.2031	0.4887	0.8978	0.5868	26.1668	21.7607
29	n-24	13.102	0.8787	0.3207	0.6433	0.4963	14.3675	12.8464
30	n-25	11.850	2.8434	0.2373	0.6808	0.5041	10.8652	13.7087
31	n-26	11.32	-1.0686	0.0030	0.8180	0.5020	10.6623	9.5938
32	n-27	12.43	0.1537	0.0115	0.8975	0.5973	12.2177	12.3715
33	n-28	10.859	0.0498	0.2660	0.9232	0.6012	10.5476	10.5974
34	n-29	7.659	-0.0072	-0.4918	0.9346	0.6024	7.9554	7.9483
35	n-30	11.193	0.2339	0.0037	0.9133	0.5842	10.7837	11.0176
36	n-31	13.019	0.1111	-0.0180	0.9230	0.5868	12.9504	13.0615
37	n-32	7.108	-0.3087	0.0112	0.9028	0.5812	7.4916	7.1829
38	n-33	10.607	0.1279	0.0052	0.8593	0.5745	10.3276	10.4555
39	n-34	8.108	0.7352	0.0421	0.8612	0.5740	8.0335	8.7687
40	n-35	13.019	-0.9926	-0.2376	0.8348	0.5630	13.1703	12.1777
41	n-36	7.108	2.4445	0.0246	0.8142	0.5855	4.9929	7.4375
42	n-37	4.762	-6.7706	-0.1945	0.7942	0.5587	11.3642	4.5936
43	n-38	14.194	4.4529	0.3821	0.5360	0.5575	9.8006	14.2535
44	n-39	13.412	0.0382	0.0338	0.7695	0.5505	13.4968	13.5350
45	n-40	11.891	0.3739	-0.1687	0.7647	0.5457	11.2868	11.6607
46	n-41	8.876	-0.3624	0.1310	0.7646	0.5458	9.4983	9.1359
47	n-42	12.024	0.4597	0.0600	0.7158	0.5322	12.1245	12.5842
48	n-43	12.01	-1.7817	0.0064	0.7169	0.5337	13.2011	11.4195
49	n-44	11.85	1.3664	0.2031	0.7240	0.5614	10.5465	11.9129
50	n-45	11.32	0.4730	0.0559	0.8139	0.5615	11.4166	11.8896
51	n-46	12.43	-1.5811	-0.0768	0.8143	0.5648	13.3860	11.8048
52	n-47	10.859	1.3185	0.1973	0.8211	0.5952	9.2251	10.5435
53	n-48	7.659	-1.7842	0.0352	0.9097	0.5957	10.1854	8.4012
54	n-49	11.193	3.0707	0.1225	0.8461	0.5729	5.6431	8.7138
55	n-50	18.232	-1.0012	-0.0953	1.0247	0.5961	21.6764	20.6752
56	n-51	13.102	-0.0227	0.0297	0.8558	0.5360	13.2564	13.2337
57	n-52	11.85	-0.0112	-0.0222	0.8458	0.5530	11.8894	11.8782
58	n-53	11.32	0.0418	-0.0579	0.8458	0.5790	11.2676	11.3095
59	n-54	12.43	-0.7217	-0.0626	0.8487	0.6091	13.2050	12.4834
60	n-55	10.859	0.8860	0.0176	0.8478	0.6373	9.5034	10.3893
61	n-56	7.659	-0.1410	-0.0808	0.9117	0.6748	8.3650	8.2240
62	n-57	11.193	-0.9986	-0.0652	0.8461	0.6868	12.1449	11.1464
63	n-58	13.019	1.1109	0.0458	0.8547	0.7325	11.2769	12.3877
64	n-59	7.108	0.1238	-0.0776	0.9307	0.7711	7.7623	7.8861
65	n-60	10.607	-0.4902	-0.0914	0.8497	0.7734	4.1939	3.7038
66	n-61	18.232	-0.3325	-0.0369	0.8478	0.8363	24.9319	24.5994
67	n-62	13.102	0.0000	0.0000	0.6266	0.6266	13.7156	13.7156
68	n-63	11.85	0.0000	#DIV/0!	0.6394	0.6394	12.0681	12.0681
69	n-64	11.32	0.0000	#DIV/0!	0.6905	0.6905	10.8184	10.8184
70	n-65	12.43	0.0000	#DIV/0!	0.7644	0.7644	13.2191	13.2191
71	n-66	10.859	0.0000	#DIV/0!	0.8027	0.8027	10.1546	10.1546
72	n-67	7.659	0.0000	#DIV/0!	0.9198	0.9198	8.9433	8.9433
73	n-68	11.193	0.0000	#DIV/0!	1.0091	1.0091	8.0981	8.0981
74	n-69	13.019	0.0000	#DIV/0!	1.2235	1.2235	14.9005	14.9005
75	n-70	7.108	0.0000	#DIV/0!	1.1256	1.1256	11.0687	11.0687
76	n-71	10.607	#DIV/0!	#DIV/0!	1.2581	1.2581	#DIV/0!	#DIV/0!
77	n-72	10.859	#DIV/0!	#DIV/0!	2.2627	2.2627	#DIV/0!	#DIV/0!
78	n-73	7.659	#DIV/0!	#DIV/0!	#DIV/0!	#DIV/0!	#DIV/0!	#DIV/0!
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100