Graphing the efficient frontier for a two-stock portfolio in Excel
Shows how to download returns for two stocks, calculate mean, variance and standard deviations for various portfolios of the two stocks, and draw the efficient frontier in Excel.
Some good books on Excel and Finance:
Financial Modeling - by Benninga:
http://amzn.to/2tByGQ2
Principles of Finance with Excel - by Benninga:
http://amzn.to/2uaCyo6