Hello,
first of all sorry for my bad english and mistakes if i do.
in my strategy there is a criterion like this: OpInc(0,QTR)>OpInc(1,QTR)*1.5
in this formula if the ‘‘OpInc(1,QTR) is negative’’ and ‘‘OpInc(0,QTR) positive’’, it passes the criterion. But i can not formulise it.
in other words, in the this formula, ((OpInc(0,QTR)-OpInc(1,QTR))/ OpInc(1,QTR))*100 > 50, the company has been increased operation income more than %50 according to previous quarter. But When I started the screen test, it couldn’t catch the company.
for example:
OpInc(0,QTR)=500
OpInc(1,QTR)=-300
(500-(-300)/-300 =800/-300 = - 266 (it is not big from 50 :))
I can solve the problem in excell like this: ((OpInc(0,QTR)-OpInc(1,QTR))/ [b]MUTLAK/b)*100 > 50,
is there any function to solve this problem in the screen section.? and is there any benevolent body wanna help for poor me ?
thank you all…