Getting a stock quote within a spreadsheet is now super simple with Google Docs and their built-in function called GOOGLEFINANCE(). Excel solutions are available but none are as simple or robust. Kudos to Google for implementing their API on a level that requires no more technical knowledge than using a built-in spreadsheet function much like SUM() or AVERAGE().
Google Finance Function Documentation
Excel solutions
1) MSN Money Data Provider: functionality has been mostly removed since 2008
2) Macro: Provided by Gummy-Stuff. I do not endorse or verify the content of this macro, use at your own risk.
Erik Hughes is an Investment Adviser Representative for Halvorson Research Associates, LLC
Market commentary and fundamental stock valuation available every on their website. Link below.
HRA Market Commentary
No comments:
Post a Comment