Upgrade from Eikon -> Workspace. Learn about programming differences.

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

Overview |  Quickstart |  Documentation |  Downloads |  Tutorials |  Articles

question

Upvotes
Accepted
16 3 1 5

Eikon Python API: most recent data are missing

I try to download common shares outstanding using the following code, and find data are not available for the most recent quarters, whereas they are available from EXCEL and Eikon Web App.

tickers = ['GOOG.O'] start_date = dt.datetime(2000,1,1)
end_date = dt.datetime(2017, 12, 29)
date_format = '%Y-%m-%d'
parameters = {'SDate':start_date.strftime(date_format),
'EDate':end_date.strftime(date_format),
'FRQ': 'FQ',
'Period': 'FQ0',
'Curn': 'USD'} debug_mode = True fields = [ek.TR_Field('TR.ISSourceDate'), # reported date
ek.TR_Field('TR.ISSource'), # source
ek.TR_Field('TR.TtlCmnSharesOut'), # total common shares outstanding
]

data_grid4, err4 = ek.get_data(tickers, fields, parameters, debug= debug_mode)
eikoneikon-data-apipythonrefinitiv-dataplatform-eikonworkspaceworkspace-data-apifundamentals
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.

Upvotes
Accepted
78.1k 246 52 72

There is a known issue that the underlying API does not handle NULL values correctly so the data in the column is shifted upward.

For example:

The following is the output from Eikon Data API.

However, Eikon excel returns:

In summary, with Eikon Data API, the data in recent rows are null because the data in the column is shifted upward to replace the null value,

For more information, please refer to this question.


eikondataapi.png (29.7 KiB)
excel.png (36.7 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.

Upvotes
16 3 1 5

Is there a way to circumvent the problem, and when do we expect the bug fixed?

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.

There's no workaround, I'm afraid. The fix is currently expected by the end of April.

The issue has been 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.