question

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

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 512.0 KiB each and 1.0 MiB total.

veerapath.rungruengrayubkul avatar image   veerapath.rungruengrayubkul

Hello @priyanka,

Thank you for your participation in the forum.

Is the reply below satisfactory in resolving your query? If yes please click the 'Accept' text next to the reply. This will guide all community members who have a similar question. Otherwise please post again offering further insight into your question.

Thanks,

AHS

1 Answer

· Write an Answer
Upvotes
Accepted
Jirapongse avatar image
78.9k ●250 ●52 ●74

@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 512.0 KiB each and 1.0 MiB total.

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

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