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

  • #341
  • Edited 11:13pm Oct 21, 2015 11:00pm | Edited 11:13pm
FELLOW TRADERS

Would some body please point me in the rite direction,I have bean searching this GREAT thread all day but cant find any detailed information on how to set up trading on the EXCEL GAP TRADING SPREAD SHEET,there lots of information for once you are set up and tweaking your system, BUT VERY LITTLE FOR THE FIRST STEP BASICS on getting connected to the spread sheet and connecting it to the platform.

PLEASE HELP,
THANKS IN ADVANCE,
GW

Please excuse my stupidity if I have missed all this some how.
IMPROVISE ADAPT OVERCOME
  • #342
  • Oct 21, 2015 11:55pm Oct 21, 2015 11:55pm
Quoting ghost walker
FELLOW TRADERS Would some body please point me in the rite direction,I have bean searching this GREAT thread all day but cant find any detailed information on how to set up trading on the EXCEL GAP TRADING SPREAD SHEET,there lots of information for once you are set up and tweaking your system, BUT VERY LITTLE FOR THE FIRST STEP BASICS on getting connected to the spread sheet and connecting it to the platform. PLEASE HELP, THANKS IN ADVANCE, GW Please excuse my stupidity if I have missed all this some how.

Ghost,

Look here. For some help.

http://www.forexfactory.com/showthre...18#post8549718

and kind suggesti. Make sure you read and re-read each post and refer to any other posts in other threads that might be mentioned.

And remember we all are learning
  • #343
  • Edited 2:48pm Oct 22, 2015 12:10am | Edited 2:48pm
Quoting CapeCoddah
Here is the first release of the revisions to the Power Meter V3 that PipFlak and I discussed several pages earlier. This version does not implement any of those changes yet but is intended to rearrange the information presentation in anticipation of incorporating several of the suggested modifications. The format of the screen has been revised to move the Currency Strength display and Modoki Heat Map to the bottom of the display. The placement of these two displays as well as the Basket Buttons are now user specified. The first box is a countdown...
CapeCoddah

Could this indicator or something like it be implemented to indicate whether last bar is too long/strong? It would save having to go to the chart to check. I wonder if the multiplier was tied to market strength if that would make it a flexi filter? Or should it be tied to some other strength like CRS? Maybe someone more knowledgeable than me knows. We really need something.
RSI would be good too like powermeter 3 RSI2
Just thinking out loud.
Attached File(s)
File Type: mq4 AverageBarRangeRH.mq4   4 KB | 947 downloads
  • #344
  • Oct 22, 2015 12:18am Oct 22, 2015 12:18am
Quoting jarfx05
{quote} Hi, yes, Gap and HM H4 / D1 TP=8 SL=35
Hi Jarfx,

Great trading!
GAP - What number did you set consider as long / short? example 2.0/-2.0? 1.7/-1.7? Consider any interval like 30m? consider any sync of pairs? Gap from excel sheet or from DB? If excel sheet from gap test or gap sync or speedometer page?
HM H4/D1 - What and how exactly are you looking at on this criteria? entry only the top and bottom currency pair? or only long the top currency and short the bottom currency?
Entry - Market price entry or pending order? You enter from the chart or only on DB click buy/sell without looking at the chart? Entry once you see GAP match with Heat map criteria?


Thanks!

Alpe
  • #345
  • Oct 22, 2015 12:51am Oct 22, 2015 12:51am
Quoting jarfx05
{quote} Hi, yes, Gap and HM H4 / D1 TP=8 SL=35

jarfx, do you still maintain "Gap level to open Buy/Sell" at +1.5 and -1.5?
  • #346
  • Oct 22, 2015 12:53am Oct 22, 2015 12:53am
Quoting dtlase
{quote} What is the error?
can you send me complete file and update procedure .
  • #347
  • Oct 22, 2015 6:12am Oct 22, 2015 6:12am
Quoting jamesT.
Manual Trading from NY open + 2 till now with Excel GAP + HeatMapH4 Signal. Entry, if both arrows are green or red. {image}
Good results! I'm trying to trade the GAP, at the moment with discrete good results.

May you please explain a bit more your way of trade? I don't know if I understood well. You check GAP in DB, and when its up some level (I guess 1.7 or so....) you entry if arrows are both in the same direction. Am I right?


thank you in advance and many many green pips!
TONI
  • #348
  • Edited 6:27am Oct 22, 2015 6:15am | Edited 6:27am
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...
in the quote above, what dose it mean to set up the path to dwm.csv , and how do you do this.
gw
IMPROVISE ADAPT OVERCOME
  • #349
  • Oct 22, 2015 7:45am Oct 22, 2015 7:45am
Quoting forexdaist
{quote} Good results! I'm trying to trade the GAP, at the moment with discrete good results. May you please explain a bit more your way of trade? I don't know if I understood well. You check GAP in DB, and when its up some level (I guess 1.7 or so....) you entry if arrows are both in the same direction. Am I right? thank you in advance and many many green pips! TONI

You're right, but I'am always testing this method. I have all said, there ist nothing to explain more. Now I must wait for more positive test results.
This morning was a bad day to test this method, because of ECB Minimum Bid Rate.
  • #350
  • Oct 22, 2015 8:39am Oct 22, 2015 8:39am
Quoting jamesT.
{quote} You're right, but I'am always testing this method. I have all said, there ist nothing to explain more. Now I must wait for more positive test results. This morning was a bad day to test this method, because of ECB Minimum Bid Rate.
Ok. I traded today since LO (some hours before news) and got it some good results, but still testing several things with the strategy.

I have one more doubt. Is this GAP ratio of PowerMeter V3 + RSI2 DB update any time or just rolling all time long? As Jibala recommended to update each 30 minutes I guess it'll be the best for capture momentum pips.


thank you again
TONI
  • #351
  • Oct 22, 2015 9:23am Oct 22, 2015 9:23am
Hi all,

i tested today set file for PM3 . only manually. The signals must be compatible with Excel . If you would like Always test and write what can be improved .

Regards

Attached File(s)
File Type: zip signal.zip   < 1 KB | 1,535 downloads

Attached Image (click to enlarge)
Click to Enlarge Name: setfi.png Size: 112 KB
if you're doing we all have results with all
  • #352
  • Oct 22, 2015 9:43am Oct 22, 2015 9:43am
Quoting jarfx05
Hi all, i tested today set file for PM3 . only manually. The signals must be compatible with Excel . If you would like Always test and write what can be improved . Regards {file} {image}
Very good trading result. Thanks for the set file.
  • #353
  • Oct 22, 2015 10:25am Oct 22, 2015 10:25am
Quoting jamesT.
{quote} Very good trading result. Thanks for the set file.
hi,

det file is a strong market . I think that the market of weak have to go down to the H4 , HM = 28 , GAP = + - 1.2
if you're doing we all have results with all
  • #354
  • Oct 22, 2015 10:58am Oct 22, 2015 10:58am
Quoting jarfx05
Hi dtlase , good trade is a good concentration , you can make tables for place order and manage ? Please.... Thanks a lot
Will look at that.
  • #355
  • Oct 22, 2015 11:02am Oct 22, 2015 11:02am
Quoting stefanie
{quote} can you send me complete file and update procedure .
Everything you need is here. Some more information can be found in "Dashboard thread".
  • #356
  • Oct 22, 2015 11:12am Oct 22, 2015 11:12am
Quoting ghost walker
{quote} in the quote above, what dose it mean to set up the path to dwm.csv , and how do you do this. gw
The ExportToExcelTimer create DWM.csv into your MT4 file folder. Go to your MT4 file menu click on Open Data Folder.
Open The MQL4 folder=>File folder=>DWM.csv
Copy out this path and follow the instruction in post #295
http://www.forexfactory.com/showthre...18#post8549718

Hope that helps.
  • #357
  • Oct 22, 2015 11:15am Oct 22, 2015 11:15am
Quoting jarfx05
Hi all, i tested today set file for PM3 . only manually. The signals must be compatible with Excel . If you would like Always test and write what can be improved . Regards {file} {image}
Great and thanks for the analyse
  • #358
  • Oct 22, 2015 12:29pm Oct 22, 2015 12:29pm
Quoting jamesT.
{quote} You're right, but I'am always testing this method. I have all said, there ist nothing to explain more. Now I must wait for more positive test results. This morning was a bad day to test this method, because of ECB Minimum Bid Rate.
@James
I saw your updated version with Arrows. This is great idea, but you need to allow for update or your data feed will not be correct.
  • #359
  • Oct 22, 2015 1:33pm Oct 22, 2015 1:33pm
I love to excel,,,,,

Attached Image (click to enlarge)
Click to Enlarge Name: ke.png Size: 161 KB
if you're doing we all have results with all
  • #360
  • Oct 22, 2015 1:45pm Oct 22, 2015 1:45pm
Hi dtlase,

where can i find information on how to fit tables for inedex?

F40,AUS200,US30,US500,JP225,UK100,STOXX50,IT40,DE30...etc

REGARDS

Attached Image (click to enlarge)
Click to Enlarge Name: ke.png Size: 119 KB
if you're doing we all have results with all
1 trader viewing now