What is wrong with my Symbol conversion code?

Marc_Belen24 · 7:20PM

Hello Team please check the following code.

The output that I want is USA country code specific but it is showing Exchanges from Thailand and Vienna.

Also my asset class are code for funds, equities, certificates and bonds but Commodities futures also show in my output.

Here is the code:

from lseg.data.content import symbol_conversion

import lseg.data as ld

import pandas as pd

my_tickers = ['AIG PR A', 'PTT', 'BRKa', 'ANPA', 'BADDDDYYYYYDDY', 'DNB', 'VRA', 'LAWR', 'STR', 'TYO']

ld.open_session()
response = symbol_conversion.Definition(

symbols=my_tickers,

from_symbol_type=symbol_conversion.SymbolTypes.TICKER_SYMBOL,


to_symbol_types=[

    symbol_conversion.SymbolTypes.RIC


],

# preferred_country_code = "G:6J", # USA USA = "G:6J"


preferred_country_code = symbol_conversion.CountryCode.USA,


asset_class=[


    symbol_conversion.AssetClass.FUNDS,


    symbol_conversion.AssetClass.EQUITIES,


    symbol_conversion.AssetClass.CERTIFICATES,


    symbol_conversion.AssetClass.BONDS,


    ],


asset_state=symbol_conversion.AssetState.ACTIVE,

).get_data()

ld.close_session()

response = pd.DataFrame(response.data.df).reset_index().rename(columns={'index': 'Ticker'})

print(response)