MT4 to Excel through Excel RTD (Finally!)

thank you for sharing

thank you

HI GUYS,
I HAVE DOWLOAD THIS MQ5 FROM .>https://www.mql5.com/en/code/1246

I NEED IMPORT MT5 LIVE DDE TO EXCEL , WHO KNOW HOW TO MODIFY FOR LIVE DATA ASK & BID PRICE?

Check & Add Item DDE

if(!CheckItem("COMPANY","Value")) AddItem("COMPANY","Value");
if(!CheckItem("TIME","Value")) AddItem("TIME","Value");
if(!CheckItem("BID","EURUSD")) AddItem("BID","EURUSD");
// Set Item Value DDE
SetItem("COMPANY","Value",(string)AccountInfoString(ACCOUNT_COMPANY));
SetItem("TIME","Value",(string)TimeCurrent());


SetItem("BID","EURUSD",(string) ?????()); >FOR THIS IF I WANT CHECK FOR EURUSD BID HOW TO SET?

THANK YOU

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

This is great Garfield.. Well done!

I will update about myself.

Since I am still learning VBA and it is delaying me from further projects in executing trades, I decided to temporarily purchase one of the EA builders to design my EAs and strategies and backtest them. I will try to allocate time in the future for VBA.

——————-

keep the good work,

Cheers,

Well done.

Are the fully automated strategies based on purely technical indicators based on moving averages?

Please give more details as to the models you have used.

This is amazing, the layout does not seem like you used excel at all.

Garfield well done

Suggestion do not change anything and just keep that burbling along

The normal temptation is to tweak and finesse and then a mess happens

Replicate what have working with another broker maybe but keep everything the same on this account and with these settings

A weekly update pix would be appreciated

Thanks

SE

Please share your exp with EA builder. In the past, I found the EA builders limitation was to be able to check indicator values across multiple timeframes to identify trades.

All 3 strategies have MA's accoss multiple TF as part of trade entry decision.
I have posted 1 of the strategy earlier with an excel template which can be fully automated.

All strategies have some variations on MA, some other indicators, assessment across multiple timeframes price range movement.
Trade entries are based on rules defined in Excel RTD. Trade management post entry is managed by EA where all trades move to BE and then uses a trailing SL.
I haven't implemented Money management in terms of risk % per trade, however based on the initial calculation 0.01 microlot per 5K account is very safe. Currently I am trading with 1.5K per 0.01 which I would categories as medium risk, wouldn't go lower than 1.5K.

Plan to increase it to 0.02 lot at 3K and maintain a ratio of 0.01 lot per 2.5K.

For free and quite detailed analytics, I have been using myfxbook.com since a few years.

Can trades be entered by Pending Orders just using Excel ? Can all order types be executed by Excel ?

I enter trade at market. Excel RTD command as option for pending trades as limit or stop order.

From what I have seen so far, there are no such limitations at all.

I wish if I was able to review my experience with some products. The problem I fear is that I would be violating FF rules. I will try to summarize my experience without mentioning the names of the products and out of respect to Forex Factory guidelines and rules.

There is an EA builder that uses (if) and else If logic. This one I have not purchased yet but is free to be used in Demo Trading. It can also be used to retrieve data from other symbols in other time frames which will be ideal for trying currency strength formulas.

There is another one I have recently purchased and currently use. It has a very simple interface. The trade can be closed by different formulas either from indicators or price with ATR or any formula. For example, I can set arithmetic equations for when to close a deal. I chose this EA builder for its simplicity and then may use something else in the future. This tool enables the creating of custom indicators as well. I have used it in the past. It is totally free.

and there is one or two more.


----------------


I still love Excel and it is the reason how I got to this stage. There are things of which I do not know if I can implement with EA builders. For example, if I want to trade the break of a trend line of an indicator or if I want to apply an indicator as a second study on another indicator. For ex: SMA of RSI, etc.. Will I be able or not to formulate these strategies in EA builders is something I need to find. However, for the most part, these online tools and standalone applications will suffice the needs of most traders.

--------------------

There are also a couple of products that communicate between Excel and MT4.. One is designed for coders and developers in which it can read and write to Excel (Two way). For example, you create an indicator in Excel then you can see it in MT4. But this product requires programming knowledge.

There is another product that is very easy to use for any excel user to trade directly from excel without any VBA with simple syntaxes. This product can retrieve all indicators from MT4. However, it differs from EXCEL RTD in that the previously loaded history bars are not refreshed except if Excel is restarted. However, the instant prices are live and indicators values as well. And of course, trades can be managed from Excel. I am not sure if one would require two licenses to use on a personal PC and a virtual server as it is an Excel add-on. I have this product but have not used it in a while and almost forgot about it.

------------------

I am sorry for not mentioning the names of products here, but can PM you if you are interested.

---------
I believe one should have more than one tool including EA builders, Excel, etc.. For example, and as you have previously mentioned, I can use EXCEL RTD for instant manual trading and letting the EA manage the trade. I kind of came to a halt when it came to the automation of trades via EXCEL RTD in VBA.

Or use EXCEL for dashboards (as those EA builders do not make dashboards) and complex strategies that can not be formulated by EA builders, then trade with an EA, and so on.

Or use Excel for giving different weights for each time frame or when most of the conditions are met. Such logic may be hard to formulate in online tools.

However, Backtesting may be better and less time-consuming, and effective with an EA.

There will never be one solution that fits all.


-------------------


Let me know if you need any more clarification,

Regards,

A spreadsheet for trend-following approach

Hi All

I've not read this whole thread as it's way too long, so apologies if this has been answered already.

I am currently using the formula =RTD("fxbluelabs.excelrtd", ,account#, "@bh,UK100,M5,high,1"), which works fine.

However, I want to know the previous candle price data for the bid AND the ask, so that I know the spread for back-testing purposes.

I can get live bid/ask prices using =RTD("fxbluelabs.excelrtd", ,20764818, "bidUK100"). But this updates too often and forces excel to calculate, so when working on a large spreadsheet it's a pain.

When I try to retrieve the previous candle bid/ask data, I use =RTD("fxbluelabs.excelrtd", ,account#, "@bh,bidUK100,M5,high,1"), (notice the extra "bid" before the symbol name.

But the cell just reads "wait".

Does anyone know how I can achieve what I'm trying to do? E.g. is there a way to retrieve the spread for a given time?

Many Thanks.

Hi,
Welcome to the thread.

As far as I know, we can't retrieve the previous Bid/Ask or spread.. Only current.

Directional Bias Trading (Mixed/Semi-Automation)


As I have mentioned before, I will use EXCEL RTD for the dashboards in higher time frames and will execute with EA (using an EA tool builder) until I learn more about VBA for trading in Excel (which is absolutely not that hard at all; at least for our purpose here), but I can not find enough time for it.

Here is what I have done so far in a demo account:

I checked my Excel dashboard and AUDJPY was one of the candidates among others. This was before London Session. Here is a screenshot showing a vertical line at the time of establishing my bullish bias. I first checked Price Action before trading. We had a breakout and a retest.


Then I decided to trade based on a strategy I am testing and can be improved. The idea is to establish bias on HTF and execute with a strategy automatically in Lower Time Frames and then stop trading until a new opportunity appears.
AUDJPY:H4


I have four SMAs (20,30,40,50). For longs, the SMAs have to spread out and be stacked in order. Price in M5/M15 has to close above SMA20 and not be far away by X pips from SMA20. Target profit is 20 Pips and Stop Loss is 10 pips. EA will only go long. No limit to the number of open trades. I will change this in the future.

Here is a screenshot of AUDJPYM5 later on:




There were two other closed trades in profit (in the screenshot)
----------------

I worked on other pairs and had good results. However, sometimes the price just breaks out in my direction but is not executed by the EA because the conditions I have put were not met. That is fine so far.

-----------------------

Nice.
Do you have to attache the EA to chart of every pair and everytime frame you want to trade?
or can it be attached to 1 chart to monitor a list of pairs and timeframe via setting tab of the EA?

That is the total number of trades executed in demo and win/loss ratio?