Upgrade from Eikon -> Workspace. Learn about programming differences.

For a deeper look into our Eikon Data API, look into:

Overview |  Quickstart |  Documentation |  Downloads |  Tutorials |  Articles

question

Upvotes
Accepted
3 0 0 3

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?

eikoneikon-data-apipythonrefinitiv-dataplatform-eikonworkspaceworkspace-data-api
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.

Upvotes
Accepted
10.1k 18 6 9

@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.

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.

Upvotes
10.1k 18 6 9

@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.


1624606540979.png (39.3 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.

Upvotes
3 0 0 3

@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.

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.