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.

2 Answers

· Write an Answer
Upvote
Accepted
Jirapongse avatar image
80k ●257 ●52 ●75

@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.4k ●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.