filmov
tv
Graphing the Efficient Frontier using Random Portfolios in Excel
Показать описание
We use solver to calculate the weights of the tangency portfolio and the minimum variance portfolio. We then use a random array to produce a data table of random portfolios. A properly formatted scatter plot shows the efficient frontier.
If you do not have data ready, use these videos:
If you do not have data ready, use these videos:
0:08:47
0:04:11
0:32:47
0:04:27
0:15:32
0:02:54
0:05:51
0:35:01
0:05:23
0:09:21
0:14:43
0:10:06
0:07:00
0:34:57
0:03:05
0:09:22
0:15:38
0:10:31
0:20:07
0:12:22
0:34:36
0:15:25
0:30:34
0:16:27