Menu
Sister Sites

Options

Bookmark Thread

First Page First Unread Last Page Last Post

Printable Version

Similar Threads

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

Has anyone made an Excel spreadsheet to analyze your MT4 trades? 0 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!)

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.
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.
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.
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.
-----------------------
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,
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.
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
File Type: xlsx Fib Levels.xlsx   22 KB | 56 downloads
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 Images (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.
  • Post #169
  • Quote
  • Edited at 10:23pm Nov 24, 2020 9:45pm | Edited at 10: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..

---------------
  • Post #170
  • Quote
  • Edited at 10:23pm Nov 24, 2020 9:55pm | Edited at 10: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.
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.
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.
Happy Thanksgiving to all Christians...
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,

  • Post #175
  • Quote
  • Edited Nov 27, 2020 12:12am Nov 26, 2020 3:53pm | Edited Nov 27, 2020 12:12am
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.
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,
  • Post #177
  • Quote
  • Edited at 3:48am Nov 30, 2020 3:17am | Edited at 3: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
File Type: xlsx Breakout for 28 Pairs.xlsx   50 KB | 88 downloads
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.
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
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?
1 member viewing: