Export OHLC data to csv for use in excel

Hello,

I have lots of daily charts opened in MetaTrader 5 and I currently use Ctrl&S to save them to csv manually.

I would like to automate this to save time.

It needs to export all loaded OHLC price data in the opened charts and is automatically updated at a timed interval in minutes that I can adjust.

A separate file will be created for each market and every time It updates the original file is overwritten as the CSV files will be connected to excel.

Kind Regards