@vishweshwar_kadiyala You have to pull the daily closing price. Then calculate the 6 months or 1 year return. The other thing we do is the calculation of daily price change using this info. We have to use the last 6m or 1 year data to calculate the standard deviation.
Please see below. This is how the table will look. We have to do this for all stocks in the index.
AARTIDRUGS | ||
---|---|---|
27/03/2024 | 440.80 | -0.236% |
28/03/2024 | 434.30 | -0.645% |
01/04/2024 | 457.40 | 2.251% |
02/04/2024 | 468.20 | 1.014% |
03/04/2024 | 474.70 | 0.599% |
04/04/2024 | 487.75 | 1.178% |
05/04/2024 | 492.65 | 0.434% |
08/04/2024 | 487.30 | -0.474% |
09/04/2024 | 513.05 | 2.236% |
10/04/2024 | 508.00 | -0.430% |
12/04/2024 | 504.20 | -0.326% |
Subscribe To Our Free Newsletter |