Retrieve the complete list of RICs of an exchange using Eikon Data Python API?

I am looking for the way to use Eikon Data Python API to retrieve the complete list of RICs of a given exchange.
Best Answer
-
Here's an example retrieving the full listing on Australian Securities Exchange. The screener returns the max of 5K rows. If the listing exceeds 5K, then additional criteria need to be used to narrow the search and break the result. E.g. you can retrieve all stocks listed on an exchange with the market cap more than X, then with the market cap between X and Y and then with the market cap less than Y.
ek.get_data('SCREEN(U(IN(Equity(active,public,primary))/*UNV:Public*/), IN(TR.ExchangeMarketIdCode,"XASX"))','TR.CommonName')
0
Answers
-
Thanks a lot for the formula. Can you please also explain how did you populate "XASX" for Australian Securities Exchange? How about other exchanges like Mexican Stock Exchange, Chile Stock Exchange?
0 -
For exchange identifiers in the screener we use MIC or Market Identifier Code (ISO 10383). For a more generic use case follow the Screener wizard in Eikon Excel. Click on the Screener button in Thomson Reuters ribbon in Eikon Excel. Follow the wizard to select your equity screening criteria, then click Insert Screener button. This will insert =TR function into Excel worksheet. The screener expression can be copied and pasted from this formula into your Python code. This is exactly what I did to create the example above.
0 -
The equity screener expression in the above example excludes non primary and dual listings. To include dual listings in the result use
ek.get_data('SCREEN(U(IN(Equity(active,public,primary,countryprimaryquote))/*UNV:Public*/), IN(TR.ExchangeMarketIdCode,"XHKG"))',['TR.CommonName'])
For help with creating equity screener expressions follow the Screener wizard in Eikon Excel. You may also want to watch video tutorial titled "Creating Data Retrieval Functions using Equity Screener" available from the main Eikon menu - Help - Tutorials and Training.
0 -
Thank you for your reply Alex. I also want to get all active equities of a given exchange on a given historical date, point in time. Do you have any suggestions?
0 -
I don't believe this is possible in Eikon. See my comments on a previous thread on similar subject.
https://community.developers.refinitiv.com/comments/28509/view.html0
Categories
- All Categories
- 6 AHS
- 36 Alpha
- 166 App Studio
- 6 Block Chain
- 4 Bot Platform
- 18 Connected Risk APIs
- 47 Data Fusion
- 34 Data Model Discovery
- 684 Datastream
- 1.4K DSS
- 613 Eikon COM
- 5.2K Eikon Data APIs
- 10 Electronic Trading
- Generic FIX
- 7 Local Bank Node API
- 3 Trading API
- 2.9K Elektron
- 1.4K EMA
- 248 ETA
- 552 WebSocket API
- 37 FX Venues
- 14 FX Market Data
- 1 FX Post Trade
- 1 FX Trading - Matching
- 12 FX Trading – RFQ Maker
- 5 Intelligent Tagging
- 2 Legal One
- 23 Messenger Bot
- 3 Messenger Side by Side
- 9 ONESOURCE
- 7 Indirect Tax
- 60 Open Calais
- 275 Open PermID
- 44 Entity Search
- 2 Org ID
- 1 PAM
- PAM - Logging
- 6 Product Insight
- Project Tracking
- ProView
- ProView Internal
- 22 RDMS
- 1.9K Refinitiv Data Platform
- 629 Refinitiv Data Platform Libraries
- 4 LSEG Due Diligence
- LSEG Due Diligence Portal API
- 4 Refinitiv Due Dilligence Centre
- Rose's Space
- 1.2K Screening
- 18 Qual-ID API
- 13 Screening Deployed
- 23 Screening Online
- 12 World-Check Customer Risk Screener
- 1K World-Check One
- 46 World-Check One Zero Footprint
- 45 Side by Side Integration API
- 2 Test Space
- 3 Thomson One Smart
- 10 TR Knowledge Graph
- 151 Transactions
- 143 REDI API
- 1.8K TREP APIs
- 4 CAT
- 26 DACS Station
- 121 Open DACS
- 1.1K RFA
- 104 UPA
- 191 TREP Infrastructure
- 228 TRKD
- 915 TRTH
- 5 Velocity Analytics
- 9 Wealth Management Web Services
- 86 Workspace SDK
- 11 Element Framework
- 5 Grid
- 18 World-Check Data File
- 1 Yield Book Analytics
- 46 中文论坛