Skip to main content

Various tools to create a connection to the WRDS service and download commonly used data.

Project description

Wrds Tools

Tools for accessing compustat variables through WRDS by name.


To build a connection to the wrds server via python, a .pgpass file is required in the user's home directory, with access limited to the user. To create this file, follow the instructions here: How to access WRDS through Python (WRDS login required).

After creating the file, don't forget to run "chmod 0600 ~/.pgpass" in the console to limit access, as also described here.

Using package directly from github

Install import_from_github_com from your terminal to use this package directly from github.

pip3 install import_from_github_com

Or use your package manager (e.g., Conda).

Now you can use Wrds Tools by importing it from github.

import wrds
from github_com.julianbarg import wrds_tools


Build a connection to WRDS.

wrds = wrds_tools.WrdsConnection()
Loading library list...

Download all S&P 500 constituents from between 2002-2007.

from datetime import date

wrds.set_observation_period(start_date=date(year=2002, month=1, day=1), 
                            end_date=date(year=2007, month=12, day=31))
sp500 = wrds.return_dataframe()

Save your sample to a .csv and excel file.


Run custom wrds queries.

db = wrds.db

KLD_ratings = db.get_table('kld', 'history')

# get some basic financials
funda = db.raw_sql('select GVKEY, FYEAR, FIC, REVT, SALE, EMP, GP, CURCD from compa.funda')

Project details

Download files

Download the file for your platform. If you're not sure which to choose, learn more about installing packages.

Files for wrds-tools, version 0.0.10
Filename, size File type Python version Upload date Hashes
Filename, size wrds_tools-0.0.10-py3-none-any.whl (20.3 kB) File type Wheel Python version py3 Upload date Hashes View
Filename, size wrds_tools-0.0.10.tar.gz (8.0 kB) File type Source Python version None Upload date Hashes View

Supported by

AWS AWS Cloud computing Datadog Datadog Monitoring DigiCert DigiCert EV certificate Facebook / Instagram Facebook / Instagram PSF Sponsor Fastly Fastly CDN Google Google Object Storage and Download Analytics Pingdom Pingdom Monitoring Salesforce Salesforce PSF Sponsor Sentry Sentry Error logging StatusPage StatusPage Status page