指定
Sunday PM
November 15th, 2015
Programmer,
Just need TICK based data from MT4, using DDE, into Excel.
Most cell formulas are copy and paste.
Symbols(pairs) required must be in a generic coding format so I can put the correct
currency names into the cells easily, apply protection, and resave the file.
Multiple audio alerts and cells changing colors based on ticks and other related cells.
Copy of spreadsheet is included as I need ALL cells visible on a laptop screen
at the same time, thus no scrolling.
Indicators being referenced are RSI and EMA only.
Cells(tick updated) need to be programmed as follows:
EMA Columns;
C21, D21,A7, A11, A15, E5, E9,A5,A9, A13, A17, E7, E11, A21,
I5, I7, I9, I11, I13, and I15
all cells will reference a different currency pair that I need to add-
if EMA of 3 periods and weighted is ABOVE EMA of 5 and weighted then cell is green, or
if EMA of 3 and weighted is BELOW EMA of 5 and weighted then cell is red, or
cell is yellow if BOTH statements are false-
RSI Columns;
C23, D23, A23, J5, J7, J9, J11, J13, J15, F5, F7, F9, F11, B5,
B7, B9, B11, B13, B15, and B17
all cells will reference a different currency pair that I need to add-
if RSI of 2 periods(tick updated) and NO limit cap on 0 level or 100 level is
equal to or greater than 70 then cell is green, or if RSI of 2 periods(tick updated)
and NO limit cap on 0 level or 100 level is equal to or lesser than 30 then cell is
red, or if RSI is greater than 30 but less than 70 than cell is yellow-
TICK Columns;
C25, D25, A25, K5, K7, K9, K11, K13, K15, G11, G9, G7, G5, C5, C7,
C9, C11, C13, C15, and C17
all cells will reference a different currency pair that I need to add-
if current tick is greater than or equal to the previous tick then cell is green, or
if current tick is less than or equal to the previous tick then cell is red, or if
no change in price then cell is yellow-
Cell Activity to create Very Short Audio Alert:
Cell A3 turns red if majority of any 5 of 7 cells(A5, A7, A9, A11, A13, A15, or A17)
are red, or cell A3 turns green if majority of any 5 of 7 cells(A5, A7, A9, A11, A13, A15,
or A17) are green, or any other condition cell A3 turns yellow-
Cell E3 turns red if majority of any 3 of 4 cells(E5, E7, A9, or E11)
are red, or cell E3 turns green if majority of any 3 of 4 cells(E5, E7, E9, or E11)
are green, or any other condition cell E3 turns yellow-
Cell I3 turns red if majority of any 4 of 6 cells(I5, I7, I9, I11, I15,or I13)
are red, or cell I3 turns green if majority of any 4 of 6 cells(5, I7, I9, I11, I15,or I13)
are green, or any other condition cell I3 turns yellow-
Cells A3 and E3 and I3 shall ALWAYS show the number of cells, referenced by them,
as a foreground number in black(thick font please) whether the cell is either red or green.
Cell B3 turns red if majority of any 5 of 7 cells(B5, B7, B9, B11, B13, B15, or B17)
are red, or cell B3 turns green if majority of any 5 of 7 cells(B5, B7, B9, B11, B13, B15,
or B17) are green, or any other condition cell B3 turns yellow-
Cell F3 turns red if majority of any 3 of 4 cells(F5, F7, F9, or F11)
are red, or cell F3 turns green if majority of any 3 of 4 cells(F5, F7, F9, or F11)
are green, or any other condition cell F3 turns yellow-
Cell J3 turns red if majority of any 4 of 6 cells(J5, J7, J9, J11, J15,or J13)
are red, or cell J3 turns green if majority of any 4 of 6 cells(J5, J7, J9, J11, J15,or J13)
are green, or any other condition cell J3 turns yellow-
Cells B3 and F3 and J3 shall ALWAYS show the number of cells, referenced by them,
as a foreground number in black(thick font please) whether the cell is either red or green.
Cell C3 turns red if majority of any 5 of 7 cells(C5, C7, C9, C11, C13, C15, or C17)
are red, or cell C3 turns green if majority of any 5 of 7 cells(C5, C7, C9, C11, C13, C15,
or C17) are green, or any other condition cell C3 turns yellow-
Cell G3 turns red if majority of any 3 of 4 cells(G5, G7, G9, or G11)
are red, or cell G3 turns green if majority of any 3 of 4 cells(G5, G7, G9, or G11)
are green, or any other condition cell G3 turns yellow-
Cell K3 turns red if majority of any 4 of 6 cells(K5, K7, K9, K11, K15,or K13)
are red, or cell K3 turns green if majority of any 4 of 6 cells(K5, K7, K9, K11, K15,
or K13) are green, or any other condition cell K3 turns yellow-
Cells C3 and G3 and K3 shall ALWAYS show the number of cells, referenced by them,
as a foreground number in black(thick font please) whether the cell is either red or green.
F14, F15, and F16 are always the same as F13 and F13 is the cell getting updated only-
Twelve(12) possible combinations that can create an audio alert.
The sound will be the same for all possibilities and continue every 5 seconds as long as
one of the combinations are true.
Cell D1 will be red if Cells A3 and E3 are red and audio alert else it turns yellow and no alert-
Cell D1 will be green if Cells A3 and E3 are green and audio alert else it turns yellow and no alert-
Cell H1 will be red if Cells B3 and F3 are red and audio alert else it turns yellow and no audio alert-
Cell H1 will be green if Cells B3 and F3 are green and audio alert else it turns yellow and no alert-
If D1 and H1 are red then F13 goes red and audio alert else goes yellow and no alert-
If D1 and H1 are green then F13 goes green and audio alert else goes yellow and no alert-
If C21 is green and D21 is red then audio alert, or
if C21 is red and D21 is green then audio alert-
If C23 is green and D23 is red then audio alert, or
if C23 is red and D23 is green then audio alert-
If C25 is green and D25 is red then audio alert, or
if C25 is red and D25 is green then audio alert-
Sure hope these pages are not difficult to implement from MT4 into Excel!
Thank you in advance for your time regarding this matter.
Sincerely,
Mark
PS Glad to send a Excel Spreadsheet Layout I envisioned to your email address!
EMA | RSI | |||||||||
Major EMA | Major RSI | Major TICKS | Major EMA | Major RSI | Major TICKS | Major EMA | Major RSI | Major TICKS | ||
pair | symbol | correlation | ||||||||
pair | symbol | correlation | ||||||||
pair | symbol | correlation | ||||||||
pair | symbol | correlation | ||||||||
pair | correlation | |||||||||
pair | correlation | |||||||||
pair | ||||||||||
EMA – RSI | ||||||||||
EurChf | EurUsd | UsdChf | ||||||||
EMA | EMA | EMA | ||||||||
RSI | RSI | RSI | ||||||||
TICKS | TICKS | TICKS | ||||||||