Exporting data from Metatrader into Excel in real time | Page 2 | Forex Factory

Options

Go to
Permalinks
Print Thread

Similar Threads

Exporting indicators data in excel 8 replies

Simple way of exporting MT4 data from Data Window into Excel? 2 replies

Exporting MT4 data to Excel 7 replies

Exporting data to Excel? 3 replies

Problems exporting price data to excel 3 replies

Attachments: Exporting data from Metatrader into Excel in real time
Exit Attachments

Exporting data from Metatrader into Excel in real time

  • #21
  • Apr 18, 2018 10:44pm Apr 18, 2018 10:44pm
Update to my DDE connection issues. It just so happens I bought a new mouse for my computer this past Saturday(Logitech G403). Now thinking nothing of it I installed the typical software that came with the mouse. Needless to say if the software(Logitech Setpoint) is running in the background it will interfere with the DDE connection to MT4. Exit the software and back comes the DDE connection. This only took me 3 days to surf the web to find a answer...lol. Never would have guessed mouse software would effect DDE this way. Live and learn i guess.
K.I.S.S.
  • #22
  • Apr 19, 2018 9:53am Apr 19, 2018 9:53am
Quoting fmsfx
Update to my DDE connection issues. It just so happens I bought a new mouse for my computer this past Saturday(Logitech G403). Now thinking nothing of it I installed the typical software that came with the mouse. Needless to say if the software(Logitech Setpoint) is running in the background it will interfere with the DDE connection to MT4. Exit the software and back comes the DDE connection. This only took me 3 days to surf the web to find a answer...lol. Never would have guessed mouse software would effect DDE this way. Live and learn i guess....
well then everything is fine again
  • #23
  • Apr 25, 2018 7:13am Apr 25, 2018 7:13am
Hello
who can excel the file in Sentmen and Main
Repair the aud, nzd and usd again correctly
Attached File(s)
File Type: xlsx Sentiment Daily.xlsx   991 KB | 1,053 downloads
File Type: xlsx MarketView.xlsx   1.0 MB | 1,027 downloads
  • #24
  • Apr 26, 2018 3:18pm Apr 26, 2018 3:18pm
No brokers that I know of has the DDE feed to load up all the cells. I used this excel years ago with a broker called Bronco I think, of which this excel was design for. They had all the DDE info to populate the whole excel sheet. I have been trying to convert some of those cells with RTD using Ameritrade but it’s a work in progress while live trading takes precedent at the moment.
K.I.S.S.
  • #25
  • Apr 26, 2018 3:40pm Apr 26, 2018 3:40pm
Quoting fmsfx
No brokers that I know of has the DDE feed to load up all the cells. I used this excel years ago with a broker called Bronco I think, of which this excel was design for. They had all the DDE info to populate the whole excel sheet. I have been trying to convert some of those cells with RTD using Ameritrade but it’s a work in progress while live trading takes precedent at the moment.
Thanks for your quick reply
  • #26
  • Apr 26, 2018 3:57pm Apr 26, 2018 3:57pm
simplefx has quite a few of those instruments.
  • #27
  • Aug 3, 2018 2:01pm Aug 3, 2018 2:01pm
Just an update regarding DDE to Excel hangups. While I was getting a new PC up and ready for some streaming I once again found that my DDE was not working. This time after the normal checks/fix like before nothing worked. So basically I decide to upgrade Office 12/2007 to Office 2016 and that fixed the issue right away. I know ancient version of excel but hey if it ain't broke don't fix it right?...lol. So if you have or want to use a older version of excel most likely you will encounter the same DDE connection issues. Hope this can help a few traders.

Dave
K.I.S.S.
  • #28
  • Mar 8, 2019 10:16am Mar 8, 2019 10:16am
Hi Guys,

Any idea how to get custom indicator data from mt4 to excel? I have managed to get the DDE working but that only shows the prices. but not indicator data.

Many Thnaks
  • #29
  • Mar 9, 2019 5:52am Mar 9, 2019 5:52am
Quoting sh4843
Hi Guys, Any idea how to get custom indicator data from mt4 to excel? I have managed to get the DDE working but that only shows the prices. but not indicator data. Many Thnaks

https://www.fxflat.com/fileadmin/use..._Excel_RTD.pdf
  • #30
  • Apr 16, 2019 5:04pm Apr 16, 2019 5:04pm
I would like to get the values for Equity and Balance in the DDE sample file.
Anyone know what the syntax is for these, or where I can find that information?
Thanks
  • #31
  • Jul 16, 2019 8:40am Jul 16, 2019 8:40am
anyone knows if i could import closing price of for examles 5th candle etc before current price? attached a screenshot of what i mean.
Attached Image (click to enlarge)
Click to Enlarge Name: Screenshot1.png Size: 52 KB
  • #32
  • Sep 1, 2019 8:00pm Sep 1, 2019 8:00pm
I have done that through Excel RTD. Have a look here. You can go to 500 bars back and get indi values on those history bars as well.
https://www.forexfactory.com/showthread.php?t=944826

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

However, my current concern is a way to use EXCEL RTD to do that as an array either for a group of look back bars for one pair or for a group of pairs with the same TF. I just have to keep adding the formula every time.

Extracted from my thread:
In More details:

I need to know how to use the fill handle to fill all the cells without typing the formula in each row.
An example: After connecting MT4 to Excel, I type this formula =RTD("fxbluelabs.excelrtd", ,"Account Number", "@bh,GBPUSD,H4,close,0") to get the current close of GBPUSD H4.
If I change the last number (0) to (1), I will get the previous close.
If I type the formula as =RTD("fxbluelabs.excelrtd", ,"Account Number", "@bh,GBPUSD,H4,close,200") I will get the close of the 200th bar.
Now, the problem is that when I selected the first three or four cells (in a column) with the above formulas and try to use the fill handle, I get the new rows filled the same as the selected row cells. For example, the first column has rows 1st, 2nd, 3rd. If I drag the first column, it is filled in the right order with 4th, 5th, 6th, etc..
But the column with the formulas that are linked to MT4 is not being filled correctly. Excel just repeats the values of those three rows in the second column.
  • #33
  • Dec 14, 2019 1:09am Dec 14, 2019 1:09am
Quoting kette
Hello who can excel the file in Sentmen and Main Repair the aud, nzd and usd again correctly {file} {file}
how to unprotect the excel spreadsheet? any password anyone?
  • #34
  • Last Post: Mar 12, 2024 1:10pm Mar 12, 2024 1:10pm
Quoting mehrdadr27
Hi I have a custom mt4 indicator that allow us to export live data from mt4 to metastock, ninjatrader, Dynamic trader and much more like gannalyst.... Put this indicator in custom indicator folder of mt4 setting for indicator is .... {image} {file} You can export as TXT or PRN. Enjoy
Hello ,
I know , a lot time has been passed over this message , but I want ask to dear members , is there is any MT5 expert advisor or MT5 İndicator to export data (5 min , 1 Hour , 1 Day ) from MT5 to MetaStock ?

I will be very appreciate if any member help me to find ?

Best regards...
0 traders viewing now