Web View Nifty Bank Nifty and Nifty Top 10 Cheapest Stocks


1	Stock	Price	Lowest Closing in last 3 Years	Recovery % in last 3 Years	<= Sorted Data	Original Data =>	Stock	Price	Lowest Closing in last 3 Years	Recovery % in last 3 Years	Market Capital (in crores)

2	ADANIPORTS	1408.65	Loading...	Loading...			ADANIPORTS	1408.65	Loading...	Loading...	303878.88
3	ASIANPAINT	3042.95	Loading...	Loading...			ASIANPAINT	3042.95	Loading...	Loading...	291153.25	Check the sorting by entering any dummy value in "Column L"
4	AXISBANK	1173.20	Loading...	Loading...	मैं फॉर्मूला सहित यह शीट बनाकर उपलब्ध करवाने के लिये मेरे फॉलोवर्स श्री हिमांशु नेनुजी का हार्दिक आभारी हूं। जो पहली बार इस शीट पर आये हैं वो निम्न वीडियो देखें जिससे वो समझ सकें कि इसे कैसे यूज करना हैः-		AXISBANK	1173.20	Loading...	Loading...	362925.89	Stocks in Sorted Data will change automatically.
5	BAJAJ-AUTO	11869.50	Loading...	Loading...			BAJAJ-AUTO	11869.50	Loading...	Loading...	331672.90	Don't Enter / Change any values in "Sorted Data Section."
6	BAJAJFINSV	1877.95	Loading...	Loading...			BAJAJFINSV	1877.95	Loading...	Loading...	299035.10
7	BAJFINANCE	7300.10	Loading...	Loading...			BAJFINANCE	7300.10	Loading...	Loading...	451621.10
8	BHARTIARTL	1683.10	Loading...	Loading...			BHARTIARTL	1683.10	Loading...	Loading...	1009981.43
9	BPCL	338.20	Loading...	Loading...			BPCL	338.20	Loading...	Loading...	73047.69
10	BRITANNIA	5993.00	Loading...	Loading...	इसके अलावा श्री नितिन पोटाडे जी, श्री विश्वास जी, श्री गौतम कॉपाटेल जी, श्री फायनेंसगुरूजी का भी इस शीट के लिये फॉर्मूलों का सुझाव देने में योगदान रहा है उनका भी मैं आभारी हूं।		BRITANNIA	5993.00	Loading...	Loading...	144352.37
11	CIPLA	1594.30	Loading...	Loading...			CIPLA	1594.30	Loading...	Loading...	128993.40
12	COALINDIA	493.10	Loading...	Loading...			COALINDIA	493.10	Loading...	Loading...	303667.00
13	DIVISLAB	6150.00	Loading...	Loading...			DIVISLAB	6150.00	Loading...	Loading...	163433.81
14	DRREDDY	6600.00	Loading...	Loading...	Link of Raw Sheet with Formulas		DRREDDY	6600.00	Loading...	Loading...	1323.11
15	EICHERMOT	4735.90	Loading...	Loading...	https://docs.google.com/spreadsheets/d/10Lp8oVUpdJyEiTQ1gCPXW2B2Iv-C3PZjCy7yIfAthQ8/edit?usp=sharing		EICHERMOT	4735.90	Loading...	Loading...	129577.30
16	GAIL	228.80	Loading...	Loading...			GAIL	228.80	Loading...	Loading...	150911.49
17	GRASIM	2721.20	Loading...	Loading...			GRASIM	2721.20	Loading...	Loading...	182889.80
18	HCLTECH	1839.95	Loading...	Loading...			HCLTECH	1839.95	Loading...	Loading...	497435.30
19	HDFC	-	Loading...	Loading...			HDFC	-	Loading...	Loading...	-
20	HDFCBANK	1651.50	Loading...	Loading...			HDFCBANK	1651.50	Loading...	Loading...	15063.36
21	HDFCLIFE	722.30	Loading...	Loading...			HDFCLIFE	722.30	Loading...	Loading...	155577.32
22	HEROMOTOCO	5477.00	Loading...	Loading...			HEROMOTOCO	5477.00	Loading...	Loading...	109469.99
23	HINDALCO	746.70	Loading...	Loading...			HINDALCO	746.70	Loading...	Loading...	167084.62
24	HINDUNILVR	2785.05	Loading...	Loading...			HINDUNILVR	2785.05	Loading...	Loading...	653433.99
25	ICICIBANK	1223.30	Loading...	Loading...			ICICIBANK	1223.30	Loading...	Loading...	10259.00
26	INDUSINDBK	1347.85	Loading...	Loading...			INDUSINDBK	1347.85	Loading...	Loading...	104977.10
27	INFY	1935.00	Loading...	Loading...			INFY	1935.00	Loading...	Loading...	9584.95
28	IOC	163.10	Loading...	Loading...			IOC	163.10	Loading...	Loading...	230374.42
29	ITC	488.95	Loading...	Loading...			ITC	488.95	Loading...	Loading...	610995.28
30	JSWSTEEL	1019.45	Loading...	Loading...			JSWSTEEL	1019.45	Loading...	Loading...	248456.18
31	KOTAKBANK	1884.45	Loading...	Loading...			KOTAKBANK	1884.45	Loading...	Loading...	374401.43
32	LT	3491.90	Loading...	Loading...			LT	3491.90	Loading...	Loading...	478841.53
33	M&M	3136.80	Loading...	Loading...			M&M	3136.80	Loading...	Loading...	375860.16
34	MARUTI	12792.10	Loading...	Loading...			MARUTI	12792.10	Loading...	Loading...	401655.12
35	NESTLEIND	2515.00	Loading...	Loading...			NESTLEIND	2515.00	Loading...	Loading...	242177.00
36	NTPC	422.50	Loading...	Loading...			NTPC	422.50	Loading...	Loading...	409345.15
37	ONGC	292.65	Loading...	Loading...			ONGC	292.65	Loading...	Loading...	368247.85
38	POWERGRID	330.35	Loading...	Loading...			POWERGRID	330.35	Loading...	Loading...	306919.93
39	RELIANCE	2749.00	Loading...	Loading...			RELIANCE	2749.00	Loading...	Loading...	1855496.43
40	SBILIFE	1733.95	Loading...	Loading...			SBILIFE	1733.95	Loading...	Loading...	173668.49
41	SBIN	799.00	Loading...	Loading...			SBIN	799.00	Loading...	Loading...	713085.04
42	SHREECEM	24350.00	Loading...	Loading...			SHREECEM	24350.00	Loading...	Loading...	87856.60
43	SUNPHARMA	1902.90	Loading...	Loading...			SUNPHARMA	1902.90	Loading...	Loading...	456426.15
44	TATAMOTORS	931.40	Loading...	Loading...			TATAMOTORS	931.40	Loading...	Loading...	342542.78
45	TATASTEEL	160.85	Loading...	Loading...			TATASTEEL	160.85	Loading...	Loading...	200698.23
46	TCS	4146.00	Loading...	Loading...			TCS	4146.00	Loading...	Loading...	1501367.93
47	TECHM	1645.00	Loading...	Loading...			TECHM	1645.00	Loading...	Loading...	160952.28
48	TITAN	3474.90	Loading...	Loading...			TITAN	3474.90	Loading...	Loading...	308200.70
49	ULTRACEMCO	11423.20	Loading...	Loading...			ULTRACEMCO	11423.20	Loading...	Loading...	329161.40
50	UPL	583.60	Loading...	Loading...			UPL	583.60	Loading...	Loading...	43764.18
51	WIPRO	528.45	Loading...	Loading...			WIPRO	528.45	Loading...	Loading...	3319.97