how to Query best stocks for longterm in screener

75 results found: Showing page 1 of 3

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 %	Sales Var 5Yrs %	Profit Var 5Yrs %
1.	Tips Music	690.95	40.75	8832.52	1.88	59.06	92.94	103.93	32.41	122.19	32.91	38.14
2.	One Global Serv	544.20	15.30	1063.53	0.00	18.19	68.58	133.81	141.27	87.02	167.02	97.21
3.	Waaree Renewab.	970.25	21.15	10124.15	0.10	155.71	60.69	1102.40	131.31	83.61	203.30	189.68
4.	Jindal Poly Inve	1095.60	1.34	1151.48	0.00	35.16	-47.25	47.28	503.83	63.41	296.33	123.39
5.	Sigma Advanced System	435.80	27.69	7680.53	0.00	128.45	1400.69	322.82	469.05	60.82	52.62	172.38
6.	HBL Engineering	794.95	26.30	22035.61	0.25	63.73	44.18	604.12	27.03	58.45	29.35	117.77
7.	Frontier Springs	1502.70	28.96	1775.52	0.04	16.59	42.28	82.54	17.78	50.92	33.15	51.12
8.	Shilchar Tech.	4069.00	29.43	4655.02	0.31	28.39	-48.72	151.65	-34.59	50.72	40.80	95.56
9.	HDFC AMC	2495.90	37.42	106987.57	2.16	623.29	-2.42	1050.48	16.56	42.88	16.02	16.62
10.	V-Marc India	1513.95	36.94	3697.17	0.00	63.63	157.30	1105.46	97.52	41.38	59.91	76.88
11.	Oriana Power Ltd	1686.40	13.58	3426.62	0.00	130.41	19.02	1032.49	64.51	39.61	122.17	222.80
12.	Indo Tech.Trans.	2657.60	30.42	2822.37	0.00	23.92	14.01	238.99	15.98	37.71	30.58	71.30
13.	Gokul Agro	232.85	18.60	6871.09	0.00	118.92	144.14	6200.19	13.51	36.73	23.53	53.33
14.	Jyoti Resins	878.95	15.07	1054.74	1.02	20.08	1.52	92.94	18.23	36.53	25.45	44.39
15.	Force Motors	18243.00	22.75	24037.45	0.22	278.54	56.59	2549.84	8.23	36.08	35.43	65.51
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 %	Sales Var 5Yrs %	Profit Var 5Yrs %
16.	Indrapr.Medical	396.00	19.77	3630.25	1.14	41.70	1.68	364.81	9.31	35.83	19.30	132.20
17.	Manorama Indust.	1476.10	37.79	8813.58	0.04	59.52	40.81	382.30	64.21	35.45	46.29	74.10
18.	Sika Interplant	931.50	54.19	1974.86	0.26	7.83	-1.01	41.33	-10.19	35.24	21.52	25.57
19.	C P C L	1181.40	5.67	17592.39	0.68	1421.85	202.57	16817.32	-2.50	35.11	23.42	64.54
20.	eClerx Services	1380.10	18.38	12979.94	0.04	189.65	24.45	1107.29	23.27	34.81	21.35	21.53
21.	Godfrey Phillips	2220.10	22.70	34629.51	1.43	521.46	77.36	1787.27	13.59	32.84	20.41	37.92
22.	Cemindia Project	1112.80	32.49	19116.52	0.27	242.17	113.63	2973.49	17.42	32.76	29.83	112.23
23.	Action Const.Eq.	900.30	25.83	10721.06	0.22	110.91	-6.45	1029.49	7.13	31.70	21.73	40.49
24.	Algoquant Fin	54.66	46.93	1536.47	0.00	15.88	1398.11	77.28	43.35	31.43	111.83	67.14
25.	SML Mahindra	3785.00	34.28	5476.90	0.62	54.20	2.36	897.65	16.45	30.92	36.86	26.15

1 2 3 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