Screener Excel Template

By Marketcap

by Jay

94 results found: Showing page 1 of 4
Edit Columns
S.No. Name CMP Rs. P/E Mar Cap Rs.Cr. Div Yld % NP Qtr Rs.Cr. Qtr Profit Var % Sales Qtr Rs.Cr. Qtr Sales Var % ROCE % Sales Var 5Yrs % Profit Var 5Yrs % PEG
1. Havells India 1567.0066.8298241.770.64517.0015.746543.5620.2424.7918.2014.704.55
2. Coforge 7382.0064.4749369.971.03255.90-9.453318.2042.8228.6020.0814.614.41
3. Blue Star 1671.1062.7334360.290.42132.4622.722807.3625.2625.5113.0917.133.66
4. CRISIL 4664.8048.3134113.691.20159.8416.06813.1810.2335.6013.4914.433.35
5. Carborundum Uni. 1008.8042.8819209.840.4037.61140.741255.459.0320.1311.8313.333.22
6. Astral 1316.1067.7235355.020.28112.60-0.621397.001.9623.1617.6122.183.05
7. Rail Vikas 352.2058.8173434.410.60294.99-9.514590.75-1.8218.7016.6519.642.99
8. Supreme Inds. 3447.7045.5843795.050.87293.94-17.163027.070.6422.9513.6415.502.94
9. CCL Products 600.1029.288013.010.7563.04-0.40758.4114.1412.3919.6710.062.91
10. Grindwell Norton 1683.7050.5518641.931.0187.97-5.99702.616.4724.5910.9518.592.72
11. Asian Paints 2409.8053.00231147.481.381128.44-23.298549.44-6.0837.5013.0320.522.58
12. Sonata Software 420.6527.5911796.071.88105.0143.482842.7914.0135.5123.8111.202.46
13. Elantas Beck 9647.7056.437648.390.0832.87-10.95206.1316.7323.0213.6923.052.45
14. Siemens 2919.7045.72103976.500.41614.60-9.593587.20-3.3023.6111.1918.682.45
15. Ajanta Pharma 2585.2035.0932292.281.39225.2611.121170.4111.0433.3312.4314.362.44
S.No. Name CMP Rs. P/E Mar Cap Rs.Cr. Div Yld % NP Qtr Rs.Cr. Qtr Profit Var % Sales Qtr Rs.Cr. Qtr Sales Var % ROCE % Sales Var 5Yrs % Profit Var 5Yrs % PEG
16. Timken India 2728.4051.0520522.680.0974.3110.04671.439.6723.3611.8221.352.39
17. Bayer Crop Sci. 4677.8040.3721023.012.9934.20-63.271056.9010.6833.9110.0117.012.37
18. Triveni Turbine 507.7547.5716140.200.5192.6035.48503.4016.6138.3214.5120.082.37
19. Clean Science 1168.0047.6312412.020.4365.644.81240.8223.6729.5715.0120.082.37
20. Infosys 1506.8023.60625813.742.857038.00-11.7540925.007.9237.5012.4110.012.36
21. KSB 719.2049.1812516.900.5651.6015.70595.409.4123.8214.3821.962.24
22. Craftsman Auto 4654.6056.5811103.820.2412.93-73.961576.0939.5119.9919.6225.632.21
23. Uno Minda 877.1553.5050362.780.23254.3720.214183.9918.7719.9418.8924.712.17
24. Balkrishna Inds 2676.9029.1851749.080.60449.4847.172560.3312.5717.6212.4513.872.10
25. Blue Dart Expres 6260.0054.0114854.980.4081.01-8.861511.699.3119.2210.6626.282.06

Search Query

You can customize the query below:

Custom query example

Market capitalization > 500 AND Price to earning < 15 AND Return on capital employed > 22%