Mutual Fund May 2023 share holdings and fund action in Havells India Ltd.

Hide Index and Arbitrage Funds

MF	May-2023					Apr-2023		Mar-2023
MF	AUM (Cr)	AUM %	Shares Held	Month Change	Month Change %	Shares Held	Month Change %	Shares Held	Month Change %
Aditya Birla Sun Life Flexi Cap Fund	88.94	0.54%	680,000	0	0%	680,000	0%	680,000	0%
SBI Flexicap Fund	180.50	1.06%	1,380,000	0	0%	1,380,000	0%	1,380,000	0%
Canara Robeco Consumer Trends Fund	18.97	1.79%	145,000	0	0%	145,000	0%	145,000	0%
Nippon India Arbitrage Fund	13.41	0.15%	102,500	102,500	100%	0	-100%	70,000	-77.71%
HSBC Arbitrage Fund	2.94	0.16%	22,500	22,000	4400%	500	0%	500	-87.50%
Baroda BNP Paribas Arbitrage Fund	-	-%	-	-	-%	-	-%	0	-100%
Aditya BSL Nifty Next 50 ETF	2.01	2.80%	15,384	-278	-1.77%	15,662	0.26%	15,622	-2.19%
SBI NIFTY 200 Quality 30 ETF	1.00	3.05%	7,636	16	0.21%	7,620	1.29%	7,523	0.04%
SBI S&P BSE Sensex Next 50 ETF	0.22	2.35%	1,655	-49	-2.88%	1,704	0.24%	1,700	-2.19%
Nippon India ETF BSE Sensex Next 50	0.52	2.34%	3,984	0	0%	3,984	0%	3,984	-2.21%
HSBC Nifty Next 50 Index Fund	1.84	2.80%	14,071	72	0.51%	13,999	1.77%	13,756	0.45%
Nippon India ETF Nifty Next 50 Junior BeES	91.64	2.80%	700,625	3,230	0.46%	697,395	1.62%	686,273	2.58%
Nippon India ETF Nifty 100	0.64	0.35%	4,911	-149	-2.94%	5,060	0%	5,060	1.18%
LIC MF Nifty 100 ETF	1.98	0.35%	15,132	1	0.01%	15,131	0.05%	15,123	-0.42%
SBI Nifty Next 50 ETF	37.65	2.81%	287,860	359	0.12%	287,501	1.80%	282,431	1.05%
SBI S&P BSE 100 ETF	0.02	0.34%	178	1	0.56%	177	0%	177	-0.56%
Nippon India ETF Consumption	0.69	1.72%	5,275	-345	-6.14%	5,620	0%	5,620	-4.42%
SBI Nifty Next 50 Index Fund	13.43	2.80%	102,642	-1,101	-1.06%	103,743	-0.16%	103,909	0.13%
SBI Nifty Consumption ETF	0.16	1.73%	1,235	-97	-7.28%	1,332	0.08%	1,331	2.62%
HDFC NIFTY Next 50 Index Fund	10.99	2.80%	84,060	1,589	1.93%	82,471	0.81%	81,806	-2.10%
360 ONE Quant Fund	0	-%	0	-13,253	-100%	13,253	-4.43%	13,868	-3.39%
Aditya Birla Sun Life Nifty Next 50 Index Fund	1.11	2.80%	8,452	-214	-2.47%	8,666	0.86%	8,592	1.12%
HDFC Nifty 100 Equal Weight Index Fund	0.73	1.00%	5,571	-192	-3.33%	5,763	-3.47%	5,970	-15.80%
HDFC Nifty 100 Index Fund	0.36	0.35%	2,744	-43	-1.54%	2,787	-0.64%	2,805	8.76%
HDFC Nifty 100 ETF	0.03	0.35%	205	0	0%	205	0%	205	0.49%
HDFC Nifty Next 50 ETF	0.26	2.80%	1,984	1	0.05%	1,983	0.35%	1,976	7.98%
Aditya Birla Sun Life Nifty 200 Quality 30 ETF	0.28	3.04%	2,175	154	7.62%	2,021	0.10%	2,019	0.15%
HDFC NIFTY100 Quality 30 ETF	0.24	2.55%	1,846	2	0.11%	1,844	0.11%	1,842	0.38%
SBI Arbitrage Opportunities Fund	4.25	0.05%	32,500	12,500	62.50%	20,000	-92.99%	285,500	1.24%
HDFC Arbitrage Fund	0.78	0.01%	6,000	6,000	100%	0	-100%	31,500	186.36%
Aditya Birla Sun Life Arbitrage Fund	0.39	0.01%	3,000	3,000	100%	0	-100%	6,500	-13.33%
Aditya Birla Sun Life Balanced Advantage Fund	15.79	0.25%	120,728	0	0%	120,728	0%	120,728	0%
SBI Equity Savings Fund	-	-%	-	-	-%	0	-100%	5,000	0%
DSP Aggressive Hybrid Fund	62.92	0.83%	481,088	0	0%	481,088	0%	481,088	0%
Tata Ethical Fund	24.72	1.48%	189,000	0	0%	189,000	0%	189,000	0%
Tata Large Cap Fund	23.55	1.58%	180,084	0	0%	180,084	0%	180,084	0%
Kotak Arbitrage Fund	80.44	0.37%	615,000	614,500	122900%	500	-98.33%	30,000	-92.81%
Mirae Asset Large Cap Fund	348.96	1.01%	2,667,967	-193,645	-6.77%	2,861,612	-4.12%	2,984,671	0%
ICICI Prudential Focused Equity Fund	62.88	1.46%	480,759	-100,000	-17.22%	580,759	-11.86%	658,933	3.59%
Mirae Asset Large & Midcap Fund	204.65	0.81%	1,564,631	-330,289	-17.43%	1,894,920	-5.01%	1,994,920	0%
ICICI Prudential Nifty Next 50 Index	78.45	2.81%	599,773	2,640	0.44%	597,133	1.35%	589,151	-0.52%
Mirae Asset Great Consumer Fund	67.36	2.92%	515,000	0	0%	515,000	0%	515,000	0%
Tata Retirement Savings Progressive Fund	24.39	1.76%	186,500	0	0%	186,500	0%	186,500	0%
Tata Retirement Savings Moderate Fund	26.29	1.59%	201,000	0	0%	201,000	0%	201,000	0%
Tata Retirement Savings Conservative Fund	1.15	0.70%	8,800	0	0%	8,800	0%	8,800	0%
Mirae Asset Aggressive Hybrid Fund	58.19	0.79%	444,866	-105,847	-19.22%	550,713	0%	550,713	0%
Mirae Asset ELSS Tax Saver Fund	40.12	0.25%	306,751	-591,559	-65.85%	898,310	-27.81%	1,244,294	0%
Tata India Consumer Fund	69.58	4.66%	532,000	0	0%	532,000	0%	532,000	0%
Tata Flexi Cap Fund	33.24	1.49%	254,100	-70,000	-21.60%	324,100	0%	324,100	0%
Tata Arbitrage Fund	37.08	0.59%	283,500	283,500	100%	0	-100%	29,500	18%
DSP Nifty Next 50 Index Fund	7.65	2.80%	58,462	960	1.67%	57,502	1.37%	56,723	1.63%
ICICI Prudential BSE 500 ETF	0.24	0.27%	1,863	59	3.27%	1,804	3.44%	1,744	2.95%
ICICI Prudential Nifty Next 50 ETF	9.36	2.80%	71,524	393	0.55%	71,131	0.21%	70,979	-0.91%
Quantum ESG Best In Class Strategy Fund	1.38	2.08%	10,548	0	0%	10,548	0%	10,548	0%
DSP Quant Fund	28.14	2.24%	215,122	-4,621	-2.10%	219,743	-18.28%	268,891	-1.77%
Tata Quant Fund	2.29	5.92%	17,495	0	0%	17,495	-35.24%	27,014	0%
ICICI Prudential Nifty 100 ETF	0.18	0.35%	1,389	-52	-3.61%	1,441	1.91%	1,414	0%
Mirae Asset Nifty Next 50 ETF	3.20	2.80%	24,444	275	1.14%	24,169	4.95%	23,029	-1.57%
ICICI Prudential ESG Exclusionary Strategy Fund	8.55	0.69%	65,394	0	0%	65,394	0%	65,394	0%
Mirae Asset Nifty 100 ESG Sector Leaders ETF	0.70	0.52%	5,368	-172	-3.10%	5,540	-3.13%	5,719	-0.45%
Kotak Nifty Next 50 Index Fund	2.96	2.81%	22,659	-95	-0.42%	22,754	0.57%	22,624	-0.18%
Edelweiss Nifty 100 Quality 30 Index Fund	0.37	2.54%	2,794	101	3.75%	2,693	0.30%	2,685	2.87%
ICICI Prudential Nifty India Consumption ETF	0.70	1.73%	5,349	1	0.02%	5,348	51.80%	3,523	2.74%
Edelweiss NIFTY Large Midcap 250 Index Fund	0.08	0.17%	644	7	1.10%	637	1.27%	629	3.11%
Navi Nifty Next 50 Index Fund	3.25	2.81%	24,871	1,124	4.73%	23,747	4.57%	22,709	4.55%
Mirae Asset Nifty India Manufacturing ETF	1.44	1.75%	11,022	-3	-0.03%	11,025	-1.95%	11,244	7.48%
Bandhan Nifty 100 Index Fund	0.25	0.35%	1,919	33	1.75%	1,886	2.22%	1,845	-1.76%
ICICI Prudential Housing Opportunities Fund	54.53	2.28%	416,890	-94,984	-18.56%	511,874	9.80%	466,187	49.44%
Kotak NIFTY India Consumption ETF	0.01	1.72%	95	0	0%	95	0%	95	2.15%
Tata Housing Opportunities Fund	12.43	3.06%	95,000	0	0%	95,000	0%	95,000	18.75%
Navi Nifty India Manufacturing Index Fund	0.24	1.75%	1,863	41	2.25%	1,822	0.77%	1,808	13.21%
Invesco India Multicap Fund	26.26	1.03%	200,782	0	0%	200,782	0.79%	199,211	0%
Invesco India Aggressive Hybrid Fund	3.07	0.78%	23,487	0	0%	23,487	0%	23,487	0%
Sundaram Nifty 100 Equal Weight Fund	0.56	0.98%	4,288	0	0%	4,288	-13.22%	4,941	0%
Taurus Flexi Cap Fund	0	-%	0	-42,679	-100%	42,679	-47.11%	80,696	0%
Taurus Largecap Equity Fund	0	-%	0	-8,488	-100%	8,488	-41.01%	14,388	-6.62%
ICICI Prudential Equity Arbitrage Fund	8.31	0.08%	63,500	19,500	44.32%	44,000	-11.11%	49,500	-78.43%
Invesco India Arbitrage Fund	14.78	0.33%	113,000	107,500	1954.55%	5,500	0%	5,500	-68.57%
LIC MF Nifty Next 50 Index Fund	1.52	2.79%	11,614	-155	-1.32%	11,769	-2.80%	12,108	1.03%
Motilal Oswal Focused Fund	51.65	2.93%	394,902	0	0%	394,902	16.87%	337,902	61.95%
DSP Dynamic Asset Allocation Fund	41.45	1.17%	316,931	40,500	14.65%	276,431	0%	276,431	0%
Motilal Oswal ELSS Tax Saver Fund	0	-%	0	-342,600	-100%	342,600	0%	342,600	20.24%
PGIM India Equity Savings Fund	0.65	0.55%	5,000	0	0%	5,000	0%	5,000	0%
Union Balanced Advantage Fund	-	-%	-	-	-%	0	-100%	52,000	0%
Union Equity Savings Fund	-	-%	-	-	-%	0	-100%	11,000	0%
LIC MF Value Fund	1.08	1.12%	8,260	0	0%	8,260	0%	8,260	0%
Mirae Asset Equity Savings Fund	1.79	0.31%	13,708	-15,212	-52.60%	28,920	0%	28,920	0%
Invesco India Equity Savings Fund	0.72	0.56%	5,470	0	0%	5,470	0%	5,470	0%
DSP Flexi Cap Fund	88.58	1.08%	677,239	0	0%	677,239	0%	677,239	0%
Motilal Oswal Nifty 500 Fund	1.19	0.27%	9,125	316	3.59%	8,809	1.36%	8,691	5.60%
Axis Nifty 100 Index Fund	3.05	0.35%	23,328	-3,980	-14.57%	27,308	0.75%	27,106	-0.33%
Motilal Oswal Large and Midcap Fund	0	-%	0	-178,055	-100%	178,055	0%	178,055	0%
Motilal Oswal Nifty Next 50 Index Fund	3.68	2.80%	28,124	-349	-1.23%	28,473	0.97%	28,200	-3.20%
Sundaram Large Cap Fund	16.61	0.56%	127,000	0	0%	127,000	0%	127,000	0%
Axis NIFTY India Consumption ETF	0.21	1.72%	1,600	1	0.06%	1,599	0%	1,599	2.83%
Axis Nifty Next 50 Index Fund	2.42	2.81%	18,510	-289	-1.54%	18,799	2.31%	18,374	2.15%
NJ Arbitrage Fund	1.05	0.31%	8,000	0	0%	8,000	0%	8,000	0%
Mirae Asset Balanced Advantage Fund	4.27	0.40%	32,654	-15,500	-32.19%	48,154	0%	48,154	0%
Tata Multicap Fund	15.70	0.77%	120,000	0	0%	120,000	0%	120,000	0%
UTI Large Cap Fund	147.14	1.35%	1,125,000	0	0%	1,125,000	0%	1,125,000	0%
UTI Flexi Cap Fund	358.48	1.42%	2,740,789	-13,000	-0.47%	2,753,789	0%	2,753,789	-0.36%
UTI India Consumer Fund	11.51	2.36%	88,000	0	0%	88,000	0%	88,000	0%
UTI Master Equity Plan Unit Scheme	17.79	0.75%	135,983	0	0%	135,983	0%	135,983	22.74%
UTI Nifty Next 50 ETF	32.94	2.80%	251,877	5,857	2.38%	246,020	1.90%	241,435	8.00%
UTI Nifty Next 50 Index Fund	63.66	2.81%	486,752	3,160	0.65%	483,592	1.40%	476,935	0.80%
UTI BSE Sensex Next 50 ETF	0.13	2.35%	981	0	0%	981	0.10%	980	-14.71%
UTI Unit Linked Insurance Plan	29.86	0.57%	228,270	0	0%	228,270	0%	228,270	0%
UTI Focused Fund	65.40	2.73%	500,000	0	0%	500,000	0%	500,000	-16.67%
Bandhan Arbitrage Fund	53.95	1.62%	412,500	411,500	41150%	1,000	-97.06%	34,000	-45.60%
Edelweiss Nifty Next 50 Index Fund	0.40	2.80%	3,094	-117	-3.64%	3,211	2.62%	3,129	-26.96%
HDFC BSE 500 ETF	0.01	0.27%	73	0	0%	73	0%	73	-35.40%
Mirae Asset Flexi Cap Fund	8.29	0.98%	63,383	-7,684	-10.81%	71,067	7.93%	65,847	100%
UTI Arbitrage Fund	8.44	0.26%	64,500	64,500	100%	0	-100%	7,500	200%
HSBC Flexi Cap Fund	30.31	0.92%	231,700	0	0%	231,700	0%	231,700	0%
NJ Balanced Advantage Fund	52.22	1.29%	399,230	-20,140	-4.80%	419,370	100%	-	-%
Edelweiss Arbitrage Fund	10.66	0.21%	81,500	80,000	5333.33%	1,500	100%	-	-%
HDFC BSE 500 Index Fund	0.03	0.27%	207	15	7.81%	192	100%	-	-%
Mahindra Manulife Large Cap Fund	3.14	1.30%	24,000	24,000	100%	-	-%	-	-%
Axis Arbitrage Fund	6.28	0.25%	48,000	48,000	100%	-	-%	-	-%
Axis Equity Savings Fund	0.20	0.02%	1,500	1,500	100%	-	-%	-	-%
Total:			23,419,248	-293,828		23,713,076		24,438,351

Kotak Arbitrage Fund Growth was the highest buyer of 614,500 shares in May 2023 constituting 0.10% of the paid up equity of the company.

Mirae Asset ELSS Tax Saver Fund -Regular Plan-Growth was the highest seller of 591,559 shares in May 2023 constituting 0.09% of the paid up equity of the company.

Shareholding Stock Screeners

Mutual Fund May 2023 share holdings and fund action in Havells India Ltd.

42 MFs bought and 36 MFs sold Havells India Ltd. in the month of May 2023 for a net change of 293,828 stocks

Kotak Arbitrage Fund Growth was the highest buyer of 614,500 shares in May 2023 constituting 0.10% of the paid up equity of the company.

Mirae Asset ELSS Tax Saver Fund -Regular Plan-Growth was the highest seller of 591,559 shares in May 2023 constituting 0.09% of the paid up equity of the company.

Shareholding Stock Screeners