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

  • #1,021
  • Dec 25, 2015 5:07am Dec 25, 2015 5:07am
Quoting dtlase
Hello friends, I want to thank everyone that has contributed to the success and progress of the work on this thread. I wish everyone Merry Christmas and a Happy New Year. Thanks to PipFlak for starting the thread, JibalaPasan for your amazing contribution, project13et, jarfx05, pipdripper, LFN, emonts, blueface, dariuske, Tobib80, JamesT, Bernhard, FerruFX, dlouw, Miche09, CapeCoddah, ppuruswani, nbelchior, rabbit68, forexdaist, on and on and on................ you guys are wonderful. I wish you all many green pips in 2016. dtlase MERRY CHRISTMAS...
Thanks my friend!! Merry christmas and a happy new year!
  • #1,022
  • Dec 28, 2015 9:33am Dec 28, 2015 9:33am
Today quite a few trades (7) possible! By far the best I want to show here. See how CADCHF has changed within minutes!
Attached Image (click to enlarge)
Click to Enlarge Name: Ashampoo_Snap_2015.12.28_23h06m34s_006_.png Size: 174 KB

Attached Image (click to enlarge)
Click to Enlarge Name: Ashampoo_Snap_2015.12.28_23h09m41s_007_.png Size: 178 KB

Attached Image (click to enlarge)
Click to Enlarge Name: Ashampoo_Snap_2015.12.28_23h11m15s_008_CADCHF-M1.png Size: 46 KB

Attached Image (click to enlarge)
Click to Enlarge Name: Ashampoo_Snap_2015.12.28_23h16m01s_009_.png Size: 13 KB

PDF & BCC (Patience Discipline Focus & Belief Confidence Consistency)
  • #1,023
  • Dec 28, 2015 9:47am Dec 28, 2015 9:47am
And another one:
Attached Image (click to enlarge)
Click to Enlarge Name: Ashampoo_Snap_2015.12.28_23h42m29s_010_.png Size: 179 KB

Attached Image (click to enlarge)
Click to Enlarge Name: Ashampoo_Snap_2015.12.28_23h45m13s_011_EURCAD-M1.png Size: 46 KB
PDF & BCC (Patience Discipline Focus & Belief Confidence Consistency)
  • #1,024
  • Dec 30, 2015 3:29am Dec 30, 2015 3:29am
My choice for today so far:
Attached Image (click to enlarge)
Click to Enlarge Name: Ashampoo_Snap_2015.12.30_16h29m47s_016_.png Size: 171 KB

Attached Image (click to enlarge)
Click to Enlarge Name: Ashampoo_Snap_2015.12.30_16h32m21s_017_GBPCAD-M1.png Size: 45 KB

Attached Image (click to enlarge)
Click to Enlarge Name: Ashampoo_Snap_2015.12.30_16h32m40s_018_USDCAD-M1.png Size: 42 KB

Attached Image (click to enlarge)
Click to Enlarge Name: Ashampoo_Snap_2015.12.30_16h33m01s_019_EURCAD-M1.png Size: 39 KB

Attached Image (click to enlarge)
Click to Enlarge Name: Ashampoo_Snap_2015.12.30_16h35m26s_020_NZDCAD-M1.png Size: 42 KB

Attached Image (click to enlarge)
Click to Enlarge Name: Ashampoo_Snap_2015.12.30_17h10m26s_021_AUDCAD-M1.png Size: 41 KB

PDF & BCC (Patience Discipline Focus & Belief Confidence Consistency)
  • #1,025
  • Dec 30, 2015 4:16am Dec 30, 2015 4:16am
Quoting JibalaPasan
My choice for today so far: {image} {image} {image} {image} {image} {image}
Hi Jibala,

You never rest... I wonder how do you manage this manual trades. Do you stare at front of your PC untill the setup appears? Do you check the Excel only each half an hour? Do you stay 4-7 hours chasing the trades or just check in some hours and high liquidity moments like LO?

Please, please, answer my questions.


.......and happy new year!!

TONI
  • #1,026
  • Dec 30, 2015 5:42am Dec 30, 2015 5:42am
Quoting forexdaist
{quote} Hi Jibala, You never rest... I wonder how do you manage this manual trades. Do you stare at front of your PC untill the setup appears? Do you check the Excel only each half an hour? Do you stay 4-7 hours chasing the trades or just check in some hours and high liquidity moments like LO? Please, please, answer my questions. .......and happy new year!! TONI
I like to be on the internet, doing different things. Mostly I'm reading the news because I'm interested to know what happens in the world. All this I can do on the Laptop. On the big second screen, the Dashboard is running and shows all necessary information about the market. If then I recognize a signal or an interesting constellation I have a closer look. If I am not at the desk, the automatism of the dashboard will do the job.

Happy New Year to you too!
PDF & BCC (Patience Discipline Focus & Belief Confidence Consistency)
  • #1,027
  • Dec 30, 2015 6:01am Dec 30, 2015 6:01am
Quoting JibalaPasan
{quote} I like to be on the internet, doing different things. Mostly I'm reading the news because I'm interested to know what happens in the world. All this I can do on the Laptop. On the big second screen, the Dashboard is running and shows all necessary information about the market. If then I recognize a signal or an interesting constellation I have a closer look. If I am not at the desk, the automatism of the dashboard will do the job. Happy New Year to you too!
Thanks for your answer. I see though you dont get yet the change direction trades, and you pick preferently the momentum in trend direction. So, do you change setup conditions? Toni
  • #1,028
  • Dec 30, 2015 7:40am Dec 30, 2015 7:40am
Quoting forexdaist
{quote} Thanks for your answer. I see though you dont get yet the change direction trades, and you pick preferently the momentum in trend direction. So, do you change setup conditions? Toni
No, I didn't and do not change anything! Never change a running system!

Quoting Udine
Dont trade Frankfurt ..

Start London... increase the probability of winning trades!!

Choose your battles more wisely !!
PDF & BCC (Patience Discipline Focus & Belief Confidence Consistency)
  • #1,029
  • Dec 31, 2015 6:19am Dec 31, 2015 6:19am
Quoting JibalaPasan
{quote} No, I didn't and do not change anything! Never change a running system! {quote}
Today I made an excuse and changed the GAP - Filter to smaller TFs for pure GAP scalping!
Attached Image (click to enlarge)
Click to Enlarge Name: Ashampoo_Snap_2015.12.30_21h29m27s_031_CADCHF-M1.png Size: 45 KB

Attached Image (click to enlarge)
Click to Enlarge Name: Ashampoo_Snap_2015.12.31_17h31m09s_035_EURNZD-M1.png Size: 47 KB

Attached Image (click to enlarge)
Click to Enlarge Name: Ashampoo_Snap_2015.12.31_17h41m55s_036_GBPNZD-M1.png Size: 43 KB

Attached Image (click to enlarge)
Click to Enlarge Name: Ashampoo_Snap_2015.12.31_18h01m03s_038_GBPJPY-M1.png Size: 48 KB

Attached Image (click to enlarge)
Click to Enlarge Name: Ashampoo_Snap_2015.12.31_19h23m33s_042_EURCAD-M1.png Size: 43 KB

Attached Image (click to enlarge)
Click to Enlarge Name: Ashampoo_Snap_2015.12.31_19h29m50s_043_EURGBP-M1.png Size: 45 KB

Attached Image (click to enlarge)
Click to Enlarge Name: Ashampoo_Snap_2015.12.31_19h30m04s_044_EURAUD-M1.png Size: 46 KB

Attached Image (click to enlarge)
Click to Enlarge Name: Ashampoo_Snap_2015.12.31_20h07m25s_045_.png Size: 22 KB

It's party time!

HAPPY NEW YEAR
Attached Image
PDF & BCC (Patience Discipline Focus & Belief Confidence Consistency)
  • #1,030
  • Dec 31, 2015 6:48am Dec 31, 2015 6:48am
Attached Image (click to enlarge)
Click to Enlarge Name: Happy-New-Year.jpg Size: 121 KB
  • #1,031
  • Dec 31, 2015 12:46pm Dec 31, 2015 12:46pm
Quoting JibalaPasan
{quote} Today I made an excuse and changed the GAP - Filter to smaller TFs for pure GAP scalping! {image} {image} {image} {image} {image} {image} {image} {image} It's party time! HAPPY NEW YEAR {image}
Hi Jibala,
What was your initial GAP TF and what is your last GAP TF?
  • #1,032
  • Dec 31, 2015 10:57pm Dec 31, 2015 10:57pm
Quoting htawfik
{quote} hi jibala, what was your initial gap tf and what is your last gap tf?
(1) <= m60 (mtf)
(2) <= m15 (mtf)
PDF & BCC (Patience Discipline Focus & Belief Confidence Consistency)
  • #1,033
  • Jan 1, 2016 8:21am Jan 1, 2016 8:21am
What Excel version runs fine with MT4? I have Excel 2016 and many crosses have wrong values ( USDJPY show120261,00 and similar ). I searched info in this thread but i didnt find how resolve this
Try don't lose pants never...
  • #1,034
  • Jan 1, 2016 8:42am Jan 1, 2016 8:42am
Quoting braintheboss
What Excel version runs fine with MT4? I have Excel 2016 and many crosses have wrong values ( USDJPY show120261,00 and similar ). I searched info in this thread but i didnt find how resolve this
You must refine your search! The solution is in the thread! Mentioned many times already.
PDF & BCC (Patience Discipline Focus & Belief Confidence Consistency)
  • #1,035
  • Jan 1, 2016 8:46am Jan 1, 2016 8:46am
I tried enable Excel transition formula entry, change separator char in windows options,TEXT('MT4'|XXXXXX,"#,##0.00000 ")... I read almost 20 pages of this thread and i didnt find the solution. Sometimes things are not easy to found with big threads...
Try don't lose pants never...
  • #1,036
  • Jan 1, 2016 1:42pm Jan 1, 2016 1:42pm
Quoting braintheboss
I tried enable Excel transition formula entry, change separator char in windows options,TEXT('MT4'|XXXXXX,"#,##0.00000 ")... I read almost 20 pages of this thread and i didnt find the solution. Sometimes things are not easy to found with big threads...
Hi,

Just be patient and watch the speedometer in the rhythm H4..Jibała shows every day...
if you're doing we all have results with all
  • #1,037
  • Jan 1, 2016 9:52pm Jan 1, 2016 9:52pm
Quoting braintheboss
I tried enable Excel transition formula entry, change separator char in windows options,TEXT('MT4'|XXXXXX,"#,##0.00000 ")... I read almost 20 pages of this thread and i didnt find the solution. Sometimes things are not easy to found with big threads...
Did you change it in Excel as well?
Attached Image (click to enlarge)
Click to Enlarge Name: Ashampoo_Snap_2016.01.02_11h47m37s_001_.png Size: 236 KB
PDF & BCC (Patience Discipline Focus & Belief Confidence Consistency)
  • #1,038
  • Jan 1, 2016 11:44pm Jan 1, 2016 11:44pm
Quoting dtlase
I have decided to make this excel open source due to request from friends and also for others to add their input. Also attached is the indicator that create and populate DWM.csv file. The indicator will constantly update the file based on the time frame you have placed it on. On the Speedometer excel I have delayed the update by 5 sec so that the import process should be without error. You need to set-up the path to DWM.csv. 1. C:\Users\xxxxxx\AppData\Roaming\MetaQuotes\Terminal\2010C2441A263399B34F537D91A53AC9\MQL4\Files 2. C:\Users\xxxxxxx\AppData\Roaming\MetaQuotes\Terminal\2010C2441A263399B34F537D91A53AC9\MQL4\Files\DWM.csv...
Hi dtlase,
would you please check the update date for the DWM.CSV on your computer, i noticed that the ExportToExcelTimer is not updating the file anymore so all the results related to GAP calculation is not correct for Ver4

I have MT4 Build 940 and the last updated date for the DWM was on 10th of Nov.

Would you clarify that

Best regards,
  • #1,039
  • Edited 5:42am Jan 2, 2016 4:42am | Edited 5:42am
Quoting JibalaPasan
{quote} Did you change it in Excel as well? {image}
No. I will see. Thanks

PS: With that option better ( strenght28 is parcial fine ). But some spreads showed wrong. Heatmap dont show some data too. But all MT4 data is loaded. :S
Attached Image (click to enlarge)
Click to Enlarge Name: Captura de pantalla (1).png Size: 227 KB
Try don't lose pants never...
  • #1,040
  • Jan 2, 2016 5:46am Jan 2, 2016 5:46am
Quoting htawfik
{quote} Hi dtlase, would you please check the update date for the DWM.CSV on your computer, i noticed that the ExportToExcelTimer is not updating the file anymore so all the results related to GAP calculation is not correct for Ver4 I have MT4 Build 940 and the last updated date for the DWM was on 10th of Nov. Would you clarify that Best regards,


@htawfik
It is working fine. I have ExportToExcelTimer indicator on two systems, one on M1 chat and the other on M5 chat and they update the DWM.CSV file.
1 trader viewing now