2
$\begingroup$

I need to extract an exhaustive list of securities with CUSIPs and ISINs on bloomberg. This data needs to be on a global level. Can someone help with the formulae on bloomberg please?

Cheers, G

$\endgroup$
2
$\begingroup$

Just use the EQS function and grab all active securities (primary listing only unless you want the same one per each exchange)

Specify in the resultscreen for isin and cusips in the add columns field

Click results in EQS Enter ISIN in the Add column entry and hit enter (repeat that for cusip too)

$\endgroup$
  • $\begingroup$ Thank you!! Can you please specify the steps to get the end result for ISIN and CUSIPs? Also, is there any online source as an alternative to bloomberg? $\endgroup$ – Gitanjali Mathur109 Feb 18 '15 at 2:34
  • $\begingroup$ also, can you please share how to extract all listings (other than primary listings), country traded in, industry and sector etc.. $\endgroup$ – Gitanjali Mathur109 Feb 18 '15 at 4:12
  • $\begingroup$ Just enter those into the fields in the results screen of EQS, I updated the answer with the instructions $\endgroup$ – Kyle Balkissoon Feb 18 '15 at 15:01
  • $\begingroup$ Hi Kyle, thank you for your prompt help and reply. Will this help me retrieve securities in all listings ie. primary and otherwise? $\endgroup$ – Gitanjali Mathur109 Feb 19 '15 at 18:13
  • $\begingroup$ also, will this also help to extract securities traded on OTC? $\endgroup$ – Gitanjali Mathur109 Feb 19 '15 at 18:24
2
$\begingroup$

Maybe try http://bsym.bloomberg.com/sym/ see left bottom part "predefined files".

$\endgroup$
  • $\begingroup$ Also maybe some samples here can help too : ftp.nyxdata.com $\endgroup$ – nelpler Feb 24 '15 at 16:57
0
$\begingroup$

You should press the green "help" key on the Bloomberg terminal twice to communicate with their helpdesk.

However, in general you can simply use the "BDP(CUSIP, PRICE)" or "BDH(CUSIP, PRICE; STARTDATE, ENDDATE)" function with Bloomberg's Excel Addin (e.g. https://stackoverflow.com/questions/20080470/bloomberg-bhd-function-with-isin).

$\endgroup$
  • $\begingroup$ Thank you!! Can you please specify the steps to get the end result for ISIN and CUSIPs? Also, is there any online source as an alternative to bloomberg? $\endgroup$ – Gitanjali Mathur109 Feb 18 '15 at 2:51

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

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