question

Upvotes
Accepted
ykr1314 avatar image
10 ●3 ●4 ●6

How to get Corporate Actions from 1900.01.01 till today in onDemadExtract for a ric

How do I get this

ric region splitdate adjtype adjustment description ..
-----------------------------------------------------------------------------..
000001.SZ F 1995.09.25 43 0.833333 2:10 Non-renounceable scrip is..
000001.SZ F 1996.05.27 43 0.5 10:10 Non-renounceable scrip i..
000001.SZ F 1997.08.25 43 0.666667 5:10 Non-renounceable scrip is..
000001.SZ F 2000.11.06 13 0.873533 3:10 Non-renounceable rights i..
000001.SZ F 2007.06.20 33 1 Return of capital ..
000001.SZ F 2007.06.20 43 1 1:10 Non-renounceable scrip is..
000001.SZ F 2013.06.20 80 0.625 6:10 Stock dividend, same stoc..
000001.SZ F 2013.06.20 80 0.625 6:10 Stock dividend, same stoc..
000001.SZ F 2014.06.12 43 0.833333 2:10 Non-renounceable scrip is..
000001.SZ F 2015.04.13 43 0.833333 2:10 Non-renounceable scrip is..
000001.SZ F 2016.06.16 43 0.833333 2:10 Non-renounceable scrip is..

at present I am able to get this for same ric

RIC Capital Change Ex Date Capital Change Event Type Adjustment Factor Capital Change Event Type Description
---------------------------------------------------------------------------------------------------------------------------
"000001.SZ" "2016/06/16" "43" ".833333" "Non-renounceable scrip issue in same stock"

How do I get back date data for same ric instead of just the latest CA.

tick-history-rest-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.

zoya faberov avatar image   zoya faberov

Hello @ykr1314,

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

moragodkrit.chumsri_1 avatar image   moragodkrit.chumsri_1

Hello @ykr1314,

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

veerapath.rungruengrayubkul avatar image   veerapath.rungruengrayubkul

Hello @ykr1314,

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

To get back date date, you may specify the date range in the request's Conditions. Below are the sample of Corporate Actions request and result. Some rows do not match.

{
  "ExtractionRequest": {
    "@odata.type": "#ThomsonReuters.Dss.Api.Extractions.ExtractionRequests.CorporateActionsStandardExtractionRequest",
    "ContentFieldNames": [
        "RIC",
        "Capital Change Ex Date",
        "Capital Change Event Type",
        "Actual Adjustment Factor",
        "New Shares Terms",
        "Old Shares Terms",
        "Capital Change Event Type Description"
    ],
    "IdentifierList": {
      "@odata.type": "#ThomsonReuters.Dss.Api.Extractions.ExtractionRequests.InstrumentIdentifierList",
      "InstrumentIdentifiers": [{
        "Identifier": "000001.SZ",
        "IdentifierType": "Ric"
      }]
    },
    "Condition": {
      "ReportDateRangeType": "Range",
      "QueryStartDate": "1990-01-01T00:00:00.000Z",
      "QueryEndDate": "2017-11-09T00:00:00.000Z",
      "ExcludeDeletedEvents": true,
      "IncludeCapitalChangeEvents": true,
      "IncludeDividendEvents": false,
      "IncludeEarningsEvents": false,
      "IncludeMergersAndAcquisitionsEvents": false,
      "IncludeNominalValueEvents": false,
      "IncludePublicEquityOfferingsEvents": false,
      "IncludeSharesOutstandingEvents": false,
      "IncludeVotingRightsEvents": false,
      "CorporateActionsCapitalChangeType": "CapitalChangeExDate",
      "CorporateActionsDividendsType": "DividendPayDate",
      "CorporateActionsEarningsType": "PeriodEndDate",
      "ShareAmountTypes": [
      ]
    }
  }
}
RIC,Capital Change Ex Date,Capital Change Event Type,Actual Adjustment Factor,New Shares Terms,Old Shares Terms,Capital Change Event Type Description
000001.SZ,1996/05/27,43,.5,10,10,Non-renounceable scrip issue in same stock
000001.SZ,1993/05/24,71,.518138,9.5,10,Complex capital change
000001.SZ,2007/06/20,43,1,1,10,Non-renounceable scrip issue in same stock
000001.SZ,2000/11/06,13,.873533,3,10,Non-renounceable rights issue in same stock
000001.SZ,1997/08/25,43,.666667,5,10,Non-renounceable scrip issue in same stock
000001.SZ,1995/09/25,43,.833333,2,10,Non-renounceable scrip issue in same stock
000001.SZ,1994/07/11,71,.638999,6,10,Complex capital change
000001.SZ,2014/06/12,43,.833333,2,10,Non-renounceable scrip issue in same stock
000001.SZ,2015/04/13,43,.833333,2,10,Non-renounceable scrip issue in same stock
000001.SZ,2007/06/20,33,,,,Return of capital
000001.SZ,2013/06/20,80,.625,6,10,"Stock dividend, same stock"
000001.SZ,2008/10/31,43,.769231,3,10,Non-renounceable scrip issue in same stock
000001.SZ,2016/06/16,43,.833333,2,10,Non-renounceable scrip issue in same stock

With regard to data availability, I have found the following information in the User Guide for Tick History 11.2 GUI


corpaction.png (12.2 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.