using Python to download all securities that have exposures to a country, a sector, or a company ...

jeremie.zhou
jeremie.zhou Newcomer
in Eikon Data APIs

...to excel

I wanted to download from Refinitiv Eikon all securities (including equities, bonds, etc.) that have exposure to a given country, using Python. But I have no experience using Python to download anything from Eikon at all. Wondering if anyone can help me on this.

I also wanted to download all securities that have exposure to a given sector of a country, using Python.

Lastly, I wanted download all securities that have exposure to a given issuer name, say Chevron.

Any help will be appreciated! Thanks!!

Tagged:

Best Answer

  • aramyan.h
    aramyan.h admin
    Answer ✓

    Hi @jeremie.zhou ,


    You can do that using Search capabilities of RD Libraries for Python, please check the quick start and examples here.

    As for the search functions this and also this articles is going to be very useful. Additionally you can use the Advanced Search app from LSEG Workspace to filter the companies and the export the python query for a programatic access. Click on Export query below and then select Codebook to get the Python code:

    screenshot-2023-12-15-at-134216.png

    Hope this will help you get started, feel free to let us know if you will have any issues using the functions.


    Best regards,

    Haykaz

Answers

Categories