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

jeremie.zhou

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

aramyan.h

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:

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