MATLAB: How to query securities with different security IDs from Bloomberg on MATLAB 7.10 (R2010a)

Datafeed Toolbox

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.

Best Answer

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
Related Question