Import stock quotes using Excel

December 2, 2006

There are a lot of tools how there to manage your personal finance, but none seems as flexible and powerful as Excel.

In order to manage your stock portfolio with Excel we need to periodically update your stock quotes and that can be a hassle.

Wait no more, Excel 2003 has a feature called Web Query that’s just great to import stock quotes. Here’s how it works.

You find a site that has the quote you want (e.g. http://finance.yahoo.com/q?s=goog , for Google’s quote).

You open Excel and go to Data->Import External Data->New Web Query

Step 1

Then enter the site’s URL at the next window and select the table that has the quote you want.

Step 2

And you’re done, now you have the information on your spreadsheet and you can do whatever you want with it.

To refresh the Web Query, right click the Range and select “Refresh”. You can also edit the Range’s properties so that it is automatically refreshed.

Step 3

Advertisements