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

  • #281
  • Oct 19, 2015 7:37am Oct 19, 2015 7:37am
Quoting Adhipfx
Hi Does anyone can tell me,How can i change "auto update 30M" to 1H? Thanks in advance
"Auto update" sounds like using a macro which can be changed in source code only.
PDF & BCC (Patience Discipline Focus & Belief Confidence Consistency)
  • #282
  • Oct 19, 2015 7:43am Oct 19, 2015 7:43am
Quoting JibalaPasan
{quote} "Auto update" sounds like using a macro which can be changed in source code only.
Thanks Jibala

so that i cannot do by myself,right?
  • #283
  • Oct 19, 2015 7:46am Oct 19, 2015 7:46am
Quoting Adhipfx
{quote} Thanks Jibala so that i cannot do by myself,right?
If you can access the source code and find the procedure, then you can.
PDF & BCC (Patience Discipline Focus & Belief Confidence Consistency)
  • #284
  • Oct 19, 2015 8:50am Oct 19, 2015 8:50am
Quoting JibalaPasan
{quote} If you can access the source code and find the procedure, then you can.
ok Thank you my mentor
  • #285
  • Oct 19, 2015 9:35am Oct 19, 2015 9:35am
PM3+RSI

today took a long time . As always at the end h4 is the largest movement the whole market.
Attached Image (click to enlarge)
Click to Enlarge Name: h4clos.png Size: 47 KB
if you're doing we all have results with all
  • #286
  • Oct 19, 2015 12:40pm Oct 19, 2015 12:40pm
Hi dtlase or Dariuske,
Please, could you provide the VBA Project password of any of the file (Speeddometer V2, V3, V4 or V41)?, I am trying to do a code to take an image screenshot of the GAP_SYNC while I am sleeping and @ work but it is locked.
Regards



Quoting dtlase
{quote} This will do the magic. You need to do some tweaking to export value of your indicator. Use the iCustom function to call your indicator and supply all the necessary inputs. This will loop through and export value for all 28 currency pair. -----iCustom(NULL, 0, "Indi-Name",5, 10, "Arial", 85 , 25, 0 , 0, 0); This is a must have script for anyone that want to export to excel. Bless you all. The script exports values for...... "Symb,DOpen,WOpen,MOpen,PrevD,PrevW,PrevM,dEMA8,dEMA21,wEMA8,wEMA21,mEMA8,mEMA21,m30RSI2,dRSI2,wRSI2,mRSI2" you can...
  • #287
  • Edited 4:21am Oct 20, 2015 3:46am | Edited 4:21am
Hello Traders, how are your studies and development? One thing we analyzed, if there is a GAP then trend in M1 & M5 should be the same direction.

Sample: If GAP is +2.96 (positive GAP) then direction / trend of M1 & M5 chart should be long.
PDF & BCC (Patience Discipline Focus & Belief Confidence Consistency)
  • #288
  • Oct 20, 2015 4:06am Oct 20, 2015 4:06am
Quoting JibalaPasan
Hello Traders, how are your studies and development? One thing we analyzed, if there is a GAP then trend in M1 & M5 should be the same direction. Sample: If GAP is +2.96 (positive GAP) then M1 & M5 direction / trend should be long.
Hi Jibala,

to get this one clear: If i.e. gap measured in the 30 minutes interval (reset gap every 30 minutes) is above / below a certain value (i.e. <> 2.75) then the direction of M1 and M5 should point in the same direction which could be measured by using the multimeter?

Example:
- Gap interval is 30 minutes which means it is resetted every 30 minutes.
- Gap critical value <> 2.75
- Gap value above critical value
- Multimeter M1 and M5 both green
=> Enter long for 4-5 pips.

Or do mean that gap interval M1 and M5 should point in the same direction?

Thanks in advance.
  • #289
  • Oct 20, 2015 4:22am Oct 20, 2015 4:22am
Quoting Sniper1310
{quote} Hi Jibala, to get this one clear: If i.e. gap measured in the 30 minutes interval (reset gap every 30 minutes) is above / below a certain value (i.e. <> 2.75) then the direction of M1 and M5 should point in the same direction which could be measured by using the multimeter? Example: - Gap interval is 30 minutes which means it is resetted every 30 minutes. - Gap critical value <> 2.75 - Gap value above critical value - Multimeter M1 and M5 both green => Enter long for 4-5 pips. Or do mean that gap interval M1 and M5 should point in the same...
I've edited, hope it's more clear now.
PDF & BCC (Patience Discipline Focus & Belief Confidence Consistency)
  • #290
  • Oct 20, 2015 4:24am Oct 20, 2015 4:24am
Quoting JibalaPasan
{quote} I've edited, hope it's more clear now.
Thanks. Now I need to add M1 and M5 in my Multimeter.
  • #291
  • Oct 20, 2015 4:48am Oct 20, 2015 4:48am
Quoting Sniper1310
{quote} Thanks. Now I need to add M1 and M5 in my Multimeter.
Sample CADCHF:
Attached Image

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

Attached Image (click to enlarge)
Click to Enlarge Name: Ashampoo_Snap_2015.10.20_19h40m27s_017_CADCHF-M5.png Size: 48 KB

Attached Image (click to enlarge)
Click to Enlarge Name: Ashampoo_Snap_2015.10.20_19h40m50s_018_CADCHF-M30.png Size: 52 KB

Last BS -2.42, current 0.63, GAP 3.05

That's why I wrote you guys must watch and study how GAP works! After study more improve on development which will lead you to success.

Edit: Sry screen deleted, should not be shown here!
PDF & BCC (Patience Discipline Focus & Belief Confidence Consistency)
  • #292
  • Oct 20, 2015 8:29am Oct 20, 2015 8:29am
Quoting jarfx05
{quote} Hi dtlase, Do you think that the addition of divergence can improve the results? {image} regard
Will look into this..
  • #293
  • Oct 20, 2015 8:34am Oct 20, 2015 8:34am
Quoting JibalaPasan
{quote} Just make your script an indicator or expert which will run continuously on a chart and export all data on specified interval (eg M30)! The generated csv file then can be automatically imported / updated into your excel sheet. Should be not that much difficult, right?
Thanks Jibala. I was doing manual, but now automated.
  • #294
  • Oct 20, 2015 8:38am Oct 20, 2015 8:38am
Quoting JibalaPasan
Hello Traders, how are your studies and development? One thing we analyzed, if there is a GAP then trend in M1 & M5 should be the same direction. Sample: If GAP is +2.96 (positive GAP) then direction / trend of M1 & M5 chart should be long.
Need to follow up with your study. Thanks
  • #295
  • Edited 9:10am Oct 20, 2015 8:58am | Edited 9:10am
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

1 goes into cell C2, and 2 goes into cell C3 of the getValues sheet.

You can adjust to fit your need, all is open.
Attached Image(s) (click to enlarge)
Click to Enlarge Name: SetUpPath2.PNG Size: 63 KB
Click to Enlarge Name: Speedometer+HM1.PNG Size: 69 KB
Attached File(s)
File Type: zip Speedometer_v4c+HeatMap.zip   596 KB | 3,194 downloads
File Type: mq4 ExportToExcelTimer.mq4   13 KB | 2,537 downloads
  • #296
  • Oct 20, 2015 9:24am Oct 20, 2015 9:24am
Quoting JibalaPasan
{quote} That's why I wrote you guys must watch and study how GAP works! After study more improve on development which will lead you to success.
Thank you Jibala. Do I understand correctly that in your example M1 and M5 are down, Gap is up so NO trade?


And a big THANKS to dtlase for your skill and sharing. Open source will be great.

dlouw
  • #297
  • Edited 4:32pm Oct 20, 2015 9:32am | Edited 4:32pm
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...
Jibala

I updated the first page thanks dtlase. Also here is a CJA mtf RSI that I have been experimenting with. Works good for me. I cross a 3 Period and 9 (5 and 14 are a common scalping setting) and use it along with psylevel indicator. Might be of use to someone else. Hope it's ok to post here it's not commercial and is on forex factory site but I can't find the link. Love this system! Almost forgot you have to add however many pairs that you want to use and put a semi colon not a comma between.
Attached File(s)
File Type: ex4 MTF RSI Multi Pair Dashboard.ex4   66 KB | 1,554 downloads
  • #298
  • Oct 20, 2015 10:51am Oct 20, 2015 10:51am
Quoting dtlase
{quote} Will look into this..
Hi dtlase ,

is the place possible order directly from excel and manage ?

regard
if you're doing we all have results with all
  • #299
  • Oct 20, 2015 11:20am Oct 20, 2015 11:20am
Quoting jarfx05
{quote} Hi dtlase , is the place possible order directly from excel and manage ? regard
Hi Jarfx05,
It is very possible to place order directly from excel and manage. Looking at how to make it give accurate signal before giving that a try.
The flexi filter are yet to be accurate.
  • #300
  • Oct 20, 2015 1:23pm Oct 20, 2015 1:23pm
Thank you dtlase...
Regards

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...
1 trader viewing now