I want to create a adjustfactor sheet like the picture below,any one who can help me?
by the ek.get_data() or ek.get_timeseries() way
For a deeper look into our Eikon Data API, look into:
Overview | Quickstart | Documentation | Downloads | Tutorials | Articles
39.2k
●75 ●11 ●27
@wyj
There are multiple issues with what you're trying to do. In the example request you provided you're mixing up fields from different categories: dividend history, capital change history and adjustment factor history. As a result you have columns of data related to different events, which are not aligned on the rows. E.g. the TR.CAAdjustmentFactor of 0.833333 returned at the top of the column is related to the scrip issue effective 16-Jun-2016 and has no relation to the cash dividend paid on 21-Jul-2017.
If you're looking to retrieve adjustment factors specific to dividends then use
ek.get_data(['000001.SZ'],['TR.DivPaymentType','TR.DivExDate','TR.DivAdjustmentFactor'],{'SDate':0, 'EDate':-6000})What you will notice is that for Chinese stocks the adjustment factor returned for cash dividends is null. This is because in line with market practice Thomson Reuters does not adjust price history for Chinese stocks for most cash dividends. See the discussion on
this thread for more details on how Thomson Reuters adjusts stock prices history for capital changes and how you can you can perform additional adjustments following the methodology of your choosing.
4.6k
●26 ●7 ●22
Due to a bug in handling null values while returning series in get_data(), it is not currently possible. This issue should be fixed in the upcoming release though.
