MT4 Trading the GAP With Excel | Page 139 | 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,761
  • Feb 3, 2017 2:10pm Feb 3, 2017 2:10pm
Quoting Forexpinbar
NY session results..Not a bad way to end the week..Green pips to you all. {image}
Forexpinbar, jsut for clarification, you only go off the speedometer and when it says buy sell then go to the CSM and heatmap? Or do you check MTF Gaps like suggested earlier? Just curious. I have had promising results using the sell/buy, CSM and modoki.
  • #2,762
  • Edited 3:09pm Feb 3, 2017 2:47pm | Edited 3:09pm
Quoting ForexFury
{quote} Hey, Have you completed all of the steps listed here? http://www.forexfactory.com/showthre...20#post9497120 If your spreadsheet still doesn't seem right please post screenshots and describe in more detail what doesn't seem to be working.
Hi
I followed the steps all of them still I get the same result I have been trying it I will try sending the pictures I don't knw if they will show properly
I went and enable MT4 to run the speedometer on excel then installed the files copied the speedometer file to files, I ran the export to excel then i stopped till it says history complete but still same result here are my screenshots please help me its getting to me now lol
Attached Image(s) (click to enlarge)
Click to Enlarge Name: Capture3.PNG Size: 23 KB
Click to Enlarge Name: Capture4.PNG Size: 129 KB
Click to Enlarge Name: Capture5.PNG Size: 120 KB
Click to Enlarge Name: Capture3 - Copy.PNG Size: 23 KB
Click to Enlarge Name: Capture1 - Copy.PNG Size: 97 KB
Attached Images
  • #2,763
  • Feb 3, 2017 11:06pm Feb 3, 2017 11:06pm
OK. Try this to solve the problem.
Attached Image (click to enlarge)
Click to Enlarge Name: Excel Path.png Size: 392 KB
  • #2,764
  • Feb 4, 2017 12:19am Feb 4, 2017 12:19am
Quoting brucech
OK. Try this to solve the problem. {image}
Good morning I tried to correct i will send you the screenshot but it didnt load the history i will try it on monday but i did this
Attached Image (click to enlarge)
Click to Enlarge Name: Capture6.PNG Size: 110 KB
  • #2,765
  • Feb 4, 2017 2:13am Feb 4, 2017 2:13am
Hello fellow traders, thank you so much for all your greetings, prayers and support. It helped us a lot. Nathalia is on a good way again. I'm sure after a couple of days she will continue with her project which she started just before she became sick.

She will be more satisfied and happy even if she's seeing how good her robot was doing its duties while she was asleep.

Once again thank you for everybody's support and stay green always.

Jibala
Attached Image
PDF & BCC (Patience Discipline Focus & Belief Confidence Consistency)
  • #2,766
  • Edited 6:17am Feb 4, 2017 5:56am | Edited 6:17am
Quoting JibalaPasan
Hello fellow traders, thank you so much for all your greetings, prayers and support. It helped us a lot. Nathalia is on a good way again. I'm sure after a couple of days she will continue with her project which she started just before she became sick. She will be more satisfied and happy even if she's seeing how good her robot was doing its duties while she was asleep. Once again thank you for everybody's support and stay green always. Jibala widget.png;2172415 {image}


Results that come from determination, dedication, motivation and passion will always succeed in the end.
First of all we breath and love what we do.
By failing to prepare, you are preparing to fail.
  • #2,767
  • Feb 4, 2017 10:40am Feb 4, 2017 10:40am
Forexpinbar, how do u decide when to TP or SL?
  • #2,768
  • Edited 5:10am Feb 5, 2017 2:32am | Edited 5:10am
Quoting the bourne
{quote}.. I'm currently studying Muti timeframes Gap for M15-M30-H1 Correlation = I'm saving each xx ticks the single Currency strenght,for each TimeFrame,then I subtract the actual (the more recent )strenght from the first of the column,obtaining each time an updated Gap . I put all this Gaps in another excel tab,the 2 tabs are side by side[see pic 1 ] and calculate correlations from there.Obtained correlation % values are shown in the main trading window,for visual testing purposes [see pic 2].I do this for each timeframes,calculating the strenght...
Hi the bourne,

I'm reading this thread and particularly studying gap correlation.

This post of your was interesting to me and thanks to attached pics it's clear enough, except for how you determine xx ticks value.
Taking M15 TimeFrame as example, if you want to have 60 measurements (i.e. your COUNT), xx ticks should be equal to : 900000 / 60 = 15000.

Is it calculation correct ?

Finally is not totally clear to me your last sentence of the post when you say that "Obviously,the M15 strenght TAB refreshes at each new M15 candle, ..."
Can you please explain ?

Thank you and best regards,
Bubincka
Porta itineris dicitur longissima esse
  • #2,769
  • Feb 5, 2017 3:23am Feb 5, 2017 3:23am
Forexpinbar,

We appreciate your posts. It is very helpful to understanding how to use both the Excel and the chart indicators to know when to pull the trigger.

Please continue to post your screenshots as you have done in this post. It gives us a chance to see what you were seeing at the time you decided to to the trades.
http://www.forexfactory.com/showthre...88#post9519588


Thanks.

Bruce
  • #2,770
  • Feb 5, 2017 12:50pm Feb 5, 2017 12:50pm
Quoting bubincka
{quote} Hi the bourne, I'm reading this thread and particularly studying gap correlation. This post of your was interesting to me and thanks to attached pics it's clear enough, except for how you determine xx ticks value. Taking M15 TimeFrame as example, if you want to have 60 measurements (i.e. your COUNT), xx ticks should be equal to : 900000 / 60 = 15000. Is it calculation correct ? Finally is not totally clear to me your last sentence of the post when you say that "Obviously,the M15 strenght TAB refreshes at each new M15 candle, ..." Can you...
Hello Bubincka
I know you are doing great from the other thread.
Come on,keep it up!

About your question,COUNT is just an Iteration Counter,numbers are random and not time related
DO UT DES
  • #2,771
  • Feb 5, 2017 6:17pm Feb 5, 2017 6:17pm
Good morning traders please can someone please help me with the excel gap installation its killing me i have been busy with it but somewhere somehow i am failing to get it ryt pls help
Attached Image(s) (click to enlarge)
Click to Enlarge Name: cut 1.PNG Size: 116 KB
Click to Enlarge Name: cut 2.PNG Size: 102 KB
  • #2,772
  • Feb 5, 2017 8:49pm Feb 5, 2017 8:49pm
I have problem with heat map modoki

Attached Image (click to enlarge)
Click to Enlarge Name: Capture.PNG Size: 7 KB


Anyone can help me please
  • #2,773
  • Feb 5, 2017 9:06pm Feb 5, 2017 9:06pm
Just found another version that working ,
is this version is same with you guys ??

Attached Image
Attached File(s)
File Type: mq4 HeatMapModokiV1.mq4   8 KB | 515 downloads
  • #2,774
  • Feb 5, 2017 9:48pm Feb 5, 2017 9:48pm
Quoting NooBme
Just found another version that working , is this version is same with you guys ?? Capture.PNG;2173652 {file} {image}
Yes, is the same.
  • #2,775
  • Feb 6, 2017 1:39am Feb 6, 2017 1:39am
Quoting kdaawwgy
Good morning traders please can someone please help me with the excel gap installation its killing me i have been busy with it but somewhere somehow i am failing to get it ryt pls help {image} {image}
I strongly recommend that you start reading again because you don't understand a little bit even how it must work and how you have to setup properly. If for any case you still have problems use the search function and do some research on how to solve the issue. There's no shortcut and especially no spoon-feeding. If you are not willed to put some efforts in your work you're not worth to earn anything!

Jibala
PDF & BCC (Patience Discipline Focus & Belief Confidence Consistency)
  • #2,776
  • Feb 6, 2017 1:46am Feb 6, 2017 1:46am
Quoting JibalaPasan
{quote} I strongly recommend that you start reading again because you don't understand a little bit even how it must work and how you have to setup properly. If for any case you still have problems use the search function and do some research on how to solve the issue. There's no shortcut and especially no spoon-feeding. If you are not willed to put some efforts in your work you're not worth to earn anything! Jibala
How is Nathalia feeling ?
By failing to prepare, you are preparing to fail.
  • #2,777
  • Feb 6, 2017 2:21am Feb 6, 2017 2:21am
Quoting project13et
{quote} How is Nathalia feeling ?
She is on a good way to recover. The first thing she asked for was her laptop because she wants to continue with her project.

Jibala
PDF & BCC (Patience Discipline Focus & Belief Confidence Consistency)
  • #2,778
  • Feb 6, 2017 2:45am Feb 6, 2017 2:45am
Quoting the bourne
{quote} Hello Bubincka I know you are doing great from the other thread. Come on,keep it up! About your question,COUNT is just an Iteration Counter,numbers are random and not time related
Hi the bourne,

thank you for your reply.

Yes, my main strategy is indeed 00-level by Udine, that I regularly trade 100% manually.

Now, after having considered the many similarities between the 00-level system and trading the Gap with Excel, I wanted to know more on this thread, because discoveries on a strategy can bring benefits in trading the other one and vice-versa (e.g. gap correlation, it could be very useful if available in a dashboard to trade 00-level system manually).

Therefore to calc gap correlation in the example you posted, I saw that you get currency strength every xx ticks and the only way I see to implement this in MT4 is by using GetTickCount() function. Then, after you reach the max count that should coincide with the duration of a specific TimeFrame you reset the COUNT and start again from zero. Based on these strengths you calculates the gaps each xx ticks and then apply the Excel CORREL function to these values-
This is the way I uderstood your post.

Anyway I will diligently read all the thread from post #1, as masters teach it is the only way to understand and grow.

Best regards,
Bubincka
Porta itineris dicitur longissima esse
  • #2,779
  • Edited 6:50am Feb 6, 2017 5:25am | Edited 6:50am
Good time to buy JPY pairs. ..81pips after signal and still counting.
Attached Image(s) (click to enlarge)
Click to Enlarge Name: LG.png Size: 18 KB
Click to Enlarge Name: lg2.png Size: 16 KB
Goal of a successful trader is to make the best trades. Money is secondary
  • #2,780
  • Feb 6, 2017 7:04am Feb 6, 2017 7:04am
JPY is on heat..Feel the power..
Attached Image (click to enlarge)
Click to Enlarge Name: LG.png Size: 16 KB
Goal of a successful trader is to make the best trades. Money is secondary
9 traders viewing now