Cannot get ICSBN, and SECD datatype from DataStream API

Question

Question by daniele.grassi · Feb 24 at 09:15 AM · sedol api datastream icsbn

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).

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.

1614157930181.png (22.0 KiB)

1614157995670.png (8.3 KiB)

0

10 |1500 characters needed characters left characters exceeded

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

Answer 1 · 2021-02-25T02:24:29Z

Best Answer

Answer by jirapongse.phuriphanvichai · Feb 25 at 02:24 AM

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)

1 · Share

10 |1500 characters needed characters left characters exceeded

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