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$

3 Answers 3

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$
6
  • $\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$ Feb 18, 2015 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$ Feb 18, 2015 at 4:12
  • $\begingroup$ Just enter those into the fields in the results screen of EQS, I updated the answer with the instructions $\endgroup$ Feb 18, 2015 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$ Feb 19, 2015 at 18:13
  • $\begingroup$ also, will this also help to extract securities traded on OTC? $\endgroup$ Feb 19, 2015 at 18:24
2
$\begingroup$

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

$\endgroup$
1
  • $\begingroup$ Also maybe some samples here can help too : ftp.nyxdata.com $\endgroup$
    – nelpler
    Feb 24, 2015 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$
1
  • $\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$ Feb 18, 2015 at 2:51

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.