How can I query securities with different security IDs from Bloomberg on MATLAB 7.10 (R2010a)?

2 views (last 30 days)
I would like to query Sedol securites from Bloomberg. I could not find any appropriate documentation for it.
I am using the following code:
 
conn=blp;
tmp = getdata(conn, tmpSedols,{'TICKER_AND_EXCH_CODE','MARKET_STATUS'});
Also, I try to use the following security names:
'B1TQ2V0 Equity'
'6208842 Equity'
'6290689 Equity'
'6569163 Equity'
I have a problem in that the original 'tmpSedols' is 4833 rows long but the length of the returned vector from the function is only 488. I suspect that this is due to multiple Sedols having a conflict. I am looking for a correct way to specify Sedol numbers.

Accepted Answer

MathWorks Support Team
MathWorks Support Team on 10 Mar 2017
hen specifying a Sedol1 id, you need to prepend "/sedol1/" to the security name. For example, for B1TQ2V0, this would be "/sedol1/B1TQ2V0".
This is the full command:
tmp = getdata(conn,'/sedol1/B1TQ2V0', {'TICKER_AND_EXCH_CODE','MARKET_STATUS'});
Each 'sedol1' number must be preceded with the '/sedol1/' string. You do not need to use the 'Equity' string.
Other valid security type id's are
ticker
cusip
wpk
isin
sedol1
sedol2
sicovam
common
svm
cins
cats

More Answers (0)

Tags

No tags entered yet.

Products


Release

R2010a

Community Treasure Hunt

Find the treasures in MATLAB Central and discover how the community can help you!

Start Hunting!