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

[[Deleted]]

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?