Computertim Technologies - free computer training, tips, and support



Home Articles Help Shop Business Education

> Articles

Microsoft Windows
Microsoft Word
Microsoft Outlook
Microsoft Excel
Microsoft PowerPoint
Microsoft FrontPage
Palm OS
General Articles




Microsoft Excel

Print article

 E-mail this page

Insert a Stock Quote

Reader rating: 5 out of 10



Introduction

Do you need to reference stock market data in your worksheet? Need to keep track of your current portfolio value?

This How-To Article shows you how to insert an automatically updated stock quote into your worksheet.


Insert a Stock Quote

1. Click the cell where you would like to place the stock quote.

2. Click the "Data" menu, point to "Get External Data", and select "Run Saved Query...". (Note: If you are using Excel 2002, click "Data", point to "Import External Data", and select "Import Data".)

3. Click "Microsoft Investor Stock Quotes" and click "Get Data". (Note: If you are using Excel 2002, click "MSN MoneyCentral Investor Stock Quotes", and click "Open".)

4. Click OK.

5. In the text box, enter the symbol of the stock which you would like an updated quote for. (Example: MSFT)

6. Click OK.

7. Excel will now connect to the Internet and retrieve the stock quote you specified.

Rate this article:

Poor   1 - 2 - 3 - 4 - 5 - 6 - 7 - 8 - 9 - 10   Excellent


Books on Microsoft Excel




Featured articles

Choosing a Cell Phone and Rate Plan - General Articles

Stopping Unwanted E-mail - General Articles

Learn about Cookies - Microsoft Windows

HotSync Timeout Errors - Palm OS



Also from Computertim Technologies

Thoughts on Internet Advertising - an interactive opinion essay by Tim Rooney.

Post your opinions on technology and get free computer help in the forums.

Tired of AOL? Try Juno for half the price of AOL.

Shop for the best deals online at our shopping site.

Home  |  Articles  |  Help  |  Shop  |  Business  |  Education  |  Contact Us

Privacy Policy

Copyright 2003 Computertim Technologies.  All rights reserved.