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
54 1 0 5

Workspace API returns NaT for some fields, but in Data Item Browser there is full value for these fields

When using Workspace API in Python under Windows 10, some fields produce "NaT" results, but these fields have full values in Data Item Browser.


E.g. the Python command


df=rd.get_data(['MMM.N','BAG.L','AOS.N'], ['TR.ISUpdateType','TR.IsISFlashUpdated','TR.IsBSFlashUpdated','TR.IsCFFlashUpdated'], parameters={'NULL':'Blank'})


produces no results for the required fields.


How can one obtain the values for these fields in Python?

workspace#technologypython apirefinitiv-data-libraries
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
Upvote
Accepted
10.8k 21 6 9

@IoannisG Thanks for your question - have you tried:

import refinitiv.data as rd
rd.open_session()
df=rd.get_data(['MMM.N','BAG.L','AOS.N'],
               ['TR.F.UpdateType(StType=INC)','TR.F.IsFlashUpdated(StType=INC)',
                'TR.F.UpdateType(StType=BAL)','TR.F.IsFlashUpdated(StType=BAL)',
                'TR.F.UpdateType(StType=CAS)','TR.F.IsFlashUpdated(StType=CAS)'],
               parameters={'Period':'FY0'},
               use_field_names_in_headers=True
              )
df

1717688156181.png

There are also more StTypes available - please see the Data Item Browser (type DIB into Eikon/WS Search bar) and search for 'Update Type' or 'Is Flash Updated' - on the right had pane - look at the parameter settings.


I hope this can help.


1717688156181.png (65.8 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.