Gathering Financial Data from the Internet

I. Current Data

1. Price, EPS, Dividend, from Yahoo Finance for up to about 30 tickers at a time. Easily programmed into Excel VBA:

http://www.gummy-stuff.org/Yahoo-data.htm

2. The Motley Fool Screener data can be downloaded as a csv file. This can be used as a lookup table for the excel spreadsheet using vertical search, or if someone gets more sophisticated, excel vba could query for this information. Current problem: office 2003 can't load file names longer than 256 characters, and the csv query if quite lengthy.

II. Historical Data

Dividends

Infinite history, one ticker at a time:

http://finance.yahoo.com/q/hp?s=GE&a=00&b=2&c=1962&d=02&e=1&f=2010&g=v

Earnings

Yahoo

Provides a couple of years or quarters of data, one ticker at a time.

http://finance.yahoo.com/q/is?s=vz

advfn:

Data back to 1994, but a major pain to retrieve.

http://ih.advfn.com/p.php?pid=financials&symbol=ANAD&btn=annual_reports&start_date=0&annual_reports=1

http://www.advfn.com/p.php?pid=financials&btn=s_ok&mode=quarterly_reports&symbol=jnj&s_ok=OK&istart_date=56

NASDAQ

3 years at a time, seems to go back a long way. Not clear how to scrape due to URL.

http://www.nasdaq.com/symbol/aapl/revenue-eps#.UTzH_1fcN8E

ycharts

Free for 5 years historical, relatively easy to retrieve.

http://ycharts.com/companies/AAPL/eps

http://ycharts.com/companies/HPQ/historical_data/eps?start_month=2&start_day=4&start_year=1990&end_month=2&end_day=4&end_year=2012

Wharton Research Data Services (WRDS)

Academic source. Allows database queries (think Matlab, MySQL, etc.). Requires license.

https://wrds-web.wharton.upenn.edu/wrds/

http://www.mathworks.com/matlabcentral/fileexchange/12027

http://www.mathworks.com/products/database/

http://desk.stinkpot.org:8080/tricks/index.php/2006/02/how-to-get-matlab-to-talk-to-mysql/

http://www.mathworks.com/matlabcentral/fileexchange/17897 & http://sourceforge.net/projects/mym/

III. Analysis

Excellent site with dividend growth analysis:

http://www.dividend-growth-stocks.com

http://www.dividendgrowthinvestor.com

IV. References

A bit outdated, but worth a look:

http://pages.stern.nyu.edu/~adamodar/New_Home_Page/data.html