question

Upvotes
Accepted
utalwar avatar image
1 ●0 ●0 ●3

DatastreamDSWS returns "NA" for "SECD" (SEDOL) using the "get_data" method

I am using the Datastream API for Python. It returns "NA" values - when I use the "DSGRID" Excel Add-in on the same list of securities, I get the required "SECD" values. My code:


securities = ['US0235861004', 'US29362U1043', 'US5393192027', 'US07134L1070', 'CA91702V1013', 'US0008681092', 'US4281031058', 'US16411R2085', 'INE733E01010', 'US18270D1063']


fields = ['SECD']
sec_str = "".join(['{},'.format(x) for x in securities])[:-1]
secd_list = ds.get_data(tickers=sec_str, fields=fields, kind=0)


Output:

screen-shot-2022-07-28-at-50321-pm.png

datastream-apidatastream-for-office
screen-shot-2022-07-28-at-50321-pm.png (78.9 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.

wasin.w avatar image   wasin.w

Hello @utalwar

Thank you for your participation in the forum. Is the reply below satisfactory in resolving your query?


If so please can you click the 'Accept' text next to the appropriate reply? This will guide all community members who have a similar question.

Thanks,


AHS

wasin.w avatar image   wasin.w
Hello @utalwar

Does the problem still persist in your environment?

If so, please give us more information as requested by @Jirapongse

raksina.samasiri avatar image   raksina.samasiri

hi @utalwar

I'm afraid we haven't heard from you in a while and we cannot provide further assistance without the details we asked for. I'm closing this thread. If you need any further assistance, please start a new thread.

Thanks,
AHS

2 Answers

· Write an Answer
Upvote
Accepted
Jirapongse avatar image
79.2k ●251 ●52 ●74

@utalwar

Does the problem still occur?

If yes, please specify the versions of Python and DatastreamDSWS that you are using.

Moreover, please use the below code at the beginning to log all HTTP requests and responses.

import logging
import http.client 
http.client.HTTPConnection.debuglevel = 1 
logging.basicConfig()
logging.getLogger().setLevel(logging.DEBUG)
requests_log = logging.getLogger("requests.packages.urllib3")
requests_log.setLevel(logging.DEBUG)
requests_log.propagate = True

The output looks like this:

1659593738956.png


1659593738956.png (78.9 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.

Upvotes
raksina.samasiri avatar image
14.2k ●30 ●5 ●10

hi @utalwar ,

I used the same code to verify the value, the result is as below

1659324484408.png

This could be a permission issue or month-to-date usage exceeds the limit

To check, first, you may check your usage if it exceeds the limit (You can read more about DSWS usage stats and limits for Desktop users here)

ds.get_data(tickers='STATS', fields=['DS.USERSTATS'],kind=0, start='2021-01-15')

Then, test the request via the DswsClient website to check if you have the right permission using Datastream Python library to retrieve this data. In the example response below, the value can be retrieved properly

1659325053211.png

Hope this helps and please let me know in case there's any further questions


1659324484408.png (52.1 KiB)
1659325053211.png (74.3 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.

utalwar avatar image utalwar

Thank you for your response. My usage is well below the limit. While using the Dsws Client website, I get the following response:

screen-shot-2022-08-01-at-93835-am.png

screen-shot-2022-08-01-at-93835-am.png (222.2 KiB)

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.