Hi @mjg

Using the symbol.conversion you get PrimaryRIC. If you need to have better control and get the RIC from chosen exchange you can try with this code:

from refinitiv.data.content import search
response = search.Definition(
    filter = f"IssuerTicker eq 'BAC' " \
        "and ExchangeCode in ('NYQ' 'NYS' 'NSQ') " \
        "and AssetStateName eq 'Active' " \
        "and DTSimpleType eq 'Ordinary Share'",
    select = "RIC,ExchangeCode,PrimaryRIC"
                                 ).get_data()
response.data.df

Hi @mjg ,

I have checked those instruments (BAC/F) in workspace and they don't have the suffix there either, so I would suggest raising a content query via Helpdesk through https://my.refinitiv.com/ or directly from Workspace/Eikon. There are better positioned to answer the content related questions.

Best regards,

Haykaz

thank you @m.bunkowski for the helpful response.

ironically, all i really need is a way to get a good enough RIC , from a standard current ticker such as BAC, AAPL, F, or ABBV, to confidently make a subsequent query to the eikon API - such as:

instruments_arg = ['AAPL.O'] 
df, err = ek.get_data(
            instruments=instruments_arg,
            fields=['TR.CompanyMarketCapitalization'])

i had found that to get back valid data from that get_data call, each item in instruments_arg needed to have the suffix, otherwise it would fail.

if there is there a simpler way to call get_data where it can accept a naive ticker, then i can sidestep this problem

introducing variables such as making sure i need to know an exhaustive list of:

"and ExchangeCode in ('NYQ' 'NYS' 'NSQ') " . i will surely need some BATS listed and ARCA listed names and i don't know those codes offhand or if my list of exchanges is necessarily static.

as well as wanting to handle non-ordinary-share situations such as 'Depository Receipts' or 'Equity ETF' units or what have you seems like added work

@m.bunkowski thank you again.

as a hypothetical - what if i had CUSIP information instead rather than Ticker, would that make solving the symbol conversion problem easier/trivial?

i appreciate the heads up about being able to use the rd call instead. will that work for all fields that i currently query the same way i query for market cap?

thank you!