+ Reply to Thread
Results 1 to 6 of 6

Average on Prices from DDE

  1. #1
    Registered User
    Join Date
    12-17-2014
    Location
    Limassol, Cyprus
    MS-Off Ver
    Ms office 2013
    Posts
    22

    Average on Prices from DDE

    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??

  2. #2
    Forum Guru samba_ravi's Avatar
    Join Date
    07-26-2011
    Location
    Hyderabad, India
    MS-Off Ver
    Excel 2021
    Posts
    8,904

    Re: Average on Prices from DDE

    pls attach sample file with expected result
    Samba

    Say thanks to those who have helped you by clicking Add Reputation star.

  3. #3
    Registered User
    Join Date
    12-17-2014
    Location
    Limassol, Cyprus
    MS-Off Ver
    Ms office 2013
    Posts
    22

    Re: Average on Prices from DDE

    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
    Attached Files Attached Files

  4. #4
    Forum Expert bebo021999's Avatar
    Join Date
    07-22-2011
    Location
    Vietnam
    MS-Off Ver
    Excel 2016
    Posts
    9,412

    Re: Average on Prices from DDE

    It's not enough data to make Average. Provide more pls.
    Quang PT

  5. #5
    Registered User
    Join Date
    12-17-2014
    Location
    Limassol, Cyprus
    MS-Off Ver
    Ms office 2013
    Posts
    22

    Re: Average on Prices from DDE

    I want the average of spread each hour and each symbol. What more data you want?

  6. #6
    Registered User
    Join Date
    12-17-2014
    Location
    Limassol, Cyprus
    MS-Off Ver
    Ms office 2013
    Posts
    22

    Re: Average on Prices from DDE

    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
    Attached Files Attached Files

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. [SOLVED] Average prices etc
    By Bandini in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 09-12-2014, 10:10 PM
  2. [SOLVED] Extracting latest prices from a price book with past and present prices
    By benoj2005 in forum Excel Formulas & Functions
    Replies: 9
    Last Post: 08-10-2012, 04:08 AM
  3. Prices average
    By tofimoon4 in forum Excel - New Users/Basics
    Replies: 4
    Last Post: 11-14-2011, 02:51 AM
  4. Average prices for products throughout time
    By josepablocam in forum Excel General
    Replies: 4
    Last Post: 07-26-2010, 07:57 AM
  5. challenging "share stock" average prices
    By amrezzat in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 11-17-2005, 08:23 AM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1