DDE live prices

Hi guys,

I have some prices updating in excel real time through DDE 24 hours a day. I want if possible to take the average of that prices per hour.

On attached sample B/C/D columns are updating from the MT4 platform. Column B is the time of the last update column C is the price and column D is the ASK price. Column E shows the spread which is ASK minus BID price. That i want is to have the average of Spread (column E) per hour. So column F will show me the average of column E between 00:00 and 01:00, column G between 01:00 and 02:00 and so on.

From what i understand somehow the column E should save the data.

Hope i was clear

Thanks

AttachmentSize
Spread.xls52 KB
Nick's picture

have a look