Skip to content

LastAncientOne/Beverages_Long_Term_Investment

BranchesTags

Folders and files

NameName
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
 
 

Repository files navigation

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.

About

Long-Term Investment in the Beverage Industry

Topics

excel stock investing investments stock-analysis longterm investment-strategies investment-portfolio investment-analysis

Resources

Readme

License

MIT license
Activity

Stars

16 stars

Watchers

2 watching

Forks

7 forks
Report repository

Releases

No releases published

Packages

No packages published

Languages