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

26 results found: Showing page 1 of 2

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	420.10	7.09	1747.57	0.00	42.00	4.90	83.10	-56.72	123.80	150.63
2.	Mobilise App	92.80	18.66	88.27	0.00					103.25	79.90
3.	Kartik Invest.	6924.45	33.13	168.95	0.00	0.01	200.00	0.00		94.69	80.89
4.	Apsis Aerocom	248.00	44.95	298.89	0.00	3.12		13.65		91.95	91.72
5.	Shantidoot Infra	510.50	18.14	91.79	0.00	0.65	-27.78	17.53	247.13	86.13	65.11
6.	Oswal Pumps	410.25	13.40	4676.48	0.00	91.56	15.66	501.07	31.95	77.91	87.50
7.	Sharvaya Metals	111.95	6.41	112.29	0.00	9.39	128.47	89.97	117.79	65.49	82.28
8.	Owais Metal	189.20	6.82	344.01	0.00	25.21	1.98	122.62	16.64	59.47	55.32
9.	One Global Serv	495.50	15.60	968.36	0.00	21.66	522.41	141.27	323.34	56.38	42.31
10.	Telge Projects	104.00	18.48	101.82	0.00	0.83	277.27	9.08	71.32	55.40	61.25
11.	Sahana Systems	813.35	11.38	718.76	0.12	27.67	95.55	114.16	116.87	42.14	30.52
12.	Frontier Springs	1527.80	31.98	1803.52	0.04	14.28	63.57	81.43	39.75	41.56	32.04
13.	Borana Weaves	342.35	15.58	909.00	0.00	18.55	63.27	111.36	42.04	41.21	60.33
14.	Danish Power	841.85	24.77	1657.74	0.00	29.31	41.39	211.06	29.18	40.21	28.94
15.	Jaro Institute	407.45	18.17	904.44	0.49	7.03	280.72	60.01	38.62	39.89	35.76
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.	Concord Control	2628.10	89.77	2728.87	0.00	16.02	93.48	81.55	63.92	36.78	27.39
17.	Sobhagya Mercant	906.45	32.93	788.62	0.00	6.05	65.75	47.47	5.12	33.71	24.43
18.	SRM Contractors	517.30	14.64	1186.34	0.00	24.10	50.62	231.21	53.69	33.20	27.16
19.	Uni Abex Alloy	3189.65	18.07	629.95	1.10	5.47	3.40	45.53	8.22	31.90	26.26
20.	Aryaman Fin.Serv	611.95	22.47	749.45	0.00	8.87	-51.62	19.95	-46.91	31.88	31.30
21.	Aryaman Capital	448.00	18.63	536.58	0.00	5.73	-50.43	15.44	-35.13	31.72	38.69
22.	Balu Forge	557.70	26.46	6769.42	0.03	71.09	20.47	311.11	21.63	31.26	25.38
23.	Basilic Fly Stud	245.35	11.41	619.88	0.00	8.83	19.82	105.02	12.39	31.23	24.79
24.	Desco Infra.	261.75	12.27	200.92	0.00	10.21	75.73	76.57	108.01	30.15	25.25
25.	Systango Tech	293.60	13.32	430.68	0.00	18.30	88.66	45.49	58.06	28.74	23.38

1 2 Next

Results per page

10 25 50

Search Query

You can customize the query below:

Query

Custom query example

Market capitalization > 500 AND Price to earning < 15 AND Return on capital employed > 22%

Detailed guide on creating screens

Only companies with Mar 2026 results