Regular Datastream can pull WC05350 for ISINs below but API fails and returns NA:
IE00BY7QL619
US18482P1030
US1251411013
US0025353006
Please help fix the issue
3
●0 ●0 ●3
Datastream API fails to pull WC05350 for sample ISINs
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!
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
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
3
●0 ●0 ●3
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
