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/xltra鈥?/a>
http://finance.groups.yahoo.com/group/sm鈥?/a>
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=financial鈥?/a>
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-鈥?/a>
After changing the ticker symbol, it will take 20-30 seconds to refresh the queries and get the data for that company.
Yes good work and thankyou for the info. I'm sure I will find it very useful.
Report Abuse
What is the best way to research hundreds of companies' financial statements?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.
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.What is the best way to research hundreds of companies' financial statements?
hoovers.com
No comments:
Post a Comment