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 | 745.80 | Loading... | Loading... | ADANIPORTS | 745.80 | Loading... | Loading... | 161103.09 | ||||||
3 | ASIANPAINT | 3216.05 | Loading... | Loading... | ASIANPAINT | 3216.05 | Loading... | Loading... | 308862.37 | Check the sorting by entering any dummy value in "Column L" | |||||
4 | AXISBANK | 980.05 | Loading... | Loading... | मैं फॉर्मूला सहित यह शीट बनाकर उपलब्ध करवाने के लिये मेरे फॉलोवर्स श्री हिमांशु नेनुजी का हार्दिक आभारी हूं। जो पहली बार इस शीट पर आये हैं वो निम्न वीडियो देखें जिससे वो समझ सकें कि इसे कैसे यूज करना हैः- | AXISBANK | 980.05 | Loading... | Loading... | 301756.90 | Stocks in Sorted Data will change automatically. | ||||
5 | BAJAJ-AUTO | 4752.70 | Loading... | Loading... | BAJAJ-AUTO | 4752.70 | Loading... | Loading... | 134639.57 | Don't Enter / Change any values in "Sorted Data Section." | |||||
6 | BAJAJFINSV | 1475.90 | Loading... | Loading... | BAJAJFINSV | 1475.90 | Loading... | Loading... | 234861.88 | ||||||
7 | BAJFINANCE | 7078.35 | Loading... | Loading... | BAJFINANCE | 7078.35 | Loading... | Loading... | 428217.53 | ||||||
8 | BHARTIARTL | 834.75 | Loading... | Loading... | BHARTIARTL | 834.75 | Loading... | Loading... | 482859.94 | ||||||
9 | BPCL | 367.25 | Loading... | Loading... | BPCL | 367.25 | Loading... | Loading... | 78172.11 | ||||||
10 | BRITANNIA | 4868.05 | Loading... | Loading... | इसके अलावा श्री नितिन पोटाडे जी, श्री विश्वास जी, श्री गौतम कॉपाटेल जी, श्री फायनेंसगुरूजी का भी इस शीट के लिये फॉर्मूलों का सुझाव देने में योगदान रहा है उनका भी मैं आभारी हूं। | BRITANNIA | 4868.05 | Loading... | Loading... | 117171.54 | |||||
11 | CIPLA | 971.85 | Loading... | Loading... | CIPLA | 971.85 | Loading... | Loading... | 78058.61 | ||||||
12 | COALINDIA | 230.15 | Loading... | Loading... | COALINDIA | 230.15 | Loading... | Loading... | 141927.63 | ||||||
13 | DIVISLAB | 3533.95 | Loading... | Loading... | DIVISLAB | 3533.95 | Loading... | Loading... | 93949.30 | ||||||
14 | DRREDDY | 4669.70 | Loading... | Loading... | Link of Raw Sheet with Formulas | DRREDDY | 4669.70 | Loading... | Loading... | 77601.00 | |||||
15 | EICHERMOT | 3711.75 | Loading... | Loading... | https://docs.google.com/spreadsheets/d/10Lp8oVUpdJyEiTQ1gCPXW2B2Iv-C3PZjCy7yIfAthQ8/edit?usp=sharing | EICHERMOT | 3711.75 | Loading... | Loading... | 101826.47 | |||||
16 | GAIL | 104.65 | Loading... | Loading... | GAIL | 104.65 | Loading... | Loading... | 68874.16 | ||||||
17 | GRASIM | 1758.45 | Loading... | Loading... | GRASIM | 1758.45 | Loading... | Loading... | 115549.29 | ||||||
18 | HCLTECH | 1130.00 | Loading... | Loading... | HCLTECH | 1130.00 | Loading... | Loading... | 306011.22 | ||||||
19 | HDFC | 2632.80 | Loading... | Loading... | HDFC | 2632.80 | Loading... | Loading... | 485989.14 | ||||||
20 | HDFCBANK | 1597.35 | Loading... | Loading... | HDFCBANK | 1597.35 | Loading... | Loading... | 893556.73 | ||||||
21 | HDFCLIFE | 594.20 | Loading... | Loading... | HDFCLIFE | 594.20 | Loading... | Loading... | 127603.05 | ||||||
22 | HEROMOTOCO | 2964.20 | Loading... | Loading... | HEROMOTOCO | 2964.20 | Loading... | Loading... | 59108.15 | ||||||
23 | HINDALCO | 415.10 | Loading... | Loading... | HINDALCO | 415.10 | Loading... | Loading... | 92999.05 | ||||||
24 | HINDUNILVR | 2717.80 | Loading... | Loading... | HINDUNILVR | 2717.80 | Loading... | Loading... | 638548.33 | ||||||
25 | ICICIBANK | 935.50 | Loading... | Loading... | ICICIBANK | 935.50 | Loading... | Loading... | 654379.13 | ||||||
26 | INDUSINDBK | 1304.50 | Loading... | Loading... | INDUSINDBK | 1304.50 | Loading... | Loading... | 101221.32 | ||||||
27 | INFY | 1287.40 | Loading... | Loading... | INFY | 1287.40 | Loading... | Loading... | 532584.32 | ||||||
28 | IOC | 90.50 | Loading... | Loading... | IOC | 90.50 | Loading... | Loading... | 128150.16 | ||||||
29 | ITC | 443.95 | Loading... | Loading... | ITC | 443.95 | Loading... | Loading... | 551679.36 | ||||||
30 | JSWSTEEL | 716.45 | Loading... | Loading... | JSWSTEEL | 716.45 | Loading... | Loading... | 172512.40 | ||||||
31 | KOTAKBANK | 1943.45 | Loading... | Loading... | KOTAKBANK | 1943.45 | Loading... | Loading... | 386618.90 | ||||||
32 | LT | 2306.00 | Loading... | Loading... | LT | 2306.00 | Loading... | Loading... | 323984.35 | ||||||
33 | M&M | 1400.00 | Loading... | Loading... | M&M | 1400.00 | Loading... | Loading... | 167877.74 | ||||||
34 | MARUTI | 9736.20 | Loading... | Loading... | MARUTI | 9736.20 | Loading... | Loading... | 294419.80 | ||||||
35 | NESTLEIND | 22351.45 | Loading... | Loading... | NESTLEIND | 22351.45 | Loading... | Loading... | 215395.08 | ||||||
36 | NTPC | 176.40 | Loading... | Loading... | NTPC | 176.40 | Loading... | Loading... | 171097.65 | ||||||
37 | ONGC | 153.15 | Loading... | Loading... | ONGC | 153.15 | Loading... | Loading... | 193107.14 | ||||||
38 | POWERGRID | 239.25 | Loading... | Loading... | POWERGRID | 239.25 | Loading... | Loading... | 166922.54 | ||||||
39 | RELIANCE | 2479.70 | Loading... | Loading... | RELIANCE | 2479.70 | Loading... | Loading... | 1677562.15 | ||||||
40 | SBILIFE | 1244.00 | Loading... | Loading... | SBILIFE | 1244.00 | Loading... | Loading... | 124131.74 | ||||||
41 | SBIN | 588.40 | Loading... | Loading... | SBIN | 588.40 | Loading... | Loading... | 525257.97 | ||||||
42 | SHREECEM | 25655.95 | Loading... | Loading... | SHREECEM | 25655.95 | Loading... | Loading... | 92550.52 | ||||||
43 | SUNPHARMA | 1010.35 | Loading... | Loading... | SUNPHARMA | 1010.35 | Loading... | Loading... | 243172.50 | ||||||
44 | TATAMOTORS | 571.95 | Loading... | Loading... | TATAMOTORS | 571.95 | Loading... | Loading... | 205249.89 | ||||||
45 | TATASTEEL | 109.20 | Loading... | Loading... | TATASTEEL | 109.20 | Loading... | Loading... | 133459.10 | ||||||
46 | TCS | 3260.60 | Loading... | Loading... | TCS | 3260.60 | Loading... | Loading... | 1193033.58 | ||||||
47 | TECHM | 1085.80 | Loading... | Loading... | TECHM | 1085.80 | Loading... | Loading... | 106068.27 | ||||||
48 | TITAN | 2887.00 | Loading... | Loading... | TITAN | 2887.00 | Loading... | Loading... | 256303.82 | ||||||
49 | ULTRACEMCO | 8098.55 | Loading... | Loading... | ULTRACEMCO | 8098.55 | Loading... | Loading... | 233379.99 | ||||||
50 | UPL | 695.20 | Loading... | Loading... | UPL | 695.20 | Loading... | Loading... | 52193.49 | ||||||
51 | WIPRO | 402.55 | Loading... | Loading... | WIPRO | 402.55 | Loading... | Loading... | 220609.72 |
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 | |||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
2 | RELIANCE | 2479.70 | Loading... | Loading... | RELIANCE | 2479.70 | Loading... | Loading... | Check the sorting by entering any dummy value in "Column L" | ||||||
3 | TCS | 3260.60 | Loading... | Loading... | Enter number to show Top NIFTY 50 stocks | 10 | TCS | 3260.60 | Loading... | Loading... | Stocks in Sorted Data will change automatically. | ||||
4 | HDFCBANK | 1597.35 | Loading... | Loading... | HDFCBANK | 1597.35 | Loading... | Loading... | Don't Enter / Change any values in "Sorted Data Section." | ||||||
5 | ICICIBANK | 935.50 | Loading... | Loading... | ICICIBANK | 935.50 | Loading... | Loading... | You can change values in "G3" to get more / less companies as per your need. | ||||||
6 | HINDUNILVR | 2717.80 | Loading... | Loading... | HINDUNILVR | 2717.80 | Loading... | Loading... | |||||||
7 | ITC | 443.95 | Loading... | Loading... | ITC | 443.95 | Loading... | Loading... | |||||||
8 | INFY | 1287.40 | Loading... | Loading... | INFY | 1287.40 | Loading... | Loading... | |||||||
9 | SBIN | 588.40 | Loading... | Loading... | SBIN | 588.40 | Loading... | Loading... | |||||||
10 | HDFC | 2632.80 | Loading... | Loading... | HDFC | 2632.80 | Loading... | Loading... | |||||||
11 | BHARTIARTL | 834.75 | Loading... | Loading... | BHARTIARTL | 834.75 | Loading... | Loading... | |||||||
12 | |||||||||||||||
13 | |||||||||||||||
14 | |||||||||||||||
15 | |||||||||||||||
16 | |||||||||||||||
17 | |||||||||||||||
18 | |||||||||||||||
19 | |||||||||||||||
20 | |||||||||||||||
21 | |||||||||||||||
22 | |||||||||||||||
23 | |||||||||||||||
24 | |||||||||||||||
25 | |||||||||||||||
26 | |||||||||||||||
27 | |||||||||||||||
28 | |||||||||||||||
29 | |||||||||||||||
30 | |||||||||||||||
31 | |||||||||||||||
32 | |||||||||||||||
33 | |||||||||||||||
34 | |||||||||||||||
35 | |||||||||||||||
36 | |||||||||||||||
37 | |||||||||||||||
38 | |||||||||||||||
39 | |||||||||||||||
40 | |||||||||||||||
41 | |||||||||||||||
42 | |||||||||||||||
43 | |||||||||||||||
44 | |||||||||||||||
45 | |||||||||||||||
46 | |||||||||||||||
47 | |||||||||||||||
48 | |||||||||||||||
49 | |||||||||||||||
50 | |||||||||||||||
51 |
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 | ||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
2 | AUBANK | 763.90 | Loading... | Loading... | AUBANK | 763.90 | Loading... | Loading... | Check the sorting by entering any dummy value in "Column L" | |||||
3 | AXISBANK | 980.05 | Loading... | Loading... | AXISBANK | 980.05 | Loading... | Loading... | Stocks in Sorted Data will change automatically. | |||||
4 | BANDHANBNK | 262.75 | Loading... | Loading... | BANDHANBNK | 262.75 | Loading... | Loading... | Don't Enter / Change any values in "Sorted Data Section." | |||||
5 | FEDERALBNK | 126.90 | Loading... | Loading... | FEDERALBNK | 126.90 | Loading... | Loading... | ||||||
6 | HDFCBANK | 1597.35 | Loading... | Loading... | HDFCBANK | 1597.35 | Loading... | Loading... | ||||||
7 | ICICIBANK | 935.50 | Loading... | Loading... | ICICIBANK | 935.50 | Loading... | Loading... | ||||||
8 | IDFCFIRSTB | 74.10 | Loading... | Loading... | IDFCFIRSTB | 74.10 | Loading... | Loading... | ||||||
9 | INDUSINDBK | 1304.50 | Loading... | Loading... | INDUSINDBK | 1304.50 | Loading... | Loading... | ||||||
10 | KOTAKBANK | 1943.45 | Loading... | Loading... | KOTAKBANK | 1943.45 | Loading... | Loading... | ||||||
11 | PNB | 52.20 | Loading... | Loading... | PNB | 52.20 | Loading... | Loading... | ||||||
12 | RBLBANK | 177.65 | Loading... | Loading... | RBLBANK | 177.65 | Loading... | Loading... | ||||||
13 | SBIN | 588.40 | Loading... | Loading... | SBIN | 588.40 | Loading... | Loading... |