I am totally ignorant and am in need of some help with a DDE ‘problem’. Basically I downloaded the Excel Add-in ‘Stock Market Functions’ which is able to pull down data for given stocks from the internet. As it stands the data is organized as an array, where the first column is the stock symbol and the other columns are specific data for the stock symbols such as ‘name’, ‘% change’,’last price’, ‘volume’ etc.
So basically each row has the data for a unique stock symbol. What I want is Excel to pass this data by DDE to an external program which will process the data. I am using Personal Stock Monitor to collect data at the moment- but it is no longer supported. The external program accepted data from PSM using the following DDE syntax "Program|Folder\subfolder\stock symbol!topic" eg. "PSM|My portfolio\IBM!volume"
What do I have to do to the data in my Excel so it behaves similarly and I can add or remove stocks from the spreadsheet without disturbing the links, resort etc? As it is I can’t see the way to associate the ‘topic’ with the stock symbol to get it into the ancillary program. Any advice or hints appreciated.