Export live data to Excel - page 3

To add comments, please log in or register
Yossi Nachum
247
Yossi Nachum  
Yossi Nachum:

i need to export from mt4 to other pc online every few minutes or so

 thank you 

Denis Sartakov
1769
Denis Sartakov  
Yossi Nachum:
something wrong with Yossi Nachum... sorry...
Yossi Nachum
247
Yossi Nachum  
Denis Sartakov:
something wrong with Yossi Nachum... sorry...

hi denis 

 

im sorry my english is not so good

 

i need to export from my mt4 to other client  pc my balance and equity every nin or hour 

 

can you please explain me  how to do it step by step ?

thank you and sorry again 

Harrymon12
10
Harrymon12  
I am using  MarketXLS  and it's great.
http://marketxls.com/stock-quotes-in-excel/
juan
3
juan  
Forex Trader:
You use the DDE that comes with MT4
Place these codes in individual excel cells
=MT4|BID!EURUSD
=MT4|ASK!EURUSD
=MT4|HIGH!EURUSD
=MT4|LOW!EURUSD
=MT4|TIME!EURUSD
Change the symbol for different crosses.
You will also need to go to Tools / Options and tick the enable DDE box

Good day Dear All:

 How can I export the Daily open price to an excell cell , I mean the first quote (open ) at 00:00 hrs GMT? .

I could not find the proper code.

 

many thanks 

Maestr
13
Maestr  

Hello  ,

 

I would like to export real time data to excell   from mt5  -  the date is about profit or loss for open position , margin for open positions, and total balance, and  real time equity value, also  margin %.

How can I do it?

Thank you 

Harrymon12
10
Harrymon12  
Forex Trader:
You use the DDE that comes with MT4
Place these codes in individual excel cells
=MT4|BID!EURUSD
=MT4|ASK!EURUSD
=MT4|HIGH!EURUSD
=MT4|LOW!EURUSD
=MT4|TIME!EURUSD
Change the symbol for different crosses.
You will also need to go to Tools / Options and tick the enable DDE box

I use MarketXLS. It really worked great for me.
http://marketxls.com/stock-quotes-in-excel/
Sergey Golubev
Moderator
111945
Sergey Golubev  

Forum on trading, automated trading systems and testing trading strategies

Usefull links/threads/tools

Sergey Golubev, 2011.11.23 07:17

Excel

Systems and tools

  1. Working with Excel (tools, indicators, conversion ...) - the thread 
  2. Forex data converters thread 
  3. MULTI FIBO CALCULATOR with DDE off course - the thread 
  4. FX risk calculator with DDE - the thread 
  5. Excel Spreadsheet to simulate cost averaging strategies objectively - the thread 

Articles

  1. MQL5 Cookbook: Writing the History of Deals to a File and Creating Balance Charts for Each Symbol in Excel - the article
  2. How to Prepare MetaTrader 5 Quotes for Other Applications - the article

CodeBase

  1. Export Indicator's Values - MT5 tool 
  2. VR Orders History MT5 Lite - script for MetaTrader 5
  3. DDE - Server - MT5 tool
  4. History Dump CSV with heat map for Excel analysis - MT4 tool 
  5. MS Excel: Data Exchange and Management - MT4 tool 
  6. Export to Excel in Real Time - MT4 tool 
  7. MetaCOT 2 CFTC ToolBox (Set of Indicators) MT4 - COT in Excel 
  8. Export Trades to excel - MT4 script 
  9. Converting hst-files into csv files - MT4 tool
123
To add comments, please log in or register