I am doing some research to write a formula or VBA code that would fetch the data from the website that does not have API and requires authentication. I am trying to fetch the credit ratings data from S&P and Moody's for number of institutions without searching one by one.

URL: https://www.moodys.com/
URL: https://www.standardandpoors.com/

Credit ratings data of Amazon Inc., Google LLC etc.

For authentication, I have created a GMAIL account - [email protected] with password - developerstest1

Should you have any queries, please let me know.

Thank you
Roshan Shakya