placeholder.
Project description
🐋 equities
Overview:
equities allows for easy access to the SEC's XBRL Financial Statement Dataset
Parsed data is stored locally and served to the user in pandas dataframes
The Dataset:
https://www.sec.gov/dera/data/financial-statement-data-sets.html
Install:
pip3 install equities
Donate:
Consider donating bitcoin to fund the future development of this project.
bitcoin wallet address: 3LU5MEaAXRJoCo6vx67g1Jj7qDFRKhMs5t
TUTORIAL:
The library consists of two central objects, Universe and Company.
Universe:
Building the Universe
We begin by initializing our universe and downloading our sec data packages.
from equities import Universe
u = Universe()
Essential Methods
To get the number of companies in the universe call: len(u)
To get a dataframe of XBRL metadata from of all companies in the universe call:
u.properties()
"CIK" numbers are the sec's official unique identifier for public companies. To get a full list of the cik numbers call:
u.ciks()
Accessing Companies
Universe objects are indexable by "CIK" integers. As an example, to access the first company in the universe call:
first_cik = universe.ciks()[0]
u[first_cik] # This returns an Company object.
Company:
A Company object should be thought of as an abstract representation of a real company. Every company must have an associated Universe of origin.
from equities import Company
Accessing the Financial Statements
Consider the first Company in our universe, universe[u.ciks()[0]]. It is a Company object.
c = u[u.ciks()[0]]
Dataframes of the company's financial statements over the universe in question is given by:
c.income() # income statement dataframe
c.balance() # Balancesheet dataframe
c.cash() # Cash Flow Statement dataframe
c.equity() # Consolidated Equity dataframe
Additional Company Details
To get the XBRL metadata for a given company as a pandas series call:
c.properties()
Example
I really want to demonstrate the beauty of this dataset since this is often difficult when looking at thousands of numeric datatables. Let's take a very naive peek by plotting various statements as a kind of stacked timeseries.
The following is a start to finish example of how one might plot the financial statements of the first three companies in the universe.
To perform this experiment, run the following:
from equities import test
test()
Here is the code that this function executes:
import pandas as pd
from equities import Universe, Company
import matplotlib.pyplot as plt
u = Universe()
u.build()
k,f,s = 'bar',(20,10),True
for cik in u.ciks()[:3]:
u[cik].income().T.plot(
kind=k,
figsize=f,
stacked=s)
u[cik].cash().T.plot(
kind=k,
figsize=f,
stacked=s)
u[cik].balance().T.plot(
kind=k,
figsize=f,
stacked=s)
plt.show()
Project details
Release history Release notifications | RSS feed
Download files
Download the file for your platform. If you're not sure which to choose, learn more about installing packages.
Source Distribution
Built Distribution
File details
Details for the file polis-0.0.1.tar.gz
.
File metadata
- Download URL: polis-0.0.1.tar.gz
- Upload date:
- Size: 3.2 kB
- Tags: Source
- Uploaded using Trusted Publishing? No
- Uploaded via: twine/3.2.0 pkginfo/1.5.0.1 requests/2.24.0 setuptools/50.3.2 requests-toolbelt/0.9.1 tqdm/4.43.0 CPython/3.8.5
File hashes
Algorithm | Hash digest | |
---|---|---|
SHA256 | 6678ec90244f3c08da1ec13712f5ede95487a06aad329db24ef5928556d5d57d |
|
MD5 | 64fdabfb754bd58b41f7ad09f398580e |
|
BLAKE2b-256 | e96cb8a6450df4f77d34f4e76a82c7e8dc08b98bcc42244b39a3008e41b76f3b |
File details
Details for the file polis-0.0.1-py3-none-any.whl
.
File metadata
- Download URL: polis-0.0.1-py3-none-any.whl
- Upload date:
- Size: 3.4 kB
- Tags: Python 3
- Uploaded using Trusted Publishing? No
- Uploaded via: twine/3.2.0 pkginfo/1.5.0.1 requests/2.24.0 setuptools/50.3.2 requests-toolbelt/0.9.1 tqdm/4.43.0 CPython/3.8.5
File hashes
Algorithm | Hash digest | |
---|---|---|
SHA256 | 0f343f8bc35d150649defe4e90ec4d7394cceeab6656f105bc6cedd2a1e11fce |
|
MD5 | 2215c229a70ff3a5c232183e2dfcc818 |
|
BLAKE2b-256 | 7aae941d29846245839fb6bcad1e89eba01b8abdc458ae658975478fa57d21e4 |