I have group of 12 stocks which form Index(E.g: BANK). Each stock has different WEIGHTAGE, totalling 100%. I know the 12 stock change amount and Total index amount in a given day. However, I don’t know the WEIGHTAGE of each stock or how many points each stock contribute to the index. My question is, Can we find WEIGHTAGE of each stock or how many points each stock contribute to the index?
Other Data I have: Index Base Value was 1000, when the index was first started and it value as of 1st Nove'19 is: 30330.55. I also provided 12 days stock change amount in $ and total index points change.
Other Data I have: Index Base Value was 1000, when the index was first started and it value as of 1st Nove'19 is: 30330.55. I also provided 12 days stock change amount in $ and total index points change.
| Date | Stock 1 $ Change | Stock2 $ Change | Stock3 $ Change | Stock4 $ Change | Stock5 $ Change | Stock6 $ Change | Stock7 $ Change | Stock8 $ Change | Stock9 $ Change | Stock10 $ Change | Stock11 $ Change | Stock12 $ Change | Index Points Incre/Decre |
| 16-Oct-19 | 1.675 | -0.35 | -1.35 | -0.975 | 1.725 | 0.375 | 1.125 | -5.025 | -0.275 | -2.8 | -1.2 | 0.225 | -16.3 |
| 17-Oct-19 | 8.45 | 0.85 | 1.05 | -0.55 | 2.65 | 0.375 | 32.8 | -0.5 | 0.85 | 15.875 | 4.7 | 3.175 | 450.65 |
| 18-Oct-19 | -0.375 | 0.4 | -0.175 | 4.5 | -1.4 | -0.125 | 1.275 | 5.35 | 0.6 | 2.525 | 2.1 | 2 | 130.8 |
| 22-Oct-19 | 1.6 | 0.175 | -0.225 | 5.15 | 6.675 | 0.05 | -0.825 | 6.8 | 0.25 | -4.15 | 0.425 | 0.2 | 290.9 |
| 23-Oct-19 | 1.05 | 1.15 | -0.125 | 1.15 | 1.975 | -0.075 | -4.2 | -7.6 | 0.275 | -13.9 | 2.475 | -0.3 | 48.45 |
| 24-Oct-19 | -3.575 | -1.275 | -1.15 | -2.75 | -0.175 | -0.4 | -24.8 | -0.225 | -0.775 | -3.725 | -6.475 | -1.45 | -351.65 |
| 25-Oct-19 | 0.45 | 0.825 | -0.375 | -3.55 | 7.175 | 0.9 | -5.475 | -12.3 | 0.475 | 4.325 | 9.525 | 1.925 | 288 |
| 27-Oct-19 | 0.75 | 0.025 | 0.3 | 4.35 | 0.225 | 0.5 | 2.3 | 2.2 | 0.125 | -0.55 | 0.125 | 1.3 | 120.35 |
| 29-Oct-19 | 14.175 | 0.725 | 0.625 | 2.4 | 3.925 | 0.05 | 19.325 | -8.725 | 0.5 | 8.575 | -0.575 | 1.7 | 356.75 |
| 30-Oct-19 | 4.475 | 1.25 | -0.025 | 2.925 | -3.125 | 0.375 | -9.05 | 1.675 | 0.875 | 6.025 | 4.625 | -0.675 | 114.45 |
| 31-Oct-19 | 5.525 | -0.825 | -0.875 | 9 | 4.05 | -1.075 | -8 | 2.2 | -0.825 | -10.825 | -11.25 | -6.8 | 78.75 |
| 01-Nov-19 | 5.975 | 1.4 | 1.125 | 4.85 | -0.4 | -0.375 | 33.325 | 2.7 | 0.9 | 0.175 | 0.575 | -1.9 | 264.3 |