How can we convert 1000 PermIDs into rics?

Neil Shah
Neil Shah LSEG
in Open PermID

What is the API to use?

What is the cost?

Tagged:

Best Answer

  • Steven McCoy
    Steven McCoy LSEG
    Answer ✓

    Create a "Terms and Conditions" report in DSS with "Issue PermID" and "RIC" fields. This will create a source data set for mapping RIC to PermID. Then you can feed this into your app or create a service that exports it through TREP, etc.

    image

Answers

  • Steven McCoy
    Steven McCoy LSEG

    Not supported by DSS "Symbol Cross Reference", TRTH EBD files, nor PermID.org.

  • Neil Shah
    Neil Shah LSEG
    https://community.developers.refinitiv.com/discussion/comment/6344#Comment_6344

    Is there a way to programatically convert PermID to any other identifier?

  • student.1
    student.1 Newcomer

    A fast way to convert them in Python is:


    If you have a dataframe with PermIDs then you can extract the column for the PermIDs with:

    df['Name Of The Column']

    and follow the principle below:

    ### Extract the PermID from dataframe and convert it into a list of strings because ek.get_data takes in strings

    ls_PermID = list(df['ame Of The Column'].astype('str'))


    ### Convert PermID to RIC with ek.get_data

    ls_RIC, err = ek.get_data(ls_PermID, 'TR.RIC')


    I just want to post this simple and efficient solution here after days of searching how to do it the best way.

Categories