- UID
- 222269
- 帖子
- 300
- 主题
- 69
- 注册时间
- 2011-7-2
- 最后登录
- 2014-6-29
|
9#
发表于 2011-7-26 04:42
| 只看该作者
There is no equation to solve for these points. An iterative program, like the critical line algorithm, must be used. The authors probably just used solver in excel (see DFW's comment above). Any method can probably be used as this is a simple process, unlike in 1954 when Markowitz proposed this and computers were a rarity and extremely slow.
How I would do this using excel:
Find the top corner portfolio (UK equity 100% in this case). From there, you just work your way down the frontier, adding more of the next asset (real estate in this case), calculating the weights of the portfolio by minimizing the risk for every given level of return. When you get to 8.85% return, you see that ex-UK equity joined the efficient set so you define the second corner portfolio to be at 8.86% return, just before the new asset joined the efficient set. Then you just repeat this til you get to the bottom defining a new corner portfolio every time a new asset joins or leaves the efficient set.
There are fancier and faster ways to do this. Two of the neater ones: since the asset allocation tradeoff is linear between each corner portfolio, you can use this to your advantage in creating faster algorithms. Also, if you know what the next asset is to join or leave the portfolio, you can actually calculate the exact corner portfolio. This is rarely known though.
Edited 1 time(s). Last edit at Tuesday, June 21, 2011 at 02:30PM by MathMan. |
|