For a deeper look into our Eikon Data API, look into:

Overview |  Quickstart |  Documentation |  Downloads |  Tutorials |  Articles

question

Upvotes
Accepted
1 0 0 0

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-apiworkspaceworkspace-data-apirefinitiv-dataplatform-eikonpython
icon clock
10 |1500

Up to 2 attachments (including images) can be used with a maximum of 5.0 MiB each and 10.0 MiB total.

Upvotes
Accepted
23k 22 9 14

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 5.0 MiB each and 10.0 MiB total.

Upvotes
38.1k 69 35 53

@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 5.0 MiB each and 10.0 MiB total.

Upvotes
1 0 0 0

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 5.0 MiB each and 10.0 MiB total.

Click below to post an Idea Post Idea