question

Upvotes
Accepted
priyanka avatar image
11 ●1 ●0 ●0

Getting 'Access Denied ' error message when pull Short Interest?

Hi,

I have tried to pull the SID-Short Interest value by using DSWS API. Plesae refer the below code,

Instrument = 'BRKb';

StartDate = '2010-01-01';

EndDate = '2020-05-31';

Frequency = 'D';

sec = ['<',Instrument,'>'];

fields = 'SID';

Data = history(c,sec,fields,StartDate,EndDate,Frequency)

I am getting following error message '$$ER: 2370,ACCESS DENIED FOR SID' when tried to pull the 'SID' field value. But i can able to pull 'P','PI','RI' field values. Did i do anything wrong to pull the 'SID' field value? Can anyone please suggest?


Thank You,

Priya

datastream-apidsws-api
icon clock
10 |1500

Up to 2 attachments (including images) can be used with a maximum of 5.0 MiB each and 10.0 MiB total.

1 Answer

Upvotes
Accepted
Jirapongse avatar image
38.1k ●69 ●35 ●53

@priyanka

I can retrieve the data properly.

StartDate = '2010-01-01';
EndDate = '2020-05-31';
df = ds.get_data(tickers="<BRKb>",fields=['SID'] , start=StartDate, end=EndDate, freq='D')
df.dropna()

You may try to retrieve it with DataStream in Excel. 

=DSGRID("<BRKb>","SID","2010-01-01","2020-05-31","D","RowHeader=true;ColHeader=true;DispSeriesDescription=false;YearlyTSFormat=false;QuarterlyTSFormat=false","")
If you still get the same error,

If you still get the same error, it could be a permission issue. Then, please directly contact the DataStream support team via MyRefinitiv.


1593052893513.png (18.8 KiB)
1593053247618.png (16.0 KiB)
icon clock
10 |1500

Up to 2 attachments (including images) can be used with a maximum of 5.0 MiB each and 10.0 MiB total.

Click below to post an Idea Post Idea