question

Upvotes
Accepted
muneish.adya avatar image
9 ●4 ●3 ●8

Hi, How can I extract the following columns from corporate actions standard using trth - region,adjtype,description

"ric,region,splitdate,adjtype,adjustment,description"
"000001.SZ,F,1995-09-25,43,0.833333,2:10 Non-renounceable scrip issue in same stock"
"000001.SZ,F,1996-05-27,43,0.5,10:10 Non-renounceable scrip issue in same stock"
"000001.SZ,F,1997-08-25,43,0.666667,5:10 Non-renounceable scrip issue in same stock"
"000001.SZ,F,2000-11-06,13,0.873533,3:10 Non-renounceable rights issue in same stock"
"000001.SZ,F,2007-06-20,33,1,Return of capital"
"000001.SZ,F,2007-06-20,43,1,1:10 Non-renounceable scrip issue in same stock"
"000001.SZ,F,2013-06-20,80,0.625,6:10 Stock dividend, same stock"
"000001.SZ,F,2013-06-20,80,0.625,6:10 Stock dividend, same stock"
"000001.SZ,F,2014-06-12,43,0.833333,2:10 Non-renounceable scrip issue in same stock"
"000001.SZ,F,2015-04-13,43,0.833333,2:10 Non-renounceable scrip issue in same stock"
"000001.SZ,F,2016-06-16,43,0.833333,2:10 Non-renounceable scrip issue in same stock"
"000002.SZ,F,1993-04-05,43,0.666667,5:10 Non-renounceable scrip issue in same stock"
"000002.SZ,F,1994-06-21,43,0.740741,3.5:10 Non-renounceable scrip issue in same stock"
"000002.SZ,F,1995-07-04,43,0.869565,1.5:10 Non-renounceable scrip issue in same stock"
"000002.SZ,F,1996-08-06,43,0.909091,1:10 Non-renounceable scrip issue in same stock"
"000002.SZ,F,1997-06-27,43,0.869565,1.5:10 Non-renounceable scrip issue in same stock"
"000002.SZ,F,1997-07-14,11,0.857422,2.37:10 Rights issue in same stock"
"000002.SZ,F,1998-07-10,43,0.909091,1:10 Non-renounceable scrip issue in same stock"
"000002.SZ,F,1999-08-06,43,0.909091,1:10 Non-renounceable scrip issue in same stock"
"000002.SZ,F,2000-01-10,11,0.931956,2.727:10 Rights issue in same stock"
"000002.SZ,F,2003-05-23,43,0.5,10:10 Non-renounceable scrip issue in same stock"
"000002.SZ,F,2004-05-26,43,0.666667,5:10 Non-renounceable scrip issue in same stock"
"000002.SZ,F,2005-06-29,43,0.666667,5:10 Non-renounceable scrip issue in same stock"
"000002.SZ,F,2007-05-16,43,0.666667,5:10 Non-renounceable scrip issue in same stock"

tick-history-rest-api
icon clock
10 |1500

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

1 Answer

Upvotes
Accepted
veerapath.rungruengrayubkul avatar image
11.3k ●25 ●8 ●13

@muneish.adya

The "Adjustment Factor", "Capital Change Event Type", "Capital Change Event Type Description" and "Capital Change Ex Date" field seems to match your given data. However, I cannot find a field for region.

Below is the sample output.

RIC,Adjustment Factor,Capital Change Event Type,Capital Change Event Type Description,   Capital Change Ex Date
000001.SZ,0.833333,43,Non-renounceable scrip issue in same stock,6/16/2016
000001.SZ,0.833333,43,Non-renounceable scrip issue in same stock,6/12/2014
000001.SZ,0.769231,43,Non-renounceable scrip issue in same stock,10/31/2008
000001.SZ,0.625,80,Stock dividend, same stock,6/20/2013
000001.SZ,1,33,Return of capital,6/20/2007
000001.SZ,0.833333,43,Non-renounceable scrip issue in same stock,4/13/2015
000001.SZ,0.638999,71,Complex capital change,7/11/1994
000001.SZ,0.833333,43,Non-renounceable scrip issue in same stock,9/25/1995
000001.SZ,0.666667,43,Non-renounceable scrip issue in same stock,8/25/1997
000001.SZ,0.873533,13,Non-renounceable rights issue in same stock,11/6/2000
000001.SZ,1,43,Non-renounceable scrip issue in same stock,6/20/2007
000001.SZ,0.518138,71,Complex capital change,5/24/1993
000001.SZ,0.5,43,Non-renounceable scrip issue in same stock,5/27/1996
icon clock
10 |1500

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

Click below to post an Idea Post Idea