"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"
9
●6 ●7 ●12
Hi, How can I extract the following columns from corporate actions standard using trth - region,adjtype,description
Hi @muneish.adya.
Thank you for your participation in the forum.
Is the reply below satisfactory in resolving your query?
If so please can you click the 'Accept' text next to the appropriate reply. This will guide all community members who have a similar question.
Thanks
AHS
Thank you for your participation in the forum.
Are any of the replies below satisfactory in resolving your query?
If yes please click the 'Accept' text next to the most appropriate reply. This will guide all community members who have a similar question.
Otherwise please post again offering further insight into your question.
Thanks,
AHS
11.3k
●25 ●9 ●14
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
