Stock Function cannot reference another cell

Stock Function cannot reference another cell


This works
=STOCK("GOOG","PRICE")
But this doesn't (reference symbol from other column)
=STOCK(B3,"PRICE")
(B3 is the cell which has the string "GOOG")

So its very hard to use the function generically (where symbol is in one column)
ramganesh