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

muneish.adya
muneish.adya Explorer
in TRTH

...djtype,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"

Tagged:

Best Answer

  • veerapath.rungruengrayubkul
    veerapath.rungruengrayubkul LSEG
    Answer ✓

    @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

Categories