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

  • #601
  • Jun 4, 2023 7:21am Jun 4, 2023 7:21am
Can we import MT4 Alerts in Excel? If so could someone please provide the command/formula?

Many Thanks
Stay Positive
  • #602
  • Edited 3:07am Sep 4, 2023 2:18am | Edited 3:07am
Hello Everyone, it has been a while!.

Just wondering if anyone has successfully run our Excel RTD on a Windows 2016 Server.
I have a VPS that runs Windows Server 2016 (which will continue Excel Support for some time). I then tried to run Excel RTD but it did not work!
I called Microsoft Support and they said there are issues with Excel RD on servers and it is better to create my own API that would better suit Windows servers.
  • #603
  • Sep 4, 2023 2:19am Sep 4, 2023 2:19am
Quoting forexjoy
Can we import MT4 Alerts in Excel? If so could someone please provide the command/formula? Many Thanks
Nope, unfortunately. It is only limited to what is in the documentation on the first page.
  • #604
  • Sep 4, 2023 4:39am Sep 4, 2023 4:39am
Has anyone found more Excel-ready APIs from different brokers like FXCM, Oanda, etc...
  • #605
  • Dec 20, 2023 9:30am Dec 20, 2023 9:30am
Quoting mtharwat
Has anyone found more Excel-ready APIs from different brokers like FXCM, Oanda, etc...
FP Markets in Australia offers it. You get a .exe installer that installs everything and it works
  • #606
  • Dec 20, 2023 9:32am Dec 20, 2023 9:32am
Quoting mtharwat
Hello Everyone, it has been a while!. Just wondering if anyone has successfully run our Excel RTD on a Windows 2016 Server. I have a VPS that runs Windows Server 2016 (which will continue Excel Support for some time). I then tried to run Excel RTD but it did not work! I called Microsoft Support and they said there are issues with Excel RD on servers and it is better to create my own API that would better suit Windows servers.
I also run a W Server 2016 and it wasnot working. Then last week I installed the FP Markets installer and now it is working
  • #607
  • Jan 2, 2024 5:02pm Jan 2, 2024 5:02pm
Hi guys!
I'm new to this forum. I'm trying to modify the placed trade. But getting error "strResult = "ERR: No response within the timeout"

These are the main steps used for this order modification. Can anyone please help me on this? Thanks for your time!

comment = "sl=" & newStopLossPrice & "|tp=" & takeProfitPrice
strResult = cmd.SendCommand("ticketID", "ORDERMODIFY", " & comment & ", 5)
  • #608
  • Edited 7:11am Feb 20, 2024 6:38am | Edited 7:11am
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! If, after reading the Help file you're still having problems, please tell us exactly what kind of problems they are. Best of luck and stay green always! Jibala
Hi @JibalaPasan could you help me in the formula with a relative cell for the values "pairs" and "time frame"?

I think I've got it here: =RTD("fxbluelabs.excelrtd"; ; "66664991";CONCATENAR("@bh,";$C$7;",";$D$7;",CLOSE,"&D10))
  • #609
  • Mar 15, 2024 5:33am Mar 15, 2024 5:33am
Hi all, let say I want to display historical data with Start Date/time , for example, 1/1/2024 to End Date/time , RIGHT NOW meaning to the current live data) for EURUSD pairs with OPEN HIGH LOW CLOSE for 1 hour data, could this RTD do the job?
  • #610
  • Apr 3, 2024 8:49am Apr 3, 2024 8:49am
Quoting java1708
Hi all, let say I want to display historical data with Start Date/time , for example, 1/1/2024 to End Date/time , RIGHT NOW meaning to the current live data) for EURUSD pairs with OPEN HIGH LOW CLOSE for 1 hour data, could this RTD do the job?
Hi, depends for daily charts yes, remember you can go back 500 bars back with excel rtd.
  • #611
  • Aug 8, 2024 6:36am Aug 8, 2024 6:36am
Anybody knowns how to get the closed price of an order (i.e. how to read data from the account history)? Thank you.
  • #612
  • Dec 18, 2024 4:58am Dec 18, 2024 4:58am
Hi,
anyone that can share this file "api-sample-excel-1.0.7-64bit.zip"? IG is having issues with the server connection since weeks..

Thx!
Oliver

Quoting jhclfrftr
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 {image} I have managed to install the above...
  • #613
  • Last Post: Feb 24, 2025 12:20pm Feb 24, 2025 12:20pm
Can I find someone to help me with the following
Data in the Excel File:
Column A: Contains the currency pairs.
Column B: Contains the signal type (BUY or SELL).
Column C: Contains the stop loss value.
Column D: Contains the target.
Column E: Contains the lot size.
Core Tasks and Requirements:
Develop Excel VBA Code:
The code should automatically monitor any changes in the data (columns A to E) in real time.
It should save the signals, stop loss, and target values to a CSV file.
The CSV file must be automatically sent to the Files folder on the MT4 platform.
Create an Expert Advisor (EA) for the MT4 Platform:
The EA should read the signals from the CSV file.
It must execute trades directly on the MT4 platform based on the received signals.
It should ensure that only one active trade exists for each signal until the signal changes.
0 traders viewing now