Stock Analysis - Equity Research using Excel

Learn how draw candlestick chart using Microsoft Excel. Also learn how to interpret the candlestick chart. This lecture is just an introductory lecture on candlestick analysis.

Learn how to measure the mood of investors using candlestick chart with volume traded. In Excel you can easily draw a candlestick chart with volume, open, high, low, close prices. This chart will help you gain basic understanding of investors sentiment towards particular stock.

With Excel Data Analysis Toolpak you perform variety of analysis on stock prices. In addition you can compare stock price performance of different companies in the same industry and also predict the stock prices.

Learn how to gain preliminary insights of stock prices. With just few clicks you can calculate all the required summary statistics of the stock prices. Use these summary statistics to gauge stock price movements.

Stock price provides lot of meaningful information to investors. However, investors need to summarize the data in a meaningful way and interpret the results. This lecture helps you summarize and interpret the stock price information.

Learn how to estimate probability values of historical stock prices. You can use these estimated probability values to predict stock price.

Learn how to calculate holding period return (HPR) and daily returns of a stock.

Learn how to calculate the daily returns series and visualize the returns series to understand the price pattern. With clustered column chart in Microsoft Excel you can easily trace the trend or return range of stock's return movements.

Learn how to quantify the average return and volatility of return series of investment in stocks.

Learn how to calculate annualized return and annualized standard deviation using stock's average daily return.

Learn how to measure performance persistence stock's average return of two time periods.

Learn how to assess stock's performance persistence over two or more periods using analysis of variance.

Learn how to calculate serial correlation or auto correlation among stock's return series and understand the return pattern.

Learn how to identify buy sell signals of a stock price using simple moving average. Use Microsoft Excel Data Analysis tool to calculate simple moving average series.

Learn how to calculate Exponential Moving Average (EMA) using Excel Data Analysis tool. Learn how to identify buy sell signals using exponential moving average values.

Learn how calculate summary statistics of multiple stocks belong to same sector and compare their descriptive statistics.

Learn how to calculate relative returns of stocks and compare the performance of different stocks belongs to same sector.

Learn how to compare mean returns of two independent stocks belong to same sector using independent sample t-Test.

Learn how to compare mean return of multiple stocks belongs to same sector.

Learn how to download various BSE indices values from BSE official website.

Learn how to download stock market index values from NSE website.

Learn how to download world stock prices data from yahoo finance website. You can use these data to compare domestic stocks with foreign stocks.

Learn how to analyze the close values and daily percentage change of stock market index. Understanding stock market index movements will help you in understanding stock price movements.

Learn how to measure the impact of stock market on individual stock return. Also learn how to frame null and alternative hypothesis, run regression analysis and interpret the result.