Good with MT4, DDE and microsoft excel?

Beginner Questions
1

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?

2

I’m not familiar with dde, but tell us really what your trying to acomplish, there may be an easier way.
As I get it now, you want data for the h1 timeframe, and you can export that with a custom indicator.

3

Flyer thanks for the reply basically DDE allows you to import any data you want from the MT4 platform straight into excel. That includes real time pip data (up and down) as candlesticks are forming you can watch it in excel exactly as you would be watching price moving up and down directly through mt4. I have the price movement in one cell. What i am trying to do is work out some calculations using the pip data that is being populated but excel seems to miss some of the data as you know pip movement can be so fast so the calculations are wrong.

This is what i need a solution for.

4

have you considered using a database? much better I think.

5

Thanks for this what do you suggest? Also would i be able to have live data feeds for pip data and would the database be fast enough to handle the speed of the pip figures movements to keep score so i could perform calcs?

6

Have a look at this piece of code - http://www.m-t-a-w.com/indicatorsandea/TicksInMySQL.mq4

you also need the libmysql.dll file in your indicators folder, don’t know if will help but I’m sure it’s worth consideration, it’s not very hard to set up Mysql on your computer.

7

I think the best way to solve your problem is to learn mql (not too hard) and build a custom indicator yourself

8

So doing it withing MT4 as mql developing a indicator ill be able to run any calculations i need right?

9

What does this exactly do?

10

Yes. That was exactly my point.

11

Thanks dude, have you a lot of experience developing complex indicators?

12

I have some experience, but not much. I can give you a good place to start though: Mql - Metatrader Development Course | metatrader.info. A bit old, hacked, and incomplete, but I haven’t found anything better.