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 2 5 5

How to use Saved Tickers List in Eikon

I have saved a list of tickers that I commonly work on in Eikon, with the name 'Current Univ'

I use this command to fetch data in excel

=@TR("LIST(Current_Univ)","TR.BookValuePerShare","Period=FY0 Frq=D SDate=20160101 EDate=1d CH=IN RH=calcdate",B2)

I want to use the same list of tickers to work in python as well. How can I use this.

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.

Hello @anshulmlhtr,

Thank you for your participation in the forum.

Is one of the replies below satisfactory in resolving your query?

If yes, please click the 'Accept' text next to the appropriate reply. This will guide all community members who have a similar question. Otherwise please post again offering further insight into your question.

Thanks,

-AHS

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


Upvotes
Accepted
32.2k 40 11 20

Hello @anshulmlhtr,

Try, according to the suggestion by @jirapongse.phuriphanvichai

ListData,err = ek.get_data("List('Current Universe ')",'TR.RIC;CF_LAST;TR.BookValuePerShare',{'Period':'FY0', 'SDate':'20160101', 'EDate':'1d','Frq':'D' })
ListData


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
79.1k 250 52 74

@anshulmlhtr

Yes, refer to the Eikon Data API - Cheat Sheet, you can use the list method in the Eikon Data API.

ListData,err = ek.get_data("List('test-list1')",['TR.RIC','CF_LAST'])
ListData
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
1 2 5 5

The cheat sir is great @jirapongse.phuriphanvichai, though I still can't find a way to implement my query.

I have already saved some rics/tickers in my Eikon account with the name 'Current Universe'.

I want to use this list to fetch data, can you please share the ek.get_data( {something here} , TR.PE , ...) type command for the same.

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.