Investment Portfolio Automation with Python & Excel

Learn to create your own investment & swing trading portfolio, optimize and backtest strategies using Python and Excel.

In this course, you will be learning how to automate the process of picking stocks for investment, using python.

What you’ll learn

  • Automate the process of Investment portfolio creation using Python and Excel..
  • Create your portfolio of stocks by for swing trading and long term investment..
  • Optimize portfolio based on CAGR, sharpe ratio and volatility..
  • Backtest the portfolio with 10 years historical data..

Course Content

  • Welcome to the course –> 2 lectures • 3min.
  • Before we start –> 2 lectures • 2min.
  • Installing Python and libraries –> 2 lectures • 5min.
  • Defining your universe of stocks –> 2 lectures • 4min.
  • Swing trading portfolio –> 3 lectures • 17min.
  • Investment portfolio rebalancing –> 3 lectures • 9min.
  • Optional: A quick review of the code –> 1 lecture • 7min.
  • The End and footnotes –> 1 lecture • 1min.

Investment Portfolio Automation with Python & Excel

Requirements

  • Basic knowledge of Microsoft Excel (I mean the very basic like entering values, saving)..
  • Basic knowledge of Python (not mandatory, as you can still use this course to the fullest)..
  • A PC with Internet connection..
  • No programming experience needed. You will learn everything you need to know..

In this course, you will be learning how to automate the process of picking stocks for investment, using python.

We use Excel to provide our inputs to the code, and also get the output from the code.

 

Our objective here in this course is to create a portfolio of stocks, which can be used for 2 strategies,

1. Swing trading – which is buying certain stocks and holding it for a certain period (or) holding until the portfolio reached a desired return. This process will be repeated over and over.

2. Portfolio rebalancing – which is buying “n” number of stocks and holding it for a certain period, and after that removing  “x” number of underperforming stocks and adding alternate “x” number of stocks to the portfolio.

 

For both strategies, the code will also backtest with historical data of 10 years against any Index of your choice and compare performance, which will help you make right decisions.

 

For both strategies, we have the flexibility to set the timeframe to be 1 month (or) 1 week.

 

This course and the python code is designed in such a way that, anyone can use it, irrespective of your geography or proficiency in programming.

 

I’d love to see you inside the course! 🙂

Get Tutorial