In the space to enter the address, enter the site which you usually use to monitor stock price (Here I use cnnmoney.com) and click the OK button. Enter the symbols you want to track separated by commas (if more than one) and click the Search button. You will get a window like this to choose the location where you want to insert the data. Click OK and your screen will look like this: Step 6.Now you will get a screen like this if you have entered AAPL, GOOG in the search textbox: You could find arrows in yellow boxes at different locations. Click the specific arrow which is shown just next to the information you want. Go to Data (in the main menu) and click Refresh All (from the Connections group), whenever you want to get the latest stock details.
In the Save As dialog box, navigate to the folder you want, type a name for the file in the File Name box, like Fund Quote, and click Save.5.
Now you have to add the ticker symbol as a parameter to the saved Web query.
In Windows Explorer, right-click the saved Web query file (Fund in this example) and choose Edit with Notepad from the shortcut menu.6.
Finance mutual fund quote page for the Vanguard 500 Index fund (ticker VFINX), so the URL in the Address box is .
If you don’t see yellow boxes in the browser, click the Show Icons button on the New Web Query toolbar.7. To import the data to another location on the worksheet, type the cell address.
In the Import Data dialog box, select Existing worksheet to import the data into the current worksheet. For the Existing worksheet option, type the cell address for the upper-left cell where you want the data imported. In this example, the label for the box is Enter ticker symbol and you choose the B1 cell. Turn on the check box for Use This Value/Reference for Future Refreshes. If you want the Web query to retrieve new values automatically when you enter a new ticker symbol, check the Refresh automatically when cell value changes check box. If Microsoft resources don’t do the trick, try You Tube.