question

Upvotes
Accepted
27 4 4 4

How to get list of ISIN's or MNEM within a TRBC activity code

Hello All,


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?

datastream-apidsws-apir
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.

Upvotes
Accepted
53.2k 138 44 63

@Ed_J

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.





1611545686351.png (16.1 KiB)
1611545206791.png (46.0 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.

Upvotes
27 4 4 4

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.


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.