DDE link syntax

[stack]

I am using a DDE server to pull stock/option quotes into an excel spreadsheet. I am able to call to the server and symbols by using this formula:

=STIDDE|Q!'MSFT,1'

STIDDE = server
Q! = quotes
MSFT = Microsoft
1= field type (1 = Last Price, 2 = Bid, 3 = Ask, etc)

My problem comes when trying to automate the formula so that the 'field type' cells change with a change in the stock symbol.

Example:
Stock Symbol MSFT is in cell C27, the price (=STIDDE|Q!'MSFT,1') in cell C28.

One of my many attempts was changing C28 to =STIDDE|Q!'$C27&",1"' (wrong! )

What is the correct syntax to add the result of cell C27 into the formula in C28?