Monday, August 25, 2008

Stock Quote Reports in Excel

So, you want reports on your Stock Portfolio delivered into Excel, do you?

1) Select cell A1
2) Go to Data / Get External Data / Run Saved Queries,(this may differ slightly depending on Excel version), and choose Microsoft Investor Stock Quotes
3) Enter some stock symbols (eg. UTR, MSFT, GM, etc.) and click "OK"

Presto! In a few seconds, you will have all of the current data on your stocks!

No comments: