I have noticed that many stock price data vendors that offer realtime data allow the data to be imported dynamically into Excel via DDE links. The DDE links are array formulas to be placed in the respective cells/columns eg:

= ADDE|Nyse_C!BidPrice
= ADDE|Nyse_C!AskPrice

and so on.

So, if I have a ticker (C) in A2, with the above formulas in B2, C2 and I want to change the ticker to a new stock, I have to manually change the symbol in each of the above array formulas too. So, for many values (eg. BidPrice, AskPrice, Volume, PreviousClose .... ) - it can take time.

Is there a way around this, such that if I change the symbol, it gets updated to all the cells/formulas automatically?

Thank you.