Bloomberg Excel Add-in

[nca77]

is anyone familiar with the bloomberg add-in?

is it possible to have the bloomberg formula refernce a cell that ca
be mannually changed.

example:

=BLP|M!'C Equity,[LAST_PRICE]'

can that formula somehow reference a cell to "grab" the ticker symbol?

let's say you have the ticker symbol in A1 = "C"

something like this?

=BLP|M!'$A$1&" Equity",[LAST_PRICE]'


thanks,

nic