Unlock the power of Excel in the domain of trading and investment with this comprehensive training. Delve into foundational and advanced strategies including the Moving Average Crossover, Volume Weight Average Pricing (VWAP), and the Relative Strength Indicator (RSI). Complement these with a deep understanding of key metrics like Expected Return, Beta, and Volatility, setting the stage for informed and data-driven financial decisions.

Furthermore, this course illuminates the intricacies of the Capital Asset Pricing Model, a cornerstone in modern financial theory. Whether you're a budding trader or an investment professional, the integration of Excel with these critical strategies ensures a robust approach to the financial markets, optimizing your potential for success.

Disclaimer

This course is meant for educational. It does not offer any financial advise on investment. We will not be liable for any investment gain or loss.

Certificate

All participants will receive a Certificate of Completion from Tertiary Courses after achieved at least 75% attendance.

Funding and Grant

HRD Corp Claimable Course for Employers Registered with HRD Corp

Course Code: M1299

Topic 1 Excel Primer

• Explore Excel Interface

• Format Cell

• Working with Data

• Referencing Cell

• Filtering and Sorting Data

• Create Charts

• Logical Functions

• Lookup Functions

Topic 2 Applications to Trading Strategies

• Working with OHLCV Data

• Understanding Adjusted Close

• Computing Adjusted Prices

• Computing Daily and Cumulative Returns

• Computing Moving Averages

• Moving Average Crossover Trading Strategy

• Volume Weighted Average Price (VWAP) Trading Strategy

• Relative Strength Indicator (RSI) Trading Strategy

Topic 3 Statistical Analysis on Investment

• Probability for Single and Multiple Events

• Conditional Probability and Bayes' Theorem

• Expected Value

• Mean and Standard Deviation

• Covariance and Correlation Coefficient

• Capital Asset Pricing Model

• Probability Distributions

• Linear Regression

• Volatility and Beta

• Hypothesis Testing

Topic 4 Time Series Modeling

• Random Walk Model for Stock Prices

• Monte Carlo Simulation

• VaR and Expected Shortfall