Microsoft® Excel® 2010: Data Analysis and Business Modeling

Chapter 39. Importing Data from the Internet

Questions answered in this chapter:

• Yahoo Finance provides analyst ratings (buy, sell, and hold) for stocks. How can I import this information into Excel?

• Is there a way I can download current stock prices into Excel?

We all know that the World Wide Web contains useful data on just about everything. However, you can’t really do any sort of analysis of this data while it’s on the Web. You need to import the data into Microsoft Excel, which you can do very easily. After you open the website where the data you want is located, copy the URL to the Clipboard, and then open an Excel worksheet. On the Data tab, in the Get External Data group, click From Web. When the New Web Query dialog box appears, paste ...