MT4 Trading the GAP With Excel | Page 170 | 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

  • #3,381
  • Mar 13, 2017 1:37pm Mar 13, 2017 1:37pm
Quoting Aromos
{quote} Hi Jibala, this is what it shows? {image}
Ok, I'm not the specialist in that programming stuff. I had to ask for this myself. Two well-known reasons for such an error:

1. There's a hidden sheet in your workbook
2. There is a 2nd instance of M$ Excel in the same process running.

Solution for case 1: Unhide the sheet
Solution for case 2: Every new instance of M$ Excel must run in its own process

I hope, it will help to solve the problem.

Jibala
PDF & BCC (Patience Discipline Focus & Belief Confidence Consistency)
  • #3,382
  • Mar 13, 2017 1:52pm Mar 13, 2017 1:52pm
Quoting JibalaPasan
{quote} Brother, there are no stupid questions but answers (maybe a bit boring sometimes)! What you see is the effect of formatting, because of the silver shadow in the middle, nothing special. {image} Jibala
i am not talking about the shadow, but about the data bar filled to form the grey square in the back of the arrow


Thanks
By failing to prepare, you are preparing to fail.
  • #3,383
  • Mar 13, 2017 2:52pm Mar 13, 2017 2:52pm
Quoting project13et
{quote} i am not talking about the shadow, but about the data bar filled to form the grey square in the back of the arrow Thanks
The grey square belongs to the arrow. Just play a bit with the colours and you will see for yourself.

Jibala
PDF & BCC (Patience Discipline Focus & Belief Confidence Consistency)
  • #3,384
  • Mar 13, 2017 3:56pm Mar 13, 2017 3:56pm
Quoting JibalaPasan
{quote} The grey square belongs to the arrow. Just play a bit with the colours and you will see for yourself. Jibala
I installed an older version of excel and that come default So it's not possible to the newest version of excel, I like the design more, but I like even more the advantages of the newest versions
By failing to prepare, you are preparing to fail.
  • #3,385
  • Mar 14, 2017 12:12am Mar 14, 2017 12:12am
Quoting JibalaPasan
{quote} Ok, I'm not the specialist in that programming stuff. I had to ask for this myself. Two well-known reasons for such an error: 1. There's a hidden sheet in your workbook 2. There is a 2nd instance of M$ Excel in the same process running. Solution for case 1: Unhide the sheet Solution for case 2: Every new instance of M$ Excel must run in its own process I hope, it will help to solve the problem. Jibala

Hi Jibala, this was very helpful. Error solved!

However, the MT4 is not taking the order, what needs to be adjusted?
  • #3,386
  • Mar 14, 2017 8:52am Mar 14, 2017 8:52am
Quoting Aromos
{quote} Hi Jibala, this was very helpful. Error solved! However, the MT4 is not taking the order, what needs to be adjusted?
Hello brother Aromos. Happy to see it worked for you. Which of the named solutions was helpful? For your next problem we need some more details because it's very hard to find out what causes the very thin described problem since we do not have our crystal ball at hand all the time.

But first of all you always should try to help yourself by searching and reading the thread. I'm almost 100% sure you'll find the solution inside this thread.

Jibala
PDF & BCC (Patience Discipline Focus & Belief Confidence Consistency)
  • #3,387
  • Mar 14, 2017 12:44pm Mar 14, 2017 12:44pm
Quoting JibalaPasan
{quote} I've explained already on original csm and modoki what we are looking for to enter in a counter trade. However, since I did not take any useful pictures this week to explain and show in more detail how it works, I'll try to show next week. Jibala
Ok guys, here we go with a nice example how trading makes sense and should work for all of us.

USDJPY in a long trend. The GAP, look at the pin of the m30 candle, was strong enough for a sell signal.
Attached Image (click to enlarge)
Click to Enlarge Name: Ashampoo_Snap_2017.03.14_08h37m45s_026_.png Size: 75 KB

Attached Image (click to enlarge)
Click to Enlarge Name: Ashampoo_Snap_2017.03.14_08h37m13s_025_.png Size: 304 KB

Attached Image (click to enlarge)
Click to Enlarge Name: Ashampoo_Snap_2017.03.14_08h36m49s_024_.png Size: 163 KB

The GAP HEATMAP clearly shows a rising JPY while the USD is falling. On the CSM USD still remains the top two but on the GAP HEATMAP it was fallen in all TFs from M5 to H4. The result is a nice counter trade with a TP of 6.2 Pip.
Attached Image (click to enlarge)
Click to Enlarge Name: Ashampoo_Snap_2017.03.14_12h26m06s_027_.png Size: 74 KB


Another example CADJPY on M1 chart:
Attached Image (click to enlarge)
Click to Enlarge Name: Ashampoo_Snap_2017.03.14_15h24m02s_031_.png Size: 12 KB

Attached Image (click to enlarge)
Click to Enlarge Name: Ashampoo_Snap_2017.03.14_15h21m37s_030_.png Size: 164 KB

Attached Image (click to enlarge)
Click to Enlarge Name: Ashampoo_Snap_2017.03.14_15h17m55s_029_.png Size: 56 KB

CADJPY was running in a small range of 3 Pip. However, the BOT recognized the small GAP as a sell signal and has opened an order. On the M30 chart we cannot see the range like here on M1 chart.

Our results for the month of March are brilliant again so far.
Attached Image (click to enlarge)
Click to Enlarge Name: Ashampoo_Snap_2017.03.14_17h46m54s_039_.png Size: 158 KB


Wishing you all best of luck and green Pips always.

Jibala
PDF & BCC (Patience Discipline Focus & Belief Confidence Consistency)
  • #3,388
  • Mar 14, 2017 3:16pm Mar 14, 2017 3:16pm
Quoting JibalaPasan
{quote} Ok guys, here we go with a nice example how trading makes sense and should work for all of us. USDJPY in a long trend. The GAP, look at the pin of the m30 candle, was strong enough for a sell signal. {image} {image} {image} The GAP HEATMAP clearly shows a rising JPY while the USD is falling. On the CSM USD still remains the top two but on the GAP HEATMAP it was fallen in all TFs from M5 to H4. The result is a nice counter trade with a TP of 6.2 Pip. {image} Another example CADJPY on M1 chart: {image} {image} {image} CADJPY was...
Thanks Jibala for this explanation
  • #3,389
  • Mar 14, 2017 3:32pm Mar 14, 2017 3:32pm
Does any have a good link to the spaghetti version of a currency strength indicator please nicely??
  • #3,390
  • Mar 14, 2017 3:33pm Mar 14, 2017 3:33pm
Quoting JibalaPasan
{quote} Ok guys, here we go with a nice example how trading makes sense and should work for all of us. USDJPY in a long trend. The GAP, look at the pin of the m30 candle, was strong enough for a sell signal. {image} {image} {image} The GAP HEATMAP clearly shows a rising JPY while the USD is falling. On the CSM USD still remains the top two but on the GAP HEATMAP it was fallen in all TFs from M5 to H4. The result is a nice counter trade with a TP of 6.2 Pip. {image} Another example CADJPY on M1 chart: {image} {image} {image} CADJPY was...

Great tools and results, impressed
  • #3,391
  • Mar 14, 2017 5:36pm Mar 14, 2017 5:36pm
Quote
And finally we come to the "Momentum" of our system. Long term traders do technical stuff to place orders. We don't wanna do that, we have a BOT!

Attached Image (click to enlarge)
Click to Enlarge Name: Ashampoo_Snap_2017_03_11_18h56m14s_020.jpg Size: 138 KB


On the right side of the screen the "Momentum" is indicated. Since it's almost not possible for humans eyes to determine all the changes, the BOT does it pretty well. With every 1/100 of those numbers we see the price of a pair rising or falling. The more green...


Could be good(?) to measure the Momentum with the standard formula:

  1. Choose a predetermined period X (Standard value is 14, although a value of 8 or 9 tends to be more sensitive);
  2. Calculate Close1 as the closing price for the current bar;
  3. Calculate CloseX as the closing price X bars ago;
  4. MOMENTUM = 100 x (Close1/CloseX)

using Accelerator values instead of Close1/CloseX

I'm just thinking out loud

DO UT DES
  • #3,392
  • Mar 14, 2017 5:44pm Mar 14, 2017 5:44pm
Quoting the bourne
{quote} Could be good(?) to measure the Momentum with the standard formula: Choose a predetermined period X (Standard value is 14, although a value of 8 or 9 tends to be more sensitive); Calculate Close1 as the closing price for the current bar; Calculate CloseX as the closing price X bars ago; MOMENTUM = 100 x (Close1/CloseX) using Accelerator values instead of Close1/CloseX I'm just thinking out loud {image}
This logic is good. We cannot get Close from a DDE feed. How can we do tick by tick speed this way? Accounting for spread is a challenge.
  • #3,393
  • Mar 14, 2017 6:45pm Mar 14, 2017 6:45pm
Anyone else having this problem?
'TradeFromExcel2MT4' is not expert and cannot be executed
MT4 ver 4.0 build 1045
  • #3,394
  • Mar 14, 2017 7:53pm Mar 14, 2017 7:53pm
Quoting dlouw
Anyone else having this problem? 'TradeFromExcel2MT4' is not expert and cannot be executed MT4 ver 4.0 build 1045
That's correct, because it is not an indicator and not an ea but a script and it belongs into the script folder.

Jibala
PDF & BCC (Patience Discipline Focus & Belief Confidence Consistency)
  • #3,395
  • Mar 14, 2017 8:18pm Mar 14, 2017 8:18pm
The early bird catches the Pips!

I was late to take a screen of the GAP HEATMAP.
Attached Image (click to enlarge)
Click to Enlarge Name: Ashampoo_Snap_2017.03.14_21h33m09s_042_.png Size: 241 KB

Attached Image (click to enlarge)
Click to Enlarge Name: Ashampoo_Snap_2017.03.15_01h27m06s_045_.png Size: 72 KB


For GBPAUD only the M5 GAP:
Attached Image (click to enlarge)
Click to Enlarge Name: Ashampoo_Snap_2017.03.15_01h10m32s_043_.png Size: 168 KB

Attached Image (click to enlarge)
Click to Enlarge Name: Ashampoo_Snap_2017.03.15_01h11m03s_044_.png Size: 319 KB

Attached Image (click to enlarge)
Click to Enlarge Name: Ashampoo_Snap_2017.03.15_01h37m05s_047_.png Size: 83 KB


Imma now.

Jibala
PDF & BCC (Patience Discipline Focus & Belief Confidence Consistency)
  • #3,396
  • Mar 14, 2017 8:29pm Mar 14, 2017 8:29pm
Quoting JibalaPasan
{quote} That's correct, because it is not an indicator and not an ea but a script and it belongs into the script folder. Jibala
Thanks!
We are getting close to an automated trading. Getting consistent by measuring momentum equalized by a common currency. Apples to apples. I am very appreciative of your help.
  • #3,397
  • Mar 15, 2017 2:30am Mar 15, 2017 2:30am
Quoting JibalaPasan
{quote} Hello brother Aromos. Happy to see it worked for you. Which of the named solutions was helpful? For your next problem we need some more details because it's very hard to find out what causes the very thin described problem since we do not have our crystal ball at hand all the time. But first of all you always should try to help yourself by searching and reading the thread. I'm almost 100% sure you'll find the solution inside this thread. Jibala

Hello Sister Jibala, un-hiding the hidden sheet worked.

I'm going through the thread again to find out why excel orders are not taken by MT4?

Thank you
  • #3,398
  • Mar 15, 2017 9:24am Mar 15, 2017 9:24am
Quoting JibalaPasan
The early bird catches the Pips! I was late to take a screen of the GAP HEATMAP. {image} {image} For GBPAUD only the M5 GAP: {image} {image} {image} Imma now. Jibala
Hey Jibala,

I noticed your MYFXB**K widget shows a 28% draw down you had at some point. Was this acceptable to you? Did it shake confidence in the system?
Remember, Red. Hope is a good thing, maybe the best of things...
  • #3,399
  • Mar 15, 2017 11:39am Mar 15, 2017 11:39am
Quoting JibalaPasan
The early bird catches the Pips! I was late to take a screen of the GAP HEATMAP. {image} {image} For GBPAUD only the M5 GAP: {image} {image} {image} Imma now. Jibala
Hi Jibala ,

thank you for sharing this strategy ... i'm working on modoki pin for EAX Dashboard , until now i'm comparing the top and the bottom to send signal , is there any rules to add ?!

Attached Image (click to enlarge)
Click to Enlarge Name: EAX_PIN_HM_Modoki_v2.00.png Size: 38 KB


Best Regards,
Sam
  • #3,400
  • Mar 15, 2017 2:29pm Mar 15, 2017 2:29pm
I like News collected more than 300 green pips
Attached Image (click to enlarge)
Click to Enlarge Name: topotr.png Size: 116 KB
0 traders viewing now