Now, more than ever, access to data, analytics, research
and technology is critical to your mission. From
the classroom, boardroom, or home, for 25+ years
WRDS has supported users with targeted solutions that
underpin research, reinforce learning, and enable discovery.

Using Python on Jupyter

Quickly learn how to access Jupyter on WRDS using the Python kernel.

  • Explore the WRDS Python package, designed for straightforward data access
  • Retrieve Dow Jones data
  • List libraries available to your institution

Quick Intro to WRDS

WRDS guides you through the website and introduces you to query pages, innovative tools, comprehensive resources, and research support.

Introduction to BoardEx

In this overview of BoardEx, you will learn about coverage, how the data is structured, key identifiers, and the answers to some frequently asked questions from researchers.

Introduction to Web Queries

Learn how to access WRDS data using web queries. Simple step-by-step instructions cover:

  • Adding filters and selecting variables
  • Selecting the output format
  • Downloading the data
  • Accessing past queries

SAS Studio - Part 1

This is WRDS’ introduction to accessing data through SAS/Studio. This tutorial is intended for first time users or experienced users looking to refresh their knowledge of how to access and explore data in SAS/Studio.

Research Data Overview of WRDS

This overview organizes the databases available in WRDS into five main categories:

  • Pricing data
  • Fundamental data
  • Earnings and estimates data
  • Institutional ownership data
  • Other types of data

Data by Concept

Our experts guide you in finding the data needed for your research.

Accessing WRDS Support

This video tour will guide you through the extensive support services offered by WRDS.

Classroom by WRDS

Experience how this teaching and learning toolkit can introduce finance and business concepts through interactive applications and simulations.

Introduction to Compustat | Part 1

Learn the source and scope of Compustat North America data on WRDS.

Introduction to Compustat | Part 2

Expand your knowledge of the benefits of Compustat data on WRDS through this guided video overview.

CRSP Basics

Access a comprehensive overview of CRSP data on WRDS.

CRSP Stock Database Structure

Explore CRSP’s stock database and find out why it is relied on by researchers across the globe.

CRSP Coverage

Learn about the breadth of coverage for CRSP data in this video overview.

Tags: crsp

CRSP - Useful Variables

Advanced information and tips about CRSP variables, including

  • How CRSP adjusts prices and shares for splits
  • Calculating returns with dividends
  • Delisting returns
  • Calculating market capitalization

Merging CRSP and Compustat Data

Advanced tutorial on two different approaches to merging CRSP and Compustat data:

  • Merging at the security level by CUSIP
  • Using the CRSP./Compustat Merged Database (CCM)

Downloading the S&P 500 Constituents

Learn two different ways to download the historical S&P 500 constituents from CRSP and save the data in different formats.

I/B/E/S on WRDS — Introduction and Research Guide

Take a guided tour through I/B/E/S data — the premier analyst forecast data in academia.

Introduction to S&P Capital IQ

Identify detailed company financial information for U.S. and international public and private companies and investment firms through S&P Capital IQ.

Capital IQ - Introduction

Learn about Capital IQ on the WRDS platform. The discussion of each Capital IQ dataset includes the following:

  • Description of the data
  • Details about coverage
  • Overview of key features

Capital IQ Transcripts

A detailed overview of Capital IQ Transcripts--specifically the CIQ Transcripts package on WRDS, including:

  • Coverage and data sources
  • Data collection methodology
  • Summary statistics and sample data

Capital IQ - How to Use

Step-by-step instructions for how to access Capital IQ data. Includes an overview of the Capital IQ library structure. Learn how to access Transcripts through various methods:

  • Web query
  • Full-text search
  • Full-text bulk data (WRDS Cloud)

Compustat Global: The Basics

Explore the basics of Compustat Global, including:

  • Coverage and frequency of updates
  • Variables and identifiers
  • Types of data
  • How to filter by country

Compustat Execucomp: The Basics

Explore the Compustat Execucomp database, with topics including:

  • Overview of the data
  • Compensation items
  • How to track executives

Ownership Data | Part 1

This first video, part of a two-part series on ownership data, provides detailed information about:

  • Sources of ownership data
  • Multiple databases offering ownership data on WRDS

Ownership Data | Part 2

Continuation of the two-part video series on ownership data at WRDS. Explores known data issues in ownership data. Discussion includes:

  • Comparisons between datasets
  • Solutions to some data issues

NYSE TAQ — Introduction

WRDS guides you through the introductory steps to access current U.S. market equities at the millisecond level.

American Hospital Association (AHA)

Overview of the American Hospital Association (AHA) data on WRDS. Topics include:

  • Research trends
  • COVID-19
  • New variables

Financial Statements: Intro to the Major International Databases

Learn about the four main providers of international financial statement data:

  • Compustat Global
  • BvD Osiris
  • Refinitive Worldscope
  • FactSet Fundamentals

Introduction to Event Study by WRDS

Measure the impact on the value of a firm resulting from an event.

WRDS-SEC | 1. Introduction

Overview of the various WRDS resources built using SEC filings.

  • Introduces the WRDS SEC Analytics Suite
  • Explains how to access information that can expedite and enhance research

WRDS SEC | 2. Filings and Metadata

This video--the second in a series--discusses the structure of SEC filings, including

  • How the filings are maintained
  • How the filings are organized on the WRDS server
  • How the filings are referenced in the metadata

WRDS SEC | 3. Queries and Analytics

This third video explains how to use web queries to access the SEC filings--including lists of exhibits and 8-K items--with a particular emphasis on the versatility of the search function. The discussion also includes a description of available textual analytics tools.

Introduction to WRDS Insiders

A comprehensive guide to WRDS Insiders, including:

  • Data coverage
  • Background information on disclosure of the data
  • Description of Form 3, Form 4, and Form 5
  • Structure of the datasets

Using WRDS Insiders

Comprehensive guide to using WRDS Insiders, including:

  • Details about WRDS Insiders coverage
  • Description of insider trading transactions common to all insider trading databases
  • Discussion of the general ecosystem of insider trading

Assembling WRDS Insiders

Guide to assembling a trade level dataset for derivatives/non-derivatives transactions in WRDS Insiders. The end result is the creation of a dataset similar to Thomson-Reuters Table 1/Table 2. 

WRDS Linking Procedures

Overview of the basic information necessary for linking databases on WRDS, including:

  • Common identifiers used for linking
  • Procedures used to generate linking tables on WRDS
  • Other linking resources available on WRDS

Fama-French SMB and HML | SAS Replication

Replication of the SMB and HML Fama-French factors using SAS, including:

  • Using Compustat data to calculate book value of equity
  • Using CRSP stock data for portfolio formation
  • Merging of CRSP and Compustat data
  • Comparison of results with Ken French's data

Fama-French SMB and HML | 1. Book-Equity

Learn how to work with Compustat annual data to calculate the book value of common shares. Presentation includes detailed examination of the relevant portion of SAS code used to replicate the Fama-French factors.

Fama-French SMB and HML | 2. CRSP Stock Data

Learn how to work with CRSP stock data to calculate market equity. Presentation includes detailed examination of the relevant portion of SAS code used to replicate the Fama-French factors.

Fama-French SMB and HML | 3. CRSP

Learn how to work with CRSP data to calculate portfolio weights for value-weighted returns. Presentation includes detailed examination of the relevant portion of SAS code used to replicate the Fama-French factors.

Fama-French SMB and HML | 4. Merge CRSP and Compustat: B/M Ratio

Learn how to merge CRSP and Compustat data to create book-to-market ratios. Presentation includes a detailed examination of the relevant portion of the SAS code used for replicating the Fama-French factors.

Fama-French SMB and HML | 5. Portfolio Formation

Learn how to form portfolios and calculate the returns necessary to create the SMB and HML factors. Presentation includes a detailed examination of the relevant portion of the SAS code used for replicating the Fama-French factors.

Fama-French SMB and HML | 6. Calculating Fama-French Factors

This final video in the Fama-French series demonstrates the last step in the process: how to calculate the SMB and HML Fama-French factors. Presentation includes a detailed examination of the relevant portion of the SAS code used for replicating the Fama-French factors.

Accessing WRDS Cloud

Learn how the WRDS Cloud can be used to execute research and strategy development.

Using Python on WRDS Platform

Learn how to use Python on the WRDS platform, including:

  • Establishing a connection to the WRDS server
  • Using the basic functions provided by the WRDS API

Momentum Strategy

Demonstration of how to run a momentum strategy using the WRDS Python API and the CRSP dataset.

  • Follows the momentum strategy as documented by Jegadeesh and Titman (1993)
  • Includes how to plot the return series

Python Virtual Environments

This tutorial for how to create Python virtual environments on the WRDS server covers:

  • Benefits of using a virtual environment
  • Steps for creating a virtual environment
  • Activating and deactivating a virtual environment
  • Using pip to install packages

OLS Regression in Python

Step-by-step instructions for how to run a basic regression in Python. Learn how to:

  • Install the required packages
  • Read data into Python
  • Fit a model
  • Obtain output from the model

Use SAS in Python: SASPy - Introduction 1

SASPy is a Python package which enables integration of SAS programs with Python programs. This video--the first in a 4-part series--presents a general overview of the package, including:

  • Reasons for using SASPy
  • Configuration for local computer
  • How to use SASPy on the WRDS Cloud

Use SAS in Python: SASPy - Introduction 2

This second video in the SASPy series introduces useful SASPy functions, as well as Jupyter magic for SAS. The tutorial includes:

  • Starting a SAS session
  • Submitting SAS jobs in a Python session
  • Exchanging data between SAS and Python

Use SAS in Python: SASPy - Introduction 3

This third video in the SASPy series demonstrates how to work with SASPy on WRDS Jupyter Hub. The tutorial covers many functions, including:

  • Advanced SAS data access using dataset options
  • Methods for submitting a SAS job
  • Transferring macro variables between SAS and Python

Use SAS in Python: SASPy - Introduction 4

This last video in the four-part series demonstrates a sample workflow using Python and SASPy running on a local PC. The example used is running an event study using CRSP data and a pre-written SAS macro.

Quick Intro to WRDS | Spanish

WRDS te guía a través de la plataforma y te presenta su página web en donde descargar datos, sus herramientas innovadoras, así como sus recursos integrales y de apoyo para el investigador.

Trial Data

Learn how to access sample sets of trial data at WRDS.

SAS Studio - Part 2

I explained how to login to SAS Studio and described some of the features in the screen layout. I will now explore a dataset. Here I am opening up the Compustat Daily North American Fundamentals dataset, called funda, which is used as the base dataset for the similarly named web query.

SAS Studio - Part 4

I explained how and where to store data on WRDS Cloud, the underlying server powering SAS/Studio. I will now go through an example process of uploading a file to my Home directory, running custom code to query data on WRDS, and download my results to my Home directory and or local computer.

SAS Studio - Part 3

I explored a dataset in SAS/Studio. I will now explain the different options for data storage on WRDS Cloud and how to access these folders in SAS/Studio. SAS/Studio runs on the WRDS Cloud, our high performance computing cluster. This means that, while you access it in your web browser on your computer, the SAS that runs underneath it runs on our powerful servers.

Intro to WRDS 13F Holdings - Training

Through parsing of the SEC 13F Holdings data reported in XML attachments, you can access details on holdings as well as well as summary information of equity positions held by institutional investors. As such format was mandated by the SEC after June 2013, the SEC 13F Holdings data is complete only for the period after that reporting date.

Intro IBES by WRDS - Training

I/B/E/S International Inc. created their Academic Research Program over 30 years ago to provide both summary and individual analyst forecasts of company earnings, cash flows, and other important financial items, as well as buy-sell-hold recommendations. In 2000, I/B/E/S was integrated with Thomson Reuters / First Call, and in 2012 First Call was discontinued.

Financial Data on WRDS - Training

Introduction Training to Compustat, CRSP, and WRDS Analytics.

Introduction to Classroom by WRDS - Training

Training overview of Classroom Tools by WRDS. These tools are a teaching and learning toolkit designed specifically for faculty who are introducing finance and business concepts in the classroom.

Introduction to Boardex on WRDS - Training

BoardEx contains valuable information on 1.7 million corporate executives and board members from over 2.2 million organizations.

SEC Analytics Suite by WRDS - Training

WRDS' proprietary SEC research platform is used in such disciplines as corporate due diligence, forensic accounting, disclosure research, and investment management. This teaching tool is designed to help you to learn more about the different components of the suite.

Using Python on Jupyter

Quickly learn how to access Jupyter on WRDS using the Python kernel.

  • Explore the WRDS Python package, designed for straightforward data access
  • Retrieve Dow Jones data
  • List libraries available to your institution

 
Quick Intro to WRDS

WRDS guides you through the website and introduces you to query pages, innovative tools, comprehensive resources, and research support.

WRDS democratizes data access so that all disciplines can easily search for concepts across the data repository — hosting the broadest collection of data on the most robust computing infrastructure.

 
Introduction to BoardEx

In this overview of BoardEx you will learn about coverage, how the data is structured, key identifiers, and the answers to some frequently asked questions from researchers.

 
Introduction to Web Queries

Access WRDS data through our easy-to-use web-based interface. The only requirements are a web browser and Internet access. Learn how to:

  • Add filters and select variables
  • Select the output format
  • Download the data
  • Access past queries

This tutorial is intended for first-time users, or experienced users looking to refresh their knowledge.

SAS Studio - Part 1

This is WRDS’ introduction to accessing data through SAS/Studio. This tutorial is intended for first time users or experienced users looking to refresh their knowledge of how to access and explore data in SAS/Studio.

 
Research Data Overview of WRDS

This quick overview of the research data on WRDS begins by describing usage of the most popular databases.

Databases offered on WRDS are introduced, categorized by topic:

  • Pricing data, including CRSP, Compustat, TAQ, OptionMetrics, and TRACE
  • Fundamental data, including Compustat, FactSet, Capital IQ and WorldScope
  • Earnings and estimates data, including I/B/E/S and Zacks
  • Institutional ownership data, including Thomson Reuters, CRSP Mutual Funds, WRDS-SEC Data, and AuditAnalytics
  • Other types of data, including ExecuComp, BoardEx, RavenPack and Capital IQ Key Developments

The video concludes by highlighting a suite of tools that can be used to link databases for conducting empirical research.

Data by Concept

Our experts guide you in finding the data needed for your research.

  • How data is categorized
  • Techniques to locate data
  • Resources that index WRDS' data

 
Accessing WRDS Support

This video tour will guide you through the extensive support services offered by WRDS.

Our staff of technical and research specialists assist with questions pertaining to research, data queries, and programming.

 
Classroom by WRDS

Experience how this teaching and learning toolkit can introduce finance and business concepts through interactive applications and simulations.

Instructors can utilize these robust tools as a core component of the curriculum, for stand-alone lessons or assignments, or for visually compelling classroom demonstrations.

Topics

  • Introduction to WRDS
  • Investments, Fixed Income, and Accounting
  • Text Analysis
  • Macroeconomics

 
Introduction to Compustat | Part 1

Our doctoral-level expert guides you through an overview of Compustat data on WRDS:

  • What is Compustat?
  • Coverage
  • Important types of data in Compustat

Introduction to Compustat | Part 2

Expand your knowledge of the benefits of Compustat data on WRDS through this guided video overview.

Supporting all levels of experience, Part II of our Compustat overview continues with instruction on

  • How to access data
  • How to link with other data for research

CRSP Basics

Access a comprehensive overview of CRSP data on WRDS.

Key discussion points include:

  • The popularity of CRSP data
  • CRSP features and benefits
  • Types of CRSP data accessible
  • Examples of how data is presented on WRDS

CRSP Stock Database Structure

Explore CRSP’s stock database and find out why it is relied on by researchers across the globe.

Topics covered in this overview include:

  • Types of Updates
  • Time Series vs Event Files
  • How to Merge the files

CRSP's rigorous analysis for accuracy and unique research source is characterized by its unmatched breadth, depth, and completeness — providing unique permanent identifiers backtesting, time series and event studies, and measurement of performance.

CRSP Coverage

Learn about the breadth of coverage for CRSP data in this video overview.

CRSP data on WRDS
US Stock
Historical Indices
US Index History
US Treasury and Inflation Series
Survivor-Bias-Free Mutual Funds
CRSP-Compustat Merged
Ziman Real Estate

CRSP - Useful Variables

Become a more advanced CRSP user by learning details about CRSP variables, such as:

  • What are "negative" CRPS prices
  • How to use CRSP data to create a time-series of prices that is consistent after a split
  • An explanation of the formula used to calculate returns with dividends
  • How delisting returns are calculated
  • What to do about missing delisting returns
  • How to calculate market capitalization

Merging CRSP and Compustat Data

Learn how to merge data from the two most widely-used databases in empirical financial research. The discussion covers:

  • Important structural differences between the two datasets
  • Code for merging CRSP and Compustat data at the security level by CUSIP
  • Code for using the CRSP/Compustat Merged Database (CCM) to merge by CCM link table
  • Notable differences between matching by CUSIP and matching using CCM

 
Downloading the S&P 500 Constituents

Learn two different ways to download the historical S&P 500 constituents from CRSP and save the data in different formats:

  • Use SAS Studio
  • Use a Jupyter Notebook

Requires a subscription to CRSP.

 
I/B/E/S on WRDS — Introduction and Research Guide

Take a guided tour through I/B/E/S data — the premier analyst forecast data in academia.

Key discussion points:

  • Introduction
  • Data categories
  • Identifiers
  • Forecasting time lines
  • I/B/E/S Research Guide

Conduct research using I/B/E/S, I/B/E/S Global Aggregates, I/B/E/S Key Performance Indicators (KPI), and I/B/E/S Guidance.

Introduction to S&P Capital IQ

Identify detailed company financial information for U.S. and international public and private companies and investment firms through S&P Capital IQ.

Access these key S&P Capital IQ databases through WRDS:

  • Capital Structure-Debt
  • Key Developments
  • Professionals
  • Transcripts

Capital IQ - Introduction

This video presents an overview of Capital IQ on the WRDs platform, including detailed information on the following datasets:

  • Capital Structure
  • People Intelligence
  • Key Developments
  • Transactions
  • Transcripts

The video concludes with a use case study, illustrating the powerful links available across Capital IQ products.

Capital IQ Transcripts

Capital IQ Transcripts provides historical conference call transcripts form around the world, covering approximately 8,000 public companies. Learn key information for using this data, including:

  • Details about coverage
  • How the data is collected and processed
  • How the data in the CIQ Transcripts package on WRDS is structured
  • Summary statistics, such as call types and a breakdown of transcripts by country and year
  • Description of the full text data accessible on the WRDS Cloud

Capital IQ - How to Use

Using concrete examples with Capital IQ Transcripts, this video illustrates different ways to access data. For example, instructions are provided on how to pull Apple's 2015 earnings call transcripts using:

  • PC-SAS Connect
  • Python
  • PostgreSql on the WRDs Cloud

Compustat Global: The Basics

Begins with an overview of Compustat Global, highlighting the database's coverage and available variables. Will you need to filter by country for your research? Step-by-step instructions are provided.

The three types of Compustat Global data available on the WRDS platform are explored:

  • Fundamentals data
  • Index constituents and index prices
  • Securities data

The tutorial concludes with a discussion of some common research questions regarding Compustat Global data.

Compustat Execucomp: The Basics

Compustat Execucomp is introduced, with a discussion of the:

  • Data, including details about coverage, where the data is sourced from, and the different datasets that make up Execucomp
  • Compensation items, including total compensation, cash compensation, and stock & option compensation
  • Tracking of executives, including using the annual CEO flag, and identifying board members that are CEOs

The video concludes by highlighting the support documentation available on WRDS for Execucomp.

Ownership Data | Part 1

WRDS ownership data offerings have substantially expanded in recent years. This comprehensive overview of ownership data at WRDS examines ownership data at the:

  • Institutional level
  • Porfolio or fund level
  • Insiders level

Regulatory details, data coverage, and reporting frequency are all discussed in this first part of a two-part video series on ownership data.

Ownership Data | Part 2

What information should researchers know when selecting which ownership data to use? This second video in the two-part series on ownership data focuses on known data issues in the most commonly used databases.

For example, a comparison of the three following datasets is discussed:

  • Thomson-Reuters Mutual Fund Data (Legacy SP feed)
  • Thomson-Reuters Global Ownership Data (OP feed)
  • CRSP Mutual Fund Database

The video concludes with an overview of the available WRDS research applications related to ownership data.

NYSE TAQ — Introduction

NYSE TAQ data Introduction

WRDS guides you through the introductory steps to access current U.S. market equities at the millisecond level including:

  • Access current U.S. market equities at the millisecond level.
  • View granular details of all trade and quote activity.
  • Validate best execution, develop profitable trading strategies and perform in-depth research on the aggregate marketplace.

American Hospital Association (AHA)

This video overview of the American Hospital Association (AHA) data on WRDS features access to multiple data sets that cover demographic, operational, financial and IT characteristics of the nation’s hospitals.

Topics covered: Research trends, COVID-19, and new variables.

Data collected by the American Hospital Association (AHA) represents the single best source for credible, consistent information about the nation’s hospitals.

Financial Statements: Intro to the Major International Databases

Which international database will work best for your research? View an in-depth comparison of the four main international databases that provide financial statement data:

  • Compustat Global
  • BvD Osiris
  • Refinitive Worldscope
  • FactSet Fundamentals

Learn about the contents and coverage of each database. In addition, this tutorial provides a discussion of the pros and cons of the databases, as well as their common characteristics.

Introduction to Event Study by WRDS

Instant visualization of the effect of events on stock returns – U.S. and Global.

Extract detailed, back-end data for analysis, retrieve the behind-the-scenes set of codes, or access in-depth documentation on methodology used.


Key Features include

  • Charts on Mean Cumulative Returns with significance intervals, mean Cumulative Total Returns (CTRs), mean Cumulative Abnormal (CARs) and mean BHARs
  • Daily Event Studies based on Capital IQ Key Development event
  • International Event Studies, covering 48 countries

WRDS-SEC | 1. Introduction

The WRDS SEC Analytics Suite is a “one-stop” research platform that provides standardized service tools to enable users to overcome the challenges in systematically parsing regulatory reports on the SEC website.

This video--the first in a multi-part series--introduces the WRDS SEC Analytics Suite, covering:

  • Importance of regulatory filings
  • Newly available disclosures
  • Search capabilities
  • Derived datasets
  • Tracking of entities over time using linking tables
  • Growth of available SEC filings over time

WRDS SEC | 2. Filings and Metadata

With over 19.8 million SEC filings available since 1994, it is important to be able to easily access the the specific filings that are of interest.

This video--the second in a series--discusses the structure of SEC filings, including

  • How the filings are maintained
  • How the filings are organized on the WRDS server
  • How the filings are referenced in the metadata

WRDS SEC | 3. Queries and Analytics

This third video in the series explains how to use web queries to access the SEC filings--including lists of exhibits and 8-K items--with a particular emphasis on the versatility of the search function. The discussion also includes a description of available textual analytics tools, covering

  • Readability and sentiment
  • WRDS Bag of Words

Introduction to WRDS Insiders

WRDS Insiders includes all insider trades after the SEC mandated electronic disclosure--from June 30, 2003 to the present. This introductory video covers key information for using the data, such as:

  • What is covered in the data?
  • Where does the data come from?
  • How is the data structured?

Using WRDS Insiders

Comprehensive guide to using WRDS Insiders, including:

  • Details about WRDS Insiders coverage
  • Description of insider trading transactions common to all insider trading databases
  • Discussion of the general ecosystem of insider trading

Assembling WRDS Insiders

Guide to assembling a trade level dataset for derivatives/non-derivatives transactions in WRDS Insiders. The end result is the creation of a dataset similar to Thomson-Reuters Table 1/Table 2. 

WRDS Linking Procedures

There are hundreds of datasets provided by different vendors on WRDS. Learn the basics to linking databases, including:

  • Common identifiers used for linking
  • Procedures used to generate linking tables on WRDS
  • Other linking resources available on WRDS

Fama-French SMB and HML | SAS Replication

The goal of this application is to reproduce, as closely as possible, the Fama-French SMB and HML factors in order to provide researchers with a set of programs that can be modified to further advance research in this area. This tutorial presents a step-by-step replication of the SMB and HML Fama-French factors using SAS, including:

  • Using Compustat data to calculate book value of equity
  • Using CRSP stock data for portfolio formation
  • Merging of CRSP and Compustat data
  • Portfolio formation
  • Calculating the Fama-French factors
  • Comparison of results with Ken French's data

A series of additional videos describes each of the calculations behind these steps in more detail.

 
Fama-French SMB and HML | 1. Book-Equity

Learn how to work with Compustat annual data to calculate the book value of common shares. Presentation includes detailed examination of the relevant portion of SAS code used to replicate the Fama-French factors.

Fama-French SMB and HML | 2. CRSP Stock Data

Learn how to work with CRSP stock data to calculate market equity. Presentation includes detailed examination of the relevant portion of SAS code used to replicate the Fama-French factors.

Fama-French SMB and HML | 3. CRSP

Learn how to work with CRSP data to calculate portfolio weights for value-weighted returns. Presentation includes detailed examination of the relevant portion of SAS code used to replicate the Fama-French factors.

Fama-French SMB and HML | 4. Merge CRSP and Compustat: B/M Ratio

Learn how to merge CRSP and Compustat data to create book-to-market ratios. Presentation includes a detailed examination of the relevant portion of the SAS code used for replicating the Fama-French factors.

Fama-French SMB and HML | 5. Portfolio Formation

Learn how to form portfolios and calculate the returns necessary to create the SMB and HML factors. Presentation includes a detailed examination of the relevant portion of the SAS code used for replicating the Fama-French factors.

Fama-French SMB and HML | 6. Calculating Fama-French Factors

This final video in the Fama-French series demonstrates the last step in the process: how to calculate the SMB and HML Fama-French factors. Presentation includes a detailed examination of the relevant portion of the SAS code used for replicating the Fama-French factors. The video concludes with a discussion of the correlation between the results of this replication and Professor French's factors.

Accessing WRDS Cloud

Learn how the WRDS Cloud can be used to execute research and strategy development.

  • How to access WRDS Support Section for Cloud needs
  • Which languages are supported on WRDS Cloud
  • WRDS Web-query -vs- the WRDS Cloud
  • Head nodes -vs- compute nodes

Using Python on WRDS Platform

Learn how to use Python on the WRDS platform, including:

  • Establishing a connection to the WRDS server
  • Using the basic functions provided by the WRDS API

Momentum Strategy

Demonstration of how to run a momentum strategy using the WRDS Python API and the CRSP dataset.

  • Follows the momentum strategy as documented by Jegadeesh and Titman (1993)
  • Includes how to plot the return series

Python Virtual Environments

This tutorial for how to create Python virtual environments on the WRDS server covers:

  • Benefits of using a virtual environment
  • Steps for creating a virtual environment
  • Activating and deactivating a virtual environment
  • Using pip to install packages

OLS Regression in Python

Step-by-step instructions for how to run a basic regression in Python. Learn how to:

  • Install the required packages
  • Read data into Python
  • Fit a model
  • Obtain output from the model

Use SAS in Python: SASPy - Introduction 1

SASPy is a Python package which enables integration of SAS programs with Python programs. This video--the first in a 4-part series--presents a general overview of the package, including:

  • Reasons for using SASPy
  • Configuration for local computer
  • How to use SASPy on the WRDS Cloud

Use SAS in Python: SASPy - Introduction 2

This second video in the SASPy series introduces useful SASPy functions, as well as Jupyter magic for SAS. The tutorial includes:

  • Starting a SAS session
  • Submitting SAS jobs in a Python session
  • Exchanging data between SAS and Python
  • Transferring a Python variable to SAS macro variable

Use SAS in Python: SASPy - Introduction 3

This third video in the SASPy series demonstrates how to work with SASPy on WRDS Jupyter Hub. The tutorial covers many functions, including:

  • Advanced SAS data access using dataset options
  • Methods for submitting a SAS job
  • Transferring macro variables between SAS and Python

Use SAS in Python: SASPy - Introduction 4

This last video in the four-part series demonstrates a sample workflow using Python and SASPy running on a local PC. The example used is running an event study using CRSP data and a pre-written SAS macro.

Quick Intro to WRDS | Spanish

WRDS te guía a través de la plataforma y te presenta su página web en donde descargar datos, sus herramientas innovadoras, así como sus recursos integrales y de apoyo para el investigador.

  • Primeros Pasos
  • ¿Qué datos puedes encontrar en WRDS?
  • ¿Cómo hacer una descarga web?
  • Herramientas de Analytics creadas por WRDS
  • Herramientas para la Investigación, ejemplos de programación, y más
  • Herramientas de apoyo para el investigador.

 
Trial Data

Learn how to access sample sets of trial data at WRDS.

 
SAS Studio - Part 2

I explained how to login to SAS Studio and described some of the features in the screen layout. I will now explore a dataset. Here I am opening up the Compustat Daily North American Fundamentals dataset, called funda, which is used as the base dataset for the similarly named web query.

 
SAS Studio - Part 4

I explained how and where to store data on WRDS Cloud, the underlying server powering SAS/Studio. I will now go through an example process of uploading a file to my Home directory, running custom code to query data on WRDS, and download my results to my Home directory and or local computer.

 
SAS Studio - Part 3

I explored a dataset in SAS/Studio. I will now explain the different options for data storage on WRDS Cloud and how to access these folders in SAS/Studio. SAS/Studio runs on the WRDS Cloud, our high performance computing cluster. This means that, while you access it in your web browser on your computer, the SAS that runs underneath it runs on our powerful servers.

 
Intro to WRDS 13F Holdings - Training

Through parsing of the SEC 13F Holdings data reported in XML attachments, you can access details on holdings as well as well as summary information of equity positions held by institutional investors. As such format was mandated by the SEC after June 2013, the SEC 13F Holdings data is complete only for the period after that reporting date.

Intro IBES by WRDS - Training

I/B/E/S International Inc. created their Academic Research Program over 30 years ago to provide both summary and individual analyst forecasts of company earnings, cash flows, and other important financial items, as well as buy-sell-hold recommendations. In 2000, I/B/E/S was integrated with Thomson Reuters / First Call, and in 2012 First Call was discontinued.

 
Financial Data on WRDS - Training

Introduction Training to Compustat, CRSP, and WRDS Analytics.

Introduction to Classroom by WRDS - Training

Training overview of Classroom Tools by WRDS. These tools are a teaching and learning toolkit designed specifically for faculty who are introducing finance and business concepts in the classroom.

Introduction to Boardex on WRDS - Training

BoardEx contains valuable information on 1.7 million corporate executives and board members from over 2.2 million organizations. Biographical data includes details such as age, gender, positions held, educational qualifications, compensation and stock holdings, as well as insights into the executive's professional network.

SEC Analytics Suite by WRDS - Training

WRDS' proprietary SEC research platform is used in such disciplines as corporate due diligence, forensic accounting, disclosure research, and investment management. This teaching tool is designed to help you to learn more about the different components of the suite.