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
$\begingroup$
$\endgroup$
Add a comment
|
3 Answers
$\begingroup$
$\endgroup$
6
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)
-
$\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$ Commented 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$ Commented 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$ Commented 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$ Commented Feb 19, 2015 at 18:13
-
$\begingroup$ also, will this also help to extract securities traded on OTC? $\endgroup$ Commented Feb 19, 2015 at 18:24
$\begingroup$
$\endgroup$
1
Maybe try http://bsym.bloomberg.com/sym/ see left bottom part "predefined files".
-
$\begingroup$ Also maybe some samples here can help too : ftp.nyxdata.com $\endgroup$– nelplerCommented Feb 24, 2015 at 16:57
$\begingroup$
$\endgroup$
1
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).
-
$\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$ Commented Feb 18, 2015 at 2:51