1) Press and hold the Windows Key and then press x key 2) Select the Apps and Features item in the menu by let going of Windows key and pressing F (for Features) 3) Select the Programs and Features link on the right side of the page. 3) Select the Turn Windows feature on or…
Author: ryan
After working with Python/Flask/Sqlalchemy/Celery for last 3 months, including the downloading of close to 340 projects from github for examples of how to do certain things, I wanted to share some cool github projects that use Flask/other technologies: https://github.com/apache/incubator-superset – interesting business analytic dashboardhttps://github.com/apache/incubator-airflow – interesting task executorhttps://github.com/miguelgrinberg/flasky – blog sitehttps://github.com/miguelgrinberg/microblog – features for handling…
The visualizations of this market data blew my mind when I saw this for the first time.
I want to give an unsolicited shout-out to the one program that I recommend you download right this second: Everything Search (link). It’s a local file search tool which requires a few tweaks in settings (excluding %appdata%, windows, program files). The best about this is it’s fast, not resource intensive (except for when indexing files,…
A popular source of information are the filings held in the EDGAR database. EDGAR, the Electronic Data Gathering, Analysis, and Retrieval system, performs automated collection, validation, indexing, acceptance, and forwarding of submissions by companies and others who are required by law to file forms with the U.S. Securities and Exchange Commission SEC (U.S. Securities and…
https://www.youtube.com/watch?v=2Oe9ZqXVGME&t=2427s How To Download and Process SEC XBRL Data Directly from EDGAR ^https://github.com/altova/sec-xbrl thanks Alex $ python loadSECfilings.py -y 2014 -m 1 –f 2014 –t 2017 http://rankandfiled.com/ pretty cool
To run need to do two things (while in folder of python filename.py): 1) Run worker by executing the python program with the “worker” arguement: $ celery –A tasks worker –loglevel=info 2) Call the task aka run: $ python filename.py ####################### # grabhtml.py import requests from html import unescape class GrabHTML(object): def __init__(self): pass…
Python Script to insert CSV File into SQL Server Database import pandas as pd import csv import pyodbc import sys, os USERNAME = ‘sa’ PASSWORD = ‘password’ SERVER = ‘server’ DATABASE = ‘DATA’ DRIVERNAME = ‘ODBC Driver 13 for SQL Server’ cnxn = pyodbc.connect(‘Driver={‘+DRIVERNAME+’};Server=’+SERVER+’;Database=’+DATABASE+’;uid=’+USERNAME+’;pwd=’+PASSWORD) cur = cnxn.cursor() ##### using pandas grab first row for column…