+ Reply to Thread
Results 1 to 11 of 11

Create output cells with MAX and MIN values from a DDE link?

  1. #1
    Registered User
    Join Date
    08-10-2012
    Location
    cbot
    MS-Off Ver
    Excel 2010
    Posts
    5

    Create output cells with MAX and MIN values from a DDE link?

    Have a stock quote service that provides price, volume...bid and offer data in a DDE. Is there a way to record the lowest bid value throughout the day from the DDE bid cell to another cell(and highest offer value to another cell)?

    Know what to do with the data, just don't know how to get it. Would appreciate any help.

    XP SP3, Office 2010

  2. #2
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 2000/3/7/10/13/16
    Posts
    50,749

    Re: Create output cells with MAX and MIN values from a DDE link?

    use =max(cell-range) and =min(cell-range)
    1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
    2. If your question is resolved, mark it SOLVED using the thread tools
    3. Click on the star if you think someone helped you

    Regards
    Ford

  3. #3
    Registered User
    Join Date
    08-10-2012
    Location
    cbot
    MS-Off Ver
    Excel 2010
    Posts
    5

    Re: Create output cells with MAX and MIN values from a DDE link?

    thanks FD, you guys are fast here.

    data feed for bid is only one cell that shows current bid(dynamic). don't have a cell range. that's what's got me scratching a bald spot. need the low/high dynamic bid/offer from those two cells for the day

    thanks again

  4. #4
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 2000/3/7/10/13/16
    Posts
    50,749

    Re: Create output cells with MAX and MIN values from a DDE link?

    ok then i didnt understand your request. if you only have 1 cell, how do you expect to get a min or max from it? sounds like you need to get he min or max from the sourse of that cell?

  5. #5
    Registered User
    Join Date
    08-10-2012
    Location
    cbot
    MS-Off Ver
    Excel 2010
    Posts
    5

    Re: Create output cells with MAX and MIN values from a DDE link?

    thanks again FD. I didn't know if it was possible to record a MIN/MAX value from a 'dynamic' cell, hence the question. guess I'm SOL. appreciate your time

  6. #6
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 2000/3/7/10/13/16
    Posts
    50,749

    Re: Create output cells with MAX and MIN values from a DDE link?

    if you could copy the d/l'd data to other cells throught-out the day, then the min amd max could be applied to that. but just basing it on a single cell that will constantly be changing, without recording all of those changes is a bit like asking...in cell A1, whats the highest value, sorry

  7. #7
    Registered User
    Join Date
    08-10-2012
    Location
    cbot
    MS-Off Ver
    Excel 2010
    Posts
    5

    Re: Create output cells with MAX and MIN values from a DDE link?

    now you understand my question

    thx

  8. #8
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 2000/3/7/10/13/16
    Posts
    50,749

    Re: Create output cells with MAX and MIN values from a DDE link?

    maybe a VBA guru can offer a suggestion to copy your d/l data to another location for the min/max

  9. #9
    Forum Guru shg's Avatar
    Join Date
    06-20-2007
    Location
    The Great State of Texas
    MS-Off Ver
    2003, 2010
    Posts
    40,658

    Re: Create output cells with MAX and MIN values from a DDE link?

    Does the DDE write trigger a worksheet change event?
    Entia non sunt multiplicanda sine necessitate

  10. #10
    Forum Guru JosephP's Avatar
    Join Date
    03-27-2012
    Location
    Ut
    MS-Off Ver
    2003/10
    Posts
    7,328

    Re: Create output cells with MAX and MIN values from a DDE link?

    not usually. you could use a calculate event or link a control to that cell and then use the change event of the control. or perhaps use SetLinkOnData. I don't use dde so can't test any of these theories ;-)
    Last edited by JosephP; 08-13-2012 at 04:11 AM.
    Josie

    if at first you don't succeed try doing it the way your wife told you to

  11. #11
    Registered User
    Join Date
    08-10-2012
    Location
    cbot
    MS-Off Ver
    Excel 2010
    Posts
    5

    Re: Create output cells with MAX and MIN values from a DDE link?

    OK, I've been trying to figure out worksheet change event, calculate event, and SetLinkOnData on my own, but I'm in over my head.

    shg and JP, thanks for the responses. I figured if you saw what I'm working with, maybe you could point me in the right direction

    the attached A1:I3 is the feed from the DDE. I copied what had changed a little later which is A6:I8.

    I'm trying to record the MAX and MIN values of D2 while it is at Price E2, and H2 while it is at Price G2

    If possible J2 would record D2 MAX, K2->D2 MIN, L2->H2 MAX, M2->H2 MIN

    w/o flashing text..
    DDE Link XL Forum.jpg

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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