shotahorii

shotahorii

shotahorii

shotahorii

shotahorii

shotahorii

import sqlite3
import pandas as pd
import functools as ft

class SqliteHandler:
    def __init__(self, dbname):
        self.dbname = dbname

    def df2table(self, tablename, df):
        # connect to db

shotahorii

shotahorii

import re
from requests import get
from bs4 import BeautifulSoup

# this is based on https://gist.github.com/dougvk/8499335
def ticker2cik(ticker):
    URL = 'http://www.sec.gov/cgi-bin/browse-edgar?CIK={}&Find=Search&owner=exclude&action=getcompany'
    CIK_RE = re.compile(r'\d{10}')

    soup = BeautifulSoup(get(URL.format(ticker)).content, "lxml")

shotahorii

shotahorii