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
H_U avatar image
3 ●3 ●5 ●5

How can I get previous price data for NULL values ​​in EIKON DATA API?

Good morning?


We want to receive price data through the Eikon Data API, and we are currently testing for that. I have something to inquire about it.


When receiving price data using the ‘Refinitiv Eikon’ tab in Excel, I can adjust for null values using the ‘Parameters & Quick Functions’ section of ‘Build Formula’. For example, in the United States, January 18 was a closed Monday. In 'Build Formula', I can set whether to import price data for January 15th versus January 18th in options.


Please ask if this optional feature is also available in the Eikon Data API. When I receive timeseries data from Eikon Data API, I don't get price data on January 18, is it possible to fill it with previous price data? We want to be able to receive pricing data for all days of the week (including holidays) except Saturday and Sunday.


Thank you very much for your hard work

eikoneikon-data-apipythonrefinitiv-dataplatform-eikonworkspaceworkspace-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.

wasin.w avatar image   wasin.w

Hello @jijija

Thank you for your participation in the forum. Is the reply below satisfactory in resolving your query?


If so please can you click the 'Accept' text next to the appropriate reply? This will guide all community members who have a similar question.

Thanks,


AHS

wasin.w avatar image   wasin.w

Please be informed that a reply has been verified as correct in answering the question, and has been marked as such.

Thanks,


AHS


1 Answer

· Write an Answer
Upvotes
Accepted
jason.ramchandani01 avatar image
10.2k ●18 ●6 ●9

@jijija I am not aware of such functionality natively in the eikon data api. However it is pretty standard in pandas dataframe functionality. Please see the following reference in pandas guide on fillna functionality. Basically once you have your dataframe filled with data that may contain some NA values you can simply:

df.fillna(method='ffill')

and that will propagate the previous value before NA - into the NA. I hope this can help.

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.

H_U avatar image H_U

Thank you for answer.

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.