I would like to generate a list of company codes (ISIN or Mnemonics) that meet the criteria of being in a certain TRBC industry or activity group. I am using the DataStream API in R.
For example, If I wanted a list of the securities that fall under the TRBC 2012 hierarchical ID of 59 (utilities) how would I structure that query using DataStream in R?
You may need to use LTOTMKAU instead with the listRequest method.
listDataFrame <- mydsws$listRequest(instrument = "LTOTMKAU", datatype = c("MNEM","NAME"), requestDate="0D") listDataFrame
For other lists, you can use the Datastream Navigator to search for instrument names. For example, I found a lot of items relating to TRBC.
Otherwise, you can directly contact the Refinitiv Datastream Web Service support team via MyRefinitiv to find items for you.
As a follow up, what I'm trying to do is get a list of firms that meet static criteria. Here is an example of me trying to generate a list of firms in TOTMKAU (the Australian market)
a <- dsws$snapshotRequest(instrument = c("TOTMKAU"), datatype = "", requestDate = "0D")
I'd like to know what I need to put into the datatype field to get that result. I've used this example because I've only been able to get error messages using TRBC activity codes, this al least gives me a descriptor of TOTMKAU.
Thanks for any help.