result of 3 days trading which is fully automated using strategies on Excel RTD on a real money account.

MT4 to Excel through Excel RTD (Finally!)

Excel RTD works fine on MT5 for all FX pairs. you need to request MT5 version of excel RTD from your broker.

MT4 to Excel through Excel RTD (Finally!)

Has anyone managed to buy/sell XAUUSD or XAGUSD via Excel RTD command? Works perfectly Set cmd = CreateObject("FXBlueLabs.ExcelCommand") strResult = cmd.SendCommand("31011134", "BUY", "s=EURUSD|v=1000|magic=007|comment=Test", 5) Doesn't execute Set ...

MT4 to Excel through Excel RTD (Finally!)

Kicking off a live account using excel RTD - multi-strategy

MT4 to Excel through Excel RTD (Finally!)

Great info, will keep an eye on it for progress.

MT4 to Excel through Excel RTD (Finally!)

No problem, happy to help out whenever you need it!!!

MT4 to Excel through Excel RTD (Finally!)

Worksheet calculate is the right place to deploy the code, this will auto-trigger to check for condition whenever some cell value changes. Pointed code to B2 cell to read account number instead of hard coding it in the VBA. Changed Buy/Sell command ...

MT4 to Excel through Excel RTD (Finally!)

had a quick look, there are errors and incorrect syntax in the code. Have to go for dinner, will post correct code tomorrow.

MT4 to Excel through Excel RTD (Finally!)

@mtharwat, The file doesn't have any VBA code for me to check.

MT4 to Excel through Excel RTD (Finally!)

The account has 2 strategy running side by side so hard to separate out DD related to the result I posted here. Anyone overall DD is acceptable. Attached some screenshots.

MT4 to Excel through Excel RTD (Finally!)

I am publishing this excel for everyone to understand how a trading strategy can be setup and automated in Excel. The file has 5 Tabs - Trades – Show account balance, PL etc. Cell F2 calculated position size for trades to execute. - Dashboard – o ...

MT4 to Excel through Excel RTD (Finally!)

- this logic below will buy/sell and reset the trigger cell. IF Cell A1 = "Yes" then execute trade based on Cell B1 value (Buy) & Cell B2 value (EURUSD) Cell A1 = "No" End if -this logic below will monitor for the condition and set value the trigger ...

MT4 to Excel through Excel RTD (Finally!)

What are your rules for this system 1) MA Settings? 2) Timeframes? 3) Trigger for Long or Short? 4) Position Size? Risk per trade? 5) SL 6) TP

MT4 to Excel through Excel RTD (Finally!)

can't be that hard to code it. Without knowing the specific, code logic below IF Cell A1 = "Yes" then execute trade based on Cell B1 value (Buy) & Cell B2 value (EURUSD) Cell A1 = "No" End if If Cell A2 = "Trade Condition Met" Then Cell A1 = "Yes" ...

MT4 to Excel through Excel RTD (Finally!)

I have attached test result with 4 tabs with diff currency pair. I have tested each of 3 times in a cycle and have same results which are logged in Column C,D,E in Row 1,2,3. you can rerun these pairs within this excel you should get the same ...

MT4 to Excel through Excel RTD (Finally!)

Cool. Next question You copy & paste column A to G from Row 5 onward. Do you then check column I to P has same number of rows with formula, same as row A to G? Add or Delete rows as required to match them?

MT4 to Excel through Excel RTD (Finally!)

I did 3 pairs 5 times each. All had same result. Question - are you doing a copy & paste of the data from for each pair from another sheet to the backtesting template?

MT4 to Excel through Excel RTD (Finally!)

Hey mtharwat, Before you hit "click me" button please make sure the all row for column Q, R , S & T are empty. if these are not empty then your numbers will get screwed up on re-run for a pair, which is what you are experiencing right now, because ...

MT4 to Excel through Excel RTD (Finally!)

Is it happening with all pairs or only some specific pairs? Can you attched couple of files with data to run/check.

MT4 to Excel through Excel RTD (Finally!)

Seems to be rights based on the excel. All JPY pair had 17144 bars?

MT4 to Excel through Excel RTD (Finally!)