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

How to get all Eikon Python API fields into an excel spreadsheet?

I am looking for a way to get all Data Item Codes (e.g. TR.VWAPVOLUME) into an Excel spreadsheet. I am aware that the Data Item Browser contains all Data Item Codes. I am looking for a way to consolidate all fields in an excel spreadsheet for programmatic use.

eikoneikon-data-apipythonrefinitiv-dataplatform-eikonworkspaceworkspace-data-apiapifieldsdata-item-browser
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
39.4k 77 11 27

I'm afraid there's no good way of doing this currently. The most you can do is follow Formula Builder wizard in Excel and include the list of fields as cell references for use in =TR function one category of fields at a time.

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.