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
Then enter the site’s URL at the next window and select the table that has the quote you want.
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.
RSS Feed
It really helpful … I don’t have to punch in the whole list of my invested stocks anymore … thanks
в итоге: мне понравилось…
I want to just say thanks for posting.
This spreadsheet is a better solution (and more flexible) than the webs query solution: http://investexcel.net/218/importing-historical-stock-prices-from-yahoo-into-excel/
It uses VBA to import the data