1、Navigating WRDS:Overview of Financial Data on WRDSCRSP, Compustat, and IBESDenys GlushkovRabih MoussawiWRDS Librarian ColloquiumWashington, D.C., June 15, 20091AgendaWhat is WRDS?Sources of Financial DataOverview of Compustat, CRSP, and IBES DataWRDS Tools and Support: How to Get the Help You Need?H

2、ow Can Researchers Use WRDS More Efficiently?2WRDS OverviewSingle and flexible source to extract data from leading research databasesVariety of disciplines: Accounting, Finance, Economics, Banking, Insurance, Marketing, Statistics, +Standardized queries: Every database webpage has the same format: q

3、uery + variable documentation + list of manuals, overviews, & research applicationsIdeal for Data linking: e.g. CRSP (stock prices, dividends, splits), Linking CRSP and COMPUSTAT, Matching IBES and CRSP Data, + linking sample programsInternet-based platform with multiple access optionsWeb queries: c

4、ompatible with various browsers and operating systems (nothing to install)Standardized, easy-to-use, point-and-click interface, unlimited downloads ( 2GB size limit per query)Easy variable and company name searches, and other toolsFast extracts and record retrievals through TerraBytes of dataPC SAS

5、CONNECT remote librariesUNIX X-Windows and batch job capabilitiesFull-time research and technical supportOnline help (variable definitions, data sources, equations, manuals, tutorials, sample programs, FAQs), email support, and 24/7 network monitoringData Overviews, Research Applications, Knowledge

6、Base and ForumsWRDSWe are WRDS users too3WRDS HistoryOriginally developed for Wharton needs:Centralize data management and research support Provide faculty and PhD candidates with web-based, and interactive research toolsGrown from 2 subscribers in 1997 to 250+ subscribers in 2009:All top academic a

7、nd non-profit research institutions We support over 18,000 faculty and other researchers accountsData increased from 60 GB to 30+ TBOriginally accounting and financial data; now includes economic, banking, insurance and marketing dataSeveral Free Data SourcesPartnerships with leading data vendors: G

8、rown from 2 to 40+ data providers4Data Licensing and Access with WRDSDatabases la carte Data WRDS Licensing Subscription Agreement Agreement Re-distribution agreementWRDSData Vendor WRDS Subscriber5WRDS TechnologyFlexibility to Connect and Get DataLibraries/LabsOn the roadUser PCWRDS server6WRDS Acc

9、ount Types Web UNIX Expiration queries login* dates Faculty x x Full time Staff x xPhD Candidates x x x Master Students x x Research Assistants x x x Visitors* x x x Shared Class Accounts x x Library & IP-based x * Visitors must have formal, temporary appointment* Also allows for PC SAS CONNECT sess

10、ions7Market Data CRSP, OptionMetrics, & others Prices and Returns of equities and bonds- Shares Outstanding, Volume, and Market Capitalization- Historical Data, no selection or survival biases Prices (NAVs) and Returns of REITS and Closed end funds Prices, Volumes, and Implied Volatilities of traded

11、 Options Bond Prices, Returns, and Ratings (S&P Ratings, FISD, Trace)Accounting Data Compustat & others BS, IS, and CF numbers from 10-K, 10-Q filings- Quarterly and Annual Freqs (observed with lags)- Financial, Accounting, and Industry Specific Data (e.g. SSS, Verified Oil Reserves) Executive Compe

12、nsation Data(Analyst) Forecasts Data IBES, FirstCall, & others Analyst expectations about companies future Earnings (future EPS, g(sales), or SSS)- Valuation assessments: Recommendations, Price Target Revisions and new estimates on daily frequencyOwnership Data Thomson Reuters Ownership Data Ownersh

13、ip by companies insiders and large blockholders Aggregate Ownership by institutions with $100million in discretionary assets , at the security level (e.g. hedge funds, mutual funds Vanguard Group) - Ownership by mutual fund management companies, at the fund level (e.g. Vanguard S&P500 Index Fund, et

14、c)SECEDGAR, IAPD,Sell-Side Analysts (brokers)Exchanges, &Financial Information by Source8Data on WRDS Easy and Flexible Extracts9S&Ps Compustat Accounting and Financial DataCompustat North-America: U.S. and Canadian fundamental and market information on around 31,000 active and inactive publicly hel

15、d companies, from 1950-presentCompustat Global: fundamental, market, and currency data for more than 30,000 publicly traded companies in global markets (80 countries), from 1988-presentFundamental data available on an annual and quarterly frequencies with thousands of Income Statement, Balance Sheet

16、, Statement of Cash Flows, and supplemental & industry-specific data itemsMarket data available on a monthly and daily frequencies with Prices, Dividends, Returns, Trading Volume , Shares Outstanding and Short-Interest InformationInformation on Indices, Segments, Banks, Incentive plans, Pension Data

17、 Items, as well as: Executive Compensation and S&P Credit Ratings XpressIn the summer of 2007, WRDS adopted the Xpressfeed format of Compustat North America, containing more details on a wider array of companies10Compustat Example Live DemoGet Current Assets, Inventories, and Long-Term Debt for Micr

18、osoft, Dell, and IBM between Jan 2000 and April 200911Basic Compustat StructureFundamental DataCompustat Annual & Quarterly Fundamentals: North America & GlobalOther DataSecurity Data North America & GlobalCompany Financial and Accounting DataS&P Credit Ratings XpressPoint-In-TimeIndustry SpecificSe

19、gmentExecutive Compensation12WRDS Support: CompustatOverview to Compustat XPressfeed Database, FAQs, and WRDS Reference Materials Comprehensive Dataset and Variable List Financial Statements, S&P 500 Index Constituents, and other Tools: Sample Programs: extracts, filing dates, portfolios, earnings s

20、urprises, # of segments, etc.Research Applications: book-to-market, linking, etc.13CRSP Stock Market DataCenter for Research in Security Prices (CRSP) is a research center at the Booth School of Business of the University of ChicagoComprehensive collection of daily and monthly security price, return

21、, and volume data for the NYSE, AMEX and NASDAQ stock marketsDaily and Monthly data for roughly 28,000 securities of Domestic companies and ADRs traded on major exchanges (no OTC), from 1925presentComplete historical information (bias-free): Accurate accounting of special distributions and stock spl

22、its in return calculationKeep delisting companies (pre-M&A or bankruptcies), and delisting returnsAdditionally provide stock indices, beta- and cap-based portfolios, treasury bond and risk-free rates, CRSP/Compustat Merged Database, REITs, and mutual fund databases14CRSP Example Live DemoGet monthly

23、 prices, return and volume information for Microsoft and Ford from 1925 to 2008Find all stocks that were trading in NYSE at the end of November 1929, and get their month-end prices, return and volume information=AnnualUpdateMonthlyStocks15Basic CRSP StructureMonthly Security DataCRSPSecurity DataOth

24、er Market DataOther Products:- CRSP-Compustat Merged Product (CCM)- CRSP Mutual Fund Database- CRSP Ziman REITs DatabaseStock DataEvent FilesIndices and Decile PortfoliosTreasuries and Inflation16WRDS Support: CRSPComprehensive Dataset and Variable Lists, FAQs, Manuals & Data Guides Linking CRSP-Com

25、pustat Data (with and without CCM Product)Tools: Returns + Decile Assignments , Translate to PERMNO/PERMCO , Mutual Fund Returns & Fama-French , Market Indices , Events and Names Sample Programs: Data Extracts, CCM and merging by CUSIP, Calculate CAPM beta, Excess returns, Portfolio formations, plot

26、s, Event studies, Mutual fund dataResearch Applications: Compounded returns, Momentum and Governance Portfolios, Rolling Regressions, Beta Estimation, Event Studies etc.17Thomson Reuters IBESAnalyst Forecast DataAnalysts earnings and sales forecasts (+), consensus estimates, and Buy/Hold/Sell Recomm

27、endationsComprehensive Global Coverage: Domestic and International public companies from 1980presentFeaturesup to 26 forecast measures including GAAP and pro-forma EPS, revenue/sales, net income, ROA, ROE, pre-tax profit and operating profit, EBIDTA, etc.Company indentifying information and exchange

28、 ratesNEW data on price targets, company level footnotes and restated actuals (all in detailed and summary formats) 18IBES Example Live DemoGet price target data for Lehman Brothers between July -Sep 2008 (e.g., value, horizon, announcement date, analyst name)19Basic IBES StructureIBESAdjustedUnadju

29、stedRecommendationsDetailSummaryDetailSummary20WRDS Support: IBESDetailed overview of IBES and empirical issuesLinking IBES and CRSP Important updates on data quality and changes to IBES vintagesSample programs and Research Applications: Calculate earnings surprises, work with unadjusted data, link

30、recommendations and estimates, and many more21Other Popular Databases on WRDSNYSEs Trades And Quotes (TAQ) Database: High-frequency data Intraday trades and quotes for all securities on Major US ExchangesThomson Reuters Ownership Databases: 13F, Mutual Funds, InsidersRiskMetrics Governance, and KLD

31、Social Rating datasets:Governance Provisions: Dual Class, Poison Pills, and other antitakeover provision dummiesBoard of Directors: list of board members, with additional information (ownership, bio,)Shareholder Proposals and voting records: NEW Datasets on types of proposals by shareholders and vot

32、es garnered during annual meetingsKLD Social and Environmental Records: criteria to measure corporate social responsibility, such as environment, employee relations, human rights, governance, community issues S&P Credit Ratings Xpress, TRACE and FISD Bond DataFree Datasets (CBOE Indexes, DJ Averages

33、, Fama-French, Liquidity factors)22WRDS Tools: Company & Variable SearchCompany search tool Allows users to search for a company by CUSIP, Ticker or company name across a host of different databases on WRDS (CRSP, Compustat, Thomson, TAQ, Insiders, etc)Variable search toolAllows users to search for

34、a given variable within either variable name or label or both across a wide range of various databases on WRDS (CRSP, Compustat, IBES, TAQ, Global Insight, etc)23How to Get SupportResearch and Technical SupportOnline Help (24/7) Database Manuals plus additional support documentationData Overviews: e

35、.g. OptionMetrics OverviewResearch Applications: e.g. Portfolio Construction, Event StudiesSample Programs: e.g. Merging CRSP and CompustatVariable Search: e.g. CompensationCompany Search: e.g. MicrosoftWRDS Knowledge Base: FAQ archive of answers to common user questions e.g. How to find IPO dataFOR

36、UMSWRDS: Interactive users questions and suggestions e.g. Fama and MacBeth RegressionsEmail support at wrds- (Monday-Friday, 9a-5p EST)Researchers and Technical Experts ready to assist with:Data extraction, merging, and management.Programming and technical problemsOther research concerns24Advanced W

37、RDS FeaturesAccess Data Remotely on WRDS ServerWhat if a web query does not do all that you need it to do?Example: Find all companies in 1997 with sales greater than 1 billion, total assets greater than 5 billions, and with more than 30 years of publicly reported financial statements. AdvantagesDisa

38、dvantagesUnix Simple set up.Line-based editing. Only batch runs.PC-SAS/Connect Interactive runs. Limited UNIX commands. Each method can perform a basic data extract, combining different variables from various datasets, and serve as the first step in a full-fledged statistical program. There is no need to download and import data into a separate system or even a second program to complete the analysis. SAS Connect makes use of both SAS menus and windows (program/log/output) for batch-style sessions with extras. Can alternate between server and PC processing. 25PC-SAS