Workspace is able to recognize specific SEDOLs but api fails

Hi,


if you search 6195739 (sedol code), you'll get

Chubu Steel Plate Co Ltd on Workspace;


However, if I use


rd.get_data(universe=['6195739'], fields=['TR.PriceClose'])


it returns

RDError: Error code -1 | Unable to resolve all requested identifiers in ['6195739'].


However, if I use the corresponding RIC code: 5461.T, and run: rd.get_data(universe=['5461.T'], fields=['TR.PriceClose'])


it returns me the data I need


seems like it doesnt recognize it

Does anyone have any idea?

same for

B56ZM74

BYZFF24

BF29PR1

BMDGT12

BYWFSG2

BPH27X5

6195739

6985037

6219297

Welcome!

It looks like you're new here. Sign in or register to get started.

Best Answer

  • raksina.samasiri
    Answer ✓

    Hi @Tim Lai ,

    I'd suggest using the convert_symbols function to convert the symbols.

    Regarding the Internal server error, it could come from specific instrument, could you please provide the list of symbols used for further investigation?

Answers

  • Hi @Tim Lai ,

    Have you tried using the code below to convert instrument from SEDOL to RIC first, then use the RICs list as an input of get_data function to retrieve the data

    import refinitiv.data as rd
    from refinitiv.data.discovery import (
    convert_symbols,
    SymbolTypes
    )

    rd.open_session()

    response = convert_symbols(
    symbols=['B56ZM74','BYZFF24','BF29PR1','BMDGT12','BYWFSG2','BPH27X5','6195739','6985037','6219297','6195739'],
    from_symbol_type=SymbolTypes.SEDOL,
    to_symbol_types=[SymbolTypes.RIC],
    )
    rics = response['RIC'].to_list()

    rd.get_data(universe=rics, fields=['TR.PriceClose'])

    1725854210202.png


  • Thanks @raksina.samasiri,


    Yes I did, that's my original method, I convert SEDOL to RIC using get_data like:

    rd.get_data(universe=sedol_list, fields=['TR.RIC']),


    but not converting to RIC could save me almost a minute in running time


    btw, may I ask which methods, convert_symbols or get_data, is more appropriate (in terms of speed or anything else) in converting them?


  • Also, when I tried your method, I got 'internal server error', could you pls help one the issue

    1725860609584.png

Welcome!

It looks like you're new here. Sign in or register to get started.

Welcome!

It looks like you're new here. Sign in or register to get started.