MT4 to Excel through Excel RTD (Finally!) | Page 20 | 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!)

  • #381
  • Feb 13, 2021 12:44am Feb 13, 2021 12:44am
Quoting garfield75
{quote} @mtharwat, The file doesn't have any VBA code for me to check.
Ah must be because I saved it as a non Macro enabled bookHere is the code for simpler reference:


Sub Execute_Trade()
Set cmd = CreateObject("FXBlueLabs.ExcelCommand")
Dim X As Integer
For X = 4 To 31
If Cells(X, 15) = "Yes" And Cells(X, 14) = "Long" Then
strResult = cmd.SendCommand("1336976", "BUY", "s=D4|v=1000", 5)
Else: Cells(X, 15) = "No"

End If
If Cells(X, 13) = "Trade Condition Met" Then
Cells(X, 15) = "Yes"

End If
If Cells(X, 15) = "Yes" And Cells(X, 14) = "Short" Then
strResult = cmd.SendCommand("1336976", "Sell", "s=D4|v=1000", 5)
Else: Cells(X, 15) = "No"
End If

Next X

End Sub
  • #382
  • Feb 13, 2021 1:20am Feb 13, 2021 1:20am
Quoting PayItForward
{quote} I looked in the files and did not find what I was after so ... I mean same as in Post 371, separate Sheets for each time frame, M1 - D1, if one sheet (template) is done then I can add additional sheets and copy and adjust accordingly. On the template a True/False button to output the info to the e,g, cell L7 on the 30Min used in your example. (reason not all time frame output may be needed, e.g. M1, M5, M15, M30 for intraday and longer for trend. If I have the template then with my novice skill level I should be able to do the others I think....

I will initially give you an answer for what I understand from your post and I have a comprehensive solution for you.

You need the flexibility of using Multi TFs on (the template Automation Example in post 327). The answer is that in the three tabs named (30M), (H4) and (1Hr) you can go to the top filed that displays the time frame and change it to the desired one. Here is a screeshot
Attached Image (click to enlarge)
Click to Enlarge Name: jjjjj.png Size: 10 KB

---------------------------
My suggestion is that you tell me what indicators you need (I will leave the indicators with adjustable settings) and how the dashboard should look like. Also if you need multiple instances of any indicator, let me know. For example, You may need two instances of RSI (with changeable or adjustable inputs) and you may need three EMAs, etc..

I will create a sheet that has an input tab for TF and then you can copy it in the same workbook and change the TF. Indicators' inputs will be changeable.

Once the dashboard is created, The VBA for automated trading can be combined if you wish...


Edit:

Pivot points can be calculated... No problem with it.

Support/Resistance: I have not yet created the logic in my head. However, I think (but not sure) it may not a good thing to implement with FXBlue Labs Excel RTD as this would require retrieving many data points and would slow or freeze Excel.
  • #383
  • Feb 13, 2021 1:30am Feb 13, 2021 1:30am
Quoting D-TickTrader
Good day Can any expert make this work for Supply and Demand zones to Excel sheet. There is application I found, but MT4Exec, It's not working.

Hi,

I am sorry for my late reply. I forgot to get back to you. My answer is the same as the above post. The Supply/Demand requires retrieving many data points and that may slow or freeze Excel if applied on all pairs.
  • #384
  • Feb 13, 2021 1:58am Feb 13, 2021 1:58am
Quoting mtharwat
{quote} Ah must be because I saved it as a non Macro enabled bookHere is the code for simpler reference: Sub Execute_Trade() Set cmd = CreateObject("FXBlueLabs.ExcelCommand") Dim X As Integer For X = 4 To 31 If Cells(X, 15) = "Yes" And Cells(X, 14) = "Long" Then strResult = cmd.SendCommand("1336976", "BUY", "s=D4|v=1000", 5) Else: Cells(X, 15) = "No" End If If Cells(X, 13) = "Trade Condition Met" Then Cells(X, 15) = "Yes" End If If Cells(X, 15) = "Yes" And Cells(X, 14) = "Short" Then strResult = cmd.SendCommand("1336976", "Sell", "s=D4|v=1000",...
had a quick look, there are errors and incorrect syntax in the code. Have to go for dinner, will post correct code tomorrow.
Trading is SIMPLE not EASY.
  • #385
  • Feb 13, 2021 2:32am Feb 13, 2021 2:32am
Quoting garfield75
{quote} had a quick look, there are errors and incorrect syntax in the code. Have to go for dinner, will post correct code tomorrow.
No problem.. Take your time.
Thanks
  • #386
  • Feb 13, 2021 3:17am Feb 13, 2021 3:17am
Quoting mtharwat
{quote} I will initially give you an answer for what I understand from your post and I have a comprehensive solution for you.
Will send you a PM.
When you are successful perhaps give a thought to others ... Kiva dot org
  • #387
  • Feb 13, 2021 5:55pm Feb 13, 2021 5:55pm
Quoting mtharwat
{quote} Ah must be because I saved it as a non Macro enabled bookHere is the code for simpler reference: Sub Execute_Trade() Set cmd = CreateObject("FXBlueLabs.ExcelCommand") Dim X As Integer For X = 4 To 31 If Cells(X, 15) = "Yes" And Cells(X, 14) = "Long" Then strResult = cmd.SendCommand("1336976", "BUY", "s=D4|v=1000", 5) Else: Cells(X, 15) = "No" End If If Cells(X, 13) = "Trade Condition Met" Then Cells(X, 15) = "Yes" End If If Cells(X, 15) = "Yes" And Cells(X, 14) = "Short" Then strResult = cmd.SendCommand("1336976", "Sell", "s=D4|v=1000",...

  1. Worksheet calculate is the right place to deploy the code, this will auto-trigger to check for condition whenever some cell value changes.
  2. Pointed code to B2 cell to read account number instead of hard coding it in the VBA.
  3. Changed Buy/Sell command to pick up the correct value of currency pair name.
  4. 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,

    1. Column O values change by Column M
    2. Column M value is depended on Column N
    3. Column N values based on Price.

      1. When Criteria met you execute the trade and then set O value to "No"
      2. On the next Tick the same trade will likely to trigger again if all condition met. So you may want to consider how may trades you want to have for a pair at any given time in each direction, you may need to introduce another loop to check opens and use that as additional criteria to make the decision to take or skip new trades.
      3. You may also consider a time delay, since it is a 15 min timeframe, you can code in a condition to trade maximum of 1 trade per pair in a 15 min TF.


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

MsgBox Cells(2, 2)
For X = 4 To 31

If Cells(X, 13) = "Trade Condition Met" Then
Cells(X, 15) = "Yes"
End If

If Cells(X, 15) = "Yes" And Cells(X, 14) = "Long" Then
strResult = cmd.SendCommand(Cells(2, 2), "BUY", "s=" & Cells(X, 4) & "|v=1000", 5)
Else: Cells(X, 15) = "No"
End If

If Cells(X, 15) = "Yes" And Cells(X, 14) = "Short" Then
strResult = cmd.SendCommand(Cells(2, 2), "Sell", "s=" & Cells(X, 4) & "|v=1000", 5)
Else: Cells(X, 15) = "No"
End If

Next X
End Sub

Trading is SIMPLE not EASY.
  • #388
  • Feb 13, 2021 10:32pm Feb 13, 2021 10:32pm
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...

Hey mate,

Thank you a lot for taking the effort.... Very much appreciated.
I am still trying to get the hang of VBA... So much material I need to read.

1- Yeah, the Worksheet calculate is the right one...
2-Buy SEll Command to choose the right cell to execute... great to know about. It makes sense and seems to be the basics of the for-each loop I am using. Also by the same token, if I want to change the volume of trade (v=1000), then I would follow the same suit.
3- I will try to work on the code later to make it execute one trade at a time. I will think of the new loop.
4-I will test and see if there is an error.

Thanks again Garfield,
Blesses,
  • #389
  • Feb 14, 2021 2:26am Feb 14, 2021 2:26am
Microsoft Excel Becomes a Proper Programming Language

https://thenewstack.io/microsoft-exc...ming-language/
Practice makes a person perfect
  • #390
  • Feb 14, 2021 5:18am Feb 14, 2021 5:18am
Quoting simnz
Microsoft Excel Becomes a Proper Programming Language https://thenewstack.io/microsoft-exc...ming-language/
Thanks for the link...I signed up for the beta to receive it. Hopefully, it does not take long to test it.
  • #391
  • Edited 7:09am Feb 14, 2021 6:46am | Edited 7:09am
RSI (2) system.V1

This system is inspired by "Short Term Strategies that Work" By Larry Connors. I have modified the system and changed it to test the strength of RSI(2). The book is a good read, and Connors claims to have tested RSI (2) on millions of data series. RSI(2) can be RSI(3) or more. It is up to you.

In essence, when RSI (2) is in overbought territory, then we need to sell and the opposite is true. He proposes many ways for the stop loss and target. For example the close of the very next bar, or a moving average, and one or two other methods). He prefers to use the Daily 200 MA to filter the setups and identify the trend.
He also talks about a new calculation of RSI called (Cumulative RSI) of which he sums the RSI value for a number of days and then trades based on this figure. I am not using here this cumulative RSI.

Connors talks about other (simple) systems of which his low RSI setting system can be combined with. I am not discussing them here.

"I do strongly advise you to read the book. Your understanding may be different and conclusions are different than mine. I myself when I re-read any book, I find new information or correct my initial misunderstanding).

The rules of this system - RSI(2) system Ver 1- I am going to work on tonight or tomorrow are simple. For Longs, we buy when rsi (2) dips below Level 20 and crosses it back up. Then we target the touch of Level 80 and the Stop Loss is when RSI hits Level 20. Shorts are the opposite.

I believe that everyone should try different inputs. I will first start with the Backtesting template. If the results are good, I will work on an Excel RDT dashboard.
The rules are flexible and anyone can change them. And again, I am not following exactly what Connors suggested in his book. I am just testing the strength of RSI(2). We could then use it with other systems or use it on its own etc...

Inputs:
1- RSI (2) Fixed.
2- SMA (60) fixed. (For trend filtering)
3 -RSI Long Signal Level (i.e if crossed above go long if other conditions are satisfied- Example: 20)
4- RSI Short Signal Level (i.e if crossed below go short if other conditions are satisfied - Example: 80)
5-For Long signal: Maximum RSI Level for entering Long based on the current close of RSI.(i.e No Long if current RSI closes above this level. Example: If current RSI close is above 60 or touched 80, RSI is already close to or at its potential target)
6-For Short Signals: Maximum RSI Level for entring short based on the current close of RSI. (i.e No short if current RSI closes below this level. Example: The opposite of above)
7- RSI Long TP Level
8- RSI Long SL Level
9- RSI Short TP Level
10- RSI Short SL Level

TF: Any...I will test with Daily first then go lower.

System Rules:
Long:
If:
1-Close is > SMA (60) And
2-RSI 1 bar ago is < (20) and current close > (20) And
3-Current RSI close is <(80)
Then: Entry is at the open of the new Bar.

Long Stop Loss:
RSI(2) close is <=(20)

Long Target Profit:
RSI (2) close is >=(80)
-----------------
Short:

If:
1-Close is < SMA (60) And
2-RSI 1 bar ago is > (80) and current close < (80) And
3-Current RSI close is < (20)
Then: Entry is at the open of the new Bar.


Stop Loss:
Short Stop Loss: RSI(2) close is >=(80)

Target Profit:
RSI(2) close <=(20)

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

I want in the future to get enough one-minute data to cover all the tested period of any TF as it will be better to test the exact price of Target Profit and Stop Loss when RSI crosses a level.
-----------
  • #392
  • Edited 6:02pm Feb 14, 2021 5:38pm | Edited 6:02pm
Quoting mtharwat
RSI (2) system.V1 This system is inspired by "Short Term Strategies that Work" By Larry Connors. I have modified the system and changed it to test the strength of RSI(2). The book is a good read, and Connors claims to have tested RSI (2) on millions of data series. RSI(2) can be RSI(3) or more. It is up to you. In essence, when RSI (2) is in overbought territory, then we need to sell and the opposite is true. He proposes many ways for the stop loss and target. For example the close of the very next bar, or a moving average, and one or two other...

@Garfield,
I have created the logic in Excel for backtesting but then I realized the VBA for backtesting would need to change based on the SL and TP rules of the indicator cross. I do not want you to work again on a new VBA as I need to figure out a solution myself. There will always be a modification. I just wish if I come up with a the logic (for various Stop Loss and Take Profits) by using simple Excel Formulas.

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

Any way, if any one wants an Excel RTD Dashboard for my RSI 2 system in my previous post (for signals) to analyze, pls let me know.
  • #393
  • Feb 15, 2021 1:46am Feb 15, 2021 1:46am
Quoting mtharwat
{quote} @Garfield, I have created the logic in Excel for backtesting but then I realized the VBA for backtesting would need to change based on the SL and TP rules of the indicator cross. I do not want you to work again on a new VBA as I need to figure out a solution myself. There will always be a modification. I just wish if I come up with a the logic (for various Stop Loss and Take Profits) by using simple Excel Formulas. --------------------------------- Any way, if any one wants an Excel RTD Dashboard for my RSI 2 system in my previous post (for...
No problem, happy to help out whenever you need it!!!
Trading is SIMPLE not EASY.
  • #394
  • Edited 3:32am Feb 15, 2021 1:47am | Edited 3:32am
Quoting simnz
Microsoft Excel Becomes a Proper Programming Language https://thenewstack.io/microsoft-exc...ming-language/
Great info, will keep an eye on it for progress.
Trading is SIMPLE not EASY.
  • #395
  • Feb 15, 2021 10:13am Feb 15, 2021 10:13am
VBA has No Block Scope

https://www.spreadsheetsmadeeasy.com...1fde-543917701
Practice makes a person perfect
  • #396
  • Feb 16, 2021 12:27pm Feb 16, 2021 12:27pm
Kicking off a live account using excel RTD - multi-strategy
Attached Image
Trading is SIMPLE not EASY.
  • #397
  • Edited Feb 17, 2021 2:21am Feb 16, 2021 1:14pm | Edited Feb 17, 2021 2:21am
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 cmd = CreateObject("FXBlueLabs.ExcelCommand")

strResult = cmd.SendCommand("31011134", "BUY", "s=XAUUSD|v=1000|magic=007|comment=Test", 5)

Trading is SIMPLE not EASY.
  • #398
  • Feb 18, 2021 8:25am Feb 18, 2021 8:25am
hi guys,

who know how to import live data to excel from MT5 ?
  • #399
  • Feb 18, 2021 3:23pm Feb 18, 2021 3:23pm
Quoting nicholas87
hi guys, who know how to import live data to excel from MT5 ?
I guess the same way how MT4 does! Since there's no more DDE Server included in MT5 it needs a third-party solution. Maybe this will help:

DDE - Server - Experte für den MetaTrader 5

Best of luck and stay green always!

Jibala
PDF & BCC (Patience Discipline Focus & Belief Confidence Consistency)
  • #400
  • Feb 18, 2021 3:41pm Feb 18, 2021 3:41pm
Quoting nicholas87
hi guys, who know how to import live data to excel from MT5 ?
Excel RTD works fine on MT5 for all FX pairs. you need to request MT5 version of excel RTD from your broker.
Trading is SIMPLE not EASY.
0 traders viewing now