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

• Datastream Web Service: Getting Started With R
• Datastream example in Jupyter R

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