(OPEN-CLOSE)>a & (CLOSE)>EMA(d)>EMA(e)
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.
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.