It asks you to ‘Enter Parameter Value’ and add stock quotes separated by a comma. Read: How to add a Stock Ticker to Windows Desktop.

You can even select the range of cells by just dragging the mouse over the cells and click on the “Ok” button. By default, it shows $A$1 (Cell ‘A1’) as the starting cell. It opens the “Import Data” popup and asks you where to put the data. Select the connection you have just added now and click on “Open” button or you can double click on the connection. Tap on the “Data” tab once again and click on “Existing Connections”. Check the option “Enable background refresh” and any other options as you require. Select “MSN Mone圜entral Investor Stock Quotes” and double click on it.Ĭlick on the “Properties” to open “Connection Properties” pop up.

Then, click on “Connections” which opens “Workbook Connections” and click on “Add” button. Open the Excel sheet and tap on the “Data” tab. I will take you through the steps to be followed to achieve this. You can use MSN Mone圜entral Investor Stock Quotes, the built-in connection of Excel, and pull the stock quotes. To fetch stock quotes in excel, you do not need to install any additional add-on to your excel sheet. So let us see how to get Stock Quotes in Excel. Apart from just using it for regular stuff, you can even pull or fetch stock quotes in excel. There are many built-in formulas and you can even create your own custom functions to extend the functionality. Excel functions make our job easy in minimizing the task we do.

We use it to keep track of tasks to be completed using color coding and people dealing with business, use it to keep track of products brought and sold and everyone uses it in some or the other way. Most of us use Microsoft Excel in our daily life in many ways.

Download stock quotes into excel 2007