Why does Bloomberg give "Invalid Security" error when using getdata with ISIN

32 次查看（过去 30 天）
MathWorks Support Team
回答： MathWorks Support Team 2017-8-8
I am trying to get total return of a security( given ISIN)  between a start period and end period.
Given ISIN for Nestle  SA is CH0038863350. In excel, I typically combine the ISIN number in following way.
CH0038863350  ISIN and it fetches the required fields.
I am trying to do the same in Matlab but it results in " Invalid  Security"
fromdate1= '06/30/2017';
todate1='07/31/2017';
startDate = datestr(fromdate1,'YYYYmmDD');
endDate = datestr(todate1,'YYYYmmDD');
crncy= 'USD';
z= 'CH0038863350 ISIN' ;
StocksYTDret= getdata(c,z,'CUST_TRR_RETURN_HOLDING_PER',...
   {'CUST_TRR_START_DT','CUST_TRR_END_DT','CUST_TRR_CRNCY'},...
    {startDate,endDate,crncy})
It results in error. Could you tell me what is the best way to get the data as I have 1000+ ISIN numbers to fetch data fronm Bloomberg.

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

采纳的回答

MathWorks Support Team
According to the Bloomberg API, the security ISINs should be given in the format '/isin/CH0038863350'. Failure to do so will return a struct with an ERROR field of "Invalid Security" and the data will be NaN.
>> z = '/isin/CH0038863350';
>> StocksYTDret = getdata(c,z,'CUST_TRR_RETURN_HOLDING_PER',{'CUST_TRR_START_DT','CUST_TRR_END_DT','CUST_TRR_CRNCY'},{startDate,endDate,crncy})

更多回答（0 个）

类别

在 Help Center 和 File Exchange 中查找有关 Data Import and Network Parameters 的更多信息

标签

尚未输入任何标签。

产品


版本

R2017a

Community Treasure Hunt

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

Start Hunting!

Translated by