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()
