ETF Daily Earning Mahesh Kaushik Shop of ETF's


1	इस शीट में दिनांक 26 March 2024 को ईटीएफ की लिस्ट अपडेट कर दी है। कहीं कहीं यदि गूगल फायनेंस की गणना में त्रुटि से #N/A लिखा आ रहा हो तो भी फार्मुले में IFNA जोड़ दिया है जिससे फार्मुला #N/A वाले ईटीएफ को ईगनोर करके बाकी की रेंक निकाल लेगा इसलिये कहीं कहीं #N/A लिखा दिखे तो घबरायें नहीं आप रेंक के कॉलम में देखेंगें तो रेंक सही दिखेगी। NA का कारण आईसीआईसीआई के कोड चेंज होना है उनमें गूगल फायनेंस 20 डीएमए की गणना नहीं कर पा रहा है परन्तु 20 दिनों के बाद हो सकता है ये प्रोब्लम स्वतः ठीक हो जाये I
2	ETF NSE Code	Underlying Asset	CMP	20 DMA	CMP-20 DMA	% Change 20 DMA Vs CMP	Today Buy
3	NSE:ABSLBANETF	Nifty Bank	57.43	57.92	-0.49	-0.8469	Rank	% from 20 DMA	ETF Code
4	NSE:ABSLNN50ET	Nifty Next 50	71.27	71.16	0.11	0.1546	#1	-3.0844	NSE:HDFCNIFIT
5	NSE:ALPHA	NIFTY Alpha 50 Index	50.37	50.98	-0.61	-1.1936	#2	-3.0579	NSE:ITETF
6	NSE:ALPHAETF	Mirae Asset Nifty 200 Alpha 30 ETF	25.16	25.59	-0.43	-1.6861	#3	-2.9201	NSE:ITIETF
7	NSE:ALPL30IETF	Nifty Alpha Low-Volatility 30 Index	27.47	27.77	-0.30	-1.0928
8	NSE:AUTOBEES	Nifty Auto TRI	245.5	243.65	1.85	0.7595		Your Total Fund Vs Daily investmet
9	NSE:AUTOIETF	Nifty Auto Index	24.56	24.40	0.16	0.6578		Total Fund	Daily Buy
10	NSE:AXISGOLD	Gold	82.33	81.59	0.74	0.9070		100000	1667
11	NSE:AXISILVER	Axis Silver ETF	113.25	108.82	4.43	4.0700		200000	3333
12	NSE:AXISNIFTY	Nifty 50	273.53	276.65	-3.12	-1.1271		300000	5000
13	NSE:AXISTECETF	NIFTY IT Index	402.61	414.28	-11.67	-2.8174		400000	6667
14	NSE:BANKBEES	Nifty Bank	581.19	585.45	-4.26	-0.7271		500000	8333
15	NSE:BANKBETF	Bajaj Finserv Nifty Bank ETF	56.93	57.50	-0.57	-0.9913		600000	10000
16	NSE:BANKIETF	Nifty Bank	57.52	58.06	-0.54	-0.9275		700000	11667
17	NSE:BANKNIFTY1	Nifty Bank	580.49	586.23	-5.74	-0.9787		800000	13333
18	NSE:BFSI	Nifty Financial Services Index	27.32	27.70	-0.38	-1.3843		900000	15000
19	NSE:BSE500IETF	S&P BSE 500 index	39.35	39.45	-0.10	-0.2560		1000000	16667
20	NSE:BSLGOLDETF	Gold	86.95	85.95	1.00	1.1623
21	NSE:BSLNIFTY	Nifty 50	28.94	29.28	-0.33	-1.1443	Watch these videos for more details:-
22	NSE:COMMOIETF	ICICI Prudential Nifty Commodities ETF	90.54	90.16	0.38	0.4248	Part 1	https://www.youtube.com/watch?v=IN0IH_S3d7k
23	NSE:CONSUMBEES	Nifty India Consumption TRI	129.68	130.28	-0.60	-0.4613	Part 2	https://www.youtube.com/watch?v=1UJNwvBNKXk
24	NSE:CONSUMIETF	Nifty India Consumption Index	120.93	121.08	-0.15	-0.1264	Raw sheet link for copy with formulas:-
25	NSE:CPSEETF	CPSE ETF	92.74	93.65	-0.91	-0.9691	https://docs.google.com/spreadsheets/d/1kkHSzLUBgfVKHWYoOtRWn1S8yWrsb4XvBx-JxPpgiOs/edit?usp=sharing
26	NSE:DIVOPPBEES	Nifty Dividend Opportunities 50 TRI	79.15	79.19	-0.04	-0.0467
27	NSE:EQUAL50ADD	NIFTY 50 Equal Weight Index	325.65	328.49	-2.84	-0.8656
28	NSE:FINIETF	ICICI Prudential Nifty Financial Services Ex-Bank ETF	30.37	30.82	-0.45	-1.4457
29	NSE:FMCGIETF	Nifty FMCG Index	60.3	59.01	1.29	2.1921
30	NSE:GOLDBEES	Gold	81.71	81.02	0.69	0.8523
31	NSE:GOLDCASE	Zerodha Gold ETF	15.56	15.40	0.16	1.0619
32	NSE:GOLDETF	Mirae Asset Gold ETF	96.05	95.16	0.89	0.9326
33	NSE:GOLDETFADD	DSP Gold ETF	96.04	95.04	1.00	1.0564
34	NSE:GOLDIETF	Gold	84.51	83.67	0.84	1.0094
35	NSE:GOLDSHARE	Gold	82.8	82.11	0.69	0.8379
36	NSE:HDFCBSE500	HDFC S&P BSE 500 ETF	38.33	37.65	0.68	1.8007
37	NSE:HDFCGOLD	Gold	84.25	83.61	0.64	0.7697
38	NSE:HDFCLOWVOL	HDFC NIFTY100 Low Volatility 30 ETF	20.53	20.48	0.05	0.2588
39	NSE:HDFCMID150	HDFC NIFTY Midcap 150 ETF	22.1	22.01	0.09	0.4157
40	NSE:HDFCMOMENT	HDFC NIFTY200 Momentum 30 ETF	30.97	31.67	-0.70	-2.2226
41	NSE:HDFCNEXT50	HDFC NIFTY NEXT 50 ETF	69.26	69.29	-0.03	-0.0491
42	NSE:HDFCNIF100	HDFC NIFTY 100 ETF	26.33	26.58	-0.25	-0.9499
43	NSE:HDFCNIFBAN	Nifty Bank	57.5	58.18	-0.68	-1.1696
44	NSE:HDFCNIFIT	HDFC NIFTY IT ETF	38.9	40.14	-1.24	-3.0844
45	NSE:HDFCNIFTY	Nifty 50	278.56	281.75	-3.19	-1.1320
46	NSE:HDFCPSUBK	HDFC NIFTY PSU BANK ETF	72.4	71.61	0.79	1.1067
47	NSE:HDFCPVTBAN	HDFC NIFTY Private Bank ETF	28.03	28.45	-0.42	-1.4797
48	NSE:HDFCSENSEX	SENSEX	91.96	93.14	-1.18	-1.2669
49	NSE:HDFCSILVER	HDFC Silver ETF	109.35	105.00	4.35	4.1409
50	NSE:HDFCSML250	HDFC NIFTY Smallcap 250 ETF	179.8	177.82	1.98	1.1160
51	NSE:HEALTHIETF	Nifty Healthcare Index	150.09	148.17	1.92	1.2941
52	NSE:HEALTHY	Nifty Healthcare TRI	15.06	14.85	0.21	1.4346
53	NSE:HNGSNGBEES	Hang Seng Index	409.01	386.46	22.55	5.8341
54	NSE:ICICIB22	S&P BSE BHARAT 22 index	109.05	110.12	-1.07	-0.9757
55	NSE:INFRABEES	Nifty Infra	955	961.87	-6.87	-0.7142
56	NSE:INFRAIETF	ICICI Prudential Nifty Infrastructure ETF	94.6	95.53	-0.93	-0.9730
57	NSE:IT	NIFTY IT Index	40.48	41.59	-1.11	-2.6607
58	NSE:ITBEES	Nifty IT TRI	40.59	41.75	-1.16	-2.7808
59	NSE:ITETF	Mirae Asset Nifty IT ETF	38.55	39.77	-1.22	-3.0579
60	NSE:ITETFADD	DSP Nifty IT ETF	38.7	39.76	-1.06	-2.6550
61	NSE:ITIETF	Nifty IT Index	40.46	41.68	-1.22	-2.9201
62	NSE:JUNIORBEES	Nifty Next 50	733.21	732.34	0.87	0.1187
63	NSE:KOTAKGOLD	Gold	#N/A	#N/A	#N/A	#N/A
64	NSE:KOTAKSILVE	Kotak Silver ETF	#N/A	#N/A	#N/A	#N/A
65	NSE:LOWVOLIETF	Nifty 100 Low Volatility 30 Index	22.08	22.04	0.04	0.2042
66	NSE:MAFANG	NYSE FANG+ Total Return Index	151.23	145.03	6.20	4.2725
67	NSE:MAHKTECH	Hang Seng TECH Total Return Index	22.78	21.63	1.15	5.2972
68	NSE:MAKEINDIA	Nifty India Manufacturing Total Return Index	146.15	146.59	-0.44	-0.2998
69	NSE:MASPTOP50	S&P 500 Top 50 Total Return Index	59.29	55.96	3.33	5.9535
70	NSE:MID150BEES	Nifty Midcap 150 TRI	225.3	224.74	0.56	0.2514
71	NSE:MIDCAP	Nifty Midcap 50 Index	169.79	170.04	-0.25	-0.1473
72	NSE:MIDCAPETF	Mirae Asset Mutual Fund - Mirae Asset Nifty Midcap 150 ETF	22.21	22.18	0.03	0.1488
73	NSE:MIDCAPIETF	Nifty Midcap 150	22.5	22.47	0.03	0.1246
74	NSE:MIDQ50ADD	Nifty Midcap 150 Quality 50 Index	255.45	255.02	0.43	0.1668
75	NSE:MIDSELIETF	S&P BSE Midcap Select Index	17.75	17.80	-0.05	-0.2585
76	NSE:MNC	Kotak Nifty MNC ETF	29.71	29.41	0.30	1.0080
77	NSE:MOHEALTH	Motilal Oswal S&P BSE Healthcare ETF	45.69	44.85	0.84	1.8650
78	NSE:MOM100	Nifty Midcap 100	63.52	63.53	-0.01	-0.0181
79	NSE:MOM30IETF	ICICI Prudential Nifty 200 Momentum 30 ETF	31.25	31.98	-0.73	-2.2857
80	NSE:MOMENTUM	Aditya Birla Sun Life Nifty 200 Momentum 30 ETF	31.15	31.82	-0.67	-2.0917
81	NSE:MOMOMENTUM	Nifty 200 Momentum 30 Total Return Index	62.4	63.72	-1.32	-2.0639
82	NSE:MON100	Nasdaq100	195.56	190.72	4.84	2.5386
83	NSE:MONIFTY500	Motilal Oswal Nifty 500 ETF	23.73	23.74	-0.01	-0.0442
84	NSE:MONQ50	Nasdaq Q-50 Total Return Index	77.23	75.70	1.53	2.0265
85	NSE:MOREALTY	Motilal Oswal Nifty Realty ETF	99.64	98.60	1.04	1.0573
86	NSE:MOSMALL250	Motilal Oswal Nifty Smallcap 250 ETF	18	17.72	0.28	1.5715
87	NSE:MOVALUE	Motilal Oswal S&P BSE Enhanced Value ETF	105.47	105.09	0.38	0.3602
88	NSE:NEXT50IETF	Nifty Next 50	71.4	71.50	-0.10	-0.1357
89	NSE:NIF100BEES	Nifty 100 TRI	273.07	273.18	-0.11	-0.0415
90	NSE:NIF100IETF	Nifty 100	28.45	28.72	-0.27	-0.9298
91	NSE:NIFITETF	UTI Nifty IT ETF	385.08	395.05	-9.97	-2.5234
92	NSE:NIFMID150	UTI Nifty Midcap 150 Exchange Traded Fund (ETF)	220.2	219.54	0.66	0.3027
93	NSE:NIFTY1	Nifty 50	273.89	277.15	-3.26	-1.1775
94	NSE:NIFTY50ADD	Nifty 50 Index	267.5	263.34	4.16	1.5809
95	NSE:NIFTYBEES	Nifty 50	281.66	284.63	-2.97	-1.0431
96	NSE:NIFTYETF	Nifty 50	268.59	271.90	-3.31	-1.2168
97	NSE:NIFTYIETF	Nifty 50	280.31	283.19	-2.88	-1.0177
98	NSE:NIFTYQLITY	Aditya Birla Sun Life Nifty 200 Quality 30 ETF	21.5	21.60	-0.10	-0.4768
99	NSE:NV20	Nifty50 Value 20	148.15	149.20	-1.05	-0.7011
100	NSE:NV20BEES	Nifty50 Value20 TRI	148.77	149.81	-1.04	-0.6912
101	NSE:NV20IETF	Nifty50 Value 20	14.5	14.60	-0.10	-0.6883
102	NSE:PHARMABEES	Nifty Pharma TRI	23.08	22.65	0.43	1.9187
103	NSE:PSUBANK	Nifty PSU Bank	718.27	711.48	6.79	0.9546
104	NSE:PSUBNKBEES	Nifty PSU Bank	79.85	79.18	0.67	0.8436
105	NSE:PSUBNKIETF	ICICI Prudential Nifty PSU Bank ETF	72.47	71.83	0.64	0.8903
106	NSE:PVTBANIETF	Nifty Private Bank Index	27.71	28.21	-0.50	-1.7759
107	NSE:PVTBANKADD	DSP Nifty Private Bank ETF	27.99	28.37	-0.38	-1.3290
108	NSE:QGOLDHALF	Gold	81.55	80.87	0.68	0.8465
109	NSE:SBIETFCON	Nifty India Consumption Index	120.4	120.64	-0.24	-0.2018
110	NSE:SBIETFIT	Nifty IT Index	404.99	417.14	-12.15	-2.9133
111	NSE:SBIETFPB	Nifty Private Bank Index	280.97	285.18	-4.21	-1.4773
112	NSE:SENSEXETF	Mirae Asset S&P BSE Sensex ETF	83.56	84.64	-1.08	-1.2737
113	NSE:SETFGOLD	Gold	84.33	83.53	0.80	0.9571
114	NSE:SETFNIF50	Nifty 50	266.34	269.27	-2.93	-1.0867
115	NSE:SETFNIFBK	Nifty Bank	575.93	580.81	-4.88	-0.8399
116	NSE:SETFNN50	Nifty Next 50	724.64	725.07	-0.43	-0.0597
117	NSE:SILVER	Physical price of Silver	113.59	109.07	4.52	4.1417
118	NSE:SILVERADD	DSP Silver ETF	109.69	105.34	4.35	4.1339
119	NSE:SILVERBEES	Domestic price of Silver- based on LBMA Silver daily spot fixing price	109.04	104.71	4.33	4.1317
120	NSE:SILVERETF	UTI Silver Exchange Traded Fund (UTI Silver ETF)	110.3	106.01	4.29	4.0512
121	NSE:SILVERIETF	Domestic Price of Silver	113.38	109.01	4.37	4.0112
122	NSE:SILVRETF	Mirae Asset Silver ETF	110.7	106.60	4.10	3.8491
123	NSE:SMALLCAP	Mirae Asset Nifty Smallcap 250 Momentum Quality 100 ETF	48.3	48.05	0.25	0.5245
124	NSE:TATAGOLD	Tata Gold Exchange Traded Fund	9.61	9.51	0.10	1.0515
125	NSE:TATSILV	Tata Silver Exchange Traded Fund	11.05	10.61	0.44	4.1618
126	NSE:TECH	Nifty IT TRI Index	39.74	40.76	-1.02	-2.5108
127	NSE:TNIDETF	Nifty India Digital Index	92.86	93.86	-1.00	-1.0628
128	NSE:UTIBANKETF	Nifty Bank	57.9	58.46	-0.56	-0.9571
129	NSE:UTINEXT50	Nifty Next 50	73.19	72.98	0.21	0.2891
130	NSE:UTINIFTETF	Nifty 50	274.08	277.19	-3.11	-1.1211
131	NSE:UTISENSETF	SENSEX	897	909.47	-12.47	-1.3713