How to Use Excel Add Ins for Stock Quotes

How to Use Excel Add Ins for Stock Quotes

excel add ins

You can use free Excel Add Ins for applications such as obtaining updated stock quotes. Use the steps below to save all the stock symbols you’re interested into a spreadsheet using an excel add in. You will then have a spreadsheet that you can use for tracking your investments with refreshable stock quotes from MSN Money.

Difficulty: Easy

Instructions

1.      Step 1

In order to use this Excel add in, make sure that you have Excel installed on the computer you are using.

2.      Step 2

Go to www.microsoft.com/downloads/ to get the MSN Money Stock Quotes Excel Add In. Look at the resources section towards the bottom of this web page for a link to the add-in download.

3.      Step 3

Pick your connection speed next to the “Estimated Download Time” and then click on download to install the Excel add-in onto your computer.

4.      Step 4

Once you have downloaded the excel add-in for stock quotes, open up a new Excel worksheet. Click on a cell where you would like to start adding stock quotes. Now click on Add-Ins (on the toolbar at the top of the page). Pick “Insert Stock Quotes”.

5.      Step 5

When the “Insert Stock Quotes” gui pops up, type in the symbol for the stock you’re interested in. In the properties section click on the different variables that you’re interested in and then click on “Add”. Click on “Ok” at the bottom of the pop up window. You should now see the updated stock quote information for the stock you picked.

6.      Step 6

To add another stock to your spreadsheet, click on a cell in the next row and follow the same process until you have a list of all the stocks that you want to keep up with. Save out the spreadsheet onto your computer.

7.      Step 7

To view updated stock information, open up your saved spreadsheet. Click on Add-Ins and “Update Quotes” to update your stock quote information.

Please do not print this email unless it is absolutely necessary.

The information contained in this electronic message and any attachments to this message are intended for the exclusive use of the addressee(s) and may contain proprietary, confidential or privileged information. If you are not the intended recipient, you should not disseminate, distribute or copy this e-mail. Please notify the sender immediately and destroy all copies of this message and any attachments.

WARNING: Computer viruses can be transmitted via email. The recipient should check this email and any attachments for the presence of viruses. The company accepts no liability for any damage caused by any virus transmitted by this email.

www.wipro.com