IPO released last 3 year

Here, we are providing the fallback value of 3 Years average return if the value is not available. And then specifically searching for cases where the value is 1. This will only show the results where 3 years price data is not available for companies. These are probably the companies that were recently listed.

by Sahil

999 results found: Showing page 1 of 40
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 % 3Yrs return %
1. Varyaa Creations 52.488.3125.140.000.6215.33192.38
2. Neptune Pet. 149.0016.21337.540.00118.54
3. TPI India 16.28194.3069.940.000.24162.508.0913.62117.77
4. Ambitious Plasto 10.3174.885.990.000.0350.005.4111.09112.50
5. Sanofi Consumer 5081.0562.4411701.971.0850.00-20.26172.60-22.11111.44
6. Vuenow Infratech 95.7433.15222.140.79-0.66-183.540.00-100.0094.38
7. Markobenz Ventur 10.9040.6973.230.000.17-88.6718.5748.8083.28
8. RRPSemiconductor 1693.45272.722307.150.00-1.59-2087.506.001478.9580.18
9. Oswal Pumps 70.346998.2173.54
10. Swojas Foods 14.2515.4344.120.000.545300.0027.8713171.4373.27
11. Associated 130.4916.6417.640.000.402.2172.14
12. Australian Prem 611.0031.041206.130.0025.71734.74269.23259.7470.65
13. GHV Infra 840.8070.671212.020.0013.9817575.00164.9668.53
14. International Ge 375.1537.9516212.490.64140.7311.62304.789.6268.01
15. Dam Capital Advi 256.3017.491811.690.378.48-74.3036.56-56.5664.78
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 % 3Yrs return %
16. Influx Health. 16.62222.2460.16
17. Owais Metal 659.7024.091199.490.0022.30190.55108.28117.2159.37
18. PNGS Gargi FJ 903.0032.47935.310.004.1174.8922.6947.5357.93
19. Insolation Ener 274.9049.616057.210.0061.5541.60706.8890.0156.61
20. Victory Ele. 31.37153.410.977.9355.56
21. Rajesh Power 1555.0032.072800.140.0059.61759.0155.21
22. Unified Data 341.5020.12686.120.0012.10114.4155.17
23. Hyundai Motor I 1954.0028.87158770.520.001582.56-4.0517561.952.5154.22
24. Sathlokhar 425.0523.991025.990.0026.3218.29257.4928.3853.19
25. Alpex Solar 1039.3030.452543.520.0035.32305.14327.39171.4251.80

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%