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 the ...
Get Microsoft® Excel® 2010: Data Analysis and Business Modeling now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
