Workspace is able to recognize specific SEDOLs but api fails

Tim Lai

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

raksina.samasiri

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?

raksina.samasiri

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'])

Tim Lai

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?

Tim Lai

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