Bookmark and Share

Enter your email address:

Delivered by FeedBurner



Home Page













Subscribe here
Add to My Yahoo!
This page is powered by Blogger. Isn't yours?

Host your Web site with PureHost!


eXTReMe Tracker
  Web http://www.klippert.com



  Saturday, October 11, 2008 – Permalink –

Stock Answer

Built in service



You can easily insert an automatically updated stock quote for a specific company in a spreadsheet.

Here are the instructions:

  1. On the Tools menu, click AutoCorrect options.
    (Use the Office button and Excel Options in 2007)
  2. Click the Smart Tags tab and place a check beside Label data with smart tags.
  3. Click OK.
  4. Type in a Stock symbol (such as MSFT) in a cell.
    (The symbol must be in all caps)
  5. Click outside of the cell.
  6. Place your mouse cursor over the purple triangle in the lower-right corner of the cell.
    Click the arrow.
  7. Click Insert refreshable stock price.
  8. Select whether to insert the stock price on a new worksheet or in a specific area on your current worksheet.


You can refresh a stock quote price at any time by right clicking anywhere within your worksheet and selecting Data Range Properties. Enter a value for how often the stock quote price should be refreshed.




[Edited entry from 7/8/2005]




See all Topics

Labels:


<Doug Klippert@ 4:16 AM

Comments: Post a Comment

Links to this post:

Create a Link