I want to have the following judgement done automatically and export to an Excel file dynamically.
EURUSD (or any given pair)
The most recent price movement is a net X-pips up or down? ("net" here means without an X-pip retracement)
e.g.:
X=30;
price has a recent low of 1.5700, if the price gradually goes up without a 30-pip retracement and touches 1.5730 and or beyond, the returned result should be "UP".
Then, on a definite cell in an Excel file, the value "up" is refreshed.
My question to all you MT4 experts here is, can this be done?
If yes, how? by an custom indicator or something else?
Thanks in advance for your response.
An MQL programming newbie.

EURUSD (or any given pair)
The most recent price movement is a net X-pips up or down? ("net" here means without an X-pip retracement)
e.g.:
X=30;
price has a recent low of 1.5700, if the price gradually goes up without a 30-pip retracement and touches 1.5730 and or beyond, the returned result should be "UP".
Then, on a definite cell in an Excel file, the value "up" is refreshed.
My question to all you MT4 experts here is, can this be done?
If yes, how? by an custom indicator or something else?
Thanks in advance for your response.
An MQL programming newbie.