New posts are disabled while we improve the user experience.

You can browse the site, or for urgent issues, raise a query at MyAccount.

question

Upvotes
Accepted
rahul.bevinahal avatar image
48 ●1 ●0 ●5

Corporate Action Adjustment Factor Missing Data Bug Eikon API

ek.get_data(['CRDI.MI'], ['TR.AdjmtFactorAdjustmentDate', 'TR.AdjmtFactorAdjustmentFactor'], {'EDate': '2017-09-29', 'SDate': '2011-01-01'}, debug = True, raw_output=True)

Returns

{'columnHeadersCount': 1,
 'data': [['CRDI.MI', '2017-02-06', 1],
  ['CRDI.MI', '2017-01-23', 0.501126],
  ['CRDI.MI', '2016-04-18', 10],
  ['CRDI.MI', '2015-05-18', 1],
  ['CRDI.MI', '2014-05-19', 1],
  ['CRDI.MI', '2012-04-11', 1],
  ['CRDI.MI', '2012-01-09', 1],
  ['CRDI.MI', '2011-12-27', 0.658631],
  ['CRDI.MI', '', 10]],
 'headerOrientation': 'horizontal',
 'headers': [[{'displayName': 'Instrument'},
   {'displayName': 'Corporate Action Adjustment Factor Date',
    'field': 'TR.ADJMTFACTORADJUSTMENTDATE'},
   {'displayName': 'Corporate Action Adjustment factor',
    'field': 'TR.ADJMTFACTORADJUSTMENTFACTOR'}]],
 'rowHeadersCount': 1,
 'totalColumnsCount': 3,
 'totalRowsCount': 10}

Adjustment factor for 2017-02-06 should be 0.501126 and not 1. Excel returns the data correctly

Stock,Corporate Action Adjustment Factor Date,Corporate Action Adjustment factor

CRDI.MI,NULL,1

CRDI.MI,06/02/2017,0.501126

CRDI.MI,23/01/2017,10

CRDI.MI,18/04/2016,1

CRDI.MI,18/05/2015,1

Kindly suggest a workaround for this.

eikoneikon-data-apipythonworkspacerefinitiv-dataplatform-eikonworkspace-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.

1 Answer

· Write an Answer
Upvotes
Accepted
Zhenya Kovalyov avatar image
4.6k ●27 ●7 ●22

@rahul.bevinahal what do you have in your params? When I am doing the following request:

r, e = tr.get_data(['CRDI.MI'], ['TR.AdjmtFactorAdjustmentDate', 'TR.AdjmtFactorAdjustmentFactor'])

It comes back as:

Which is exactly the value you are looking for.


screen-shot-2018-01-12-at-084706.png (22.2 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.

rahul.bevinahal avatar image rahul.bevinahal

Appreciate quick response. 

params = {'EDate': '2017-09-29', 'SDate': '2011-01-01'}
Zhenya Kovalyov avatar image Zhenya Kovalyov rahul.bevinahal

@rahul.bevinahal there is a known bug in the underlying API that does not handle NULL values correctly, thus shifting the column up.

rahul.bevinahal avatar image rahul.bevinahal Zhenya Kovalyov

Is there any link/webpage I can follow to track this issue? This is a blocker for us

Show more comments
Alex Putkov.1 avatar image Alex Putkov.1 rahul.bevinahal

The issue is fixed as of 30-Apr-18.

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.