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

  • #121
  • Nov 16, 2020 11:54pm Nov 16, 2020 11:54pm
Quoting dodiep
Thank mtharwat, I figured out my problem, due to internet latency and maybe my PC too, so the open price from RTD and history is not the same. When I restart it several time, it's fine now.
That is great to know
  • #122
  • Nov 17, 2020 3:08am Nov 17, 2020 3:08am
I tried to send command Buy or sell order. It works well, but when I change command "Buy" to "Close". It doesn't work, do you have any ideal about that?
  • #123
  • Nov 17, 2020 5:19am Nov 17, 2020 5:19am
Quoting dodiep
I tried to send command Buy or sell order. It works well, but when I change command "Buy" to "Close". It doesn't work, do you have any ideal about that?
When you say you tried to send command Buy or Sell, did you mean by manually doing it or were you referencing another cell? For example when cell A2 is 1, then buy EURUSD.

I have not tried the commands for executing trades yet because I was more concerned with finding a way to execute orders by referencing another cell.
  • #124
  • Nov 17, 2020 11:19am Nov 17, 2020 11:19am
Quoting mtharwat
Retrieving Indicators Data with "Concat" Function: Attached a workbook with a number of indicators with Concat function. It is tricky sometimes. If you need other indicators, it will be much easier to just change the indicator name in the formula. For example, @RSI could be @CCI, for indicators that require one input. If you are new to EXCEL in general, look at the dollar sign and see which cells are fixed and which ones are not to learn about it. Each sheet in the workbook represents a time frame. If you need more time frames, then just copy the...
Thank you for sharing this file. I will try to use it as a template to get multiple indicator and TF info and then have 1 master sheet to do the analysis and trade recommendation.
Trading is SIMPLE not EASY.
  • #125
  • Nov 18, 2020 2:03am Nov 18, 2020 2:03am
Quoting mtharwat
{quote} When you say you tried to send command Buy or Sell, did you mean by manually doing it or were you referencing another cell? For example when cell A2 is 1, then buy EURUSD. I have not tried the commands for executing trades yet because I was more concerned with finding a way to execute orders by referencing another cell.
Nope, I just changed Buy order button to Close order (also so in VBA) but it doesn't work. Did you try it ?
  • #126
  • Nov 18, 2020 5:37am Nov 18, 2020 5:37am
Quoting mtharwat
One more formula for calculating Currency strength. This is something I created and I want to share it with you. I am calculating strength in three time frames. In each time frame, the formula is as follows (Current Price - Low)/Low * 100 The result will always be positive (Current Price - High)/High * 100 The result will always negative Add the two results and if the net one is positive, it implies (potential) bullishness, and the opposite is true. ----------------- I am attaching two workbooks: (One for Excel RTD) and another for (DDE MT4). The...
Hey mtharwat, your DDE is excellent... Thank you so much for sharing. It provides such a quick and easy snapshot of the currency strength.
I have a simple question: is there a way (formula) to import in excel, using DDE, the freemargin value of a pair?
Attached Image (click to enlarge)
Click to Enlarge Name: DDE_Excellent.PNG Size: 146 KB
  • #127
  • Nov 18, 2020 7:07am Nov 18, 2020 7:07am
Quoting garfield75
{quote} Thank you for sharing this file. I will try to use it as a template to get multiple indicator and TF info and then have 1 master sheet to do the analysis and trade recommendation.
You are welcome garfield75. If you need other indicators, let me know. I can share another template.
  • #128
  • Nov 18, 2020 7:08am Nov 18, 2020 7:08am
Quoting dodiep
{quote} Nope, I just changed Buy order button to Close order (also so in VBA) but it doesn't work. Did you try it ?
I tried with VBA referencing another cell but no luck.
  • #129
  • Nov 18, 2020 7:13am Nov 18, 2020 7:13am
Quoting rosspetX
{quote} Hey mtharwat, your DDE is excellent... Thank you so much for sharing. It provides such a quick and easy snapshot of the currency strength. I have a simple question: is there a way (formula) to import in excel, using DDE, the freemargin value of a pair? {image}
You are welcome and very happy you find it that helpful.


No, unfortunately, I do not know the request formula for the free margin value of a pair in DDE. I also checked MQL4 https://www.metatrader4.com/en/tradi...lp/service/dde and maybe they do not offer it.
  • #130
  • Nov 18, 2020 7:21am Nov 18, 2020 7:21am
Quoting mtharwat
{quote} You are welcome and very happy you find it that helpful. No, unfortunately, I do not know the request formula for the free margin value of a pair in DDE. I also checked MQL4 https://www.metatrader4.com/en/tradi...lp/service/dde and maybe they do not offer it.
OK, thank you. It's a shame... we should be able to get more data from the DDE server; would be helpful to do more complex things in excel.
  • #131
  • Nov 18, 2020 7:44am Nov 18, 2020 7:44am
Quoting mtharwat
{quote} You are welcome and very happy you find it that helpful. No, unfortunately, I do not know the request formula for the free margin value of a pair in DDE. I also checked MQL4 https://www.metatrader4.com/en/tradi...lp/service/dde and maybe they do not offer it.
Hi mtharwat, sorry to bother you again with another question. I tried to use your excel sheet with 2 different MT4s (2 different brokers). I named the 2 excel files differently and put them in the relevant MT4 folders, however, regardless of the different file locations and different file names, they both retrieve data only from one of the 2 MT4s... Do you know of any way to make these 2 different excel sheets retrieve data from the 2 different MT4s?
  • #132
  • Nov 18, 2020 5:55pm Nov 18, 2020 5:55pm
Quoting rosspetX
{quote} Hi mtharwat, sorry to bother you again with another question. I tried to use your excel sheet with 2 different MT4s (2 different brokers). I named the 2 excel files differently and put them in the relevant MT4 folders, however, regardless of the different file locations and different file names, they both retrieve data only from one of the 2 MT4s... Do you know of any way to make these 2 different excel sheets retrieve data from the 2 different MT4s?
Hello rosspetX

You can bother me any time, no problem at all. We all mostly have the same questions and can only find answers by asking.

For your question, I had the same issue. When I open two MT4 accounts, I can not control which data feed, the DDE sheet will gather data from. I do not know if it is a limitation or is there a way around it.
  • #133
  • Nov 18, 2020 6:17pm Nov 18, 2020 6:17pm
Quoting mtharwat
One more formula for calculating Currency strength. This is something I created and I want to share it with you. I am calculating strength in three time frames. In each time frame, the formula is as follows (Current Price - Low)/Low * 100 The result will always be positive (Current Price - High)/High * 100 The result will always negative Add the two results and if the net one is positive, it implies (potential) bullishness, and the opposite is true. ----------------- I am attaching two workbooks: (One for Excel RTD) and another for (DDE MT4). The...

Hello every one,

I just noticed a small error in the DDE Workbook. The first sheet for pairs strength and quotes has nothing wrong, while the second sheet for calculating overall strength for each currency group had a couple of errors referencing wrong cells.
I have corrected the second sheet and used Vlook up (in case you do not have Office 365 with Xlookup).

Attached Image (click to enlarge)
Click to Enlarge Name: Screenshot (6).png Size: 97 KB
Attached File(s)
File Type: xlsx New CS Formula (Close relative to High and Low) DDE (Corrected).xlsx   40 KB | 569 downloads
  • #134
  • Nov 18, 2020 8:13pm Nov 18, 2020 8:13pm
Quoting rosspetX
{quote} OK, thank you. It's a shame... we should be able to get more data from the DDE server; would be helpful to do more complex things in excel.
I totally agree...
  • #135
  • Nov 19, 2020 3:34am Nov 19, 2020 3:34am
Quoting mtharwat
{quote} You are welcome garfield75. If you need other indicators, let me know. I can share another template.
Hi mtharwat,

Do you think it is possible to calculate in excel Fib levels from previous leg an trigger alerts when price reaches a specific level (61.8 or 50) ?

Please share any other execl templates you have with RTD, I am trying to work out how to get multiple Stochatics values in there.

Cheers
Garfield75
Trading is SIMPLE not EASY.
  • #136
  • Nov 19, 2020 11:04am Nov 19, 2020 11:04am
Does anyone know how to import account history/ Active Orders in to excel?
Automatically, without copy and pasting the CSV?

thx,
  • #137
  • Nov 20, 2020 11:33am Nov 20, 2020 11:33am
Quoting blablabla
Does anyone know how to import account history/ Active Orders in to excel? Automatically, without copy and pasting the CSV? thx,
The list of tickets includes both open positions and pending orders.
Attached Image (click to enlarge)
Click to Enlarge Name: b9773ce08cf33724c014ca759682076f.png Size: 57 KB

Closed orders are not possible with RTD.

Best of luck and stay green always!

Jibala
PDF & BCC (Patience Discipline Focus & Belief Confidence Consistency)
  • #138
  • Nov 20, 2020 11:35am Nov 20, 2020 11:35am
Quoting rosspetX
{quote} OK, thank you. It's a shame... we should be able to get more data from the DDE server; would be helpful to do more complex things in excel.
DDE offers some simple functions only!

Best of luck and stay green always!

Jibala
PDF & BCC (Patience Discipline Focus & Belief Confidence Consistency)
  • #139
  • Edited 9:14pm Nov 20, 2020 8:54pm | Edited 9:14pm
Quoting garfield75
{quote} Hi mtharwat, Do you think it is possible to calculate in excel Fib levels from previous leg an trigger alerts when price reaches a specific level (61.8 or 50) ? Please share any other execl templates you have with RTD, I am trying to work out how to get multiple Stochatics values in there. Cheers Garfield75

I am working on it.
  • #140
  • Nov 20, 2020 9:06pm Nov 20, 2020 9:06pm
Quoting garfield75
{quote} Hi mtharwat, Do you think it is possible to calculate in excel Fib levels from previous leg an trigger alerts when price reaches a specific level (61.8 or 50) ? Please share any other execl templates you have with RTD, I am trying to work out how to get multiple Stochatics values in there. Cheers Garfield75

I attached the previous indicators template with stochastics added. In case you need a list of other indicators, list them for me.

Attached File(s)
File Type: xlsx Indicators Data with Concat Function (Stochastics added).xlsx   27 KB | 597 downloads
Still working on the Fibonacci levels.
0 traders viewing now