Beverages Long Term Investment

Description:

This is a project for long-term investment to determine which soda beverages are good long-term investments. It involves analyzing historical data spanning five years and calculating performance measurements, conducting back-testing, forecasting, and utilizing the Capital Asset Pricing Model. The project also includes testing various trading strategies and identifying stocks with the lowest risks and highest returns.

Stock Tickers:

DPS - Dr. Pepper

KO - Coca-Cola

PEP - Pepsi

Use accountant statements: income, balance, and cashflow for analyzing

Use historical price in Excel, python, and Microsoft Azure Machine Learning Studio for Stocks Analysis

Prerequistes

Microsoft Azure Machine Learning Studio

Python 3.5+

Jupyter Notebook Python 3

Excel 2016

Power BI

Author:

Tin Hang

Disclaimer

🔴 This is not financial advice. Please conduct your own research and refrain from using this code for investing or trading in stocks. If you are interested in the stock market, consider reading books on investment, trading, and finance. It is advisable to consult with a professional investment advisor before making any investment decisions. Remember, this information is for educational purposes only.

Name		Name	Last commit message	Last commit date
Latest commit History 46 Commits
Plots		Plots
Balance Statement Project DPS KO PEP.xlsx		Balance Statement Project DPS KO PEP.xlsx
Beverages Long Term Investment Reports Accessibility.pdf		Beverages Long Term Investment Reports Accessibility.pdf
Beverages Long Term Investment Reports.pdf		Beverages Long Term Investment Reports.pdf
DPS_Daily_5Years(IF).xlsx		DPS_Daily_5Years(IF).xlsx
DPS_Daily_5Years.csv		DPS_Daily_5Years.csv
DPS_Daily_5Years_Ret.csv		DPS_Daily_5Years_Ret.csv
DPS_Fourier_Cycle.xlsx		DPS_Fourier_Cycle.xlsx
DPS_Monthly.csv		DPS_Monthly.csv
DPS_TradingStrategy.xlsx		DPS_TradingStrategy.xlsx
DPS_Weekly.csv		DPS_Weekly.csv
DPS_Weekly_Forecast.xlsx		DPS_Weekly_Forecast.xlsx
Forecasting_3_Beverages.pbix		Forecasting_3_Beverages.pbix
Forecasting_DPS.pbix		Forecasting_DPS.pbix
Forecasting_KO.pbix		Forecasting_KO.pbix
Forecasting_PEP.pbix		Forecasting_PEP.pbix
Income Statement Project DPS, KO, PEP.xlsx		Income Statement Project DPS, KO, PEP.xlsx
KO_Daily_5Years(IF).xlsx		KO_Daily_5Years(IF).xlsx
KO_Daily_5Years.csv		KO_Daily_5Years.csv
KO_Daily_5Years_Ret.csv		KO_Daily_5Years_Ret.csv
KO_Fourier_Cycle.xlsx		KO_Fourier_Cycle.xlsx
KO_Fourier_Cycle2.xlsx		KO_Fourier_Cycle2.xlsx
KO_Monthly.csv		KO_Monthly.csv
KO_TradingStrategy.xlsx		KO_TradingStrategy.xlsx
KO_Weekly.csv		KO_Weekly.csv
KO_Weekly_Forecast.xlsx		KO_Weekly_Forecast.xlsx
LICENSE		LICENSE
Long_Term_Investment_Project.ipynb		Long_Term_Investment_Project.ipynb
ML_Model_Outcome_Azure.xlsx		ML_Model_Outcome_Azure.xlsx
PEP_Daily_5Years(IF).xlsx		PEP_Daily_5Years(IF).xlsx
PEP_Daily_5Years.csv		PEP_Daily_5Years.csv
PEP_Daily_5Years_Ret.csv		PEP_Daily_5Years_Ret.csv
PEP_Fourier_Cycle.xlsx		PEP_Fourier_Cycle.xlsx
PEP_Monthly.csv		PEP_Monthly.csv
PEP_TradingStrategy.xlsx		PEP_TradingStrategy.xlsx
PEP_Weekly.csv		PEP_Weekly.csv
PEP_Weekly_Forecast.xlsx		PEP_Weekly_Forecast.xlsx
README.md		README.md
Soda.PNG		Soda.PNG
StocksPortfolio.ipynb		StocksPortfolio.ipynb

License

LastAncientOne/Beverages_Long_Term_Investment

Folders and files

Latest commit

History

Repository files navigation

Beverages Long Term Investment

Description:

Stock Tickers:

DPS - Dr. Pepper

KO - Coca-Cola

PEP - Pepsi

Use accountant statements: income, balance, and cashflow for analyzing

Use historical price in Excel, python, and Microsoft Azure Machine Learning Studio for Stocks Analysis

Prerequistes

Microsoft Azure Machine Learning Studio

Python 3.5+

Jupyter Notebook Python 3

Excel 2016

Power BI

Author:

Tin Hang

Disclaimer

About

Topics

Resources

License

Stars

Watchers

Forks

Languages