My Python scripts to screen stocks using Financial Modeling Prep and other sources 🔍

These are value investing related Python scripts I wrote to search and filter stock-related metrics I like.

Working Python scripts relying on Financial Modeling Prep

upendra-screen - My six-step screen that programmatically determines ratios mentioned in Professor Kenneth Jeffrey Marshall's book Good Stocks Cheap
upendra-simple-dcf - Calculates present value of future cash flow using the DCF model. Inputs include discount rate, cash flow growth in best, worst and normal scenarios, margin of safety and more.
fprep-basic - Get started by making a basic Financial Modeling Prep call, view the output and extract a value you like
fprep-roce_best - Calculations for getting Return on Capital Employed (ROCE) of any company that meets a threshold along with other metrics like average ROCE over the years and my own magic number to compute ROCE growth, with output sorted in descending order
fprep-52week-low - Identifies companies that are close to their 52 week lows, meeting a threshold, with output sorted from closest to low
fprep-dcf-discount - Identifies companies that are trading at a discount compared to their DCF-based intrinsic value, with output sorted in descending order
list-of-companies - Gets a list of companies that are available with Financial Modeling Prep

buy_or_hold - This Python script analyzes S&P 500 data from 1999 to early 2020 (supplied as a CSV file) and figures out if buying after a threshold (%) drop in the markets is better or if dollar cost averaging is better.

Scraping Yahoo Finance with LXML (I have a working, published Android app on this if you're interested: https://play.google.com/store/apps/details?id=com.upen.rocecalculator)
Scraping Yahoo Finance with Beautiful Soup

Clone this project, then run the Python scripts using your IDE or the python command.

Name		Name	Last commit message	Last commit date
Latest commit History 26 Commits
.gitignore		.gitignore
README.MD		README.MD
buy_or_hold.py		buy_or_hold.py
db-table-query-descending-discount.sql		db-table-query-descending-discount.sql
dcfScreen.zip		dcfScreen.zip
diffcheck.py		diffcheck.py
fprep-52week-low.py		fprep-52week-low.py
fprep-basic.py		fprep-basic.py
fprep-dcf-discount.py		fprep-dcf-discount.py
fprep-roce_best.py		fprep-roce_best.py
list_of_companies.py		list_of_companies.py
roce-bsoup_new.py		roce-bsoup_new.py
roce_bsoup_old.py		roce_bsoup_old.py
roce_lxml_file_input.py		roce_lxml_file_input.py
roce_lxml_prompt.py		roce_lxml_prompt.py
russell-2000		russell-2000
screener-sqlite.py		screener-sqlite.py
sp500.py		sp500.py
stock--dcf-terminal.db		stock--dcf-terminal.db
stock-data.db		stock-data.db
stock-dcf-data.db		stock-dcf-data.db
stock-dcf-terminal.db		stock-dcf-terminal.db
test.py		test.py
upendra-dcf-with-terminal-value.py		upendra-dcf-with-terminal-value.py
upendra-screen.py		upendra-screen.py
upendra-simple-dcf.py		upendra-simple-dcf.py
yfinance-basic.py		yfinance-basic.py
yfinance.cache		yfinance.cache