Lookup Cell Fed Via A DDE Link

I am trying to build a stock watchlist in excel 2007 with a dynamic link to a DDE server (paid for).There is no add-in or plug-in, I just CTL ALT & drag each code from a watchlist in the program I am using and place it in a cell, however can only choose one data field at a time. There are 14 data fields and over 150 codes in my list which makes 2100 cells. (My guess is about 3 days work)

I would like to just enter the stock code in say column A (A3) and with each DDE data field (e.g. lastprice, open, cose, high etc) entered in subsequent columns have it lookup the stock code in cell A3 and return the correct value based on the code in column A, rather than entering each cell individually.

Is it possible to write a macro or vba code to create the cell formula so I can just fill down and save myself 3 days work?

The DDE server I am using is formatted like this:

PROGRAMNAMElDATAFIELD!STOCKCODE

example

MISDATAlLASTPRICE!BHP.ASX

I thought I might be able to do something like the following, but it doesn't seem to work.

MISDATAlLASTPRICE!$A3

Note: The DDE server can only be accessed while the other program is running and is password protected