mt5 to excel

New comment
 
Good morning everyone,
I saw that it is possible to export mt5 data (purchase order, sale, profit, loss...) to excel. I’ve tried all the solutions and I can’t. Does anyone know if it is possible to run excel file with live data? (I have been looking for a solution for several weeks but I can’t find it).
Thank you in advance.
 

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
  3. Using spreadsheets to build trading strategies - the article

CodeBase

  1. Export Indicator's Values - MT5 tool  
  2. Export Positions History V1 - script for MetaTrader 5
  3. Export Deals History V1 - script for MetaTrader 5
  4. Live positions to csv - script for MetaTrader 5
  5. Export Calculated Prices & Indicator Buffers - script for MetaTrader 5
  6. Symbols to Excel - script for MetaTrader 5
  7. Export Summary Grouped by Symbols - script for MetaTrader 5
  8. Export Summary Grouped by Trading Days - script for MetaTrader 5
  9. VR Orders History MT5 Lite - script for MetaTrader 5
  10. DDE - Server - MT5 tool
  11. History Dump CSV with heat map for Excel analysis - MT4 tool 
  12. MS Excel: Data Exchange and Management - MT4 tool 
  13. Export to Excel in Real Time - MT4 tool 
  14. MetaCOT 2 CFTC ToolBox (Set of Indicators) MT4 - COT in Excel 
  15. Export Trades to excel - MT4 script 
  16. Converting hst-files into csv files - MT4 tool
 
39863092:
Good morning everyone,
I saw that it is possible to export mt5 data (purchase order, sale, profit, loss...) to excel. I’ve tried all the solutions and I can’t. Does anyone know if it is possible to run excel file with live data? (I have been looking for a solution for several weeks but I can’t find it).
Thank you in advance.

To export your Trade History to Excel, make sure you have Microsoft Excel installed and that it is at least version 2007.

In MetaTrader 5, from the "History" tab, right-click one of the data lines and choose "Report->Open XML".

This will open up the Windows Explorer window, prompting you for a location to save the "ReportHistory-########.xlsx" file, and once you have clicked the "Save" button, it will save the file and automatically open Excel with that file opened.


 

chart real time?



Fernando Carreiro #:

To export your Trade History to Excel, make sure you have Microsoft Excel installed and that it is at least version 2007.

In MetaTrader 5, from the "History" tab, right-click one of the data lines and choose "Report->Open XML".

This will open up the Windows Explorer window, prompting you for a location to save the "ReportHistory-########.xlsx" file, and once you have clicked the "Save" button, it will save the file and automatically open Excel with that file opened.


 
4323402 #: chart real time?

Read post #1 provided by Sergey Golubev.

New comment