MT4 Trading the GAP With Excel | Page 149 | Forex Factory

Options

Go to
Permalinks
Print Thread

Similar Threads

MT4 to Excel through Excel RTD (Finally!) 612 replies

Trading using Excel and MT4? 29 replies

MT4 Trading without GAP and without Excel 669 replies

How to copy profiles in MT4? How to use Excel with MT4? 7 replies

Integration between excel and MT4 prices 3 replies

Attachments: MT4 Trading the GAP With Excel
Exit Attachments

MT4 Trading the GAP With Excel

  • #2,961
  • Feb 14, 2017 5:48am Feb 14, 2017 5:48am
Quoting project13et
{quote} This is why I ask if for possible breakout's I should use pending order, and for breakouts that happen already direct market execution, in this case the trade wouldn't be save ... but for feature ?
Let me explain a bit the difference or better to ask why we should wait for the price to reach a certain level if there is already momentum enough to TP? Do you really think your trade/order becomes safer if it's a stop/limit order instead of a market order?

Jibala
PDF & BCC (Patience Discipline Focus & Belief Confidence Consistency)
  • #2,962
  • Feb 14, 2017 5:52am Feb 14, 2017 5:52am
Quoting JibalaPasan
{quote} Let me explain a bit the difference or better to ask why we should wait for the price to reach a certain level if there is already momentum enough to TP? Do you really think your trade/order becomes safer if it's a stop/limit order instead of a market order? Jibala
Just to avoid very strong bounce level's. Because sometimes the signal's come on a very strong resistance level from where we don't know if it will break or bounce.
By placing the pending order when the signal is available, in case there is a breakout of that resistance the order will be executed instant, without waiting for a NEW signal.
By failing to prepare, you are preparing to fail.
  • #2,963
  • Feb 14, 2017 5:59am Feb 14, 2017 5:59am
Quoting project13et
{quote} Just to avoid very strong bounce level's. Because sometimes the signal's come on a very strong resistance level from where we don't know if it will break or bounce. By placing the pending order when the signal is available, in case there is a breakout of that resistance the order will be executed instant, without waiting for a NEW signal.
Conclusion: There's a filter missing! Think about what kind of.

Jibala
PDF & BCC (Patience Discipline Focus & Belief Confidence Consistency)
  • #2,964
  • Feb 14, 2017 6:07am Feb 14, 2017 6:07am
Quoting JibalaPasan
{quote} Conclusion: There's a filter missing! Think about what kind of. Jibala
For example what wipe all profit from today
Attached Image (click to enlarge)
Click to Enlarge Name: Prtscr_EURUSD.e_M30_13-29-10.gif Size: 15 KB


Entry
Attached Image (click to enlarge)
Click to Enlarge Name: GBPCHF_Entry.png Size: 58 KB


Exit
Attached Image (click to enlarge)
Click to Enlarge Name: Prtscr_GBPCHF.e_M30_14-08-20.gif Size: 58 KB




Edit: I will update the entry data soon
By failing to prepare, you are preparing to fail.
  • #2,965
  • Feb 14, 2017 6:17am Feb 14, 2017 6:17am
Quoting JibalaPasan
{quote} Conclusion: There's a filter missing! Think about what kind of. Jibala

GBPCHF, OP_BUY Order Details: Main Trend UP, BR: 0.95 (+/- 0.72), RS: 8.50 (+/- 6.80), BS: 4.39 (+/- 3.41), BS GAP: 2.56 (+/- 0.45), APS: 2.93, AMS: 2.72, BSR: 60.71% / 39.29% (67%), Bs&Bs: 0.50 / 0.00 (+/- 0.60), GBPCHF 2.15 / -2.23

Same story with MTF gaps and All Correlation Modules, they all look good

Spaghetti at the entry time.
Attached Image (click to enlarge)
Click to Enlarge Name: Spaghetti.png Size: 312 KB
By failing to prepare, you are preparing to fail.
  • #2,966
  • Feb 14, 2017 6:46am Feb 14, 2017 6:46am
Quoting project13et
{quote} GBPCHF, OP_BUY Order Details: Main Trend UP, BR: 0.95 (+/- 0.72), RS: 8.50 (+/- 6.80), BS: 4.39 (+/- 3.41), BS GAP: 2.56 (+/- 0.45), APS: 2.93, AMS: 2.72, BSR: 60.71% / 39.29% (67%), Bs&Bs: 0.50 / 0.00 (+/- 0.60), GBPCHF 2.15 / -2.23 Same story with MTF gaps and All Correlation Modules, they all look good Spaghetti at the entry time. {image}
My question, what's the use for the spaghetti if you do not read it the right way or you do not understand it? At the end of such a move, most of the current momentum has gone and especially on the strong major currencies a small decrease is enough for as many pips to trigger your S/L. Hence, why don't you measure a certain level of the move if it's already strong enough for an entry?Is it really that hard to see and to understand the elementary things of our trading tools?
Attached Image (click to enlarge)
Click to Enlarge Name: Ashampoo_Snap_2017.02.14_13h34m58s_055_.png Size: 296 KB


Jibala
PDF & BCC (Patience Discipline Focus & Belief Confidence Consistency)
  • #2,967
  • Feb 14, 2017 7:00am Feb 14, 2017 7:00am
Quoting JibalaPasan
{quote} My question, what's the use for the spaghetti if you do not read it the right way or you do not understand it? At the end of such a move, most of the current momentum has gone and especially on the strong major currencies a small decrease is enough for as many pips to trigger your S/L. Hence, why don't you measure a certain level of the move if it's already strong enough for an entry?Is it really that hard to see and to understand the elementary things of our trading tools? Ashampoo_Snap_2017.02.14_13h34m58s_055_.png;2186404 Jibala {image}...

The trade was automatic, I am at home the trades get automatic executed in office.

I have warring this issue multiple times, that a maxim BS GAP should be measured, as a too much momentum. One of the reply answer.

"You don't need to measure a max. GAP but a min. GAP is mandatory! Secondly, keep in mind for counter trade the ratio should be at least 1:3 whereby -55:165 is not the same as -165:55 which is much better! Just to play a bit with numbers. The GAP of the countered part of a pair should be much more negative than the opposite part is positive."

I was referring to BS GAP as describe in you're trade comment , maybe you refereed to BS and from here the confusion, and this was the main reasons why this filter was totally removed from automatic trading.

Edit: Beside this too much momentum, it was still in green zone for LBAR, but that's just a separate filter.

Would you be so kind to explain more how it should work this filter...... Conclusion: There's a filter missing! Think about what kind of.

Thanks,
By failing to prepare, you are preparing to fail.
  • #2,968
  • Feb 14, 2017 7:35am Feb 14, 2017 7:35am
Quoting project13et
{quote} The trade was automatic, I am at home the trades get automatic executed in office. I have warring this issue multiple times, that a maxim BS GAP should be measured, as a too much momentum. One of the reply answer. "You don't need to measure a max. GAP but a min. GAP is mandatory! Secondly, keep in mind for counter trade the ratio should be at least 1:3 whereby -55:165 is not the same as -165:55 which is much better! Just to play a bit with numbers. The GAP of the countered part...
What did I show you in the screen above? A min. GAP or a max. GAP to measure? For the filter, you want to know about, just a hint: What's more important for your trading decision, the past status or the current?

Jibala
PDF & BCC (Patience Discipline Focus & Belief Confidence Consistency)
  • #2,969
  • Feb 14, 2017 7:57am Feb 14, 2017 7:57am
Quoting JibalaPasan
{quote} What did I show you in the screen above? A min. GAP or a max. GAP to measure? For the filter, you want to know about, just a hint: What's more important for your trading decision, the past status or the current? Jibala
"why don't you measure a certain level of the move if it's already strong enough for an entry"

My trade comments

BS GAP: 2.56 (+/- 0.45)
BS: 4.39 (+/- 3.41)

The min is measured already by flexi, you describe a MAX BS GAP
By failing to prepare, you are preparing to fail.
  • #2,970
  • Feb 14, 2017 8:29am Feb 14, 2017 8:29am
[quote=JamesCaror;9558783]
Quoting eurjpower
The beauty GBP ower 100 pips! {image] Dear Eurjpower.. Do you get buy signal on CAD? Pls confirm.. James

james realy do no

I was not on Desk! I m just back
  • #2,971
  • Edited 10:31am Feb 14, 2017 8:31am | Edited 10:31am
Quoting JibalaPasan
{quote} What did I show you in the screen above? A min. GAP or a max. GAP to measure? For the filter, you want to know about, just a hint: What's more important for your trading decision, the past status or the current? Jibala
To be clear about MTF gap's also.


BS GAP: 2.56 (+/- 0.45)

Why was not trigger early the trade, and waited until 2.56? Because not all filter where ready. For example APS: 2.93, AMS: 2.72
Attached Image
By failing to prepare, you are preparing to fail.
  • #2,972
  • Feb 14, 2017 10:33am Feb 14, 2017 10:33am
hello everyone, I`ve started to read and follow this thread one month ago with a lot of interest, I followed all the steps to connect the mt4 to excel but I`m a little bit confused and I would have 2 questions if u could help me please:
1) "getValues" sheet from the "Speedometer_v4c" seems to doesn`t update ( never, as you can see in the picture that I took it today for GBPJPY for example ) so now I`m wondering where from are updating the other sheets because it seems to be ok or are updating wrong. I was thinking that is updating from DWM excel but even that one is not updating properly ( as you can see in the picture that I`ve attached it, took it from today )

2) I would like to add smaller time frames like M1, M5, M15 before M30 for other tests but I`m going back to the first question because I don`t know where from are updating because in getValues sheet and DWM excel seems to be written like a text, so I have an idea that the C_speedometer module has to be modified ( all that paragraph which is starting with Sub testingSPEED()

I would really I appreciate your help and your advice, specially if it would come from the oldest members of this thread like Jibala, the Bourne or project13et, many many thanks in advance!
Attached Images
  • #2,973
  • Feb 14, 2017 10:39am Feb 14, 2017 10:39am
Nice trade on NZDUSD:
Attached Image (click to enlarge)
Click to Enlarge Name: Ashampoo_Snap_2017.02.14_17h21m29s_056_.png Size: 78 KB


Better to see on a small time-frame:
Attached Image (click to enlarge)
Click to Enlarge Name: Ashampoo_Snap_2017.02.14_17h21m43s_057_.png Size: 73 KB


Jibala
PDF & BCC (Patience Discipline Focus & Belief Confidence Consistency)
  • #2,974
  • Feb 14, 2017 10:43am Feb 14, 2017 10:43am
Quoting JibalaPasan
Nice trade on NZDUSD: Ashampoo_Snap_2017.02.14_17h21m29s_056_.png;2186763 Better to see on a small time-frame: Ashampoo_Snap_2017.02.14_17h21m43s_057_.png;2186765 Jibala {image} {image}
Executed by different signal.

DGTS prevent the trade to be executed by LBAR right on the limit.
Attached Image (click to enlarge)
Click to Enlarge Name: Prtscr_NZDUSD_M30_18-41-25.gif Size: 62 KB
By failing to prepare, you are preparing to fail.
  • #2,975
  • Feb 14, 2017 11:46am Feb 14, 2017 11:46am
Quoting Gabriel11
hello everyone, I`ve started to read and follow this thread one month ago with a lot of interest, I followed all the steps to connect the mt4 to excel but I`m a little bit confused and I would have 2 questions if u could help me please: 1) "getValues" sheet from the "Speedometer_v4c" seems to doesn`t update ( never, as you can see in the picture that I took it today for GBPJPY for example ) so now I`m wondering where from are updating the other sheets because it seems to be ok or are updating wrong. I was thinking that is updating from DWM excel...
It seems the DDE connection is not working properly if nothing updates. Go to the mt4 installation folder and start the DDE-Sample.xls and see if it works and updates the values properly. You have to allow macros and third-party connections.

Jibala
PDF & BCC (Patience Discipline Focus & Belief Confidence Consistency)
  • #2,976
  • Feb 14, 2017 11:57am Feb 14, 2017 11:57am
Quoting JibalaPasan
{quote} It seems the DDE connection is not working properly if nothing updates. Go to the mt4 installation folder and start the DDE-Sample.xls and see if it works and updates the values properly. You have to allow macros and third-party connections. Jibala
Hi Jibala, first of all a big thank you for your reply, the DDE its ticked and the Sample.xls its working too because I tested it ( I found on the internet a few days ago that this might be the issue )...the other sheets like Strenght, CRS, Gap Sync are updating but I don`t know where from ( and that`s why I`m afraid that are updating wrong )
  • #2,977
  • Edited 12:25pm Feb 14, 2017 12:11pm | Edited 12:25pm
Quoting JibalaPasan
{quote} My question, what's the use for the spaghetti if you do not read it the right way or you do not understand it? At the end of such a move, most of the current momentum has gone and especially on the strong major currencies a small decrease is enough for as many pips to trigger your S/L. Hence, why don't you measure a certain level of the move if it's already strong enough for an entry?Is it really that hard to see and to understand the elementary things of our trading tools? Ashampoo_Snap_2017.02.14_13h34m58s_055_.png;2186404 Jibala {image}...

With all the respect, but I want to understand what would be the filter for that trade. Because the you're statements are contradictory.

You said this trade travel too much .
Attached Image (click to enlarge)
Click to Enlarge Name: Ashampoo_Snap_2017.02.14_13h34m58s_055_.png Size: 296 KB



I attached 3 photos from you're exact entries log that you showed here (All GBP). This will show similar entries from you, like the one you comment GBPCHF.


1) Entry on the trade even if the Spaghetti movement start from the same point.
2) Entry in the trade on the exact Spaghetti level as me.
3) You're total travel distance is even bigger then mine.


Situation 1.

Attached Image



Situation 2 & 3

Attached Image


Another example of Situation 3.

Attached Image


I really appreciate you're effort sister, I hope one day too be able too pay back you're efforts for me.
By failing to prepare, you are preparing to fail.
  • #2,978
  • Edited 6:26pm Feb 14, 2017 12:47pm | Edited 6:26pm
Quoting Gabriel11
{quote} Hi Jibala, first of all a big thank you for your reply, the DDE its ticked and the Sample.xls its working too because I tested it ( I found on the internet a few days ago that this might be the issue )...the other sheets like Strenght, CRS, Gap Sync are updating but I don`t know where from ( and that`s why I`m afraid that are updating wrong )
Gabriel11,

The sheet 'getValues' only updates when the function 'prevStrength_2' runs. 'prevStrength_2' only runs when you go to sheet 'GAP_test' and click one of the two buttons. There is no issue with your DDE setup as everything else is working. Where do all the values come from? They are based on formulas that are based on other formulas that are based on other formulas. If you click on any cell, it'll reveal the logic used in the toolbar. The only items that dynamically update are the High, Low, Bid and Ask.

My advice is to reverse engineer the spread sheet so you understand what it's doing before even thinking about modifications, let alone trading. Shouts, praises and Godspeed to the great dtlase, but the spreadsheet is a bit raw. It's a great starting point for beginners to understand Gap Theory but lacks a few essentials like error trapping.

Good luck and Godspeed.
Remember, Red. Hope is a good thing, maybe the best of things...
  • #2,979
  • Feb 14, 2017 1:13pm Feb 14, 2017 1:13pm
Quoting ForexFury
{quote} Gabriel11, The sheet 'getValues' only updates when the function 'prevStrength_2' runs. 'prevStrength_2 only runs when you go to sheet GAP_test and click one of the two buttons. There is no issue with your DDE setup as everything else is working. Where do all the values come from? They are based on formulas that are based on other formulas that are based on other formulas. If you click on any cell, it'll reveal the logic used in the toolbar. The only items that dynamically update are the High, Low, Bid and Ask. My advice is to reverse engineer...
ForexFury,

Thank you very very much for your reply, definitely it helped me, I just have tried...( I know that the formulas are based on other formulas and so on because I had a look and I started to build`em back like you said, but I was confused because the high, low, ask and bid didn`t update )...thank you once again and have nice day/evening!
  • #2,980
  • Feb 14, 2017 2:23pm Feb 14, 2017 2:23pm
Quoting eurjpower
The beauty GBP ower 100 pips! {image}
Hi eurjpy may i ask you why you removed M30 from original forexpinabar setup?

Best regards,
Bubincka
Porta itineris dicitur longissima esse
0 traders viewing now