Value Stock Screener (Milestone I Project)
This was an early project in the program, designed to create a data pipeline that scraped for the current S&P 500 ticker list, pulled data from Quandl (now Nasdaq) and Yahoo! Finance, and then through modular code filters for value stocks and returns a dataframe report of possible options and corresponding investing metrics.
1-Year returns from the stocks listed in the report were as follows (adj. prices as of 12/2021):
Symbol |
Price 09-25-2020 |
Price 09-24-2021 |
Return (Adj.) |
MET |
$36.26 ($34.69 adj) |
$61.36 ($60.90 adj) |
75.6% |
XRX |
$17.98 ($16.98 adj) |
$20.77 ($20.52 adj) |
20.8% |
HIG |
$35.80 ($34.36 adj) |
$69.40 ($69.01 adj) |
100.8% |
MS |
$47.04 ($45.61 adj) |
$102.91 ($102.20 adj) |
124.1% |
PNC |
$104.90 ($101.09 adj) |
$194.50 ($193.29 adj) |
91.2% |
KIM |
$11.22 ($10.76 adj) |
$21.60 ($21.44 adj) |
99.3% |
Given the success of the returns, I am in the process of refactoring the Jupyter Notebook scripts into OOP-based code instead of functions, and the selected securities (both these and subsequent iterations of the script outputs) are in paper trading for long-term efficacy in changing markets. Exit strategies are being researched in a back testing framework. Next steps include integration into bots for trading signals, or, regulations permitting, active trading bots.
Project Report