ABCDEFGHIJKLMNO
1
Notes
2
This Google Sheet is an example of Portfolio Optimizer REST API usage to compute either a minimum variance frontier or an efficient frontier.
3
This Google Sheets uses 4 assets by default, but allows the user to use at most 20 assets by filling the shaded cells with assets returns and covariance matrix.
4
If more than 20 assets are needed, please check https://docs.portfoliooptimizer.io/#api-limits
5
Discover more at https://portfoliooptimizer.io/
6
7
Assets returns
Assets covariance matrix
8
11.72%0.023592960.0194555904-0.0012486144-0.0006971904
9
8.43%0.01945559040.03182656-0.00145021360.0043187072
10
7.11%-0.0012486144-0.00145021360.005461210.0013417284
11
6.16%-0.00069719040.00431870720.00134172840.02289169
12
13
14
15
16
17
18
19
-----
20
21
Number of portfolios to generate
Portfolios
Minimum variance frontier
22
20
Portfolio volatility
Portfolio return
23
#NAME?
24
Full portfolio exposure ?
25
True
26
27
Frontier type
28
Minimum variance frontier
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
Disclaimer
50
Under no circumstances does any information on this Google Sheet represent a recommendation to buy, sell, or hold any security.
51
None of the content on this Google Sheet is guaranteed to be correct, and anything shown here should be subject to independent verification.
52
You, and you alone, are solely responsible for any investment decisions that you make.