Live data from Hacker News

Ask HN: Where can I find free/cheap financial data?

news.ycombinator.com

1–10 of 11 posts

Ask HN: Where can I find free/cheap financial data?

#1
I am doing a side project on investing need financial statements: balance sheets, income statements, cash flows. The SEC's EDGAR tool is terrible and Google & Yahoo have a lot of companies where they just don't have the info posted. I would only need the NYSE data for yearly/quarterly reports.

I've scraped Google Finance for info but I have a lot of invalid rows in my database.

Thanks all.

Re: Ask HN: Where can I find free/cheap financial data?

#2
http://code.google.com/apis/finance/ http://kottke.org/09/06/online-financial-data-apis-and-resou... http://stackoverflow.com/questions/417453/best-most-comprehe...

(edit: Added the link for Google's finance api because I'm not sure if you are referring to their api or finance site when you say 'scrape')

Re: Ask HN: Where can I find free/cheap financial data?

#3
I've been working on a closely related project for about a year now. It's not worth your time to attempt scraping. The best advice I can give you is that any financial data source worth consuming is going to cost money, you might as well pay for it and focus your energy/time on building the product itself. The free data sources are unreliable and stale and scraping legit sites is problematic because of throttling issues.

Re: Ask HN: Where can I find free/cheap financial data?

#6
post #3

I've been working on a closely related project for about a year now. It's not worth your time to attempt scraping. The best advice I can give you is that any financial data source worth consuming is going to cost money, you might as well pay for it and focus your energy/time on building the product itself. The free data sources are unreliable and stale and scraping legit sites is problematic because of throttling iss…

I agree. The quality of data is always going to be an issue and even the paid data has several problems. Be prepared to write a lot of code to catch these data errors.

Re: Ask HN: Where can I find free/cheap financial data?

#8
The SEC has a new XML-like data system for financial information called XBRL: http://xbrl.sec.gov/

Not all companies are required to report in this format at this time but I believe over the next year most Fortune 500 companies will be required to provide their data in this format.

Re: Ask HN: Where can I find free/cheap financial data?

#9
post #8

The SEC has a new XML-like data system for financial information called XBRL: http://xbrl.sec.gov/ Not all companies are required to report in this format at this time but I believe over the next year most Fortune 500 companies will be required to provide their data in this format.

That's great information. Sounds like it's voluntary at this point but required by January 1st, 2011.

Re: Ask HN: Where can I find free/cheap financial data?

#10
I've done a lot of scraping and parsing. Your best option is to fetch the SEC's RSS, then fetch the hard-to-parse XML/Free-form and parse it. XBRL is great in its own regard, but it's very difficult to relate XBRL fields with non-XBRL filings. You would do well to separate the two results.

SEC form 4 filings are in XBRL dating back to Jan 1, 2004 for every company. There are well over 1,000,000 forms filed between then and now... I know, I have them all locally right now.

You can scrape Google's Financial pages, obviously, and you can even get 2-minute data from a JSON "_5d" variable.

You can get fundamentals data from nasdaq pretty easily, too. Scraping it is a little difficult, but you can go 120 quarters back for many companies, and 5 years back for annual data.

I have a financial statements database populated with nasdaq scraped data right now. They update within a week or so after it's published to the SEC. You'll always be behind the curve, but you will have good information, and it is good information, albeit incomplete (missing things like the number of shares outstanding).

Post reply on HN