Trading using Excel and MT4?

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?

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

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?

How can I make a connection between MT4 and Excel? If I enter a trade it Excel, MT4 execute the trade?

If he is an IT professor he will not use Excel.

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!

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

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

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

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.

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

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.

But i cant find anything about xcellink on google. Are you sure it's the right name?

No, but its close.

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

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.

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

Well, that's too bad indeed.. So there's nothing in the market that I could simply use, just buying that, no coding, right?

I am out of other ideas, your requirements are for a very small niche of users which is difficult to cater to.

why can't you just manually enter these into mt4 directly? what benefit does putting them into excel have?