How can I use the Refinitiv Python API (Workspace) to pull fund performance and holdings data for re

srinidhi

Query: The client has a question regarding Python API (Workspace). He wants to pull information that he currently all from refinitiv on excel but this time in a python environment as he needs to use it in collaboration with other data that he can not work with easily in excel.

Please find comments from client: So my main use case would be for reporting fund performance and holdings. I would need to make calls to the API on a Monthly, Quarterly and then ad-hoc basis as well.
The main datapoints I’d need to pull are prices on a particular date.
I’d then also like to pull CPI data as our fund benchmark is based on CPI.
I’d then like to pull the value of shares traded for a specific stock.
Daily Index returns.
Index constituents and weights.
PE, dividend yield, payout ratio, spot EBIT margin, 40y history of EBIT margins, 40 year history of Price to book ratio, 40 Year history of ROIC, spot Net debt/EBITDA

Jirapongse

@srinidhi

Thank you for reaching out to us.

The =@RDP.Data Workspace Excel formula can be easily converted into Python code that uses the LSEG Data Library for Python, as described in the article "How to Convert the =@RDP.Data Excel Function into Code Using the LSEG Data Library for Python."

In addition, clients can use the Data Item Browser to search for available fields and parameters. If further assistance is needed, they can contact the Workspace Excel Support Team directly through LSEG Support for guidance on identifying the appropriate fields and parameters.