The objective of this project is to learn how the Nobel Prize winning, Optimal Portfolio Theory (by Harry Markowitz), works in practice. The for the stock portfolio is plotted. The stock portfolio possibilities space is derived by assigning different weights for each stock using a random number generator. To let the computer select the optimal portfolio, the efficient frontier-Sharpe Ratio is used. In this case, the portfolio corresponding to the largest Sharpe Ratio is the optimal portfolio.
See Examples below;
Standard Deviation and Mean
Lotto Number Generator >
Playing Card Probability >
Normal Distribution Random Number Generator >
Monte Carlo Integration >
Black-Scholes Option Pricing Model - European Call and Put >
Binomial Option Pricing Model >
Portfolio Optimization >
Multiple Regression >
Bootstrap - A Non-Parametric Approach >
Multivariate Standard Normal Probability Distribution >
Monte Carlo Simulation >
Option Greeks Based on Black-Scholes Option Pricing Model.
Special! Free Choice of
Complete Excel Training Course
or Excel Add-ins Collection
on all purchases totaling over
ALL purchases totaling over $150.00 gets you BOTH! Purchases MUST be made via this site. Send payment proof to [email protected] 31 days after purchase date.
Instant Download and Money Back Guarantee on Most Software
Excel Trader Package Technical Analysis in Excel With $139.00 of FREE software!
Microsoft ® and Microsoft Excel ® are registered trademarks of Microsoft Corporation. OzGrid is in no way associated with Microsoft