I have never used DDE. Are you saying that at any point in time there is
only the raw data for one company in the worksheet? If so, are you hoping
that the DT will re-run a series of queries and each time calculate the
appropriate moving averages? I have no idea whether Excel will do that. It
seems to me though that, if this is happening, then the data for the last
company in the list (HP in your example) will be in the sheet. Is it?

--
Jim Rech
Excel MVP