Spreadsheet: 743090d1628200066-multiple-data-for-stock-portfolio-x12
Sheet: SECTOR SEGMENT

SL | SECTOR | Mkt. Capital (MN) | Mkt. Capital (%) | 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-06-16 00:00:00 | 2021-06-17 00:00:00 | 2021-06-20 00:00:00 | 2021-06-21 00:00:00 | 2021-06-22 00:00:00 | 2021-06-23 00:00:00 | 2021-06-24 00:00:00 | 2021-06-27 00:00:00 | 2021-06-28 00:00:00 | 2021-06-29 00:00:00 | 2021-06-30 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 | Remakrs
6 | Engineering | 523533 |  | 2.921183484438834 | 2.580023369467876 | 2.082498201801894 | 3.631933723961665 | 5.614926892230363 | 6.25721595309011 | 4.724406082298726 | 4.59097627768041 | 9.24 | 7.55 | 5.26 | 3.69 | 3.79 | 4.24 | 4.98 | 5.12 | 8.71 | 8.38 | 6.89 | 7.27 | 5.67 | 7.62 | 10.35 | 9.42 | 14.73 | 9.67 | 10.09 | 10.85 | 10.07 | 11.03 | 7.79 | 7.92 | 8.64 | 8.75 | 8.15 | 7.25 | 11.2 | 7.39 | 9.55 | 8.42 | 8.75 | 6.87 | 10.61 | 14.26 | 11.12 | 11.1 | 11.81 | 10.37 | 9.26 | 12.42 | 17.56 | 13.69
12 | Textile | 96298 |  | 6.26170961019614 | 4.655414068874542 | 4.513264020969975 | 6.410967160495934 | 7.420232500618352 | 9.726050801789002 | 7.282568651748565 | 3.372057345166827 | 14.17 | 7.22 | 8.17 | 5.94 | 5.47 | 7.01 | 10.62 | 7.36 | 6.01 | 6.6 | 7.42 | 8.33 | 8.89 | 8.85 | 11.32 | 11.06 | 9.33 | 8.13 | 9.29 | 19.49 | 24.35 | 20.15 | 28.2 | 30.34 | 24.67 | 18.98 | 14.55 | 23.76 | 20.21 | 17.13 | 14.59 | 15.33 | 13.99 | 14.75 | 11.47 | 9.65 | 9.23 | 8.59 | 7.61 | 7.45 | 7.09 | 12.72 | 13.92 | 12.1
2 | Bank | 561278 |  | 2.722173417372442 | 3.534997771227015 | 3.487943367008333 | 7.722499143732155 | 6.768626675251922 | 8.771936312488029 | 14.3869922777694 | 17.50520787299616 | 9.89 | 19.54 | 13.62 | 22.36 | 18.62 | 18.55 | 14.62 | 16.61 | 26.71 | 22.02 | 20.03 | 19.53 | 15.91 | 13.85 | 8.84 | 9.1 | 5.44 | 5.92 | 6.5 | 11.03 | 7.89 | 6.12 | 12.43 | 9.86 | 10.18 | 9.45 | 11.42 | 9.92 | 6.93 | 6.17 | 5.67 | 4.8 | 7.47 | 9.33 | 6.27 | 4.9 | 9.08 | 8.74 | 8.23 | 9.33 | 6.73 | 6.21 | 4.81 | 10.78
5 | Pharmaceuticals & Chemicals | 592886 |  | 5.096079217378696 | 4.591446547317487 | 5.110294222169153 | 4.49194151378429 | 11.60655141140782 | 9.400616402337507 | 9.277792939898855 | 11.284143993826 | 7.31 | 5.86 | 5.14 | 5.52 | 5 | 4.35 | 6.02 | 4.28 | 4.04 | 4.33 | 5.4 | 5.15 | 4.58 | 6.12 | 5.93 | 5.57 | 6.92 | 6.45 | 8.45 | 7.42 | 8.09 | 10.77 | 7.52 | 6.86 | 5.88 | 8.49 | 15.86 | 10.24 | 10.27 | 11.67 | 14.88 | 12.14 | 11.26 | 13.69 | 10.83 | 9.93 | 10.57 | 11.11 | 12.28 | 10.89 | 9.88 | 11.91 | 14.55 | 10.38
18 | Insurance | 150372 |  | 35.65833951686042 | 23.61823045934367 | 36.61785234021624 | 29.61696248091636 | 23.88831555036234 | 17.12228715295934 | 15.9332911010859 | 0.1160498777344477 | 0.1509 | 15.56 | 25.47 | 21.65 | 16.2 | 21.24 | 21.97 | 27.31 | 23.67 | 22.84 | 19.47 | 26.23 | 36.26 | 34.8 | 27.84 | 20.85 | 29.54 | 26.98 | 26.52 | 13.75 | 18.77 | 10.98 | 12.18 | 12.61 | 22.55 | 14.76 | 17.57 | 13.45 | 8.95 | 6.67 | 9.04 | 10.86 | 8.65 | 11.09 | 7.6 | 7.45 | 13.33 | 10.66 | 9.56 | 15.24 | 19.13 | 13.61 | 9.52 | 7.93
19 | Miscellaneous | 172057 |  | 23.12781279407291 | 13.36210450302922 | 13.76723213955723 | 14.12260725931865 | 11.79134647368376 | 14.45964206653802 | 13.2326125110539 | 0.05374941705595472 | 9.96 | 11.6 | 11.7 | 11.6 | 17.85 | 14.15 | 12.29 | 10.45 | 4.97 | 8.29 | 9.51 | 9.22 | 5.95 | 7.18 | 13.07 | 14.04 | 11.39 | 17.47 | 14.53 | 12.63 | 10.11 | 14.28 | 11.58 | 9.29 | 6.45 | 10.62 | 7.26 | 8.51 | 11.33 | 15.49 | 12.53 | 12.33 | 14.96 | 12.2 | 14.2 | 8.67 | 4.94 | 6.98 | 6.37 | 6.12 | 5.78 | 7.8 | 5.59 | 7.8
3 | Financial Institutions | 174847 |  | 3.667471235937807 | 6.226172098219998 | 6.503364691633902 | 7.718747601217942 | 3.134408556295683 | 3.87562784801326 | 4.204222607173829 | 10.01341579701116 | 5.74 | 5.08 | 3.85 | 6.44 | 7.61 | 5.29 | 5.54 | 7.07 | 5.97 | 6.97 | 5.21 | 6.97 | 7.68 | 5.72 | 4.07 | 7.68 | 3.49 | 3.3 | 3.89 | 4.32 | 3.95 | 3.93 | 3.76 | 4.56 | 3.79 | 6.98 | 5.22 | 5.67 | 9.99 | 6.3 | 5.46 | 8.56 | 6.89 | 5.91 | 4.46 | 4.04 | 4.71 | 5.75 | 4.16 | 4.4 | 3.19 | 3.29 | 4.26 | 6.51
8 | Fuel & Power | 430419 |  | 5.231121762888034 | 3.432923656895273 | 4.051276365280136 | 3.845158795818514 | 7.022212366485568 | 6.397744443762347 | 7.232688044544807 | 7.871199725791743 | 8.05 | 5.5 | 5.73 | 5.8 | 6.44 | 5.58 | 4.89 | 4.32 | 2.36 | 3.68 | 4.29 | 3.89 | 2.63 | 2.95 | 3.73 | 5.63 | 5.17 | 8.96 | 7.04 | 6.19 | 3.98 | 4.42 | 3.5 | 4.2 | 4.37 | 3.73 | 4.06 | 3.93 | 3.31 | 5.17 | 5.98 | 8.35 | 6.58 | 6.29 | 5.01 | 6.28 | 5.58 | 5.68 | 10.55 | 8.34 | 7.98 | 5.71 | 6.43 | 6.11
10 | Food & Allied | 375970 |  | 2.779033436534268 | 2.025638182640068 | 2.700850910186757 | 2.565808364677419 | 3.425816154500044 | 5.310497700140307 | 5.094947735812352 | 2.654416398458512 | 3.65 | 4.72 | 5.88 | 3.57 | 3 | 3.02 | 3.41 | 3.23 | 3.32 | 2.49 | 2.76 | 2.16 | 2.06 | 2.21 | 2.29 | 2.38 | 2.38 | 2 | 2.18 | 2.36 | 2.26 | 3.52 | 2.23 | 2.7 | 2.81 | 3.88 | 3.04 | 3.57 | 2.92 | 4.13 | 4.1 | 3.81 | 3.66 | 3.5 | 4.55 | 4.67 | 4.76 | 6.47 | 5.42 | 4.98 | 4.74 | 7 | 4.96 | 4.76
4 | Mutual Funds | 38731 |  | 1.115877876050844 | 0.9381903161701366 | 2.061175694616209 | 4.250286432346527 | 4.726489092826824 | 2.751399922635368 | 3.007088034283654 | 12.37149182656759 | 2.57 | 2.8 | 1.93 | 1.72 | 2.13 | 1.85 | 3.29 | 2.79 | 2.43 | 5.31 | 2.86 | 2.38 | 1.88 | 2.21 | 1.58 | 1.6 | 1.59 | 1.5 | 1.53 | 1.43 | 1.42 | 4.75 | 2.03 | 2.76 | 1.72 | 3.21 | 2.31 | 3.72 | 5.44 | 8.26 | 4.13 | 4.71 | 5.04 | 5.15 | 8.05 | 12.93 | 7.63 | 5.34 | 5.15 | 4.74 | 6.06 | 4.71 | 4.38 | 4.56
11 | IT Sector | 24622 |  | 0.9524053209605933 | 0.973727828146278 | 0.6112452059896345 | 0.5614926892230363 | 1.478360498207488 | 0.9097370711939523 | 2.344388538576593 | 5.520381304688056 | 3.78 | 2.1 | 2.67 | 3.04 | 4.41 | 4.03 | 3.05 | 2.19 | 2.62 | 2.02 | 1.99 | 1.85 | 1.33 | 1.38 | 1.39 | 1.9 | 1.43 | 1.24 | 1.33 | 1.02 | 1.29 | 1.83 | 0.86 | 1.14 | 1.05 | 2.48 | 1.63 | 2.26 | 1.59 | 3.07 | 2.68 | 1.4 | 2.04 | 2.22 | 2.52 | 2.28 | 3.96 | 1.85 | 3.32 | 3.5 | 5.19 | 3 | 2.83 | 3.85
14 | Ceramics Sector | 23922 |  | 1.059017856889018 | 0.7320727467085157 | 1.421500479045662 | 0.5259551772468948 | 0.8386852826369404 | 0.687849980658842 | 0.4489254648338156 | 2.468736594083396 | 0.64 | 0.49 | 0.55 | 0.94 | 0.86 | 0.49 | 0.43 | 0.54 | 0.35 | 0.72 | 0.59 | 0.41 | 0.36 | 0.46 | 1.01 | 0.75 | 0.67 | 0.96 | 1.33 | 1 | 0.85 | 1.49 | 0.96 | 0.74 | 1.22 | 0.78 | 0.98 | 0.81 | 0.81 | 1.25 | 1.42 | 1.45 | 1.81 | 2.99 | 3.69 | 4.52 | 3.79 | 4.6 | 3.94 | 3.02 | 4.37 | 3.08 | 2.97 | 3.34
9 | Services & Real Estate | 17441 |  | 0.8244702778464837 | 0.4193426413184702 | 0.3269451101805022 | 0.6894277323371458 | 1.627618048507282 | 0.5843026717424571 | 0.619944689532412 | 6.961699228897065 | 3.32 | 3.82 | 4.47 | 2.62 | 2.7 | 2.96 | 3.2 | 2.03 | 1.4 | 1.19 | 1.1 | 0.87 | 1.47 | 1.05 | 1.08 | 2.49 | 2.21 | 1.62 | 1.06 | 1.4 | 0.87 | 0.95 | 2.12 | 1.82 | 1.03 | 0.95 | 0.89 | 1.74 | 1.3 | 0.76 | 0.76 | 0.68 | 0.85 | 0.69 | 3.89 | 2.93 | 2.77 | 5.65 | 4.14 | 5.49 | 3.95 | 2.96 | 3.25 | 3.03
15 | Telecommunication | 724170 |  | 0.3198376077852738 | 4.385328977855866 | 2.423658316772853 | 3.482676173661871 | 2.956720996414976 | 5.096006845956367 | 4.332487025697776 | 1.667309791376093 | 3.03 | 5.06 | 2.76 | 2.82 | 2.29 | 4.53 | 2.75 | 3.35 | 4.87 | 2.4 | 2.75 | 1.91 | 1.71 | 1.75 | 2.14 | 1.71 | 1.65 | 1.33 | 1.38 | 1.44 | 1.72 | 1.4 | 1.38 | 1.56 | 1.11 | 1.85 | 1.58 | 1.22 | 1.02 | 1.37 | 1.34 | 1.25 | 1.41 | 1.14 | 1.05 | 1.96 | 2.58 | 1.76 | 1.59 | 1.35 | 2.35 | 1.89 | 1.71 | 1.62
7 | Cement | 96151 |  | 2.750603426953355 | 6.105344557501116 | 4.712274088036368 | 2.437873321563309 | 3.063333532343401 | 2.307625741565147 | 1.809953461393479 | 9.223701768341448 | 1.67 | 1.62 | 1.5 | 1.46 | 2.95 | 2.12 | 1.96 | 2.58 | 1.94 | 2.23 | 9.31 | 3.38 | 2.86 | 2.55 | 2.83 | 2.25 | 2.59 | 2.38 | 2.05 | 1.96 | 2.1 | 1.44 | 1.08 | 1.37 | 1.52 | 1.82 | 2.42 | 1.12 | 2.82 | 3.77 | 4.93 | 2.97 | 3.51 | 2.12 | 3 | 1.95 | 2.13 | 3.71 | 3.18 | 2.31 | 1.6 | 1.42 | 1.45 | 1.6
17 | Paper & Printing | 14619 |  | 0.04264501437136984 | 0.3980201341327853 | 0.092397531137968 | 0.03553751197614154 | 0.04975251676659816 | 0.1109435452675551 | 0.2992836432225437 | 0.7361801841420536 | 0.3 | 0.2 | 0.06 | 0.03 | 0.03 | 0.04 | 0.21 | 0.17 | 0.13 | 0.09 | 0.08 | 0.09 | 0.08 | 0.1 | 0.1 | 0.18 | 0.19 | 0.15 | 0.52 | 0.37 | 0.51 | 0.37 | 0.32 | 0.29 | 1.21 | 1.48 | 1.52 | 0.88 | 0.72 | 0.69 | 1.07 | 1.49 | 0.86 | 0.76 | 1.01 | 0.92 | 0.72 | 0.61 | 0.76 | 0.8 | 0.68 | 0.79 | 0.8 | 0.65
16 | Tannery Industries | 18044 |  | 0.7747177610798855 | 0.3340526125757305 | 0.07818252634751138 | 0.3340526125757305 | 1.663155560483424 | 0.9541144893009744 | 0.812341317318333 | 1.910403745788251 | 1.42 | 1.12 | 1.09 | 0.67 | 0.55 | 0.39 | 0.66 | 0.49 | 0.36 | 0.37 | 0.22 | 0.28 | 0.6 | 1.08 | 2.27 | 3.1 | 1.05 | 1.74 | 1.96 | 2.87 | 1.32 | 0.83 | 1.41 | 1.33 | 1.16 | 1.11 | 0.75 | 1.41 | 0.68 | 0.39 | 1.04 | 0.87 | 1.87 | 0.97 | 1.22 | 1.94 | 1.49 | 0.84 | 1.37 | 0.9 | 1.4 | 0.89 | 0.5 | 0.65
13 | Travel & Leisure | 22754 |  | 0.07818252634751138 | 0.03553751197614154 | 0.04975251676659816 | 0.03553751197614154 | 0.184795062275936 | 0.08875483621404413 | 0.05700640823286548 | 1.42040738896398 | 0.11 | 0.08 | 0.08 | 0.05 | 0.06 | 0.07 | 0.04 | 0.06 | 0.06 | 0.04 | 0.07 | 0.06 | 0.04 | 0.06 | 0.11 | 0.25 | 0.19 | 0.14 | 0.3 | 0.44 | 0.35 | 1.65 | 0.6 | 0.59 | 0.56 | 0.56 | 0.69 | 0.48 | 0.45 | 0.24 | 0.4 | 0.42 | 0.29 | 0.26 | 0.47 | 0.58 | 1.47 | 0.46 | 0.47 | 0.71 | 0.55 | 0.51 | 0.44 | 0.53
20 | Jute | 2129 |  | 0.2061175694616209 | 0.1634725550902511 | 0.1705800574854794 | 0.08529002874273968 | 0.08529002874273968 | 0.0517736544581924 | 0.06413220926197366 | 0.257681028827077 | 0.05 | 0.08 | 0.07 | 0.07 | 0.05 | 0.08 | 0.06 | 0.06 | 0.08 | 0.04 | 0.06 | 0.03 | 0.03 | 0.06 | 0.06 | 0.04 |  |  |  |  |  |  |  | 0.07 | 0.06 | 0.1 | 0.09 | 0.07 | 0.06 | 0.07 | 0.42 | 0.18 | 0.11 | 0.06 | 0.13 | 0.13 | 0.14 | 0.09 | 0.08 | 0.06 | 0.07 | 0.07 | 0.07 | 0.11
1 | DSE |  |  | 14069.64 | 11598.31 | 13561 | 13985.11 | 14862.69 | 13520.39 | 14033.51 | 13916.43 | 13965.13