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.
Any suggestions??
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.
Any suggestions??
pls attach sample file with expected result
Samba
Say thanks to those who have helped you by clicking Add Reputation star.
I have MT4 platform that I am trading. I connected MT4 with excel and I can see prices updating real time on excel as in MT4. Column B is the time of the last update of the BID and ASK price. Spread is the difference between BID and ASK. I want to see what was the spread each hour.
Thanks
It's not enough data to make Average. Provide more pls.
Quang PT
I want the average of spread each hour and each symbol. What more data you want?
Just to explain better what i want. B/C/D columns are updating from the MT4 platform. Column B is the time of the last update column C is the BID 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 and so on.
Hope i was clear
Thanks
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks