Retrieve all US primary stock listings excluding OTC/pink sheets

I am trying to get a list of all equities in the US - primary listings only - and excluding OTC stocks. Below is what I have now:

DB4 = rd.discovery.search(

view = rd.discovery.Views.EQUITY_QUOTES,

top = 10,

select="DTSubjectName,ExchangeName,RIC,MktCapCompanyUsd,ShareholdersEquityUsd,RCSIssuerCountryLeaf,RCSExchangeCountry,SearchAllCategoryv3,SearchAllCategoryv2,SearchAllCategory,RCSAssetCategory,RCSCurrencyLeaf,AssetState,IssueISIN,IsPrimaryInstrument,PrimaryQuote,PrimaryRIC,Primary",

filter = "( SearchAllCategoryv2 eq 'Equities' and RCSExchangeCountry eq 'G:6J' and ExchangeName ne 'US ''Other OTC'' and Grey Market')")

How can I add the filter for primary listings only?

Where can I find a list of RCSExchangeCountry codes?

Where can I see a list of fields I can use in select?

Thank you

Find more posts tagged with

python

universe

refinitiv-dataplatform-libraries

#content

#technology

Accepted answers

All comments

raksina.samasiri

Hi @FFabianB ,

You can use Advanced Search to find the available filters and field. However, you have to apply the field in the exported code manually as the export function of Advanced Search only export the filters part.

More detail can be found in article Find content and functionality using the Data Library with Workspace Advanced Search | Devportal

Jirapongse

@FFabianB

It should be the ExchangeCode. I ran the following code to check the ExchangeCode of OTC/pink sheets RICs.

ld.discovery.search(
    view = ld.discovery.Views.EQUITY_QUOTES,
    filter = "RIC eq 'TCEHY.PQ' or RIC eq 'CBCY.PK'",
    select = 'RIC, ExchangeCode')

However, you need to contact the helpdesk team via LSEG Support to confirm this and get a list of RCSExchangeCountry codes.

Regarding the third question, you can use the search.metadata to get all available fields.

import lseg.data as ld
from lseg.data.content import search
…
…
response = search.metadata.Definition(
    view = search.Views.EQUITY_QUOTES
).get_data()

response.data.df

You can refer to this Building Search into your Application Workflow article. You can use the _debugall to list all properties and values of an entry, as mentioned in the article.

EXPLORE OUR SITES