Magic formula

Joel Formula

by Vigneshwaran

329 results found: Showing page 1 of 14
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 % ROCE 5Yr % Avg PAT 5Yrs Rs.Cr. CMP / BV
1. Maithan Alloys 1104.255.103214.640.91-58.16-140.95435.230.4523.2627.30490.600.86
2. KNR Construct. 210.805.325928.430.127.60-76.14975.21-31.0329.1823.57585.571.31
3. Indian Metals 624.408.903368.892.4047.4034.01567.15-19.0421.4522.24327.221.43
4. Ashoka Buildcon 220.083.656178.160.00451.68132.802694.42-11.7139.9427.94646.681.58
5. Share India Sec. 174.5311.633808.611.0318.64-83.87239.44-48.5520.6940.75272.921.63
6. GHCL 612.709.405866.901.96150.2720.35781.47-5.0925.0823.09658.811.68
7. Suraj Estate 321.0515.311533.760.3118.28-5.04136.4835.9917.3920.6546.471.70
8. G M Breweries 704.2012.541608.881.0760.46-30.22169.335.9318.1320.34106.821.71
9. Panama Petrochem 362.0011.712189.871.9344.27-27.40695.23-6.1720.4130.99195.491.74
10. Dolat Algotech 100.788.231773.730.2539.79-41.70113.91-20.8835.4839.65160.581.77
11. Natl. Aluminium 180.356.2933123.654.442067.23203.245267.8347.1943.9624.332526.421.86
12. Geojit Fin. Ser. 84.0314.002344.651.7932.21-38.45176.70-15.1018.8421.01136.552.02
13. NMDC 71.179.5862571.373.401476.713.437004.597.9429.5933.916532.512.11
14. Sun TV Network 629.6514.2224813.542.66371.77-0.34940.59-2.1520.4525.771669.752.13
15. L G Balakrishnan 1287.2014.424105.191.4084.0314.50669.1710.2519.8723.04227.822.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 % ROCE 5Yr % Avg PAT 5Yrs Rs.Cr. CMP / BV
16. Mahanagar Gas 1325.2012.5313090.032.26252.19-4.831864.8519.0024.4827.54868.112.22
17. Redington 258.6717.1920222.162.40917.74-6.5026439.6817.8617.8721.981164.052.32
18. Petronet LNG 307.3011.6046095.003.251094.9043.2312315.75-10.7125.5727.113466.572.32
19. Ceigall India 249.8515.194352.510.2072.39-33.031011.617.2121.6027.72196.312.38
20. Chamanlal Setia 344.3517.321781.440.6524.555.59367.69-4.1316.7522.4096.552.43
21. Route Mobile 949.2518.015980.051.1660.28-15.201175.0015.5317.7122.19263.972.46
22. Coal India 397.306.94244845.206.429592.5312.4537824.54-1.0248.0457.6826885.862.47
23. H.G. Infra Engg. 1119.8014.787297.860.13147.01-28.201360.89-20.3316.7624.07426.392.47
24. Siyaram Silk 718.4516.403259.611.5372.455.02736.0813.8820.4220.31169.952.53
25. Chambal Fert. 551.0013.3822075.941.36130.3134.652448.73-7.3527.8721.581369.662.53

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%