Dear Sanwar,

the structure of BB tickers is the following “Ticker” & “Country ISO Code”. For example consider the ticker of ABBOTT LABORATORIES (“ABT:US”), which suggests a U.S. equity trading under the ticket “ABT”. I advise you use a formula in excel that isolates all text until the first appearance of “:” (being the required ticker) or simply use text to columns feature and set as your delimiter the “:”.

Based on my experience, ticker symbols don’t change across databases, i.e., WRDS or Compustat, and thus you can use the extracted tickers to match your dataset. To the best of my knowledge, there is no way for bulk searching companies in Bloomberg’s online platform, unless you subscribe to the database.

Regards,

Antonis