Skip to main content
This Board Has Moved

This board has been migrated to our new platform! Check out the new home page at or click below to go directly to the new Board on the new site.

Go to the New Site
Message Font: Serif | Sans-Serif
No. of Recommendations: 4
I've never been called lazy, but is that the case here? I am well versed in Excel and automating spreadsheets, but not to the point of entering a symbol and having all the numbers flow into the sheet (from where?) which would be pretty cool.

Since it was mentioned, the SMF (Stock Market Functions) add-in can be found at:

I am the author. It is a free open-source add-in for EXCEL that gathers information from the web for you. I just recently uploaded templates that include all of the financial statements data from Yahoo and MSN. All you need to do is enter a ticker symbol on the worksheet, and it will go out and grab all of the individual data items. The formulas should be easily portable to another workbook if you want to create your own custom information sheet, or comparison sheet.

The add-in, documentation, and a number of templates can be found in the files area.
Print the post  


When Life Gives You Lemons
We all have had hardships and made poor decisions. The important thing is how we respond and grow. Read the story of a Fool who started from nothing, and looks to gain everything.
Contact Us
Contact Customer Service and other Fool departments here.
What was Your Dumbest Investment?
Share it with us -- and learn from others' stories of flubs.
Work for Fools?
Winner of the Washingtonian great places to work, and Glassdoor #1 Company to Work For 2015! Have access to all of TMF's online and email products for FREE, and be paid for your contributions to TMF! Click the link and start your Fool career.