I have a list of about 8000 global companies identified using SEDOL identifiers and tickers (for whatever exchanges the companies are listed).

I need to retrieve data about these for a regression, primarily stock returns, but also for instance market capitalisation. How do I do such a query with Bloomberg?

One problem is identification of companies. My data has SEDOLs and tickers, but Bloomberg seem to be based on tickers. How does that work, considering that I guess tickers are not unique, but specific to each exchange?

The main problem is doing this query, where the data for the firms needs to be panel data. Any ideas? Also, what is the best source/community/site for Bloomberg questions?

Best Regards,



1 Answer 1


In excel, use the BDP function.

For example: =BDP("2005973 US Sedol","Px_last")

Where 2005973 is the Sedol number (in this case for IBM), and Px_last is the last price field for this stock.


Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.