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

Overview |  Quickstart |  Documentation |  Downloads |  Tutorials |  Articles

question

Upvotes
Accepted
16 1 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-apiworkspaceworkspace-data-apirefinitiv-dataplatform-eikonpythonfundamentals
icon clock
10 |1500

Up to 2 attachments (including images) can be used with a maximum of 5.0 MiB each and 10.0 MiB total.

Upvotes
Accepted
38.1k 71 35 53

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 5.0 MiB each and 10.0 MiB total.

Upvotes
16 1 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 5.0 MiB each and 10.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.

Click below to post an Idea Post Idea