Spreadsheet: 743090d1628200066-multiple-data-for-stock-portfolio-x12
Sheet: CHANGE (SEGMENT) %

SL | SECTOR | 2021-05-02 00:00:00 | 2021-05-03 00:00:00 | 2021-05-04 00:00:00 | 2021-05-05 00:00:00 | 2021-05-06 00:00:00 | 2021-05-09 00:00:00 | 2021-05-11 00:00:00 | 2021-05-12 00:00:00 | 2021-05-16 00:00:00 | 2021-05-17 00:00:00 | 2021-05-18 00:00:00 | 2021-05-19 00:00:00 | 2021-05-20 00:00:00 | 2021-05-23 00:00:00 | 2021-05-24 00:00:00 | 2021-05-25 00:00:00 | 2021-05-27 00:00:00 | 2021-05-30 00:00:00 | 2021-05-31 00:00:00 | 2021-06-01 00:00:00 | 2021-06-02 00:00:00 | 2021-06-03 00:00:00 | 2021-06-06 00:00:00 | 2021-06-07 00:00:00 | 2021-07-05 00:00:00 | 2021-07-06 00:00:00 | 2021-07-07 00:00:00 | 2021-07-08 00:00:00 | 2021-07-12 00:00:00 | 2021-07-13 00:00:00 | 2021-07-14 00:00:00 | 2021-07-15 00:00:00 | 2021-07-18 00:00:00 | 2021-07-19 00:00:00 | 2021-07-25 00:00:00 | 2021-07-26 00:00:00 | 2021-07-27 00:00:00 | 2021-07-28 00:00:00 | 2021-07-29 00:00:00 | 2021-08-02 00:00:00 | 2021-08-03 00:00:00 | Remarks
2 | Bank | -0.8665004654377032 |  | -0.4473257698541329 | 0.4369501466275661 | -0.1510204081632653 |  |  |  | -0.0034 | 0.0203 | -0.023 | 0.0006 | -0.0053 | 0.0224 | -0.0393 | 0.0199 | 0.6080674292594823 | 0.0341 | -0.0199 | -0.005 | -0.0362 | -0.0206 | -0.0501 | 0.0026 | -0.015 | -0.0299 | -0.0076 | -0.005 | -0.0087 | 0.0267 | 0.0186 | -0.0306 | -0.0137 | 0.0418 | -0.0034 | -0.0051 | 0.011 | -0.026 | -0.0052 | -0.014 | 0.0597
3 | Financial Institutions | 1.23911099429382 | -0.2565266742338252 | -0.03053435114503821 | 0.420472440944882 | 0.1574279379157426 |  |  |  | 0.0289 | -0.0695 | 0.0095 | -0.0223 | -0.0047 | 0.0154 | 0.0025 | 0.0153 | -0.1555869872701557 | 0.0295 | -0.0176 | 0.0176 | 0.0071 | -0.0196 | -0.0165 | 0.0361 | 0.0045 | 0.0432 | -0.0369 | -0.0084 | 0.031 | -0.0167 | -0.0098 | -0.0145 | -0.0042 | 0.0067 | 0.0104 | -0.0159 | 0.0024 | -0.0121 | 0.001 | 0.0097 | 0.0225
19 | Miscellaneous | 0.3549617428778515 | -0.4222495390288876 | 0.03031914893617019 | 0.02581311306143532 | -0.1650729743331657 |  |  |  | -0.0241 | 0.0164 | 0.001 | -0.001 | 0.0625 | -0.037 | -0.0186 | -0.0184 | -0.5244019138755981 | -0.0211 | 0.0122 | -0.0029 | -0.0327 | 0.0123 | 0.0589 | 0.0097 | 0.0125 | 0.0282 | 0.0416 | -0.0296 | -0.002 | 0.0263 | -0.0276 | 0.02 | -0.0553 | -0.0373 | 0.0204 | -0.0061 | -0.0025 | -0.0034 | 0.0202 | -0.0221 | 0.0221
11 | IT Sector | 0.4896019104220732 | -0.5688073394495413 | -0.7659574468085106 | 3.272727272727273 | 3.978723404255319 |  |  |  | -0.0049 | -0.003 | -0.0003 | -0.0042 | -0.0012 | -0.0016 | -0.0098 | -0.0086 | 0.1963470319634704 | -0.0003 | -0.0003 | -0.0014 | -0.0052 | 0.0005 | 0.0001 | 0.0051 | 0.0063 | -0.0067 | 0.0148 | -0.0039 | -0.0128 | 0.0064 | 0.0018 | 0.003 | -0.0024 | 0.0168 | -0.0211 | 0.0147 | 0.0018 | 0.0169 | -0.0219 | -0.0017 | 0.0102
14 | Ceramics Sector | -0.2929969796893492 | 0.02238805970149238 | -0.3722627737226277 | -0.0813953488372094 | 1.632911392405063 |  |  |  | 0.0236 | -0.0168 | 0.0057 | 0.0037 | 0.0137 | -0.0038 | -0.0006 | 0.0011 | -0.3518518518518519 | -0.0021 | -0.0013 | -0.0018 | -0.0005 | 0.001 | 0.0055 | -0.0026 | -0.0017 | 0 | 0.0044 | 0.0017 | 0.0003 | 0.0036 | 0.0118 | 0.007 | 0.0083 | -0.0073 | 0.0081 | -0.0066 | -0.0092 | 0.0135 | -0.0129 | -0.0011 | 0.0037
4 | Mutual Funds | -0.1237286305124053 | -0.1167883211678831 | -0.1928374655647384 | 0.7440273037542664 | 0.5459882583170255 |  |  |  | 0.0137 | -0.0169 | -0.0229 | -0.0157 | 0.001 | 0.0045 | 0.0144 | -0.005 | -0.1290322580645161 | 0.0228 | -0.0245 | -0.0048 | -0.005 | 0.0033 | -0.0063 | 0.0002 | 0.0141 | 0.0172 | 0.0282 | -0.0413 | 0.0058 | 0.0033 | 0.0011 | 0.029 | 0.0488 | -0.053 | -0.0229 | -0.0019 | -0.0041 | 0.0132 | -0.0135 | -0.0033 | 0.0018
7 | Cement | -0.3986171643339844 | -0.2710997442455243 | 0.3333333333333333 | -0.05 | 0.335180055401662 |  |  |  | -0.0094 | 0.0107 | 0.0116 | -0.0231 | -0.0057 | 0.0002 | -0.0016 | 0.0062 | -0.248062015503876 | 0.0029 | 0.0708 | -0.0593 | -0.0052 | -0.0031 | 0.0028 | -0.0058 | -0.013 | 0.017 | 0.0095 | 0.0116 | -0.0196 | 0.0054 | -0.0139 | 0.0088 | -0.0105 | 0.0018 | 0.0158 | -0.0053 | -0.0087 | -0.0071 | -0.0018 | 0.0003 | 0.0015
16 | Tannery Industries | -0.4036691770365126 | 1.219638242894057 | -0.2281722933643771 | -0.4826546003016591 | 0.2565597667638485 |  |  |  | 0 | -0.0005 | -0.0012 | -0.0004 | 0.0149 | -0.0083 | 0.0027 | -0.0017 | -0.2653061224489796 | -0.0083 | -0.0015 | 0.0006 | 0.0032 | 0.0048 | 0.0119 | 0.0083 | 0.0066 | -0.0073 | -0.0029 | 0.0065 | -0.0017 | 0.01 | -0.009 | 0.0025 | 0.0072 | -0.0045 | -0.0065 | 0.0053 | -0.0047 | 0.005 | -0.0051 | -0.0039 | 0.0015
13 | Travel & Leisure | 0.07078391045762619 | -0.3087248322147651 | 0.9417475728155339 | -0.63 | 0.5945945945945947 |  |  |  | -0.001 | -0.0015 | 0.0006 | 0.0039 | -0.0008 | -0.0037 | -0.0003 | 0.0002 | 0 | -0.0004 | 0.0003 | -0.0001 | -0.0002 | 0.0002 | 0.0005 | 0.0014 | -0.0021 | -0.0003 | -0.0021 | 0.0016 | 0.0002 | -0.0013 | -0.0003 | 0.0021 | 0.0011 | 0.0089 | -0.0101 | 0.0001 | 0.0024 | -0.0016 | -0.0004 | -0.0007 | 0.0009
20 | Jute |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0.3333333333333334 | -0.0469 | 0.0002 | -0.0003 | 0 | 0.0003 | 0 | -0.0002 | -0.0002 | -0.0001 | 0.0001 | 0.0035 | -0.0024 | -0.0007 | -0.0005 | 0.0007 | 0 | 0.0001 | -0.0005 | -0.0001 | -0.0002 | 0.0001 | 0 | 0 | 0.0004
15 | Telecommunication | -0.2918092226169592 | -0.09902370990237089 | 0.1130030959752322 | -0.1210013908205842 | 1.583860759493671 |  |  |  | 0.0035 | -0.0145 | -0.0072 | 0.0038 | -0.0052 | -0.0065 | -0.0178 | 0.006 | 0.4537313432835821 | -0.006 | 0.0035 | -0.0084 | -0.002 | 0.0004 | 0.0039 | -0.0043 | -0.0036 | -0.002 | 0.0035 | -0.0003 | -0.0009 | 0.0016 | -0.0027 | -0.0009 | 0.0091 | 0.0062 | -0.0082 | -0.0017 | -0.0024 | 0.01 | -0.0046 | -0.0018 | -0.0009
17 | Paper & Printing | -0.1029941604926578 | -0.34375 | 0.1801242236024846 | -0.05087719298245616 | 0.8262476894639557 |  |  |  | -0.0117 | -0.0255 | 0.0023 | 0.00069999999999999 | 0.0064 | -0.0086 | 0.0017 | -0.0004 | -0.2352941176470588 | -0.0083 | -0.0001 | 0.0001 | -0.0001 | 0.0002 | 0 | 0.0008 | -0.0064 | -0.0016 | -0.0003 | 0.0038 | 0.0042 | -0.0063 | -0.001 | 0.0025 | -0.0009 | -0.002 | -0.0011 | 0.0015 | 0.0004 | -0.0012 | 0.0011 | 0.0001 | -0.0015
10 | Food & Allied | -0.3163159453629275 | 0.2985938914351556 | -0.01331101382911174 | 1.214055198481009 | -0.1235186240524776 |  |  |  | -0.0012 | 0.0965 | -0.0592 | 0.0874 | -0.0374 | -0.0007 | 0.0039 | -0.0018 | 0.02786377708978324 | -0.0002 | 0.0027 | -0.006 | -0.001 | 0.0015 | 0.0008 | 0.0009 | 0.0053 | -0.0065 | 0.0121 | -0.0003 | -0.0029 | -0.0015 | -0.0016 | 0.0105 | 0.0012 | 0.0009 | 0.0171 | -0.0105 | -0.0044 | -0.0024 | 0.0226 | -0.0204 | -0.002
9 | Services & Real Estate | 1.500891280800361 | 8.333333333333334 | -0.7678571428571429 | -0.6153846153846155 | 0.4000000000000001 |  |  |  | 0.0004 | -0.001 | -0.0014 | -0.0003 | 0 | 0.0001 | 0.0024 | -0.0117 | -0.3103448275862069 | 0.0001 | -0.0009 | -0.0023 | 0.006 | -0.0042 | 0.0003 | 0.0141 | 0.0085 | -0.0044 | -0.0054 | 0 | -0.0008 | 0.0017 | -0.0016 | 0.032 | -0.0096 | -0.0016 | 0.0288 | -0.0151 | 0.0135 | -0.0154 | -0.0099 | 0.0029 | -0.0022
8 | Fuel & Power | 0.3099906708954274 | -0.5454545454545454 | 0.4000000000000001 | -0.2857142857142858 | 4.2 |  |  |  | -0.0001 | -0.0003 | 0 | -0.0003 | 0.0001 | 0.0001 | -0.0069 | -0.0057 | -0.4537037037037038 | 0.0029 | 0.0061 | -0.004 | -0.0126 | 0.0032 | 0.0078 | 0.019 | -0.0013 | -0.0062 | 0.0186 | 0.0081 | 0.0237 | -0.0177 | -0.0029 | -0.0128 | 0.0127 | -0.007 | 0.001 | 0.0487 | -0.0221 | -0.0036 | -0.0227 | 0.0072 | -0.0032
18 | Insurance | -0.1203408991867848 | 0.6976744186046512 | 0.04452054794520557 | 0.1868852459016392 | -0.5939226519337016 |  |  |  | 0.0022 | -0.0066 | -0.0123 | 0.0259 | 0.0117 | -0.0232 | 0.0073 | 0.0534 | -0.1332845111680702 | -0.0119 | -0.0337 | 0.0676 | 0.1003 | -0.0146 | -0.0696 | -0.0699 | -0.0412 | -0.045 | -0.0228 | 0.0237 | 0.0182 | -0.0221 | 0.0244 | -0.0349 | -0.0015 | 0.0588 | -0.0267 | -0.011 | 0.0568 | 0.0389 | -0.0552 | -0.0409 | -0.0159
12 | Textile | -0.3218654039971386 | -0.1592356687898088 | 1.196969696969697 | 1.062068965517241 | 0.1120401337792643 |  |  |  | 0.001 | 0.0023 | -0.0087 | -0.0021 | 0.0041 | -0.0028 | 0.0361 | -0.0326 | -0.1834239130434783 | -0.0004 | 0.0082 | 0.0091 | 0.0056 | -0.00040000000000001 | 0.0247 | -0.0026 | 0.0921 | -0.0355 | -0.0308 | -0.0254 | 0.0074 | -0.0134 | 0.0076 | -0.0328 | -0.0182 | -0.0042 | -0.0064 | -0.0098 | -0.0016 | -0.0036 | 0.0563 | 0.012 | -0.0182
6 | Engineering | -0.2889622829097011 | -0.206896551724138 | 0.04347826086956514 | -0.5 | 0 |  |  |  | 0 | 0.0003 | -0.0001 | 0 | -0.0002 | 0.0003 | 0.0074 | 0.0014 | 0.7011718750000001 | 0.0037 | -0.0149 | 0.0038 | -0.016 | 0.0195 | 0.0273 | -0.0093 | -0.009 | 0.0395 | -0.0381 | 0.0216 | -0.0113 | 0.0033 | -0.0188 | 0.0374 | 0.0365 | -0.0314 | -0.0002 | 0.0071 | -0.0144 | -0.0111 | 0.0316 | 0.0514 | -0.0387
5 | Pharmaceuticals & Chemicals | 0.9734924392710337 | -0.4913793103448276 | -0.2203389830508475 | 1.108695652173913 | 1.360824742268041 |  |  |  | 0.0067 | 0.005 | 0.0065 | -0.0185 | 0.0008 | 0.0026 | 0.0167 | -0.0174 | -0.05607476635514023 | 0.01 | 0.0107 | -0.0025 | -0.0057 | 0.0154 | -0.0019 | -0.0036 | -0.0562 | 0.00029999999999999 | 0.014 | 0.0321 | -0.0274 | -0.0088 | 0.0243 | -0.0286 | -0.009 | 0.0064 | 0.0054 | 0.0117 | -0.0139 | -0.0101 | 0.0203 | 0.0264 | -0.0417
1 | DSE | 0.02734557895483617 | -0.3376519832569265 | 0.5504062594041528 | -0.1911878881987577 | -0.193424526037917 |  |  |  | -0.0242 | 0.0047 | 0.0991 | -0.0382 | -0.0545 | 0.0504