Stock Analysis - Equity Research using Excel

Master the art of investing in stocks

Ratings 4.02 / 5.00

Stock Analysis - Equity Research using Excel

What You Will Learn!

Gather global stocks prices and market indices values
Data cleaning, visualizing, and calculation of summary statistics
Draw line charts, column charts, candlestick charts, and candlestick charts with volume
Analyze individual stock's return, performance, persistence, and prediction
Identify individual stock's Buy / Sell signals
Analyze sector stocks performance, comparison, and co-movement
Analyze market indices
Measure impact of market index on individual stocks returns

Description

Search job portals with key word “Equity Research” to your surprise you will find thousands of openings on any given day. Few job titles are Equity Research Associate, Equity Research Analyst, Equity Research Valuation Analyst, Technical Research Analyst, Technical Analyst etc. These job roles need meticulous knowledge of sourcing data from stock markets, analyzing data, identifying patterns, identifying trends, finding buy / selling signals, measuring impact of stock markets on stock price etc. You can learn all these from this course.

This course has 30 video lectures. The course commences with a lecture on how to download stock price data from stock exchanges and ends with measuring the impact of stock market index on stock returns. In between the course covers analyzing individual stocks, analyzing sectors, comparing stocks returns performance, measuring relationship between and among stock returns, predicting stock prices, and sourcing market index data.