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

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.

Answer 1

[MathWorks Support Team]

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