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 · Jun 24, 2020 at 06:52 PM · corporate actionmergersdatascopeapidelisting date

Getting planned delisting date for a given corporate action

There recently was a merger with AXE^F20 and WCC.N last week which I missed due to the Ex-Date in the Datascope report being 9/30/2020. I'm guessing this is an estimate, given the vague nature of AXE^F20 past investor relations documents.

So is there a way to see planned delisting date for a given merger within the Datascope reports? AXE^F20 got delisted on Monday(6/22/2020) and this was announced on Friday(6/19/2020). I can provide the the excel file download from Datascope.

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.

3 Replies

  • Sort: 
avatar image
REFINITIV
Best Answer
Answer by veerapath.rungruengrayubkul · Jun 25, 2020 at 06:31 AM

Hi @gabriel31,

Not a content expert. You may identify the delist date using Deal Effective Date in corporate action event. If this doesn't fit your requirement, please contact the DSS content support team via MyRefinitiv Get Support.

Below is the sample of On demand request for corporate active report template.

{
  "ExtractionRequest": {
    "@odata.type": "#ThomsonReuters.Dss.Api.Extractions.ExtractionRequests.CorporateActionsStandardExtractionRequest",
    "ContentFieldNames": [
        "Company RIC",
        "Company Role",
        "Company Role Description",
        "Deal Announcement Date",
        "Deal Cancel Date",
        "Deal Close Date",
        "Deal Effective Date",
        "Deal ID",
        "Deal Revised Proposal Date",
        "Deal Status",
        "Deal Status Description",
        "Deal SubType",
        "Deal SubType Description",
        "Deal Type",
        "Deal Type Description",
        "Deal Value",
        "Deal Value Currency"
    ],
    "IdentifierList": {
      "@odata.type": "#ThomsonReuters.Dss.Api.Extractions.ExtractionRequests.InstrumentIdentifierList",
      "InstrumentIdentifiers": [
          { "Identifier": "WCC.N", "IdentifierType": "Ric" }
      ]
    },
    "Condition": {
      "ReportDateRangeType": "Last",
      "PreviousDays": -1,
      "IncludeMergersAndAcquisitionsEvents": true
    }
  }
}

This will give the details of the deal.

{
   ...
            "IdentifierType": "Ric",
            "Identifier": "WCC.N",
            "Company RIC": "AXE.F",
            "Company Role": "TAR",
            "Company Role Description": "Target",
            "Deal Announcement Date": "2019-12-24",
            "Deal Cancel Date": null,
            "Deal Close Date": "2020-06-22",
            "Deal Effective Date": "2020-06-22",
            "Deal ID": "1510878",
            "Deal Revised Proposal Date": null,
            "Deal Status": "COMPLETE",
            "Deal Status Description": "Complete",
            "Deal SubType": null,
            "Deal SubType Description": null,
            "Deal Type": "MAA",
            "Deal Type Description": "Mergers & Acquisitions",
Comment

People who like this

0 Show 0 · 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
Answer by gabriel31 · Jul 02, 2020 at 04:04 PM

Thanks @veerapath.rungruengrayubkul That is kinda what I'm looking for, but the change in the Effective Date showed up on Datascope after the event had occurred. The Effective Date on 6/22/2020 for our daily download from Datascope, was "9/30/2020". So it doesn't really help with preemptively taking action before the actual corporate event.

Comment

People who like this

0 Show 0 · 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
REFINITIV
Answer by veerapath.rungruengrayubkul · Jul 03, 2020 at 03:27 AM

Hi @gabriel31,

It seems that the event was not on schedule. I'm not sure if you can see this RIC delist event in the RIC Maintenance Report where DataScope Select databases refresh by early maintenance reports that occur before market opening per region. You can find example and more information in this tutorial and article.

Anyway, I would suggest you contact the DSS product support team via MyRefinitiv Get Support. for further discussion on this event.

Comment

People who like this

0 Show 0 · 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.

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 >
13 People are following this question.

Related Questions

Corporate Action returned blank data

About new feature in DSS 12.1 on ISO 15022 35B field

Empty fields on “Get corporate actions data” API call

Corporate action information via API - Datascope

PriceHistory Corporate Actions and Dividend adjustement

  • 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