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

Overview |  Quickstart |  Documentation |  Downloads |  Tutorials |  Articles

question

Upvotes
Accepted
9 0 1 1

Corporate actions adjustments: Event type = "Stock Dividend" missing from get_data() request

I am trying to get a list of adjustment factors for corporate actions for AAON.O, and run the following API request:

df = ek.get_data('AAON.O', 
                 ['TR.AdjmtFactorAdjustmentDate', 
                  'TR.AdjmtFactorAdjustmentType', 
                  'TR.AdjmtFactorAdjustmentFactor'],
                  {'Sdate':'1990-01-01', 'EDate':'2020-12-21'})[0]

I get the following output

The same output is retrieved when using the Excel plugin.

When I search for the same thing on the Eikon platform application, under menu Event/Capital Change Overview I get the following list for Corporate Events and corresponding adjustment factors:

When comparing the two outputs, I noticed that the data requested via Eikon API is missing the event that is listed in the platform under "Event Type = Stock Dividend", the one on ExDate = 07-Mar-1995. When I look under Event/Dividend Overview, this event does not appear on the list, so it is categorized under Corporate Actions only, and not under Dividend.

I noticed similar behaviour for quite a few other RICs that have Event Type = Stock Dividend in Capital Changes overview - these are not returned by get_data(). So this behaviour appears to be systematic.

Is there a reason why Stock Dividend Event Type cannot be retrieved via Eikon API or the Excel plugin?

Thanks!

eikoneikon-data-apiworkspaceworkspace-data-apirefinitiv-dataplatform-eikonpython
api-output.jpg (32.4 KiB)
platform-output.jpg (65.9 KiB)
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.

Upvotes
Accepted
39.2k 75 11 27

@oik22

I make no claim whether the data presented in Capital Change Overview (NEW) app for any given stock is correct. The only claim I make is that it is consistent between all the interfaces (Eikon app, Eikon Excel, Eikon Data APIs).
This forum is not the best place to raise content search and explanation queries. The moderators on this forum do not have deep expertise in every type of content available through Refinitiv products, and are not in a position to answer specific content challenges. If you'd like an explanation for a piece of content or if you'd like to challenge the correctness of any content presented, the best resource is Refinitiv Helpdesk, which can be reached by calling the Helpdesk number in your country, using Contact Us capability in your Eikon application or by visiting MyRefinitiv. Refinitiv Helpdesk has access to content specialists for every type of content available through Eikon, who can provide explanation or answer any content challenges. I suggest you open a case with Refinitiv Helpdesk to ask about 11:10 stock split for AAON.O on 7-Mar-95 and to voice your concerns about dividend history. Or, if you prefer, I can do it on your behalf. To the best of my knowledge there have not been any changes to the backend interfaces for dividend history, unlike for capital change history. But again, it would be best to confirm this with the Helpdesk.

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.

@Alex Putkov.
Thanks very much for your patience with this matter and for your suggestion to contact the Helpdesk. I will give them a call, and will direct any future content-related queries to them. Thanks again for your continued support.
Upvotes
39.2k 75 11 27

@oik22

This question is very similar to the previous one you asked on this thread. The data returned by Eikon Data APIs or by Eikon Excel is not always supposed to match the data you see in Capital Change Overview (OLD) app in Eikon. Instead of Capital Change Overview (OLD) app use Capital Change Overview (NEW) app, which matches the data returned by Eikon Data APIs and Eikon Excel. For more details see the explanation provided by Refinitiv Support in the answer on the thread I referenced above.

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.

Upvotes
9 0 1 1

@Alex Putkov.

Thanks for your response. The thread you refer to was about inability of the OLD system to handle multiple events on the same day and hence the need to summarize them under a single event on a single date. The issue in this question concerns a missing single event on a single date. In this view, is there a list of all Capital Change Event Types that appear in the OLD Capital Change, but are missing in the NEW Capital Change app? So far I managed to find two: Multiple Events and Stock Dividend. Are there more?

I understand the difference between the NEW and the OLD Capital Changes apps. However, I struggle to come to terms with the fact that the NEW data delivery system that is currently in use has multiple missing corporate action events for which price adjustments have been processed and applied to price time series (i.e. when computing the implied corporate actions price adjustment factor as the ratio between corax adjusted and unadjusted daily stock prices, the dates for events that are missing in the NEW Capital Change Overview do have adjustments factors that correspond precisely to the dates and adjustment factors reported in the OLD Capital Change Overview).

I have checked with other sources, and they confirm that AAON.O has an event on 07-Mar-1995 that split the stock 11:10. So, if the event had happened, the adjustment factor does exist in your dataset and appears in the OLD Capital Change Overview app, the adjustment factor has been applied to produce correct corax adjusted prices time series, does that not imply that Eikon API intentionally feeds incomplete corporate actions data under the new infrastructure? In fact, I found this issue to be present in hundreds of US stocks.

I am also concerned whether something like this can happen with Dividend data too, i.e. is it possible that the Dividend Overview app contains dividend payments that are missing from the Eikon API data feed? This would be a more serious issue for me, as I would like to compute stock prices adjusted for dividends, and I need to do this manually by computing dividend adjustment factors and applying them to corax adjusted stock prices. However, if some dividend events are missing when downloaded through Eikon API, that would result in incorrect/incomplete adjustments being applied.

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