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

  • #21
  • Oct 5, 2020 12:19am Oct 5, 2020 12:19am
To transform this RTD worksheet into an EA, I guess the "Place Order" button/object needs to be clicked automatically when a set of conditions are met.

Does anyone know the VBA code for that?

For example say when the vVolume cell is >5000, the button should be clicked once and next time again the vVolume goes up above 5000.
  • #22
  • Oct 5, 2020 1:27pm Oct 5, 2020 1:27pm
Quoting antariks
To transform this RTD worksheet into an EA, I guess the "Place Order" button/object needs to be clicked automatically when a set of conditions are met. Does anyone know the VBA code for that? For example say when the vVolume cell is >5000, the button should be clicked once and next time again the vVolume goes up above 5000.
Even if you would know that piece of code you couldn't do anything with it because VBA can not send orders directly to MT. For that, you need an API. What is an API? An API is a set of functions and procedures allowing the creation of applications that access the features or data of an operating system, application, or other services.
That API (can be a script in MT script folder) will then check every "n" seconds if new orders are available to execute.

Best of luck and stay green always!

Jibala
PDF & BCC (Patience Discipline Focus & Belief Confidence Consistency)
  • #23
  • Oct 5, 2020 2:49pm Oct 5, 2020 2:49pm
Quoting JibalaPasan
{quote} Even if you would know that piece of code you couldn't do anything with it because VBA can not send orders directly to MT. For that, you need an API. What is an API? An API is a set of functions and procedures allowing the creation of applications that access the features or data of an operating system, application, or other services. That API (can be a script in MT script folder) will then check every "n" seconds if new orders are available to execute. Best of luck and stay green always! Jibala
Why the place order object cannot be clicked with a code and running a macro?
  • #24
  • Oct 6, 2020 3:33am Oct 6, 2020 3:33am
Quoting kenrickpoh
Thank you for this amazing resource. I'm able to set it up. However, I need some help here. =RTD("fxbluelabs.excelrtd", ,"account number", "@bh,GBPUSD,H4,close,1") When I use the above formula to get historical prices, the excel cell return the cell value "wait" instead of the price. The rest of the commands worked fine, e.g account balance, last ask price. etc. Would anybody be able to help?
Is that problem solved ? I encountered the same issue.
  • #25
  • Oct 6, 2020 3:46am Oct 6, 2020 3:46am
Quoting antariks
{quote} Why the place order object cannot be clicked with a code and running a macro?
This is a crude "API" for MT4. It allows external programs to control MT4 to execute, modify, close and delete trades
Store in experts/scripts and compile

This script Polls folder experts/files every Repeat_Delay_Seconds for a file commandfile.txt. If it exists, reads a single trade command as per examples below.:
OrderSend,AUDUSD,OP_BUY,1,Ask,5,0,0,Order1,9999,0,Orange
OrderSend,AUDUSD,OP_BUYSTOP,1,0.7670,5,0,0,Order2,9999,0,Orange
OrderModify,Order1,0.7695,0.7620,0.7720,0,Orange
OrderClose,Order1,1,Bid,5,Purple
OrderDelete,Order1

Note that the format of the CSV lines is similar to the original function calls.
An important point about managing existing orders
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
The commands OrderModify, OrderClose and OrderDelete locate the order that they are targeting by its Comment,
NOT by its ticket number.
If the command in commandfile.txt is successful it is deleted and the command is written to commandfile_log.txt
Unsuccessful commandfiles are renamed "FAILED command <TimeLocal>.txt"
Maintains list of open orders in openorders.txt in format:
OrderOpenTime,OrderComment,OrderMagicNumber,OrderSymbol,OrderType,OrderLots,OrderOpenPrice,OrderStopLoss,OrderTakeProfit


good luck
Attached File(s)
File Type: mq4 TradeFromCSVfile.mq4   26 KB | 884 downloads
Forex can only be understood backwards, but it must be traded forwards.
  • #26
  • Oct 6, 2020 4:38am Oct 6, 2020 4:38am
Quoting prozor7
{quote} This is a crude "API" for MT4. It allows external programs to control MT4 to execute, modify, close and delete trades Store in experts/scripts and compile This script Polls folder experts/files every Repeat_Delay_Seconds for a file commandfile.txt. If it exists, reads a single trade command as per examples below.: OrderSend,AUDUSD,OP_BUY,1,Ask,5,0,0,Order1,9999,0,Orange OrderSend,AUDUSD,OP_BUYSTOP,1,0.7670,5,0,0,Order2,9999,0,Orange OrderModify,Order1,0.7695,0.7620,0.7720,0,Orange OrderClose,Order1,1,Bid,5,Purple OrderDelete,Order1 Note...
Please don't be so mysterious. LOL
Once this script is running...how the excel command button is instructed to execute trades based on predetermined logic?
  • #27
  • Oct 6, 2020 4:40am Oct 6, 2020 4:40am
Quoting pooh123
{quote} Is that problem solved ? I encountered the same issue.
Try restarting your mt4 and RTD. If the formula is typed correctly, the datafeed will come for sure.
  • #28
  • Oct 6, 2020 5:12am Oct 6, 2020 5:12am
Quoting antariks
{quote} Please don't be so mysterious. LOL Once this script is running...how the excel command button is instructed to execute trades based on predetermined logic?
no mystery here
if you understand Visual Basic you will understand this

Sub WriteToCSV()

Dim MyPath As String
Dim f_command As String
Dim f_command1 As String
Dim f_command2 As String
Dim f_command3 As String
Dim f_command4 As String
Dim f_command5 As String
Dim f_command6 As String
Dim f_command7 As String
Dim f_command8 As String
Dim f_command9 As String
Dim f_command10 As String
Dim f_command11 As String
Dim f_command12 As String
Dim MyFileName As String
Dim cellValue As String
Dim rng As Range
Dim cellValue2 As Variant
MyPath = "C:\**********\MetaQuotes\Terminal\*******************\MQL4\Files\TradeFromExcel2MT4" - path to MT4 files
'MyileName = "\commandfile.txt"
If Dir(MyPath, vbDirectory) = "" Then
MkDir MyPath
Else

End If
cellValue = MyPath & "\commandfile.txt"
'f_command = "OrderSend" & "," & "AUDCAD"
f_command1 = "OrderSend"
f_command2 = "AUDCAD"
f_command3 = "OP_BUY"
f_command4 = "0.01"
f_command5 = "Ask"
f_command6 = "5"
f_command7 = "0"
f_command8 = "0"
f_command9 = "Order1"
f_command10 = "9999"
f_command11 = "0"
f_command12 = "Blue"

look here
Forex can only be understood backwards, but it must be traded forwards.
  • #29
  • Oct 7, 2020 7:07am Oct 7, 2020 7:07am
Quoting JibalaPasan
{quote} Sure mate, that I could do easily but it wouldn't solve the base problem. It seems you're lack of some M$ Excel basics even, therefore, you have to work on that first. I suggest you read the Excel Help file for Relative & Absolute Cell References. {image}{image}It works perfectly for me!
I ran into a problem with Excel RTD. If I input this formula: =RTD("fxbluelabs.excelrtd",,$A$1,"@bh,GBPUSD,5,close,1") , it works properly. However, if I change the formula to: =RTD("fxbluelabs.excelrtd",,$A$1,"@bh,GBPUSD,5,close,$B3"), where I use"$B3" as cell reference for bar shift (value in $B3=1), it returns "wait" forever. Anyone knows the cause of it ? How to fix it ?

My Excel version is 2010. Is it too old to work with cell reference in RTD ? Yet it works with cell reference ($A$1 in this case) as account number.
  • #30
  • Oct 8, 2020 2:43pm Oct 8, 2020 2:43pm
Quoting pooh123
{quote} I ran into a problem with Excel RTD. If I input this formula: =RTD("fxbluelabs.excelrtd",,$A$1,"@bh,GBPUSD,5,close,1") , it works properly. However, if I change the formula to: =RTD("fxbluelabs.excelrtd",,$A$1,"@bh,GBPUSD,5,close,$B3"), where I use"$B3" as cell reference for bar shift (value in $B3=1), it returns "wait" forever. Anyone knows the cause of it ? How to fix it ? My Excel version is 2010. Is it too old to work with cell reference in RTD ? Yet it works with cell reference ($A$1 in this case) as account number.
Go back to the post where I've posted the formula and compare it to yours. You then should clearly see what's wrong and why it doesn't work for you.

Best of luck and stay green always!

Jibala
PDF & BCC (Patience Discipline Focus & Belief Confidence Consistency)
  • #31
  • Oct 8, 2020 6:26pm Oct 8, 2020 6:26pm
Quoting prozor7
{quote} no mystery here if you understand Visual Basic you will understand this Sub WriteToCSV() Dim MyPath As String Dim f_command As String Dim f_command1 As String Dim f_command2 As String Dim f_command3 As String Dim f_command4 As String Dim f_command5 As String Dim f_command6 As String Dim f_command7 As String Dim f_command8 As String Dim f_command9 As String Dim f_command10 As String Dim f_command11 As String Dim f_command12 As String Dim MyFileName As String Dim cellValue As String Dim rng As Range Dim cellValue2 As Variant MyPath = "C:\**********\MetaQuotes\Terminal\*******************\MQL4\Files\TradeFromExcel2MT4"...
The script is placed in the proper place. Now? This new VBA and Macro to be run?
  • #32
  • Edited 9:17pm Oct 8, 2020 8:54pm | Edited 9:17pm
Hello everyone,

My apologies for not being active last period. I was busy with trading stocks CFDs on MT4. It is also not easy to find MT4 brokers who offer stocks and EXCEL RTD at the same time.

But I am back now and will at least use EXCEL RTD for forex and indices.

Thanks to all the members who have tried to help others.

If anyone has a question and or finding it difficult to use EXCEL RTD, please post here in this thread and I will try to do my best to answer your questions. Maybe I can make some videos to simplify it.

There are three things we will try to cover in this thread.
The first thing is how to retrieve the data to EXCEl by using formulas.
The second is how to make use of this data to create dashboards that require some learning of Excel (I think JibalaPasan and BennoFox have shown us some nice professional dashboards. We would love to know from them more tips on how visually represent the data we retrieve in such a professional and neat way.
The third thing is how to create market orders and trailing stops and partially take profits. This is something I am trying to learn now. I will give you an example. Let's say I want to partially close my order and set three targets. The first target is based on 1:1 and second 2:1 and so on. Another thing is to work on partially closing my trade based on an EMA or based on an indicator cross, ATR, etc.. In the PDF attached in the first post, there are some formulas that can do this.

Anyway, I will share what I currently know here in this thread helping others and learning from more professional Excel traders.

I and many other traders who were trying to find connectivity to Excel were really upset by the limited information provided and the "teasing" posts which shows a small bit of the knowledge that does not really help us. So I want this thread to be as comprehensive as possible.

Many thanks for your interaction.
  • #33
  • Edited Oct 9, 2020 12:01am Oct 8, 2020 9:05pm | Edited Oct 9, 2020 12:01am
Quoting tass
So what formula are you using to get the OHLC/Volume for the current bars and up to 500 bars ago? How would you get the OHLC/Volume of more than 1 currency pair at a time for the current bar and up to 500 bars ago?
Hi Tass,
Have you read the PDF manual in the first post? It answers all your questions. Please have a look and let me know if there is an issue. Anyone starting for the first time may find it very challenging. But it takes a bit of time and you will find it less challenging. I can work on a template and post it here. If you have Excel RTD, you will only need to change the account number with yours.
Let me know if this will make it simpler for you.

Quoting Shaydu
Hi All, I am still newbie in MetaTrader. I am curious to know if I could write my own program, more or less have the same function with Excel RTD (to collect the data from several broker and store it in excel real time). Do you have any guidance how to do it ? or some material to read ?
There are some commercial products that enable this connectivity to a number of brokers. I can PM you if you allow me to.

Quoting kenrickpoh
Thank you for this amazing resource. I'm able to set it up. However, I need some help here. =RTD("fxbluelabs.excelrtd", ,"account number", "@bh,GBPUSD,H4,close,1") When I use the above formula to get historical prices, the excel cell return the cell value "wait" instead of the price. The rest of the commands worked fine, e.g account balance, last ask price. etc. Would anybody be able to help?
I think you need to change the (,) to semi column ; . Or sometimes I find that I need to click on a cell and press enter to kind of refresh the data.

Quoting feelingfree1
Like kenrickpoh i also appreciate the resource however also need help. Most of my formula's work but for some reason a couple of the symbols come back with No Data and 'wait'. I am with Oanda using JFD Excel RTD. Does anyone know why? {image}
It does happen sometimes, unfortunately. You may need to click on the cell and press enter. Or restart again. It helped me sometimes.

Quoting investnic
Hi Has anyone had any success getting the FX Blue Labs RTD to be able to send trades to MT5. I have designed a program in excel that spits me out trades everyday, they are pending stop orders and I want to be able to send them to MT5 via this but I have been playing with it for hours and I either get errors or it says it has placed the trade but nothing shows up on the platform If someone has been ableto get this to work I would love to see examples of the VBA/excel code that you have used. Thanks
I am curious to know as you. I found many MT5 brokers offer more stocks CFDs compared to MT4 brokers. Anyway, I tried a demo with Admiral Markets MT5 and their representative said Excel RTD should work with MT5 (although they did not mention this for MT5 on their website). I tried with demo but had no luck. I emailed them and got no response.

Quoting JibalaPasan
{quote} I guess what you want to know looks like that: {image} If once you're familiar with all that syntax stuff you can do lots of calculations. Together with little developer skills, you are able to develop amazing trading tools. My current favourite is the GER30 Scalper & Swing Trader. {image}{image} Best of luck and stay green always! Jibala
Hi JibalaPasan,
We are very lucky having you here.
I wish if we learn how to create this nice graphic visual representation from your post in Excel.

Quoting BennoFox
Sample my dashboard. The possibilties of RTD are huge {image}
Top-Notch! as JibalaPasan's

Quoting ForexDigger
Hi Guys. I have studied everything about MT4/5 + Excel on this forum (including 182 pages of "MT4 Trading the GAP With Excel") and I still can't find one definitive answer regarding the RTD Link from FX Blue Labs. Sometimes it just leaves some fields empty and I don't know why. I have contacted the Blue Labs for that as well, but I got no answer from them at all. Does anybody knows why that RTD Link is so unreliable?
I have contacted them in the past with no response. I think they only deal with brokers. Try the technical department of your broker. With regard to "Empty fields", I have found that clicking on the cell (as if you are going to change the formula) and then pressing enter, the cell will refresh. It works for me.

A template I have takes a couple of minutes to open and can actually see the progress at the bottom of the Excel sheet in percentage. something like this (calculating 8 threads 20%). So I have to wait for it.
  • #34
  • Edited 9:23pm Oct 9, 2020 12:02am | Edited 9:23pm
Here is something to kickstart if anyone is struggling with formulas.

This attached sheet shows the percentage change for MTFs for all 28 currency pairs.

Here are some notes you will find in the sheet.

My calculation for %Change is done by subtracting the current price from the previous close for each time frame and then divide the result by the previous close. (Current Price - Previous Close)/Previous Close.
You can multiply the outcome by any multiplier and/or use the percentage format which automatically multiplies the result by 100. Currencies do not change in price noticeably as in stocks and hence you need to multiply it by 10 or 100 etc..
Sometimes the cells show strange numbers. So please check the referenced cells. If the retrieved values are wrong then restart excel or click on the cell and press enter.
Another trick that works for me is to try to change the symbol and then retype the symbol back.
For Example I found that the value I retrieved for USDJPY Weekly time frame is wrong. It is showing 34000 instead of 101.56. I will go to the cell and change USDJPY to any other pair, and then retype USDJPY (or reference it). It then displays the right price.
EDIT: I have also found that Re-applying Excel RTD Expert Advisor does solve the issue. So try this first. You can restart MT4 and open a dedicated chart for applying the Expert Advisor. This should fix the issue.

Please note you need to type in your account number on the top left corner.
Give it some time after you type in your account number for the sheet to retrieve the data.

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

How can you use this sheet:
1-Let us say you want indices or other CFDs, then simply change the instrument list to any other symbols. All cells will be automatically referenced.
2-You may want to find the previous close change relative to two previous closes. Then simply change (0 and 1) to (1 and 2). Cells will change values accordingly.
3-You can change the TFs to your liking and data will be referenced instantly.

The whole idea is to familiarize yourself with formulas. You can then make some simple dashboards based on the data.
If anything is confusing please let me know. It is much simpler than what you think it is.
Attached File(s)
File Type: xlsx EXCEL RTD Sample for Forex Factory.xlsx   25 KB | 1,130 downloads
  • #35
  • Oct 9, 2020 9:11pm Oct 9, 2020 9:11pm
I have added two sheets in the previous (Excel RTD Sample for Forex Factory). Attached here the new one and attached screenshots for how it should look after you type your account number.

The logic is simple. I used the conditional format in Excel to colour the cells above zero with green and the opposite with red.
Then I used the format painter (after clicking on Home Tab) to apply the same formatting on other tables or other selected cells.
You can change the conditional formatting if you wish. For example, if the percentage change is above 1 per cent then green or below -1 per cent then red. Values between 1 and -1 can be yellow.

To get a basic understanding, search for "Conditional Formatting" in Excel. and then search for "how to use Format Painter in Excel". Also how to use the "Recommended charts" in Excel to create pie charts, bar charts, etc..

Let me know if you need more explanation.

I will be back with more sheets and ideas.
Attached Image(s) (click to enlarge)
Click to Enlarge Name: 2020-10-10 (1).png Size: 226 KB
Click to Enlarge Name: 2020-10-10 (2).png Size: 159 KB
Click to Enlarge Name: 2020-10-10.png Size: 237 KB
Attached File(s)
File Type: xlsx Workbook for Change with Currency grouping and Charts.xlsx   73 KB | 1,195 downloads
  • #36
  • Oct 11, 2020 3:23am Oct 11, 2020 3:23am
Is this programmable? I am happy to share a good strategy if this can be done. Thanks
Attached Image (click to enlarge)
Click to Enlarge Name: Screenshot1.png Size: 69 KB
  • #37
  • Edited Oct 12, 2020 1:16am Oct 11, 2020 10:03pm | Edited Oct 12, 2020 1:16am
Quoting antariks
Is this programmable? I am happy to share a good strategy if this can be done. Thanks {image}
Hi antariks,
Can you please elaborate more on what you are trying to accomplish? I am afraid the photo is not quite clear for me.
My understanding is you want to initiate a buy order if volume equals a certain value. Am I right? Can you please show us the "If" formula you used? so we can see what is the problem with the formula.

Any ideas are more than welcome as the main focus is to train ourselves on how to practically translate those ideas into formulas in Excel.

Regarding using EXCEL RTD buy/sell orders, I have not yet used them but planning on. It is a great gem to create partial closes based on certain conditions. I am sure whatever conditions you have in mind can be easily implemented in Excel.

Thanks,
  • #38
  • Edited Oct 12, 2020 3:48am Oct 11, 2020 11:39pm | Edited Oct 12, 2020 3:48am
Just an example of how to make use of the Currency percentage change Dashboard.

Instead of checking all charts for currencies, indices, CFDs etc.., it is easier to identify which financial instruments to look at. In the Excel sheet (attached a photo), we see JPY group very bullish and GBP group mostly bearish for Weekly, Daily and H4 time frames.
The percentage change used here is the same as in the previously attached workbooks (Current price - previous close)/Previous close for each time frame.
You will notice that weekly and Daily values are almost identical and that is because it is the first day in the week during the Asian Session.

I do not intend to discuss trading setups in this thread but rather to show how Excel RTD can be a great assisting tool in looking for trading opportunities or avoiding a trade and establishing a bias.

Here in GBPJPY H4, we see an H4 breakout. However, the Excel Dashboard is suggesting bearishness in this pair. Also, there is a bearish divergence in Trix. So the setup looks bullish but the dashboard is suggesting the opposite. So it is better to avoid the bullish bias and wait and see what happens in the active London and NewYork sessions. White dashed lines are monthly pivots.


A tip: It is better to create tables in Excel if you have multiple time frames. Tables will enable you to show which timeframes you want to check. So you can select/deselect them individually. see last photo.
Attached Image(s) (click to enlarge)
Click to Enlarge Name: 2020-10-12.png Size: 197 KB
Click to Enlarge Name: GBPJPYH4.png Size: 66 KB
Click to Enlarge Name: 2020-10-12 (1).png Size: 194 KB
  • #39
  • Edited 6:16am Oct 12, 2020 5:57am | Edited 6:16am
Does any know how to record with a dynamic timestamp in Excel? A VBA code perhaps that can help?

I want to record the time when certain conditions are met in a column. I can assign a cell in Excel that will represent the conditions but do not know how to record a dynamic time stamp in a column. The timestamped cell should not be refreshed but rather a new cell will contain the new timestamp when the same conditions are met again.
  • #40
  • Oct 12, 2020 6:48am Oct 12, 2020 6:48am
Quoting mtharwat
Does any know how to record with a dynamic timestamp in Excel? A VBA code perhaps that can help? I want to record the time when certain conditions are met in a column. I can assign a cell in Excel that will represent the conditions but do not know how to record a dynamic time stamp in a column. The timestamped cell should not be refreshed but rather a new cell will contain the new timestamp when the same conditions are met again.
Let's say you have the time of mt4 (='MT4'|TIME!GBPAUD) running in A1 and the conditions are met in your other cell, then you just use "copy" in vba from e.g. A1 to B1.

Sheets("Your_Sheet").Range("A1").Copy
Sheets("Your_sheet").Range("B1").PasteSpecial Paste:=xlPasteValues

Best of luck and stay green always!

Jibala
PDF & BCC (Patience Discipline Focus & Belief Confidence Consistency)
0 traders viewing now