When we calculate the CAPM, we need to use the Bata. So can you help me calculated it in Excel. All ordinary data as follows:

Market Index Values for All Ordinaries for the financial year 2017 - 2018
Date	Open	High	Low	Close	Adj Close
2017/6/30	5855.899902	5855.899902	5760.100098	5764	5764
2017/7/3	5764	5772.5	5726.5	5727.5	5727.5
2017/7/4	5727.5	5828	5727.5	5819.600098	5819.600098
2017/7/5	5819.600098	5827	5793.399902	5801	5801
2017/7/6	5801	5808.799805	5780.100098	5797.5	5797.5
2017/7/7	5797.5	5797.5	5717.299805	5743.899902	5743.899902
2017/7/10	5743.899902	5786	5743.899902	5762.899902	5762.899902
2017/7/11	5762.899902	5783.299805	5741.899902	5768.5	5768.5
2017/7/12	5768.5	5769.700195	5710.100098	5717.700195	5717.700195
2017/7/13	5717.700195	5784.200195	5717.700195	5779.100098	5779.100098
2017/7/14	5779.100098	5820.799805	5779.100098	5808.700195	5808.700195
2017/7/17	5808.700195	5818.5	5782.5	5800.799805	5800.799805
2017/7/18	5800.799805	5807.700195	5729.899902	5738.200195	5738.200195
2017/7/19	5738.100098	5790.5	5738.100098	5779.399902	5779.399902
2017/7/20	5779.399902	5814.700195	5779.399902	5805.700195	5805.700195
2017/7/21	5805.700195	5805.700195	5757.399902	5771.200195	5771.200195
2017/7/24	5771.200195	5771.200195	5705.600098	5738	5738
2017/7/25	5738	5790.799805	5738	5775.299805	5775.299805
2017/7/26	5775.299805	5833.899902	5775.299805	5823.299805	5823.299805
2017/7/27	5823.299805	5846.200195	5823.299805	5832.200195	5832.200195
2017/7/28	5832.200195	5832.200195	5746.200195	5755.200195	5755.200195
2017/7/31	5755.200195	5796	5755.200195	5773.899902	5773.899902
2017/8/1	5773.899902	5823.299805	5773.899902	5820.600098	5820.600098
2017/8/2	5820.600098	5827.600098	5789.899902	5794.5	5794.5
2017/8/3	5794.5	5794.799805	5758.799805	5786.799805	5786.799805
2017/8/4	5786.799805	5791.5	5764.299805	5773.299805	5773.299805
2017/8/7	5773.299805	5831.399902	5773.299805	5824.5	5824.5
2017/8/8	5824.5	5842	5775.399902	5795.700195	5795.700195
2017/8/9	5795.700195	5826.799805	5794.899902	5816.399902	5816.399902
2017/8/10	5816.399902	5843.399902	5798.5	5810.600098	5810.600098
2017/8/11	5810.600098	5810.600098	5725.799805	5743.5	5743.5
2017/8/14	5743.5	5783.299805	5743.5	5778.600098	5778.600098
2017/8/15	5778.600098	5821.799805	5778.600098	5804	5804
2017/8/16	5804	5830.799805	5778.600098	5830.799805	5830.799805
2017/8/17	5830.799805	5852.700195	5815.100098	5827.200195	5827.200195
2017/8/18	5827.200195	5827.200195	5762.700195	5798.5	5798.5
2017/8/21	5798.5	5798.5	5754.5	5780	5780
2017/8/22	5780	5805.200195	5780	5804.799805	5804.799805
2017/8/23	5804.799805	5834.299805	5779.700195	5792.700195	5792.700195
2017/8/24	5792.700195	5809.399902	5774.100098	5801.700195	5801.700195
2017/8/25	5801.700195	5809.700195	5780	5803.399902	5803.399902
2017/8/28	5803.399902	5806.100098	5761.899902	5771.200195	5771.200195
2017/8/29	5771	5771	5711.700195	5733.600098	5733.600098
2017/8/30	5733.600098	5753.299805	5720.700195	5733.799805	5733.799805
2017/8/31	5733.799805	5776.299805	5733.799805	5776.299805	5776.299805
2017/9/1	5776.299805	5795.899902	5764.700195	5786.100098	5786.100098
2017/9/4	5786.100098	5786.100098	5753.200195	5763.799805	5763.799805
2017/9/5	5763.799805	5767.799805	5730	5767.799805	5767.799805
2017/9/6	5767.799805	5767.799805	5726.700195	5752.899902	5752.899902
2017/9/7	5752.899902	5780	5743.899902	5753.799805	5753.799805
2017/9/8	5753.799805	5758.899902	5729.299805	5739.399902	5739.399902
2017/9/11	5739.600098	5784.600098	5737	5779	5779
2017/9/12	5775.100098	5823.399902	5775.100098	5806.399902	5806.399902
2017/9/13	5806.399902	5835.700195	5804	5804	5804
2017/9/14	5804	5808.799805	5788	5798.399902	5798.399902
2017/9/15	5798.399902	5798.399902	5748.100098	5755.799805	5755.799805
2017/9/18	5755.799805	5789.899902	5755.799805	5779	5779
2017/9/19	5779	5800	5772.399902	5772.399902	5772.399902
2017/9/20	5772.399902	5772.399902	5742.600098	5769.700195	5769.700195
2017/9/21	5769.700195	5769.700195	5702.200195	5716.700195	5716.700195
2017/9/22	5716.700195	5746.200195	5716.700195	5740.600098	5740.600098
2017/9/25	5740.600098	5767.100098	5737.399902	5741.700195	5741.700195
2017/9/26	5741.700195	5756.799805	5724.899902	5729.600098	5729.600098
2017/9/27	5729.600098	5731.299805	5709.700195	5725.5	5725.5
2017/9/28	5725.5	5745.700195	5725.5	5731.5	5731.5
2017/9/29	5731.5	5749.799805	5715.399902	5744.899902	5744.899902
2017/10/1	5744.899902	5811.5	5744.899902	5791.299805	5791.299805
2017/10/2	5791.299805	5799.600098	5756.100098	5764.200195	5764.200195
2017/10/3	5764.200195	5765.700195	5717.700195	5719.600098	5719.600098
2017/10/4	5719.600098	5739.700195	5718.899902	5720.299805	5720.299805
2017/10/5	5720.299805	5777.399902	5720.299805	5777.399902	5777.399902
2017/10/8	5777.600098	5824.399902	5777.600098	5805.100098	5805.100098
2017/10/9	5805.100098	5818.600098	5788.799805	5807.100098	5807.100098
2017/10/10	5807.100098	5846.600098	5807.100098	5840.799805	5840.799805
2017/10/11	5840.799805	5864.100098	5834.299805	5864.100098	5864.100098
2017/10/12	5864.100098	5894.299805	5862.399902	5884.700195	5884.700195
2017/10/15	5884.700195	5924.899902	5884.700195	5917.200195	5917.200195
2017/10/16	5917.200195	5963.700195	5917.200195	5958.100098	5958.100098
2017/10/17	5958.100098	5969.5	5954.799805	5954.799805	5954.799805
2017/10/18	5954.799805	5973.200195	5949.100098	5959.799805	5959.799805
2017/10/19	5959.799805	5985.700195	5932.600098	5968.600098	5968.600098
2017/10/22	5968.600098	5987.299805	5955.5	5957.200195	5957.200195
2017/10/23	5957.200195	5972.299805	5949.799805	5962.5	5962.5
2017/10/24	5962.5	5983.899902	5961.700195	5972.700195	5972.700195
2017/10/25	5972.700195	5982.5	5952.600098	5982.5	5982.5
2017/10/26	5982.5	6003.200195	5928.200195	5969.299805	5969.299805
2017/10/29	5969.700195	5991.5	5969.700195	5983.700195	5983.700195
2017/10/30	5983.700195	5998.600098	5974.899902	5976.399902	5976.399902
2017/10/31	5976.399902	6019.299805	5976.399902	6005.5	6005.5
2017/11/1	6005.5	6029.700195	6000.700195	6002.200195	6002.200195
2017/11/2	6002.200195	6037.899902	6002.200195	6030.299805	6030.299805
2017/11/5	6030.299805	6038	6020.700195	6027.200195	6027.200195
2017/11/6	6027.200195	6090.100098	6027.200195	6087.399902	6087.399902
2017/11/7	6087.399902	6095.200195	6068.799805	6089.100098	6089.100098
2017/11/8	6089.100098	6124.700195	6089.100098	6122.399902	6122.399902
2017/11/9	6122.399902	6122.399902	6095.899902	6104.299805	6104.299805
2017/11/12	6104.299805	6105	6088	6097.200195	6097.200195
2017/11/13	6097.200195	6097.200195	6037.299805	6048.700195	6048.700195
2017/11/14	6048.700195	6048.700195	6012.299805	6012.299805	6012.299805
2017/11/15	6012.299805	6033	5994.399902	6023.5	6023.5
2017/11/16	6023.5	6058.5	6023.5	6038.299805	6038.299805
2017/11/19	6038.299805	6038.299805	6006.299805	6028	6028
2017/11/20	6028	6048.799805	6026.5	6044.200195	6044.200195
2017/11/21	6044.200195	6078.100098	6044.200195	6067.600098	6067.600098
2017/11/22	6067.600098	6072.600098	6053	6067.5	6067.5
2017/11/23	6067.600098	6067.600098	6034.5	6063.100098	6063.100098
2017/11/26	6063.100098	6089.899902	6060.299805	6070.399902	6070.399902
2017/11/27	6070.399902	6085.899902	6058.799805	6066.700195	6066.700195
2017/11/28	6066.700195	6113.700195	6066.700195	6096.100098	6096.100098
2017/11/29	6096.100098	6096.100098	6039.200195	6057.200195	6057.200195
2017/11/30	6057.200195	6095.899902	6057.200195	6075.5	6075.5
2017/12/3	6075.5	6087.100098	6065.299805	6070.600098	6070.600098
2017/12/4	6070.600098	6070.600098	6036.600098	6057.299805	6057.299805
2017/12/5	6057.299805	6057.299805	6023.5	6029.899902	6029.899902
2017/12/6	6029.899902	6069	6028.399902	6060.799805	6060.799805
2017/12/7	6060.799805	6092.299805	6060.799805	6077.399902	6077.399902
2017/12/10	6077.399902	6096.899902	6074.600098	6081.899902	6081.899902
2017/12/11	6081.899902	6098.299805	6081.100098	6093.100098	6093.100098
2017/12/12	6093.100098	6106.200195	6085.399902	6103.100098	6103.100098
2017/12/13	6103.100098	6125.299805	6096.399902	6096.399902	6096.399902
2017/12/14	6096.399902	6096.399902	6077.700195	6087.100098	6087.100098
2017/12/17	6087.100098	6130.5	6087.100098	6130	6130
2017/12/18	6130	6170.799805	6130	6163.200195	6163.200195
2017/12/19	6163.200195	6174	6148.799805	6167.899902	6167.899902
2017/12/20	6167.899902	6173.799805	6148.5	6156.299805	6156.299805
2017/12/21	6156.299805	6181.600098	6156.299805	6167.299805	6167.299805
2017/12/26	6167.299805	6190.600098	6167.299805	6169.700195	6169.700195
2017/12/27	6169.700195	6189.399902	6163	6189.399902	6189.399902
2017/12/28	6189.399902	6193	6155	6167.299805	6167.299805
2018/1/1	6167.299805	6177.399902	6141.399902	6166	6166
2018/1/2	6166	6186.399902	6166	6175.299805	6175.299805
2018/1/3	6175.299805	6206.600098	6175.299805	6185.399902	6185.399902
2018/1/4	6185.399902	6232.100098	6185.399902	6229.700195	6229.700195
2018/1/7	6229.700195	6251.100098	6229.700195	6236.5	6236.5
2018/1/8	6236.5	6254.100098	6236.5	6241.5	6241.5
2018/1/9	6241.5	6256.5	6205.200195	6205.899902	6205.899902
2018/1/10	6205.899902	6206.299805	6163.899902	6176.200195	6176.200195
2018/1/11	6176.200195	6192.600098	6176.200195	6176.799805	6176.799805
2018/1/14	6176.799805	6210.399902	6176.799805	6187.700195	6187.700195
2018/1/15	6187.700195	6189.200195	6156.100098	6165.899902	6165.899902
2018/1/16	6165.899902	6165.899902	6131	6134.299805	6134.299805
2018/1/17	6134.299805	6153.399902	6130.399902	6130.399902	6130.399902
2018/1/18	6130.399902	6143.600098	6117.100098	6119.299805	6119.299805
2018/1/21	6119.299805	6130.899902	6106.200195	6106.200195	6106.200195
2018/1/22	6106.200195	6154.799805	6106.200195	6150.700195	6150.700195
2018/1/23	6150.700195	6178.899902	6150.100098	6168.799805	6168.799805
2018/1/24	6168.799805	6170.299805	6144.700195	6164.700195	6164.700195
2018/1/28	6164.700195	6200.600098	6164.700195	6187.600098	6187.600098
2018/1/29	6187.600098	6187.600098	6130.799805	6135.299805	6135.299805
2018/1/30	6135.299805	6151.799805	6103.899902	6146.5	6146.5
2018/1/31	6146.5	6201.700195	6146.5	6198.799805	6198.799805
2018/2/1	6198.799805	6229.799805	6186.899902	6229.799805	6229.799805
2018/2/4	6229.799805	6229.799805	6117.200195	6128.399902	6128.399902
2018/2/5	6128.399902	6128.399902	5893.799805	5930.200195	5930.200195
2018/2/6	5930.200195	6039.899902	5930.200195	5981.5	5981.5
2018/2/7	5981.5	5998.399902	5946.5	5995.200195	5995.200195
2018/2/8	5995.200195	5995.200195	5887.299805	5937.5	5937.5
2018/2/11	5937.5	5939.100098	5893.100098	5919.700195	5919.700195
2018/2/12	5919.700195	5962.100098	5916.700195	5957	5957
2018/2/13	5957	5968	5931.299805	5940	5940
2018/2/14	5940	6012.299805	5940	6008.700195	6008.700195
2018/2/15	6008.700195	6037.5	6004.299805	6004.799805	6004.799805
2018/2/18	6005.100098	6052.100098	5992.899902	6044	6044
2018/2/19	6044	6047	6019	6045.600098	6045.600098
2018/2/20	6045.600098	6059.100098	6026.899902	6047.299805	6047.299805
2018/2/21	6047.299805	6076	6036.899902	6057.700195	6057.700195
2018/2/22	6057.700195	6108.100098	6057.700195	6105.200195	6105.200195
2018/2/25	6105.200195	6146.100098	6105.200195	6146.100098	6146.100098
2018/2/26	6146.100098	6184.600098	6146.100098	6159.299805	6159.299805
2018/2/27	6159.299805	6159.299805	6114.399902	6117.299805	6117.299805
2018/2/28	6117.299805	6117.299805	6061.200195	6075.700195	6075.700195
2018/3/1	6075.700195	6075.700195	6004.200195	6028.399902	6028.399902
2018/3/4	6028.399902	6028.399902	5988.100098	5996.399902	5996.399902
2018/3/5	5996.399902	6077.399902	5996.399902	6061.5	6061.5
2018/3/6	6061.5	6061.5	5998.200195	6005.399902	6005.399902
2018/3/7	6005.399902	6046.600098	6000.100098	6046.600098	6046.600098
2018/3/8	6046.600098	6082.200195	6046.100098	6069.100098	6069.100098
2018/3/11	6076.399902	6130.700195	6076.399902	6101.399902	6101.399902
2018/3/12	6101.399902	6101.399902	6055.100098	6077.100098	6077.100098
2018/3/13	6077.100098	6077.100098	6027.399902	6042.600098	6042.600098
2018/3/14	6042.600098	6042.600098	6013.5	6027.600098	6027.600098
2018/3/15	6027.600098	6058.799805	6027.600098	6054.899902	6054.899902
2018/3/18	6054.899902	6086.100098	6040.200195	6064.700195	6064.700195
2018/3/19	6064.700195	6064.700195	6020.700195	6040.799805	6040.799805
2018/3/20	6040.799805	6066.299805	6039.700195	6053.100098	6053.100098
2018/3/21	6053.100098	6060.600098	6014.899902	6043.200195	6043.200195
2018/3/22	6043.200195	6043.200195	5916.899902	5929	5929
2018/3/25	5929	5929	5881	5901.399902	5901.399902
2018/3/26	5901.399902	5948.299805	5901.399902	5943.700195	5943.700195
2018/3/27	5943.700195	5943.700195	5892.299805	5899.200195	5899.200195
2018/3/28	5899.200195	5912.399902	5861.899902	5868.899902	5868.899902
2018/4/3	5868.899902	5873.100098	5834	5859.100098	5859.100098
2018/4/4	5859.100098	5870.299805	5836.200195	5863.700195	5863.700195
2018/4/5	5863.700195	5905.299805	5863.700195	5888	5888
2018/4/6	5888	5897.200195	5860.799805	5886.899902	5886.899902
2018/4/9	5886.899902	5911.200195	5868.899902	5904.700195	5904.700195
2018/4/10	5904.700195	5951.799805	5883.700195	5951.799805	5951.799805
2018/4/11	5951.799805	5958.200195	5922.399902	5925.799805	5925.799805
2018/4/12	5925.799805	5932.200195	5898.100098	5911.399902	5911.399902
2018/4/13	5911.399902	5940	5911.399902	5924.700195	5924.700195
2018/4/16	5924.700195	5959.200195	5924.700195	5933	5933
2018/4/17	5933	5962.799805	5933	5934.299805	5934.299805
2018/4/18	5934.299805	5959.200195	5934.299805	5956.299805	5956.299805
2018/4/19	5956.299805	5996.299805	5956.299805	5976.399902	5976.399902
2018/4/20	5976.399902	5979.899902	5957.899902	5964.399902	5964.399902
2018/4/23	5964.399902	5986.600098	5964.399902	5976	5976
2018/4/24	5976	6015.700195	5970	6009.399902	6009.399902
2018/4/26	6009.200195	6027.600098	5996.399902	6003	6003
2018/4/27	6003	6042.899902	6003	6042.899902	6042.899902
2018/4/30	6042.899902	6079.299805	6036.100098	6071.600098	6071.600098
2018/5/1	6071.600098	6107.5	6067.899902	6100	6100
2018/5/2	6100	6139.700195	6096	6136.700195	6136.700195
2018/5/3	6136.700195	6197.899902	6136.700195	6187	6187
2018/5/4	6187	6199	6154.799805	6155.399902	6155.399902
2018/5/7	6155.399902	6201.299805	6155.399902	6175.600098	6175.600098
2018/5/8	6175.600098	6201.600098	6175.600098	6183.200195	6183.200195
2018/5/9	6183.200195	6208.700195	6175.5	6204.399902	6204.399902
2018/5/10	6204.399902	6240.799805	6204.399902	6215.899902	6215.899902
2018/5/11	6215.899902	6238.700195	6215.899902	6216.399902	6216.399902
2018/5/14	6216.399902	6235	6211.799805	6235	6235
2018/5/15	6235	6245.899902	6198.700195	6198.700195	6198.700195
2018/5/16	6198.700195	6228.299805	6195.600098	6208.100098	6208.100098
2018/5/17	6208.100098	6220.5	6181.899902	6197.200195	6197.200195
2018/5/18	6197.200195	6212.700195	6183.399902	6190.899902	6190.899902
2018/5/21	6190.899902	6200.799805	6176.200195	6190.200195	6190.200195
2018/5/22	6190.200195	6190.200195	6138.299805	6149.899902	6149.899902
2018/5/23	6149.899902	6163.899902	6135.299805	6140.299805	6140.299805
2018/5/24	6140.299805	6147.899902	6120.799805	6144.100098	6144.100098
2018/5/25	6144.100098	6145.200195	6123.600098	6141	6141
2018/5/28	6141	6141	6103.799805	6113.600098	6113.600098
2018/5/29	6113.600098	6132.899902	6104.600098	6121.700195	6121.700195
2018/5/30	6121.700195	6121.700195	6072.600098	6093.799805	6093.799805
2018/5/31	6093.799805	6132.399902	6093.799805	6123.5	6123.5
2018/6/1	6123.5	6123.5	6086.799805	6104	6104
2018/6/4	6104	6149.200195	6104	6138.600098	6138.600098
2018/6/5	6138.600098	6138.600098	6097	6108.5	6108.5
2018/6/6	6108.5	6138.299805	6108.5	6137.399902	6137.399902
2018/6/7	6137.399902	6181.799805	6137.399902	6169.399902	6169.399902
2018/6/8	6169.399902	6172.799805	6153.200195	6156.799805	6156.799805
2018/6/12	6156.799805	6173.899902	6153.799805	6164.799805	6164.799805
2018/6/13	6164.799805	6164.799805	6121.5	6133.100098	6133.100098
2018/6/14	6133.100098	6144.700195	6118.799805	6129.600098	6129.600098
2018/6/15	6129.600098	6211.200195	6129.600098	6205.299805	6205.299805
2018/6/18	6205.299805	6222.399902	6195.600098	6212.799805	6212.799805
2018/6/19	6212.799805	6253.299805	6208.799805	6208.899902	6208.899902
2018/6/20	6208.899902	6274.600098	6208.899902	6274.600098	6274.600098
2018/6/21	6274.600098	6347.799805	6274.600098	6332.899902	6332.899902
2018/6/22	6332.899902	6341.600098	6314.5	6322.100098	6322.100098
2018/6/25	6322.5	6347.5	6302.799805	6308.700195	6308.700195
2018/6/26	6308.700195	6308.700195	6259.299805	6292.100098	6292.100098
2018/6/27	6292.100098	6311.299805	6286.100098	6290.5	6290.5
2018/6/28	6290.5	6310.5	6273.399902	6305.799805	6305.799805
2018/6/29	6305.799805	6322.100098	6289.700195	6289.700195	6289.700195

other data linked: https://drive.google.com/open?id=1PnuyXkuO7TwB2CTy0sETYnE4tusoumFm