Coffee Can Portfolio (CCP) Base Query

This query returns the least number of stocks which May have generated > 10% sales growth every year for last ten years and > 15% ROCE every year for the last ten years. Use this list as the starting point to further filter out stocks which actually meet the requirements of CCP. (Note that the requirement for CCP is that the growth should exceed the specified rate every year and is not merely the CAGR.)

by Nitish

124 results found: Showing page 1 of 5

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 3Yrs %	Sales Var 5Yrs %	Sales Var 7Yrs %
1.	Atam Valves	90.53	16.47	103.77	0.83	2.13	-20.52	14.71	-14.72	20.33	43.84	30.01	19.58
2.	Touchwood Enter.	102.31	17.85	113.37	0.39	1.30	282.35	16.90	337.82	18.39	37.27	27.04	21.02
3.	Siddhika Coatins	209.00	16.79	129.14	1.58	3.74	58.47	24.36	17.17	31.10	33.12	10.35	12.34
4.	Amba Enterprises	142.10	24.28	179.91	0.35	1.89	11.18	83.73	7.97	20.56	15.34	27.31	24.48
5.	Prime Fresh	158.20	24.37	215.88	0.32	3.46	-12.18	103.02	28.61	18.68	37.36	32.89	27.31
6.	Dev Information	109.31	18.83	246.32	0.23	2.18	-40.23	42.99	21.24	25.59	19.57	20.02	13.67
7.	Fidel Softech	184.95	24.31	254.32	1.08	3.31	56.87	14.76	18.46	30.09	27.72	19.62	20.86
8.	Loyal Equipments	277.80	27.05	299.75	0.00	1.01	68.33	11.33	-12.10	28.26	32.71	17.62	19.75
9.	Alufluoride	402.10	16.33	314.46	0.75	3.18	-18.04	43.76	29.81	23.62	28.94	20.01	20.99
10.	Global Education	65.29	14.02	332.34	2.30	4.38	-25.26	14.38	4.20	35.93	19.97	20.32	11.60
11.	Geekay Wires	67.89	10.63	354.79	0.88	7.19	-28.32	91.74	-5.58	25.37	21.13	19.21	20.58
12.	DJ Mediaprint	109.74	54.98	360.15	0.09	2.28	-23.75	23.70	-14.25	16.05	18.15	29.81	24.02
13.	Cybertech Sys.	145.63	12.68	453.35	1.37	8.17	11.01	58.19	0.54	19.58	19.32	15.90	15.31
14.	Vikram Thermo	149.85	21.24	469.90	0.50	4.07	-26.53	27.11	-1.02	36.29	10.89	17.71	14.46
15.	Fredun Pharma	1059.35	21.34	500.19	0.07	6.77	63.92	119.85	52.06	18.94	27.11	32.25	33.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 %	Sales Var 3Yrs %	Sales Var 5Yrs %	Sales Var 7Yrs %
16.	Zodiac Energy	432.10	32.72	653.49	0.00	9.44	65.91	171.34	60.69	20.17	41.82	43.01	40.15
17.	Shree Ganesh Rem	539.75	31.64	692.86	0.00	3.45	-25.81	24.67	-0.44	19.51	15.06	13.20	22.05
18.	Integra Engg.	235.35	39.27	810.20	0.00	5.08	72.79	45.73	29.40	24.45	16.93	21.39	20.43
19.	RMC Switchgears	827.40	27.73	870.99	0.02	21.16	209.81	211.52	148.23	37.19	96.72	39.73	21.05
20.	Indo Amines	138.21	17.95	1003.23	0.36	11.85	29.93	285.41	12.70	18.34	11.13	17.64	17.19
21.	KMC Speciality	65.11	49.55	1061.94	0.00	4.52	-36.25	60.93	35.73	17.13	19.40	19.21	18.48
22.	Likhitha Infra.	273.25	16.28	1077.97	0.55	13.91	-18.51	122.41	-2.10	27.59	25.82	26.01	28.81
23.	ICE Make Refrig.	730.25	64.09	1152.32	0.27	-1.39	-136.10	111.86	34.50	20.57	33.08	28.26	24.63
24.	Control Print	739.00	12.44	1181.97	1.35	8.56	-42.97	111.29	13.76	18.46	18.38	16.87	13.62
25.	Dynacons Sys.	992.65	17.44	1263.18	0.05	18.17	27.15	330.61	17.13	39.15	24.66	31.03	29.21

1 2 3 4 5 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 Jun 2025 results