Search US Stocks traded on German Gettex (XMUN)

Anufriyev
Anufriyev Explorer
in TRTH

Hi all,

Could you pls advise on the following issue.

I try to find all US stocks which are traded on Munich Gettex Exchange (code: XMUN). When I do it via Eikon API Screen in Python I get only ~250 items:

fields = ['TR.ISIN','TR.InstrumentType','TR.CompanyName','TR.ExchangeName','TR.CompanyMarketCap(Scale=9)','TR.TRBCActivity','TR.TRBCEconomicSector']
US_stocks_on_XMUN = 'SCREEN(U(IN(Equity(active,public,countryprimaryquote))), \
                        IN(TR.ExchangeMarketIdCode,"XMUN"), \
                        IN(TR.RegCountryCode,"US"), \
                        Contains(TR.InstrumentType,"Ordinary Shares"), \
                        CURN=EUR)'
US_stocks_XMUN, err = ek.get_data(US_stocks_on_XMUN, fields)

... but when I do it manually via advanced search (Universe = "Equities" & Type of Equity = "Ordinary Shares" & Exchange = "GETTEX" & Country of issuer = "United States") I get a correct result (around 2000).

Could you pls advise how I could do it programmatically via Eikon and/or via RDP.

Thanks

Tagged:

Best Answer

  • raksina.samasiri
    raksina.samasiri admin
    Answer ✓

    Hi @Anufriyev ,

    In the Advanced Search screen, you can click on the Export option > Export query

    1671767562868.png

    Then select the Codebook tab to get the Python code for Refinitiv Data Library below is the screenshot of this code output, it returns 2174 rows which is the same number as the result on the Advanced search.1671767417283.png

    Here's the exported code

    import refinitiv.data as rd
    rd.open_session()

    rd.discovery.search(
    view = rd.discovery.Views.EQUITY_QUOTES,
    top = 5000,
    filter = "(AssetState ne 'DC' and SearchAllCategoryv2 eq 'Equities' and (RCSAssetCategoryGenealogy eq 'A:1L' and ExchangeName xeq 'GETTEX' and RCSIssuerCountryGenealogy eq 'M:DQ\G:AM\G:6J'))",
    select = "DTSubjectName,ExchangeName,RIC,IssueISIN,Gics,AssetState,BusinessEntity,PI,SearchAllCategoryv3,SearchAllCategoryv2,SearchAllCategory,CUSIP,CinCUSIP,SEDOL,RCSAssetCategoryLeaf,RCSCurrencyLeaf,ExDividendDate,RCSIssuerCountryLeaf,RCSAssetCategoryGenealogy,RCSIssuerCountryGenealogy"
    )

    Hope this helps and please let me know in case you have any further questions.

Answers

  • Anufriyev
    Anufriyev Explorer

    Oh, great! I didn't know that you could do "Export query" in advanced search as well. Thank you for the hint!

Categories