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
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
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
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?
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
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
now you understand my question
thx
maybe a VBA guru can offer a suggestion to copy your d/l data to another location for the min/max
Does the DDE write trigger a worksheet change event?
Entia non sunt multiplicanda sine necessitate
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
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
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks