question

Upvotes
Accepted
daniele.grassi avatar image
1 ●0 ●1 ●0

Cannot get ICSBN, and SECD datatype from DataStream API

Hello, I am trying to use the DataStream API to get sector name (ICSBN) and sedol code (SECD) for a list of mnemonics (example: B:ABI).


Even if these attributes do exists (I can clearly see them using DataStream) the API requests returns NA.

Can you help me to understand why does this happen and how to solve the problem?


Please find below a screenshot of my request and the related response (The SECD for B:ABI is BYYHL23).



In addition, according to the answer to this question https://community.developers.refinitiv.com/questions/72952/datastream-api-datatypes.html

I should be able to obtain the same results using both the API and the Excel Add-in. Unfortunately though, I get different results.

This is what I get if I ask for SECD using the Excel add-in.

TypeSEDOL CODEB:ABIBYYHL23


And here's my excel request.

=@DSGRID("B:ABI","SECD","-0D","","","RowHeader=true;ColHeader=true;DispSeriesDescription=true;DispDatatypeDescription=true","")


Thanks in advance.

datastream-apidsws-api
1614157930181.png (22.0 KiB)
1614157995670.png (8.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.

Alex Putkov.1 avatar image   Alex Putkov.1

@daniele.grassi

Thank you for your participation in the forum. Are any of the replies below satisfactory in resolving your query? If yes please click the 'Accept' text next to the reply that best answers your question. This will guide all community members who have a similar question. Otherwise please post again offering further insight into your question.

Thanks,

-AHS

wasin.w avatar image   wasin.w

Please be informed that a reply has been verified as correct in answering the question, and has been marked as such.

Thanks,


AHS

1 Answer

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

@daniele.grassi

I can get the data properly.

The response is:

You need to contact the Refinitiv Datastream Web Service team via MyRefinitiv to verify the problem.


1614219767312.png (29.2 KiB)
1614219784434.png (11.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.