How to get the RICs for all stocks listed on the Shanghai Stock Exchange

Dan_Li2025

Hello！ I'm trying to get the RICs for all stocks listed on the Shanghai Stock Exchange, but it seems to keep returning an empty table. Does it support SQL queries? Or where can I verify this myself ？ like which place in the workspace to check if it's written correctly? tks.

df = rd.discovery.search(
view=rd.discovery.Views.SEARCH_ALL,
filter="(AssetCategory eq 'Equity') and (ExchangeCode in ('SHG' 'SHA'))",
select='RIC, CompanyName, ExchangeCode',
top=100 # Limit the number of returned results for quick verification
)

Jirapongse

@Dan_Li2025

Thank you for reaching out to us.

You may need to verify the ExchangeCode for Shanghai Stock Exchange. I checked and found that it should be 'SHH'.

Therefore, the code looks like this:

df = ld.discovery.search(
    view=ld.discovery.Views.SEARCH_ALL,
    filter="(AssetCategoryName eq 'Equity') and (ExchangeCode in ('SHH'))",
    select='RIC, CompanyName, ExchangeCode',
    top=100 # Limit the number of returned results for quick verification
)

Or,

df = ld.discovery.search(
    view=ld.discovery.Views.SEARCH_ALL,
    filter="(AssetCategoryName eq 'Equity') and  ExchangeName xeq 'Shanghai Stock Exchange'",
    select='RIC, CompanyName, ExchangeCode',
    top=100 # Limit the number of returned results for quick verification
)

You can also refer to this Find content and functionality using the Data Library with Workspace Advanced Search article.

Please contact the helpdesk support team directly via LSEG Support to verify the exchange code.