(OPEN-CLOSE)>a & (CLOSE)>EMA(d)>EMA(e)
with:
a=(0.0004,0.0006,0.0008,0.00010,0.00012)
d=(1,2,3,4,5,6,7,8,9,10…198,199,200)
e=(1,2,3,4,5,6,7,8,9,10…198,199,200)
e >= d+3
CLOSE, OPEN, EMA1,EMA2,…EMA200 ARE DEFINED LIKE VARIABLES ALREADY. How can I make this query in MYSQL? The number of combinations is a lot.
LAST QUESTIONS:
SELECT * FROM 1week WHERE ADX>25 AND (OPEN-CLOSE)>0.00020
THE PROBLEM IN HERE IS THAT THE (OPEN-CLOSE)>0.00020 NEEDS TO BE FOR THE NEXT DATE WHERE ADX>25 EVERY TIME.
THANKS A LOT IN ADVANCE.