WRDS (Wharton Research Data Services)

Web Queries

Using the web-based query form to extract and output data in .txt, .csv, .xlsx, .dat, .sav, .dta, and etc.

1. Select Date Range

2. Select Database Search Method, the options include:

   1. Manually entering identifiers

   2. Uploading a text file containing a list of identifiers

   3. The entire database

3. Select Variables

4. Select Output Format

Find detailed introduction of WRDS Web Query in this video tutorial (Vimeo 10 min, 23 sec). 

To run web queries, make sure you have the following:

• A modern web browser such as Firefox, Chrome, Safari or Internet Explorer (IE10 or greater).
• Javascript, cookies, and pop-up windows enabled.

Detailed step-by-step directions (Must be logged in with a WRDS account to access this page)

The WRDS Cloud

WRDS provides a high-performance computing cluster, the WRDS Cloud. WRDS Data is easily accessible in your favorite programming language from your computer or on the WRDS Cloud.

The connection methods available are listed under each language.

Python Video Introduction (Vimeo 16 min, 56 sec) (tutorials and exemplar notebooks provided below requiring a WRDS account)

• A web browser (Jupyter Lab environment)
• Local Jupyter Notebook environment
• Local command line environment

R (tutorials provided below requiring a WRDS account)

• A web browser (RStudio Server environment)  
• Local R Studio environment
• Local command line environment

SAS (tutorials provided below requiring a WRDS account)

• A web browser (SAS Studio environment)  
• Local SAS (Connect) environment
• Local command line environment

More programming tutorials including Stata, MATLAP and PostgreSQL are available at WRDS Support/Programming