DDE offers some simple functions only! Best of luck and stay green always! Jibala

MT4 to Excel through Excel RTD (Finally!)

The list of tickets includes both open positions and pending orders. image Closed orders are not possible with RTD. Best of luck and stay green always! Jibala

MT4 to Excel through Excel RTD (Finally!)

From the RTD manual: Best of luck and stay green always! Jibala

MT4 to Excel through Excel RTD (Finally!)

It's hard to give an or the right answer as long as you don't tell us about how you try to import data into M$ Excel. Best of luck and stay green always! Jibala

MT4 to Excel through Excel RTD (Finally!)

Wrong approach! You should have a strategy at the first. Secondly, test your strategy. This is very important to know if the signals coming from your strategy are good enough. Execute the trades manually from within your Excel Sheet. If everything ...

MT4 to Excel through Excel RTD (Finally!)

Sorry, but what's not clear on that statement? In other words, bar 0 is the current in-progress bar; bar 1 is the last complete bar etc. Best of luck and stay green always! Jibala

MT4 to Excel through Excel RTD (Finally!)

Read the manual! Best of luck and stay green always! Jibala

MT4 to Excel through Excel RTD (Finally!)

It works perfectly for me. Check formula again, maybe you see what's wrong. image Best of luck and stay green always! Jibala

MT4 to Excel through Excel RTD (Finally!)

It was just a quick test just to see if the formula is correct and the buttons are sending an order to the terminal. There's no automatism behind the buttons! Just manual execution. Best of luck and stay green always! Jibala

MT4 to Excel through Excel RTD (Finally!)

Kindly check the MT4 logfiles. Maybe you'll find an entry there. 0 11:28:58.936 '1234567': order sell market 0.02 EURUSD sl: 0.00000 tp: 0.00000 1 11:28:59.106 '1234567': order sell 0.02 EURUSD opening at market sl: 0.00000 tp: 0.00000 failed ...

MT4 to Excel through Excel RTD (Finally!)

That implicates that the cell "C2" is changed manually but that never happens since you calculate the cell by reference to another cell. Therefore, you must adjust that piece of code and you have to work with "Private Sub Worksheet_Calculate()" ...

MT4 to Excel through Excel RTD (Finally!)

Ok, sorry it was my mistake. VBA cannot interpret the pointer "RTD!A1", where RTD! is referring to the table and "A1" the cell with the account number. You have to hard code it with the account number instead! Accordingly to the manual: Private Sub ...

MT4 to Excel through Excel RTD (Finally!)

That's absolutely correct! Best of luck and stay green always! Jibala

MT4 to Excel through Excel RTD (Finally!)

Please explain a bit more in detail and maybe show the VBA code so that we maybe can have a look at what you're doing wrong. Best of luck and stay green always! Jibala

MT4 to Excel through Excel RTD (Finally!)

You can do a lot if you're familiar with VBA. We do the most with M$ Excel formulas. Only the order execution is coded in VBA and send to MT4 thru the API. Best of luck and stay green always! Jibala

MT4 to Excel through Excel RTD (Finally!)

Just add an ActiveX Controls CommandButton and add the VBA Macro to it. image image Private Sub CommandButton1_Click() Set cmd = CreateObject("FXBlueLabs.ExcelCommand") strResult = cmd.SendCommand(RTD!A1, "BUY", "s=EURUSD|v=1500", 5) End Sub ...

MT4 to Excel through Excel RTD (Finally!)

Almost correct! image Best of luck and stay green always! Jibala

MT4 to Excel through Excel RTD (Finally!)

Let's say you have the time of mt4 (='MT4'|TIME!GBPAUD) running in A1 and the conditions are met in your other cell, then you just use "copy" in vba from e.g. A1 to B1. Sheets("Your_Sheet").Range("A1").Copy ...

MT4 to Excel through Excel RTD (Finally!)

Go back to the post where I've posted the formula and compare it to yours. You then should clearly see what's wrong and why it doesn't work for you. Best of luck and stay green always! Jibala

MT4 to Excel through Excel RTD (Finally!)

Even if you would know that piece of code you couldn't do anything with it because VBA can not send orders directly to MT. For that, you need an API. What is an API? An API is a set of functions and procedures allowing the creation of applications ...

MT4 to Excel through Excel RTD (Finally!)