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!