It can be modified to download other data found on the web. The VBA that retrieves the data from Yahoo was adapted from code found at mathfinance.cn.

Sharpe, Sortino and Treynor Ratios), plot histograms of daily returns to check if they’re normally distributed, identified stocks with my desired risk characteristics, and calculate mean-variance optimal portfolios. For example, I’ve used this variations of this spreadsheet to calculate investment ratios (e.g. You could also perform far more advanced analyses (which I’ll discuss in future blog posts).