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

  • #581
  • Jul 30, 2022 4:44am Jul 30, 2022 4:44am
Just browsing around RTD again saw yr question
Not totally sure what you mean
For what reason ?
What do u wish to accomplish
  • #582
  • Edited 4:34am Aug 25, 2022 4:08am | Edited 4:34am
Hi Everybody.
I have one problem that stops my EA development. Does anybody knows how to achieve the following:

To put simply:
I need a way to send and receive a Terminal Global Variable from MT4 to Excel. Preferably using Excel RTD.

To put a bit more complicated way:
The Excel RTD from what I know can only pass certain set of data, that are explained in the documentation. I want to use Excel RTD to pass my own data, calculated by EA.

I want to use a few EA's at the same time, and each of them is calculating some parameters- ie. the optimal size of renko brick for each symbol and some more. I want to pass all of them to Excel for comparison. After that the decision is to be made within excel and send back as a set of the Global Variables of the Terminal. After that each EA will read these variables, which will actually be a command to either open or close a trade. For the purpose of security I would also like to send "close all" command to all the EA's with an addition of another variable that would mean "do not open other trades until the ban is removed". All of that would be very easy to achieve if I only could use Excel RTD app to pass GVT between MT4 and Excel.


Any ideas?

Thanks a lot.
  • #583
  • Sep 14, 2022 8:42pm Sep 14, 2022 8:42pm
Hi

i need to have open as zero line and the high 1 as Hi with timeline on it like 3.15GMT /Umt then low L1 @ 10.10 and 2nd high @14.55 and Low 15.35 L2 then third one and so till close which is 00 Zero line all in excel format which can be use with mt4 .mt5 indicator TIA
Mind vission traders
  • #584
  • Oct 18, 2022 2:42am Oct 18, 2022 2:42am
Greetings !
I need a formula that will automatically activate a trade in Mt4, but based on the VALUE of the cell. Example:
Cell reached value 75% = Trade opened in Mt4.
Cell reached value 65% = Trade closed in Mt4
The basic formula would look like this: strResult = cmd.SendCommand("123789", "BUY", "s=EURUSD|v=10000", 5)
but in the formula where it says -buy-, I need the ratio of cells (gogili12+xlsx) (I31 and J31), let's say: if : I31> of J31=BUY or if : J31>of I31 = SELL. THAT'S HOW EXCEL WILL KNOW WHETHER TO START THE TRADE WITH BUY OR WITH SELL. and the last item in the formula: v=1000", 5) which, as far as I understand, represents the value of the cell should react to the value that I determine, for example: if the value is > of 75% = YES (start the trade) and if the value is in the same cell fell to 68% = NO (stop the trade). All this should happen in one cell (K31) - fail - (gogili12+xlsx). In K31, the formula determines whether the trade will be started and whether it will be a buy or sel based on cell values (I31 and J31). How to write a formula in cell K31? When you open (gogili12+xlsx) it will be clear to you. Of course I attached the excel RTD and in SPK EX.MG.docx it is explained what it is about. Thank you. Klaki.
Attached File(s)
File Type: docx SPK EX.MG.docx   18 KB | 388 downloads
File Type: xlsx Gogili12+.xlsx   32 KB | 564 downloads
  • #585
  • Dec 17, 2022 11:30pm Dec 17, 2022 11:30pm
I tried to find the williams percentage range rtd excel formula , anybody know the williams percentage range formula ,please reply the full syntax…
Would anybody be able to help?
  • #586
  • Jan 9, 2023 3:13am Jan 9, 2023 3:13am
Hello, I am trying to send an ORDER including StopLoss but not successful:

strResult = cmd.SendCommand("XXXXXX", "BUY", "s=EURUSD|v=2000|sl=" & Range("U5"), 5)

the problem is where I am addressing the SL to cell U5. Anyone can help?

Thanks!
Pavel
  • #587
  • Jan 9, 2023 6:54am Jan 9, 2023 6:54am
Hello,

I am trying to put a automated order but its not executing the trade

Sub Sell2()

Set cmd = CreateObject("FXBlueLabs.ExcelCommand")

Dim x As Integer
x = 1

If Sheet1.Range("K15").Value = x Then

strResult = cmd.SendCommand("82131521", "SELL", "s=EURNZD|v=1000", 5)

End If

End Sub

K15 in sheet1 is 1 but when i run the macro it is not executing..

Do when I use this code it is
Sub Sell()
Set cmd = CreateObject("FXBlueLabs.ExcelCommand")
strResult = cmd.SendCommand("82131521", "SELL", "s=EURNZD|v=1000", 5)
End Sub

But the thing is I want to excecute automatically when the x condition is 1
  • #588
  • Jan 10, 2023 12:51pm Jan 10, 2023 12:51pm
Quoting martijn25
Hello, I am trying to put a automated order but its not executing the trade Sub Sell2() Set cmd = CreateObject("FXBlueLabs.ExcelCommand") Dim x As Integer x = 1 If Sheet1.Range("K15").Value = x Then strResult = cmd.SendCommand("82131521", "SELL", "s=EURNZD|v=1000", 5) End If End Sub K15 in sheet1 is 1 but when i run the macro it is not executing.. Do when I use this code it is Sub Sell() Set cmd = CreateObject("FXBlueLabs.ExcelCommand") strResult = cmd.SendCommand("82131521", "SELL", "s=EURNZD|v=1000", 5) End Sub But the thing is I want to excecute...
Only good it didn't, otherwise it would execute until K15 is set to <> 1

You need to insert an additional switch, which will set K15 <> 1 after it has executed your order. I recommend you work with "Worksheet_Calculate" to verify K15 is equal 1 or not. If it's 1 use "Call" and run the macro "Sub Sell()".

I always use "Private Sub Worksheet_Calculate", to trigger a separate sub when an individual cell's value changes.


Best of luck and stay green always!

Jibala
PDF & BCC (Patience Discipline Focus & Belief Confidence Consistency)
  • #589
  • Jan 31, 2023 12:03pm Jan 31, 2023 12:03pm
Quoting blablabla
Hey guys, i’m currently setting up a trade manager in excel with rtd, i’ve got the live orders/ balance displayed, and now looking to add a “Close All” button or close button for any given transaction. does someone have a working example of this they’d be willing to share. new to VBA, but figured it would be a good project to start with.. so far, i’ve found excel to be a more stable trade manager than using MT4 which can freeze on news events. so wanting to expand the capabilities of excel / rtd
Attached File(s)
File Type: xls Trade Management.xls   25 KB | 496 downloads
Attached File(s)
File Type: xls VFX-Excel-RTD-data-examples.xls   155 KB | 572 downloads
  • #590
  • Feb 3, 2023 9:37am Feb 3, 2023 9:37am
I didn't know it before. Now, I definitely gonna build a RTD version of my system.
  • #591
  • Feb 5, 2023 10:52pm Feb 5, 2023 10:52pm
MT4 just crashed when I used RTD to update my historical data for 28 pairs.
  • #592
  • Feb 6, 2023 2:56am Feb 6, 2023 2:56am
Hi everyone. When I paste the formula into the excel sheet it gives me this error. What can it be? thx to all!
Attached Image (click to enlarge)
Click to Enlarge Name: try.jpg Size: 123 KB
  • #593
  • Feb 6, 2023 4:04am Feb 6, 2023 4:04am
I have solved it with this video
Inserted Video
  • #594
  • Feb 8, 2023 10:24am Feb 8, 2023 10:24am
hi everyone

I have downloaded the IG API (per "api-sample-excel-1.0.7-64bit.zip") and managed to install and got to the create relevant "IG API Excel Sample" (per "ig-api-sample.xlsm") after installation
+ I have also played around with it and managed to download historical OHLC data

I am hoping to be able to download live data using RTD Functions, but I have not been able to do so
+ I have learnt, I believe, that IGMarkets has partnered with LightStreamer.com, and the following are relevant live samples

https://content.invisioncic.com/o280...bacfc51e5c.png

I have managed to install the above "Basic Stock - List Demo Microsoft (Excel, RTD) Client"
+ but the sample Excel did not seem to be able to import Live Data from the IGMarkets data servers



Essentially, my objective is to be able to have an Excel file (let us call this "MyExcelRTD Spreadsheet") to download the following data:
+ historical OHLC Prices up to the last 500 minutes
+ live OHLC Prices per the current minute
- I am planning to build this "MyExcelRTD Spreadsheet" using the "IG API Excel Sample" (is this possible?)

may I ask if a fellow forum member can help with guiding as to how I can achieve the preceding objective?

I have the following questions:
+ can I use the "IG API Excel Sample" (as installed per IG API (per "api-sample-excel-1.0.7-64bit.zip")) to do both the following?
- download historical OHLC Prices up to the last 500 minutes
- - this obviously can be done, as I have done so already

- download live OHLC Prices per the current minute
- - ie am I able to use RTD Functions within this IG API Excel Sample to import live data?

+ from relevant Lightstreamer.com webpages (ie https://demos.lightstreamer.com/?p=l...icrosoft=excel), or rather from the "Basic Stock - List Demo Microsoft (Excel, RTD) Client which I have managed to install, I was able to see that the "progID" used is actually "lightstreamer.rtdexceldemo"
- per the following RTD Function: =RTD("lightstreamer.rtdexceldemo",,"item30","bid")
- can I used this progID in "MyExcelRTD Spreadsheet"?
- or is there another 'progID" which I need to use, and if so, what is the name of the "progID"?

+ I have entered the following RTD Function into a new worksheet of the "IG API Excel Sample"
- "=RTD("lightstreamer.rtdexceldemo",,Z....P,"bidGBPUSD")", but "#NAME?" is returned?
- "Z....P" is my IG AccountID, do I use this AccountID, or is there another AccountID which I have to use so tha this RTD Function will work?

+ also, does IGMarkets and/or Lightstreamer have any kind of RTD documentation (in the same manner eg other brokers have for their ExcelRTD documentation)?
- please see an example here: https://www.jfdbrokers.com/documents...r-guide_EN.pdf
- if so, can please share the documentation here?

sincerely hope that someone can help
+ I have spent easily at least a week on this (including on IGMarkets MT4 Excel RTD ExpertAdvisor) and cannot go forward

thank you

Jim
  • #595
  • Feb 20, 2023 9:10pm Feb 20, 2023 9:10pm
Hi All,
Just wondering if someone can please assist with some Excel RTD questions? I have connected MT4 with Excel using the DDE excel sample file. I had to add .i after cell path / command to work because I'm using raw MT4. What I am trying to extract into excel is the following trade info after an EA has executed a trade-
1). Initial SL figure expressed in actual dollar terms e.g. -163.56 (same as when you hover over the SL line on chart). SL is trailing but I only want the initial figure.
2). Initial TP figure expressed in actual dollar terms e.g. 783.46 (same as when you hover over the SL line on chart)
3). Highest Profit figure reached during the trade- as expressed in the Terminal / Profit column in the Trade tab at the bottom of MT4 (I realise that to record the highest profit figure will require an excel formula).

It could be that Excel RTD isn't the way to do this? (but would be good because I can work with it). Many thanks if anyone knows if this is possible. Please see screenshot of what I'm trying to do below-
Attached Image (click to enlarge)
Click to Enlarge Name: screenshot.png Size: 5 KB
  • #596
  • Edited 7:44am Feb 21, 2023 7:24am | Edited 7:44am
Quoting BennoFox
Sample my dashboard. The possibilties of RTD are huge {image}
Hi BennoFox,
I saw the control panel when I signed up today.
I like it a lot. I was also trying to make a panel. But I really like yours. If you have your consent, I would like to use it. Or if you want to explain your logic or share your file with me, I would be very happy.
I wish you to stay healthy and happy.
my mail: { email address deleted by staff }
  • #597
  • Apr 8, 2023 12:27pm Apr 8, 2023 12:27pm
Quoting HoTuanViet
Zdravo svima, slučajno sam ušao i pročitao ovu temu, veoma je interesantna. Za mene ova tema nam daje novi način za jednostavno upravljanje višestrukim računima za trgovanje ili upravljanje višestrukim nalozima u isto vrijeme, ali to nije sistem trgovanja. Moje lično mišljenje je takvo. Napravio sam ovaj fajl, nadam se da će nekome biti od koristi. Jedan mali doprinos: D {file}
Greetings!
This Excel RTD file of yours is suitable for what I am trying to do, but I would like to automate it if possible... Is it possible to enter VBA code to automatically start the store when the text appears in cell N2: 1/1 ON , and when the text appears: 1/1 OF to close the open trade? I will make sure that I force Excel to show 1/1 ON and 1/1 OF in cell N2 (when the conditions for that are met...) I'm still somehow managing in Excel, but VBA doesn't work in my head at all.. You don't have to worry about the content in columns W: AW, in short, signals from the indicators that are placed on the MT4 platform are registered there and come to my email. I capture them in Excel with a power query, and each indicator is given a percentage value, the sum of which is added up and affects the final signal... cell X20. I will also make sure that the little x is placed in its place in your file. Thanks
klaki
Attached File(s)
File Type: rar Excel RTD 01+3 prob1.rar   73 KB | 477 downloads
  • #598
  • Apr 9, 2023 11:51pm Apr 9, 2023 11:51pm
Quoting garfield75
{quote} Good pick up the excel formula for USDJPY was wrong. updated file attached. {file}
Dear Garfield & Mtharwat,
Thank you for the hardwork for creating such excellent tool !. I might missed a post whether there is similar Excel Spreadsheet that run on DDE instead of RTD
Like to test and see whether MTF Strength V1 using DDE f(Timeframe from M5, M25, M30, H1, H4 D1, WK & MN) is much better in execution.

I have tested excel file "New Price Change..." but quite often the spreadsheet closed automatically. Probabaly to do with my old PC.

Nevertheless, would like learnt if there is MTF Strength Meter V1 for DDE version.

Thank you and keep all the good work.

Citi
  • #599
  • May 12, 2023 4:40pm May 12, 2023 4:40pm
Good evening all,

I don't know if this thread is still active at all but if it is... Is there a way to use RTD with trading time zones such as only show data from the current day between 7:00am to 14:00pm GMT time?

I'm trying to work it out. I can get the current time in excel and Vlookup against a table I have made with indexes to candles to read from in the day but it only references from the current candle on the chart back. For example

If it's 5pm I want the RTD to look back to 2pm (on the 1H) so I want it to start at 3 candles back on the 1H chart and then show me the last 7 bars back from here?

I can't seem to figure it out.

Thanks all
  • #600
  • May 29, 2023 2:24am May 29, 2023 2:24am
I have been reading through this material and was curious if it was possible to send a trailing stop as opposed to a stop. I am working on setting up an if price moves this much then cancel and resend stop but hoped someone knew a better way. Also, wanted to post this for an opinion of a more streamlined approach because i am very new to VBA and coding in general. I feel like i should be able to not have the quotes around action but unsuccessful when trying to remove. This will send orders to MT4 using Excel RTD. Any comments are welcome.


Private Sub limitorder()
'
' send order from cells of demo account and 0123456 is a number i put in for posting but will be the account number
'
Set cmd = CreateObject("FXBlueLabs.ExcelCommand")
Worksheets("one").Activate ' the name of the sheet is one
action = Cells(6, 1) 'this is cell A6 on the active worksheet and will be set to BUYLIMIT or SELLLIMIT
fxsymbol = Cells(7, 1) 'this is cell A7 on the active worksheet and includes the trading symbol and so on for the next few lines
units = Cells(8, 1) ' 1000, 2000, 10000
stoploss = Cells(9, 1) 'stoploss price
entry = Cells(10, 1) 'entry price

strResult = cmd.SendCommand("0123456", "" & action & "", "s=" & fxsymbol & "|v=" & units & "|price=" & entry & "|sl=" & stoploss, 5)

'''''''''''''''''''''''''''''''references
'strResult = cmd.SendCommand("0123456", "BUYLIMIT", "s=AUDUSD|v=1000|price=0.64041|sl=0.64000|tp=0.67800", 5)
'strResult = cmd.SendCommand("0123456", "" & action & "", "s=" & fxsymbol & "|v=" & units & "|price=" & entry & "|sl=" & stoploss, 5)

End Sub
2 traders viewing now