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

1 次查看（过去 30 天）
MathWorks Support Team
编辑： MathWorks Support Team 2017-3-10
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.

请先登录，再回答此问题。

采纳的回答

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

更多回答（0 个）

类别

在 Help Center 和 File Exchange 中查找有关 Equity Derivatives 的更多信息

标签

尚未输入任何标签。

产品


版本

R2010a

Community Treasure Hunt

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

Start Hunting!

Translated by