Excel to mt4 - can't find my answer

I know this has been a topic in many places but i cant find the answer im looking for

I have the dde-sample that comes with mt4
It works, no problems
but how do i change it to register the last closed candle,on whatever time frame ,to HLC rather than the hi and lo for the day?

Previously discussed here.

http://www.forexfactory.com/showthre...18#post4351018