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
gaetano.martinico avatar image
1 ●0 ●0 ●1

I don't understand what issues my python code has

I have a really heavy excel file 400K rows, and I need, using cusip or ticker and date of shareholder meeting (variables for each row) to download data such as revenues, total asset, market cap, etc. for my thesis. I tried excel =TR(...) formula, but does not recognise cusip or ticker, while datastream recognise the ticker or @ticker but when I run the formula for all rows my file stop to work, and excel crash. Therefore I tried using chatgpt trying to use python but it seems there is not a way to use datastream through python or at least I don't have accademic API key. I have eikon and refinitiv API key. I tried using eikon but even through python can't find the data, showing N/A or ticker not found, even if looking for the ticker within desktop app, the company can be found. If a value is found is different than the one downloaded in the few rows where datastream in excel worked. I don't know how to populate my heavy database without crash.
Python provide several errors or no data (N/A)
What do you suggest?
First example
1717879128806.png

1717879144203.png



SECOND
1717879229970.png

1717879248776.png


What Identifier do you suggest to use?


#contentpython api
1717879229970.png (42.1 KiB)
1717879248776.png (78.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.

2 Answers

· Write an Answer
Upvotes
Accepted
Jirapongse avatar image
83.1k ●281 ●53 ●77

@gaetano.martinico

Thank you for reaching out to us.

You can try the CUSIP codes directly in the get_data method without prefixing them with 'CUSIP='.

1717992725031.png
I suggest to use the Refinitiv Data Library for Python instead.

The library contains the symbology API that can convert tickers or CUSIPs to RICs.

1717992981778.png

Then, you can use RICs wit the rd.get_data method to retrieve the data.

The examples are available on GitHub.


1717992725031.png (11.2 KiB)
1717992981778.png (22.0 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.

gaetano.martinico avatar image gaetano.martinico
Really thanks, since my excel file, where I get the cusip and ticker is really heavy (500k rows) what would you suggest? for just 500 rows and only revenues python is taking more than 10 minutes, and datastream or refinitv formula in excel provide several issues. What could be a fast way?
Upvotes
Jirapongse avatar image
83.1k ●281 ●53 ●77

@gaetano.martinico

Typically, there are limitations when using the desktop APIs, as mention in the Eikon Data API Usage and Limits Guideline. Moreover, if you request a lot of data, the request can be canceled or timed out by the server.

I suggest you to contact your LSEG account team or sales team directly to discuss the solution that is suitable for this usage.

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.