#Post Modern Portfolio Theory Based Portfolio Analysis and Optimization
The project is about the Post-Modern Portfolio Theory (MPT) based analysis and optimization of a given portfolio’s returns based on individual investors’ risk tolerance. It is a continuation and evolution of the original project referenced in contributions section below.
The project tries to solve a typical business problem of a Portfolio Manager to find an optimal construction of an investment portfolio.
Let's take a business scenario as described below.
The Modern Portfolio Theory has two main fundamentals:
- a portfolio’s total risk and return profile is more important than the risk/return profile of any individual investment, and
- it is possible for an investor to build a diversified portfolio comprising of multiple assets or investments that will maximize returns while limiting risk.
The above points are built upon an understanding of three key concepts:
- the risk-return relationship,
- the role of diversification in building an investment portfolio, and
- the efficient frontier representing the combination offering the best possible expected return for given risk level.
This project leverages python 3.7.* with the following additional packages:
- Jupyter Notebook - The main module of the Financial Planner is written in Jupyter Notebook.
- Conda - Conda environment is recommended to have Pandas library and other dependencies pre-installed.
Required Libraries:
You may need the following libraries to work with the application.
- Pandas - pandas is a Python package providing fast, flexible, and expressive data structures designed to make working with “relational” or “labeled” data both easy and intuitive.
- NumPy - NumPy is the fundamental package for scientific computing in Python.
- yfinance - Download market data from Yahoo! Finance's API
- SQLAlchemy - SQLAlchemy is the Python SQL toolkit and Object Relational Mapper that gives application developers the full power and flexibility of SQL.
import pandas as pd import sqlalchemy as sql import numpy as np import scipy as sci import matplotlib.pyplot as plt import scipy.optimize as sco
import yfinance as yf
import hvplot.pandas import holoviews as hv import seaborn as sns import copy
from pathlib import Path
from pandas_datareader import data as pdr from pandas import Timestamp as tstamp from pandas import read_csv as rcsv from pandas import read_sql_query as rsqq from sqlalchemy import ( create_engine as ce, inspect )
from datetime import date from datetime import timedelta from scipy import stats
from MCForecastTools import MCSimulation from calculations import MPTCalculations as mpt from metrics import QuantMetrics as qm from dataset import DataCollection as ds
import warnings
This project leverages Jupyter Lab v3.4.4 and python v3.7 with the following packages:
import os
-
pandas - Software library written for the python programming language for data manipulation and analysis.
-
read_csv - From 'pandas', reads a comma-separated values (csv) file into DataFrame.
-
concat - From 'pandas', concatenate pandas objects along a particular axis, allows optional set logic along the other axes.
-
numpy - Software library, NumPy is the fundamental package for scientific computing in Python, provides vast functionality.
-
Path - From pathlib - Object-oriented filesystem paths, Path instantiates a concrete path for the platform the code is running on.
-
hvplot - provides a high-level plotting API built on HoloViews that provides a general and consistent API for plotting data into numerous formats listed within linked documentation.
MacBook Pro (16-inch, 2021)
Chip Appple M1 Max
macOS Monterey version 12.6
Homebrew 3.5.10
Homebrew/homebrew-core (git revision 0b6b6d9004e; last commit 2022-08-30)
Homebrew/homebrew-cask (git revision 63ae652861; last commit 2022-08-30)
anaconda Command line client 1.10.0
conda 4.13.0
Python 3.9
pip 22.1.2 from /opt/anaconda3/envs/dev/lib/python3.7/site-packages/pip (python 3.7)
git version 2.37.2
In the terminal, navigate to directory where you want to install this application from the repository and enter the following command
git clone git@github.com:Billie-LS/Portfolio_Optimize_PMPT.gitFrom terminal, the installed application is run through jupyter lab web-based interactive development environment (IDE) interface by typing at prompt:
> jupyter labThe file you will run is:
nmpt.ipynbSkylizard, Loki 'billie' GitHub LinkedIn
Modern Portfolio Theory Based Portfolio Analysis and Optimization
Peers of FinTech Blended Boot Camp, Columbia Engineering (2022-23 Batch)
MIT License
Copyright (c) [2022] [Loki 'billie' Skylizard]
Permission is hereby granted, free of charge, to any person obtaining a copy of this software and associated documentation files (the "Software"), to deal in the Software without restriction, including without limitation the rights to use, copy, modify, merge, publish, distribute, sublicense, and/or sell copies of the Software, and to permit persons to whom the Software is furnished to do so, subject to the following conditions:
The above copyright notice and this permission notice shall be included in all copies or substantial portions of the Software.
THE SOFTWARE IS PROVIDED "AS IS", WITHOUT WARRANTY OF ANY KIND, EXPRESS OR IMPLIED, INCLUDING BUT NOT LIMITED TO THE WARRANTIES OF MERCHANTABILITY, FITNESS FOR A PARTICULAR PURPOSE AND NONINFRINGEMENT. IN NO EVENT SHALL THE AUTHORS OR COPYRIGHT HOLDERS BE LIABLE FOR ANY CLAIM, DAMAGES OR OTHER LIABILITY, WHETHER IN AN ACTION OF CONTRACT, TORT OR OTHERWISE, ARISING FROM, OUT OF OR IN CONNECTION WITH THE SOFTWARE OR THE USE OR OTHER DEALINGS IN THE SOFTWARE.