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 davet1 · Sep 12, 2018 at 06:42 AM · javarest apicorporateactions

How to use CorporateActions extractions

I've been using the various REST examples (.../datascope-select-dss/datascope-select-rest-api...) and I'm trying to make sense of CorporateActions. I can make the sample request, and receive the response ok, but I'm not sure about the Condition fields, or how to best process the results. The example says

    "Condition": {
      "ReportDateRangeType": "Last",
      "PreviousDays": 30,
      "ExcludeDeletedEvents": true,
      "IncludeCapitalChangeEvents": true,
      "IncludeDividendEvents": true,
      "IncludeEarningsEvents": true,
      "IncludeMergersAndAcquisitionsEvents": true,
      "IncludeNominalValueEvents": true,
      "IncludePublicEquityOfferingsEvents": true,
      "IncludeSharesOutstandingEvents": true,
      "IncludeVotingRightsEvents": true,
      "CorporateActionsCapitalChangeType": "CapitalChangeExDate",
      "CorporateActionsDividendsType": "DividendPayDate",
      "CorporateActionsEarningsType": "PeriodEndDate",
      "ShareAmountTypes": [
      ]
    }

Firstly, where can I find a list of all the various Condition options with their descriptions?

Secondly, what's the right way to process this data? I can imagine making an initial request for (say) 20 years of corporate events (I think I can set StartDate and EndDate instead of saying PreviousDays: 7200), but how are the rows identified? In the DSS content guide xls file I can see the field, "Issue Level Event ID", "Unique system-generated ID for each issue-level record related to the corporate actions event; All subsequent amendments and updates to this event are entered under this number". What happens with that? How are amendments and updates flagged? How do I know what order to apply them in if I receive multiple entries for one Issue Level Event ID in a response?

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
Best Answer
Answer by davet1 · Nov 08, 2018 at 08:07 AM

For anyone's future reference, it seems that a Corporate Action is identified by a unique identifier. Unfortunately, for some reason, there are (at least) three different unique identifiers.

The three identifiers I have discovered so far:

Issue Level Event ID

Offer ID

Deal ID

I have also been informed (on a phone call with TR) that an update to a corporate action will (of course) come in with the same unique identifier as its initial creation. The information received in that record is a complete representation of the record (so no need to look for individual field updates), also that if there have been multiple updates to a corporate action then they will all be rolled into one (because the record represents the latest state). Therefore you shouldn't receive multiple updates to a corporate action in a request.

Comment
Christiaan Meihsl

People who like this

1 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 davet1 · Sep 17, 2018 at 07:29 AM

/bump

Anything? Even an appropriate bit of The Fine Manual to Read?

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 zoya.farberov · Sep 17, 2018 at 12:04 PM

Hello @davet1,

On the first part of your question, you can find all Condition options pertaining to CorporateAction via REST API Reference Tree. Expand:

Extractions-> Report Template -> Corporate Action Standard Report Template to see

Condition

On the second part of your question, how to process, I think it depends on what result you are trying to derive and I can think of a couple of pointers, rather then answers:

Corporate actions have an identifier and also have a "Corporate Actions Type". Depending on these fields, one would decide if this type of action on this RIC is of interest, and also what other fields will be populated for this type of action. I.e.

Corporate Action Standard Report Template

-> Enums -> CorporateActionsStandardEventsType shows what event types can be seen,

such as Dividents, Earnings, etc.

For in-depth information on corporate actions content available, the best way to get content questions answered is to contact a TR content expert via My TR Support or to call your local TR Helpdesk.

Comment

People who like this

0 Show 1 · 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
davet1 · Nov 08, 2018 at 08:08 AM 0
Share

It is unfortunate that answers are automatically marked as correct.

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

Related Questions

How do I request Entity data (having their OrgID) using the REST API

Data Scope java request for Spread Ric - Time Series

REST API method GET /Search/HistoricalChainResolution for Chains Search?

Get Target RIC for Demerger from DataScope Select

Is there is a way to set up precision of close price in EOD pricing template and universal close price in history pricing template by using REST API

  • 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