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?


Best Answer

  • Jirapongse
    Jirapongse ✭✭✭✭✭
    Answer ✓

    @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.

Answers