Home|About|Gaming cabinet|Archives|How it works|Starter sites

GeezerVison is showing github.com — Stock_Analysis_For_Quant/Excel_Stock at master · LastAncientOne/Stock_Analysis_For_Quant

Expand file tree

/

Excel_Stock

/

Copy path

Directory actions

More options

More options

Directory actions

More options

More options

Latest commit

History

History

/

Excel_Stock

/

Copy path

Folders and files

Name		Name	Last commit message	Last commit date
parent directory ..
Bullock_Gold_Mining_Case		Bullock_Gold_Mining_Case
Excel Risk-Adjusted Returns Ratios Measurement		Excel Risk-Adjusted Returns Ratios Measurement
Excel_Machine_Learning		Excel_Machine_Learning
Excel_Option		Excel_Option
Excel_Portfolio_Strategies		Excel_Portfolio_Strategies
Excel_Statistics		Excel_Statistics
Excel_Stock_VBA_Macros		Excel_Stock_VBA_Macros
Excel_Technical_Indicators		Excel_Technical_Indicators
Excel_Time_Series		Excel_Time_Series
ASSETS_KellyFormula.xlsx		ASSETS_KellyFormula.xlsx
Arithmetic_vs_Geometric.xlsx		Arithmetic_vs_Geometric.xlsx
Dashboard_Financial.xlsx		Dashboard_Financial.xlsx
Dashboard_Stocks.xlsx		Dashboard_Stocks.xlsx
DataAnalysisStock.xlsx		DataAnalysisStock.xlsx
Excel_Chart.PNG		Excel_Chart.PNG
Excel_RL.PNG		Excel_RL.PNG
Financial_Analyst.xlsx		Financial_Analyst.xlsx
Performance_measurement_benchmarking.xlsx		Performance_measurement_benchmarking.xlsx
Quantitative_Value.xlsx		Quantitative_Value.xlsx
README.md		README.md
SP500_Financial_Statement.xlsx		SP500_Financial_Statement.xlsx
SP500_Market_Crash.xlsx		SP500_Market_Crash.xlsx
SP500_Market_Crash_2022.xlsx		SP500_Market_Crash_2022.xlsx
Stock_Basic_Stationary.xlsx		Stock_Basic_Stationary.xlsx
Stock_Beta.xlsx		Stock_Beta.xlsx
Stock_Beta_Upside_Downside.xlsx		Stock_Beta_Upside_Downside.xlsx
Stock_Budget_Money.xlsx		Stock_Budget_Money.xlsx
Stock_Budget_Money_2.xlsx		Stock_Budget_Money_2.xlsx
Stock_Charts.xlsx		Stock_Charts.xlsx
Stock_Companies_Statistics.xlsx		Stock_Companies_Statistics.xlsx
Stock_Compare.xlsx		Stock_Compare.xlsx
Stock_Compare_Part2.xlsx		Stock_Compare_Part2.xlsx
Stock_Compare_Part3.xlsx		Stock_Compare_Part3.xlsx
Stock_Data_Analysis.xlsx		Stock_Data_Analysis.xlsx
Stock_Data_Analysis_Part2.xlsx		Stock_Data_Analysis_Part2.xlsx
Stock_Decision_Analysis.xlsx		Stock_Decision_Analysis.xlsx
Stock_Decision_Errors.xlsx		Stock_Decision_Errors.xlsx
Stock_Dollar_Cost_Average.xlsx		Stock_Dollar_Cost_Average.xlsx
Stock_Dollar_Cost_Average_vs_Lump_Sum.xlsx		Stock_Dollar_Cost_Average_vs_Lump_Sum.xlsx
Stock_Drawdown.xlsx		Stock_Drawdown.xlsx
Stock_Exponential_Growth.xlsx		Stock_Exponential_Growth.xlsx
Stock_Future_Earnings_per_Share.xlsx		Stock_Future_Earnings_per_Share.xlsx
Stock_Gain_Loss.xlsx		Stock_Gain_Loss.xlsx
Stock_Gordon_Growth_Model.xlsx		Stock_Gordon_Growth_Model.xlsx
Stock_Historical_Volatility.xlsx		Stock_Historical_Volatility.xlsx
Stock_Holding_Period_Return.xlsx		Stock_Holding_Period_Return.xlsx
Stock_Importance_Features.xlsx		Stock_Importance_Features.xlsx
Stock_Kelly_One_Asset.xlsx		Stock_Kelly_One_Asset.xlsx
Stock_Kelly_Two_Assets.xlsx		Stock_Kelly_Two_Assets.xlsx
Stock_Linear_Regression.xlsx		Stock_Linear_Regression.xlsx
Stock_Linear_Regression_2.xlsx		Stock_Linear_Regression_2.xlsx
Stock_Linear_Regression_Equation.xlsx		Stock_Linear_Regression_Equation.xlsx
Stock_Logistic_Regression.xlsx		Stock_Logistic_Regression.xlsx
Stock_Matched_Pairs.xlsx		Stock_Matched_Pairs.xlsx
Stock_Monte_Carlo.xlsx		Stock_Monte_Carlo.xlsx
Stock_Morningstar.xlsx		Stock_Morningstar.xlsx
Stock_Multiple_Regression.xlsx		Stock_Multiple_Regression.xlsx
Stock_Multiple_Regression_2.xlsx		Stock_Multiple_Regression_2.xlsx
Stock_Pair_Trade_ADF_Test.xlsx		Stock_Pair_Trade_ADF_Test.xlsx
Stock_Pivot_Table.xlsx		Stock_Pivot_Table.xlsx
Stock_Pivot_Table_2.xlsx		Stock_Pivot_Table_2.xlsx
Stock_Pivot_Table_3.xlsx		Stock_Pivot_Table_3.xlsx
Stock_Plot_MA.xlsx		Stock_Plot_MA.xlsx
Stock_Polynomial_Regression.xlsx		Stock_Polynomial_Regression.xlsx
Stock_Predict_Price_Regression.xlsx		Stock_Predict_Price_Regression.xlsx
Stock_Price_Projections.xlsx		Stock_Price_Projections.xlsx
Stock_Risk_Returns.xlsx		Stock_Risk_Returns.xlsx
Stock_Simulate_Price.xlsx		Stock_Simulate_Price.xlsx
Stock_Simulate_Price_Part2.xlsx		Stock_Simulate_Price_Part2.xlsx
Stock_Simulate_Regression.xlsx		Stock_Simulate_Regression.xlsx
Stock_Simulate_Two_Correlated.xlsx		Stock_Simulate_Two_Correlated.xlsx
Stock_Slope_Beta.xlsx		Stock_Slope_Beta.xlsx
Stock_Statements.xlsx		Stock_Statements.xlsx
Stock_Statements_Preprocessing.xlsx		Stock_Statements_Preprocessing.xlsx
Stock_Statements_Ratio_Analysis.xlsx		Stock_Statements_Ratio_Analysis.xlsx
Stock_TWAP.xlsx		Stock_TWAP.xlsx
Stock_Table.xlsx		Stock_Table.xlsx
Stock_Trend.xlsx		Stock_Trend.xlsx
Stock_Trend_Explained.xlsx		Stock_Trend_Explained.xlsx
Stock_Value_At_Risk.xlsx		Stock_Value_At_Risk.xlsx
Stock_Value_Averaging.xlsx		Stock_Value_Averaging.xlsx
Stock_Value_Investment.xlsx		Stock_Value_Investment.xlsx
Stock_Z_Score.xlsx		Stock_Z_Score.xlsx
TinInformationRatio.xlsx		TinInformationRatio.xlsx
Tin_Hang_Portfolio_Project_Fall_2014.xlsx		Tin_Hang_Portfolio_Project_Fall_2014.xlsx
Tin_MeanReversion.xlsx		Tin_MeanReversion.xlsx
Title_Excel.PNG		Title_Excel.PNG
TradingStrategy.xlsx		TradingStrategy.xlsx
VWAP.xlsx		VWAP.xlsx

README.md

Outline

Excel for Stock Trading and Investment

Description:

This Excel project includes technical analysis, fundamental analysis, quantitative analysis, time series analysis, and various types of trading strategies. It also incorporates numerous risk-return metrics, technical indicators, and portfolio strategies. Additionally, it involves data analysis and data science for both single stocks and multiple stocks. Statistical analysis techniques, such as hypothesis testing, t-tests, R-Squared, Significant F, p-values, coefficients, F-tests, and Durbin-Watson statistics, are utilized for investing and trading purposes. Time series forecasting metrics are employed for modeling, while VBA, macros, and complex formulas are created for stock analysis.

Download Software

https://www.microsoft.com/en-us/microsoft-365/excel

Python Library for Excel

https://www.python-excel.org/

R Library for Excel

https://readxl.tidyverse.org/

Matlab Library for Excel

https://www.mathworks.com/help/compiler/create-excel-add-ins.html

Software:

List of Stock Strategies and Investment

List of Technical Analysis
Fundamental Analysis (Statements)
Budgeting Money for Investing
Project of Portfolio Stocks Investment
Project of Values in the Company (Cashflows)
Stock Data Analysis
Stock Measurement Ratios
Long-Term Investment
Statistics
Time Series
Forecasting

Trading Stocks in Statistics

Trading With Gaussian Statistical Models
Hypothesis Testing in Finance
Independent Sample t-Test for Stock Returns
Statistical Modeling
Statistical Inference

Author

* Tin Hang

🔴 Warning: This is not financial advice. Do not rely on it for investment or trading decisions. It is for educational purposes only.