Querying Web Sites
Web sites can be a rich source of information for your workbooks—particularly financial sites and sites that offer products for sale. By building a query to such a site, you can refresh the results whenever you want without having to use your browser.
CASE STUDY: Getting Financial Data
Suppose that you want to keep an eye on both the levels and volume of major financial market indices. Doing so can be a good way to tell whether the markets are starting to turn, whether up or down.
1. | Begin by selecting a worksheet cell that is not part of an existing external data range. If the active cell is part of such a range, the Import Data, the New Web Query, and the New Database Query menu items are disabled. |
2. | Choose Data, Import ... |
Get Managing Data with Microsoft® Excel 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.
