- WRDS Harvard Subscriptions
- WRDS Finding Historic Financials
- Demo
- WRDS Finding a Time Series of Stock Prices in CRSP
- WRDS Introduction to Compustat
- WRDS Finding a Time Series of Financial Data in Compustat
- WRDS Insider Data from Thomson Financial/Spectrum
- WRDS Institutional Holdings Data from Thomson Financial/Spectrum
- WRDS Introduction to CRSP Stock Price Data
- WRDS Locating Historical S&P 500 Constituents
WRDS
WRDS Harvard Subscriptions
To see a list of all databases that WRDS offers see:
http://wrds.wharton.upenn.edu/demo/databaselist.shtml
| Title | Description | Coverage |
|---|---|---|
| Audit Analytics | Provides audit, regulatory and disclosure intelligence in order to track, analyze, benchmark and understand public company disclosure issues and trends. | 2004 - present |
| Bank Regulatory | The Bank Regulatory Database contains five databases for regulated depository financial institutions. These databases provide accounting data for bank-holding companies, commercial banks, savings banks, and savings and loans institutions. The source of the data is the required regulatory forms filled for supervising purposes. | Varies - most data 1976- |
| Blockholders | This dataset contains standardized data for blockholders for 1,913 companies. | 1996-2001 |
| Bureau van Dijk | WRDS currently provides users with the following company information databases: | Varies - see below |
| Amadeus
European public and private company information on over 10 million public and private companies from 41 countries, including all the EU countries and Eastern Europe. |
Up to 10 years | |
| Bankscope
Global banking information on over 28,000 banks worldwide. |
Up to 16 years | |
| Isis
Global information on 5,250 non-life companies (back to 1992), 2,400 life companies (to 1995), and 610 composites (to 1995) in over 120 different countries. |
1992-present | |
| Osiris
Listed and major unlisted/delisted companies from over 190 countries. |
20 years on over 55,000 companies; 8 years of financial data for more than 3,350 listed banks; 9 years of data on over 660 listed insurance companies | |
| CBOE Indexes | The CBOE (Chicago Board Options Exchange) Volatility Index® (VIX®) is a key measure of market expectations of near-term volatility conveyed by S&P 500 stock index option prices. | 1986-previous year |
| COMPUSTAT Bank | Financial, statistical and market information on the largest and most important banks in the U.S. Contains a wide range of fundamental and technical data. | 1950-Current Year |
| COMPUSTAT Executive Compensation | Standard and Poor's Execucomp provides executive compensation data collected directly from each company's annual proxy (DEF14A SEC form). Detailed information on salary, bonus, options and stock awards, non-equity incentive plans, pensions and other compensation items are available. | 1992-previous year |
| COMPUSTAT Global | Compustat Global provides financial and market data covering publicly traded companies in more than 80 countries, representing over 90% of the world's market capitalization, including coverage of over 96% of European market capitalization and 88% of Asian market capitalization. Hundreds of data items, ratios and concepts and up to 12 years of annual history is included. Compustat Global consists of four distinct files: Industrial/Commercial; Financial Services; Issue; and Currency. The Currency File contains month-end and average translation rate items and cross-rate tables for designated currencies. The Compustat Global Financial Service file covers financial companies and contains data for Income Statement, Balance Sheet, Flow of Funds, and supplemental data items. The Compustat Global Industrial/Commercial contains data for Income Statement, Balance Sheet, Flow of Funds, and supplemental data items. The Compustat Global Issues file contains stock market related items, including monthly prices, dividends, shares traded, issued capital, and earnings per share. |
|
| Global Fundamentals Annual Global Fundamentals Quarterly Global Security Daily |
1989-previous year | |
| COMPUSTAT North America | Compustat North America is a database of U.S. and Canadian fundamental and market information on more than 30,000 active and inactive publicly held companies. It provides thousands of Income Statement, Balance Sheet, Statement of Cash Flows, and supplemental data items. It also contains information on indices, industry segments, banks, market prices, dividends, and earnings. | |
| Quarterly Updates Financial Statements Fundamentals Annual Fundamentals Quarterly Security Monthly Index Constituents Index Prices Index Fundamentals Pension Industry Specific Ratings Annual Updates Fundamentals Annual Fundamentals Quarterly Security Monthly Index Constituents Index Prices Index Fundamentals Pension Industry Specific Ratings |
Varies most data 1950-Current Year | |
| COMPUSTAT Other databases |
Segments Index Fundamentals Filings |
|
| CRSP | The Center for Research in Security Prices (CRSP) maintains the most comprehensive collection of security price, return, and volume data for the NYSE, AMEX, and Nasdaq stock markets. Additional CRSP files provide stock indices, beta- and cap-based portfolios, treasury bond and risk-free rates, and mutual fund databases. | |
| CRSP/Compustat Merged- Annual Update Version CRSP/Compustat Merged - Quarterly Update Version |
Varies - most data 1925-previous year | |
| Daily U.S. Treasury Bonds Monthly U.S. Treasury Bonds |
1925- | |
| Daily U.S. Stocks - Annual Update Version Daily US Stocks - Quarterly Update Version Monthly U.S. Stocks - Annual Update Version Monthly U.S. Stocks - Quarterly Update Version |
1925-previous year | |
| Indices: NYSE, AMEX, NASDAQ, and S&P - Annual Update Version Indices NYSE, AMEX, NASDAQ and S&P - Quarterly Update Version |
1925-previous year | |
| Mutual Funds - U.S. and Intl. | Varies- most data 1961-previous year | |
| Corporate Library | The Corporate Library offers annual historical data captures for each proxy year beginning in 2001. Information includes:
Corporate Board Structure and Independence Director Positions and Committee Assignments Executive Compensation Director Compensation Audit Fees Corporate Ownership Takeover Defenses The Corporate Library is a source of comprehensive objective corporate governance, compensation, and critical company information. It contains information on over 4,000 U.S. companies and over 40,000 corporate executives and directors. |
|
| CSMAR | The China Stock Market & Accounting Research Database offers data on the China stock markets and the financial statements of China's listed companies. Financial Data(Balance Sheet and Income Statements) Direct and Indirect Cash Flow | 1990-20011(Financial Data) 1998-2011(Cash Flow) |
| CUSIP Master Files | The CUSIP Service Bureau, which is operated by Standard & Poor's for the American Bankers Association, exists for the primary purpose of uniquely identifying issuers and issues of financial instruments within a standard framework, and disseminating this data to the financial marketplace via various media. The CUSIP Master Files provide CUSIP numbers, standardized descriptions and additional data attributes for over 5 million corporate, municipal and government securities offered in North America.
CUSIP numbers and standardized descriptions are used by virtually all sectors of the financial industry, and are critical for the accurate and efficient clearance and settlement of securities and other financial instruments as well as back-office processing. The CUSIP number consists of nine characters: a base number of six characters known as the issuer number, (the 4th, 5th and/or 6th position may be alpha or numeric) and a two character suffix (either numeric or alphabetic or both) known as the issue number. The ninth character is a check digit. |
|
| DMEF Academic Data | Four individual data sets, each containing customer buying history for about 100,000 customers of nationally known catalog and non-profit database marketing businesses are available through DMEF to approved academic researchers for use within academic situations.
Corporate names are anonymous and customer names and addresses have been removed, but the business type is indicated. ZIP codes have been retained (if possible) to provide a potential link to Census ZIP level demographics. |
1993 - 1995 |
| Dow Jones | Dow Jones Industrial, Transportation, and Utility Averages | 1896-2007 |
| Eventus | Eventus performs event studies using data read directly from CRSP stock databases or pre-extracted from any source. The Eventus system includes utility programs to convert calendar dates to CRSP trading day numbers, convert CUSIP identifiers to CRSP permanent identification numbers, and extract event study cumulative or compounded abnormal returns for cross-sectional analysis. | Dependent upon data input |
| Fama French Momentum and Liquidity | Fama-French Research Portfolios and Factors. The Fama-French Portfolios are constructed from the intersections of two portfolios formed on size, as measured by market equity (ME), and three portfolios using the ratio of book equity to market equity (BE/ME) as a proxy for value. Returns from these portfolios are used to construct the Fama-French Factors. | 1926-2009 (daily 1963-to current year) |
| Federal Deposit Insurance Corporation (FDIC) | FDIC Call Reports - The Federal Deposit Insurance Corporation (FDIC) dataset contains financial data and history of all entities filing the Report of Condition and Income (Call Report) and some savings institutions filing the OTS Thrift Financial Report (TFR). These entities include commercial banks, savings banks, or savings and loans. | 1984-1998 |
| Federal Reserve Bank Reports | The Federal Reserve Bank Reports contains three databases collected from Federal Reserve Banks. Two of them (Foreign Exchanges and Interest Rates) come from reports published for the Federal Reserve Board (H.10 and H.15 reports). The other one contains the state composite indexes from the Federal Reserve Bank of Philadelphia. | Varies 1919-current year, 1971-current year |
| Global Insight/DRI | Global Insight/DRI databases provide national and sectoral-level information and market indices information. The "Global Insight Series Attributes" web query provides a means to save time in using the "Global Insight Series Data" web query. It also provides a good way to explore the breadth and depth of GI data coverage without processing the large volume of data values. | Varies |
| I/B/E/S | IBES Forecasts, Recommendations and Actuals - Individual and Summary: The Institutional Brokers Estimates System (IBES) provides consensus and detailed forecasts from security analysts, including earnings per share, revenue, cash flow, long-term growth projections, and stock recommendations. | Varies - most data 1974-current year |
| IRI | The IRI Marketing Fact Book contains data on grocery store purchases from a representative sample of static qualifying U.S. panelist households to help make intelligent inferences for strategic planning and decision making. These purchases are continuously tracked across all UPC-coded brand-items in all categories. | 1983-1997 |
| ISSM | The Institute for the Study of Security Markets (ISSM) database contains tick-by-tick data covering the NYSE and AMEX between 1983 and 1992, and NASDAQ between 1987 and 1992. Each year of data is divided into two files, one for trades and one for quotes. | 1983-1992 |
| KLD Research and Analytics | KLD created the Domini 400 SocialSM Index (DS 400 Index), a socially screened, capitalization-weighted index of 400 common stocks. The DS 400 is recognized as the first social investment benchmark. As well, KLD provides social ratings for all companies in the DS400. | 1991-2010 |
| Mutual Fund Links (MFLINK) | The MFLINKS tables provide a reliable means to join CRSP Mutual Fund (MFDB) data that covers mutual fund performance, expenses, and related information to equity holdings data in the TFN/CDA S12 datasets. Using MFLINKS allows a researcher to gather detail on holdings for either particular funds or fund families and groups of funds at specific points in time. | |
| OptionMetrics | OptionMetrics's IvyDB is a comprehensive source of historical price and implied volatility data for the U.S. equity and index options markets. | 1996-September 2009 |
| OTC Corporate Bond Transaction Data (TRACE) | FINRA is the Financial Industry Regulatory Authority, a non-governmental regulator of the entire securities industry. It was formed in the summer of 2007 from the NYSE and the NASD. TRACE - Trade Reporting and Compliance Engine is FINRA's over-the-counter (OTC) corporate bond market real-time price dissemination service. Bringing transparency to the corporate bond market, it helps create a level playing field for all market participants by providing comprehensive, real-time access to corporate bond price information. Introduced in July of 2002, TRACE consolidates transaction data for all eligible corporate bonds - investment grade, high yield and convertible debt. As a result, individual investors and market professionals can access information on 100 percent of OTC activity representing over 99 percent of total U.S. corporate bond market activity in over 30,000 securities. The TRACE Historical Time and Sales data is available through WRDS. The information collected and disseminated for all publicly traded corporate bonds by TRACE includes the time of execution, price, yield, and volume. |
2002-previous year |
| Penn World Tables | Penn World Tables from the Univ. of Pennsylvania provide national income accounts-type variables converted to international prices. | 1950-2007 |
| Philadelphia Stock Exchange (PHLX) | Currency Options and Implied Volatility: The Philadelphia Stock Exchange's United Currency Options Market (UCOM) offers choice of expiration date, strike (exercise) price, premium payment, and any combination of ten currencies currently available for a total of 100 possible currency pairs. | 1983-1997 |
| RiskMetrics (formerly IRRC) | RiskMetrics (through ISS Governance Services) is a leader in corporate governance data. They deliver to WRDS four datasets identified as: RiskMetrics Group Historical Governance, Historical Directors data, Voting Results data, and Shareholder Proposal data. | Varies - most data 1990-previous year |
| SEC Disclosure of Order Execution | SEC-mandated Disclosure of Order Execution Statistics | 2001-2005 |
| On November 15, 2000, the SEC adopted new rules aimed at improving public disclosure of order execution and routing practices. As a result of Rule 11Ac1-5, market centers that trade national market system securities must make monthly, electronic disclosures of basic information concerning their quality of executions on a stock-by-stock basis, including how market orders of various sizes are executed relative to the public quotes and information about effective spreads - the spreads actually paid by investors whose orders are routed to a particular market center. In addition, market centers must disclose the extent to which they provide executions at prices better than the public quotes to investors using limit orders. | ||
| TAQ | The Trade and Quote (TAQ) database contains intraday transactions data (trades and quotes) for all securities listed on the New York Stock Exchange (NYSE) and American Stock Exchange (AMEX), as well as Nasdaq National Market System (NMS) and Small Cap issues. | 1993-2009 |
| Thomson Reuters | The Thomson Reuters databases cover Mutual Funds Holdings (CDA/Spectrum s12) and 13f Institutional Holdings (CDA/Spectrum s34). The Insiders Filings database contains transaction and holdings information filed with the SEC. Also included is WRDS-Reuters Dealscan. It provides users with access to Thomson Reuters LPC's database of detailed terms and conditions on over 200,000 loan transactions. | Varies - see below |
| Mutual Funds (s12)
- s12type1 Fund Characteristics - s12type2 Stock Characteristics - s12type3 Holdings - s12type4 Change in Holdings |
1980-Current year | |
| Institutional (s34)
- s34type1 Institutional Manager Characteristics - s34type2 Stock Characteristics - s34type3 Stock Holdings - s34type4 Changes in Stock Holdings |
1980-Current year | |
| Insiders | 1986-2009 | |
| DealScan | 1981-2013 |