question

Upvotes
Accepted
Pocari Sweat avatar image
5 ●1 ●2 ●5

Getting CO2 Emissions data from Datastream (eg: datatype 'ENERDP023')

Hi all,

I would like to get CO2 data for the ENERDP.. DataTypes (as per http://product.datastream.com/browse/search.aspx?dsid=ZCAZ146&AppGroup=DSAddin&dt=true&q=CO2&prev=dtx1%7C0001_0001_0006&subset=dtx1%7C0001_0001_0006 )

I need to use DataStream programatically (R or Python or whatever) for this (no Eikon API)

I thought I was in luck, because the R tutorial at https://developers.refinitiv.com/sites/default/files/Getting%20Started%20with%20R_0.pdf actually uses the ENERDP.. points in its final example. But, running that R code only returns NA values for all the ENERDP points. (works with something simple like P for price, but 'NA' for the ENERDP..)

My question is: should that R tutorial be returning data for ENERDP023 for example? If so, any ideas why I only receive NA, no matter if I go back -20Y years? If those dataTypes truly don't have data behind them, why? Is it just a bad tutorial? Or are there a very limited number of securities that have this data, and does anyone have any examples?


Any help appreciated,

thanks

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.

1 Answer

Upvotes
Accepted
Jirapongse avatar image
56.2k ●145 ●45 ●65

@Pocari Sweat

I have run the code and found that some data points are NA for "ENERDP024", "ENERDP025", "ENERDP096", "ENERDP023", "ENERDP123", and "ENERO03V". 

xtsData <- mydsws$timeSeriesListRequest(instrument =
c("U:F","U:BA","U:CAT","U:CVX","U:KO","U:XOM","@INTC","U:JNJ","U:IBM"),
 datatype =
c("ENERDP024","ENERDP025","ENERDP096","ENERDP023","ENERDP124","ENERDP027","ENERDP123","ENPIDP029","ENERO03V"),
 startDate = "-10Y",
 endDate = "-0D",
 frequency = "Y")

It returns all NA for "ENERDP124", and "ENERDP027".

For "ENPIDP029", only "U:F" returns the data.

To verify the data, you can directly contact the DataStream support team via MyRefinitiv.




1594956615027.png (16.7 KiB)
1594956805770.png (17.4 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.