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
21 4 5 6

How to backfill missing data?

Hello,

There are always some missing data point for any inquiry and I understand that. For example:

ek.get_data('015351109', ['TR.PE'], {'SDate':'20180830'})

got nothing even 015351109 is a company on S&P 500 list.

My question is, is there a parameter in the ek.get_data function that can return the nearest available data if the data on '20180830' is not available? For example,

ek.get_data('015351109', ['TR.PE'], {'SDate':'20180730'}) has a value and I want to get that value return if my inquiry for data on '20180830' got nothing.


Thanks!


eikoneikon-data-apipythonrefinitiv-dataplatform-eikonworkspaceworkspace-data-api
error.png (11.9 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
Accepted
18.2k 21 13 21

Hi @aryer

There are 2 topics:

1. Why the data between 2018-07-26 to 2018-10-25 is not available

For content question, please contact Refinitiv Content Helpdesk, specifying Eikon as product, so Eikon content experts can help identify the required content.

2. If you would like to remove NaN rows in dataframe

You can use this code:


ahs02.png (27.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
18.2k 21 13 21

Hi @aryer

I think you can request data in range to cover the date which you want and look for the next available data point if that data point is missing.

This is an example:


ahs3.png (38.6 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.

got the result for '015351109' from 2018-01-01,EDate=2019-01-31 using the following function:

df,e = ek.get_data('015351109',['TR.PE(SDate = 2018-01-01,EDate=2019-01-31,Frq=D).Date','TR.PE(SDate = 2018-01-01,EDate=2019-01-31,Frq=D)'])

Please check attached for results. And you can see that the data jumped from 2018-07-26 to 2018-10-25, from 50.45 to 105.59, without any data points in between.

Could you let me know why this happened? Any methods to fix it?

Thank you!temp.txtresult.jpg

temp.txt (12.3 KiB)
result.jpg (134.5 KiB)
Upvotes
21 4 5 6

result.jpgI got the result for '015351109' from 2018-01-01,EDate=2019-01-31 using the following function:

df,e = ek.get_data('015351109',['TR.PE(SDate = 2018-01-01,EDate=2019-01-31,Frq=D).Date','TR.PE(SDate = 2018-01-01,EDate=2019-01-31,Frq=D)'])

Please check attached for results. And you can see that the data jumped from 2018-07-26 to 2018-10-25, from 50.45 to 105.59, without any data points in between.

Could you let me know why this happened? Any methods to fix it?

Thank you!


result.jpg (134.5 KiB)
temp.txt (12.3 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.

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.