Scribd
Upload
76 views7 pages

Risk and Return in Excel

This document contains daily closing price and return data for Tata Steel Ltd. stock from the Bombay Stock Exchange from September 3, 2019 to August 5, 2020. Key statistics calculated from the data include an average daily return of 0.046%, a variance of 0.0004038, and a standard deviation of 0.0200958 as a measure of risk. The highest daily return was 5.32% on September 20, 2019 and the lowest was -8.18% on March 12, 2020.

Uploaded by

Subash
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as XLSX, PDF, TXT or read online on Scribd
76 views7 pages

Risk and Return in Excel

This document contains daily closing price and return data for Tata Steel Ltd. stock from the Bombay Stock Exchange from September 3, 2019 to August 5, 2020. Key statistics calculated from the data include an average daily return of 0.046%, a variance of 0.0004038, and a standard deviation of 0.0200958 as a measure of risk. The highest daily return was 5.32% on September 20, 2019 and the lowest was -8.18% on March 12, 2020.

Uploaded by

Subash
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as XLSX, PDF, TXT or read online on Scribd
You are on page 1/ 7

Assignment -II

Subash Tripura
ID: 19IUT0160022
Topic : Calculation Risk and return of Tata Steel Ltd. stock from BSE daily data

Tata steel ltd


Date Close Daily Return
3-Sep-19 36562.91 Average Return= 0.046%
4-Sep-19 36724.74 0.44% Varience= 0.0004038
5-Sep-19 36644.42 -0.22% Risk(S.D.)= 0.0200958
6-Sep-19 36981.77 0.92%
9-Sep-19 37145.45 0.44%
11-Sep-19 37270.82 0.34%
12-Sep-19 37104.28 -0.45%
13-Sep-19 37384.99 0.76%
16-Sep-19 37123.31 -0.70%
17-Sep-19 36481.09 -1.73%
18-Sep-19 36563.88 0.23%
19-Sep-19 36093.47 -1.29%
20-Sep-19 38014.62 5.32%
23-Sep-19 39090.03 2.83%
24-Sep-19 39097.14 0.02%
25-Sep-19 38593.52 -1.29%
26-Sep-19 38989.74 1.03%
27-Sep-19 38822.57 -0.43%
30-Sep-19 38667.33 -0.40%
1-Oct-19 38305.41 -0.94%
3-Oct-19 38106.87 -0.52%
4-Oct-19 37673.31 -1.14%
7-Oct-19 37531.98 -0.38%
9-Oct-19 38177.95 1.72%
10-Oct-19 37880.4 -0.78%
11-Oct-19 38127.08 0.65%
14-Oct-19 38214.47 0.23%
15-Oct-19 38506.09 0.76%
16-Oct-19 38598.99 0.24%
17-Oct-19 39052.06 1.17%
18-Oct-19 39298.38 0.63%
22-Oct-19 38963.84 -0.85%
23-Oct-19 39058.83 0.24%
24-Oct-19 39020.39 -0.10%
25-Oct-19 39058.06 0.10%
27-Oct-19 39250.2 0.49%
29-Oct-19 39831.84 1.48%
30-Oct-19 40051.87 0.55%
31-Oct-19 40129.05 0.19%
1-Nov-19 40165.03 0.09%
4-Nov-19 40301.96 0.34%
5-Nov-19 40248.23 -0.13%
6-Nov-19 40469.78 0.55%
7-Nov-19 40653.74 0.45%
8-Nov-19 40323.61 -0.81%
11-Nov-19 40345.08 0.05%
13-Nov-19 40116.06 -0.57%
14-Nov-19 40286.48 0.42%
15-Nov-19 40356.69 0.17%
18-Nov-19 40284.19 -0.18%
19-Nov-19 40469.7 0.46%
20-Nov-19 40651.64 0.45%
21-Nov-19 40575.17 -0.19%
22-Nov-19 40359.41 -0.53%
25-Nov-19 40889.23 1.31%
26-Nov-19 40821.3 -0.17%
27-Nov-19 41020.61 0.49%
28-Nov-19 41130.17 0.27%
29-Nov-19 40793.81 -0.82%
2-Dec-19 40802.17 0.02%
3-Dec-19 40675.45 -0.31%
4-Dec-19 40850.29 0.43%
5-Dec-19 40779.59 -0.17%
6-Dec-19 40445.15 -0.82%
9-Dec-19 40487.43 0.10%
10-Dec-19 40239.88 -0.61%
11-Dec-19 40412.57 0.43%
12-Dec-19 40581.71 0.42%
13-Dec-19 41009.71 1.05%
16-Dec-19 40938.72 -0.17%
17-Dec-19 41352.17 1.01%
18-Dec-19 41558.57 0.50%
19-Dec-19 41673.92 0.28%
20-Dec-19 41681.54 0.02%
23-Dec-19 41642.66 -0.09%
24-Dec-19 41461.26 -0.44%
26-Dec-19 41163.76 -0.72%
27-Dec-19 41575.14 1.00%
30-Dec-19 41558 -0.04%
31-Dec-19 41253.74 -0.73%
1-Jan-20 41306.02 0.13%
2-Jan-20 41626.64 0.78%
3-Jan-20 41464.61 -0.39%
6-Jan-20 40676.63 -1.90%
7-Jan-20 40869.47 0.47%
8-Jan-20 40817.74 -0.13%
9-Jan-20 41452.35 1.55%
10-Jan-20 41599.72 0.36%
13-Jan-20 41859.69 0.62%
14-Jan-20 41952.63 0.22%
15-Jan-20 41872.73 -0.19%
16-Jan-20 41932.56 0.14%
17-Jan-20 41945.37 0.03%
20-Jan-20 41528.91 -0.99%
21-Jan-20 41323.81 -0.49%
22-Jan-20 41115.38 -0.50%
23-Jan-20 41386.4 0.66%
24-Jan-20 41613.19 0.55%
27-Jan-20 41155.12 -1.10%
28-Jan-20 40966.86 -0.46%
29-Jan-20 41198.66 0.57%
30-Jan-20 40913.82 -0.69%
31-Jan-20 40723.49 -0.47%
1-Feb-20 39735.53 -2.43%
3-Feb-20 39872.31 0.34%
4-Feb-20 40789.38 2.30%
5-Feb-20 41142.66 0.87%
6-Feb-20 41306.03 0.40%
7-Feb-20 41141.85 -0.40%
10-Feb-20 40979.62 -0.39%
11-Feb-20 41216.14 0.58%
12-Feb-20 41565.9 0.85%
13-Feb-20 41459.79 -0.26%
14-Feb-20 41257.74 -0.49%
17-Feb-20 41055.69 -0.49%
18-Feb-20 40894.38 -0.39%
19-Feb-20 41323 1.05%
20-Feb-20 41170.12 -0.37%
24-Feb-20 40363.23 -1.96%
25-Feb-20 40281.2 -0.20%
26-Feb-20 39888.96 -0.97%
27-Feb-20 39745.66 -0.36%
28-Feb-20 38297.29 -3.64%
2-Mar-20 38144.02 -0.40%
3-Mar-20 38623.7 1.26%
4-Mar-20 38409.48 -0.55%
5-Mar-20 38470.61 0.16%
6-Mar-20 37576.62 -2.32%
9-Mar-20 35634.95 -5.17%
11-Mar-20 35697.4 0.18%
12-Mar-20 32778.14 -8.18%
13-Mar-20 34103.48 4.04%
16-Mar-20 31390.07 -7.96%
17-Mar-20 30579.09 -2.58%
18-Mar-20 28869.51 -5.59%
19-Mar-20 28288.23 -2.01%
20-Mar-20 29915.96 5.75%
23-Mar-20 25981.24 -13.15%
24-Mar-20 26674.03 2.67%
25-Mar-20 28535.78 6.98%
26-Mar-20 29946.77 4.94%
27-Mar-20 29815.59 -0.44%
30-Mar-20 28440.32 -4.61%
31-Mar-20 29468.49 3.62%
1-Apr-20 28265.31 -4.08%
3-Apr-20 27590.95 -2.39%
7-Apr-20 30067.21 8.97%
8-Apr-20 29893.96 -0.58%
9-Apr-20 31159.62 4.23%
13-Apr-20 30690.02 -1.51%
15-Apr-20 30379.81 -1.01%
16-Apr-20 30602.61 0.73%
17-Apr-20 31588.72 3.22%
20-Apr-20 31648 0.19%
21-Apr-20 30636.71 -3.20%
22-Apr-20 31379.55 2.42%
23-Apr-20 31863.08 1.54%
24-Apr-20 31327.22 -1.68%
27-Apr-20 31743.08 1.33%
28-Apr-20 32114.52 1.17%
29-Apr-20 32720.16 1.89%
30-Apr-20 33717.62 3.05%
4-May-20 31715.35 -5.94%
5-May-20 31453.51 -0.83%
6-May-20 31685.75 0.74%
7-May-20 31443.38 -0.76%
8-May-20 31642.7 0.63%
11-May-20 31561.22 -0.26%
12-May-20 31371.12 -0.60%
13-May-20 32008.61 2.03%
14-May-20 31122.89 -2.77%
15-May-20 31097.73 -0.08%
18-May-20 30028.98 -3.44%
19-May-20 30196.17 0.56%
20-May-20 30818.61 2.06%
21-May-20 30932.9 0.37%
22-May-20 30672.59 -0.84%
26-May-20 30609.3 -0.21%
27-May-20 31605.22 3.25%
28-May-20 32200.59 1.88%
29-May-20 32424.1 0.69%
1-Jun-20 33303.52 2.71%
2-Jun-20 33825.53 1.57%
3-Jun-20 34109.54 0.84%
4-Jun-20 33980.7 -0.38%
5-Jun-20 34287.24 0.90%
8-Jun-20 34370.58 0.24%
9-Jun-20 33956.69 -1.20%
10-Jun-20 34247.05 0.86%
11-Jun-20 33538.37 -2.07%
12-Jun-20 33780.89 0.72%
15-Jun-20 33228.8 -1.63%
16-Jun-20 33605.22 1.13%
17-Jun-20 33507.92 -0.29%
18-Jun-20 34208.05 2.09%
19-Jun-20 34731.73 1.53%
22-Jun-20 34911.32 0.52%
23-Jun-20 35430.43 1.49%
24-Jun-20 34868.98 -1.58%
25-Jun-20 34842.1 -0.08%
26-Jun-20 35171.27 0.94%
29-Jun-20 34961.52 -0.60%
30-Jun-20 34915.8 -0.13%
1-Jul-20 35414.45 1.43%
2-Jul-20 35843.7 1.21%
3-Jul-20 36021.42 0.50%
6-Jul-20 36487.28 1.29%
7-Jul-20 36674.52 0.51%
8-Jul-20 36329.01 -0.94%
9-Jul-20 36737.69 1.12%
10-Jul-20 36594.33 -0.39%
13-Jul-20 36693.69 0.27%
14-Jul-20 36033.06 -1.80%
15-Jul-20 36051.81 0.05%
16-Jul-20 36471.68 1.16%
17-Jul-20 37020.14 1.50%
20-Jul-20 37418.99 1.08%
21-Jul-20 37930.33 1.37%
22-Jul-20 37871.52 -0.16%
23-Jul-20 38140.47 0.71%
24-Jul-20 38128.9 -0.03%
27-Jul-20 37934.73 -0.51%
28-Jul-20 38492.95 1.47%
29-Jul-20 38071.13 -1.10%
30-Jul-20 37736.07 -0.88%
31-Jul-20 37606.89 -0.34%
3-Aug-20 36939.6 -1.77%
4-Aug-20 37687.91 2.03%
5-Aug-20 37663.33 -0.07%
6-Aug-20 38025.45 0.96%
7-Aug-20 38040.57 0.04%
10-Aug-20 38182.08 0.37%
11-Aug-20 38407.01 0.59%
12-Aug-20 38369.63 -0.10%
13-Aug-20 38310.49 -0.15%
14-Aug-20 37877.34 -1.13%
17-Aug-20 38050.78 0.46%
18-Aug-20 38528.32 1.26%
19-Aug-20 38614.79 0.22%
20-Aug-20 38220.39 -1.02%
21-Aug-20 38434.72 0.56%
24-Aug-20 38799.08 0.95%
25-Aug-20 38843.88 0.12%
26-Aug-20 39073.92 0.59%
27-Aug-20 39113.47 0.10%
28-Aug-20 39467.31 0.90%
31-Aug-20 38628.29 -2.13%
1-Sep-20 38900.8 0.71%
Ltd. stock from BSE daily data

You might also like