Analyst Ratings from MSN in Excel

Copper Contributor

How do I get analyst ratings from the MSN Stocks in an Excel Spreadsheet?

 

I'm not seeing Analyst Ratings as a value in the list of available fields:
https://support.office.com/en-us/article/how-to-write-formulas-that-reference-data-types-295d95e2-1e...

1 Reply
Hello,

The question is quite unclear... If you mean you want to import the MSN stocks into Excel, all you need to do is copy the URL of the MSN stock from their website and click on From Web in Excel. Next, you paste the URL and connect to import the specific you want