question

Upvotes
Accepted
3 0 0 4

Datastream API fails to pull WC05350 for sample ISINs

Regular Datastream can pull WC05350 for ISINs below but API fails and returns NA:
IE00BY7QL619

US18482P1030

US1251411013

US0025353006
Please help fix the issue

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.

@Wasin Waeosri

Regarding your question if the ISIN names are valid, I checked Eikon and it can read the ISINs just fine:

IE00BY7QL619 - Johnson Controls International PLC
US18482P1030 - Clearfield Inc

US1251411013 - Ceco Environmental Corp

US0025353006 - Aaron's Inc

Is there a way we can apply a fix on the Datastream API issue? Thanks!

Hello @AGB

I have contact Datastream team to verify this query.

Upvotes
Accepted
681 2 2 1

Hi,

Here we can see that you have used LATEST VALUE within your request. Therefore you will need to use LATESTDATE as the START Date within DSWS.

Best regards

James

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
681 2 2 1

Hi, This isn't a DSWS question. The ISIN's work fine. Please contact the helpdesk to identify why we do not have this Worldscope content for these ISINs.

Best regards

James

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
3 0 0 4

Hi @James.Bright1

I am from the helpdesk. There is Worldscope content for these ISINs and it works fine via normal Datastream product. Here's the formula and result:

=DSGRID("IE00BY7QL619,US18482P1030,US1251411013,US0025353006","WC05350","Latest Value","","","ColHeader=true;DispSeriesDescription=true;DispDatatypeDescription=true","")

FISCAL PERIOD END DATE
30/09/2018

30/09/2018

31/12/2018

31/12/2018

This proves the following:

1) There IS Worldscope content for the ISINs

2) The issue is with DSWS product not being able to pull up the content

Please help.

Regards,

Amor Galvez-Barcelona

ADVANCED SUPPORT EXECUTIVE, AIM

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.