I would like to do stock research on public companies using their financial statements on spreadsheet. I would like to downloand them to Excel for my investment research. Punching numbers by hand is hassle I need many companies. What is the best way?
2006-12-03 06:27:45 · 4 answers · asked by walker197010 1 in Business & Finance ➔ Investing
What I want to do is customized ratio analysis, for example sales volatility calculation, of multiple companies in the easiest way.
2006-12-03 13:00:09 · update #1
There are two Yahoo groups that can help you get a lot of information into EXCEL from the web:
http://tech.groups.yahoo.com/group/xltraders/
http://finance.groups.yahoo.com/group/smf_addin/
The first group has files in the library that use combinations of VBA and web queries to get information into EXCEL. The discussion board can also be very helpful in helping you find specific solutions.
The second one is my group. In the files area, you can find a free open-source EXCEL add-in, documentation, and templates that can grab information from the web using user-defined functions.
One good source for an enormous amount of quarterly and annual financial data is AdvFN. For example, on IBM:
http://www.advfn.com/p.php?pid=financials&symbol=IBM
Click on the "Annual Reports" and "Quarterly Reports" button for the detailed info. There is also a "data downloads" button on that page which can download a chunk of information as a CSV file, but you'll need to go through the free registration process first.
You can also set up web queries to place the annual and quarterly information directly into a spreadsheet. Here's an example of one I created for someone else:
http://ogres-crypt.com/iqy/advfn-annual-financial-query.xls
After changing the ticker symbol, it will take 20-30 seconds to refresh the queries and get the data for that company.
2006-12-03 13:04:49 · answer #1 · answered by Randy H 4 · 0⤊ 0⤋
Yahoo is quick and easy. You can create a portfolio and list all the stocks you're interested in. You can list them in a table with whichever columns you want to see. You can click on the idividual company names to see more details about any of them.
2006-12-03 20:53:47 · answer #2 · answered by Greg 2 · 0⤊ 0⤋
yahoo has a nice stock screener if you're interested in that. I don't think you can export data to a spreadsheet there though.
2006-12-03 17:20:19 · answer #3 · answered by scottrc5391 3 · 0⤊ 0⤋
hoovers.com
2006-12-03 14:36:03 · answer #4 · answered by CuriousHIC 2 · 0⤊ 0⤋