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:
[ Ссылка ]
Principles of Finance with Excel - by Benninga:
[ Ссылка ]
Ещё видео!