Welcome,
Guest


hello,
I start with the screener and I can't find my filter criteria.  Price which has increased by 10% for the current year  Price increased by 10% for year n1  Price increased by 10% for year n2  Netsales which increased by 10% for the current year  Netsales which increased by 10% for the year n1  Netsales which increased by 10% for the year n2  EPS which increased by 10% for the current year  EPS which increased by 10% for year n1  EPS which increased by 10% for year n2  Cashflow which increased by 10% for the current year  Cash flow which increased by 10% for the year n1  Cash flow which increased by 10% for the year n2  Netmargin >5% for the current year  Netmargin >5% for year n1  Netmargin >5% for year n2  Leverage (Debt / EBITDA) <3 for the current year  Leverage (Debt / EBITDA) <3 for year n1  Leverage (Debt/EBITDA) <3 for year n2 Thank you for your help Translated with www.DeepL.com/Translator (free version) 
adolfin


Assuming you are screening quarterly reporting markets (4 interim periods per year), you can use the following Free Form Conditions:
 Price which has increased by 10% for the current year Price52 week price percent change >= 0.1  Price increased by 10% for year n1 We do not offer this.  Price increased by 10% for year n2 We do not offer this.  Netsales which increased by 10% for the current year ( Total Revenue(I) + Total Revenue(I1) + Total Revenue(I2) + Total Revenue(I3) ) >= ( Total Revenue(I4) + Total Revenue(I5) + Total Revenue(I6) + Total Revenue(I7) ) * 1.1  Netsales which increased by 10% for the year n1 We do not have quarterly results that go that far back, but you can use the last fiscal year: Total Revenue(A) >= Total Revenue(A1) * 1.1  Netsales which increased by 10% for the year n2 Similarly, you can use the prior fiscal year: Total Revenue(A1) >= Total Revenue(A2) * 1.1  EPS which increased by 10% for the current year ( Diluted EPS(I) + Diluted EPS(I1) + Diluted EPS(I2) + Diluted EPS(I3) ) >= ( Diluted EPS(I4) + Diluted EPS(I5) + Diluted EPS(I6) + Diluted EPS(I7) ) * 1.1  EPS which increased by 10% for year n1 You would use the fiscal years, like above, since we don't have quarterly numbers for the entire period: Diluted EPS(A) >= Diluted EPS(A1) * 1.1  EPS which increased by 10% for year n2 Diluted EPS(A1) >= Diluted EPS(A2) * 1.1  Cashflow which increased by 10% for the current year ( Total Operating Cash Flow(I) + Total Operating Cash Flow(I1) + Total Operating Cash Flow(I2) + Total Operating Cash Flow(I3) + Capital Expenditures(I) + Capital Expenditures(I1) + Capital Expenditures(I2) + Capital Expenditures(I3) ) >= ( Total Operating Cash Flow(I4) + Total Operating Cash Flow(I5) + Total Operating Cash Flow(I6) + Total Operating Cash Flow(I7) + Capital Expenditures(I4) + Capital Expenditures(I5) + Capital Expenditures(I6) + Capital Expenditures(I7) ) * 1.1  Cash flow which increased by 10% for the year n1 Using the fiscal year periods, like above: Total Operating Cash Flow(A) + Capital Expenditures(A) >= ( Total Operating Cash Flow(A1) + Capital Expenditures(A1) ) * 1.1  Cash flow which increased by 10% for the year n2 Total Operating Cash Flow(A1) + Capital Expenditures(A1) >= ( Total Operating Cash Flow(A2) + Capital Expenditures(A2) ) * 1.1  Netmargin >5% for the current year ( ( Net Income(I) + Net Income(I1) + Net Income(I2) + Net Income(I3) ) / ( Total Revenue(I) + Total Revenue(I1) + Total Revenue(I2) + Total Revenue(I3) ) ) >= 0.05  Netmargin >5% for year n1 ( ( Net Income(I4) + Net Income(I5) + Net Income(I6) + Net Income(I7) ) / ( Total Revenue(I4) + Total Revenue(I5) + Total Revenue(I6) + Total Revenue(I7) ) ) >= 0.05 OR using fiscal year: Net Income(A) / Total Revenue(A) >= 0.05  Netmargin >5% for year n2 Using fiscal year: Net Income(A1) / Total Revenue(A1) >= 0.05  Leverage (Debt / EBITDA) <3 for the current year Total Debt(I) / ( EBITDA(I) + EBITDA(I1) + EBITDA(I2) + EBITDA(I3) ) < 3  Leverage (Debt / EBITDA) <3 for year n1 Total Debt(I4) / ( EBITDA(I4) + EBITDA(I5) + EBITDA(I6) + EBITDA(I7) ) < 3 OR using fiscal year: Total Debt(A) / EBITDA(A) < 3  Leverage (Debt/EBITDA) <3 for year n2 Total Debt(A1) / EBITDA(A1) < 3 
Last Edit: 1 month, 2 weeks ago by admin.


thank you very much for such a detailed answer. i will try.
if you not offer " Price increased by 10% for year n1" . is it possible to have the condition  Price which increase by 30 % during the last 3 years ? 
adolfin


We only have price change variables going back a maximum of one year, and only for certain predefined periods. We cannot calculate price change over a longer period.

The following user(s) said Thank You: gandolfi


 Do you have an alternative to select the stocks that have had a regular progression during the last 3 years (growth stock).
 I would also like to avoid the growth stocks which are +60% and then 40%. It would be in progression of 20% but they are too volatile. 
adolfin


Unfortunately, we do not have price history going back more than a year. You can look for progression in company performance, but not in price.

