Scripted examples of Beta and RSI algorithms running against historical stock data from my yahoofinancials module. The resulting data frames are then pushed to a cloud base PostgreSQL Database. More algorithms are coming!
- An algorithm to solve for the beta values of a set of stocks against an index fund
- An algorithm to determine the RSI of a set of stocks
- sqlalchemy functionality to create PostgreSQL tables and to push results to the cloud
- Currently set up to only run on Python 3.x
- Make sure you have Python 3+ set up
- Clone this repository from git-hub
git clone https://github.com/JECSand/pandas_sqlalchemy_technical_analysis.git- Go to Amazon Web Services and spin up a PostgreSQL RDS Instance
- AWS PostgreSQL RDS - Some good documentation on how to get started with AWS RDS.
- Once the RDS Instance is up, grab the credentials from AWS and add them to lines 50-54 of the code.
- To start the script, enter:
python3 pandas_with_sqlalchemy.py- When the process is complete, your terminal window should show the following:
