A Web Query is a simple way of retrieving up to date financial data into Excel from the Netquote website.
Q. What type of data is available to my by Netquote that I can call directly into Excel?
A. Netquote provides various Web Queries for you. From Dividend History to the Full Market Tables, check the Query downloads to the left to see what is available.
To use the Netquote Web Queries (subscribers only) simply download the Queries you want and save to the 'My Data Sources' folder located in your 'My Documents' area of your computer.
Web queries are saved in text files with .iqy extensions.
Netquote Intraday Market Web Query
- Open Microsoft Excel and on the Data menu, point to Import External Data, and then click Import Data.
- Locate the folder where your query file is stored in the Look in box.
- Select the Web query you want to run.
- Click Open.
In the Import Data dialog box, do one of the following:
To return the data from the Web page to the selected worksheet, click Existing worksheet. On your worksheet, click the cell where you want to place the upper-left corner of the external data range (external data range: A range of data that is brought into a worksheet but that originates outside of Excel, such as in a database or text file. In Excel, you can format the data or use it in calculations as you would any other data.), and then click OK.
To return the data to a new worksheet, click New worksheet, and then click OK. Excel adds a new worksheet to your workbook and automatically starts the external data range in the upper-left corner of the new worksheet.
- If prompted, enter parameters for the query. If you don't know what the valid parameters are, ask the person who created the query.
Excel runs the query. A spinning refresh icon appears in the status bar (status bar: A horizontal bar at the bottom of the screen that displays information about the current condition of the program, such as the status of items in the window, the progress of the current task, or information about the selected item.) to indicate that the query is running. To check the status of the query, double-click the refresh icon.
Netquote Market Fundamentals Query
Netquote Dividend Web Query
Netquote Fundamentals Web Query