COMPUSTAT Xpressfeed
Xpressfeed (XPF) is a both a format and a delivery method of the Compustat database. The primary benefits of the XPF-based sets include the many new data items, the use of mnemonics instead of data numbers to refer to variables, and a more thorough, easy-to-search manual.
User's guides and Literature (To access users' guide and other literature on the database, you will be re-directed to the WRDS or publishers' website. For WRDS website, you will be prompted to login using your WRDS account. Request a WRDS account.)
| Dataset location: /data/data2/comp/sasdata/na/ | |||
| SAS libname: comp | |||
| SAS Dataset | Description | Primary Key field(s) | Group |
Company Fundamental Data (~/company) |
|||
| company | Company | gvkey | |
| co_adesind | Company Annual Descriptor | gvkey datadate indfmt datafmt consol popsrc | Annual |
| co_afnd1 | Company Annual Item (A-L) | gvkey datadate indfmt datafmt consol popsrc | |
| co_afnd2 | Company Annual Item (M-Z) | gvkey datadate indfmt datafmt consol popsrc | |
| co_afnddc1 | Company Annual Data Code (A-L) | gvkey datadate indfmt datafmt consol popsrc | |
| co_afnddc2 | Company Annual Data Code (M-Z) | gvkey datadate indfmt datafmt consol popsrc | |
| co_afntind1 | Company Annual Footnote (A-L) | gvkey datadate indfmt datafmt consol popsrc | |
| co_afntind2 | Company Annual Footnote (M-Z) | gvkey datadate indfmt datafmt consol popsrc | |
| co_idesind | Company Interim Descriptor | gvkey datadate indfmt consol popsrc fyr datafmt | Interim |
| co_ifndq | Company Interim Quarterly Item | gvkey datadate indfmt consol popsrc fyr datafmt | |
| co_ifntq | Company Interim Quarterly Footnote | gvkey datadate indfmt consol popsrc fyr datafmt | |
| co_ifndsa | Company Interim Semi-Annual Item | gvkey datadate indfmt consol popsrc fyr datafmt | |
| co_ifntsa | Company Interim Semi-Annual Footnote | gvkey datadate indfmt consol popsrc fyr datafmt | |
| co_ifndytd | Company Interim Year-to-Date Item | gvkey datadate indfmt consol popsrc fyr datafmt | |
| co_ifntytd | Company Interim Year-to-Date Footnote | gvkey datadate indfmt consol popsrc fyr datafmt | |
| co_aaudit | Company Auditor | gvkey datadate indfmt datafmt consol popsrc rank | Supplemental |
| co_adjfact | Company Adjustment Factors | gvkey effdate thrudate | |
| co_ainvval | Company Inventory Valuation | gvkey datadate indfmt datafmt consol popsrc rank | |
| co_indstrypres | Company Industry Presentation (prior) | gvkey datadate consol popsrc | |
| co_ipcd | Company Industry Presentation | gvkey datadate consol popsrc ipcd | |
| co_industry | Company Industry Classification | gvkey datadate consol popsrc | |
| co_amkt | Company Annual Market Data | gvkey datadate cfflag popsrc curcd | |
| co_fortune | Company Fortune 500 Information | gvkey datadate popsrc | |
| co_hgic | Company GICS History | gvkey indtype indfrom | |
| co_mthly | Company Monthly | gvkey datadate | |
| co_offtitl | Officer Title Code | gvkey ofid ofcd | |
| co_iaudit | Company Interim Auditor | gvkey datadate indfmt consol popsrc fyr datafmt rank | |
| co_imkt | Company Interim Market Data | gvkey datadate cfflag popsrc curcd yem | |
| co_aanotes | Analyst Notes -Annual | gvkey datadate mnemonic sequence | Analyst Notes |
| co_qanotes | Analyst Notes -Quarterly | gvkey datadate mnemonic sequence | |
| co_filedate | Filing Date | gvkey datadate consol popsrc srctype | |
| co_srcdate | Source Filing Date | gvkey datadate srctype | |
Security Data (~/security) |
|||
| security | Security | gvkey iid | |
| sec_mth | Security Monthly Descriptor | gvkey iid datadate | |
| sec_mthdiv | Security Monthly Dividend | gvkey iid datadate | |
| sec_mthprc | Security Monthly Item | gvkey iid datadate | |
| sec_mthspt | Security Monthly Stock Split | gvkey iid datadate | |
| sec_divid | Security Dividend | gvkey iid datadate curcddv | |
| sec_dprc | Security Daily Price | gvkey iid datadate curcdd | |
| sec_mdivfn | Security Monthly Dividend Fn | gvkey iid datadate dataitem | |
| sec_msptfn | Security Monthly Stock Split Fn | gvkey iid datadate dataitem | |
| sec_spind | Security SP Index | gvkey iid datadate | |
| sec_split | Security Stock Split | gvkey iid datadate | |
Bank Data (~/bank) |
|||
| bank_afnddc | Company Annual Data Codes(Bank) | gvkey datadate | |
| bank_afndfn | Company Annual Footnote(Bank) | gvkey datadate | |
| bank_ann | Company Annual Descriptor(Bank) | gvkey datadate | |
| bank_annfund | Company Annual Item(Bank) | gvkey datadate | |
| bank_qfnddc | Company Quarterly Data Codes(Bank) | gvkey datadate | |
| bank_qfndfn | Company Quarterly Footnote(Bank) | gvkey datadate | |
| bank_qtr | Company Quarterly Descriptor(Bank) | gvkey datadate | |
| bank_qtrfund | Company Quarterly Item(Bank) | gvkey datadate | |
| bcompany | Company (Bank) | gvkey | |
Currency Data (~/currency) |
|||
| currency | Currency | isocurcd | |
Economic Data (~/economy) |
|||
| ecind_mth | Economic Indicator Monthly | econiso datadate | |
| exrt_dly | Exchange Rate Daily | tocurd datadate | |
| exrt_mth | Exchange Rate Monthly | tocurm datadate | |
Index Data (~/index) |
|||
| idx_ann | Index Annual | gvkeyx datadate | |
| idx_anndes | Index Annual Descriptor | gvkeyx datadate | |
| idx_qrt | Index Quarterly | gvkeyx datadate | |
| idx_qrtdes | Index Quarterly Descriptor | gvkeyx datadate | |
| idx_mth | Index Monthly | gvkeyx datadate | |
| idx_daily | Index Daily | gvkeyx datadate | |
| idx_index | Indices | gvkeyx | |
| idxm_index | Monthly North American Index | gvkeyx | |
| idxm_mth | Monthly North American Index Item | gvkeyx datadate | |
| idxcst_his | Index Constituent History | gvkey iid gvkeyx from | |
| spidx_cst | SP Index Constituent Descriptors | gvkey iid datadate indexid | |
| spind | SP Index | gvkey | |
| spind_dly | SP Index Daily | gvkey datadate | |
| spind_mth | SP Index Monthly | gvkey datadate | |
Industry-Specific Data (~/industry) |
|||
| aco_indsta | Industry-Specific Annual Item | gvkey datadate indfmt datafmt consol popsrc | |
| aco_indstq | Industry-Specific Quarterly Item | gvkey datadate indfmt consol popsrc fyr datafmt | |
| aco_indstytd | Industry-Specific YTD Item | gvkey datadate indfmt consol popsrc fyr datafmt | |
| aco_indfnta | Industry-Specific Annual Footnote | gvkey datadate indfmt datafmt consol popsrc | |
| aco_indfntq | Industry-Specific Quarterly Footnote | gvkey datadate indfmt consol popsrc fyr datafmt | |
| aco_indfntytd | Industry-Specific YTD Footnote | gvkey datadate indfmt consol popsrc fyr datafmt | |
Insider Data (~/insider) |
|||
| it_mbuysell | Insider Transaction | gvkey iid datadate ittrntyp itrank | |
| it_msummary | Insider Summary Data | gvkey iid datadate | |
| it_r_rltn | Insider Relationship Reference Data | itrltncd | |
Institutional Ownership Data (~/institution) |
|||
| io_qaggregate | Institutional Ownership Aggregate Data | gvkey iid datadate | |
| io_qbuysell | Institutional Ownership Transaction | gvkey iid datadate iotrntyp iorank | |
| io_qchanges | Institutional Ownership Changes | gvkey iid datadate iocrank | |
| io_qholders | Institutional Ownership Top Holders | gvkey iid datadate iohrank | |
Pension Data (~/pension) |
|||
| aco_pnfnda | Pension Annual Item | gvkey datadate indfmt datafmt consol popsrc | |
| aco_pnfndq | Pension Quarterly Item | gvkey datadate indfmt consol popsrc fyr datafmt | |
| aco_pnfndytd | Pension YTD Item | gvkey datadate indfmt consol popsrc fyr datafmt | |
| aco_pnfnta | Pension Annual Footnote | gvkey datadate indfmt datafmt consol popsrc | |
S&P Ratings (~/rating) |
|||
| adsprate | Company S&P Credit Ratings | gvkey datadate | |
| Segment Data (segment) | |||
| seg_afndfn | Segment Annual Footnote | gvkey datadate srcdate stype sid | |
| seg_ann | Segment Annual Descriptor | gvkey datadate | |
| seg_annfund | Segment Annual Item | gvkey datadate srcdate stype sid | |
| seg_customer | Segment Customer | gvkey datadate cid | |
| seg_geo | Segment Geographic Code | gvkey datadate stype sic gareag | |
| seg_naics | Segment NAICS | gvkey datadate stype sic ranks | |
| seg_product | Segment Product | gvkey datadate pdid | |
| seg_type | Segment Detail | gvkey datadate stype sid | |
Utility Data (~/utility) |
|||
| ucompany | Company (Utility) | gvkey | |
| util_afnddc | Company Annual Data Codes (Utility) | gvkey datadate | |
| util_afndfn | Company Annual Footnote (Utility) | gvkey datadate | |
| util_ann | Company Annual Descriptor (Utility) | gvkey datadate | |
| util_annfund | Company Annual Item (Utility) | gvkey datadate | |
| util_qfnddc | Company Quarterly Data Codes (Utility) | gvkey datadate | |
| util_qfndfn | Company Quarterly Footnote (Utility) | gvkey datadate | |
| util_qtr | Company Quarterly Descriptor (Utility) | gvkey datadate | |
| util_qtrfund | Company Quarterly Item (Utility) | gvkey datadate | |
| util_rcase | Company Quarterly Rate Case Item (Utility) | gvkey datadate | |
