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
5 0 0 1

ISIN and RIC codes for Rights Issues

I am studying capital increases through subscription rights, and I have obtained data for many of them through Screener. However, I need to find the ISIN code and the RIC associated with those subscription rights and, so far, I have not found any way to obtain it through any API.

For example, I put the case of the capital increase made by the Spanish company “IBI Lion Socimi SA” in the year 2023. I know the RIC (YIBI.MC) and the ISIN (ES0105633004) of the company, as well as the PermID of the process (5018383). I need to find the way to obtain the ISIN and/or the RIC of the subscription rights which, for this particular case, I know are YIBI_r.MC^I23 and ES0605633926, respectively.

I know this can be obtained by manually searching one by one, but the volume of processes I work with makes it not feasible to do it this way. I have tried using the "get_symbology" function, but I have been able to verify that, in this case, none of the RICs associated to the ISIN of the company match the one I need.

Specifically, I would like to know how to perform this procedure to obtain this data using the Eikon API in Python3. My intention is to obtain the price series of these subscription rights during the period in which they were listed on the markets.

I hope you can help me with this problem. If you need any additional information, please do not hesitate to ask for it.

#contentpython apiricsisinissue
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.

Upvotes
Accepted
1.4k 5 3 6

Hi @uva39

I think that if you use rd library and the search capabilites you may be able to get the rights issued for a selected equity if that is what you are looking for.

import refinitiv.data as rd
from refinitiv.data.content import search
rd.open_session()

response = search.Definition(
    filter = "RCSAssetCategoryLeaf eq 'Right' and PrimaryRIC eq 'YIBI.MC'",
    select = "RIC,IssueISIN").get_data() 
response.data.df
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.

Upvotes
17.2k 82 39 63

Hi @uva39

You may be able to use the Search API within Python to acquire this information. While I was able to capture some details, I was not able to filter down to capture a unique value. The Search ecosystem is quite rich and provides a lot of fields that may produce the desired results, however, this will require a content expert to step in.

I would suggest you reach out the helpdesk and specifically ask how to retrieve this information within Search. Or even more general, whether such information can be acquired by our data services given your input requirements. They will bring in a content specialist.

Hope this helps.

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.

Upvotes
5 0 0 1

With these answers, for now I have a solution to move forward with.

Thank you very much!

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.