Skip to content

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 based PostgreSQL Database. More algorithms are coming!

License

Notifications You must be signed in to change notification settings

JECSand/pandas_sqlalchemy_technical_analysis

Folders and files

NameName
Last commit message
Last commit date

Latest commit

 

History

2 Commits
 
 
 
 
 
 

Repository files navigation

pandas_sqlalchemy_technical_analysis

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!

Features

  • 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

How to use

  1. Make sure you have Python 3+ set up
  2. Clone this repository from git-hub
git clone https://github.com/JECSand/pandas_sqlalchemy_technical_analysis.git
  1. Go to Amazon Web Services and spin up a PostgreSQL RDS Instance
  1. Once the RDS Instance is up, grab the credentials from AWS and add them to lines 50-54 of the code.
  2. To start the script, enter:
python3 pandas_with_sqlalchemy.py
  1. When the process is complete, your terminal window should show the following: Screenshot_from_2017-10-26_09-50-07.png

Coming Soon!

More Algorithms to be added!

About

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 based PostgreSQL Database. More algorithms are coming!

Resources

License

Stars

Watchers

Forks

Releases

No releases published

Packages

No packages published

Languages