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 ,

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