Hi there,
I am trying to build a stock watchlist in excel 2007 with a dynamic link to a DDE server (paid for).
I would like to just enter the stock code in say row 1 (A3) and with each DDE data field (e.g. lastprice, open, cose, high etc) have it lookup the stock code in cell A3 and return the correct value, rather than entering 200 x 7 stock codes and DDE data fields.
The DDE server I am using is formatted like this:
PROGRAMNAMElFIELD!STOCKCODE
example
MISDATAlLASTPRICE!BHP.ASX
I thought I might be able to do something like the following, but it doesn't work:
MISDATAlLASTPRICE!$A3
Note: 1 there is no add-in, I just drag from a watchlist in the program I am using.
2 The DDE server can only be accessed while the other program is running and is password protected
Could anyone help please, I'd be very greatful
Bookmarks