Build a portfolio optimization system

Reference no: EM13138184

The exercise is to build a portfolio optimization system that can display efficient frontiers to a decision maker. As this includes many repetitive tasks, one should try to automate them with macros as much as possible.

Content-wise, the project involves

Retrieval of price data
Calculation of covariance matrix and historical mean return
Minimum of 20well distributed points used to characterize efficient frontier
Display efficient frontier
Table describing each portfolio option, the associated expected return and the portfolio standard deviation
Bonus:
- Allow re-runs with different numbers of points, different forecasted returns, and maybe even different constraint right hand sides
- option to override historical mean returns with forecasted returns that may be different

For good results, you probably need to work with 20 or more securities. Try to include in your model realistic-type sector, industry, and upper bound constraints, but don't make them too tight.

Reference no: EM13138184

Questions Cloud

Is homosexuality biologically-psychology : Describe and evaluate the reasoning used in the positions to address this issue and describe how this topic impacts our society, and what citizens can do to resolve it.

Make it sound better : I am writing to petition for reinstatement at XXX University. I have been placed on academic suspension since fall 2012 quarter due to my failure in maintaining above a 2.0 cumulative GPA.

Paraphrase in a couple of sentences : The New Jim Crow by Michelle Alexander that all people make mistakes. All of us violate the law at some point in our lives. In fact, if the worst thing you have ever done is speed ten miles over the speed limit on the freeway

Use excel to find the right-tail p value : Faced with rising fax costs, a firm issued a guideline that transmissions of ten pages or more should be sent by two-day mail instead. Exceptions are allowed, but they want the average to be ten or below. Use Excel to find the right-tail p value

Build a portfolio optimization system : For good results, you probably need to work with 20 or more securities. Try to include in your model realistic-type sector, industry, and upper bound constraints, but don't make them too tight.

Quackity quack company''s ad states that its product is : Quackity Quack Company's ad states that its product is "the best on the market today." Because of this ad, the Federal Trade Commission is most likely to

Adjustment to reconcile net income : When preparing a statement of cash flows (indirect method), which of the following is not an adjustment to reconcile net income to net cash provided by operating activities?

Basics of managerial purposes and decisions : The CEO of your company has asked you to prepare a written presentation to be given at the next board of directors meeting on why different types of cost information need to be reported to support different managerial purposes and decisions. In a ..

Administrative expenses and operating income : No additional fixed manufacturing overhead will be incurred because of this order. The only additional selling expense on this order will be a $0.50 per unit shipping cost. There will be no additional administrative expenses because of this order...

User Account

All Pages