How to export live and previous bars data from mt4 to Excel?

I did “DDE” enabled in MT4 and Excel displays low, high, open and close prices and it is updated and also shows the opening value, but it only receives from the daily bar.

I want to get the close, open, high, low values ​​of the previous(and live) bar in H1 /or others and the prices should be updated in excel whenever a new bar is created.

Does anyone know how to do it?

I am also looking for an answer to it. I hope that I will find some good recommendations here.