This Excel Add-In lets you take financial data from Yahoo Finance, Google Finance, MorningStar, Reuters etc straight into Excel. For example you want the market cap of MSFT from Yahoo Finance in your Excel spreadsheet. Just install the add-in and use the formula “=RCHGetElementNumber(“MSFT”, 941)”. Quote from the orginal post.
You can turbo charge you stock financial spreadsheets using an excellent and free Excel Stock Market Functions Add-in. You can download this great tool that lets you add data from MSN, Yahoo, Google, Reuters, ADVFN, Morningstar, and more directly into your Excel spreadsheet cells by joining the smf_addin group.
Note to download the add-in you have to join the associated Yahoo Group.
FT – DCF model
The Lex column from the Financial Times has an online DCF calculator / model. This is good for people that don’t want to build a model in Excel and are happy to plug in a few high level assumptions to generate a valuation.