I am trying to extract a time series of historical ratings of a company via the Python API access, b

Radeesh

I am trying to extract a time series of historical ratings of a company via the Python API access, but I cannot find the suitable input or function to make it work. With the attached code, I only get one row of a rating, but not all historical ratings.

Jirapongse

@Radeesh

Thank you for reaching out to us.

This could be a content related question. I got the same output when pulling data through the following formula in the Workspace Excel.

=RDP.Data("AAPL.O","TR.IssuerRating;TR.IssuerRating.Date;TR.IssuerRating.RatingSourceDescription;TR.FIssuerRating;TR.FIssuerRating.Date;TR.FiIssuerMoodysLongRating;TR.FiIssuerMoodysLongRating.Date;TR.FiIssuerFitchLongRating;TR.FiIssuerFitchLongRating.Date","Frq=D SDate=2000-01-01 EDate=2026-07-05 CH=Fd RH=IN",B2)

Please contact the Workspace Excel support team directly to verify the formula and content. Then, please share the formula that can be used to pull the required data. After that, I can convert it to Python code. Otherwise, you can also refer to this How to Convert the =@RDP.Data Excel Function into Code Using the LSEG Data Library for Python article.