Symbol Conversion does not seem to give me the correct RIC.

CharlesYan

Previously, I made a post about retrieving the data here, the code will be pasted again here.

When I typed in 'TYO', the code does not return the correct answer 'TYO' but 'TYOGc1'. I would be grateful if someone can help me out.

import pandas as pd
import refinitiv.data as rd
from refinitiv.data.content import symbol_conversion

def RefinitivRetriever(Ticker):
    rd.open_session()
    converted = []

    Refinitiv_Info = symbol_conversion.Definition(
        symbols = Ticker,
        from_symbol_type = symbol_conversion.SymbolTypes.TICKER_SYMBOL,
        to_symbol_types = [
            symbol_conversion.SymbolTypes.RIC
        ],
    ).get_data()
    # This step is to check if the conversion is successful. If not, fill in with an empty string.    
    for t in Ticker:
        try:
            converted = converted.append(Refinitiv_Info.data.raw['Matches'][t]['RIC'])
        except KeyError:
            converted = converted.append('')

    # Return a dataframe with two columns, first one RIC list, while the second one Company Market Cap
    RICs = Refinitiv_Info.data.df['RIC'].tolist()
    MarketCap = rd.get_data(RICs, fields = ['TR.CompanyMarketCap'])
    MarketCap.columns = ['RIC', 'MarketCap']

    rd.close_session()

jonathan.legrand

Hi @CharlesYan,

Please use further arguments within the `symbol_conversion.Definition` to narow down your search. E.g.: `asset_class`

import refinitiv.data as rd
from refinitiv.data.content import symbol_conversion
rd.open_session()

test = symbol_conversion.Definition(
    symbols = "TYO",
    from_symbol_type = symbol_conversion.SymbolTypes.TICKER_SYMBOL,
    to_symbol_types = [symbol_conversion.SymbolTypes.RIC],
    asset_class="Funds").get_data()
display(test.data.df)

rd.close_session()

You can find information about these arguments here, which was linked here.

CharlesYan

Hi,
@jonathan.legrand . Thx for your guidance. Can I know any other asset_class I can choose? I would be grateful if you can locate me to the documentation line.

The reason was my list not only contains funds but also ordinary stocks.

jonathan.legrand

Hi @CharlesYan; you can find information about these arguments, such as `asset_class `, here, which was linked here.

CharlesYan

Many thx for being so helpful!