• Home
  • Forums
  • Trades
  • News
  • Calendar
  • Market
  • Brokers
  • Login
  • Join
  • User/Email: Password:
  • 12:25pm
Menu
  • Forums
  • Trades
  • News
  • Calendar
  • Market
  • Brokers
  • Login
  • Join
  • 12:25pm
Sister Sites
  • Metals Mine
  • Energy EXCH
  • Crypto Craft

Options

Bookmark Thread

First Page First Unread Last Page Last Post

Printable Version

Similar Threads

MT4 to Excel through Excel RTD (Finally!) 420 replies

How to copy profiles in MT4? How to use Excel with MT4? 7 replies

MetaTrader and Excel using DDE 8 replies

Using Excel data and building platform 2 replies

Looking for Help with using Excel and MetaTrader 4 5 replies

  • Platform Tech
  • /
  • Reply to Thread
  • Subscribe
  • 1
Attachments: Trading using Excel and MT4?
Exit Attachments

Trading using Excel and MT4?

  • Last Post
  •  
  • Page 1 2
  • Page 1 2
  •  
  • Post #1
  • Quote
  • First Post: Jun 17, 2010 8:18pm Jun 17, 2010 8:18pm
  •  alex198555
  • | Joined Apr 2010 | Status: Member | 85 Posts
Hi, everyone! I am interested if I can trade from Excel. Let's say that I have some orders written in Excel file and I want that MT4 read them and execute them. Is it possible?

Can I stored the Excel file on some FTP server and make MT4 read and execute them?
  • Post #2
  • Quote
  • Jun 17, 2010 8:39pm Jun 17, 2010 8:39pm
  •  Ronald Raygun
  • Joined Jul 2007 | Status: 28 y/o Investor/Trader/Programmer | 5,016 Posts
Why use an FTP server?

Just have the master excel file make slave excel files in the experts/files folder and have the EA read the slave excel files
  • Post #3
  • Quote
  • Jun 17, 2010 8:45pm Jun 17, 2010 8:45pm
  •  alex198555
  • | Joined Apr 2010 | Status: Member | 85 Posts
Well, because I am working on some project. Basically, my IT professor is interested in Forex as well. I would like to store the file on FTP server, so many people can use it. Later on, I would like to create an EA that actually reads and executes trades from that Excel file.

But, I didn't get the idea how I can read and execute trades from Excel?! This is my first point. Can you help me? Or provide some sample for this?
  • Post #4
  • Quote
  • Nov 18, 2010 12:48pm Nov 18, 2010 12:48pm
  •  alex198555
  • | Joined Apr 2010 | Status: Member | 85 Posts
How can I make a connection between MT4 and Excel? If I enter a trade it Excel, MT4 execute the trade?
  • Post #5
  • Quote
  • Nov 18, 2010 4:51pm Nov 18, 2010 4:51pm
  •  7bit
  • Joined Mar 2009 | Status: Member | 1,231 Posts
Quoting alex198555
Disliked
Basically, my IT professor is interested in Forex
Ignored
If he is an IT professor he will not use Excel.
  • Post #6
  • Quote
  • Nov 19, 2010 12:05pm Nov 19, 2010 12:05pm
  •  One day!
  • Joined Jul 2009 | Status: ...or there about! | 220 Posts
Quoting alex198555
Disliked
How can I make a connection between MT4 and Excel? If I enter a trade it Excel, MT4 execute the trade?
Ignored
This is something that I too am interested in but do not know where to start. I have developed an Excel journal to calculate my position size and record my trades, stat's etc. However, as I don't know how to integrate Excel and MT4 I have to prepare orders in two stages; Firstly, calculate the position size etc in Excel, then secondly, input the details in MT4. What I would like to be able to do is code a send procedure to send the trade details to MT4 and have it open a trade, then for MT4 to report back to Excel when the trade is opened and closed. I would also like to send the real-time profit/loss for each open trade - I have tried doing this in Excel by using the calculate event. The problem here is that with the constant DDE updating, the worksheet is nearly always calculating something and therefore, the worksheet cannot be used for anything else.

I would really appreciate any ideas on how to go about this - assuming that it is possible. To date, I would say that I have a basic understanding of VBA code and have managed to develop a few indicators in MT4, so I am no expert - but keen to learn.

Thanks in advance for any help.

One day!
  • Post #7
  • Quote
  • Nov 19, 2010 1:01pm Nov 19, 2010 1:01pm
  •  sangmane
  • Joined Apr 2009 | Status: MT4 Programmer | 758 Posts
One day I believe you can!

I have made a sample on how to send data from Excel to MT4 and having MT4 replied back to Excel using Named Pipe. So this is a two way comm, although on this scheme, Excel have to be the initiator (I don't think we can running background process / continuous loop in Excel).

You can see my post and mql / xls sample here:
http://www.forexfactory.com/showthre...36#post4135336

Hope this help
  • Post #8
  • Quote
  • Nov 20, 2010 3:34am Nov 20, 2010 3:34am
  •  One day!
  • Joined Jul 2009 | Status: ...or there about! | 220 Posts
Quoting sangmane
Disliked
One day I believe you can!

I have made a sample on how to send data from Excel to MT4 and having MT4 replied back to Excel using Named Pipe. So this is a two way comm, although on this scheme, Excel have to be the initiator (I don't think we can running background process / continuous loop in Excel).

You can see my post and mql / xls sample here:
http://www.forexfactory.com/showthre...36#post4135336

Hope this help
Ignored
Thank you sangmane - pipes aren't something that I am familiar with so I'll read the linked article and play around with your example - see if I can make sense of them.

Regards
  • Post #9
  • Quote
  • Feb 15, 2013 9:33pm Feb 15, 2013 9:33pm
  •  edgarlemos
  • | Joined Dec 2012 | Status: Member | 22 Posts
Hello!

I'd like to do something like this: Having an Excel file where I write my orders (pending orders in fact) like buy stop/sell stop/(..) , price, TP, SL, Volume, an then that would export and put all the orders on Metatrader.. Would it be possible? I have no experience on coding of any type, so.. I'm here to get help from experienced guys like you, if it would be possible.

Best regards
  • Post #10
  • Quote
  • Feb 15, 2013 10:04pm Feb 15, 2013 10:04pm
  •  CodeMeister
  • Joined Sep 2009 | Status: Making Code While Making Pips | 1,672 Posts
Read or reread post #7. It tells you how to do it properly, but does require strong coding skills. I believe there are commercially available products for non programmers.
  • Post #11
  • Quote
  • Feb 16, 2013 10:58am Feb 16, 2013 10:58am
  •  edgarlemos
  • | Joined Dec 2012 | Status: Member | 22 Posts
Yes, as I said, i understand nothing about coding, and I have no time to learn that.. could you recomend me any commercial solution?

Best regards
  • Post #12
  • Quote
  • Feb 16, 2013 2:04pm Feb 16, 2013 2:04pm
  •  CodeMeister
  • Joined Sep 2009 | Status: Making Code While Making Pips | 1,672 Posts
I seem to recall that one of the brokers offerred this.

Plus there was a third party software vendor with a name something like xcellink.
  • Post #13
  • Quote
  • Feb 16, 2013 2:24pm Feb 16, 2013 2:24pm
  •  edgarlemos
  • | Joined Dec 2012 | Status: Member | 22 Posts
But i cant find anything about xcellink on google. Are you sure it's the right name?
  • Post #14
  • Quote
  • Feb 16, 2013 3:38pm Feb 16, 2013 3:38pm
  •  CodeMeister
  • Joined Sep 2009 | Status: Making Code While Making Pips | 1,672 Posts
No, but its close.
  • Post #15
  • Quote
  • Feb 16, 2013 9:22pm Feb 16, 2013 9:22pm
  •  edgarlemos
  • | Joined Dec 2012 | Status: Member | 22 Posts
Is it Mexcel Trader from FxDialogue?? I've seen that, but apparently you have to use the dialog box as you use on metatrader, so it's kinda redundant..
Any other solutions? Or were you talking about another platform?

Best Regards
  • Post #16
  • Quote
  • Feb 16, 2013 11:42pm Feb 16, 2013 11:42pm
  •  CodeMeister
  • Joined Sep 2009 | Status: Making Code While Making Pips | 1,672 Posts
That's one of them. I thought they had full Excel integration, maybe it was only partial. They seem to have gone out of business last week. Oh well.
  • Post #17
  • Quote
  • Feb 16, 2013 11:51pm Feb 16, 2013 11:51pm
  •  CodeMeister
  • Joined Sep 2009 | Status: Making Code While Making Pips | 1,672 Posts
Here is the other. But I think some assembly is required. I think they or somebody else will providem that service at cost.



https://www.fx1.net/excellink.php
  • Post #18
  • Quote
  • Feb 17, 2013 6:54pm Feb 17, 2013 6:54pm
  •  edgarlemos
  • | Joined Dec 2012 | Status: Member | 22 Posts
Well, that's too bad indeed.. So there's nothing in the market that I could simply use, just buying that, no coding, right?
  • Post #19
  • Quote
  • Feb 18, 2013 2:42am Feb 18, 2013 2:42am
  •  CodeMeister
  • Joined Sep 2009 | Status: Making Code While Making Pips | 1,672 Posts
I am out of other ideas, your requirements are for a very small niche of users which is difficult to cater to.
  • Post #20
  • Quote
  • Feb 18, 2013 2:56am Feb 18, 2013 2:56am
  •  nubcake
  • Joined Oct 2009 | Status: >Apocalypto< for Deputy PM 2020 | 3,686 Posts
Quoting edgarlemos
Disliked
Hello!

I'd like to do something like this: Having an Excel file where I write my orders (pending orders in fact) like buy stop/sell stop/(..) , price, TP, SL, Volume, an then that would export and put all the orders on Metatrader.. Would it be possible? I have no experience on coding of any type, so.. I'm here to get help from experienced guys like you, if it would be possible.

Best regards
Ignored
why can't you just manually enter these into mt4 directly? what benefit does putting them into excel have?
Forex Trading for the Savvy Beginner
  • Platform Tech
  • /
  • Trading using Excel and MT4?
  • Reply to Thread
    • Page 1 2
    • Page 1 2
0 traders viewing now
  • More
Top of Page
  • Facebook
  • Twitter
About FF
  • Mission
  • Products
  • User Guide
  • Media Kit
  • Blog
  • Contact
FF Products
  • Forums
  • Trades
  • Calendar
  • News
  • Market
  • Brokers
  • Trade Explorer
FF Website
  • Homepage
  • Search
  • Members
  • Report a Bug
Follow FF
  • Facebook
  • Twitter

FF Sister Sites:

  • Metals Mine
  • Energy EXCH
  • Crypto Craft

Forex Factory® is a brand of Fair Economy, Inc.

Terms of Service / ©2021