MT4 Trading the GAP With Excel | Page 108 | 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,141
  • Edited 12:17pm Jul 12, 2016 10:27am | Edited 12:17pm
The result incl. the night session starting at 01:05 am:
Attached Image

The result starting from LO only:
Attached Image


Edit: +18 Pip to add for AUDUSD & NZDUSD.
PDF & BCC (Patience Discipline Focus & Belief Confidence Consistency)
  • #2,142
  • Jul 12, 2016 4:49pm Jul 12, 2016 4:49pm
My results for Tokyo +3 hours and London +3 hours,pic of the trades and some trade reports
I only trade standard style,go-with-the-currency-strenght

today I've noticed a couple of good Counter trades from my Excel about UJ and CJ,but I'm still working on counter trend module and signals are still in experimental stage ,hence not traded by the EA yet

2016.07.12 03:03 CHFJPY Sell , Bid ratio 0.12% , R Strength -9.00 , BS Ratio -5.61 , Gap -1.63 , AMS 2.86
2016.07.12 03:48 EURNZD Sell , Bid ratio 1.97% , R Strength -8.10 , BS Ratio -5.22 , Gap -2.22 , AMS 3.45
2016.07.12 03:52 GBPCHF Buy , Bid ratio 94.27% , R Strength 8.10 , BS Ratio 5.91 , Gap 1.83 , AMS 3.42
2016.07.12 04:33 EURAUD Sell , Bid ratio 0.23% , R Strength -9.00 , BS Ratio -5.67 , Gap -3.16 , AMS 3.11
2016.07.12 04:41 NZDJPY Buy , Bid ratio 100% , R Strength 9.00 , BS Ratio 6.71 , Gap 3.11 , AMS 4.06
2016.07.12 04:52 GBPUSD Buy , Bid ratio 94.99% , R Strength 8.21 , BS Ratio 4.32 , Gap 2.44 , AMS 3.24
2016.07.12 10:02 NZDUSD Buy , Bid ratio 99.47% , R Strength 9.00 , BS Ratio 6.11 , Gap 0.92 , AMS 3.84
Attached Image (click to enlarge)
Click to Enlarge Name: TOKYO_LONDON_TRADES_2016_07_12.png Size: 29 KB
DO UT DES
  • #2,143
  • Jul 13, 2016 2:39am Jul 13, 2016 2:39am
Yes, yes, yessssssssssssssssss! Just up and what a surprise! My result from last night:
Attached Image (click to enlarge)
Click to Enlarge Name: Ashampoo_Snap_2016.07.13_09h23m52s_039_.png Size: 58 KB

No need to count the Pips one by one here comes the total:
Attached Image

OMG... that's just amazing!

And I also want to show that losing trade because it looks so funny:
Attached Image (click to enlarge)
Click to Enlarge Name: Ashampoo_Snap_2016.07.13_09h36m57s_042_.png Size: 65 KB
PDF & BCC (Patience Discipline Focus & Belief Confidence Consistency)
  • #2,144
  • Jul 13, 2016 2:45am Jul 13, 2016 2:45am
Can one or all of the clever people here please help. Unable to get the action buttons to work in Speedometer v4c.
I believe I have all the correct information and files as follows:
Downloaded Speedometer_v4c ... thanks The Bourne
Enable DDE Server - tick
In my MT4 terminal in C:\Users\xxxxxx\AppData\Roaming\MetaQuotes\Terminal\Numbers-Letters\MQL4\Files\TradeFromExcel2MT4
I have the following - Folder: TradeFromExcel2MT4 - Files: commandfile, commandfile_log, openorders
C:\Users\xxxxxx\AppData\Roaming\MetaQuotes\Terminal\Numbers-Letters\MQL4\Scripts\TradeFromCsvFile ... thanks project13et
Folder: TradeFromCsvFile - Files: TradeFromCsvFile.MQL4 and TradeFromCsvFile.exe
In the Excel Workbook I have in the sheet "getValues": SetUp Path
C:\Users\xxxxxx\AppData\Roaming\MetaQuotes\Terminal\Numbers-Letters\MQL4\Files
C:\Users\xxxxxx\AppData\Roaming\MetaQuotes\Terminal\Numbers-Letters\MQL4\Files\DWM.csv
The DWM.csv file exists in
C:\Users\xxxxxx\AppData\Roaming\MetaQuotes\Terminal\Numbers-Letters\MQL4\Files
In Sheet "Arkusz1" I am unable to get the action buttons (Buy/Sell) to work
When I click on the e.g. "Buy" button a MVB Runtime error 76 Path Not Found occurs.
Click on Debug, and the following is found in the file:
MyPath = "C:\Users\Ola\AppData\Roaming\MetaQuotes\Terminal\3F73F5301A2A2B329CFC8731B09270FD\MQL4\Files\TradeFromExcel2MT4"
It appears that the new path is not automatically updated in the file from the "getValues" sheet.
Any help appreciated.
Thanks
When you are successful perhaps give a thought to others ... Kiva dot org
  • #2,145
  • Jul 13, 2016 3:14am Jul 13, 2016 3:14am
Quoting PayItForward
Can one or all of the clever people here please help. Unable to get the action buttons to work in Speedometer v4c. I believe I have all the correct information and files as follows: Downloaded Speedometer_v4c ... thanks The Bourne Enable DDE Server - tick In my MT4 terminal in C:\Users\xxxxxx\AppData\Roaming\MetaQuotes\Terminal\Numbers-Letters\MQL4\Files\TradeFromExcel2MT4 I have the following - Folder: TradeFromExcel2MT4 - Files: commandfile, commandfile_log, openorders C:\Users\xxxxxx\AppData\Roaming\MetaQuotes\Terminal\Numbers-Letters\MQL4\Scripts\TradeFromCsvFile...
It's relatively clear to see that the path to the expected folder is not correct! Maybe you did a mistake while you typed it. Kindly copy the path directly from the file explorer to Excel!
PDF & BCC (Patience Discipline Focus & Belief Confidence Consistency)
  • #2,146
  • Jul 13, 2016 3:33am Jul 13, 2016 3:33am
where can i get price to open indicators like yours jabila?thanks
  • #2,147
  • Jul 13, 2016 3:44am Jul 13, 2016 3:44am
Quoting JibalaPasan
{quote} It's relatively clear to see that the path to the expected folder is not correct! Maybe you did a mistake while you typed it. Kindly copy the path directly from the file explorer to Excel!
The path I have in the Excel Workbook for the sheet "getValues":
SetUp Path
C:\Users\xxxxxx\AppData\Roaming\Met aQuotes\Terminal\Numbers-Letters\MQL4\Files
C:\Users\xxxxxx\AppData\Roaming\Met aQuotes\Terminal\Numbers-Letters\MQL4\Files\DWM.csv
That was copied using File Explorer and it does not work as I stated.
Please help
Thanks
When you are successful perhaps give a thought to others ... Kiva dot org
  • #2,148
  • Jul 13, 2016 3:48am Jul 13, 2016 3:48am
Quoting hypervash
where can i get price to open indicators like yours jabila?thanks
You easily can find if you just use the search function of the forum!
PDF & BCC (Patience Discipline Focus & Belief Confidence Consistency)
  • #2,149
  • Jul 13, 2016 3:57am Jul 13, 2016 3:57am
Quoting PayItForward
{quote} The path I have in the Excel Workbook for the sheet "getValues": SetUp Path C:\Users\xxxxxx\AppData\Roaming\Met aQuotes\Terminal\Numbers-Letters\MQL4\Files C:\Users\xxxxxx\AppData\Roaming\Met aQuotes\Terminal\Numbers-Letters\MQL4\Files\DWM.csv That was copied using File Explorer and it does not work as I stated. Please help Thanks
Ok, then lets ask the following question: What does the program expects when you press the buy/sell button?

The vba macro gets the values to buy/sell from an Excel sheet, opens a txt-file (commandfile.txt) in a specified folder, writes the values in the txt-file and closes it again.

If it can't find the specified folder, the procedure fails! Easy to understand, right?

Jibala
PDF & BCC (Patience Discipline Focus & Belief Confidence Consistency)
  • #2,150
  • Jul 13, 2016 3:58am Jul 13, 2016 3:58am
Quoting JibalaPasan
{quote} Ok, then lets ask the following question: What does the program expects when you press the buy/sell button? The vba macro gets the values to buy/sell from an Excel sheet, opens a txt-file (commandfile.txt) in a specified folder, writes the values in the txt-file and closes it again. If it can't find the specified folder, the procedure fails! Easy to understand, right? Jibala
Do you have any trades executed during London? The market seams very slow to me, no trades.

Thanks,
By failing to prepare, you are preparing to fail.
  • #2,151
  • Jul 13, 2016 4:06am Jul 13, 2016 4:06am
Quoting project13et
{quote} Do you have any trades executed during London? The market seams very slow to me, no trades. Thanks,
Last order opened NZDCAD @08:17:30 server time. No new orders during LO so far.
PDF & BCC (Patience Discipline Focus & Belief Confidence Consistency)
  • #2,152
  • Jul 13, 2016 4:24am Jul 13, 2016 4:24am
Lot of new features have been added or modify, some stuff that are not used anymore got deleted, so many thinks have been tried over and over to come this far, and now lot's of hours of work just get deleted but we know for sure they are not good .... so I can't wait to see it in auction but it seams the market doesn't want to let it play with new "toys" ...
Attached Image (click to enlarge)
Click to Enlarge Name: Basket.png Size: 61 KB
By failing to prepare, you are preparing to fail.
  • #2,153
  • Jul 13, 2016 4:25am Jul 13, 2016 4:25am
Quoting JibalaPasan
{quote} You easily can find if you just use the search function of the forum!
i did search but i cant find the one like yours..here's what i found
Attached Image
  • #2,154
  • Jul 13, 2016 4:29am Jul 13, 2016 4:29am
Quoting project13et
Lot of new features have been added or modify, some stuff that are not used anymore got deleted, so many thinks have been tried over and over to come this far, and now lot's of hours of work just get deleted but we know for sure they are not good .... so I can't wait to see it in auction but it seams the market doesn't want to let it play with new "toys" ... {image}


I just was wondering who has confirmed the remote session to my computer?
Attached Image (click to enlarge)
Click to Enlarge Name: Ashampoo_Snap_2016.07.13_11h32m46s_045_.png Size: 90 KB
PDF & BCC (Patience Discipline Focus & Belief Confidence Consistency)
  • #2,155
  • Jul 13, 2016 4:57am Jul 13, 2016 4:57am
Quoting JibalaPasan
{quote} I just was wondering who has confirmed the remote session to my computer? {image}
2 trades executed while we was speaking
Attached Image(s) (click to enlarge)
Click to Enlarge Name: AUDUSD.png Size: 58 KB
Click to Enlarge Name: EURJPY.png Size: 65 KB
By failing to prepare, you are preparing to fail.
  • #2,156
  • Jul 13, 2016 5:04am Jul 13, 2016 5:04am
Quoting JibalaPasan
{quote} Ok, then lets ask the following question: What does the program expects when you press the buy/sell button? The vba macro gets the values to buy/sell from an Excel sheet, opens a txt-file (commandfile.txt) in a specified folder, writes the values in the txt-file and closes it again. If it can't find the specified folder, the procedure fails! Easy to understand, right? Jibala
...... And the only sheet where the user defines a path is getValues
And the path set there, by instructions, is either:
C:\Users\xxxxxx\AppData\Roaming\MetaQuotes\Terminal\Numbers-Letters\MQL4\Files
OR
C:\Users\xxxxxx\AppData\Roaming\MetaQuotes\Terminal\Numbers-Letters\MQL4\Files\DWM.csv
BUT the commandfile.txt does not reside in either of those paths, so what is the Excel sheet name where the input:
C:\Users\xxxxxx\AppData\Roaming\MetaQuotes\Terminal\Numbers-Letters\MQL4\Files\TradeFromExcel2MT4
is made?

Hopefully ... here endith your lesson
When you are successful perhaps give a thought to others ... Kiva dot org
  • #2,157
  • Jul 13, 2016 6:17am Jul 13, 2016 6:17am
Quoting PayItForward
{quote} ...... And the only sheet where the user defines a path is getValues And the path set there, by instructions, is either: C:\Users\xxxxxx\AppData\Roaming\MetaQuotes\Terminal\Numbers-Letters\MQL4\Files OR C:\Users\xxxxxx\AppData\Roaming\MetaQuotes\Terminal\Numbers-Letters\MQL4\Files\DWM.csv BUT the commandfile.txt does not reside in either of those paths, so what is the Excel sheet name where the input: C:\Users\xxxxxx\AppData\Roaming\MetaQuotes\Terminal\Numbers-Letters\MQL4\Files\TradeFromExcel2MT4 is made? Hopefully ... here...
Okay, got it! After we've changed the path inside the vba source code directly it works. I can't tell you why it doesn't accept the values from the input sheet and I am not in the mood for a Sherlock Holmes hence, kindly ask the developer or change it like we did directly in the vba source code.

Jibala
PDF & BCC (Patience Discipline Focus & Belief Confidence Consistency)
  • #2,158
  • Jul 13, 2016 7:39am Jul 13, 2016 7:39am
Quoting JibalaPasan
{quote} Okay, got it! After we've changed the path inside the vba source code directly it works. I can't tell you why it doesn't accept the values from the input sheet and I am not in the mood for a Sherlock Holmes hence, kindly ask the developer or change it like we did directly in the vba source code. Jibala
Already sent PMs to the developer with no response.
So clearly, as it does not work as expected and as I don't know VBA, and I guess I am not the only reader of this thread that does not know VBA, then that explains why there are only a few people who can contribute here.

Thanks for your obviously very valuable time Jibala - green pips to you.

I know there are at least two other clever people here, the bourne and project13et, who have this working and who have given their time before by providing assistance in the past, maybe they can spare a few minutes to help ... if so it would be greatly appreciated.
When you are successful perhaps give a thought to others ... Kiva dot org
  • #2,159
  • Jul 13, 2016 8:00am Jul 13, 2016 8:00am
Quoting PayItForward
{quote} Already sent PMs to the developer with no response. So clearly, as it does not work as expected and as I don't know VBA, and I guess I am not the only reader of this thread that does not know VBA, then that explains why there are only a few people who can contribute here. Thanks for your obviously very valuable time Jibala - green pips to you. I know there are at least two other clever people here, the bourne and project13et, who have this working and who have given their time before by providing assistance in the past, maybe they can...
Ok guys, you know I am always willing to help if I can. Open your speedometer file and activate the macros. In the menu bar of your excel chose developer tools => macros. Select Button_Actions and klick modify. You will find the red marked parameter 6 times in the source code. Change it to the folder of your choice which must be the same as specified in the GetValues sheet.
Attached Image (click to enlarge)
Click to Enlarge Name: Ashampoo_Snap_2016.07.13_14h45m56s_047_.png Size: 77 KB

Good luck!
PDF & BCC (Patience Discipline Focus & Belief Confidence Consistency)
  • #2,160
  • Jul 13, 2016 9:38am Jul 13, 2016 9:38am
Quoting PayItForward
{quote}I don't know VBA, and I guess I am not the only reader of this thread that does not know VBA, then that explains why there are only a few people who can contribute here.
This is for sure a hard thread to follow and a difficult system to learn. Not only because one have to know Excel, VBA, mql coding and so on but also (mainly) because all the info is in so many different posts and even in several different threads, doc, pdf's and so on. Would be far easyer for someone that was there from the very beginning but very hard and difficult to try catching up at this point.
Even the thread starter have stop posting for some reason. Maybe given up? I don't know but i have been reading and studying this for many many days and weeks now and i am starting to see that i probably have to give up, and that have not happen many times all this years around different trading forums. I mean given up before even getting to the point of testing the idea/system if i really wanted to test it and all the info needed was there. (Like it supposed to be here..)
I am an "old" man and to memorize and sort out all this info from all the hundreds and hundreds of posts and then in the end put all of that in to use is probably to much for me. And on top of that i should also learn a couple of programming languages. Hard enough even to learn all of this in English when that is not my language.

I know it sounds like i am complaining here but i am not. Just trying to describe my situation. Probably many many others are in similar situation and like PayItForward say that may explain why only a few people contribute here.
I am really thankful for all the work and sharing that is done here. I really am! Thank you all!

In the first page of this thread the thread starter suggest something that sounds like a good idea for new readers to start from:
Quoting PipFlak
I think the first thing we need to do is create a 'GAP Trading for Dummies' pdf. I am one of the dummies who don't really know how to use this spreadsheet yet. If we could start with the basic setup in excel and how to test if it is working correctly that would be nice.
Friendly regards
Arctic4x
3 traders viewing now