| A | B | C | D | E | F | G | H | I | J | K | L | M | N | O | P | Q | R | S | T | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1 | ||||||||||||||||||||
2 | Stock Symbol | NSE:ADANIENT | Latest Stock Price | 2527.4 | Stock Return | -0.2973003031 | Stock Beta | #DIV/0! | ||||||||||||
3 | Benchmark | INDEXNSE:NIFTY_50 | Latest Benchmark Price | 25227.35 | Benchmark Return | 0.3887621213 | Stock Alpha | #DIV/0! | ||||||||||||
4 | Risk Free Rate | 6.73 | Latest Risk Free Price | 113.1270 | Risk Free Return | 0.1312703808 | ||||||||||||||
5 | ||||||||||||||||||||
6 | Stock Data | Benchmark Data | Risk Free Returns | |||||||||||||||||
7 | Date | Close | Return | Date | Close | Return | Date | Close | Return | 10 | ||||||||||
8 | 1/18/2023 15:30:00 | 3596.7 | 1/18/2023 15:30:00 | 18165.35 | 1/18/2023 15:30:00 | 100.0000 | 0.0184 | 12 | 0.2 | 2 | ||||||||||
9 | 1/19/2023 15:30:00 | 3463.55 | -0.0370 | 1/19/2023 15:30:00 | 18107.85 | -0.0032 | 1/19/2023 15:30:00 | 100.0184 | 0.0184 | 9 | -0.25 | -3 | ||||||||
10 | 1/20/2023 15:30:00 | 3456.15 | -0.0021 | 1/20/2023 15:30:00 | 18027.65 | -0.0044 | 1/20/2023 15:30:00 | 100.0369 | 0.0184 | 11 | 0.2222222222 | 2 | ||||||||
11 | 1/23/2023 15:30:00 | 3436.35 | -0.0057 | 1/23/2023 15:30:00 | 18118.55 | 0.0050 | 1/23/2023 15:30:00 | 100.0553 | 0.0184 | 14 | 0.2727272727 | 3 | ||||||||
12 | 1/24/2023 15:30:00 | 3442 | 0.0016 | 1/24/2023 15:30:00 | 18118.3 | 0.0000 | 1/24/2023 15:30:00 | 100.0738 | 0.0184 | |||||||||||
13 | 1/25/2023 15:30:00 | 3388.95 | -0.0154 | 1/25/2023 15:30:00 | 17891.95 | -0.0125 | 1/25/2023 15:30:00 | 100.0922 | 0.0184 | 0.4449494949 | ||||||||||
14 | 1/27/2023 15:30:00 | 2761.45 | -0.1852 | 1/27/2023 15:30:00 | 17604.35 | -0.0161 | 1/27/2023 15:30:00 | 100.1107 | 0.0184 | |||||||||||
15 | 1/30/2023 15:30:00 | 2892.85 | 0.0476 | 1/30/2023 15:30:00 | 17648.95 | 0.0025 | 1/30/2023 15:30:00 | 100.1291 | 0.0184 | |||||||||||
16 | 1/31/2023 15:30:00 | 2973.9 | 0.0280 | 1/31/2023 15:30:00 | 17662.15 | 0.0007 | 1/31/2023 15:30:00 | 100.1476 | 0.0184 | |||||||||||
17 | 2/1/2023 15:30:00 | 2135.35 | -0.2820 | 2/1/2023 15:30:00 | 17616.3 | -0.0026 | 2/1/2023 15:30:00 | 100.1661 | 0.0184 | |||||||||||
18 | 2/2/2023 15:30:00 | 1565.25 | -0.2670 | 2/2/2023 15:30:00 | 17610.4 | -0.0003 | 2/2/2023 15:30:00 | 100.1845 | 0.0184 | |||||||||||
19 | 2/3/2023 15:30:00 | 1586.8 | 0.0138 | 2/3/2023 15:30:00 | 17854.05 | 0.0138 | 2/3/2023 15:30:00 | 100.2030 | 0.0184 | |||||||||||
20 | 2/6/2023 15:30:00 | 1572.7 | -0.0089 | 2/6/2023 15:30:00 | 17764.6 | -0.0050 | 2/6/2023 15:30:00 | 100.2215 | 0.0184 | |||||||||||
21 | 2/7/2023 15:30:00 | 1802.95 | 0.1464 | 2/7/2023 15:30:00 | 17721.5 | -0.0024 | 2/7/2023 15:30:00 | 100.2400 | 0.0184 | |||||||||||
22 | 2/8/2023 15:30:00 | 2164.25 | 0.2004 | 2/8/2023 15:30:00 | 17871.7 | 0.0085 | 2/8/2023 15:30:00 | 100.2584 | 0.0184 | |||||||||||
23 | 2/9/2023 15:30:00 | 1925.7 | -0.1102 | 2/9/2023 15:30:00 | 17893.45 | 0.0012 | 2/9/2023 15:30:00 | 100.2769 | 0.0184 | |||||||||||
24 | 2/10/2023 15:30:00 | 1846.95 | -0.0409 | 2/10/2023 15:30:00 | 17856.5 | -0.0021 | 2/10/2023 15:30:00 | 100.2954 | 0.0184 | |||||||||||
25 | 2/13/2023 15:30:00 | 1717.65 | -0.0700 | 2/13/2023 15:30:00 | 17770.9 | -0.0048 | 2/13/2023 15:30:00 | 100.3139 | 0.0184 | |||||||||||
26 | 2/14/2023 15:30:00 | 1749.7 | 0.0187 | 2/14/2023 15:30:00 | 17929.85 | 0.0089 | 2/14/2023 15:30:00 | 100.3324 | 0.0184 | |||||||||||
27 | 2/15/2023 15:30:00 | 1779.1 | 0.0168 | 2/15/2023 15:30:00 | 18015.85 | 0.0048 | 2/15/2023 15:30:00 | 100.3509 | 0.0184 | |||||||||||
28 | 2/16/2023 15:30:00 | 1796.6 | 0.0098 | 2/16/2023 15:30:00 | 18035.85 | 0.0011 | 2/16/2023 15:30:00 | 100.3694 | 0.0184 | |||||||||||
29 | 2/17/2023 15:30:00 | 1722.7 | -0.0411 | 2/17/2023 15:30:00 | 17944.2 | -0.0051 | 2/17/2023 15:30:00 | 100.3879 | 0.0184 | |||||||||||
30 | 2/20/2023 15:30:00 | 1621.45 | -0.0588 | 2/20/2023 15:30:00 | 17844.6 | -0.0056 | 2/20/2023 15:30:00 | 100.4064 | 0.0184 | |||||||||||
31 | 2/21/2023 15:30:00 | 1571.1 | -0.0311 | 2/21/2023 15:30:00 | 17826.7 | -0.0010 | 2/21/2023 15:30:00 | 100.4249 | 0.0184 | |||||||||||
32 | 2/22/2023 15:30:00 | 1404.85 | -0.1058 | 2/22/2023 15:30:00 | 17554.3 | -0.0153 | 2/22/2023 15:30:00 | 100.4435 | 0.0184 | |||||||||||
33 | 2/23/2023 15:30:00 | 1382.65 | -0.0158 | 2/23/2023 15:30:00 | 17511.25 | -0.0025 | 2/23/2023 15:30:00 | 100.4620 | 0.0184 | |||||||||||
34 | 2/24/2023 15:30:00 | 1315.65 | -0.0485 | 2/24/2023 15:30:00 | 17465.8 | -0.0026 | 2/24/2023 15:30:00 | 100.4805 | 0.0184 | |||||||||||
35 | 2/27/2023 15:30:00 | 1193.5 | -0.0928 | 2/27/2023 15:30:00 | 17392.7 | -0.0042 | 2/27/2023 15:30:00 | 100.4990 | 0.0184 | |||||||||||
36 | 2/28/2023 15:30:00 | 1363.85 | 0.1427 | 2/28/2023 15:30:00 | 17303.95 | -0.0051 | 2/28/2023 15:30:00 | 100.5176 | 0.0184 | |||||||||||
37 | 3/1/2023 15:30:00 | 1564.3 | 0.1470 | 3/1/2023 15:30:00 | 17450.9 | 0.0085 | 3/1/2023 15:30:00 | 100.5361 | 0.0184 | |||||||||||
38 | 3/2/2023 15:30:00 | 1607.25 | 0.0275 | 3/2/2023 15:30:00 | 17321.9 | -0.0074 | 3/2/2023 15:30:00 | 100.5546 | 0.0184 | |||||||||||
39 | 3/3/2023 15:30:00 | 1879.5 | 0.1694 | 3/3/2023 15:30:00 | 17594.35 | 0.0157 | 3/3/2023 15:30:00 | 100.5732 | 0.0184 | |||||||||||
40 | 3/6/2023 15:30:00 | 1982.9 | 0.0550 | 3/6/2023 15:30:00 | 17711.45 | 0.0067 | 3/6/2023 15:30:00 | 100.5917 | 0.0184 | |||||||||||
41 | 3/8/2023 15:30:00 | 2039.65 | 0.0286 | 3/8/2023 15:30:00 | 17754.4 | 0.0024 | 3/8/2023 15:30:00 | 100.6103 | 0.0184 | |||||||||||
42 | 3/9/2023 15:30:00 | 1953.15 | -0.0424 | 3/9/2023 15:30:00 | 17589.6 | -0.0093 | 3/9/2023 15:30:00 | 100.6288 | 0.0184 | |||||||||||
43 | 3/10/2023 15:30:00 | 1896.2 | -0.0292 | 3/10/2023 15:30:00 | 17412.9 | -0.0100 | 3/10/2023 15:30:00 | 100.6474 | 0.0184 | |||||||||||
44 | 3/13/2023 15:30:00 | 1874.4 | -0.0115 | 3/13/2023 15:30:00 | 17154.3 | -0.0149 | 3/13/2023 15:30:00 | 100.6659 | 0.0184 | |||||||||||
45 | 3/14/2023 15:30:00 | 1738.2 | -0.0727 | 3/14/2023 15:30:00 | 17043.3 | -0.0065 | 3/14/2023 15:30:00 | 100.6845 | 0.0184 | |||||||||||
46 | 3/15/2023 15:30:00 | 1839 | 0.0580 | 3/15/2023 15:30:00 | 16972.15 | -0.0042 | 3/15/2023 15:30:00 | 100.7031 | 0.0184 | |||||||||||
47 | 3/16/2023 15:30:00 | 1843.8 | 0.0026 | 3/16/2023 15:30:00 | 16985.6 | 0.0008 | 3/16/2023 15:30:00 | 100.7216 | 0.0184 | |||||||||||
48 | 3/17/2023 15:30:00 | 1876.55 | 0.0178 | 3/17/2023 15:30:00 | 17100.05 | 0.0067 | 3/17/2023 15:30:00 | 100.7402 | 0.0184 | |||||||||||
49 | 3/20/2023 15:30:00 | 1804.95 | -0.0382 | 3/20/2023 15:30:00 | 16988.4 | -0.0065 | 3/20/2023 15:30:00 | 100.7588 | 0.0184 | |||||||||||
50 | 3/21/2023 15:30:00 | 1824.25 | 0.0107 | 3/21/2023 15:30:00 | 17107.5 | 0.0070 | 3/21/2023 15:30:00 | 100.7773 | 0.0184 | |||||||||||
51 | 3/22/2023 15:30:00 | 1815.4 | -0.0049 | 3/22/2023 15:30:00 | 17151.9 | 0.0026 | 3/22/2023 15:30:00 | 100.7959 | 0.0184 | |||||||||||
52 | 3/23/2023 15:30:00 | 1794 | -0.0118 | 3/23/2023 15:30:00 | 17076.9 | -0.0044 | 3/23/2023 15:30:00 | 100.8145 | 0.0184 | |||||||||||
53 | 3/24/2023 15:30:00 | 1740.65 | -0.0297 | 3/24/2023 15:30:00 | 16945.05 | -0.0077 | 3/24/2023 15:30:00 | 100.8331 | 0.0184 | |||||||||||
54 | 3/27/2023 15:30:00 | 1723.05 | -0.0101 | 3/27/2023 15:30:00 | 16985.7 | 0.0024 | 3/27/2023 15:30:00 | 100.8517 | 0.0184 | |||||||||||
55 | 3/28/2023 15:30:00 | 1600.85 | -0.0709 | 3/28/2023 15:30:00 | 16951.7 | -0.0020 | 3/28/2023 15:30:00 | 100.8703 | 0.0184 | |||||||||||
56 | 3/29/2023 15:30:00 | 1740.4 | 0.0872 | 3/29/2023 15:30:00 | 17080.7 | 0.0076 | 3/29/2023 15:30:00 | 100.8889 | 0.0184 | |||||||||||
57 | 3/31/2023 15:30:00 | 1750.45 | 0.0058 | 3/31/2023 15:30:00 | 17359.75 | 0.0163 | 3/31/2023 15:30:00 | 100.9075 | 0.0184 | |||||||||||
58 | 4/3/2023 15:30:00 | 1717.45 | -0.0189 | 4/3/2023 15:30:00 | 17398.05 | 0.0022 | 4/3/2023 15:30:00 | 100.9261 | 0.0184 | |||||||||||
59 | 4/5/2023 15:30:00 | 1698 | -0.0113 | 4/5/2023 15:30:00 | 17557.05 | 0.0091 | 4/5/2023 15:30:00 | 100.9447 | 0.0184 | |||||||||||
60 | 4/6/2023 15:30:00 | 1754.05 | 0.0330 | 4/6/2023 15:30:00 | 17599.15 | 0.0024 | 4/6/2023 15:30:00 | 100.9633 | 0.0184 | |||||||||||
61 | 4/10/2023 15:30:00 | 1797.25 | 0.0246 | 4/10/2023 15:30:00 | 17624.05 | 0.0014 | 4/10/2023 15:30:00 | 100.9819 | 0.0184 | |||||||||||
62 | 4/11/2023 15:30:00 | 1803.15 | 0.0033 | 4/11/2023 15:30:00 | 17722.3 | 0.0056 | 4/11/2023 15:30:00 | 101.0006 | 0.0184 | |||||||||||
63 | 4/12/2023 15:30:00 | 1847.25 | 0.0245 | 4/12/2023 15:30:00 | 17812.4 | 0.0051 | 4/12/2023 15:30:00 | 101.0192 | 0.0184 | |||||||||||
64 | 4/13/2023 15:30:00 | 1870.75 | 0.0127 | 4/13/2023 15:30:00 | 17828 | 0.0009 | 4/13/2023 15:30:00 | 101.0378 | 0.0184 | |||||||||||
65 | 4/17/2023 15:30:00 | 1878.75 | 0.0043 | 4/17/2023 15:30:00 | 17706.85 | -0.0068 | 4/17/2023 15:30:00 | 101.0564 | 0.0184 | |||||||||||
66 | 4/18/2023 15:30:00 | 1850.95 | -0.0148 | 4/18/2023 15:30:00 | 17660.15 | -0.0026 | 4/18/2023 15:30:00 | 101.0751 | 0.0184 | |||||||||||
67 | 4/19/2023 15:30:00 | 1853.85 | 0.0016 | 4/19/2023 15:30:00 | 17618.75 | -0.0023 | 4/19/2023 15:30:00 | 101.0937 | 0.0184 | |||||||||||
68 | 4/20/2023 15:30:00 | 1842.9 | -0.0059 | 4/20/2023 15:30:00 | 17624.45 | 0.0003 | 4/20/2023 15:30:00 | 101.1123 | 0.0184 | |||||||||||
69 | 4/21/2023 15:30:00 | 1803 | -0.0217 | 4/21/2023 15:30:00 | 17624.05 | 0.0000 | 4/21/2023 15:30:00 | 101.1310 | 0.0184 | |||||||||||
70 | 4/24/2023 15:30:00 | 1801.95 | -0.0006 | 4/24/2023 15:30:00 | 17743.4 | 0.0068 | 4/24/2023 15:30:00 | 101.1496 | 0.0184 | |||||||||||
71 | 4/25/2023 15:30:00 | 1844.6 | 0.0237 | 4/25/2023 15:30:00 | 17769.25 | 0.0015 | 4/25/2023 15:30:00 | 101.1683 | 0.0184 | |||||||||||
72 | 4/26/2023 15:30:00 | 1847.9 | 0.0018 | 4/26/2023 15:30:00 | 17813.6 | 0.0025 | 4/26/2023 15:30:00 | 101.1869 | 0.0184 | |||||||||||
73 | 4/27/2023 15:30:00 | 1853.05 | 0.0028 | 4/27/2023 15:30:00 | 17915.05 | 0.0057 | 4/27/2023 15:30:00 | 101.2056 | 0.0184 | |||||||||||
74 | 4/28/2023 15:30:00 | 1924.95 | 0.0388 | 4/28/2023 15:30:00 | 18065 | 0.0084 | 4/28/2023 15:30:00 | 101.2243 | 0.0184 | |||||||||||
75 | 5/2/2023 15:30:00 | 1919.85 | -0.0026 | 5/2/2023 15:30:00 | 18147.65 | 0.0046 | 5/2/2023 15:30:00 | 101.2429 | 0.0184 | |||||||||||
76 | 5/3/2023 15:30:00 | 1839 | -0.0421 | 5/3/2023 15:30:00 | 18089.85 | -0.0032 | 5/3/2023 15:30:00 | 101.2616 | 0.0184 | |||||||||||
77 | 5/4/2023 15:30:00 | 1911.25 | 0.0393 | 5/4/2023 15:30:00 | 18255.8 | 0.0092 | 5/4/2023 15:30:00 | 101.2803 | 0.0184 | |||||||||||
78 | 5/5/2023 15:30:00 | 1920.3 | 0.0047 | 5/5/2023 15:30:00 | 18069 | -0.0102 | 5/5/2023 15:30:00 | 101.2989 | 0.0184 | |||||||||||
79 | 5/8/2023 15:30:00 | 1887.5 | -0.0171 | 5/8/2023 15:30:00 | 18264.4 | 0.0108 | 5/8/2023 15:30:00 | 101.3176 | 0.0184 | |||||||||||
80 | 5/9/2023 15:30:00 | 1896.1 | 0.0046 | 5/9/2023 15:30:00 | 18265.95 | 0.0001 | 5/9/2023 15:30:00 | 101.3363 | 0.0184 | |||||||||||
81 | 5/10/2023 15:30:00 | 1892.15 | -0.0021 | 5/10/2023 15:30:00 | 18315.1 | 0.0027 | 5/10/2023 15:30:00 | 101.3550 | 0.0184 | |||||||||||
82 | 5/11/2023 15:30:00 | 1984.65 | 0.0489 | 5/11/2023 15:30:00 | 18297 | -0.0010 | 5/11/2023 15:30:00 | 101.3737 | 0.0184 | |||||||||||
83 | 5/12/2023 15:30:00 | 1964.7 | -0.0101 | 5/12/2023 15:30:00 | 18314.8 | 0.0010 | 5/12/2023 15:30:00 | 101.3924 | 0.0184 | |||||||||||
84 | 5/15/2023 15:30:00 | 1916.05 | -0.0248 | 5/15/2023 15:30:00 | 18398.85 | 0.0046 | 5/15/2023 15:30:00 | 101.4110 | 0.0184 | |||||||||||
85 | 5/16/2023 15:30:00 | 1889.15 | -0.0140 | 5/16/2023 15:30:00 | 18286.5 | -0.0061 | 5/16/2023 15:30:00 | 101.4297 | 0.0184 | |||||||||||
86 | 5/17/2023 15:30:00 | 1899.5 | 0.0055 | 5/17/2023 15:30:00 | 18181.75 | -0.0057 | 5/17/2023 15:30:00 | 101.4484 | 0.0184 | |||||||||||
87 | 5/18/2023 15:30:00 | 1890 | -0.0050 | 5/18/2023 15:30:00 | 18129.95 | -0.0028 | 5/18/2023 15:30:00 | 101.4672 | 0.0184 | |||||||||||
88 | 5/19/2023 15:30:00 | 1956.05 | 0.0349 | 5/19/2023 15:30:00 | 18203.4 | 0.0041 | 5/19/2023 15:30:00 | 101.4859 | 0.0184 | |||||||||||
89 | 5/22/2023 15:30:00 | 2326.1 | 0.1892 | 5/22/2023 15:30:00 | 18314.4 | 0.0061 | 5/22/2023 15:30:00 | 101.5046 | 0.0184 | |||||||||||
90 | 5/23/2023 15:30:00 | 2633.7 | 0.1322 | 5/23/2023 15:30:00 | 18348 | 0.0018 | 5/23/2023 15:30:00 | 101.5233 | 0.0184 | |||||||||||
91 | 5/24/2023 15:30:00 | 2475.6 | -0.0600 | 5/24/2023 15:30:00 | 18285.4 | -0.0034 | 5/24/2023 15:30:00 | 101.5420 | 0.0184 | |||||||||||
92 | 5/25/2023 15:30:00 | 2537.45 | 0.0250 | 5/25/2023 15:30:00 | 18321.15 | 0.0020 | 5/25/2023 15:30:00 | 101.5607 | 0.0184 | |||||||||||
93 | 5/26/2023 15:30:00 | 2544.35 | 0.0027 | 5/26/2023 15:30:00 | 18499.35 | 0.0097 | 5/26/2023 15:30:00 | 101.5795 | 0.0184 | |||||||||||
94 | 5/29/2023 15:30:00 | 2534.05 | -0.0040 | 5/29/2023 15:30:00 | 18598.65 | 0.0054 | 5/29/2023 15:30:00 | 101.5982 | 0.0184 | |||||||||||
95 | 5/30/2023 15:30:00 | 2496.45 | -0.0148 | 5/30/2023 15:30:00 | 18633.85 | 0.0019 | 5/30/2023 15:30:00 | 101.6169 | 0.0184 | |||||||||||
96 | 5/31/2023 15:30:00 | 2493.35 | -0.0012 | 5/31/2023 15:30:00 | 18534.4 | -0.0053 | 5/31/2023 15:30:00 | 101.6357 | 0.0184 | |||||||||||
97 | 6/1/2023 15:30:00 | 2492.15 | -0.0005 | 6/1/2023 15:30:00 | 18487.75 | -0.0025 | 6/1/2023 15:30:00 | 101.6544 | 0.0184 | |||||||||||
98 | 6/2/2023 15:30:00 | 2445.05 | -0.0189 | 6/2/2023 15:30:00 | 18534.1 | 0.0025 | 6/2/2023 15:30:00 | 101.6731 | 0.0184 | |||||||||||
99 | 6/5/2023 15:30:00 | 2433.95 | -0.0045 | 6/5/2023 15:30:00 | 18593.85 | 0.0032 | 6/5/2023 15:30:00 | 101.6919 | 0.0184 | |||||||||||
100 | 6/6/2023 15:30:00 | 2433.65 | -0.0001 | 6/6/2023 15:30:00 | 18599 | 0.0003 | 6/6/2023 15:30:00 | 101.7106 | 0.0184 | |||||||||||