Creating and Using Web Queries
Chapter 7, “Ratio Analysis,” discussed a variety of indicators of a company's financial status. It did not go into detail about where to find those indicators or how best to get them into an Excel worksheet. This section shows you one good way.
A Web query is a special kind of query: it obtains data not from a database but from Web pages, which are usually constructed using Hypertext Markup Language (HTML) or one of its variants such as Extended Markup Language (XML). Web queries return data from the Web page directly to your Excel worksheet.
Required is Excel 2000 or 2002 and a Web connection. If you have those, you're ready to go.
1. | Choose Data, Import External Data, New Web Query. The New Web Query dialog ... |
Get Business Analysis with Microsoft® Excel, 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.
