question

Upvotes
Accepted
ricardo.siguero avatar image
5 ●8 ●12 ●12

Corporate Action data retrieval (Stored & sheduled approach)

Hi all,

Is there a way of retrieving Corporate Action (CA) data by using the 'Stored & Scheduled' (instrument list+report template+schedule) approach of the REST Api?

The case shown at the "Use Cases Reference" document for Corporate Action data retrieval shows the use of the 'ExtractWithNotes' endpoint.that follows the "On Demand" approach.

We need to specify a date range (from date/end date) but the three CA-related report templates documented on the API seems not to use such kind of criteria...

Any feedback will be appreciated.

Ricardo

tick-history-rest-apirest-apicorporate-actions
icon clock
10 |1500

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

Alex Putkov.1 avatar image   Alex Putkov.1

@ricardo.siguero
Thank you for your participation in the forum. Is the reply below satisfactory in resolving your query? If yes please click the 'Accept' text next to the reply. This will guide all community members who have a similar question. Otherwise please post again offering further insight into your question.
Thanks,
-AHS

Jirapongse avatar image   Jirapongse

@ricardo.siguero

Please be informed that a reply has been verified as correct in answering the question, and has been marked as such.

Thanks,

AHS

1 Answer

· Write an Answer
Upvotes
Accepted
veerapath.rungruengrayubkul avatar image
11.3k ●25 ●9 ●14

@ricardo.siguero

You can follow the steps in the REST API Tutorial 12: GUI control calls: immediate extract tutorial for "Stored & Scheduled" extraction type. You also need to change the report template to CorporateActionsStandardReportTemplates.

Below is the sample request for creating the Corporate Actions Standard report template with date range specific.

{
    "@odata.type": "#ThomsonReuters.Dss.Api.Extractions.ReportTemplates.CorporateActionsStandardReportTemplate",
    "ShowColumnHeaders": false,
    "Name": "CorporateActionsStandard",
    "Headers": [
        
    ],
    "Trailers": [
        
    ],
    "ContentFields": [
        {
            "FieldName": "Adjustment Factor",
            "Format": null
        },
        {
            "FieldName": "Capital Change Announcement Date",
            "Format": null
        },
        {
            "FieldName": "Currency Code",
            "Format": null
        },
        {
            "FieldName": "Exchange Code",
            "Format": null
        }
    ],
    "Condition": {
        "ReportDateRangeType": "Range",
        "QueryStartDate": "2017-09-11T00:00:00.000Z",
        "QueryEndDate": "2017-09-13T23:59:59.000Z",
        "ExcludeDeletedEvents": true,
        "IncludeCapitalChangeEvents": true,
        "IncludeDividendEvents": true,
        "IncludeEarningsEvents": true,
        "IncludeMergersAndAcquisitionsEvents": true,
        "IncludeNominalValueEvents": true,
        "IncludePublicEquityOfferingsEvents": true,
        "IncludeSharesOutstandingEvents": true,
        "IncludeVotingRightsEvents": true,
        "CorporateActionsCapitalChangeType": "CapitalChangeExDate",
        "CorporateActionsDividendsType": "DividendPayDate",
        "CorporateActionsEarningsType": "PeriodEndDate"
    }
}

This request will create the following template in GUI.


corporateactions.png (25.4 KiB)
icon clock
10 |1500

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

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

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