Welcome,
Guest


Basically what I'm trying to find are stocks that show increase in growth across Net Profit Margin, Revenue and EPS for last 4 periods (4 years or 4 quarters). So they key element here is company growth.
So here is an example of what I'm looking for: i.share.pho.to/a8ec2324_o.png As you can see in this example, the company shows a consecutive growth (according to those stats) over last 4 periods. What would be the full formula to screen that with screener.co? 
Anton


You can use Free Form Conditions in the Basic Screener to set up your screen. For Net Profit Margin, you would use:
Net Income(I) / Total Revenue(I) > 1.064 * ( Net Income(I1) / Total Revenue(I1) ) Net Income(I1) / Total Revenue(I1) > 1.057 * ( Net Income(I2) / Total Revenue(I2) ) Net Income(I2) / Total Revenue(I2) > 1.05 * ( Net Income(I3) / Total Revenue(I3) ) Net Income(I3) / Total Revenue(I3) > 1.043 * ( Net Income(I4) / Total Revenue(I4) ) I'm not sure how to interpret the negative numbers in your table, but, for Revenue, you can use: Total Revenue(I) > 1.05 * Total Revenue(I1) for 5% growth (and can adjust the percentage factor as needed) For EPS, you can use: Diluted EPS(I) > 1.05 * Diluted EPS(I1) You can build out the formulas for the previous periods Revenue and EPS just as was done with net margin. 


Thank you for your message, I have applied some rules I created in Free Condition Forum, however, I noticed that the actual data doesn't match my formula criteria.
Basically I wanted to find stocks that were doubling their EPS for the last 4 consecutive quarters. The thing is that the numbers in column don't match the formula pattern, and that doesn't just apply to negative numbers, but also to positive ones, it seems very random, maybe I did something wrong? i.imgur.com/WoeuhYo.png 
Anton


You should add Free Form Conditions for each time period to exclude negative numbers. For example:
Basic EPS Excluding Extraordinary(I) > 0 Those numbers look correct to me. For example, AMEX:CEI: 39 > 92 * 2 11 > 39 * 2 13.8 > 11 * 2 The problem is that you are allowing negative numbers. 


Yes but if I exclude negative numbers that would leave out around 40% of stocks out of equation.
As if the company grows from negative numbers I still want to see it, for example: 10 5 0 +10 As well as 100 75 50 25 Those 4 consecutive periods both show growth. So how do I include that? 
Anton


Also, providing your example on AMEX:CEI:, that is indeed correct, but what about the others that I highlighted? They are not accurate. I mean if AMEX:CEI: is working why others don't make sense?

Anton
