Getting started with excel and live MT4 data

 
Guys,

I just discovered DDE and able to get live data to excel, fantastic stuff.

I like to ask someone, how and where to get started if I want to record the data of OHLC of certain time frames, for example at the close of the hour, I want data of the last hour in 60 min candle, 30 min candle etc...

From there I think I'm able to do everything else but I'm not sure how to separate the candles and how to pull the data out at the specific time.

Thanks for listening
 

Is thier anyway to log prices at specific times with mt4 and dde server ?

pedropip:
Guys,

I just discovered DDE and able to get live data to excel, fantastic stuff.

I like to ask someone, how and where to get started if I want to record the data of OHLC of certain time frames, for example at the close of the hour, I want data of the last hour in 60 min candle, 30 min candle etc...

From there I think I'm able to do everything else but I'm not sure how to separate the candles and how to pull the data out at the specific time.

Thanks for listening

 

You can use the "Export-RT-Historical-Data-for-Ramp" MT4 indicator. It creates real time streaming .csv files that you can open in excel or any other program. It is free at http://www.ramprt.com/mt4/Ramp-MT4-Connection-Instructions.htm.