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.

Setup

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

Example

Build a connection to WRDS.

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

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))
wrds.build_sp500()
wrds.add_names()
sp500 = wrds.return_dataframe()

Save your sample to a .csv and excel file.

sp500.to_csv('sp500.csv')
sp500.to_excel('sp500.xlsx')

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.

Source Distribution

wrds_tools-0.0.13.tar.gz (9.3 kB view details)

Uploaded Source

Built Distribution

wrds_tools-0.0.13-py3-none-any.whl (21.6 kB view details)

Uploaded Python 3

File details

Details for the file wrds_tools-0.0.13.tar.gz.

File metadata

  • Download URL: wrds_tools-0.0.13.tar.gz
  • Upload date:
  • Size: 9.3 kB
  • Tags: Source
  • Uploaded using Trusted Publishing? No
  • Uploaded via: twine/1.13.0 pkginfo/1.5.0.1 requests/2.21.0 setuptools/40.8.0 requests-toolbelt/0.9.1 tqdm/4.31.1 CPython/3.6.7

File hashes

Hashes for wrds_tools-0.0.13.tar.gz
Algorithm Hash digest
SHA256 bef7cc1b8b4fd6bde0b89c9848ec87a637a09be8cd5dafdb32724c82ae0418ea
MD5 dec44faf33b39e4803cc92fd9bb724f4
BLAKE2b-256 dd81e5340bc60f00e87f0120adb2a6465b7ea13cca2928c55482fba9a3dcd735

See more details on using hashes here.

File details

Details for the file wrds_tools-0.0.13-py3-none-any.whl.

File metadata

  • Download URL: wrds_tools-0.0.13-py3-none-any.whl
  • Upload date:
  • Size: 21.6 kB
  • Tags: Python 3
  • Uploaded using Trusted Publishing? No
  • Uploaded via: twine/1.13.0 pkginfo/1.5.0.1 requests/2.21.0 setuptools/40.8.0 requests-toolbelt/0.9.1 tqdm/4.31.1 CPython/3.6.7

File hashes

Hashes for wrds_tools-0.0.13-py3-none-any.whl
Algorithm Hash digest
SHA256 384fccf01ca94c8cf8534ba748467e6811622f09827e44232796c9baf4bfd836
MD5 13b03f0826219a087cc80c24116301fc
BLAKE2b-256 2c3a6650a8d6986250cc37ff841fdfdab405b9b53f3e3f96ebcb2740c40ba537

See more details on using hashes here.

Supported by

AWS Cloud computing and Security Sponsor Datadog Monitoring Fastly CDN Google Download Analytics Pingdom Monitoring Sentry Error logging StatusPage Status page