Difference between revisions of "Data Dictionaries"
Jump to navigation
Jump to search
imported>Ed |
|||
| (2 intermediate revisions by one other user not shown) | |||
| Line 3: | Line 3: | ||
==WRDS== | ==WRDS== | ||
| − | The following [http://wrds.wharton.upenn.edu/ WRDS] data dictionaries are available: | + | WRDS has now changed its variable names somewhat, but these old (legacy) data dictionaries may still be of some use. The following legacy [http://wrds.wharton.upenn.edu/ WRDS] data dictionaries are available: |
#[http://www.edegan.com/repository/DD-COMPUSTATBalanceSheetExtracts.txt DD-COMPUSTATBalanceSheetExtracts.txt] | #[http://www.edegan.com/repository/DD-COMPUSTATBalanceSheetExtracts.txt DD-COMPUSTATBalanceSheetExtracts.txt] | ||
#[http://www.edegan.com/repository/DD-COMPUSTATIndustrialAnnual.txt DD-COMPUSTATIndustrialAnnual.txt] | #[http://www.edegan.com/repository/DD-COMPUSTATIndustrialAnnual.txt DD-COMPUSTATIndustrialAnnual.txt] | ||
| Line 12: | Line 12: | ||
Users should also consult the [http://wrds.wharton.upenn.edu/ds/comp/manuals/ftp.shtml WRDS COMPUSTAT User Manual] | Users should also consult the [http://wrds.wharton.upenn.edu/ds/comp/manuals/ftp.shtml WRDS COMPUSTAT User Manual] | ||
| + | ==Thomson SDC== | ||
| + | |||
| + | It appears that the Thomson SDC Platinum system may be being phased out by Thomson. However, the following data dictionaries are an invaluable source while access is still available (users should note that Thomson often randomly remove variables from their system and requesting a (now) non-existent variable will cause your query to crash): | ||
#[http://www.edegan.com/repository/DD-ThomsonSDCGNI-AttributeCodeExplanations.txt DD-ThomsonSDCGNI-AttributeCodeExplanations.txt] | #[http://www.edegan.com/repository/DD-ThomsonSDCGNI-AttributeCodeExplanations.txt DD-ThomsonSDCGNI-AttributeCodeExplanations.txt] | ||
#[http://www.edegan.com/repository/DD-ThomsonSDCGNI.txt DD-ThomsonSDCGNI.txt] | #[http://www.edegan.com/repository/DD-ThomsonSDCGNI.txt DD-ThomsonSDCGNI.txt] | ||
| Line 26: | Line 29: | ||
#[http://www.edegan.com/repository/DD-ThomsonVEIPOs-AttributeCodeExplanations.txt DD-ThomsonVEIPOs-AttributeCodeExplanations.txt] | #[http://www.edegan.com/repository/DD-ThomsonVEIPOs-AttributeCodeExplanations.txt DD-ThomsonVEIPOs-AttributeCodeExplanations.txt] | ||
#[http://www.edegan.com/repository/DD-ThomsonVEIPOs.txt DD-ThomsonVEIPOs.txt] | #[http://www.edegan.com/repository/DD-ThomsonVEIPOs.txt DD-ThomsonVEIPOs.txt] | ||
| − | #[http://www.edegan.com/repository/DD-ThomsonVEPortfolioCompanies-AttributeCodeExplanations.txt DD- | + | #[http://www.edegan.com/repository/DD-ThomsonVEPortfolioCompanies-AttributeCodeExplanations.txt DD-ThomsonVEPortfolioCompanies-AttributeCodeExplanations.txt] |
#[http://www.edegan.com/repository/DD-ThomsonVEPortfolioCompanies.txt DD-ThomsonVEPortfolioCompanies.txt] | #[http://www.edegan.com/repository/DD-ThomsonVEPortfolioCompanies.txt DD-ThomsonVEPortfolioCompanies.txt] | ||
Latest revision as of 18:54, 1 August 2009
Data dictionaries are plain text files listing variables and their labels, as well as values for certain fields. They are an invaluable reference source, as is a summary of the data available in the various sources.
WRDS
WRDS has now changed its variable names somewhat, but these old (legacy) data dictionaries may still be of some use. The following legacy WRDS data dictionaries are available:
- DD-COMPUSTATBalanceSheetExtracts.txt
- DD-COMPUSTATIndustrialAnnual.txt
- DD-CRSPDailyPrices.txt
- DD-COMPUSTATCountryCodes.txt
- DD-COMPUSTATStateCodes.txt
Users should also consult the WRDS COMPUSTAT User Manual
Thomson SDC
It appears that the Thomson SDC Platinum system may be being phased out by Thomson. However, the following data dictionaries are an invaluable source while access is still available (users should note that Thomson often randomly remove variables from their system and requesting a (now) non-existent variable will cause your query to crash):
- DD-ThomsonSDCGNI-AttributeCodeExplanations.txt
- DD-ThomsonSDCGNI.txt
- DD-ThomsonSDCMA-AttributeCodeExplanations.txt
- DD-ThomsonSDCMA.txt
- DD-ThomsonVECommitments-AttributeCodeExplanations.txt
- DD-ThomsonVECommitments.txt
- DD-ThomsonVEDisbursements-AttributeCodeExplanations.txt
- DD-ThomsonVEDisbursements.txt
- DD-ThomsonVEFirms-AttributeCodeExplanations.txt
- DD-ThomsonVEFirms.txt
- DD-ThomsonVEFunds-AttributeCodeExplanations.txt
- DD-ThomsonVEFunds.txt
- DD-ThomsonVEIPOs-AttributeCodeExplanations.txt
- DD-ThomsonVEIPOs.txt
- DD-ThomsonVEPortfolioCompanies-AttributeCodeExplanations.txt
- DD-ThomsonVEPortfolioCompanies.txt
