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
yogesh.sharma avatar image
1 ●1 ●2 ●1

While retrieving TR.Volume using get_data fill blanks with Na instead of 0

While we get the dataframe from eikon api for Daily volumes, on the days where trading doesn't happen is filled with 0 instead of just returning blanks.

eikoneikon-data-apipythonrefinitiv-dataplatform-eikonworkspaceworkspace-data-apiparameters
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 ●26 ●7 ●22

get_data has a NULL parameter (NA|ZERO|BLANK), however, it does not seem to work for time series over get_data() call. So, the only two things I can suggest is either to use get_timeseries() or use pandas:

df.replace(0, np.nan, inplace=True)
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.