How to export live data from MT5 to Excel or Google Sheets?

 
So I want to have a substitute for charts. I want to export and then after the bar closes - save real time data (OHLC) to Excel at a common time intervals like M15, H1, D1. Like I said - substitute for charts. Does anyone know how to do this?
 
DamianJean:
So I want to have a substitute for charts. I want to export and then after the bar closes - save real time data (OHLC) to Excel at a common time intervals like M15, H1, D1. Like I said - substitute for charts. Does anyone know how to do this?

I heard that it can be done either with an EA or script

I am also curious how it can be done to perform some tests

 
Hello.
Its not dificult. 
I made mt4 and mt5 data recorder.

To export data from mt4 to excel sheet.
you must have EA can read information that you want and save them in excel sheet.

these information can be.
Bid, Open, Close High Low, Spreas Volume and ....

information can save for all time frames in different excel files.

 
Hamed Dehghani:
Hello.
Its not dificult. 
I made mt4 and mt5 data recorder.

To export data from mt4 to excel sheet.
you must have EA can read information that you want and save them in excel sheet.

these information can be.
Bid, Open, Close High Low, Spreas Volume and ....

information can save for all time frames in different excel files.

Anyone go to do the Writing in Google Sheets? <Deleted>

Reason: