Bloomberg xl function - a simple question

  • Thread starter Thread starter ben.biddle
  • Start date Start date
B

ben.biddle

I don't have a complex problem to solve. I have a spreadsheet with the
ticker symbols for some exchange traded options, but no cusips. I'm
just looking for a Blmbrg function that I can use to pull in the cusips
using the ticker. I'll use the spreadsheet on an ongoing basis and the
tickers may change so just entering them one time from a Blmbrg screen
isn't desirable. Any help? I'm a total novice to the whole Blbrg DDE
thing. Thanks in advance. I promise, next time I'll try to bring
something more interesting/challenging to the table.
 
Ben,

as an example... gm us 6/06 c2.5

the BLP function would look like this... =blp(A1&" equity","id_cusip")

were cell A1 = gm us 6/06 c2.5

Hope that helps!
 
Back
Top