Needed a MetaTrader 5 script that reads an excel sheet. Format of excel sheet below ( file also attached).
Pair Active Chart LTR MTR STR LTS MTS STS 50PCT 21EMA 8EMA
AUDUSD Y D1 1.051 1.034 1.017 0.992 0.965 0.941 0 Y N
EURUSD N H1 1.051 1.034 1.017 0.992 0.965 0.941 0 Y N
Only one line will have Active = Y value. When the script encounters Active = Y, it opens a chart where the chart type (D1 or H1 or H4) based on the value in that column.
Then the horizontal lines for LTR, MTR, STR, LTS, MTS, STS and 50PCT are automatically drawn using script.
21EMA and 8EMA are only drawn if value = Y for each.
It will be great if the lines can have a text next to it saying what type of line it is (LTR etc). If not, different colors would be preferred.
The chart that opens should have white background with bullish bar in green and bearish bar in red.
Optional:
It will be great if I also have the option to save back the values to the excel sheet for that currency if I move the horizontal lines up or down .. controlled using some button.
If something I have mentioned is not possible but there is another way to achieve it using another method, I am open to feedback