Agree downloading history data from MT4 will give lot more bars and may have been a better option in hindsight for this analysis. I prefer DDE Server or Excel RTD because it can continuously stream data into excel to be able to do analysis in ...

New Year Stress-free trading system for traders with patience

Thanks Simnz for the offer. All good, I have IG and Pepperstone live accounts to get data.

MT4 to Excel through Excel RTD (Finally!)

Hey Mtharwat, Dont worry, I just finished it. Will test it on Monday to make sure it works properly and then post it here.

MT4 to Excel through Excel RTD (Finally!)

Weekend Project taking shape using Excel RTD data, will post it after initial testing.

MT4 to Excel through Excel RTD (Finally!)

Based on Excel RTD limitation, I could only extract around 500 bars for 1 Hr TF to for analysis. Data is from 11th Dec 2020 to 14th Jan 2021 for US30. I have broken it down by 24 hours based on GMT and different session times.

New Year Stress-free trading system for traders with patience

Hey Simnz, Will have a look at WS30 this weekend to come up with price movement matrix. If you want it aligned to market price over 24 hours period, then the lowest TF for analysis would be 1 Hr. Gut feel London & New york overlap known as "NyLon" ...

New Year Stress-free trading system for traders with patience

Hi Sasschrist Please elaborate on your solution with some examples shared here. Cheers

MT4 to Excel through Excel RTD (Finally!)

Had a look at GBPJPY 250 candles for time frame of 5 Min, 15 Min, 30 Min & 60 Min. Without having a clear hypothesis, it is not possible to do deep analysis on the probability of profit or loss. Attached excel has all the data.

New Year Stress-free trading system for traders with patience

Yes. That is the one.

MT4 to Excel through Excel RTD (Finally!)

Hey Simnz, I can have crack at getting some stats in excel. Give me 3 instruments and timeframes that you want me to try. Cheers Garfield.

New Year Stress-free trading system for traders with patience

WOW, have you done this in excel RTD template? If it is in excel RTD would you mind sharing the template or cell function/formula used? Cheers Garfield

MT4 to Excel through Excel RTD (Finally!)

Hi Mtharwat, What is your thought on creating this in excel rtd for all timeframe? Cheers Garfield

MT4 to Excel through Excel RTD (Finally!)

Hey Nicholas, As JibalaPasan mentioned you will need to use and another cell to track value, which can be a number or text or timestamp. I use timestamp as the flag to make sure there is a certain amount of time delay between trade alerts & ...

MT4 to Excel through Excel RTD (Finally!)

Template attached with VBA code. Since the site doesn't allow for any VBA/Macro enabled file to be updated. I have changed the extension to .xls so I could upload it. Please download the file. change the extension from .xls to .xlsm before opening ...

MT4 to Excel through Excel RTD (Finally!)

Hey Nicholas87, This is the exact code you need to execute trades. Private Sub Worksheet_Calculate() Set cmd = CreateObject("FXBlueLabs.ExcelCommand") If Range("A1") >= 10 Then strResult = cmd.SendCommand("xxxxxx", "BUY", "s=EURUSD|v=1000", 5) End ...

MT4 to Excel through Excel RTD (Finally!)

Hey Nicholas, you will need to write the code in VBA within the calculating section. Private Sub Worksheet_Calculate() --- write your code here --- End Sub Cheers

MT4 to Excel through Excel RTD (Finally!)

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 ...

MT4 to Excel through Excel RTD (Finally!)

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 ...

MT4 to Excel through Excel RTD (Finally!)

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.

MT4 to Excel through Excel RTD (Finally!)

@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 ...

MT4 to Excel through Excel RTD (Finally!)