Returning split type

Hi,

i'm currently making the following request to return all historical and future splits for a select list of tickers;

fields = [

'TR.CAEffectiveDate',

'TR.CAAdjustmentFactor',

'TR.CAAdjustmentType',

'TR.CATermsOldShares',

'TR.CATermsNewShares',

]

r, e = ek.get_data(Refinitive_Tickers['RIC_CODE'].tolist(), fields, {'CAEventType':'SSP'})

Is there any way to return an indicator whether it was a split with redemption or without redemption?

Best Answer

  • @christian.risom01 Thanks for the additional information - so the list of event types is as I have shown you in the Corporate Action Event Type Parameter. If you know of a date and company where such a thing happened you could try to see if this is captured by the ALL corporate actions events then try to see where it is showing up. I think the terminology is different in Fixed Income bonds are redeemed and that is standard. In equities however, to my knowledge shares are bought back or canceled or extinguished. I think the key point you are trying to see is if the sharesplit event had a capital change event as well (in your case the redemption part). If this doesn't help then I think you may need to get this clarified with a content specialist (Corporate Actions or CORAX). You can do this by raising a content query in Contact Us. I hope this can help. Please let me know how you get on.

Answers

  • @christian.risom01 So i'm not sure what you mean when you say redemption - do you mean stock buyback? You can see all the Event Types supported in the Data Item Browser app (type DIB into eikon search). See below
    1624606540979.png


    If you want to filter for more than one of these just request All and then filter on the ones you want ie splits and buybacks on the same date. Or just request Buybacks and Share Splits and filter on common dates. I hope this can help.

  • @jason.ramchandani

    Here's a case to further elaborate;

    A stock split is carried out the description of the split is as follows;

    "Redemption procedure share split, whereby 1 share is converted into 2 shares an ordinary share and a redemption share. The price to be paid for each redemption share is SEK 3.00. Redemption share trade under ISIN XXXXXXXXXXXXXXXX."

    I wish to be able to determine in all cases if the stocksplit happened under a "Redemption Procedure".

    the reason is that i'm only interested in stocksplits where the total amount of stocks actually changes.