Export live data to Excel - page 3

New comment
 
Yossi Nachum:
something wrong with Yossi Nachum... sorry...
 
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 

 
I am using  MarketXLS  and it's great.
http://marketxls.com/stock-quotes-in-excel/
 
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 

 

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 

 
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/
 

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
 

Hello Team,


Can we create an alert when limit order pass or get executed.


Alert should be call comment whatever mentioned in the order


Regards

 

Hello Team,

I am beginner in MT5 programming and haven't done anything yet. currently I want to create an indicator where client place any limit order(Sell Limit, Buy Limit, Sell Stop Limit, Buy Stop Limit) then I should get an alert with the client pending order details.

#property indicator_chart_window
#property indicator_buffers   0
#property indicator_plots     0

Above is the Indicator property which will generate Alert.

I have knowledge of while loop where I can put the Pending order is equal to fill then i should get alert like,

While( ORDER_TYPE_BUY_LIMIT == FILLED)  {
alert(Order is filled)
}
While( ORDER_TYPE_SELL_LIMIT == FILLED)  {
alert(Order is filled)
}

I am getting issues in declaring the keyword which will target the client pending order.

Can anyone help me to get the solution.

Regards,

Abhishek Pandey

 
Forex Trader #: i get error after i type in =MT4|BID!EURUSD. Anyone knows what's the problem?
hi 
try this 

=SINGLE(mt4|bid!EURAUD)
123
New comment
Reason: