how to get interlisted RICs?
The question is in the title.
Example, https://api.tmxmoney.com/interlisted/en/all/clist.txt
BMO - listed on TSX and NYSE
Goal : to find all interlisted symbols that are traded on TSX and on any US exchange.
Best Answer
-
I don't believe you can use interlisted as a search criteria, so the only way I can think of achieving this is by running a screen that returns all stocks listed on TSX, then another screen for all stocks listed on US exchanges (make sure to include dual listed in the criteria), include CUSIP in the results for both screens and find the intersection between the results of two screens by matching the CUSIP.
0
Answers
-
Sounds promising.
"make sure to include dual listed in the criteria" - could you clarify what you mean here?
Is there a guarantee that the main part of the RIC (without exchange extension) will match for interlisted tickers?
Thanks
0 -
When setting criteria in the Screener wizard under the Universe you have an option (not checked by default) to include dual listings. Checking this option will add "countryprimaryquote" term to the expression defining the universe:
SCREEN(U(IN(Equity(active,public,primary,countryprimaryquote)),...
The ticker will not necessarily match. You can see an example in the text file you referenced: Barrick Gold Corporation is listed as ABX on TSX and as GOLD on NYSE.
0 -
what exactly parameter 'countryprimaryquote' does mean? For Toronto exchange I see 50 symbols difference. BMO.TO is in both lists.
0 -
It means include in the universe primary quotes for the issue in each country where the stock is listed in addition to the primary quote for the issue globally. Without this term BMO will be excluded from the screen for US exchanges because the primary quote for BMO stock globally is the TSX one.
0 -
Thank you, Alex.
It makes sense.
Can I use ISIN instead of CUSIP to match the symbols between US and CAN? In this case I could request US universe using ISINs from Canada.
0 -
I'm not sure I understand the last sentence, but in the process I described above you could use ISIN instead if CUSIP if you prefer.
0
Categories
- All Categories
- 3 Polls
- 6 AHS
- 36 Alpha
- 166 App Studio
- 6 Block Chain
- 4 Bot Platform
- 18 Connected Risk APIs
- 47 Data Fusion
- 34 Data Model Discovery
- 687 Datastream
- 1.4K DSS
- 622 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
- 255 ETA
- 557 WebSocket API
- 38 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
- 276 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
- 680 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
- 27 DACS Station
- 121 Open DACS
- 1.1K RFA
- 105 UPA
- 194 TREP Infrastructure
- 229 TRKD
- 918 TRTH
- 5 Velocity Analytics
- 9 Wealth Management Web Services
- 91 Workspace SDK
- 11 Element Framework
- 5 Grid
- 18 World-Check Data File
- 1 Yield Book Analytics
- 48 中文论坛
