Discover Refinitiv
MyRefinitiv Refinitiv Perspectives Careers
Created with Sketch.
All APIs Questions & Answers  Register |  Login
Ask a question
  • Questions
  • Tags
  • Badges
  • Unanswered
Search:
  • Home /
  • DSS /
avatar image
Question by gabriel31 · Nov 21, 2019 at 04:14 PM · pythonrest apidatascope selectcorporate actionsdemerger

Get Target RIC for Demerger from DataScope Select

Hello,

When retrieving corporate action details for Demergers, is there a way to get the target RIC for a given action? You can retrieve the details within the 'Corporate Action Notes' column, but that requires parsing the entire paragraph of text.

For example, on 06/03/2019 DUPONT DE NMOURS (DD.N) had a Demerger of:

".33333333 of a share of Corteva Inc per one share of DowDuPont Inc. Due bills attached 23 May 2019 and redeemable beginning 4 June 2019."

However, I was unable to find a column which corresponded to the RIC or other identifier of Corteva. I may be missing a column, but I've tried all the different 'ID' fields with no luck.

Thanks for the help!

People who like this

0 Show 0
Comment
10 |1500 characters needed characters left characters exceeded
▼
  • Viewable by all users
  • Viewable by moderators
  • Viewable by moderators and the original poster
  • Advanced visibility
Viewable by all users

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

1 Reply

  • Sort: 
avatar image
REFINITIV
Best Answer
Answer by veerapath.rungruengrayubkul · Nov 22, 2019 at 04:23 AM

Hi @gabriel31,

This question is a content query which should be answered/confirmed by content expert by opening support a case on myRefinitiv. This forum is best suited for API related questions and discussions.

Anyway, I have found that the "Capital Change New Security ISIN" field can provide the ISIN of Corteva, US22052L1044.

{
            "IdentifierType": "Ric",
            "Identifier": "DD.N",
            "Corporate Actions Type": "CAP",
            "Corporate Action Notes": ".33333333 of a share of Corteva Inc per one share of DowDuPont Inc. Due bills attached 23 May 2019 and redeemable beginning 4 June 2019.",
            "Capital Change Event Type Description": "Demerger (DEM)",
            "Capital Change New Security ISIN": "US22052L1044",

Hope this helps.

Comment

People who like this

0 Show 5 · Share
10 |1500 characters needed characters left characters exceeded
▼
  • Viewable by all users
  • Viewable by moderators
  • Viewable by moderators and the original poster
  • Advanced visibility
Viewable by all users

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

avatar image
gabriel31 · Nov 22, 2019 at 02:22 PM 0
Share

Thanks. That helps. Just a quick follow-up, is there a field that does not require third-party licensing?

Future questions, I'll add to myRefinitiv.

avatar image
gabriel31 · Nov 22, 2019 at 02:25 PM 0
Share

Additionally, Is there a way to get the RIC of Corteva in this scenario?

avatar image
REFINITIV
veerapath.rungruengrayubkul ♦♦ gabriel31 · Nov 26, 2019 at 08:20 AM 0
Share

I have found the "Capital Change New Security PILC" field which provides Primary Issue Level Code (PILC) of Corteva (176731833). According to the Data Content Guide, the field doesn't require additional licensing. However, I'm not able to find a way to convert the PILC to RIC.

With regard to converting ISIN to RIC, you can see this article.

avatar image
REFINITIV
gteage01 gabriel31 · Nov 26, 2019 at 10:22 AM 0
Share

@gabriel31

Hi Gabriel,

Looking at how the data is represented with the GUI may help here, ie. the Corporate Actions tab for RIC: DD.N:

https://hosted.datascope.reuters.com/DataScope/details/RIC_REQuTg==%5EEN#corporate-actions Looks like what you need is in " Target RIC" as a "Mergers & Acquisition" Corax request.

Best regards,

Gareth

avatar image
REFINITIV
gteage01 gteage01 · Nov 26, 2019 at 10:26 AM 0
Share

ONDEMAND_CORAX_MAA_EXAMPLE.txtTry this POST attached to: https://hosted.datascopeapi.reuters.com/RestApi/v1/Extractions/ExtractWithNotes - it should provide the last event from M&A event:

ondemand-corax-maa-example.txt (1.1 KiB)

Watch this question

Add to watch list
Add to your watch list to receive emailed updates for this question. Too many emails? Change your settings >
14 People are following this question.

Related Questions

How to get FX Rates from DataScope Select Rest API in Python?

historical bond prices via DSS Python (REST) API

Retrieving upcoming earnings events, AGMs

Why do I get a different number of results using DataScope .Net SDK and DataScope Select Web UI?

DataScope Select - REST API , functionality Adhoc - decimals

  • Feedback
  • Copyright
  • Cookie Policy
  • Privacy Statement
  • Terms of Use
  • Careers
  • Anonymous
  • Sign in
  • Create
  • Ask a question
  • Spaces
  • Alpha
  • App Studio
  • Block Chain
  • Bot Platform
  • Calais
  • Connected Risk APIs
  • DSS
  • Data Fusion
  • Data Model Discovery
  • Datastream
  • Eikon COM
  • Eikon Data APIs
  • Elektron
    • EMA
    • ETA
    • WebSocket API
  • Legal One
  • Messenger Bot
  • Messenger Side by Side
  • ONESOURCE
    • Indirect Tax
  • Open PermID
    • Entity Search
  • Org ID
  • PAM
    • PAM - Logging
  • ProView
  • ProView Internal
  • Product Insight
  • Project Tracking
  • Refinitiv Data Platform
    • Refinitiv Data Platform Libraries
  • Rose's Space
  • Screening
    • Qual-ID API
    • Screening Deployed
    • Screening Online
    • World-Check One
    • World-Check One Zero Footprint
  • Side by Side Integration API
  • TR Knowledge Graph
  • TREP APIs
    • CAT
    • DACS Station
    • Open DACS
    • RFA
    • UPA
  • TREP Infrastructure
  • TRIT
  • TRKD
  • TRTH
  • Thomson One Smart
  • Transactions
    • REDI API
  • Velocity Analytics
  • Wealth Management Web Services
  • World-Check Data File
  • Explore
  • Tags
  • Questions
  • Badges