{ "info": { "author": "Julian Barg", "author_email": "barg.julian@gmail.com", "bugtrack_url": null, "classifiers": [], "description": "# Wrds Tools\n\nTools for accessing compustat variables through WRDS by name.\n\n## Setup\n\nTo build a connection to the wrds server via python, a .pgpass file is required in the user's home \ndirectory, with access limited to the user. To create this file, follow the instructions here: ![How to access WRDS through Python](https://wrds-www.wharton.upenn.edu/pages/support/programming-wrds/programming-python/python-from-your-computer/) (WRDS login required).\n\nAfter creating the file, don't forget to run \"chmod 0600 ~/.pgpass\" in the console to limit access, ![as also described here](https://www.postgresql.org/docs/9.5/libpq-pgpass.html).\n\n### Using package directly from github\n\nInstall import_from_github_com from your terminal to use this package directly from github.\n\n```bash\npip3 install import_from_github_com\n```\nOr use your package manager (e.g., Conda).\n\nNow you can use Wrds Tools by importing it from github.\n```python\nimport wrds\nfrom github_com.julianbarg import wrds_tools\n```\n\n## Example\nBuild a connection to WRDS.\n```python\nwrds = wrds_tools.WrdsConnection()\n```\n```\nLoading library list...\nDone\n```\n\nDownload all S&P 500 constituents from between 2002-2007.\n```python\nfrom datetime import date\n\nwrds.set_observation_period(start_date=date(year=2002, month=1, day=1), \n end_date=date(year=2007, month=12, day=31))\nwrds.build_sp500()\nwrds.add_names()\nsp500 = wrds.return_dataframe()\n```\n\nSave your sample to a .csv and excel file.\n```python\nsp500.to_csv('sp500.csv')\nsp500.to_excel('sp500.xlsx')\n```\n\nRun custom wrds queries.\n```python\ndb = wrds.db\n\nKLD_ratings = db.get_table('kld', 'history')\n\n# get some basic financials\nfunda = db.raw_sql('select GVKEY, FYEAR, FIC, REVT, SALE, EMP, GP, CURCD from compa.funda')\n```\n\n\n", "description_content_type": "text/markdown", "docs_url": null, "download_url": "", "downloads": { "last_day": -1, "last_month": -1, "last_week": -1 }, "home_page": "", "keywords": "", "license": "", "maintainer": "", "maintainer_email": "", "name": "wrds-tools", "package_url": "https://pypi.org/project/wrds-tools/", "platform": "", "project_url": "https://pypi.org/project/wrds-tools/", "project_urls": null, "release_url": "https://pypi.org/project/wrds-tools/0.0.13/", "requires_dist": [ "pandas", "wrds" ], "requires_python": "", "summary": "Various tools to create a connection to the WRDS service and download commonly used data.", "version": "0.0.13" }, "last_serial": 5170808, "releases": { "0.0.1": [ { "comment_text": "", "digests": { "md5": "6e27b4a5abcbcd7090a0fa4f9c08ff26", "sha256": "61701dede7e0b5bdd37d6a98ddf1e85515bbbdd3f9a82a4802fe2a1414044c7f" }, "downloads": -1, "filename": "wrds_tools-0.0.1-py3-none-any.whl", "has_sig": false, "md5_digest": "6e27b4a5abcbcd7090a0fa4f9c08ff26", "packagetype": "bdist_wheel", "python_version": "py3", "requires_python": null, "size": 17023, "upload_time": "2019-03-08T16:22:25", "url": "https://files.pythonhosted.org/packages/b0/fa/7fb461e944471b2479359f6ac8abc5ec4c929132888e49987bfe7dd25fde/wrds_tools-0.0.1-py3-none-any.whl" }, { "comment_text": "", "digests": { "md5": "5daaee0632518326ba24bf5231330507", "sha256": "35afb439e89f94d7f63ba9d667675b7a9a6e8474ad99e72f86796c49e14462f8" }, "downloads": -1, "filename": "wrds_tools-0.0.1.tar.gz", "has_sig": false, "md5_digest": "5daaee0632518326ba24bf5231330507", "packagetype": "sdist", "python_version": "source", "requires_python": null, "size": 4675, "upload_time": "2019-03-08T16:22:27", "url": "https://files.pythonhosted.org/packages/f1/52/ba618214e1c54f3fc757f666b408493d7c19446febbb8679de7772d6eb7a/wrds_tools-0.0.1.tar.gz" } ], "0.0.10": [ { "comment_text": "", "digests": { "md5": "ef392010803774e146f4090ba5aaf0ff", "sha256": "08a7128d7633fec9686aba74f0a5067f248bc09f80dd2df7142fb4973eeae882" }, "downloads": -1, "filename": "wrds_tools-0.0.10-py3-none-any.whl", "has_sig": false, "md5_digest": "ef392010803774e146f4090ba5aaf0ff", "packagetype": "bdist_wheel", "python_version": "py3", "requires_python": null, "size": 20313, "upload_time": "2019-04-18T20:30:54", "url": "https://files.pythonhosted.org/packages/38/88/69efdd28e3deffaaf6707b30ce363c400f6cf429e34f66ebedb93d280fbf/wrds_tools-0.0.10-py3-none-any.whl" }, { "comment_text": "", "digests": { "md5": "3720efce7f4ad91f6b671ffe1a76e2c0", "sha256": "b30b2b6aad68c448fcc6e5eedca9815c4d4b29a773e252f89d85143dd922c589" }, "downloads": -1, "filename": "wrds_tools-0.0.10.tar.gz", "has_sig": false, "md5_digest": "3720efce7f4ad91f6b671ffe1a76e2c0", "packagetype": "sdist", "python_version": "source", "requires_python": null, "size": 8017, "upload_time": "2019-04-18T20:30:58", "url": "https://files.pythonhosted.org/packages/4a/6f/54e49cf5f4441f20970fa29f53d7d0a0775e2a82a827642e4d8863a6e982/wrds_tools-0.0.10.tar.gz" } ], "0.0.11": [ { "comment_text": "", "digests": { "md5": "055ad3ea9dc9da31466ced5bef74b448", "sha256": "54f9755c4463718ef8202a5e1d726f94f03c089be2fd08abbb68509a7b61aa6c" }, "downloads": -1, "filename": "wrds_tools-0.0.11-py3-none-any.whl", "has_sig": false, "md5_digest": "055ad3ea9dc9da31466ced5bef74b448", "packagetype": "bdist_wheel", "python_version": "py3", "requires_python": null, "size": 21582, "upload_time": "2019-04-21T21:18:36", "url": "https://files.pythonhosted.org/packages/07/04/cc182a224e328193217c557201e28b1abc89f394e534aff714c6c257daa3/wrds_tools-0.0.11-py3-none-any.whl" }, { "comment_text": "", "digests": { "md5": "aa263119b54715981e207450d87b24f7", "sha256": "f13af23fa411d84f808d5a49814a6ad82428e980cd4bae2a5e309febfd0c15dd" }, "downloads": -1, "filename": "wrds_tools-0.0.11.tar.gz", "has_sig": false, "md5_digest": "aa263119b54715981e207450d87b24f7", "packagetype": "sdist", "python_version": "source", "requires_python": null, "size": 9287, "upload_time": "2019-04-21T21:18:41", "url": "https://files.pythonhosted.org/packages/b2/24/7c848b895e36fd5fe4e7eaa8de9ec84a614975176ccc756c771d549968e5/wrds_tools-0.0.11.tar.gz" } ], "0.0.12": [ { "comment_text": "", "digests": { "md5": "62161286a8938bef1369990cbe961b8f", "sha256": "f496e0b628055c60c35eb09343d1be08b8a12ceed347fa7bcb1181add0850156" }, "downloads": -1, "filename": "wrds_tools-0.0.12-py3-none-any.whl", "has_sig": false, "md5_digest": "62161286a8938bef1369990cbe961b8f", "packagetype": "bdist_wheel", "python_version": "py3", "requires_python": null, "size": 21583, "upload_time": "2019-04-21T21:58:58", "url": "https://files.pythonhosted.org/packages/20/77/84e4ead1b7473e9b92388954c86d9180e14ee0ff2accb378cd1232b335b6/wrds_tools-0.0.12-py3-none-any.whl" }, { "comment_text": "", "digests": { "md5": "92888dc794db96353ed4d483d988cd2a", "sha256": "9769abe66b34a9ae98cecb218dd4ef999e8702d5fe9d88d82b24414719faad84" }, "downloads": -1, "filename": "wrds_tools-0.0.12.tar.gz", "has_sig": false, "md5_digest": "92888dc794db96353ed4d483d988cd2a", "packagetype": "sdist", "python_version": "source", "requires_python": null, "size": 9288, "upload_time": "2019-04-21T21:59:03", "url": "https://files.pythonhosted.org/packages/f1/84/ae7a6a7fdcbed252f2aff99d88233a7cdd43d002c436991d2abb25ca71c7/wrds_tools-0.0.12.tar.gz" } ], "0.0.13": [ { "comment_text": "", "digests": { "md5": "13b03f0826219a087cc80c24116301fc", "sha256": "384fccf01ca94c8cf8534ba748467e6811622f09827e44232796c9baf4bfd836" }, "downloads": -1, "filename": "wrds_tools-0.0.13-py3-none-any.whl", "has_sig": false, "md5_digest": "13b03f0826219a087cc80c24116301fc", "packagetype": "bdist_wheel", "python_version": "py3", "requires_python": null, "size": 21582, "upload_time": "2019-04-21T22:31:55", "url": "https://files.pythonhosted.org/packages/2c/3a/6650a8d6986250cc37ff841fdfdab405b9b53f3e3f96ebcb2740c40ba537/wrds_tools-0.0.13-py3-none-any.whl" }, { "comment_text": "", "digests": { "md5": "dec44faf33b39e4803cc92fd9bb724f4", "sha256": "bef7cc1b8b4fd6bde0b89c9848ec87a637a09be8cd5dafdb32724c82ae0418ea" }, "downloads": -1, "filename": "wrds_tools-0.0.13.tar.gz", "has_sig": false, "md5_digest": "dec44faf33b39e4803cc92fd9bb724f4", "packagetype": "sdist", "python_version": "source", "requires_python": null, "size": 9286, "upload_time": "2019-04-21T22:31:59", "url": "https://files.pythonhosted.org/packages/dd/81/e5340bc60f00e87f0120adb2a6465b7ea13cca2928c55482fba9a3dcd735/wrds_tools-0.0.13.tar.gz" } ], "0.0.2": [ { "comment_text": "", "digests": { "md5": "42c7dbc8b16f2bdb26af726776bdc674", "sha256": "39d84578f7de4f33c68668cf2f93ecbae4435bf9d4fdcca0f0ad17d710e5b9ae" }, "downloads": -1, "filename": "wrds_tools-0.0.2-py3-none-any.whl", "has_sig": false, "md5_digest": "42c7dbc8b16f2bdb26af726776bdc674", "packagetype": "bdist_wheel", "python_version": "py3", "requires_python": null, "size": 16940, "upload_time": "2019-03-08T20:30:37", "url": "https://files.pythonhosted.org/packages/21/99/2000ebd18a4445e7c0f675116923c7dda2d0030ebf4ecc2834a22937f7fd/wrds_tools-0.0.2-py3-none-any.whl" }, { "comment_text": "", "digests": { "md5": "cdc0b5a6c368e3b39cddaf1e9fcabf42", "sha256": "017f83eb0b5d21340381f1240531639f0f21457b54e9bc9a052616e9954fd5b5" }, "downloads": -1, "filename": "wrds_tools-0.0.2.tar.gz", "has_sig": false, "md5_digest": "cdc0b5a6c368e3b39cddaf1e9fcabf42", "packagetype": "sdist", "python_version": "source", "requires_python": null, "size": 4603, "upload_time": "2019-03-08T20:30:39", "url": "https://files.pythonhosted.org/packages/d7/29/1e1753528da17af75de308b24d0e3ce9958749ceb1218cb8896990b6ec05/wrds_tools-0.0.2.tar.gz" } ], "0.0.3": [ { "comment_text": "", "digests": { "md5": "5fbd5ccb7a791751498db99ce0d83b80", "sha256": "dab4eb404df03d7be2c6289162060401a88f04e6eed32997d69b4fb7927e8843" }, "downloads": -1, "filename": "wrds_tools-0.0.3-py3-none-any.whl", "has_sig": false, "md5_digest": "5fbd5ccb7a791751498db99ce0d83b80", "packagetype": "bdist_wheel", "python_version": "py3", "requires_python": null, "size": 17899, "upload_time": "2019-03-14T01:03:06", "url": "https://files.pythonhosted.org/packages/40/1d/a5c4b982ae0c68e54246ec73c79dfb4bda4b4671a1b362588eea7bed9aba/wrds_tools-0.0.3-py3-none-any.whl" }, { "comment_text": "", "digests": { "md5": "fd80f5b80660b20e8d080c5b44e168de", "sha256": "a690c5ff50c360e32c179a44686a99dee1219989a697c03bc9c04a810cb2b297" }, "downloads": -1, "filename": "wrds_tools-0.0.3.tar.gz", "has_sig": false, "md5_digest": "fd80f5b80660b20e8d080c5b44e168de", "packagetype": "sdist", "python_version": "source", "requires_python": null, "size": 5609, "upload_time": "2019-03-14T01:03:09", "url": "https://files.pythonhosted.org/packages/db/c6/ee171457168a5e5ab45e1d7a80bf71d548e1651666bdbdf527e511de0184/wrds_tools-0.0.3.tar.gz" } ], "0.0.3.1": [ { "comment_text": "", "digests": { "md5": "52843bf6af08bb7a63ac116c3c5a0e74", "sha256": "6bbf54cbdfc00953a2af93d21d02ef33f04d05dcf96874a3c045cb6ded4d8a4b" }, "downloads": -1, "filename": "wrds_tools-0.0.3.1-py3-none-any.whl", "has_sig": false, "md5_digest": "52843bf6af08bb7a63ac116c3c5a0e74", "packagetype": "bdist_wheel", "python_version": "py3", "requires_python": null, "size": 17922, "upload_time": "2019-03-14T01:42:59", "url": "https://files.pythonhosted.org/packages/d7/34/e640d38e0125df840e4075076ac34a642263c43cb0a0c9c81624ec8f1d5b/wrds_tools-0.0.3.1-py3-none-any.whl" } ], "0.0.4": [ { "comment_text": "", "digests": { "md5": "8e00b896e1579652bfbd98b05ca5a15d", "sha256": "64eb7ac77fe852780093aa786beac88afb1ac733d231b97475753de194277582" }, "downloads": -1, "filename": "wrds_tools-0.0.4-py3-none-any.whl", "has_sig": false, "md5_digest": "8e00b896e1579652bfbd98b05ca5a15d", "packagetype": "bdist_wheel", "python_version": "py3", "requires_python": null, "size": 17892, "upload_time": "2019-03-14T01:48:16", "url": "https://files.pythonhosted.org/packages/e3/a9/bec76a8885d4ea10359b7e6dc500d5c48fd8a10ace0e8e94cb60e2ea7a72/wrds_tools-0.0.4-py3-none-any.whl" }, { "comment_text": "", "digests": { "md5": "0233e3813d1a927f0d5ee86851cb1189", "sha256": "0741de4179dcb63c45b350fb9180f474e70fb4281d713afa822b6b1991d9c83f" }, "downloads": -1, "filename": "wrds_tools-0.0.4.tar.gz", "has_sig": false, "md5_digest": "0233e3813d1a927f0d5ee86851cb1189", "packagetype": "sdist", "python_version": "source", "requires_python": null, "size": 5607, "upload_time": "2019-03-14T01:48:18", "url": "https://files.pythonhosted.org/packages/1e/27/070139a984ee73a1dc5e070a24c81362d73e3b964cfb8736a5ddb765ec85/wrds_tools-0.0.4.tar.gz" } ], "0.0.5": [ { "comment_text": "", "digests": { "md5": "c07eb57267e76c44fe95d14186d7b9db", "sha256": "32822b7a9c95340d10761c8d56dc7c9508cabe64900eea0c66fe19f2ade00da6" }, "downloads": -1, "filename": "wrds_tools-0.0.5-py3-none-any.whl", "has_sig": false, "md5_digest": "c07eb57267e76c44fe95d14186d7b9db", "packagetype": "bdist_wheel", "python_version": "py3", "requires_python": null, "size": 18830, "upload_time": "2019-03-15T21:54:54", "url": "https://files.pythonhosted.org/packages/02/b9/4a83cc9ed36f4863049f1a47fbc52045403258785e570e47fe112f2fdc0d/wrds_tools-0.0.5-py3-none-any.whl" }, { "comment_text": "", "digests": { "md5": "71c60d2380afc6468b9788d0491d3254", "sha256": "b002a552c5b9b307049a230005aa873dec865bf9901729a75edf88840c3507f5" }, "downloads": -1, "filename": "wrds_tools-0.0.5.tar.gz", "has_sig": false, "md5_digest": "71c60d2380afc6468b9788d0491d3254", "packagetype": "sdist", "python_version": "source", "requires_python": null, "size": 6526, "upload_time": "2019-03-15T21:54:57", "url": "https://files.pythonhosted.org/packages/94/36/d23110c4b7fd5dd08ddc9bf1219c392781bff71f27342651dcb5532b5188/wrds_tools-0.0.5.tar.gz" } ], "0.0.6": [ { "comment_text": "", "digests": { "md5": "6124c601134b784953b1981bcea2a8e5", "sha256": "1f10380a12258bf942d2c82918e42b68f43d5efc0719f69859774f08fa8b14a8" }, "downloads": -1, "filename": "wrds_tools-0.0.6-py3-none-any.whl", "has_sig": false, "md5_digest": "6124c601134b784953b1981bcea2a8e5", "packagetype": "bdist_wheel", "python_version": "py3", "requires_python": null, "size": 20009, "upload_time": "2019-03-16T17:58:04", "url": "https://files.pythonhosted.org/packages/40/3c/2b2a0457caa03a1878cc5db3b20e4e294c03925f124c33341d648ae9ff04/wrds_tools-0.0.6-py3-none-any.whl" }, { "comment_text": "", "digests": { "md5": "03b0dc4e3d1b994f04bb2deda460091b", "sha256": "9f251d65c1e99a3b89468643e948b635eabeef92db5c6c7570eea5f7f7dde0f0" }, "downloads": -1, "filename": "wrds_tools-0.0.6.tar.gz", "has_sig": false, "md5_digest": "03b0dc4e3d1b994f04bb2deda460091b", "packagetype": "sdist", "python_version": "source", "requires_python": null, "size": 7052, "upload_time": "2019-03-16T17:58:08", "url": "https://files.pythonhosted.org/packages/e7/ee/61c9e0c576c4032dfb5b429a39560f91bb1239a964fa44168cfeef910d14/wrds_tools-0.0.6.tar.gz" } ], "0.0.7": [ { "comment_text": "", "digests": { "md5": "87d079b249767a2c787b47e4452e3686", "sha256": "250251173af6bccbdd3d8446170955835d8e3707fa3e39fc77dd06d6920c8d27" }, "downloads": -1, "filename": "wrds_tools-0.0.7-py3-none-any.whl", "has_sig": false, "md5_digest": "87d079b249767a2c787b47e4452e3686", "packagetype": "bdist_wheel", "python_version": "py3", "requires_python": null, "size": 20021, "upload_time": "2019-03-16T18:33:53", "url": "https://files.pythonhosted.org/packages/1a/1b/1ae9dc28139c84d440053a21e63e494888bf5626abdc96965cd73f51d2e2/wrds_tools-0.0.7-py3-none-any.whl" }, { "comment_text": "", "digests": { "md5": "7a9da876e9cb05bc154a1d709353aaa5", "sha256": "8bfda4b9a378bfb370535abf2f5fd4e57dbf553d8ac0db51dd01fdcb43031375" }, "downloads": -1, "filename": "wrds_tools-0.0.7.tar.gz", "has_sig": false, "md5_digest": "7a9da876e9cb05bc154a1d709353aaa5", "packagetype": "sdist", "python_version": "source", "requires_python": null, "size": 7059, "upload_time": "2019-03-16T18:33:57", "url": "https://files.pythonhosted.org/packages/87/a1/845e7ed9d5148a31396ec6a5194a50b3bfd08a0fe9d06ccd06d7a15bf1c5/wrds_tools-0.0.7.tar.gz" } ], "0.0.8": [ { "comment_text": "", "digests": { "md5": "97e4251ddcb215d3d0015ae6ef5ef08e", "sha256": "7c363da64d11872afca3cfba99dbc12f379a1a47909606a30d12594ddc2d7125" }, "downloads": -1, "filename": "wrds_tools-0.0.8-py3-none-any.whl", "has_sig": false, "md5_digest": "97e4251ddcb215d3d0015ae6ef5ef08e", "packagetype": "bdist_wheel", "python_version": "py3", "requires_python": null, "size": 20210, "upload_time": "2019-04-18T17:29:33", "url": "https://files.pythonhosted.org/packages/9e/59/83e197c86bd3623319db8564f5d538c1d41730e4a8c89869b9479798e124/wrds_tools-0.0.8-py3-none-any.whl" }, { "comment_text": "", "digests": { "md5": "02958e48ad315c4a072d0a274cb9b61f", "sha256": "7b7398bef431024fa57a24e8bb411712b2c10459e07a659dfabdfbd84e81b1ca" }, "downloads": -1, "filename": "wrds_tools-0.0.8.tar.gz", "has_sig": false, "md5_digest": "02958e48ad315c4a072d0a274cb9b61f", "packagetype": "sdist", "python_version": "source", "requires_python": null, "size": 7922, "upload_time": "2019-04-18T17:29:37", "url": "https://files.pythonhosted.org/packages/1c/28/c2b80537e84028b7c8fe44ec847a98520048f2d1927f252152b179f4df11/wrds_tools-0.0.8.tar.gz" } ], "0.0.9": [ { "comment_text": "", "digests": { "md5": "5247eb22a3c62fd261bf614c0ec92f15", "sha256": "175dc98debe4eb458a4d0bb4231b3df717d7626126262633d9e8be2828e113df" }, "downloads": -1, "filename": "wrds_tools-0.0.9-py3-none-any.whl", "has_sig": false, "md5_digest": "5247eb22a3c62fd261bf614c0ec92f15", "packagetype": "bdist_wheel", "python_version": "py3", "requires_python": null, "size": 20250, "upload_time": "2019-04-18T18:42:18", "url": "https://files.pythonhosted.org/packages/50/1c/a7df18b776aa6b097ad26a67126d3634eab64dfb2ecee5e813fdc7c21bb5/wrds_tools-0.0.9-py3-none-any.whl" }, { "comment_text": "", "digests": { "md5": "10d7359d27a2baa671b83e96af235d3e", "sha256": "806a9cf2b71b30a650ea10cdd1d36654f91377a8772ba8b58763599ab850d20a" }, "downloads": -1, "filename": "wrds_tools-0.0.9.tar.gz", "has_sig": false, "md5_digest": "10d7359d27a2baa671b83e96af235d3e", "packagetype": "sdist", "python_version": "source", "requires_python": null, "size": 7958, "upload_time": "2019-04-18T18:42:22", "url": "https://files.pythonhosted.org/packages/22/9a/cf72be27c69ac983daf9aeb773cf74cfb942f0c97a70ec9ea0a27332cc96/wrds_tools-0.0.9.tar.gz" } ] }, "urls": [ { "comment_text": "", "digests": { "md5": "13b03f0826219a087cc80c24116301fc", "sha256": "384fccf01ca94c8cf8534ba748467e6811622f09827e44232796c9baf4bfd836" }, "downloads": -1, "filename": "wrds_tools-0.0.13-py3-none-any.whl", "has_sig": false, "md5_digest": "13b03f0826219a087cc80c24116301fc", "packagetype": "bdist_wheel", "python_version": "py3", "requires_python": null, "size": 21582, "upload_time": "2019-04-21T22:31:55", "url": "https://files.pythonhosted.org/packages/2c/3a/6650a8d6986250cc37ff841fdfdab405b9b53f3e3f96ebcb2740c40ba537/wrds_tools-0.0.13-py3-none-any.whl" }, { "comment_text": "", "digests": { "md5": "dec44faf33b39e4803cc92fd9bb724f4", "sha256": "bef7cc1b8b4fd6bde0b89c9848ec87a637a09be8cd5dafdb32724c82ae0418ea" }, "downloads": -1, "filename": "wrds_tools-0.0.13.tar.gz", "has_sig": false, "md5_digest": "dec44faf33b39e4803cc92fd9bb724f4", "packagetype": "sdist", "python_version": "source", "requires_python": null, "size": 9286, "upload_time": "2019-04-21T22:31:59", "url": "https://files.pythonhosted.org/packages/dd/81/e5340bc60f00e87f0120adb2a6465b7ea13cca2928c55482fba9a3dcd735/wrds_tools-0.0.13.tar.gz" } ] }