im trying to import external data from an automatic update source, to evaluate stock performances in a live market environment. the forumla for quoting a real time stock price is:

=PS|QUOTE!'####-HK,last'

where #### is the stock number.

i have in my column A the whole list of stock numbers, and want to place the according formulas in the B column. i tried using the substitute function like this:

=substitute("=PS|QUOTE!'####-HK,last'","####",A1)

where A1 is "0002"

however the function can only output a string of text instead of the actual result of the formula, i.e, =PS|QUOTE!'0002-HK,last'

any advice is appreciated.