Hi - i want to download in R ASX200 constituents, their price and weight in a time series? many t...

jared.grylls

Hi - i want to download in R ASX200 constituents, their price and weight in a time series? many thanks

Find more posts tagged with

datastream-api

dsws-api

Accepted answers

Jirapongse

@jared.grylls

You can use the DatastreamDSWS2R from https://github.com/CharlesCara/DatastreamDSWS2R.

I assume that ASX200 is S&P/ASX 200. The symbol for this constituent is LASX200I.

The data type for price and weight should be P and WTIDX.

P is "Price - Trade" while WTIDX is "% Weight Of Each Constituent Within The List".

The code to retrieve the price and weighting is:

listDataFrame <- mydsws$listRequest(instrument = "LASX200I",
                                    datatype = c("NAME","MNEM","P","WTIDX"), 
                                    requestDate=Sys.Date())

The result is:

You can retrieve the time series data for P with the following code.

mydsws$chunkLimit <- 20L
xtsData <- mydsws$timeSeriesListRequest(instrument = "LASX200I",
                       datatype = "P",
                       startDate = "-30D",
                       endDate = "-0D",
                       frequency = "D")
xtsData

From my finding, WTIDX is not a time series type so you can't retrieve WTIDX in time series.

However, you need to directly contact the Datastream support team via my.refinitiv.com for confirmation.

For more information, please refer to the following resources.

All comments

Jirapongse

@jared.grylls

You can use the DatastreamDSWS2R from https://github.com/CharlesCara/DatastreamDSWS2R.

I assume that ASX200 is S&P/ASX 200. The symbol for this constituent is LASX200I.

The data type for price and weight should be P and WTIDX.

P is "Price - Trade" while WTIDX is "% Weight Of Each Constituent Within The List".

The code to retrieve the price and weighting is:

listDataFrame <- mydsws$listRequest(instrument = "LASX200I",
                                    datatype = c("NAME","MNEM","P","WTIDX"), 
                                    requestDate=Sys.Date())

The result is:

You can retrieve the time series data for P with the following code.

mydsws$chunkLimit <- 20L
xtsData <- mydsws$timeSeriesListRequest(instrument = "LASX200I",
                       datatype = "P",
                       startDate = "-30D",
                       endDate = "-0D",
                       frequency = "D")
xtsData

From my finding, WTIDX is not a time series type so you can't retrieve WTIDX in time series.

However, you need to directly contact the Datastream support team via my.refinitiv.com for confirmation.

For more information, please refer to the following resources.

jared.grylls

hi - many thanks for your response.

the problem i am now facing is that, using the code you mentioned, it doesn't update the constituent list throughout time (Stocks come in and out normally quarterly). i think i will have to do something like the below: however this only works for monthly, instead of LASX200I1219, how could i get change the instrument to get weekly?

mydsws$listRequest(instrument = 'LASX200I1219',

datatype = list('WTIDX','WC13010','MV','P','RV','PO'),

requestDate = "0D")

thanks again

Jared

Jirapongse

@jared.grylls

Thank you for sharing.

I am unable to find instruments for the weekly constituent list. Please contact the Datastream support team via my.refinitiv.com for the way to the weekly constituent list.

EXPLORE OUR SITES