Convert bond RICs/ISIN symbols to Parent RIC (RIC of the Issuer) with Excel?

HoaiATCTT65A_

Using Green Bond Guide in Sustainability, I got a list of Bonds with bond RICs, bond ISIN and Issuers Name.

I am trying to download multiple companies' data (ROA%, Total Asset and Total debt percentage to total capital) through Screener. However, the the Porfolio import require Symbols/ Company RICs and PermID beside Issuers Name, which I can not find everything by hand. Is there a way to get a list of Issuers RICs/ Symbol tickers from >6000 bond ISIN/RIC through Excel or directly in Workspace?

Thank you very much!

Jirapongse

@HoaiATCTT65A_

Thank you for reaching out to us.

This forum is dedicated to software developers using LSEG APIs. For questions regarding the LSEG Workspace Excel, please contact the helpdesk support team directly via LSEG Support.

In addition, we provide the LSEG Data Libraries (Python, .NET, and Typescript) to programmatically access data. However, the moderators on this forum do not have deep expertise in every bit of content available through LSEG products, which is required to answer content questions such as this one.

The best resource for content questions is the Helpdesk support team, which can be reached by submitting queries through LSEG Support. The support team will either have the required content expertise ready available or can reach out to relevant content experts to get the answer for you.

You need to ask for the Excel formula, such as =RDP.Data, that can be used to retrieve the required data.

Then, we can help you converting that formula to code.