Wharton Research Data Services (WRDS) Workshop

Transcript:Wharton Research Data Services (WRDS) Workshop:
Wharton Research Data Services (WRDS) Workshop Department of Finance & Management Science Outline of Workshop Introduction……………………………………................................................Hongwei Zhao Live Demo of Accessing WRDS……………………………………………….Jingjing Chen Center for Research in Security Prices (CRSP)…………………………Cuyler Strong S&P Global Market Intelligence’s Compustat……………………………Yoonsoo Nam Eventus…………………………………………….................................................Feiwei Chen Thomson Reuters 13-F Filings……………………………………………................Ao Wang Trials and Unsubscribed Datasets.………………………………………….Adrian Tippit Conclusion………………………………………………………………………….Hongwei Zhao Introduction Presenter: Hongwei Zhao What Is WRDS? Wharton Research Data Services (WRDS) is the award-winning research platform and business intelligence tool Developed by the Wharton School of the University of Pennsylvania Offers over 250 terabytes of data Used by 400+ institutions in 30+ countries. WRDS Website Comprehensive Services Research applications Applications, utilities and an extensive suite of template and sample programs Online specialists support E-learning A library of video sessions covering a host of topics presented by research experts Timely updates Convert and install database updates for immediate access Learning environment Enable to demonstrate real-world applications of principles with actual company data Data Licensing and Access with WRDS Data WRDS Licensing Subscription Agreement Agreement Re-distribution agreement WRDS Data Vendor WRDS Subscriber Friendly Support Environments WRDS supports the following client environments Subscribed Data Audit Analytics Bank Regulatory Beta Suite by WRDS Blockholders BoardEx CBOE Indexes Compustat – Capital IQ CRSP CUSIP DMEF Academic Data Dow Jones Efficient Frontier by WRDS Event Study by WRDS Eventus Fama French & Liquidity Factors Federal Reserve Bank ISS (Formerly RiskMetrics) MSCI (Formerly KLD and GMI) MSRB OTC Markets Penn World Tables Peters and Taylor Total Q PHLX Public Research Quotient SAS Visual Analytics SEC Order Execution Thomson Reuters TRACE World Indices by WRDS WRDS SEC Analytics Suite Live Demo of Accessing WRDS Presenter: Jingjing Chen Creating WRDS Account Step 1: Register at WRDS website https://wrds-web.wharton.upenn.edu/wrds/ Step 2: Get the email to set your password The WRDS Representatives for our institution are: Gregory Alan Neunherz greg_neun@wsu.edu 509-335-1315 Tyson Livingston tyson_livingston@wsu.edu Getting data from WRDS Wed-based access WRDS Cloud: offers access to all WRDS data SAS studio Remote access to WRDS via PC-SAS, MATLAB, R, Python, Fortran, C Command line access via SSH Downloading from the website Log in to the WRDS platform: https://wrds-web.wharton.upenn.edu/wrds/ Create a data query and view the results Advantages Simple, powerful queries with a few clicks Download up to 2GB of data per query Export into the format of your choice Import into popular programs with ease Disadvantages Lack of flexibility Accessing WRDS via SAS studio SAS Studio is an interface to