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

Options
Ed_J
Ed_J Newcomer
in Datastream
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?

Tagged:

Best Answer

  • Jirapongse
    Jirapongse ✭✭✭✭✭
    Answer ✓

    @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

    image


    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.

    image

    Otherwise, you can directly contact the Refinitiv Datastream Web Service support team via MyRefinitiv to find items for you.




Answers

  • Ed_J
    Ed_J Newcomer

    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.


Categories