Skip to content

Latest commit

 

History

History

Excel_Stock

Folders and files

NameName
Last commit message
Last commit date

parent directory

..
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 

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:

Excel

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.