Lirsen Myrtaj
Corrected time not defined issue (#35)
956cded
raw
history blame
9.58 kB
import streamlit as st
from datetime import date, timedelta
#from rest_api.fetch_data import (get_symbol_data)
import pandas as pd
from plots import (
beta,
basic_portfolio,
# display_portfolio_return,
display_heat_map,
#circle_packing,
ER,
buble_interactive
)
### Koi
from ef import(
ef_viz
)
def risk_str(num):
if num >=5 and num <15:
return 'Low Risk Aversion'
elif num >= 15 and num <25:
return 'Medium Risk Aversion'
elif num >= 25 and num <=35:
return 'High Rish Aversion'
#### Koi
from sharp_ratio import(
cumulative_return,
preprocess,
sharp_ratio_func
)
def risk_str(num):
if num >=5 and num <15:
return 'Low Risk Aversion'
elif num >= 15 and num <25:
return 'Medium Risk Aversion'
elif num >= 25 and num <=35:
return 'High Rish Aversion'
#### Koi
def load_heading():
"""The function that displays the heading.
Provides instructions to the user
"""
with st.container():
st.title('Dataminers')
header = st.subheader('This App performs historical portfolio analysis and future analysis ')
st.subheader('Please read the instructions carefully and enjoy!')
# st.text('This is some text.')
def get_choices():
"""Prompts the dialog to get the All Choices.
Returns:
An object of choices and an object of combined dataframes.
"""
choices = {}
#tab1, tab2, tab3, tab4, tab5 = st.tabs(["Tickers", "Quantity", "Benchmark","Risk Free Return","Risk Aversion"])
tickers = st.sidebar.text_input('Enter stock tickers.', 'GOOG,A,AVOG,AMD')
# Set the weights
weights_str = st.sidebar.text_input('Enter the investment quantities', '50,30,25,25')
benchmark = st.sidebar.selectbox(
'Select your ideal benchmark of return',
('SP500', 'AOK', 'IXIC'))
if benchmark == 'IXIC':
st.sidebar.warning("You have selected a volatile benchmark.")
elif benchmark == 'SP500':
st.sidebar.success('You have selected a balanced benchmark')
elif benchmark == 'AOK':
st.sidebar.success('You have selected a conservative benchmark')
### koi
rf = st.sidebar.number_input('Enter current rate of risk free return', min_value=0.001, max_value=1.00, value=0.041)
#A_coef_map =
A_coef = st.sidebar.slider('Enter The Coefficient of Risk Aversion', min_value=5, max_value=35, value=30, step=5)
if A_coef > 20:
st.sidebar.success("You have selected a "+ risk_str(A_coef) +" investing style")
investing_style = 'Conservative'
elif A_coef >10 and A_coef <= 20:
st.sidebar.success("You have selected a "+risk_str(A_coef) +" investing style")
investing_style = 'Balanced'
elif A_coef <= 10:
st.sidebar.warning("You have selected a "+ risk_str(A_coef) +" investing style")
investing_style = 'Risky'
# Every form must have a submit button.
submitted = st.sidebar.button("Calculate")
symbols = []
reset = False
# Reusable Error Button DRY!
#def reset_app(error):
# st.sidebar.write(f"{error}!")
# st.sidebar.write(f"Check The Syntax")
# reset = st.sidebar.button("RESET APP")
if submitted:
#with st.spinner('Running the calculations...'):
# time.sleep(8)
# st.success('Done!')
# convert strings to lists
tickers_list = tickers.split(",")
weights_list = weights_str.split(",")
#crypto_symbols_list = crypto_symbols.split(",")
# Create the Symbols List
symbols.extend(tickers_list)
#symbols.extend(crypto_symbols_list)
# Convert Weights To Decimals
weights = []
for item in weights_list:
weights.append(float(item))
if reset:
# # Clears all singleton caches:
#tickers = st.sidebar.selectbox('Enter 11 stock symbols.', ('GOOG','D','AAP','BLK'))
# crypto_symbols = st.sidebar.text_input('Enter 2 crypto symbols only as below', 'BTC-USD,ETH-USD')
#weights_str = st.sidebar.text_input('Enter The Investment Weights', '0.3,0.3 ,0.3')
st.experimental_singleton.clear()
else:
# Submit an object with choices
choices = {
'symbols': symbols,
'weights': weights,
'benchmark': benchmark,
'investing_style': investing_style,
'risk-free-rate': rf,
'A-coef': A_coef
}
# Load combined_df
data = pd.read_csv('data_and_sp500.csv')
combined_df = data[tickers_list]
raw_data=pd.read_csv('us-shareprices-daily.csv', sep=';')
# return object of objects
return {
'choices': choices,
'combined_df': combined_df,
'data': data,
'raw_data':raw_data
}
def run():
"""The main function for running the script."""
load_heading()
choices = get_choices()
if choices:
st.success('''** Selected Tickers **''')
buble_interactive(choices['data'],choices['choices'])
st.header('Tickers Beta')
"""
The Capital Asset Pricing Model (CAPM) utilizes a formula to enable the application to calculate
risk, return, and variability of return with respect to a benchmark. The application uses this
benchmark, currently S&P 500 annual rate of return, to calculate the return of a stock using
Figure 2 in Appendix A. Elements such as beta can be calculated using the formula in Appendix
A Figure 1. The beta variable will serve as a variable to be used for calculating the variability of
the stock with respect to the benchmark. This variability factor will prove useful for a variety of
calculations such as understanding market risk and return. If the beta is equal to 1.0, the stock
price is correlated with the market. When beta is smaller than 1.0, the stock is less volatile than
the market. If beta is greater than 1.0, the stock is more volatile than the market.
The CAPM model was run for 9 stocks, using 10-year daily historical data for initial test analysis.
With this initial analysis, beta was calculated to determine the stock’s risk by measuring the
price changes to the benchmark. By using CAPM model, annual expected return and portfolio
return is calculated. The model results can be found in Appendix A.
"""
beta(choices['data'], choices['choices'])
ER(choices['data'], choices['choices'])
##### EDIT HERE ##### koi
st.header('CAPM Model and the Efficient Frontier')
"""
CAPM model measures systematic risks, however many of it's functions have unrealistic assumptions and rely heavily on a linear interpretation
of the risks vs. returns relationship. It is better to use CAPM model in conjunction with the Efficient Frontier to better
graphically depict volatility (a measure of investment risk) for the defined rate of return. \n
Below we map the linear Utility function from the CAPM economic model along with the Efficient Frontier
Each circle depicted above is a variation of the portfolio with the same input asset, only different weights.
Portfolios with higher volatilities have a yellower shade of hue, while portfolios with a higher return have a larger radius. \n
As you input different porfolio assets, take note of how diversification can improve a portfolio's risk versus reward profile.
"""
ef_viz(choices['data'],choices['choices'])
"""
There are in fact two components of the Efficient Frontier: the Efficient Frontier curve itself and the Minimum Variance Frontier.
The lower curve, which is also the Minimum Variance Frontier will contain assets in the portfolio
that has the lowest volatility. If our portfolio contains "safer" assets such as Governmental Bonds, the further to the right
of the lower curve we will see a portfolio that contains only these "safe" assets, the portfolios on
this curve, in theory, will have diminishing returns.\n
The upper curve, which is also the Efficient Frontier, contains portfolios that have marginally increasing returns as the risks
increases. In theory, we want to pick a portfolio on this curve, as these portfolios contain more balanced weights of assets
with acceptable trade-offs between risks and returns. \n
If an investor is more comfortable with investment risks, they can pick a portfolio on the right side of the Efficient Frontier.
Whereas, a conservative investor might want to pick a portfolio from the left side of the Efficient Frontier. \n
Take notes of the assets' Betas and how that changes the shape of the curve as well. \n
How does the shape of the curve change when
the assets are of similar Beta vs when they are all different?\n
Note the behavior of the curve when the portfolio contains only assets with Betas higher than 1 vs. when Betas are lower than 1.\n
"""
##### ##### Koi
basic_portfolio(choices['combined_df'])
display_heat_map(choices['data'],choices['choices'])
#display_portfolio_return(choices['combined_df'], choices['choices'])
preprocess(choices['raw_data'], choices['choices'])
cumulative_return(choices['raw_data'], choices['choices'])
sharp_ratio_func(choices['raw_data'], choices['choices'])
if __name__ == "__main__":
run()