Portfolio Optimization Seven Security Example with Excel Solver

#excel    #optimization   #solver

Portfolio Optimization in Excel*
Solver Model starts at 8:27

Please SUBSCRIBE:
https://www.youtube.com/subscription_...


https://alphabench.com/data/excel-por...

Video starts off with a classic finance textbook two security portfolio, and demonstrates how to select an optimal blend of the investments. But how do you select the optimal blend for many securities? This where Excel's Solver comes in.  Learn how to use matrix multiplication and array functions to turn a coding nightmare into a few trivial keystrokes.

*The content is for informational purposes only. Investment in securities can involve the risk of losing any monies invested. This video and other content should not be construed as investment, financial, or other advice.

• #education
• #excel_solver
• #excel_portfolio_optimization
• #excel
• #solver
• #portfolio_variance_excel
• #portfolio_excel
• #excel_solver_example
• #capital_allocation_line_excel
• #efficient_frontier_excel
• #efficient_frontier
• #sharpe_ratio
• #sharpe_ratio_excel
• #expected_return
• #calculate_expected_return_of_portfolio
• #covariance_matrix_excel
• #mmult_excel
• #portfolio_optimization
• #financial_modeling
• #portfolio
• #optimization
• #portfolio_management
• #transpose_in_excel
• #financial_modeling_in_excel