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

  • #541
  • May 30, 2021 9:26am May 30, 2021 9:26am
Quoting garfield75
{quote} Try the code below to see if this works. -------------------------------- Private Sub Worksheet_Calculate() Dim X As Integer Set cmd = CreateObject("FXBlueLabs.ExcelCommand") For X = 3 To 30 If Cells(X, 4) = "Buy" And Cells(X, 6) = "You Can Trade" Then strResult = cmd.SendCommand(Cells(1, 2), "BUY", "s=" & Cells(X, 1) & "|v=1000", 5) End If If Cells(X, 4) = "Sell" And Cells(X, 6) = "You Can Trade" Then strResult = cmd.SendCommand(Cells(1, 2), "SELL", "s=" & Cells(X, 1) & "|v=1000", 5) End If Next X End Sub
Thanks... I will try it when the market opens..
  • #542
  • Edited 5:54am May 31, 2021 5:23am | Edited 5:54am
Quoting garfield75
{quote} Try the code below to see if this works. -------------------------------- Private Sub Worksheet_Calculate() Dim X As Integer Set cmd = CreateObject("FXBlueLabs.ExcelCommand") For X = 3 To 30 If Cells(X, 4) = "Buy" And Cells(X, 6) = "You Can Trade" Then strResult = cmd.SendCommand(Cells(1, 2), "BUY", "s=" & Cells(X, 1) & "|v=1000", 5) End If If Cells(X, 4) = "Sell" And Cells(X, 6) = "You Can Trade" Then strResult = cmd.SendCommand(Cells(1, 2), "SELL", "s=" & Cells(X, 1) & "|v=1000", 5) End If Next X End Sub
Thanks Garfield,
It works great.

Now I have two questions please:
1- If I want to add Target profit, Stop Loss, trailing, etc , then I can simply add another (IF) statement and end (IF) before Next X . Am I right?

2- The use of the (Switch) I mentioned does not trigger quickly enough. In other words, sometimes two or three positions are opened very quickly before the (Open Trades column) shows No trade to be taken. Does this have to do with the consistency section in the PDF Guide? The one that mentions Reader Lock and Reader Unlock?
  • #543
  • May 31, 2021 6:36am May 31, 2021 6:36am
I am unable to establish connectivity between MT4 and Excel on my virtual PC.

I think I know the reason but do not know what is causing it or how to fix it.

Once I apply expert advisor on the chart, it shows the smiley face and every box is ticked, etc.., however, the small pop-up window that always accompanies Excel RTD EA does not appear. I think this is the reason I can not establish the connection.

I do not know what is causing this issue and how to launch this pop-up window. I re-applied the EA many times and restarted MT4 many times.

It must be something with security settings in the server. I tried to navigate through the settings but could not figure it out.
  • #544
  • May 31, 2021 7:15am May 31, 2021 7:15am
Quoting mtharwat
I am unable to establish connectivity between MT4 and Excel on my virtual PC. I think I know the reason but do not know what is causing it or how to fix it. Once I apply expert advisor on the chart, it shows the smiley face and every box is ticked, etc.., however, the small pop-up window that always accompanies Excel RTD EA does not appear. I think this is the reason I can not establish the connection. I do not know what is causing this issue and how to launch this pop-up window. I re-applied the EA many times and restarted MT4 many times. It must...
Is excel installed on your virtual pc? Who is the provider?
Trading is SIMPLE not EASY.
  • #545
  • May 31, 2021 7:18am May 31, 2021 7:18am
Quoting mtharwat
{quote} Thanks Garfield, It works great. Now I have two questions please: 1- If I want to add Target profit, Stop Loss, trailing, etc , then I can simply add another (IF) statement and end (IF) before Next X . Am I right? 2- The use of the (Switch) I mentioned does not trigger quickly enough. In other words, sometimes two or three positions are opened very quickly before the (Open Trades column) shows No trade to be taken. Does this have to do with the consistency section in the PDF Guide? The one that mentions Reader Lock and Reader Unlock?
1. Yes, make sure to get the syntex right.
2. You will need to pause the calculation, that is the only way to get around this issue. It took me a long time to figure this one out. I will send you the line of code tomorrow
Trading is SIMPLE not EASY.
  • #546
  • May 31, 2021 7:28am May 31, 2021 7:28am
Quoting garfield75
{quote} Is excel installed on your virtual pc? Who is the provider?
I installed office 365 myself.
The provider is Binary Lane (server in Sydney)
  • #547
  • Edited 8:09am Jun 1, 2021 6:19am | Edited 8:09am
Deleted
  • #548
  • Jun 16, 2021 7:26pm Jun 16, 2021 7:26pm
I don't speak English well. Can you please tell me if it is possible and how this command would look like in visual basic
=RTD("fxbluelabs.excelrtd";;account number;"@bh, "symbol",H4,close,1")

Thank you
  • #549
  • Jun 19, 2021 3:15am Jun 19, 2021 3:15am
Quoting garfield75
{quote} 1. Yes, make sure to get the syntex right. 2. You will need to pause the calculation, that is the only way to get around this issue. It took me a long time to figure this one out. I will send you the line of code tomorrow
Hi garfield75,
Is it possible to create a symbols Excel dashboard for CFDs offered by a MT4 broker generating the excel/csv spreadsheet (using excellent scripts and indicators coded by FF member Bluerain for raw dump) as well as for display on the MT4 chart.

BlueRain has modified an excellent CFD scanner making it full of statistics. But it is good only for an advanced trader.

Attached Image (click to enlarge)
Click to Enlarge Name: 9048d8e9663db31c5fbec2146a2b1bc2.png Size: 252 KB

Indicators attached
A user-friendly can better be created in Excel Dashboard which will help any manual trader act promptly for making the trading decisions based on price being close
to various data points.

to Stop Hunt Zone, exhaustion as shown by ADR% and Hi-Low proximity to the current Price. Excel can provide an excellent scanner for CFD symbols.
Attached Image (click to enlarge)
Click to Enlarge Name: Dashboard view of symbols.png Size: 254 KB


Indicator to generate csv/excel spreadsheet in the MT4 fiiles is here. https://www.forexfactory.com/thread/...5#post13226425

Blue Rain has also coded a Two days Open Close price difference indicator to mark stop hunt and trader trap zones.
If you combine both the CFD dashboard as a scanner and the logic of Two days indicator (indicator attached) it should look like this
Attached Image (click to enlarge)
Click to Enlarge Name: dashboard for stop hunt excel idea.png Size: 1.5 MB

The indicator is attached. two days open close lines

How to use the index to read previous high lows is explained here:

https://www.forexfactory.com/thread/...9#post13273499
https://www.forexfactory.com/thread/...5#post13273505
https://www.forexfactory.com/thread/...9#post13197819
Attached File(s)
File Type: mq4 Two Days Open Close Lines with PipDiff.mq4   12 KB | 425 downloads
File Type: mq4 FXTT_Fx_Scanner 2.13 [3 MAs].mq4   123 KB | 438 downloads
File Type: mq4 FXTT_Fx_Scanner 2.12.mq4   108 KB | 433 downloads
Practice makes a person perfect
  • #550
  • Jun 19, 2021 3:18am Jun 19, 2021 3:18am
CFD asset symbols are generally classified in Asset Class.

Small CFD brokers (95% are market makers while 5% use futures as CFDs) offer less than 200
Pepperstone:
Total Markets: 178
[highlight=rgba(0, 0, 0, 0.05)]Forex Pairs: [/highlight]36
[highlight=rgba(0, 0, 0, 0.05)]Commodities: [/highlight]16
[highlight=rgba(0, 0, 0, 0.05)]Indices: [/highlight]14
[highlight=rgba(0, 0, 0, 0.05)]UK Stocks: [/highlight]0
[highlight=rgba(0, 0, 0, 0.05)]US Stocks: [/highlight]64
IG
Total Markets: 17,000
[highlight=rgba(0, 0, 0, 0.05)]Forex Pairs: [/highlight]51
[highlight=rgba(0, 0, 0, 0.05)]Commodities: [/highlight]38
[highlight=rgba(0, 0, 0, 0.05)]Indices: [/highlight]34
[highlight=rgba(0, 0, 0, 0.05)]UK Stocks: [/highlight]3,925
[highlight=rgba(0, 0, 0, 0.05)]US Stocks: [/highlight]6,352

Symbols information is lifted from the broker's platform.

2. Sample Market Info, Deposit Currency is USD
MarketInfo(OrderSymbol(),MODE_LOTSIZE)
ODL Securities
ODL-MT4 Demo

Report for GLD
847.1 Low day price.
881.65 High day price.
2008.05.01 18:33:43 The last incoming tick time (last known server time).
851.2 Last incoming bid price. For the current symbol, it is stored in the predefined variable Bid
851.7 Last incoming ask price. For the current symbol, it is stored in the predefined variable Ask
0.01 Point size in the quote currency. For the current symbol, it is stored in the predefined variable Point
2 Count of digits after decimal point in the symbol prices. For the current symbol, it is stored in the predefined variable Digits
50 Spread value in points.
10 Stop level in points.
100 Lot size in the base currency.
1 Tick value in the deposit currency.
0.01 Tick size in points.
-8.25 Swap of the long position.
7.25 Swap of the short position.
0 Market starting date (usually used for futures).
0 Market expiration date (usually used for futures).
1 Trade is allowed for the symbol.
0.1 Minimum permitted amount of a lot.
0.1 Step for changing lots.
1000 Maximum permitted amount of a lot.
0 Swap calculation method. 0 - in points; 1 - in the symbol base currency; 2 - by interest; 3 - in the margin currency.
1 Profit calculation mode. 0 - Forex; 1 - CFD; 2 - Futures.
4 Margin calculation mode. 0 - Forex; 1 - CFD; 2 - Futures; 3 - CFD for indices.
0 Initial margin requirements for 1 lot.
0 Margin to maintain open positions calculated for 1 lot.
0 Hedged margin calculated for 1 lot.
851.7 Free margin required to open 1 lot for buying.
0 Order freeze level in points. If the execution price lies within the range defined by the freeze level, the order cannot be modified, cancelled or closed.
Practice makes a person perfect
  • #551
  • Jun 26, 2021 10:14am Jun 26, 2021 10:14am
hello rtd professionals,
my mt4 runs on a virtual server outside of my home. I am using a remote desktop connection. . My Excel is locally at home on my private PC. I would now like to start Excel RTD on my virtual server and receive and process the data on my private PC. Can someone help me how to set up the connection so that it works? I don't want to install my Excel on the virtual server. Only mt4 should be installed there. Does somebody has any idea?
Many Thanks
Pivot
the highest point comes before the fall
  • #552
  • Edited 10:06pm Jul 12, 2021 12:46am | Edited 10:06pm
EDIT: 13/07/2021
Some wrong formulas when calculating Price Action Pairs Strength and calculating Pairs Strength based on indicators.

I have before shared a couple of templates that calculate percentage change for Individual currencies. I believe I have shared one for DDE and another for Excel RTD.
There is something wrong with the formula and I am correcting it here. If you do not know how to correct the formula in the template, ask me and provide the template and I will correct it for you.
The wrong calculation also applies to dashboards with indicators. For example: Using one or two MAs for calculating strength per pair.

The way to calculate percentage Change in Excel is:

If Current > Open then (Current - Low) / (High - Low) * 100
If current < Open then (Current - High) / (High - Low) * 100

What I have before done wrong was using the same formula (top one) for the second case when Current is lower than open. The same principle shoul apply to other templates/dashboards that use indicators instead of price action.
  • #553
  • Jul 12, 2021 4:27am Jul 12, 2021 4:27am
Quoting simnz
{quote} Hi garfield75, Is it possible to create a symbols Excel dashboard for CFDs offered by a MT4 broker generating the excel/csv spreadsheet (using excellent scripts and indicators coded by FF member Bluerain for raw dump) as well as for display on the MT4 chart. BlueRain has modified an excellent CFD scanner making it full of statistics. But it is good only for an advanced trader. {image} Indicators attached A user-friendly can better be created in Excel Dashboard which will help any manual trader act promptly for making the trading decisions...
Hello do you know what dashboard with PFL and PFH that you include in your post?
  • #554
  • Jul 12, 2021 5:05am Jul 12, 2021 5:05am
Quoting Revsss
{quote} Hello do you know what dashboard with PFL and PFH that you include in your post?
It is a commercial product selling for US$150 on mql forum. I just copied it with a view to having one code it for me.
If you have coding and/or Excel skills, contact me by PM. I will tell you how to go about it.
Practice makes a person perfect
  • #555
  • Jul 12, 2021 5:36am Jul 12, 2021 5:36am
Quoting simnz
{quote} Hi garfield75, Is it possible to create a symbols Excel dashboard for CFDs offered by a MT4 broker generating the excel/csv spreadsheet (using excellent scripts and indicators coded by FF member Bluerain for raw dump) as well as for display on the MT4 chart. BlueRain has modified an excellent CFD scanner making it full of statistics. But it is good only for an advanced trader. {image} Indicators attached A user-friendly can better be created in Excel Dashboard which will help any manual trader act promptly for making the trading decisions...


is the screenshot at the top done in excel ? With the ATR 1hr and conditional format on Pivot points? I could try that but would take days to sort… amazing work if you’ve done that but fantastic for mean reversion
  • #556
  • Edited 5:44am Jul 31, 2021 4:49am | Edited 5:44am
@PayItForward

I have seen you were posting in Trading the GAP in Excel.

Can you direct me to the specific Excel Spreadsheet that best expresses the GAP theory?
Also, I have two more questions:
1-I downloaded some spreadsheets from the thread and noticed a couple of them have VBAs for executing orders. Is there a specific API being used or is it a bridging app/indi to connect with MT4? I do not have much experience with VBAs.
2-With the GAP theory, we need a previous reading to be compared with the current one. I do not think the DDE would allow this unless there is an API or a specific indicator/script that does the bridging.
I do not think the orders in these spreadsheets (in Trading the GAP thread) are using Excel RTD through FX Flue Labs.


Thanks,
  • #557
  • Jul 31, 2021 12:37pm Jul 31, 2021 12:37pm
https://www.forexfactory.com/thread/...7#post13650177
  • #558
  • Aug 1, 2021 1:32am Aug 1, 2021 1:32am
Quoting mtharwat
@PayItForward I have seen you were posting in Trading the GAP in Excel. Can you direct me to the specific Excel Spreadsheet that best expresses the GAP theory? Also, I have two more questions: 1-I downloaded some spreadsheets from the thread and noticed a couple of them have VBAs for executing orders. Is there a specific API being used or is it a bridging app/indi to connect with MT4? I do not have much experience with VBAs. 2-With the GAP theory, we need a previous reading to be compared with the current one. I do not think the DDE would allow...
Hi
When I get a chance next week I'll go through the old files I may have and send them to you.
The .xls did have missing data fields and because of that only gave part of the picture.
From memory there is a connection file Xls to Mt4 and you are correct Excel RTD was not used it was MT4 DDE connection.
If jibalapasan is still around and prepared to assist from memory she worked closely with nasap and the originator of Trading The Gap, whose name escapes me, and jibala know far more than I.
Hope this helps
When you are successful perhaps give a thought to others ... Kiva dot org
  • #559
  • Aug 1, 2021 8:36am Aug 1, 2021 8:36am
[quote=PayItForward;13650386]{quote} Hi When I get a chance next week I'll go through the old files I may have and send them to you. The .xls did have missing data fields and because of that only gave part of the picture.


Thanks, PayItForward. Takr yor time.
I think the GAP theory is about price opening with a GAP and then waiting for it to be refilled. Isn't this the general idea?
  • #560
  • Aug 1, 2021 8:30pm Aug 1, 2021 8:30pm
[quote=mtharwat;13650556]
Quoting PayItForward
{quote} Hi When I get a chance next week I'll go through the old files I may have and send them to you. The .xls did have missing data fields and because of that only gave part of the picture. Thanks, PayItForward. Takr yor time. I think the GAP theory is about price opening with a GAP and then waiting for it to be refilled. Isn't this the general idea?
Two different things.
See https://www.forexfactory.com/marialuiza for Gap theory and attached .pdf
Attached File(s)
File Type: pdf Maria Gap Theory.pdf   114 KB | 627 downloads
When you are successful perhaps give a thought to others ... Kiva dot org
1 trader viewing now