Calculating Rates of Return in Excel
In this video, we will show you how to calculate the average and geometric average return of a stock, using Excel. Suppose you are interested in buying Apple stock. Your first task is to calculate the stock return of Apple in the last 2 years. First, we are going to obtain stock prices. For this, we will use Yahoo Finance.
Read more...