best query for investment

prompt for screener to pull the best stocks Market Capitalization < 10000 AND Return on Equity > 20 AND Return on Capital Employed > 20 AND Debt to Equity < 0.25 AND Sales growth > 20 AND Promoter holding > 50 AND Profit growth > 20 AND OPM > 15 AND EPS > 20

by Agpr

20 results found: Showing page 1 of 1
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 % ROE %
1. Indosolar 414.056.971719.310.0042.004.9083.10-56.72123.80150.63
2. Kartik Invest. 8956.2042.85218.530.000.01200.000.0094.6980.89
3. One Global Serv 518.3014.571012.910.0018.1968.58133.81141.2787.0265.27
4. GE Power 907.5517.466099.820.00113.21418.10316.4018.7879.9677.73
5. Emkay Tools 930.0516.90992.480.2734.3639.9682.4831.7470.6852.48
6. Jindal Poly Inve 981.801.211033.600.0035.16-47.2547.28503.8363.4154.80
7. Frontier Springs 1489.7028.681758.580.0416.5942.2882.5417.7850.9239.88
8. Garnet Construct 81.952.89113.910.004.72216.7810.401486.6741.0332.19
9. Sahana Systems 800.5010.42707.410.1247.1021.60216.9989.0039.8131.70
10. Oswal Pumps 398.3512.034536.610.0092.5343.90509.7439.7938.2435.16
11. Indo Tech.Trans. 2782.8031.702940.590.0023.9214.01238.9915.9837.7128.35
12. Systango Tech 230.8010.62338.563.0313.57-3.2844.8917.0232.9926.82
13. Mahalaxmi Rubtec 181.018.05175.250.005.4317.7929.5629.2032.4027.33
14. Krishna Defence 1189.4046.591776.170.0812.3064.4464.8542.1830.7523.72
15. Sharda Cropchem 904.7511.988154.260.99318.7256.532064.9012.9330.3724.16
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 % ROE %
16. Desco Infra. 229.0510.73175.820.0010.2175.7376.57108.0130.1525.25
17. Macpower CNC 949.6028.05949.990.1610.1510.93100.2925.3529.1121.30
18. Aimtron 1282.3057.492642.710.0025.6977.79178.5875.9427.6523.60
19. Ceinsys Tech 946.4014.711976.530.3737.1769.96170.7119.8927.4624.76
20. Anlon Tech 671.0030.24419.740.008.45114.4764.54107.0627.0821.11

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%