Thursday, April 23, 2009

Compustat

You can use COMPUSTAT on WRDS to get hundreds of financial variables. Here's how to do it.
http://WRDS1.wharton.upenn.edu
Use your WHARTON ID to logon (not your PennKey)
Choose COMPUSTAT NORTH AMERICA From the left column
Under FTP (Legacy)
choose Industrial Annual
1. Date range
Change as needed
2. Search
I searched by GVKEY (5180)(Glaxo holdings LLP)
You find this through Code Lookup
3. Variables
Company name etc.
Data Items
I picked the first 6 data items Cash, Receivables, Inventory, Current Assets
current Liabilities, total assets. These won't appear as labels in the printout.

Output Format (Comma delimited)

Submit Report
It will take a few second for the report URL to appear, click on it
to download or display report. (Thanks Mike Halperin)

No comments:

Post a Comment