Download and Keep Track of Stocks in Excel 2007

This article was written by MysticGeek, a tech blogger at the How-To Geek Blogs.

Microsoft Excel is used by companies and individuals to keep track of and compute virtually anything that requires numbers. If you are computing financial symbols, did you know there’s a way to have Excel automatically update those values online?

You can use smart tags in Excel to keep track of your stock quotes.  (Keep in mind you do need an Internet connection for this).  With this feature Excel will connect to MSN Money Central to download the information.

First we need to enable the smart cell feature by clicking the Office Button \ Excel Options \ Proofing \ AutoCorrect Options and click on the Smart Tags tab. Make sure and place a check next to Financial Symbol.  Click OK twice to get back to your worksheet.

download-and-keep-track-of-stocks-in-excel-2007 photo 1

Now that smart tags are enabled all we need to do is enter in our favorite stock symbol using all capital letters (in this instance I am using Microsoft).  Now hover the mouse over the lower left corner of the cell until the smart tag appears and click.  Select Insert refreshable stock price.

download-and-keep-track-of-stocks-in-excel-2007 photo 2

Now select where you would like the starting cell or you can also choose a new work sheet.  Click OK.

download-and-keep-track-of-stocks-in-excel-2007 photo 3 

Excel will go retrieve the information regarding the stock from MSN Money Central.  This will also include hyperlinks to additional information which will open in a separate browser.

download-and-keep-track-of-stocks-in-excel-2007 photo 4

Is this a feature you’d actually use?

More stories

Quick Tip Faster Use Of Mouse

Although I am not a Keyboard Ninja I still like to navigate quickly through Windows.  You can make your mousing more efficient using the snap to option which is inherent to XP.  This also works with Vista although getting to this setting is obviously different.

Make the Mouse Pointer Stay Away from What You’re Typing

If your mouse pointer seems to constantly get in the way while you are typing, you aren’t alone… you click in the middle of some text and start typing to insert more, but the cursor stays in the way. There’s a tiny utility called MouseAway that will solve this problem for you… it’s not new, but it

Funny Only To A Geek

I have heard and seen many funny situations in my IT career but today was the best one I have heard in a long time. A person referred to the asterisk key on their keyboard as “The Snowflake Key”. LMAO doesn’t do the 20 minutes of laughing I did justice.

Save Pages for Later With Reading List Extension for Firefox

I spend an enormous amount of time browsing the web looking for new ideas to write about, so one of the biggest problems for me is tagging articles for more careful reading later. Also, I’m sure any moment I’m going to reach a page that says “You’ve reached the end of the internet, now go outside”.

Unofficial Windows XP Themes Created by Microsoft

Anybody who has ever tried to change the theme in Windows will already know that you have to hack the uxtheme file in order to install themes into XP that aren’t digitally signed by Microsoft. If you would rather not or are unable to patch your system you might be interested in these unofficial

XP: Adjust Screen Flickering On CRT Monitors

Let’s face it … CRT monitors are still out there in the office environment.  Where I work we are slowly phasing them out as our budget allows.  The other day I was troubleshooting an issue with an older computer with a CRT monitor and when I looked at it I almost got sick from the flickering

Expand the Add Bookmark Dialog in Firefox by Default

If you are reading this article you are probably annoyed that every single time you add a bookmark in Firefox you have to click on the expand button to show the folder list before you can actually locate the folder to put the bookmark in.

Create Shortcut Icon to Disable / Enable the Screensaver

How many times have you been watching a long video on your computer and had the screensaver come on? Then you play the game of trying to jiggle the mouse every certain number of minutes to make sure it doesn’t happen again…  seems like it would be easier to have a really quick way to disable the

WINAMP 10th Anniversary Edition

After a buddy of mine pestered me enough about Winamp I finally decided to take the 10th Anniversary Edition for a test run. Previous versions of Winamp never impressed me much. I hate having to configure tons of worthless features in a player. Also, I have never liked inviting intrusive