question

Upvotes
Accepted
CharlesYan avatar image
3 ●0 ●2 ●4

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.

Jirapongse avatar image   Jirapongse

@CharlesYan

Hi,

Thank you for your participation in the forum.

Is the reply below satisfactory in answering your question?

If yes please click the 'Accept' text next to the reply. This will guide all community members who have a similar question.

Otherwise please post again offering further insight into your question.

Thanks,

AHS

raksina.samasiri avatar image   raksina.samasiri

Please be informed that a reply has been verified as correct in answering the question, and has been marked as such.

Thanks,
AHS

1 Answer

· Write an Answer
Upvotes
Accepted
jonathan.legrand avatar image
5.8k ●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.

CharlesYan avatar image 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 avatar image jonathan.legrand CharlesYan

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

CharlesYan avatar image CharlesYan jonathan.legrand
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.