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

  • #881
  • Dec 11, 2015 11:00am Dec 11, 2015 11:00am
think of a jigsaw puzzle where you don't have all the pieces or you may have only 65% of the full image . Amen
Quoting pipdripper
{quote} This would probably the most popular screenshot you posted which obviously gave more thought to the fact that RSI was fully part of the criteria your dashboard looked before taking a trade - and if I get you right at this moment, you are saying that it was basically an experiment and mostly for visual purposes, am I right? Give and take, I believe that everyone might have to be think for themselves and pull various pieces together to get something they would understand and be comfortable trading with. Thanks.
  • #882
  • Edited 11:52am Dec 11, 2015 11:41am | Edited 11:52am
Hello friends,
How is trading going? I have been away for a while because of work. I have some catching up to do on the thread and PM's. I will like to say that fixing of bugs and new features on the dashboard will resume next year by God's grace.



Quoting jarfx05
Hi dtlase , is it possible to make buy-sell button to excel... regards

I have Christmas gift for all excel lovers.
You can place your trade in your excel now.(MANUAL no AUTO yet).
Place the TradeFromExcel2MT4.ex4 in the script folder and attach to your MT4 chat that is all.
Open your excel and start to trade. You can close order by selecting from the open order in the OpenOrder sheet.
Select any comment of the trade you want to close, it will prompt you if you want to close the trade. Choose yes/no.
You can manually pull open trade from MT4. It also pull open trade when your GAP update is done automatically.
Set your Lot size in the cell.
Thanks to Paul's blog http://paulsfxrandomwalk.blogspot.nl...atrader-4.html
The Excel and the script file is open source, hope some good vba programmer can contribute and we can make excel another platform for trading.
Merry Christmas and happy new year in advance. And many green pips in 2016.

dtlase
Attached Image(s) (click to enlarge)
Click to Enlarge Name: ExcelWithButton1.PNG Size: 121 KB
Click to Enlarge Name: ExcelWithButton4.PNG Size: 68 KB
Attached Images
Attached File(s)
File Type: zip TradeFromExcel2MT4.zip   544 KB | 2,855 downloads
  • #883
  • Dec 11, 2015 12:08pm Dec 11, 2015 12:08pm
Greetings Thread

If there is anyone who has experienced with resolve could give me guidance to solving this issue with the excel spreadsheet "speedometer". I previously had issues with RunTime error "76" set up path. Issue fixed

New issue....... I am getting a RunTime error "9" SCRIPT OUT OF RANGE

After Debug I got the following (see highlight below) DOES ANYONE HAVE A QUICK FIX SUGGESTION?

ChDir "" + Cells.Item(2, "C") + ""
Workbooks.Open Filename:="" + Cells.Item(3, "C") + ""
Range("A1:CZ29").Select
Selection.Copy
'Windows("" + Cells.Item(4, "C") + "").Activate
Windows("Speedometer_v4c.xlsm").Activate
Range("A6").Select
Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks _
:=False, Transpose:=False
Windows("DWM.csv").Activate
Application.CutCopyMode = False
ActiveWindow.Close
Range("A6").Select
End Sub

Attached Image (click to enlarge)
Click to Enlarge Name: screen shot.png Size: 161 KB
  • #884
  • Dec 11, 2015 12:13pm Dec 11, 2015 12:13pm
Quoting Mooz
Greetings Thread If there is anyone who has experienced with resolve could give me guidance to solving this issue with the excel spreadsheet "speedometer". I previously had issues with RunTime error "76" set up path. Issue fixed New issue....... I am getting a RunTime error "9" after debugged I got the following (see highlight below) DOES ANYONE HAVE A QUICK FIX SUGGESTION? ChDir "" + Cells.Item(2, "C") + "" Workbooks.Open Filename:="" + Cells.Item(3, "C") + "" Range("A1:CZ29").Select Selection.Copy 'Windows("" + Cells.Item(4, "C") + "").Activate...
Have you change the name of your file? If you have for example "Speedometer_v4ddd.xlsm", you will have to change the file name in the line of code highlighted.

Also when a new file is posted everybody should endeavour to change to their MT4 Path.
Attached Image (click to enlarge)
Click to Enlarge Name: ExcelWithButton5.PNG Size: 8 KB
  • #885
  • Dec 11, 2015 12:44pm Dec 11, 2015 12:44pm
Quoting dtlase
Hello friends, How is trading going? I have been away for a while because of work. I have some catching up to do on the thread and PM's. I will like to say that fixing of bugs and new features on the dashboard will resume next year by God's grace. {quote} I have Christmas gift for all excel lovers. You can place your trade in your excel now.(MANUAL no AUTO yet). Place the TradeFromExcel2MT4.ex4 in the script folder and attach to your MT4 chat that is all. Open your excel and start to trade. You can close order by selecting from the open order...

Hi dtlase ,

today we have Christmas? Many thanks for all you do !!! I think that I 've done everything as it should be but it is a mistake . What do I do next ?

Attached Image (click to enlarge)
Click to Enlarge Name: mmini.png Size: 31 KB
Regards
if you're doing we all have results with all
  • #886
  • Dec 11, 2015 1:00pm Dec 11, 2015 1:00pm
Quoting dtlase
{quote} Have you change the name of your file? If you have for example "Speedometer_v4ddd.xlsm", you will have to change the file name in the line of code highlighted. Also when a new file is posted everybody should endeavour to change to their MT4 Path. {image}
Hi Dtlase,

First of all I wanted to Thank You, Jibala, Pip Flak,CapeCoddah, Dariuske, "God Farther" George (GVC) creator of The DashBoard and Team Many Blessings

Yes, I have changed file name
SetUp Path
C:\Users\Starr Brand LLC\AppData\Roaming\MetaQuotes\Terminal\7F3EF561E42815388D4A6200AA5AE4FD\MQL4\Files
C:\Users\Starr Brand LLC\AppData\Roaming\MetaQuotes\Terminal\7F3EF561E42815388D4A6200AA5AE4FD\MQL4\Files\DWM.csv

So I guess I have to change in code ("Speedometer_v4c.xlsm") to StarrBrandLLC for fix? Simple enough
Thx
  • #887
  • Dec 11, 2015 1:09pm Dec 11, 2015 1:09pm
Quoting dtlase
Hello friends, How is trading going? I have been away for a while because of work. I have some catching up to do on the thread and PM's. I will like to say that fixing of bugs and new features on the dashboard will resume next year by God's grace. {quote} I have Christmas gift for all excel lovers. You can place your trade in your excel now.(MANUAL no AUTO yet). Place the TradeFromExcel2MT4.ex4 in the script folder and attach to your MT4 chat that is all. Open your excel and start to trade. You can close order by selecting from the open order...

Thank you for the script, I was working all day to make the GAP calculation automatic ,BR for pairs, and to execution of orders. Thank you very much you made my work much much easier.

Thanks @JibalaPasan & @nasap for inspiration and trade examples, after I calculate proper the GAP, i found GAP such an amazing indicator lag free similar to ADR.
For non native English speakers is harder to understand some time

P.S values are not proper highlight yet, was just half done
Attached Image (click to enlarge)
Click to Enlarge Name: 1.png Size: 271 KB
By failing to prepare, you are preparing to fail.
  • #888
  • Edited 1:53pm Dec 11, 2015 1:38pm | Edited 1:53pm
Quoting jarfx05
{quote} Hi dtlase , today we have Christmas? Many thanks for all you do !!! I think that I 've done everything as it should be but it is a mistake . What do I do next ? {image}Regards
@jarfx05
Sorry it is my fault, I should have make it more easier. You should have something like this
MyPath = "C:\Users\macmini\AppData\Roaming\MetaQuotes\Terminal\2010C2441A263399B34F537D91A53AC9\MQL4\Files\TradeFromExcel2MT4"


If you have your path correct, TradeFromExcel2MT4 folder will be created in MT4 file folder. I didn't want to go into that blablabla technical details.
  • #889
  • Dec 11, 2015 1:47pm Dec 11, 2015 1:47pm
Quoting Mooz
{quote} Hi Dtlase, First of all I wanted to Thank You, Jibala, Pip Flak,CapeCoddah, Dariuske, "God Farther" George (GVC) creator of The DashBoard and Team Many Blessings Yes, I have changed file name SetUp Path C:\Users\Starr Brand LLC\AppData\Roaming\MetaQuotes\Terminal\7F3EF561E42815388D4A6200AA5AE4FD\MQL4\Files C:\Users\Starr Brand LLC\AppData\Roaming\MetaQuotes\Terminal\7F3EF561E42815388D4A6200AA5AE4FD\MQL4\Files\DWM.csv So I guess I have to change in code ("Speedometer_v4c.xlsm") to StarrBrandLLC for fix? Simple enough Thx

@Mooz
If your file name is Speedometer_v4c.xlsm then that is correct.
The work around is to copy the path and put in the code directly like this


ChDir "C:\Users\Starr Brand LLC\AppData\Roaming\MetaQuotes\Terminal\7F3EF561E42815388D4A6200AA5AE4FD\MQL4\Files"
Workbooks.Open Filename:="C:\Users\Starr Brand LLC\AppData\Roaming\MetaQuotes\Terminal\7F3EF561E42815388D4A6200AA5AE4FD\MQL4\Files\DWM.csv "
Range("A1:CZ29").Select
Selection.Copy
'Windows("" + Cells.Item(4, "C") + "").Activate
Windows("Speedometer_v4c.xlsm").Activate
Range("A6").Select
Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks _
:=False, Transpose:=False
Windows("DWM.csv").Activate
Application.CutCopyMode = False
ActiveWindow.Close
Range("A6").Select
End Sub
  • #890
  • Dec 11, 2015 1:59pm Dec 11, 2015 1:59pm
Quoting project13et
{quote} Thank you for the script, I was working all day to make the GAP calculation automatic ,BR for pairs, and to execution of orders. Thank you very much you made my work much much easier. Thanks @JibalaPasan & @nasap for inspiration and trade examples, after I calculate proper the GAP, i found GAP such an amazing indicator lag free similar to ADR. For non native English speakers is harder to understand some time P.S values are not proper highlight yet, was just half done {image}

@project13et
Hope you will share the auto when you are through.
  • #891
  • Dec 11, 2015 2:45pm Dec 11, 2015 2:45pm
Quoting dtlase
{quote} @project13et Hope you will share the auto when you are through.
sorry its late and Friday. I do not understand were in the table I must change a line to my mt4 directory?
Scan all 28 Forex pairs with ONE chart... Currency Strength28 Indicators
  • #892
  • Dec 11, 2015 2:55pm Dec 11, 2015 2:55pm
my error
Attached Image (click to enlarge)
Click to Enlarge Name: 2015-12-11_21-55-07.jpg Size: 69 KB
  • #893
  • Dec 11, 2015 3:17pm Dec 11, 2015 3:17pm
Quoting dtlase
{quote} @project13et Hope you will share the auto when you are through.

Hi dtlase- thanks for sharing the Excel- i am able to open the order from excel but getting this error also after click on buy or sell tap on excel-
Attached File(s)
File Type: docx Excelerror.docx   83 KB | 554 downloads
  • #894
  • Dec 11, 2015 7:27pm Dec 11, 2015 7:27pm
Quoting ppuruswani
{quote} Hi dtlase- thanks for sharing the Excel- i am able to open the order from excel but getting this error also after click on buy or sell tap on excel- {file}
look rootDir
if you're doing we all have results with all
  • #895
  • Dec 11, 2015 9:36pm Dec 11, 2015 9:36pm
Quoting ppuruswani
{quote} Hi dtlase- thanks for sharing the Excel- i am able to open the order from excel but getting this error also after click on buy or sell tap on excel- {file}

@ppuruswani

Change to your own Path.
rootDir = "C:\Users\xxxxxxxx\AppData\Roaming\MetaQuotes\Terminal\xxxxxxxx1A263399B34F537D91Axxx\MQL4\Files\TradeFromExcel2MT4"
  • #896
  • Dec 11, 2015 10:03pm Dec 11, 2015 10:03pm
Quoting Test12
my error {image}


@Test12
Technically commandfile.txt is the csv file created when you click buy, sell, close button. This pass the strings for example "OrderSend,AUDUSD,OP_BUY,1,Ask,5,0,0,Order1,9999,0,Orange".
TradeFromExcel2MT4.ex4 script in MT4 Reads the commandfile.txt in your MT4 file folder.
If this go smoothly the commandfile.txt is deleted and created when new order is made.

So your error occur because you placed an order when another has not finish executing.
Trapping errors like this comes in future update. This version is for people to have something to work with and to lay
foundation for great coders to work with.

dtlase
  • #897
  • Dec 11, 2015 10:23pm Dec 11, 2015 10:23pm
Remember use Trade Managers like APTM or MPTM to manage your trade.
  • #898
  • Dec 11, 2015 11:41pm Dec 11, 2015 11:41pm
Quoting dtlase
{quote} @ppuruswani Change to your own Path. rootDir = "C:\Users\xxxxxxxx\AppData\Roaming\MetaQuotes\Terminal\xxxxxxxx1A263399B34F537D91Axxx\MQL4\Files\TradeFromExcel2MT4"

Thank you Masters dtlase and jarfx05 - i will check on Monday and update-
  • #899
  • Dec 12, 2015 4:10am Dec 12, 2015 4:10am
Quoting dtlase
Hello friends, How is trading going? I have been away for a while because of work. I have some catching up to do on the thread and PM's. I will like to say that fixing of bugs and new features on the dashboard will resume next year by God's grace. {quote} I have Christmas gift for all excel lovers. You can place your trade in your excel now.(MANUAL no AUTO yet). Place the TradeFromExcel2MT4.ex4 in the script folder and attach to your MT4 chat that is all. Open your excel and start to trade. You can close order by selecting from the open order...
Hi dtlase,

Thanks once again for a marvellous update.

Given the quality of your updates, we can only expect greater things for the New Year in your dashboard.

Merry Christmas and Happy New Year in advance.

Stay blessed!
  • #900
  • Dec 12, 2015 10:23am Dec 12, 2015 10:23am
Quoting dtlase
Hello friends, How is trading going? I have been away for a while because of work. I have some catching up to do on the thread and PM's. I will like to say that fixing of bugs and new features on the dashboard will resume next year by God's grace. {quote} I have Christmas gift for all excel lovers. You can place your trade in your excel now.(MANUAL no AUTO yet). Place the TradeFromExcel2MT4.ex4 in the script folder and attach to your MT4 chat that is all. Open your excel and start to trade. You can close order by selecting from the open order...
Great thanks for all your efforts!

Stay positive, Multimillion
"All will be correctly, in this world is built" - The Master and Margarita
0 traders viewing now