Real Time Data (RTD) - MT5 to Spreadsheet (Excel, LibreOffice)

[Maverick]

I am hoping there is someone on this site who can help me export my LIVE mt5 data to a spreadsheet
FYI ... I use Libre Office

 

[Enivid]

You could try to make an MT5 indicator that constantly saves the data into a .csv file. Then use Excel/LibreOffice to auto-update from that .csv as External Data.

 

[Maverick]

Somebody over at EARNFOREX describes "How to Connect MT4 to Excel" which is good for Bid, Ask, High, and Low BUT sadly that is all the information you can get

I want the data information on my MA's

Had hoped it could be done by changing the "BID" in the link =DDE("MT4","BID","SPX500") ... BUT to what ?

I can get the historical High, Low, Open & Close

How to export data from Metatrader 5

1. Open Metatrader 5 and the right click on the symbol in a market watch:
2. Click on symbols.
3. Click on a specific symbol.
4. Click on the bars tab.
5. Then you will see the bars and you have to select them.
6. Click on export.
7. Choose the folder for saving data.

If I can get the Open, High, Low & Close data ... WHY can't I get the complete Data Window ?

 

[Maverick]

Posted the job on MQL5 https://www.mql5.com/en/job/212752 to get a feel

 

[Enivid]

Somebody over at EARNFOREX describes "How to Connect MT4 to Excel" which is good for Bid, Ask, High, and Low BUT sadly that is all the information you can get

That article is about DDE. It won't help you with your task. You need to code (or get coded) an indicator that writes all the data that you need (including the values from other indicators) into a CSV file. That file can be then used for auto-update data in your Excel spreadsheet.

 

[Maverick]

That article is about DDE.

Realised that BUT thought it might help others ... Agreed this thread is for RTD maybe I should have started one for DDE

Please feel free to delete those that are not relevant

 

[EnrichWave]

Is there any solution for MT5 like that MT4 DDE server option to get real BID price in excel,

BR.

 

[Enivid]

Is there any solution for MT5 like that MT4 DDE server option to get real BID price in excel,

BR.

No built-in solution. You can either use a third-party DDE or create your own indicator that would write to a .csv and then use Excel to automatically import data from that .csv.

 

[Maverick]

Is there any solution for MT5 like that MT4 DDE server option to get real BID price in excel,

BR.

Sadly no

My workaround

MT4 and MT5 chart data SHOULD be the same

I have an MT4 chart open for the same instrument I am trading on MT5

The MT4 DDE feeds live information to my spreadsheet

Sadly all that is available is the Bid, Ask, High and Low