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
Attachment | Size |
---|---|
Spread.xls | 52 KB |
have a look
have a look here:
http://excelexperts.com/VBA-Tips-Run-Code-Every-Hour-Minute-or-Second