TCS Backtest DMADMA.xlsx

	A	B	C	D	E	F	G	H	I	J
1	Date	Open	High	Low	Close	200 DMA	100 DMA	50 DMA	Outout	Difference from 200 DMA

2	8/10/2018	2102.65	2122.20	2048.15	2077.55
3	9/10/2018	2080.35	2107.65	2053.20	2091.80
4	10/10/2018	2100.00	2105.95	2029.00	2043.60
5	11/10/2018	1985.00	2013.00	1941.00	1979.95
6	12/10/2018	1978.00	1978.00	1903.00	1918.30
7	15/10/2018	1940.00	1955.55	1920.00	1949.50
8	16/10/2018	1958.00	1971.90	1935.00	1962.30
9	17/10/2018	1970.00	1989.00	1920.00	1929.40
10	19/10/2018	1929.00	1929.00	1870.05	1913.20
11	22/10/2018	1914.00	1916.00	1886.95	1903.00
12	23/10/2018	1888.00	1898.00	1837.00	1843.65
13	24/10/2018	1852.05	1874.00	1811.10	1848.50
14	25/10/2018	1844.00	1876.90	1825.05	1853.00
15	26/10/2018	1853.90	1853.90	1791.10	1799.10
16	29/10/2018	1808.70	1877.95	1784.35	1871.00
17	30/10/2018	1867.00	1909.40	1845.00	1894.80
18	31/10/2018	1900.00	1943.90	1875.45	1938.15
19	1/11/2018	1943.65	1944.35	1901.30	1935.75
20	2/11/2018	1934.20	1954.60	1905.00	1913.45
21	5/11/2018	1910.00	1927.35	1884.75	1890.85
22	6/11/2018	1894.00	1937.50	1891.00	1932.70
23	7/11/2018	1940.00	1949.00	1937.00	1942.15
24	9/11/2018	1961.00	1961.95	1905.00	1909.20
25	12/11/2018	1908.50	1946.10	1908.50	1914.85
26	13/11/2018	1915.00	1939.00	1903.00	1934.95
27	14/11/2018	1925.00	1929.90	1870.00	1880.65
28	15/11/2018	1864.00	1899.00	1857.60	1872.85
29	16/11/2018	1889.00	1899.80	1870.25	1886.60
30	19/11/2018	1899.00	1907.35	1864.30	1902.45
31	20/11/2018	1902.00	1902.00	1874.20	1878.25
32	21/11/2018	1871.00	1871.05	1798.55	1812.00
33	22/11/2018	1820.00	1847.60	1809.95	1812.55
34	26/11/2018	1819.00	1860.00	1784.50	1846.10
35	27/11/2018	1854.00	1897.90	1835.35	1890.25
36	28/11/2018	1889.00	1989.00	1882.50	1983.90
37	29/11/2018	1997.00	1997.00	1942.55	1960.55
38	30/11/2018	1966.00	1991.00	1959.85	1968.25
39	3/12/2018	1984.00	1990.00	1968.30	1982.40
40	4/12/2018	1983.00	2019.40	1971.00	2010.85
41	5/12/2018	2006.00	2018.00	1985.00	2006.75
42	6/12/2018	1998.00	2017.00	1979.60	1992.70
43	7/12/2018	1985.05	2003.90	1973.00	1995.20
44	10/12/2018	1975.00	2011.00	1960.00	1975.80
45	11/12/2018	1970.00	2010.00	1961.00	2000.00
46	12/12/2018	2001.10	2022.00	1984.95	2016.80
47	13/12/2018	2024.00	2029.70	1974.50	1982.60
48	14/12/2018	1983.00	1998.95	1975.25	1989.75
49	17/12/2018	1999.00	2004.90	1985.00	1994.30
50	18/12/2018	1991.90	2002.00	1976.40	1987.85
51	19/12/2018	1984.80	1984.80	1960.05	1968.45			1935.77
52	20/12/2018	1953.80	1974.90	1946.00	1954.05			1933.30
53	21/12/2018	1948.00	1950.00	1886.55	1895.80			1929.38
54	24/12/2018	1905.80	1938.90	1905.00	1918.50			1926.88
55	26/12/2018	1921.80	1921.80	1870.25	1889.20			1925.06
56	27/12/2018	1909.00	1941.70	1872.10	1908.95			1924.88
57	28/12/2018	1915.00	1920.00	1893.00	1896.05			1923.81
58	31/12/2018	1908.00	1909.00	1886.15	1893.05			1922.42
59	1/1/2019	1896.00	1910.00	1885.00	1902.80			1921.89
60	2/1/2019	1905.00	1934.45	1900.00	1923.30			1922.09
61	3/1/2019	1919.00	1944.95	1893.10	1899.95			1922.03
62	4/1/2019	1900.00	1901.20	1841.00	1876.85			1922.70
63	7/1/2019	1891.80	1908.80	1881.00	1897.90			1923.68
64	8/1/2019	1905.40	1906.40	1883.30	1893.55			1924.50
65	9/1/2019	1907.40	1919.00	1866.70	1886.95			1926.25
66	10/1/2019	1890.00	1905.00	1872.10	1888.55			1926.60
67	11/1/2019	1870.00	1875.00	1835.00	1842.55			1925.56
68	14/1/2019	1850.00	1851.00	1810.00	1813.25			1923.06
69	15/1/2019	1810.00	1869.35	1808.00	1867.80			1921.70
70	16/1/2019	1870.00	1875.00	1847.00	1870.15			1920.84
71	17/1/2019	1878.00	1898.00	1871.30	1894.30			1920.90
72	18/1/2019	1881.00	1904.20	1876.00	1900.65			1920.26
73	21/1/2019	1902.00	1932.00	1895.45	1908.70			1919.59
74	22/1/2019	1907.10	1918.25	1890.00	1901.90			1919.45
75	23/1/2019	1901.00	1906.10	1870.00	1875.60			1918.66
76	24/1/2019	1884.80	1905.25	1875.00	1901.55			1918.00
77	25/1/2019	1902.00	1935.00	1901.00	1920.80			1918.80
78	28/1/2019	1933.00	1962.00	1925.50	1955.00			1920.44
79	29/1/2019	1962.00	1989.05	1936.65	1982.75			1922.36
80	30/1/2019	1979.60	1989.50	1954.65	1981.40			1923.94
81	31/1/2019	1987.00	2019.75	1985.00	2014.10			1926.66
82	1/2/2019	2009.50	2034.75	1998.10	2029.95			1931.02
83	4/2/2019	2029.95	2055.45	2023.00	2050.25			1935.77
84	5/2/2019	2050.00	2055.00	2028.00	2044.55			1939.74
85	6/2/2019	2049.90	2086.85	2041.05	2074.80			1943.43
86	7/2/2019	2074.75	2097.95	2067.00	2082.90			1945.41
87	8/2/2019	2075.00	2089.50	2051.00	2061.40			1947.43
88	11/2/2019	2060.00	2096.00	2048.90	2065.90			1949.38
89	12/2/2019	2070.00	2070.00	2018.00	2051.60			1950.77
90	14/2/2019	2060.05	2075.00	2033.05	2044.60			1951.44
91	15/2/2019	2049.00	2052.00	2010.95	2029.70			1951.90
92	18/2/2019	2037.60	2041.95	1962.65	1970.30			1951.45
93	19/2/2019	1970.00	1971.00	1892.00	1904.80			1949.65
94	20/2/2019	1915.00	1933.80	1881.30	1914.75			1948.42
95	21/2/2019	1914.75	1940.00	1897.05	1914.20			1946.71
96	22/2/2019	1917.20	1930.00	1905.10	1925.65			1944.89
97	25/2/2019	1932.50	1990.00	1930.50	1985.15			1944.94
98	26/2/2019	1984.00	2045.15	1972.25	2038.70			1945.92
99	27/2/2019	2040.00	2074.95	2022.00	2058.10			1947.19
100	28/2/2019	2060.00	2071.35	1977.60	1983.45			1947.10