FINAL HACK
Market Capitalization > 500 AND Market Capitalization > Market Capitalization 3years back AND Sales growth 10Years >9 AND Sales growth 7Years >9 AND Sales growth 5Years >9 AND Sales growth 3Years > 9 AND Sales growth >10 AND Profit growth 10Years >9 AND Profit growth 7Years >9 AND Profit growth 5Years >10 AND Profit growth 3Years >10 AND Profit growth >10 AND OPM 10Year >9 AND OPM 5Year >9 AND OPM last year >10 AND OPM >10 AND Average return on equity 10Years >15 AND Average return on equity 7Years >15 AND Average return on equity 5Years >15 AND Average return on equity 3Years >15 AND Return on equity >15 AND Average return on capital employed 10Years >15 AND Average return on capital employed 7Years >15 AND Average return on capital employed 5Years >15 AND Return on capital employed > 15 AND Pledged percentage < 10 AND Promoter holding > 30 AND Debt to equity <1 AND Interest Coverage >3 AND Up from 52w low >20 AND Down from 52w high < 20 AND (Net block + Capital work in progress ) > ( Net block preceding year +Capital work in progress preceding year ) Save Query
by Bala
| 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 % | Mar Cap 3yrs back Cr. | Sales Var 10Yrs % |
|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1. | Shilchar Tech. | 5653.05 | 44.02 | 6467.20 | 0.15 | 55.36 | 121.26 | 231.86 | 119.92 | 71.10 | 133.37 | 19.39 |
| 2. | Swaraj Engines | 4246.55 | 31.22 | 5158.46 | 2.44 | 45.42 | 29.11 | 454.16 | 29.41 | 56.21 | 1587.65 | 12.04 |
| 3. | Jyoti Resins | 1366.35 | 22.19 | 1639.62 | 0.67 | 19.78 | 5.38 | 78.61 | 10.35 | 49.99 | 880.94 | 26.95 |
| 4. | HDFC AMC | 5024.00 | 43.65 | 107468.13 | 1.78 | 638.73 | 18.05 | 901.22 | 29.59 | 43.33 | 45770.65 | 14.39 |
| 5. | Mazagon Dock | 3290.80 | 55.01 | 132744.26 | 0.44 | 325.29 | -50.93 | 3174.41 | 2.28 | 43.17 | 4834.75 | 12.23 |
| 6. | Frontier Springs | 4969.00 | 56.50 | 1957.83 | 0.03 | 11.66 | 130.89 | 70.08 | 58.77 | 41.83 | 107.38 | 20.89 |
| 7. | Bharat Electron | 419.40 | 57.64 | 306572.13 | 0.52 | 2127.02 | 18.39 | 9149.59 | 6.84 | 38.99 | 51365.96 | 12.85 |
| 8. | Solar Industries | 16756.00 | 120.79 | 151625.13 | 0.06 | 346.11 | 37.09 | 2166.55 | 34.51 | 38.13 | 25305.56 | 19.44 |
| 9. | Banco Products | 655.40 | 23.91 | 9374.67 | 1.63 | 153.50 | 125.21 | 874.65 | 20.83 | 33.42 | 973.54 | 11.03 |
| 10. | Persistent Sys | 5838.85 | 67.25 | 91319.62 | 0.59 | 395.76 | 25.51 | 3242.11 | 25.15 | 30.44 | 36430.72 | 20.23 |
| 11. | Polycab India | 6689.50 | 52.19 | 100681.08 | 0.52 | 734.36 | 33.09 | 6985.80 | 24.93 | 29.72 | 35334.30 | 16.89 |
| 12. | Hexaware Tech. | 867.00 | 45.34 | 52781.20 | 0.66 | 327.10 | 17.24 | 3207.90 | 16.70 | 29.52 | 14139.56 | 16.58 |
| 13. | Sika Interplant | 1401.10 | 118.69 | 2970.41 | 0.17 | 7.91 | 30.74 | 46.02 | 23.84 | 29.04 | 265.59 | 17.25 |
| 14. | Dhanuka Agritech | 1727.50 | 26.52 | 7873.67 | 0.12 | 75.50 | 27.92 | 442.02 | 20.01 | 28.79 | 3342.92 | 9.99 |
| 15. | Fiem Industries | 1970.35 | 25.66 | 5185.91 | 1.50 | 58.85 | 21.14 | 639.42 | 14.69 | 27.82 | 1183.71 | 11.39 |
| 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 % | Mar Cap 3yrs back Cr. | Sales Var 10Yrs % |
| 16. | Dynamic Cables | 998.00 | 37.32 | 2418.09 | 0.03 | 23.56 | 71.10 | 331.18 | 37.47 | 26.37 | 269.78 | 14.69 |
| 17. | Shriram Pistons | 2505.65 | 21.79 | 11037.35 | 0.40 | 151.54 | 25.84 | 988.37 | 15.52 | 25.98 | 1551.13 | 11.05 |
| 18. | Schaeffler India | 3961.95 | 60.98 | 61926.70 | 0.71 | 265.41 | 16.58 | 2110.02 | 14.10 | 25.67 | 27460.03 | 17.44 |
| 19. | Jash Engineering | 574.85 | 41.60 | 3607.49 | 0.25 | 35.75 | -8.22 | 300.38 | 38.32 | 24.97 | 609.36 | 19.99 |
| 20. | Integra Engg. | 245.00 | 45.57 | 842.70 | 0.00 | 4.13 | 52.96 | 42.26 | 26.60 | 24.45 | 242.63 | 19.38 |
| 21. | Kovai Medical | 6157.85 | 32.22 | 6736.66 | 0.16 | 54.70 | 4.83 | 356.98 | 11.17 | 22.98 | 1741.90 | 13.06 |
| 22. | AGI Infra | 1003.50 | 36.74 | 2451.89 | 0.05 | 15.74 | 68.52 | 83.28 | 4.32 | 21.85 | 289.51 | 23.06 |
| 23. | Control Print | 826.05 | 13.16 | 1321.21 | 1.21 | 66.64 | 434.40 | 122.07 | 21.33 | 18.46 | 583.04 | 14.17 |
| 24. | Vishnu Chemicals | 508.05 | 26.98 | 3419.94 | 0.06 | 38.94 | 40.43 | 392.63 | 30.72 | 17.98 | 1909.68 | 13.22 |