MT4 to Excel through Excel RTD (Finally!) | Page 27 | Forex Factory

Options

Go to
Permalinks
Print Thread

Related Instruments

EUR/USD, EUR/JPY, GBP/USD

Similar Threads

Calculating EMA strength like RTD on break free trading 0 replies

MT4 RTD API 0 replies

MT4 export to Excel? 8 replies

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

Integration between excel and MT4 prices 3 replies

Attachments: MT4 to Excel through Excel RTD (Finally!)
Exit Attachments

MT4 to Excel through Excel RTD (Finally!)

  • #521
  • Edited 7:02am Apr 16, 2021 6:34am | Edited 7:02am
Quoting garfield75
@mtharwat - how are you going with EA/Indicator development? How do you rate Pivot and S/R reliability for trading?
Hello my friend,

My big apology as I have just found about your post.

So far, I trade price action (based on my other two threads for time charts and Renko). I prefer Renko myself. The same rules in my first post in the price action thread with candlesticks apply on Renko.
I myself have not seen anything that is more reliable than scanning the 28 pairs three or four times a day based on Renko. I sometimes stay till late waiting for the price to make its move. Sometimes, (but not always), I want to see the overall price structure when a certain level is triggered. By the same token, I want to witness the momentum if there is any.

I invite anyone to allocate time and study Renko. It has not but given me more pips and success. I myself stopped even using divergence and there is no single indicator on my chart. Just the purest and cleanest Renko chart.

I am not into support/resistance as the sole or primary way of analysis. I combine it with patterns/trendlines/etc.. Everything has its place in multi-time frame analysis or multi Renko box analysis; when to use this pattern or that and when to use support and resistance.

I can elaborate more if you wish with a detailed description...

Scanning all pairs (although is sometimes demanding and titring three/four times a day) is like cooking my own food from scratch and dieting on the healthiest ingredients. I prefer my own hand-making and this has stood the test of time either for trading or dieting D:.

Sorry again for not seeing your post.
  • #522
  • Edited May 6, 2021 11:13am May 5, 2021 11:23am | Edited May 6, 2021 11:13am
Hey guys,

i’m currently setting up a trade manager in excel with rtd,

i’ve got the live orders/ balance displayed, and now looking to add a “Close All” button or close button for any given transaction.

does someone have a working example of this they’d be willing to share.

new to VBA, but figured it would be a good project to start with..

so far, i’ve found excel to be a more stable trade manager than using MT4 which can freeze on news events. so wanting to expand the capabilities of excel / rtd
  • #523
  • May 6, 2021 9:07am May 6, 2021 9:07am
Quoting blablabla
Hey guys, i’m currently setting up a trade manager in excel with rtd, i’ve got the live orders/ balance displayed, and now looking to add a “Close All” button or close button for any given transaction. does someone have a working example of this they’d be willing to share. new to VBA, but figured it would be a good project to start with.. so far, i’ve found excel to be a more stable trade manager than using MT4 which can freeze on news events. so wanting to expand the capabilities of it
Hello,

This is a great thing. I, unfortunately, did not have time to learn VBA to be able to do it.

I believe there were a couple of posts in this thread that had some VBA examples.

I wish if I can learn it as I really want to give a go to trading based on different currency strength formulas.
  • #524
  • May 6, 2021 6:19pm May 6, 2021 6:19pm
Quoting blablabla
Hey guys, i’m currently setting up a trade manager in excel with rtd, i’ve got the live orders/ balance displayed, and now looking to add a “Close All” button or close button for any given transaction. does someone have a working example of this they’d be willing to share. new to VBA, but figured it would be a good project to start with.. so far, i’ve found excel to be a more stable trade manager than using MT4 which can freeze on news events. so wanting to expand the capabilities of excel / rtd

Attached Image
Trading is SIMPLE not EASY.
  • #525
  • Edited 10:14am May 7, 2021 10:00am | Edited 10:14am
This was an EA I have previously created and shared.

I placed it on a virtual server as today there were big moves in some pairs.
The results were very good. I tested it in Demo with 0.1 lots.

Closed trades
Attached Image (click to enlarge)
Click to Enlarge Name: ff3.png Size: 21 KB

open trade:
Attached Image (click to enlarge)
Click to Enlarge Name: open.png Size: 8 KB


The reason why it worked well is the fact that it traded the pullbacks and since the market is very volatile today, it caught some good moves. In short, it depends on the trader's analysis of which pairs to choose and which time to use the EA.



----------

The EA is this one
Attached File(s)
File Type: ex4 SMA cross D-H4-Current.ex4   39 KB | 455 downloads



How it trades:
It checks the crossover of two MAs in Daily and two MAs in H4 and two MAs in the current time frame. In my case the current time frame was M15.

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

The setting I used are in this photo I took

Attached Image (click to enlarge)
Click to Enlarge Name: 0B8A3415-BDCF-4D04-9E86-107228F91D21.jpeg Size: 352 KB


---------------------
  • #526
  • Edited 11:48am May 7, 2021 11:15am | Edited 11:48am
Quoting mtharwat
This was an EA I have previously created and shared. I placed it on a virtual server as today there were big moves in some pairs. The results were very good. I tested it in Demo with 0.1 lots. Closed trades {image} open trade: {image} The reason why it worked well is the fact that it traded the pullbacks and since the market is very volatile today, it caught some good moves. In short, it depends on the trader's analysis of which pairs to choose and which time to use the EA. ---------- The EA is this one {file} How it trades: It checks the crossover...
------------------------

So now I closed all trades as I felt the market is getting a bit slow and there is a chance of some ranging.

The first two trades were closed manually and the rest were closed by the EA.

Attached Image (click to enlarge)
Click to Enlarge Name: last.png Size: 37 KB


The net profit is USD 108.76 (based on 0.1 lots) in the span of about 2 hours and a half.

----------

Important Note:


You have to use your own judgment of when to apply the EA and on which pairs. You have to first analyze the pairs in Higher Time Frames and choose the right time when there is good volatility before applying the EA. Watch for news influencing the pairs either for the day or the following couple of days.

Here is a good example:

AUDJPY was breaking out of a Resistance in H4. I set the EA to take trades in M15. I stopped the EA because there is another resistance in the way.
H4:
Attached Image (click to enlarge)
Click to Enlarge Name: AUDJPYH4.png Size: 85 KB


M15:
Attached Image (click to enlarge)
Click to Enlarge Name: AUDJPYM15.png Size: 39 KB



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

Combine this EA with the EXCEL RTD template I shared for Breakouts in this thread.
  • #527
  • May 7, 2021 11:54am May 7, 2021 11:54am
Another example of No Bullish trades.

NZDUSD at Daily Resistance so no way to go long..Only after it breaks it not before.

I apologize if someone finds this stuff basic, but I know many who just trade without doing any analysis.

Attached Image (click to enlarge)
Click to Enlarge Name: NZDUSD.aDaily.png Size: 52 KB
  • #528
  • May 8, 2021 7:36am May 8, 2021 7:36am
Hi, mtharwat.
Although I liked your replies above, there are quite a few exceptions that one needs to keep in mind and here I will show you examples of yesterday's trades on US30 for your kind perusal and comment.
I like your EA because it hides the SL, but I am not convinced just yet that the H4/D1 is the correct setting for M15 (and M5 in my case) for the EA. Having said that let me thank you for your kind assistance with the EA that was not trading.
===
Daily is the first screenshot to show you that there are no RES-LEVELS unless one uses the Fib levels, which shows very clear levels in this case. From here I will add RES/SUPP levels to support my statement.

Attached Image (click to enlarge)
Click to Enlarge Name: 9aa202306f54c224f666d57ba5539308.png Size: 111 KB

===
Attached Image (click to enlarge)
Click to Enlarge Name: 81da3206f855aeb3f1bb0c8ca118f9fe.png Size: 129 KB
H4 confirming.
===
H4 with RES/SUPP lines
Attached Image (click to enlarge)
Click to Enlarge Name: 12081c6449f3a3e131def224175dfdf6.png Size: 122 KB
===
M15 still no RES-levels in sight.
Attached Image (click to enlarge)
Click to Enlarge Name: bf237401c92cf2c00316f3b4b4be52f3.png Size: 114 KB
===
M5 the same
Attached Image (click to enlarge)
Click to Enlarge Name: 2af652e4795b9ea3d4152c683639c912.png Size: 98 KB
===
Here with Fiblevels.
Attachment g
Attached Image (click to enlarge)
Click to Enlarge Name: e387a8ca4c33b0b4d14330a675714a4f.png Size: 117 KB
Hercs
  • #529
  • Edited 10:51am May 9, 2021 10:33am | Edited 10:51am
Quoting Hercs
Hi, mtharwat. Although I liked your replies above, there are quite a few exceptions that one needs to keep in mind and here I will show you examples of yesterday's trades on US30 for your kind perusal and comment. I like your EA because it hides the SL, but I am not convinced just yet that the H4/D1 is the correct setting for M15 (and M5 in my case) for the EA. Having said that let me thank you for your kind assistance with the EA that was not trading. === Daily is the first screenshot to show you that there are no RES-LEVELS unless one uses the...

You are welcome,

For US30, first, remove all those colours from the chart and look at it plain and simple. The more you strip indis from your chart, the clearer the chart will be.


Let's look at the Daily:
Attached Image (click to enlarge)
Click to Enlarge Name: US30.aDaily.png Size: 48 KB

There was a breakout and in Weekly/Monthly, there is no Near resistance.

The Daily/H4 EA was meant to trade M15/M30 for intraday setups.

So what would we do in such a case?

1- Look for Pull backs in the Lower time frame that represent a consolidation and then a breakout.
2- If the Higher time frame (Which is the daily in our example) has trended so much (which is not the case yet), then we should wait for a good pullback on that Daily time frame.
3- The more we trend away from the most recent S/R, we need to reduce our lot size as long as we do not have a good daily pullback.

In our example, we have not yet trended that far from the most recent Daily S/R
Here in M15, we had a couple of breakout or consolidations that would have enabled us to trade (intradaily)
M15
Attached Image (click to enlarge)
Click to Enlarge Name: US30.aM15.png Size: 53 KB


BTW: The current TF in the EA can be set on an M30 chart/H1/M5 or any and do not forget to set your SL settings accordingly.

-------

Fibonacci:

If you want to use them, then you need Fibonacci expansion. If there is no near resistance, a fib expansion may help. They may help for setting your target but can not be used for a (reversal setup) unless we have good congestion in daily, H4 and a breakout south with a retest. Other than that, the FIB level is not enough at all.

With the normal Fib Retracement, you may use it for pullbacks. However for Fib Retracements (I prefer a consolidation at Lower time frames) and a breakout above this level.

Generally speaking, some traders prefer using fib (Expansion and retracement) in conjunction with divergences.
------------------

Some traders would use MAs. For example, if the price has trended far away from an MA (50) for example, they would anticipate a correction and won't trade any more unless it corrects.

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


EDIT:
I wanted to add that in the future, I will add the possibility of making all Time Frames as variables. Maybe someone wants to trade M1/M5 based on H1/H4 or even trade H4 based on weekly, etc..
  • #530
  • May 9, 2021 10:39am May 9, 2021 10:39am
Quoting mtharwat
This was an EA I have previously created and shared. I placed it on a virtual server as today there were big moves in some pairs. The results were very good. I tested it in Demo with 0.1 lots. Closed trades {image} open trade: {image} The reason why it worked well is the fact that it traded the pullbacks and since the market is very volatile today, it caught some good moves. In short, it depends on the trader's analysis of which pairs to choose and which time to use the EA. ---------- The EA is this one {file} How it trades: It checks the crossover...

I just wanted to comment on the short settings I showed in my EA:
The reason I am using short settings is that I want to trade as close as possible to Price Action and price momentum or shift of momentum and hence I am using MAs 1 and 5 for both H4 and Daily. MA 1 is the same as the price itself and MA5 is for confirmation. Then the current TF uses 1 and 3 MAs for a quick entry into the market.

All of this is to be done in conjunction with analyzing S/R and any other patterns you may find in the chart as I have explained in a previous post.
  • #531
  • May 13, 2021 11:17pm May 13, 2021 11:17pm
Any peperstone cleints?

In the last 7 or 10 days, I have seen very wide gaps in a number of US and Australian currencies. They were very wide and I refrained from trading.

Then today I checked other brokers including IC markets, IG, FXCM, and have not seen such gaps at all.

I have just emailed Pepperstone and inquired about the reason for such gaps.
  • #532
  • May 13, 2021 11:34pm May 13, 2021 11:34pm
Quoting mtharwat
Any peperstone cleints? In the last 7 or 10 days, I have seen very wide gaps in a number of US and Australian currencies. They were very wide and I refrained from trading. Then today I checked other brokers including IC markets, IG, FXCM, and have not seen such gaps at all. I have just emailed Pepperstone and inquired about the reason for such gaps.

Interesting, now that you mentioned my NZDCHF trade closed out with SL this morning (2nd trade in a new account) with PepperStone and still open and active with GoMarkets didn't get anywhere close to SL.

Pls let me know what is their response. I will also send an email with the example.

Cheers
Trading is SIMPLE not EASY.
  • #533
  • May 27, 2021 9:02pm May 27, 2021 9:02pm
Quoting garfield75
{quote} 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 to pick up the correct value of currency pair name. Please copy-paste the code below in Excel. The market is closed so I can't test it, but I think there is a logical error, Column O values change by Column M Column M value is depended on Column N Column N values based on Price. When Criteria...

I have done a different approach that only worked for Buys but did not work for shorts. ( I am still learning VBA).
I used the "switch Logic" within the Excel template itself rather than inside the VBA. I used one of the EXCEL RTD formulas to find the current open trades. And then I look up for the Pair if it is present in the Open Trades column. If it is there, then no trade.
However, I was successful with Buy Orders (Only one trade at a time) but no Sell Orders were executed.

Initially, I tested Buying only and used:

Private Sub Worksheet_Calculate()
Dim X As Integer
Set cmd = CreateObject("FXBlueLabs.ExcelCommand")

For X = 3 To 30
If Cells(X, 4) = "Buy" And Cells(X, 6) = "You Can Trade" Then
strResult = cmd.SendCommand(Cells(1, 2), "BUY", "s=" & Cells(X, 1) & "|v=1000", 5)

End If
Next X
End Sub

-----------

Then I wanted to include Sell Orders so I added Else If but it did not work.

Thanks,
  • #534
  • May 27, 2021 9:20pm May 27, 2021 9:20pm
I placed =RTD("fxbluelabs.excelrtd", , $B$1, "t"&G3&"s") in one column
and another column for a sequence of numbers (1 to 28 ).

B1 is the account number and G3 (not fixed) is the column for the number sequence.

This helped me in opening only one trade for each pair.

Attached Image
  • #535
  • May 28, 2021 6:32am May 28, 2021 6:32am
Hi all, Ive read the RTD guide from FXBlue, but I've downloaded ROC as an indicator and keen to pull this into excel..I cant seem to use this in my cell - =RTD("fxbluelabs.excelrtd", , "accountno", "@roc,GBPUSD,D1,10,0").....is this incorrect, or do I have to pull the data out from history centre and work it out manually?

Cheers
  • #536
  • May 28, 2021 6:38am May 28, 2021 6:38am
Hi, I have downloaded roc as an indicator - was trying to pull this into excel via RTD...using the code - =RTD("fxbluelabs.excelrtd", , "acc", "@roc,GBPUSD,D1,10,0")..doesnt seem to work...do i need to download the data via history centre and work out manually, or am i simply using the wrong code? thanks
  • #537
  • May 29, 2021 1:26am May 29, 2021 1:26am
Quoting TraderPom
Hi, I have downloaded roc as an indicator - was trying to pull this into excel via RTD...using the code - =RTD("fxbluelabs.excelrtd", , "acc", "@roc,GBPUSD,D1,10,0")..doesnt seem to work...do i need to download the data via history centre and work out manually, or am i simply using the wrong code? thanks

Hi,
I am typing from my phone so apology for any typo.
Not all indicators are enabled with FX Blue Labs unfortunately. I believe the ones already mentioned in the PDF are the ones we can pull their data.

However ROC is one of the easiest to calculate.
I have shared a template but forgot its name that does this calculation. I believe the title had these keywords ( close relative to close N periods ago).

ROC is simply calculating the percentage change of a recent close to a previous (N) close.
(Close (recent) - close (previous)) / close previous * 100.

If this does not help, let me know and I can share a template later.
  • #538
  • May 29, 2021 5:48am May 29, 2021 5:48am
suspected that would be the case...thanks for coming back.. I've pulled the last 30 days of prices for major FX from history centre, which Ive used to work out 30-day realised vol, but can easily use for ROC...

i've read the various brokers guides, which are all the same, but if there is a complete list of indicators the API reads then I'd appreciate the share - guess its a function of trying and seeing what works

be great if FXBlue would be open to including variables to feed into excel upon on request

In the process of building an interface, and guess others have done something before but not the sort of thing people share
  • #539
  • May 30, 2021 2:37am May 30, 2021 2:37am
Quoting mtharwat
{quote} I have done a different approach that only worked for Buys but did not work for shorts. ( I am still learning VBA). I used the "switch Logic" within the Excel template itself rather than inside the VBA. I used one of the EXCEL RTD formulas to find the current open trades. And then I look up for the Pair if it is present in the Open Trades column. If it is there, then no trade. However, I was successful with Buy Orders (Only one trade at a time) but no Sell Orders were executed. Initially, I tested Buying only and used: Private Sub Worksheet_Calculate()...

Try the code below to see if this works.

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

Private Sub Worksheet_Calculate()
Dim X As Integer
Set cmd = CreateObject("FXBlueLabs.ExcelCommand")

For X = 3 To 30
If Cells(X, 4) = "Buy" And Cells(X, 6) = "You Can Trade" Then
strResult = cmd.SendCommand(Cells(1, 2), "BUY", "s=" & Cells(X, 1) & "|v=1000", 5)
End If

If Cells(X, 4) = "Sell" And Cells(X, 6) = "You Can Trade" Then
strResult = cmd.SendCommand(Cells(1, 2), "SELL", "s=" & Cells(X, 1) & "|v=1000", 5)
End If

Next X
End Sub
Trading is SIMPLE not EASY.
  • #540
  • May 30, 2021 9:26am May 30, 2021 9:26am
Quoting TraderPom
suspected that would be the case...thanks for coming back.. I've pulled the last 30 days of prices for major FX from history centre, which Ive used to work out 30-day realised vol, but can easily use for ROC... i've read the various brokers guides, which are all the same, but if there is a complete list of indicators the API reads then I'd appreciate the share - guess its a function of trying and seeing what works be great if FXBlue would be open to including variables to feed into excel upon on request In the process of building an interface, and...
I remember I once tried some other indicators and guessed the short names but it did not work. I believe the indicators that are listed in the PDF Guide are the only retrievable ones.
0 traders viewing now