90 % Loss and Recovered to 50 rs

To create a stock screener formula that filters stocks which have lost 90% or more of their all-time high value and have subsequently recovered to a stock price above 50, you can use the following formula

by sachidanand

19 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 % All time high Rs.
1. Kanishk Steel 50.1914.93142.740.001.45590.48101.2126.9412.56797.58
2. Teerth Gopicon 52.104.8762.520.003.32-59.1650.27-25.5827.59774.00
3. MPDL Ltd 53.1739.400.00-1.51-174.554.052431.25-2.876850.00
4. Natl. Gen. Inds. 53.3956.7929.530.00-0.25-247.061.62-42.353.22839.85
5. ARSS Infra 54.27123.400.00-115.52-20366.6718.68-78.47-0.631418.00
6. Swadeshi Inds 55.3545.0259.880.000.35600.009.29305.686.86840.00
7. Netwrk.18 Media 55.438547.310.00148.8598.58467.86-85.100.61581.26
8. Signet Industrie 55.548.13163.490.900.69914.29259.522.7213.72745.00
9. Starlog Enterp. 62.0192.810.00-2.15-929.173.0217.05-2.00849.90
10. Pioneer Invest 67.3310.0782.800.003.619.7315.3177.208.82926.35
11. MMTC 67.39142.7810108.500.0044.26-33.171.36109.237.701897.72
12. Dhani Services 68.87122.794163.880.006.56107.4685.93-19.971.39819.95
13. Global Offshore 73.39225.370.00-1.90-165.074.25-49.34-5.07864.90
14. Bilcare 90.20212.380.00-9.7641.63186.36-4.011.101830.00
15. EKI Energy 116.15320.621.72-1.29-154.9614.94-91.620.273149.99
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 % All time high Rs.
16. Binny Mills 239.0576.260.00-2.98-11.611.30-16.673500.00
17. Reliance Infra. 258.002.3610542.680.00305.45125.555907.82-17.8734.012641.00
18. Dalal Street Inv 404.7512.950.00-0.24-442.860.00-100.002.6511846.40
19. National Standar 1742.25301.953484.500.000.99-62.500.00-100.006.8819000.00

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%