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

  • #161
  • Nov 23, 2020 9:57am Nov 23, 2020 9:57am
Coming along, have 15 Min and 5 min TF for the testing purpose to integrate with Telegram for instant messaging for Alert when a trade setup is confirmed.
Attached Image (click to enlarge)
Click to Enlarge Name: 814965570ba7bafdd9c82d3795f4c4c0.png Size: 100 KB
Trading is SIMPLE not EASY.
  • #162
  • Nov 23, 2020 7:46pm Nov 23, 2020 7:46pm
Quoting mtharwat
{quote} I will look into it after the session. I may need to retrieve the last 20 bars for each timeframe to make sure the swing occurred within these bars. I think 20 is enough. 10 bars was not enough for all pairs when I sampled it once.
I got caught in trading yesterday till very late and this morning have a couple of things to do.
Will finish it as soon as I can.
  • #163
  • Nov 23, 2020 10:12pm Nov 23, 2020 10:12pm
Quoting mtharwat
{quote} ----If you are able to work on the SMS alert, it will be great. I was trying to find a VBA to record the time of occurrence of conditions but did not find one. An email or similar will be great to get notified and to backtest when conditions are met. I will be using this to test group currency strength. -----Let us break your strategy into pieces. What you wish to do is to have a dashboard across multiple time frames (6 from your picture) and you have 7 indicators/requests from EXCEL RTD and one indicator/request for the current price. So...
Here step.

 

  1. Create a Telegram Bot
  2. Create a Chat Room
  3. Add the BOT as Admin to chat room.

Above steps can be found via searching the web. Ping me directly of you get stuck on any of the steps.

Code snippet below can be included in VBA to trigger notification whenever a specific condition is met.
Replace TokenID with BOT API Key
Replace ID with Chatroom ID
Replace Testing with whatever text/msg content

Set objHTTP = CreateObject("MSXML2.ServerXMLHTTP")
objHTTP.Open "POST", "https://api.telegram.org/bot<TokenId>/sendMessage?chat_id=<ID>text=Testing", False
objHTTP.setRequestHeader "Content-Type", "text/xml"
objHTTP.send (request)


Example of chat room msg screen

Attached Image (click to enlarge)
Click to Enlarge Name: d099e8c80c78f1920c50a8b3decbb91f.png Size: 59 KB
Trading is SIMPLE not EASY.
  • #164
  • Nov 24, 2020 6:49am Nov 24, 2020 6:49am
Quoting mtharwat
{quote} I will look into it after the session. I may need to retrieve the last 20 bars for each timeframe to make sure the swing occurred within these bars. I think 20 is enough. 10 bars was not enough for all pairs when I sampled it once.
Hello Garfield75,

I tried the best I can for three hours plus.
What I did is that I thought of a workbook dedicated to Fib calculations and the data needed.
I made three requests (Time of Bar, Swing High, Swing Low) for 22 previous bars * 28 Pairs. It was only for one-time frame and then I would copy the sheet for more time frames.
Excel was slow with me halfway and I had to restart it a couple of times. It then totally froze. This was why it took me this long time.
Anyway, I closed Excel and tried to restart the workbook but it did not open. I tried a couple of times without luck. I think I way exceeded the maximum number of requests.
I even closed MT4 and just opened Excel without the API but still, the file won't load.
-----------------------
  • #165
  • Nov 24, 2020 6:58am Nov 24, 2020 6:58am
Quoting garfield75
{quote} Here step. Create a Telegram Bot Create a Chat Room Add the BOT as Admin to chat room. Above steps can be found via searching the web. Ping me directly of you get stuck on any of the steps. Code snippet below can be included in VBA to trigger notification whenever a specific condition is met. Replace TokenID with BOT API Key Replace ID with Chatroom ID Replace Testing with whatever text/msg content Set objHTTP = CreateObject("MSXML2.ServerXMLHTTP") objHTTP.Open "POST", "https://api.telegram.org/bot<TokenId>/sendMessage?chat_id=<ID>text=Testing",...
Thank you.. Great!
I remember I read about telegram and Excel from an online source but the instructions were not clear.
Your steps are detailed and clear. I will try the steps as soon as I can.

Cheers,
  • #166
  • Nov 24, 2020 7:18am Nov 24, 2020 7:18am
Quoting mtharwat
{quote} Hello Garfield75, I tried the best I can for three hours plus. What I did is that I thought of a workbook dedicated to Fib calculations and the data needed. I made three requests (Time of Bar, Swing High, Swing Low) for 22 previous bars * 28 Pairs. It was only for one-time frame and then I would copy the sheet for more time frames. Excel was slow with me halfway and I had to restart it a couple of times. It then totally froze. This was why it took me this long time. Anyway, I closed Excel and tried to restart the workbook but it did not...

What I am working on now is to calculate fib levels for only the pairs that have their conditions met. This should not be an issue at all.
  • #167
  • Nov 24, 2020 9:43am Nov 24, 2020 9:43am
Quoting mtharwat
{quote} What I am working on now is to calculate fib levels for only the pairs that have their conditions met. This should not be an issue at all.

I have it ready now. Please check it and I will check it again tomorrow as I have not had enough time to test it. My head is spinning around. It took more time than I thought.
Attached Image (click to enlarge)
Click to Enlarge Name: 2020-11-25 (6).png Size: 26 KB

Attached Image (click to enlarge)
Click to Enlarge Name: 2020-11-25 (7).png Size: 26 KB


This Sheet will show if the trend is down or up and show 50 and 61.8 fib levels.
You can change the following:
Pair, Swing Bars, Confirmed or unconfirmed, Range of Pips from Fib level (How far from Fib).

The sheet will display the High and Low of the swing and the two fib levels. It will also show a down trend in red and the opposite in green. If the price is far more than the specified range of pips, the dashboard will display "wait".

Please let me know if any of the info is not correctly displayed and will check it again.
Attached File(s)
File Type: xlsx Fib Levels.xlsx   22 KB | 740 downloads
  • #168
  • Nov 24, 2020 2:53pm Nov 24, 2020 2:53pm
Quoting mtharwat
{quote} I have it ready now. Please check it and I will check it again tomorrow as I have not had enough time to test it. My head is spinning around. It took more time than I thought. {image} {image} This Sheet will show if the trend is down or up and show 50 and 61.8 fib levels. You can change the following: Pair, Swing Bars, Confirmed or unconfirmed, Range of Pips from Fib level (How far from Fib). The sheet will display the High and Low of the swing and the two fib levels. It will also show a down trend in red and the opposite in green. If the...
@mtharwat,
Thank you for putting in the effort of this, absolutely amazing. I will test it out.

Initial testing to check if this is correct AUDCAD on 4 Hr (excel) vs whats on 4 hr chart it seems to plot the previous leg.

On another note, do you have any suggestion or idea on how to create currency strength/weakness in excel RTD?
Attached Image(s) (click to enlarge)
Click to Enlarge Name: 522ea6be9d690908b32c62677d5ce3e6.png Size: 32 KB
Click to Enlarge Name: 4f941ce9a36f430423a67df1e29e40db.png Size: 63 KB
Trading is SIMPLE not EASY.
  • #169
  • Edited 9:23pm Nov 24, 2020 8:45pm | Edited 9:23pm
Quoting garfield75
{quote} @mtharwat, Thank you for putting in the effort of this, absolutely amazing. I will test it out. Initial testing to check if this is correct AUDCAD on 4 Hr (excel) vs whats on 4 hr chart it seems to plot the previous leg. On another note, do you have any suggestion or idea on how to create currency strength/weakness in excel RTD? {image} {image}

You are welcome, No problem at all.

Regarding the Fib Levels in Excel:

I have just put fractals indicator in MT4 and left the @swing indicator in Excel with the setting of 2 for swing bars and 0 for confirmed. They both should give same results.

Here is a shot for AUDCAD H4

Attached Image (click to enlarge)
Click to Enlarge Name: AUDCADH4.png Size: 66 KB


Excel is showing Upward Trend.
Attached Image (click to enlarge)
Click to Enlarge Name: 2020-11-25 (8).png Size: 31 KB


------

I want you to please to continue testing it by putting fractals indicator in MT4 and leaving the EXCEL Swing parameters the same (so they both match).
Remember that Fractals in MT4 will only show after the successive two bars have been printed.
Also maybe there is some latency and the Excel RTD EA needed to be refreshed (uninstalled and installed).

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

Let me know what you find..

---------------
  • #170
  • Edited 9:23pm Nov 24, 2020 8:55pm | Edited 9:23pm
Quoting garfield75
{quote} On another note, do you have any suggestion or idea on how to create currency strength/weakness in excel RTD? {image} {image}

Of course....
Maybe you have not been following the thread from the beginning.
So far, most of the workbooks I shared here are for different formulas for calculating Currency strength for single pairs and combining them for scoring Currency strength.

Have a look at the clip attachment at the top right of this page
Attached Image


The most recent one you will find is CSM based on Fractals.
There are other attachments as well that have keywords like CS (for Currency Strength).

I also describe the logic or the mathematical formulas behind measuring strength. So check the post before downloading.

----

EDIT: On a side note, I am leaning more towards CSM Based on Fractals. (However, this may change in the future).
I like its concept of deriving formulas. Play with the (Confirm/Unconirm) input so it may act as a breakout. For example, @Swing Bars can be 2 or three or 5 and an unconfirmed swing is chosen. In this case, when a bar breaks out the last three or 5 bars, we will not wait for confirmed successive bars. Or choose the confirmed swing (0 input), to give confirmed strength. I am still experimenting with both and I like it.

The whole idea of any Currency strength workbook I am sharing here is to give us a "Head-up" to where the current strength/momentum is. I myself check each chart individually every day (28 pairs and indices and metals and then stocks!)
I am getting old for this and I am really getting tired.
  • #171
  • Nov 24, 2020 9:20pm Nov 24, 2020 9:20pm
Quoting mtharwat
{quote} Of course.... Maybe you have not been following the thread from the beginning. So far, most of the workbooks I shared here are for different formulas for calculating Currency strength for single pairs and combining them for scoring Currency strength. Have a look at the clip attachment at the top right of this page {image} The most recent one you will find is CSM based on Fractals. There are other attachments as well that have keywords like CS (for Currency Strength). I also describe the logic or the mathematical formulas behind measuring...

some of the CS files were DDE that is why I didn't download them. no sure why, but DDE feed randomly crashes my excel so I don't use it.
Trading is SIMPLE not EASY.
  • #172
  • Nov 24, 2020 9:22pm Nov 24, 2020 9:22pm
Quoting garfield75
{quote} some of the CS files were DDE that is why I didn't download them. no sure why, but DDE feed randomly crashes my excel so I don't use it.
I edited my previous post so check it again pls

DDE was for those who do not have EXCEL RTD but is quite limited for sure. The files that are for DDE have "DDE" in the name of the attachmnet. So do not worry about it.
  • #173
  • Nov 26, 2020 5:09am Nov 26, 2020 5:09am
Happy Thanksgiving to all Christians...
  • #174
  • Nov 26, 2020 6:20am Nov 26, 2020 6:20am
Quoting garfield75
{quote} Here step. Create a Telegram Bot Create a Chat Room Add the BOT as Admin to chat room. Above steps can be found via searching the web. Ping me directly of you get stuck on any of the steps. Code snippet below can be included in VBA to trigger notification whenever a specific condition is met. Replace TokenID with BOT API Key Replace ID with Chatroom ID Replace Testing with whatever text/msg content Set objHTTP = CreateObject("MSXML2.ServerXMLHTTP") objHTTP.Open "POST", "https://api.telegram.org/bot<TokenId>/sendMessage?chat_id=<ID>text=Testing",...
Hi garfiled75,

I did the first two steps including

  1. Create a Telegram Bot
  2. Create a Chat Room


I got stuck on the VBA. My knowledge of VBA is weak.
I got this error message Compile Error - Sub or Function not defined.

The VBA I used is
Private Sub Worksheet_Change(ByVal Target As Range)
If Target.Address = "$B$4" Then
Call Mymacro
End If
Set objHTTP = CreateObject("MSXML2.ServerXMLHTTP")
objHTTP.Open "POST", "https://api.telegram.org/bot<API<Signals Excel>text=Testing", False
objHTTP.setRequestHeader "Content-Type", "text/xml"
objHTTP.send (request)
End Sub

$B$4 is the cell that its value will be changed based on another cell.

-------
Otherwise, can you please share with me your VBA (if your VBA is doing what I intend to do by sending a signal when a cell changes its value automatically and not manually)?

------

I know it is holidays now so take your time whenever you are available.
Thanks,

  • #175
  • Edited 11:12pm Nov 26, 2020 2:53pm | Edited 11:12pm
Quoting mtharwat
{quote} Hi garfiled75, I did the first two steps including Create a Telegram Bot Create a Chat Room I got stuck on the VBA. My knowledge of VBA is weak. I got this error message Compile Error - Sub or Function not defined. The VBA I used is Private Sub Worksheet_Change(ByVal Target As Range) If Target.Address = "$B$4" Then Call Mymacro End If Set objHTTP = CreateObject("MSXML2.ServerXMLHTTP") objHTTP.Open "POST", "https://api.telegram.org/bot<API<Signals Excel>text=Testing", False objHTTP.setRequestHeader "Content-Type", "text/xml" objHTTP.send...

The VBA I used is
Private Sub Worksheet_Change(ByVal Target As Range)
If Target.Address = "$B$4" Then
Call Mymacro
End If
Set objHTTP = CreateObject("MSXML2.ServerXMLHTTP")
objHTTP.Open "POST", "https://api.telegram.org/bot<API<Signals Excel>text=Testing", False
objHTTP.setRequestHeader "Content-Type", "text/xml"
objHTTP.send (request)
End Sub
-----------
I don't see the "Mymacro" being defined in your code, based on what you have shared.

1) if you are passing variables between functions then make sure it is a Global variable example "Public SMSTest As String"

2) if you are going to call/use the telegram msg multiple times set it as a separate function. in your VBA code above I didn't see "Chat ID" parameter

Private Sub TelegramMsg()

'Set objHTTP = CreateObject("MSXML2.ServerXMLHTTP")
'objHTTP.Open "POST", "https://api.telegram.org/bot<API Key>/sendMessage?chat_id=-<Chat ID>&text=" & SMSTest, False
'objHTTP.setRequestHeader "Content-Type", "text/xml"
'objHTTP.send (request)

End Sub


3) Call the "TelegramMsg() or assuming in your case "MyMacro" function when something it meets condition. In my case I have it in Worksheet_Calculate()

Private Sub Worksheet_Calculate()
Dim objMsg As Object, msgConf As Object
Dim a As Double
Dim b As Double
Dim c As Double
Dim fxValue As Double
Dim x As String
Dim rn As Range
Dim r As Range
Dim currenthour As Double
Dim FileNo As Integer
Dim ce As Range
Dim retval As Variant
Dim i As Long

' Daily Slingshot & Extreme Setup
For i = 7 To 35
If Range("H" & i).Value <> "Wait" Then
a = Abs(Now - Range("Y" & i).Value) * 86400 / 60
If a > 340 Then
SMSTest = Range("A" & i).Value & " Daily Chart Check for- " & Range("H" & i).Value
Range("Y" & i).Value = Now()
Call TelegramMsg
End If
End If
Next

End Sub



Let me know if that resolves your error.
Trading is SIMPLE not EASY.
  • #176
  • Nov 30, 2020 1:45am Nov 30, 2020 1:45am
Quoting garfield75
{quote} The VBA I used is Private Sub Worksheet_Change(ByVal Target As Range) If Target.Address = "$B$4" Then Call Mymacro End If Set objHTTP = CreateObject("MSXML2.ServerXMLHTTP") objHTTP.Open "POST", "https://api.telegram.org/bot<API<Signals Excel>text=Testing", False objHTTP.setRequestHeader "Content-Type", "text/xml" objHTTP.send (request) End Sub ----------- I don't see the "Mymacro" being defined in your code, based on what you have shared. 1) if you are passing variables between functions then make sure it is a Global variable example "Public...

Very much appreciated garfiled75. Thank you for addressing it thoroughly.

Because of my lack of knowledge with VBA, I need to sit tight and allocate a morning for it. I have tried a bit but it did not work still with me. It was not because of the lack of your instructions, but rather because of my poor knowledge of VBA.

I at least sorted out what I need the VBA to do for me. A message to be sent when a cell changes value within a range. For example: If cell A1 is in the range of (70 to 100) then send a message only once. When cell A1 goes below 70 or above 100 and then comes back to the range, then send a message again for once.

I will be in touch again and update you...

Regards,
  • #177
  • Edited 2:48am Nov 30, 2020 2:17am | Edited 2:48am
Breakout Dashboard...

It is becoming a favorite and has traded the last three trades (in my other thread) based on it. Of course, I do not trade blindly based on a dashboard only but use it as a head-up for where I should look for an anticipated breakout.

Breakout Dashboard:
It is based on the breakout of fractals and you can choose the number of fractals and confirm or un-confirm it. When price breaks out, it shows how much percentage it has moved either up or down above/below the recent swing (high/low). The calculations are based on high swings (The high of the Swing/Fractal) and the opposite for low swings.


The sheet (Master Sheet Sorted) is showing the strongest and weakest. There are two columns. The first one is for breaking out pairs while the other is for the price range of the time frame being used. The calculation in the second column is the current price-low/low to show the percentage of the move for any time frame. For example, you may check H4 for breakouts and Weekly for range.

Attached Image (click to enlarge)
Click to Enlarge Name: 2020-11-30 (1).png Size: 97 KB

In case you do not want the chart in Excel, then delete the "Candlestick" sheet to reduce the number of requests.
Attached File(s)
File Type: xlsx Breakout for 28 Pairs.xlsx   50 KB | 773 downloads
  • #178
  • Nov 30, 2020 2:17am Nov 30, 2020 2:17am
Quoting mtharwat
{quote} Very much appreciated garfiled75. Thank you for addressing it thoroughly. Because of my lack of knowledge with VBA, I need to sit tight and allocate a morning for it. I have tried a bit but it did not work still with me. It was not because of the lack of your instructions, but rather because of my poor knowledge of VBA. I at least sorted out what I need the VBA to do for me. A message to be sent when a cell changes value within a range. For example: If cell A1 is in the range of (70 to 100) then send a message only once. When cell A1 goes...
Happy to help and return the favour.

so your Logic/Code should look like this as part of Worksheet_calculate module. The C1 value will act as a Flag to track when the range moves out of the range and comes back to trigger the msg.


if A1 is > 70 and A1< 100 then
If C1.value ="Off"
Call Telegram msg
C1.value = "On"
End if
End if

if A1 is < 70 and A1> 100 then
C1.value = "Off"
End if


if A1 is > 70 and A1< 100 then
Send a message via telegram
C1.value = "On"
End if
Trading is SIMPLE not EASY.
  • #179
  • Dec 10, 2020 12:15pm Dec 10, 2020 12:15pm
  •  moursi
  • | Joined Dec 2011 | Status: don't try to change the world .... | 78 Posts
hi all have a good day i look for adx formula for RTD something like that the rsi =RTD("fxbluelabs.excelrtd", , "10000001", "@rsi,GBPUSD,M1,14,0") but i need for ADX help me please if you can
Rule #1: Never Lose Money Rule #2: Never Forget Rule Number One
  • #180
  • Dec 16, 2020 5:56am Dec 16, 2020 5:56am
Quoting moursi
hi all have a good day i look for adx formula for RTD something like that the rsi =RTD("fxbluelabs.excelrtd", , "10000001", "@rsi,GBPUSD,M1,14,0") but i need for ADX help me please if you can

Hi moursi,

I have tried to get ADX and DMI but with no luck. I tried @adx and for DMI something like @dmip and @dmiplus but did not work. Maybe I would try again with @dmi+ve....FX Blue labs on their website do not say anything about the list of indicators they enable nor what names they have to retrieve them in Excel.
The only indicators I am sure of are the ones listed in the PDF. I am not sure if these indicators are the only ones we can retrieve their data or are there more?
0 traders viewing now