question

Upvotes
Accepted
3 0 2 3

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

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()
pythonrefinitiv-dataplatform-eikon#product#contentrefinitiv-data-platform
icon clock
10 |1500

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

1 Answer

· Write an Answer
Upvotes
Accepted
5.7k 21 2 6

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


1702977239479.png


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


1702977239479.png (4.8 KiB)
icon clock
10 |1500

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

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.

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

Many thx for being so helpful!

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.