Chapter 34. Importing Data from the Internet
The MSN Money Central Web site 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, we can’t really do any sort of analysis of this data while it’s on the Web. We need to import the data into Microsoft Office Excel. Excel 2007 makes importing data from the Web very easy. After you find the URL where the data you want is located, copy the URL to the Windows Clipboard. Then open an Excel worksheet and on the Data tab, in the Get External Data group, click From Web. When the New Web Query dialog box appears, ...
Get Microsoft® Office Excel® 2007: Data Analysis and Business Modeling, Second Edition 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.
