Spreadsheet: 857911d1706772486-compare-multiple-tables-etf-overlap-aligw
Sheet: ICICIB22

Stock Invested in | Sector | Sector Total | Value(Mn) | % of Total Holdings | 1M Change | 1Y Highest Holding | 1Y Lowest Holding | Quantity | 1M Change in Qty | M-Cap | GroupName
Larsen & Toubro Ltd. | Civil construction | 17.34 | 24460.7 | 0.1645 | 0.0002 | 16.72% (Sep 2023) | 14.44% (May 2023) | 69.35 L | 96.24 k | Large Cap | 82.87
ITC Limited | Diversified fmcg | 11.93 | 17736.4 | 0.1193 | -0.0079 | 20.49% (Feb 2023) | 11.93% (Dec 2023) | 3.84 Cr | 5.33 L | Large Cap | 82.87
National Thermal Power Corporation Ltd. | Power generation | 13.34 | 16695.2 | 0.1123 | 0.0055 | 11.23% (Dec 2023) | 7.81% (Feb 2023) | 5.37 Cr | 7.45 L | Large Cap | 82.87
Power Grid Corporation of India Ltd. | Power - transmission | 8.21 | 12207.5 | 0.0821 | 0.0002 | 8.88% (Mar 2023) | 7.15% (Jan 2023) | 5.15 Cr | 7.15 L | Large Cap | 82.87
Axis Bank Ltd. | Private sector bank | 7.85 | 11673.8 | 0.0785 | -0.0081 | 9.82% (Jan 2023) | 7.85% (Dec 2023) | 1.06 Cr | 1.47 L | Large Cap | 82.87
State Bank Of India | Public sector bank | 7.57 | 9208.4 | 0.0619 | 0.0003 | 8.76% (Jan 2023) | 6.17% (Nov 2023) | [NAME] | 1.99 L | Large Cap | 82.87
Bharat Electronics Ltd. | Aerospace & defense | 5.7 | 8475.3 | 0.057 | 0.0059 | 5.7% (Dec 2023) | 4.54% (Feb 2023) | 4.60 Cr | 6.39 L | Mid Cap | 10.52
Oil & Natural Gas Corporation Ltd. | Oil exploration & production | 5.42 | 8051 | 0.0542 | -0.0041 | 6.04% (Mar 2023) | 5.27% (Jan 2023) | 3.93 Cr | 5.45 L | Large Cap | 82.87
National Aluminium Co. Ltd. | Aluminium | 5.4 | 8030.3 | 0.054 | 0.0114 | 5.4% (Dec 2023) | 2.66% (Feb 2023) | 6.08 Cr | 8.45 L | Small Cap | 6.59
Coal India Ltd. | Coal | 5.33 | 7930.9 | 0.0533 | -0.0016 | 5.5% (Nov 2023) | 4.06% (Jul 2023) | 2.11 Cr | 2.93 L | Large Cap | 82.87
Indian Oil Corporation Ltd. | Refineries & marketing | 6.26 | 4982.5 | 0.0335 | 0.0009 | 3.35% (Dec 2023) | 2.78% (Sep 2023) | 3.84 Cr | 5.33 L | Large Cap | 82.87
Bharat Petroleum Corporation Ltd. | Refineries & marketing | 6.26 | 4329.5 | 0.0291 | -0.0028 | 3.42% (Jan 2023) | 2.66% (Sep 2023) | 96.09 L | 1.33 L | Large Cap | 82.87
[NAME] (India) Ltd. | Gas transmission/marketing | 2.89 | 4290.9 | 0.0289 | 0.0023 | 2.89% (Dec 2023) | 2.5% (Jun 2023) | 2.65 Cr | 3.68 L | Large Cap | 82.87
Power Finance Corporation Ltd. | Financial institution | 2.74 | 2125.2 | 0.0143 | 0.0001 | 1.43% (Dec 2023) | 0.68% (Jan 2023) | 55.57 L | 77.22 k | Mid Cap | 10.52
NHPC Ltd. | Power generation | 13.34 | 1979.2 | 0.0133 | 0.0006 | 1.33% (Dec 2023) | 1.02% (Feb 2023) | 3.06 Cr | 4.25 L | Mid Cap | 10.52
Rural Electrification Corporation Limited | Financial institution | 2.74 | 1954.6 | 0.0131 | 0.0006 | 1.31% (Dec 2023) | 0.56% (Mar 2023) | 47.36 L | 65.67 k | Mid Cap | 10.52
Bank Of Baroda | Public sector bank | 7.57 | 1646.5 | 0.0111 | 0.0004 | 1.29% (Jan 2023) | 1.07% (Nov 2023) | 71.24 L | 98.96 k | Large Cap | 82.87
NBCC (India) Ltd. | Civil construction | 17.34 | 716.9 | 0.0048 | -0.0003 | 0.51% (Nov 2023) | 0.31% (Feb 2023) | 87.91 L | 1.22 L | Mid Cap | 10.52
NLC India Ltd. | Power generation | 13.34 | 634.8 | 0.0043 | 0.001 | 0.43% (Dec 2023) | 0.17% (Jan 2023) | 25.06 L | 34.86 k | Small Cap | 6.59
Engineers India Ltd. | Civil construction | 17.34 | 606.5 | 0.0041 | 0.0001 | 0.47% (Jul 2023) | 0.26% (Feb 2023) | 35.40 L | 49.08 k | Small Cap | 6.59
SJVN Ltd. | Power generation | 13.34 | 524.7 | 0.0035 | -0.0002 | 0.37% (Nov 2023) | 0.15% (Feb 2023) | 57.69 L | 80.06 k | Small Cap | 6.59
Indian Bank | Public sector bank | 7.57 | 401.2 | 0.0027 | -0.0002 | 0.33% (Oct 2023) | 0.24% (May 2023) | 9.53 L | 13.33 k | Mid Cap | 10.52