Good with MT4, DDE and microsoft excel? Need help!

Ok so just recently managed to get pip data recording with the currency pair EUR/USD with excel 2007 on a workbook i had prepared from MT4 using DDE. I am having some difficulty though as i am trying to formulize the pip data first by totalling it per hour as thats the time frame im looking at, but sometimes i dont think excel is recording every single pip that occurs through MT4 which i find odd as its a direct feed.

Im not sure what im doing wrong, if anyone has had experience with this it be good to know what to do to overcome it?

After finally getting my DDE to work I had the same problem and gave up on DDE for now.

I checked the tics on MT4 and at the same time the tics on XL via DDE.
XL appears to miss some of the tics.

Can someone please explain why this would be or what to do to correct it.

Any help much appreciated.