MT4 and excel integration

Hi guys,

I new to excel so bear with me. I'm not sure if someone here uses MT4 and excel.

I can get live data from a Metatrader forex chart through DDE link to excel, for me to get live data streaming into excel I need to put these code in indivdual cells:

=MT4|BID!EURUSD
=MT4|ASK!EURUSD
=MT4|HIGH!EURUSD
=MT4|LOW!EURUSD
=MT4|TIME!EURUSD

But what I want to do is to record this live data into excel so I can use this data to manipulate later on such as build different time candles etc...

I really want to download past meta trader history and Metatrader history is there to download but I not sure if I can run it together with the live feed to get a continuous stream of data with looking at past history, also not sure if this is truly difficult to do in excel.

Anyway I hope I make sense