retrieve CAMarketAdjustmentFactor data via EIKON python API

I am trying to retrieve CAMarketAdjustmentFactor from EIKON python data API.

with belowing code:

ek.get_data('000001.SZ', [ 'TR.CAMarketAdjustmentFactor', 'TR.CAExDate', 'TR.CADealDate', 'TR.CAEffectiveDate' ], {'SDate':'0D', 'EDate':'-40AY'})

or

ek.get_data('000001.SZ', [ 'TR.AdjmtFactorAdjustmentFactor', 'TR.AdjmtFactorAdjustmentDate', 'TR.AdjmtFactorAdjustmentType', 'TR.AdjmtFactorIsApplied', 'TR.AdjmtFactorUnderlyingEventId', ], {'SDate':'1980-01-01', 'EDate':'2018-08-31'})

the results just show the records from 1995.

image

or via Excel give me same results.

=TR("000001.SZ","TR.AdjmtFactorAdjustmentDate;TR.AdjmtFactorAdjustmentFactor","SDate=1980-06-01 EDate=2018-05-01 CH=Fd RH=IN",G1)

but within EIKON, I can see following:

image

So my question is how could I retrieve the two records of 1994 and 1993 at the bottom via the API.

Best Answer

Answers