RIC mappings after corporate actions
Is there any way to get the RIC of the company spun-off from a parent organization or the rics of merger and acquiror companies that participated in a merger and acquisition activity using the python API?
Best Answer
-
It could be TR.SecurityOwnedRIC under Ownership => Ownership Investors => Investor-Level Holdings category from Eikon Excel Formula Builder.
If not, please contact Eikon Support team for TR.xxx fields or formula which can provide the required information.
0
Answers
-
Hi,
I do not see the Security Owned RIC in the options (attached screenshot)
What is shown on your screen should work, but I do not see that option.
0 -
@sonam.srivastava
I believe what you're looking for is given the RIC GETIb.ST, which represents ordinary shares of Getinge AB, to find the RIC ARJOb.ST, which represents ordinary shares of Arjo AB, which was demerged from Getinge AB in Dec 2017.
The field that @jirapongse.phuriphanvichai mentioned would give the RIC of a stock of a public company if it has as a strategic investor another public company. E.g. Ford Motor Co (F.N) owns 41% of Ford Otomotiv Sanayi AS (FROTO.IS), hence given F.N TR.SecurityOwnedRIC field will return FROTO.IS.
However in case of a spin off or demerger the old company may not necessarily hold any shares in the new issue. In your example Getinge AB may not own any portion of Arjo.
If instead of ownership we look at the capital change events for GETIb.ST, we will find the demerger event completed on 12-Dec-2017 and from the field TR.CANewIssue we can find the name of the new issue "Arjo Ord Shs". But I don't see any way to get the RIC or other identifier such as ISIN for it.
This said none of the moderators on this forum are specialists in every type of data available through Thomson Reuters products. If I don't see a way to retrieve certain data, it doesn't always mean there's no way. You may want to contact Thomson Reuters Helpdesk and ask if indeed there's no way at all using Eikon to get ARJOb.ST given GETIb.ST.1 -
Categories
- All Categories
- 6 AHS
- 39 Alpha
- 161 App Studio
- 4 Block Chain
- 4 Bot Platform
- 16 Connected Risk APIs
- 47 Data Fusion
- 30 Data Model Discovery
- 608 Datastream
- 1.3K DSS
- 577 Eikon COM
- 4.9K Eikon Data APIs
- 7 Electronic Trading
- Generic FIX
- 7 Local Bank Node API
- Trading API
- 2.7K Elektron
- 1.3K EMA
- 236 ETA
- 519 WebSocket API
- 33 FX Venues
- 10 FX Market Data
- 1 FX Post Trade
- 1 FX Trading - Matching
- 12 FX Trading – RFQ Maker
- 5 Intelligent Tagging
- 2 Legal One
- 20 Messenger Bot
- 2 Messenger Side by Side
- 9 ONESOURCE
- 7 Indirect Tax
- 59 Open Calais
- 264 Open PermID
- 39 Entity Search
- 2 Org ID
- PAM
- PAM - Logging
- 8.4K Private Comments
- 6 Product Insight
- Project Tracking
- ProView
- ProView Internal
- 20 RDMS
- 1.4K Refinitiv Data Platform
- 367 Refinitiv Data Platform Libraries
- 3 Refinitiv Due Diligence
- LSEG Due Diligence Portal API
- 3 Refinitiv Due Dilligence Centre
- Rose's Space
- 1.1K Screening
- 18 Qual-ID API
- 13 Screening Deployed
- 23 Screening Online
- 10 World-Check Customer Risk Screener
- 990 World-Check One
- 44 World-Check One Zero Footprint
- 45 Side by Side Integration API
- Test Space
- 3 Thomson One Smart
- 1.2K TR Internal
- Global Hackathon 2015
- 2 Specialists Who Code
- 10 TR Knowledge Graph
- 150 Transactions
- 142 REDI API
- 1.7K TREP APIs
- 4 CAT
- 21 DACS Station
- 117 Open DACS
- 1.1K RFA
- 103 UPA
- 172 TREP Infrastructure
- 224 TRKD
- 886 TRTH
- 5 Velocity Analytics
- 5 Wealth Management Web Services
- 59 Workspace SDK
- 9 Element Framework
- 5 Grid
- 13 World-Check Data File
- Yield Book Analytics
- 46 中文论坛