I'm trying to retrieve the most recent bond ratings from Moody's, S&P, and Fitch from a list of tickers.
I convert the list of tickers to both ISIN and RICs with this code that seems to work:
I tried throwing the whole list of codes as either RICa rics = codes['RIC'].tolist() or ISIN as isin = codes['IssueISIN'].tolist() but got an exception that it was "Unable to resolve all requested identifiers". So I tried looping through each code individually but I'm still getting the same exception.
Using the ISIN, the code looks like this:
Any ideas? Same results with RICs. Is the conversion off? Am I requesting the ratings incorrectly? At a loss here. Thanks.