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