{"text_format":"1","workbook":"xlsx","n_sheets":5,"sheets":["Inputs","Returns","Correlation Matrix","Covar Matrix","Efficient Frontier"],"not_rendered":{"charts":1,"images":43,"macros":1,"external_links":0,"defined_names":100,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"row_number_cap","date_system":"1900"}

{"sheet":"Inputs","index":0,"n_rows":1048576,"n_cols":9,"rows_kept":4500,"cut":true,"hidden":false,"merged":[[10,4,10,5],[11,4,11,5],[24,7,24,8],[13,1,13,2]],"bounds":{"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0},"read":"row_number_cap"}
["Finding the Efficient Frontier"]
[]
[]
["Today's date",{"$f":"TODAY()","v":"2021-02-08"}]
["Start date  ",{"$f":"DATE(YEAR(endDate)-5, MONTH(endDate), 15)","v":"2016-02-15"}]
["End date  ",{"$f":"DATE(YEAR(B4), MONTH(B4), 15)","v":"2021-02-15"}]
[]
[]
[]
[]
[null,null,null,null,"Risk-free Rate",null,0.03]
[null,null,null,null,"Market Risk Premium (Rm-Rf)",null,5.7000000000000002E-2]
[]
[null,"Ticker Symbols"]
[null,1,"IYE"]
[null,2,"FXI"]
[null,3,"VBR"]
[null,4,"RJA"]
[null,5,"HYG"]
[null,6,"IDU"]
[null,7,"VGT"]
[null,8,"IFGL"]
[]
[]
[null,null,null,null,null,null,null,"Enter Value for x"]
[]
[]
[]
[]
["Ignore everything below this point on this worksheet"]
[]
[]
[]
[]
[]
["If selected to be restricted, weights for these individual ETFs must be 0.2 or less"]
["Financial (XLF)"]
["Health (XLV)"]
["Energy (IYE)"]
["Technology (VGT)"]
["Utilities  (IDU)"]
["China (FXI)"]
["Japan (NKY)"]
["India (INP)"]
["Latin America (EWZ)"]
["Europe (EWG)"]
["Emerging Markets (VWO)"]
["Junk Bonds (HYG)"]
["Domestic Real Estate (VNQ)"]
["Global Real Estate (IFGL)"]
["Precious Metals (IAU)"]
["Natural Resources (VAW)"]
["Agricultural Commodities (RJA)"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[0,"Financial (XLF)",null,null,"if any of these are 1's then the weight must be less than .2"]
[0,"Health (XLV)"]
[0,"Energy (IYE)"]
[0,"Technology (VGT)"]
[0,"Utilities  (IDU)"]
[0,"China (FXI)"]
[0,"Japan (NKY)"]
[0,"India (INP)"]
[0,"Latin America (EWZ)"]
[0,"Europe (EWG)"]
[0,"Emerging Markets (VWO)"]
[0,"Junk Bonds (HYG)"]
[0,"Domestic Real Estate (VNQ)"]
[0,"Global Real Estate (IFGL)"]
[0,"Precious Metals (IAU)"]
[0,"Natural Resources (VAW)"]
[0,"Agricultural Commodities (RJA)"]
[0,"weights less than 50%..then 1"]
[0,"non-negative..then 1"]
["m"]
["^GSPC",null,null,null,null,null,null,null,"^GSPC"]

{"sheet":"Returns","index":1,"n_rows":69,"n_cols":21,"rows_kept":69,"cut":false,"hidden":false,"merged":[[0,1,0,9],[0,10,0,18]]}
[null,"PRICES",null,null,null,null,null,null,null,null,"RETURNS",null,null,null,null,null,null,null,null,"Rf",{"$f":"Inputs!$G$11","v":0.03}]
["Date","IYE","FXI","VBR","RJA","HYG","IDU","VGT","IFGL","S&P500",{"$f":"B2","v":"IYE"},{"$f":"C2","v":"FXI"},{"$f":"D2","v":"VBR"},"RJA","HYG","IDU","VGT","IFGL",{"$f":"J2","v":"S&P500"},"Rm-Rf",{"$f":"Inputs!$G$12","v":5.7000000000000002E-2}]
["2016-02-01",26.20269,26.656475,84.861373999999998,5.98,61.531970999999999,49.736938000000002,95.078331000000006,20.705777999999999,1932.2299800000001,"_1","_2","_3","_4","_5","_6","_7","_8"]
["2016-03-01",28.577271,29.728842,92.102669000000006,6.23,63.080173000000002,53.416679000000002,103.169495,22.424862000000001,2059.73999,{"$f":"LN(B4/B3)","v":8.6749604336123068E-2},{"$f":"LN(C4/C3)","v":0.10908560024290315},{"$f":"LN(D4/D3)","v":8.188489119448937E-2},{"$f":"LN(E4/E3)","v":4.0955764836821486E-2},{"$f":"LN(F4/F3)","v":2.4849611246313789E-2},{"$f":"LN(G4/G3)","v":7.1375161654107025E-2},{"$f":"LN(H4/H3)","v":8.167212956764984E-2},{"$f":"LN(I4/I3)","v":7.9757462323316999E-2},{"$f":"LN(J4/J3)","v":6.3904990415635493E-2}]
["2016-04-01",31.378494,29.517557,94.386307000000002,6.55,65.088668999999996,52.681064999999997,98.718947999999997,23.115046,2065.3000489999999,{"$f":"LN(B5/B4)","v":9.351107221288496E-2},-7.1324468413084636E-3,2.4492087452537305E-2,5.0088716847798621E-2,3.1343974125381938E-2,-1.3866944950236023E-2,-4.4096314568182388E-2,3.0313493408188747E-2,2.6957616481642385E-3]
["2016-05-01",30.981508000000002,29.623197999999999,95.711089999999999,6.56,65.204864999999998,53.507744000000002,103.99479700000001,22.705454,2096.9499510000001,-1.2732243431817116E-2,3.572531745928257E-3,1.3938165048448782E-2,1.5255533088371917E-3,1.7836039477442903E-3,1.5570298018937345E-2,5.2063965345381484E-2,-1.7878587542270861E-2,1.5208366645339389E-2]
["2016-06-01",31.725854999999999,30.12499,95.556838999999997,6.57,66.357246000000004,57.114666,101.252861,22.535435,2098.860107,2.3741453222323718E-2,1.6797289259518063E-2,-1.6129314961208564E-3,1.5232295405216379E-3,1.7518880843551271E-2,6.5234540227404353E-2,-2.671990666617808E-2,-7.5162006834153198E-3,9.1050648411568206E-4]
["2016-07-01",31.228643000000002,31.419789999999999,100.299736,6.37,67.236748000000006,56.970692,109.274811,23.827145000000002,2173.6000979999999,-1.579624505013482E-2,4.2082889303589846E-2,4.8441819644254494E-2,-3.0914362912447164E-2,1.3166979744930748E-2,-2.5239711555509574E-3,7.6244948788994529E-2,5.5736517704940126E-2,3.4990433050203752E-2]
["2016-08-01",31.603086000000001,32.856430000000003,101.027878,6.04,68.573677000000004,53.806870000000004,111.82641599999999,23.546092999999999,2170.9499510000001,1.1919055510688007E-2,4.470951481620767E-2,7.233435696045557E-3,-5.3195457637348405E-2,1.9688800590560999E-2,-5.7135805979742278E-2,2.3081900714711945E-2,-1.1865572603558286E-2,-1.2199870176702919E-3]
["2016-09-01",32.451839,33.707766999999997,100.71843,6.2,69.327492000000007,53.710472000000003,114.17887899999999,23.553902000000001,2168.2700199999999,2.6502339294626358E-2,2.5580821600178386E-2,-3.0676967102510619E-3,2.6145280104322207E-2,1.0932793591587655E-2,-1.7931623687292076E-3,2.0818520775160804E-2,3.315923949272739E-4,-1.2352134063971093E-3]
["2016-10-01",31.482641000000001,32.687939,98.367973000000006,6.4,68.636009000000001,54.538128,113.948883,22.348137000000001,2126.1499020000001,-3.0320798780620391E-2,-3.0722113635250382E-2,-2.3613528409943706E-2,3.174869831458027E-2,-1.0024227934089214E-2,1.5292061582074728E-2,-2.0163795577515789E-3,-5.2548534877982549E-2,-1.9616837421336072E-2]
["2016-11-01",34.369804000000002,33.335312000000002,108.412628,6.32,68.644431999999995,51.837029000000001,114.548508,21.601102999999998,2198.8100589999999,8.774207363135833E-2,1.9611083612964379E-2,9.7229303248949739E-2,-1.2578782206860073E-2,1.2271230991413128E-4,-5.0795313951143201E-2,5.2484308360429451E-3,-3.3998583679429345E-2,3.3603545390870432E-2]
["2016-12-01",34.763129999999997,30.781286000000001,110.79331999999999,6.31,69.678421,53.770167999999998,115.64308200000001,20.665348000000002,2238.830078,1.1378954175385772E-2,-7.9710347643420928E-2,2.1721907001538639E-2,-1.5835316056443847E-3,1.4950649692898881E-2,3.6614075790633173E-2,9.5101845359010732E-3,-4.4286090311519928E-2,1.8037111058687334E-2]
["2017-01-01",33.751862000000003,33.188465000000001,112.240807,6.52,70.862778000000006,54.968139999999998,121.05381,22.128695,2278.8701169999999,-2.9521756206129918E-2,7.5295467877403946E-2,1.2980142031388925E-2,3.2738699385439739E-2,1.6854631180517544E-2,2.2034929426404216E-2,4.5726589015410643E-2,6.841689471016886E-2,1.7726314594617782E-2]
["2017-02-01",32.944648999999998,34.554366999999999,114.498718,6.51,71.633560000000003,57.677112999999999,127.032967,22.723198,2363.639893,-2.4206735978556666E-2,4.033156296085403E-2,1.9917000706597868E-2,-1.5349197180837017E-3,1.0818376504577586E-2,4.8106695051023413E-2,4.8211477963976165E-2,2.6511158390041409E-2,3.6523000999039816E-2]
["2017-03-01",32.406494000000002,34.816692000000003,113.226913,6.29,71.532639000000003,57.218189000000002,129.544937,22.673653000000002,2362.719971,-1.6470015375304087E-2,7.5629882019880457E-3,-1.1169741563579361E-2,-3.4378385508128717E-2,-1.4098441869843021E-3,-7.9886023646613489E-3,1.9581189358677881E-2,-2.1827513838362182E-3,-3.8927294496698804E-4]
["2017-04-01",31.525580999999999,34.852867000000003,114.12846399999999,6.22,72.123383000000004,58.021678999999999,132.93159499999999,23.382673,2384.1999510000001,-2.7559523314458333E-2,1.0384737256916999E-3,7.9308062764768209E-3,-1.1191163961261104E-2,8.2244701153875704E-3,1.394487922339944E-2,2.5806847795200927E-2,3.0791688388779579E-2,9.0501322804594966E-3]
["2017-05-01",30.316314999999999,36.309218999999999,111.389763,6.18,72.866814000000005,60.396228999999998,138.79284699999999,24.064527999999999,2411.8000489999999,-3.911329505011666E-2,4.0936275288045776E-2,-2.4289261942699737E-2,-6.4516352814887193E-3,1.0255003863998592E-2,4.0109952645173079E-2,4.3147839558737688E-2,2.8743611021275598E-2,1.1509759254333795E-2]
["2017-06-01",30.020340000000001,35.920257999999997,113.721367,6.39,72.9636,58.367305999999999,134.88533000000001,23.682030000000001,2423.4099120000001,-9.8108645246534083E-3,-1.0770249932542948E-2,2.0715878268015842E-2,3.3415996919844017E-2,1.3273776238589535E-3,-3.4170764912441226E-2,-2.8557502082479799E-2,-1.6022356323217336E-2,4.8022259241070758E-3]
["2017-07-01",30.895600999999999,38.649635000000004,115.273567,6.37,73.706283999999997,60.297504000000004,140.86166399999999,24.614025000000002,2470.3000489999999,2.8738659385664864E-2,7.3235905226828768E-2,1.3556839409306565E-2,-3.1347988053713918E-3,1.0127373492575314E-2,3.2534805537174333E-2,4.3353292315156396E-2,3.8599869738898632E-2,1.916401766181007E-2]
["2017-08-01",29.253851000000001,40.194172000000002,113.593109,6.07,73.763908000000001,62.146610000000003,145.24137899999999,24.849245,2471.6499020000001,-5.4602588178301922E-2,3.9184678727593167E-2,-1.4685302636704476E-2,-4.8240864512665058E-2,7.8150034459551735E-4,3.020556117291865E-2,3.0618738735343983E-2,9.5109673555625433E-3,5.4628357104102084E-4]
["2017-09-01",31.839835999999998,40.012462999999997,118.64376799999999,6.07,74.204262,60.089523,145.98092700000001,24.504812000000001,2519.360107,8.4706987077794033E-2,-4.531029406162102E-3,4.3502613035517092E-2,0,5.9520273856297386E-3,-3.3660770793048245E-2,5.078935057640962E-3,-1.3957863358935355E-2,1.911903932397916E-2]
["2017-10-01",31.923983,41.729613999999998,120.250626,6.07,74.271996000000001,62.927227000000002,157.21736100000001,24.697700999999999,2575.26001,2.6393352897500365E-3,4.2020064036063072E-2,1.3452657522130642E-2,0,9.1238835907067562E-4,4.6143431512547378E-2,7.4153336640193385E-2,7.8406559505404729E-3,2.1945560290305279E-2]
["2017-11-01",32.595165000000001,41.947665999999998,124.057152,6.05,73.997009000000006,64.661918999999997,158.931839,25.356983,2647.580078,2.0806418990885006E-2,5.2117490809081689E-3,3.1164247854050985E-2,-3.3003330286568541E-3,-3.7093027675442008E-3,2.719351844023021E-2,1.0846111945253848E-2,2.6343993236004521E-2,2.7695540908411347E-2]
["2017-12-01",34.118225000000002,41.947665999999998,123.879875,6,73.864249999999998,60.495888000000001,158.662125,25.356983,2673.610107,4.5667734506163848E-2,0,-1.4300165840916209E-3,-8.2988028146950658E-3,-1.795724405063379E-3,-6.6597054389457011E-2,-1.6984835696706004E-3,0,9.7836144642919464E-3]
["2018-01-01",35.371673999999999,48.804577000000002,127.089668,6.15,74.521156000000005,58.831211000000003,171.096619,27.237976,2823.8100589999999,3.6079631345770864E-2,0.15140130574311136,2.5580538505104774E-2,2.4692612590371633E-2,8.8541091638108041E-3,-2.7902882384608786E-2,7.5451479124801407E-2,7.1558020409482045E-2,5.4657398659986728E-2]
["2018-02-01",31.600082,43.754542999999998,121.070435,6.35,73.565101999999996,56.457839999999997,171.260773,25.415171000000001,2713.830078,-0.1127516148155096,-0.10922865203198497,-4.8520400892647295E-2,3.2002731086173734E-2,-1.2912302549262759E-2,-4.1178348479881992E-2,9.5896286404591831E-4,-6.9265896838131433E-2,-3.9726107788010244E-2]
["2018-03-01",31.980702999999998,43.773086999999997,121.530586,6.18,73.411941999999996,58.282451999999999,165.13810699999999,25.805769000000002,2640.8701169999999,1.1972974127043966E-2,4.2372906195348587E-4,3.7934840498267284E-3,-2.7136541435000917E-2,-2.0841357435258359E-3,3.1806888273902309E-2,-3.6405247270412937E-2,1.5251792396656656E-2,-2.725249739187887E-2]
["2018-04-01",35.294196999999997,43.485835999999999,122.540909,6.3,73.755172999999999,60.111995999999998,165.44160500000001,26.428118000000001,2648.0500489999999,9.85858698374837E-2,-6.5839005975252751E-3,8.2789575301893889E-3,1.9231361927887592E-2,4.6645151986061126E-3,3.0908369094955583E-2,1.8361567528354438E-3,2.3830447536135273E-2,2.7150859477301889E-3]
["2018-05-01",36.496814999999998,43.272717,128.07662999999999,6.39,73.780463999999995,59.770919999999997,177.102631,26.209633,2705.2700199999999,3.3506437016337917E-2,-4.9129318389887671E-3,4.4183831406141856E-2,1.4184634991956381E-2,3.4284598300448585E-4,-5.6901672341618074E-3,6.8111108016662814E-2,-8.3015041709966087E-3,2.1378191291432879E-2]
["2018-06-01",36.549103000000002,39.816459999999999,128.057816,5.95,73.833931000000007,60.812592000000002,175.54461699999999,25.501738,2718.3701169999999,1.4316476638943617E-3,-8.3241949404082777E-2,-1.4690722257504303E-4,-7.1343048831904926E-2,7.2441447649063194E-4,1.7277617736949923E-2,-8.8361621762833784E-3,-2.7380408243527332E-2,4.830749144322073E-3]
["2018-07-01",37.172096000000003,40.954475000000002,131.73245199999999,6.08,75.074112,62.301186000000001,180.641434,26.189616999999998,2816.290039,1.6901728109835357E-2,2.8180689303795966E-2,2.8291137460296212E-2,2.1613476420537171E-2,1.6657390035168165E-2,2.4183589738400724E-2,2.8620800295234197E-2,2.6616427805885256E-2,3.5387950784307211E-2]
["2018-08-01",36.006359000000003,39.799644000000001,134.91288800000001,5.84,75.622001999999995,63.011699999999998,196.78814700000001,25.844083999999999,2901.5200199999999,-3.1862810534616329E-2,-2.8603116411006942E-2,2.3856309185615071E-2,-4.027389913793996E-2,7.2714869623828962E-3,1.1339960904137969E-2,8.5613715334857149E-2,-1.3281318548944595E-2,2.9814314708128044E-2]
["2018-09-01",36.777664000000001,40.203364999999998,131.91227699999999,5.68,76.015984000000003,62.259407000000003,196.555252,25.383372999999999,2913.9799800000001,2.1195142634281711E-2,1.0092731062676509E-2,-2.2492162604203291E-2,-2.7779564107075706E-2,5.196361372544196E-3,-1.2010783040746185E-2,-1.18418169877805E-3,-1.7987362584465535E-2,4.2850929639178534E-3]
["2018-10-01",32.646656,36.889076000000003,120.65273999999999,5.72,74.498047,63.516967999999999,180.47567699999999,24.215021,2711.73999,-0.1191482735051122,-8.6035234732884353E-2,-8.9220631348963811E-2,7.0175726586465398E-3,-2.017072368573938E-2,1.9997442408405782E-2,-8.5347557216751843E-2,-4.7121210291155645E-2,-7.1929345879864132E-2]
["2018-11-01",31.853401000000002,39.452255000000001,123.48938800000001,5.73,74.169433999999995,65.832901000000007,177.82777400000001,24.981770999999998,2760.169922,-2.4598272768315024E-2,6.7175742764940427E-2,2.3238723118308872E-2,1.7467253349418002E-3,-4.420785675153277E-3,3.5812645760752555E-2,-1.4780495126007301E-2,3.1173255815880461E-2,1.7701752187834409E-2]
["2018-12-01",27.464082999999999,36.691913999999997,108.573189,5.6,72.307198,62.796470999999997,162.407669,24.099119000000002,2506.8500979999999,-0.14826507981814599,-7.253480281200847E-2,-0.12873072668328445,-2.2948932985544766E-2,-2.5428442992713567E-2,-4.7220850935215941E-2,-9.0705870585245721E-2,-3.5971115089927508E-2,-9.6265219766061866E-2]
["2019-01-01",30.832063999999999,40.954258000000003,121.581535,5.75,76.587729999999993,65.405327,176.01950099999999,26.739547999999999,2704.1000979999999,0.11567610914639881,0.10989938154797141,0.11316060910539635,2.6433257068155646E-2,5.7513199539358351E-2,4.0704830117778569E-2,8.0485140517507672E-2,0.10396838420377387,7.5742151976753658E-2]
["2019-02-01",31.479942000000001,41.419434000000003,126.433662,5.55,77.163628000000003,67.950576999999996,188.91613799999999,26.478012,2784.48999,2.0795393672566262E-2,1.1294405620421968E-2,3.9132651876115594E-2,-3.5401927050915952E-2,7.4913249647922649E-3,3.8176924353536777E-2,7.0708412267092069E-2,-9.8290152938002185E-3,2.9295553154109054E-2]
["2019-03-01",31.976946000000002,42.027003999999998,123.441833,5.51,78.168816000000007,69.305549999999997,196.019058,27.415925999999999,2834.3999020000001,1.5664624552059553E-2,1.4562173081104874E-2,-2.3947702284643543E-2,-7.2333045935200607E-3,1.2942589528816014E-2,1.9744357470189919E-2,3.6908686893793619E-2,3.4809432693088185E-2,1.7765510853122508E-2]
["2019-04-01",32.135899000000002,42.235863000000002,128.85910000000001,5.34,78.945389000000006,70.454193000000004,209.13108800000001,26.926601000000002,2945.830078,4.958548499415634E-3,4.9573302016366434E-3,4.294950209787058E-2,-3.1338970192719584E-2,9.8855393009697826E-3,1.6437764392633194E-2,6.4749381461094324E-2,-1.8009402673158696E-2,3.8560397496415821E-2]
["2019-05-01",28.469866,38.324604000000001,118.377747,5.53,77.43235,69.762114999999994,190.56104999999999,26.808502000000001,2752.0600589999999,-0.12112755958928298,-9.7177602237150912E-2,-8.4838802211633257E-2,3.4962162562139937E-2,-1.9351683011246786E-2,-9.8716565867376736E-3,-9.2988654991126352E-2,-4.3956067285364653E-3,-6.8040893892824417E-2]
["2019-06-01",30.767842999999999,40.603008000000003,125.757088,5.56,79.847954000000001,71.478065000000001,206.661621,27.081037999999999,2941.76001,7.7623891559243541E-2,5.7750060509730014E-2,6.0471416046125263E-2,5.4102927282474794E-3,3.0719599357916592E-2,2.4299522040500336E-2,8.1110158889483044E-2,1.0114702167766122E-2,6.6658301495081035E-2]
["2019-07-01",30.377752000000001,39.413798999999997,127.439926,5.31,79.982635000000002,71.845741000000004,214.614395,26.922194000000001,2980.3798830000001,-1.275958774954576E-2,-2.9726169118583268E-2,1.3292911739688069E-2,-4.60062730086436E-2,1.6852973228679653E-3,5.1307150825384484E-3,3.7760131675272868E-2,-5.8827759824929852E-3,1.3042724816945116E-2]
["2019-08-01",27.736605000000001,37.515030000000003,120.51174899999999,5.03,80.550895999999995,75.274696000000006,209.90635700000001,27.271470999999998,2926.459961,-9.0957477428463662E-2,-4.9374330737124196E-2,-5.5897834683833247E-2,-5.4171851142199502E-2,7.0796844744702722E-3,4.6622701336116415E-2,-2.2181394013747052E-2,1.2890135265085218E-2,-1.825728178481683E-2]
["2019-09-01",28.629003999999998,38.167133,124.852768,5.25,80.901695000000004,77.772407999999999,211.86230499999999,27.271470999999998,2976.73999,3.1667308870396434E-2,1.7233099914652366E-2,3.5387936832363583E-2,4.2808092491884435E-2,4.3455425504187609E-3,3.2642679489578767E-2,9.2750467170803173E-3,0,1.7035250490979523E-2]
["2019-10-01",28.206377,39.461750000000002,127.49587200000001,5.35,80.911972000000006,77.622703999999999,220.66201799999999,28.661255000000001,3037.5600589999999,-1.4872242690451945E-2,3.3357095726493723E-2,2.0948800519019789E-2,1.8868484304382736E-2,1.2702264529765257E-4,-1.9267536074515309E-3,4.069564164627517E-2,4.9705073231069985E-2,2.0225842365795155E-2]
["2019-11-01",28.606338999999998,39.260365,130.65652499999999,5.35,81.359818000000004,76.050049000000001,233.00543200000001,28.576902,3140.9799800000001,1.4080249491958283E-2,-5.1163625191519083E-3,2.4487945710486795E-2,0,5.519716483723707E-3,-2.0468298698316924E-2,5.4429566016930282E-2,-2.9474415490850403E-3,3.3480265788399043E-2]
["2019-12-01",29.197189000000002,41.84,133.30175800000001,5.56,82.639296999999999,77.935310000000001,241.589584,28.305098000000001,3230.780029,2.0444100893781337E-2,6.3637333957172984E-2,2.0043482080522219E-2,3.8501547354575852E-2,1.560380323250312E-2,2.4487460588759499E-2,3.6178585949833482E-2,-9.5568393770893226E-3,2.8188756355889417E-2]
["2020-01-01",27.000679000000002,38.827820000000003,129.76397700000001,5.39,82.872894000000002,83.355620999999999,251.48040800000001,29.371689,3225.5200199999999,-7.8210423680703592E-2,-7.4715819747246642E-2,-2.6898176607078318E-2,-3.1052723341585254E-2,2.8227184196156405E-3,6.7236921828420476E-2,4.0124733360459096E-2,3.6989321449460273E-2,-1.6294193652275938E-3]
["2020-02-01",23.021629000000001,39.726703999999998,116.55735,5.15,81.462165999999996,74.667191000000003,233.14720199999999,27.063638999999998,2954.219971,-0.1594278484936611,2.288660639585316E-2,-0.10733381223125638,-4.5548670245260894E-2,-1.7169344814376254E-2,-0.11007525995152392,-7.5695063584461347E-2,-8.1840158581046096E-2,-8.7859536953221323E-2]
["2020-03-01",14.504574,36.678317999999997,86.999184,4.8,73.275833000000006,66.840339999999998,209.64946,21.054905000000002,2584.5900879999999,-0.46197011738356275,-7.983781612077552E-2,-0.29248468725618493,-7.0380796761799619E-2,-0.10590783693797785,-0.11073399499506048,-0.10623312443248813,-0.25105754302554767,-0.13366772472854824]
["2020-04-01",19.328453,37.704216000000002,98.778717,4.75,76.809639000000004,69.560883000000004,240.358521,22.339321000000002,2912.429932,0.28711421101870643,2.7586128155658449E-2,0.12698342726867282,-1.0471299867295366E-2,4.7099285424597799E-2,3.9895592993926997E-2,0.13669474828468686,5.921484965557413E-2,0.11942083884125214]
["2020-05-01",19.675668999999999,38.153655999999998,103.51899,4.91,79.105225000000004,72.354445999999996,259.25943000000001,22.55592,3044.3100589999999,1.7804537288939097E-2,1.1849666939846508E-2,4.6872907567290033E-2,3.3129323759879342E-2,2.9448788127141565E-2,3.9374518985378533E-2,7.5697574427632239E-2,9.6491599436174056E-3,4.4286532959149118E-2]
["2020-06-01",19.299515,38.788738000000002,105.151527,4.93,78.698479000000006,68.471778999999998,276.81951900000001,22.811900999999999,3100.290039,-1.930283020528057E-2,1.6508361384336999E-2,1.5647350018317793E-2,4.0650462481693723E-3,-5.1550995377681024E-3,-5.5155227490529653E-2,6.5536517271498812E-2,1.1284814253225734E-2,1.822137420311417E-2]
["2020-07-01",18.664937999999999,40.756844000000001,109.13088999999999,5.12,82.655426000000006,73.958427,293.99520899999999,23.477817999999999,3271.1201169999999,-3.3433175425532875E-2,4.9493829740599911E-2,3.7145563348187347E-2,3.7815450996817664E-2,4.9056643764819385E-2,7.7081463062223757E-2,6.0197733411702495E-2,2.8773687024570938E-2,5.363680159734547E-2]
["2020-08-01",18.518737999999999,43.308456,114.18032100000001,5.43,82.654326999999995,72.005295000000004,326.73324600000001,24.558512,3500.3100589999999,-7.8637062882478907E-3,6.0724128120753909E-2,4.5230974379939629E-2,5.8784694894427655E-2,-1.329625119008483E-5,-2.6763480060975581E-2,0.10558060522737814,4.5002454635998813E-2,6.7719083177738171E-2]
["2020-09-01",15.55574,41.377510000000001,109.31862599999999,5.53,81.882880999999998,71.838027999999994,310.10537699999998,23.735598,3363,-0.17435338200198156,-4.5610408115924879E-2,-4.3512169507706491E-2,1.8248681588399533E-2,-9.3772303820757585E-3,-2.3256842501186326E-3,-5.2231910990956469E-2,-3.4082568578490645E-2,-4.0018120099239295E-2]
["2020-10-01",15.221303000000001,43.446381000000002,113.400009,5.69,82.192993000000001,75.827499000000003,297.398346,22.950001,3269.959961,-2.1733742538414879E-2,4.8790060593491766E-2,3.6654678283773882E-2,2.8522432603996117E-2,3.7801093081074595E-3,5.4047036770865434E-2,-4.1839693046655149E-2,-3.3657966466269763E-2,-2.8055692266440762E-2]
["2020-11-01",19.390574000000001,46.303401999999998,133.158051,6,84.945351000000002,77.142394999999993,334.66421500000001,26.200001,3621.6298830000001,0.24209111189725843,6.3687878611415463E-2,0.16061530541349553,5.3049221089815392E-2,3.2938065191093664E-2,1.719198924490839E-2,0.11805521338221985,0.13244146885545149,0.10214642793925913]
["2020-12-01",20.044187999999998,45.741852000000002,141.33757,6.58,86.279021999999998,77.008422999999993,353.08758499999999,27.17,3756.070068,3.315216471439799E-2,-1.2201758215198181E-2,5.9614366457435175E-2,9.2275276109170842E-2,1.5578365958143086E-2,-1.7381942628551088E-3,5.3588456445364085E-2,3.6353974503267009E-2,3.6449047693140835E-2]
["2021-01-01",21.040001,49.360000999999997,145.11000100000001,6.78,86.652000000000001,76.790001000000004,351.29998799999998,26.719999000000001,3714.23999,4.8486198979136814E-2,7.6126722356973084E-2,2.6340939864666693E-2,2.9942356615078318E-2,4.3136109880938635E-3,-2.8403691164850652E-3,-5.0756171919426199E-3,-1.6701112194961787E-2,-1.1199137618311695E-2]
["2021-02-01",22.719999000000001,51.689999,153.800003,6.81,87.199982000000006,78.629997000000003,370.70001200000002,27.040001,3886.830078,{"$f":"LN(B63/B62)","v":7.6820114440840082E-2},{"$f":"LN(C63/C62)","v":4.6123920005394503E-2},5.8160994183069768E-2,4.4150182091166933E-3,6.3040272358495537E-3,2.3678831485066259E-2,5.3752617414933722E-2,1.1904976913716522E-2,4.5419856946961754E-2]
[]
["Monthly Standard Deviation",null,null,null,null,null,null,null,null,null,{"$f":"STDEV(K4:K63)","v":9.9217159981010036E-2},{"$f":"STDEV(L4:L63)","v":5.3050800188961703E-2},6.4012789485369537E-2,3.3805992384081628E-2,2.1449274394527575E-2,3.986990560874399E-2,5.3171628662876974E-2,5.1645068126809718E-2,4.3658157656429206E-2]
["Annualized Standard Deviation",null,null,null,null,null,null,null,null,null,{"$f":"K65*SQRT(12)","v":0.34369832413959783},{"$f":"L65*SQRT(12)","v":0.18377336261893251},0.22174680744574168,0.11710739281903179,7.4302466073615847E-2,0.13811340441463987,0.18419192473057705,0.1789037639119809,0.15123629445157513]
["Correlation with S&P",null,null,null,null,null,null,null,null,null,{"$f":"CORREL(K4:K63,$S$4:$S$63)","v":0.82780865287622463},{"$f":"CORREL(L4:L63,$S$4:$S$63)","v":0.60652603797620663},0.90758755270446667,0.32710970415333102,0.79793610482230803,0.45532434328262805,0.90011596004180738,0.75544720411096111,1]
["Beta",null,null,null,null,null,null,null,null,null,{"$f":"K67*(K66/$S$66)","v":1.8812709457974506},{"$f":"L67*(L66/$S$66)","v":0.73701441786194832},1.3307297895621857,0.25329213968190056,0.39202640194584076,0.41581549846660476,1.0962586180918223,0.89365022293314855,1]
["Expected Return from CAPM",null,null,null,null,null,null,null,null,null,{"$f":"$U$1+K68*$U$2","v":0.13723244391045469},{"$f":"$U$1+L68*$U$2","v":7.2009821818131065E-2},0.10585159800504458,4.443765196186833E-2,5.2345504910912923E-2,5.3701483412596472E-2,9.2486741231233877E-2,8.0938062707189465E-2,{"$f":"$U$1+S68*$U$2","v":8.6999999999999994E-2}]

{"sheet":"Correlation Matrix","index":2,"n_rows":11,"n_cols":14,"rows_kept":11,"cut":false,"hidden":false,"merged":[[0,2,0,9]]}
[null,null,"Correlation Matrix"]
[null,null,{"$f":"Returns!K3","v":"_1"},{"$f":"Returns!L3","v":"_2"},{"$f":"Returns!M3","v":"_3"},{"$f":"Returns!N3","v":"_4"},{"$f":"Returns!O3","v":"_5"},{"$f":"Returns!P3","v":"_6"},{"$f":"Returns!Q3","v":"_7"},{"$f":"Returns!R3","v":"_8"}]
[null,null,{"$f":"Returns!B2","v":"IYE"},{"$f":"Returns!C2","v":"FXI"},{"$f":"Returns!D2","v":"VBR"},{"$f":"Returns!E2","v":"RJA"},{"$f":"Returns!F2","v":"HYG"},{"$f":"Returns!G2","v":"IDU"},{"$f":"Returns!H2","v":"VGT"},{"$f":"Returns!I2","v":"IFGL"},null,null,"Stand Dev","Expect Ret"]
[{"$f":"C2","v":"_1"},{"$f":"C3","v":"IYE"},{"$f":"CORREL(INDIRECT(C$2),INDIRECT($A4))","v":1.0000000000000002},0.49999578923056731,0.90762178035454921,0.35013416696550431,0.80707030266127289,0.37966319160363238,0.63484653361854282,0.72667529025711208,null,{"$f":"B4","v":"IYE"},{"$f":"Returns!K66","v":0.34369832413959783},{"$f":"Returns!K69","v":0.13723244391045469}]
[{"$f":"D2","v":"_2"},{"$f":"D3","v":"FXI"},0.49999578923056731,1,0.56541244184658324,0.29700085949587174,0.51867880682119383,0.22032444165414208,0.55386016412840877,0.5893410785683405,null,{"$f":"B5","v":"FXI"},{"$f":"Returns!L66","v":0.18377336261893251},{"$f":"Returns!L69","v":7.2009821818131065E-2}]
[{"$f":"E2","v":"_3"},{"$f":"E3","v":"VBR"},0.90762178035454921,0.56541244184658324,0.99999999999999978,0.41309165081448868,0.83171795845544971,0.44498015114967387,0.74765751891406251,0.7586163622978549,null,"VBR",{"$f":"Returns!M66","v":0.22174680744574168},{"$f":"Returns!M69","v":0.10585159800504458}]
[{"$f":"F2","v":"_4"},{"$f":"F3","v":"RJA"},0.35013416696550431,0.29700085949587174,0.41309165081448868,1.0000000000000002,0.36116548324206565,0.19179329807452075,0.19799638727546207,0.40362141073810281,null,"RJA",{"$f":"Returns!N66","v":0.11710739281903179},{"$f":"Returns!N69","v":4.443765196186833E-2}]
[{"$f":"G2","v":"_5"},{"$f":"G3","v":"HYG"},0.80707030266127289,0.51867880682119383,0.83171795845544971,0.36116548324206565,1,0.56756823678998347,0.64296971267562208,0.78777413756647452,null,"HYG",{"$f":"Returns!O66","v":7.4302466073615847E-2},{"$f":"Returns!O69","v":5.2345504910912923E-2}]
[{"$f":"H2","v":"_6"},{"$f":"H3","v":"IDU"},0.37966319160363238,0.22032444165414208,0.44498015114967387,0.19179329807452075,0.56756823678998347,1.0000000000000002,0.36871386018042362,0.51553899094557365,null,"IDU",{"$f":"Returns!P66","v":0.13811340441463987},{"$f":"Returns!P69","v":5.3701483412596472E-2}]
[{"$f":"I2","v":"_7"},{"$f":"I3","v":"VGT"},0.63484653361854282,0.55386016412840877,0.74765751891406251,0.19799638727546207,0.64296971267562208,0.36871386018042362,1,0.64432423596280464,null,"VGT",{"$f":"Returns!Q66","v":0.18419192473057705},{"$f":"Returns!Q69","v":9.2486741231233877E-2}]
[{"$f":"J2","v":"_8"},{"$f":"J3","v":"IFGL"},0.72667529025711208,0.5893410785683405,0.7586163622978549,0.40362141073810281,0.78777413756647452,0.51553899094557365,0.64432423596280464,1,null,"IFGL",{"$f":"Returns!R66","v":0.1789037639119809},{"$f":"Returns!R69","v":8.0938062707189465E-2}]

{"sheet":"Covar Matrix","index":3,"n_rows":1048530,"n_cols":10,"rows_kept":4500,"cut":true,"hidden":false,"merged":[[0,3,0,8],[11,3,11,8]],"bounds":{"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0}}
[null,null,null,"Var/Cov Matrix"]
[null,null,{"$f":"'Correlation Matrix'!C3","v":"IYE"},{"$f":"'Correlation Matrix'!D3","v":"FXI"},{"$f":"'Correlation Matrix'!E3","v":"VBR"},{"$f":"'Correlation Matrix'!F3","v":"RJA"},{"$f":"'Correlation Matrix'!G3","v":"HYG"},{"$f":"'Correlation Matrix'!H3","v":"IDU"},{"$f":"'Correlation Matrix'!I3","v":"VGT"},{"$f":"'Correlation Matrix'!J3","v":"IFGL"}]
[null,{"$f":"C2","v":"IYE"},{"$f":"'Correlation Matrix'!C4*'Correlation Matrix'!$M$4*'Correlation Matrix'!M4","v":0.11812853801636808},{"$f":"'Correlation Matrix'!D4*'Correlation Matrix'!$M$5*'Correlation Matrix'!M4","v":3.1581032413681161E-2},{"$f":"'Correlation Matrix'!E4*'Correlation Matrix'!$M$6*'Correlation Matrix'!M4","v":6.9173491906619575E-2},{"$f":"'Correlation Matrix'!F4*'Correlation Matrix'!$M$7*'Correlation Matrix'!M4","v":1.4092765298351727E-2},{"$f":"'Correlation Matrix'!G4*'Correlation Matrix'!$M$8*'Correlation Matrix'!M4","v":2.0610665250202817E-2},{"$f":"'Correlation Matrix'!H4*'Correlation Matrix'!$M$9*'Correlation Matrix'!M4","v":1.8022363268458845E-2},{"$f":"'Correlation Matrix'!I4*'Correlation Matrix'!$M$10*'Correlation Matrix'!M4","v":4.0189884052013715E-2},{"$f":"'Correlation Matrix'!J4*'Correlation Matrix'!$M$11*'Correlation Matrix'!M4","v":4.468248157816769E-2}]
[null,{"$f":"D2","v":"FXI"},{"$f":"'Correlation Matrix'!C5*'Correlation Matrix'!$M$4*'Correlation Matrix'!M5","v":3.1581032413681161E-2},{"$f":"'Correlation Matrix'!D5*'Correlation Matrix'!$M$5*'Correlation Matrix'!M5","v":3.3772648808269662E-2},{"$f":"'Correlation Matrix'!E5*'Correlation Matrix'!$M$6*'Correlation Matrix'!M5","v":2.3041210878907464E-2},{"$f":"'Correlation Matrix'!F5*'Correlation Matrix'!$M$7*'Correlation Matrix'!M5","v":6.3918206490684408E-3},{"$f":"'Correlation Matrix'!G5*'Correlation Matrix'!$M$8*'Correlation Matrix'!M5","v":7.0824626542691817E-3},{"$f":"'Correlation Matrix'!H5*'Correlation Matrix'!$M$9*'Correlation Matrix'!M5","v":5.5921790822987772E-3},{"$f":"'Correlation Matrix'!I5*'Correlation Matrix'!$M$10*'Correlation Matrix'!M5","v":1.8747928049708731E-2},{"$f":"'Correlation Matrix'!J5*'Correlation Matrix'!$M$11*'Correlation Matrix'!M5","v":1.9376206453132046E-2}]
[null,{"$f":"E2","v":"VBR"},{"$f":"'Correlation Matrix'!C6*'Correlation Matrix'!$M$4*'Correlation Matrix'!M6","v":6.9173491906619589E-2},{"$f":"'Correlation Matrix'!D6*'Correlation Matrix'!$M$5*'Correlation Matrix'!M6","v":2.3041210878907464E-2},{"$f":"'Correlation Matrix'!E6*'Correlation Matrix'!$M$6*'Correlation Matrix'!M6","v":4.9171646612378828E-2},{"$f":"'Correlation Matrix'!F6*'Correlation Matrix'!$M$7*'Correlation Matrix'!M6","v":1.0727242676491592E-2},{"$f":"'Correlation Matrix'!G6*'Correlation Matrix'!$M$8*'Correlation Matrix'!M6","v":1.3703663407255718E-2},{"$f":"'Correlation Matrix'!H6*'Correlation Matrix'!$M$9*'Correlation Matrix'!M6","v":1.3628053995023238E-2},{"$f":"'Correlation Matrix'!I6*'Correlation Matrix'!$M$10*'Correlation Matrix'!M6","v":3.0537302219553E-2},{"$f":"'Correlation Matrix'!J6*'Correlation Matrix'!$M$11*'Correlation Matrix'!M6","v":3.009532649088055E-2}]
[null,{"$f":"F2","v":"RJA"},{"$f":"'Correlation Matrix'!C7*'Correlation Matrix'!$M$4*'Correlation Matrix'!M7","v":1.4092765298351727E-2},{"$f":"'Correlation Matrix'!D7*'Correlation Matrix'!$M$5*'Correlation Matrix'!M7","v":6.3918206490684417E-3},{"$f":"'Correlation Matrix'!E7*'Correlation Matrix'!$M$6*'Correlation Matrix'!M7","v":1.0727242676491592E-2},{"$f":"'Correlation Matrix'!F7*'Correlation Matrix'!$M$7*'Correlation Matrix'!M7","v":1.3714141452871023E-2},{"$f":"'Correlation Matrix'!G7*'Correlation Matrix'!$M$8*'Correlation Matrix'!M7","v":3.142633808168563E-3},{"$f":"'Correlation Matrix'!H7*'Correlation Matrix'!$M$9*'Correlation Matrix'!M7","v":3.1020841174784477E-3},{"$f":"'Correlation Matrix'!I7*'Correlation Matrix'!$M$10*'Correlation Matrix'!M7","v":4.2708288172152217E-3},{"$f":"'Correlation Matrix'!J7*'Correlation Matrix'!$M$11*'Correlation Matrix'!M7","v":8.4562533503588812E-3}]
[null,{"$f":"G2","v":"HYG"},{"$f":"'Correlation Matrix'!C8*'Correlation Matrix'!$M$4*'Correlation Matrix'!M8","v":2.0610665250202817E-2},{"$f":"'Correlation Matrix'!D8*'Correlation Matrix'!$M$5*'Correlation Matrix'!M8","v":7.0824626542691817E-3},{"$f":"'Correlation Matrix'!E8*'Correlation Matrix'!$M$6*'Correlation Matrix'!M8","v":1.3703663407255718E-2},{"$f":"'Correlation Matrix'!F8*'Correlation Matrix'!$M$7*'Correlation Matrix'!M8","v":3.142633808168563E-3},{"$f":"'Correlation Matrix'!G8*'Correlation Matrix'!$M$8*'Correlation Matrix'!M8","v":5.5208564646208342E-3},{"$f":"'Correlation Matrix'!H8*'Correlation Matrix'!$M$9*'Correlation Matrix'!M8","v":5.8244797720620944E-3},{"$f":"'Correlation Matrix'!I8*'Correlation Matrix'!$M$10*'Correlation Matrix'!M8","v":8.7996283455207703E-3},{"$f":"'Correlation Matrix'!J8*'Correlation Matrix'!$M$11*'Correlation Matrix'!M8","v":1.0471874401365688E-2}]
[null,{"$f":"H2","v":"IDU"},{"$f":"'Correlation Matrix'!C9*'Correlation Matrix'!$M$4*'Correlation Matrix'!M9","v":1.8022363268458848E-2},{"$f":"'Correlation Matrix'!D9*'Correlation Matrix'!$M$5*'Correlation Matrix'!M9","v":5.5921790822987772E-3},{"$f":"'Correlation Matrix'!E9*'Correlation Matrix'!$M$6*'Correlation Matrix'!M9","v":1.362805399502324E-2},{"$f":"'Correlation Matrix'!F9*'Correlation Matrix'!$M$7*'Correlation Matrix'!M9","v":3.1020841174784477E-3},{"$f":"'Correlation Matrix'!G9*'Correlation Matrix'!$M$8*'Correlation Matrix'!M9","v":5.8244797720620944E-3},{"$f":"'Correlation Matrix'!H9*'Correlation Matrix'!$M$9*'Correlation Matrix'!M9","v":1.907531247900187E-2},{"$f":"'Correlation Matrix'!I9*'Correlation Matrix'!$M$10*'Correlation Matrix'!M9","v":9.3798497107665905E-3},{"$f":"'Correlation Matrix'!J9*'Correlation Matrix'!$M$11*'Correlation Matrix'!M9","v":1.2738456998215795E-2}]
[null,{"$f":"I2","v":"VGT"},{"$f":"'Correlation Matrix'!C10*'Correlation Matrix'!$M$4*'Correlation Matrix'!M10","v":4.0189884052013715E-2},{"$f":"'Correlation Matrix'!D10*'Correlation Matrix'!$M$5*'Correlation Matrix'!M10","v":1.8747928049708731E-2},{"$f":"'Correlation Matrix'!E10*'Correlation Matrix'!$M$6*'Correlation Matrix'!M10","v":3.0537302219553E-2},{"$f":"'Correlation Matrix'!F10*'Correlation Matrix'!$M$7*'Correlation Matrix'!M10","v":4.2708288172152225E-3},{"$f":"'Correlation Matrix'!G10*'Correlation Matrix'!$M$8*'Correlation Matrix'!M10","v":8.7996283455207703E-3},{"$f":"'Correlation Matrix'!H10*'Correlation Matrix'!$M$9*'Correlation Matrix'!M10","v":9.3798497107665905E-3},{"$f":"'Correlation Matrix'!I10*'Correlation Matrix'!$M$10*'Correlation Matrix'!M10","v":3.3926665135954562E-2},{"$f":"'Correlation Matrix'!J10*'Correlation Matrix'!$M$11*'Correlation Matrix'!M10","v":2.123217725628759E-2}]
[null,{"$f":"J2","v":"IFGL"},{"$f":"'Correlation Matrix'!C11*'Correlation Matrix'!$M$4*'Correlation Matrix'!M11","v":4.4682481578167697E-2},{"$f":"'Correlation Matrix'!D11*'Correlation Matrix'!$M$5*'Correlation Matrix'!M11","v":1.9376206453132046E-2},{"$f":"'Correlation Matrix'!E11*'Correlation Matrix'!$M$6*'Correlation Matrix'!M11","v":3.009532649088055E-2},{"$f":"'Correlation Matrix'!F11*'Correlation Matrix'!$M$7*'Correlation Matrix'!M11","v":8.4562533503588812E-3},{"$f":"'Correlation Matrix'!G11*'Correlation Matrix'!$M$8*'Correlation Matrix'!M11","v":1.047187440136569E-2},{"$f":"'Correlation Matrix'!H11*'Correlation Matrix'!$M$9*'Correlation Matrix'!M11","v":1.2738456998215795E-2},{"$f":"'Correlation Matrix'!I11*'Correlation Matrix'!$M$10*'Correlation Matrix'!M11","v":2.123217725628759E-2},{"$f":"'Correlation Matrix'!J11*'Correlation Matrix'!$M$11*'Correlation Matrix'!M11","v":3.2006556741873797E-2}]
[]
[null,null,null,"Weighted Var/Cov Matrix"]
[null,null,{"$f":"C2","v":"IYE"},{"$f":"D2","v":"FXI"},"VBR","RJA","HYG","IDU","VGT","IFGL"]
[null,"Weights",{"$f":"B15","v":-8.5456671366218553E-2},{"$f":"B16","v":2.3596195168437657E-2},{"$f":"B17","v":-0.15009221988178126},{"$f":"B18","v":0.15952502244889305},{"$f":"B19","v":1.1477627191325142},{"$f":"B20","v":-2.0228660710092019E-2},{"$f":"B21","v":5.9955617105507258E-2},{"$f":"B22","v":-0.13506197865726438}]
[{"$f":"B3","v":"IYE"},-8.5456671366218553E-2,{"$f":"C3*$B$15*C14","v":8.626741292693408E-4},{"$f":"D3*B15*$D$14","v":-6.3681645320691404E-5},{"$f":"E3*B15*$E$14","v":8.872455975084256E-4},{"$f":"F3*B15*$F$14","v":-1.9211930468841524E-4},{"$f":"G3*B15*$G$14","v":-2.021576109006812E-3},{"$f":"H3*B15*$H$14","v":3.1154790989633493E-5},{"$f":"I3*B15*$I$14","v":-2.0591719004863163E-4},{"$f":"J3*B15*$J$14","v":5.1572283975258478E-4}]
[{"$f":"B4","v":"FXI"},2.3596195168437657E-2,{"$f":"C4*B16*$C$14","v":-6.3681645320691404E-5},1.8803949805037716E-5,-8.1602874880391666E-5,2.4059986230961885E-5,1.9181315419879258E-4,-2.66925571027524E-6,2.6523152061260237E-5,-6.1750978063869691E-5]
["VBR",-0.15009221988178126,{"$f":"C5*B17*$C$14","v":8.8724559750842581E-4},-8.1602874880391666E-5,1.1077228479903915E-3,-2.5684735684684953E-4,-2.360733581546392E-3,4.137701498682952E-5,-2.7480126369190926E-4,6.1008500094990065E-4]
["RJA",0.15952502244889305,-1.9211930468841524E-4,2.4059986230961888E-5,-2.5684735684684953E-4,3.4900066417089442E-4,5.7540642494299343E-4,-1.0010355817376875E-5,4.0848005530155238E-5,-1.821964489665213E-4]
["HYG",1.1477627191325142,-2.0215761090068124E-3,1.9181315419879256E-4,-2.3607335815463916E-3,5.7540642494299332E-4,7.2729513836547839E-3,-1.3523103926990892E-4,6.0554485928643006E-4,-1.6233405855920922E-3]
["IDU",-2.0228660710092019E-2,3.11547909896335E-5,-2.66925571027524E-6,4.1377014986829527E-5,-1.0010355817376875E-5,-1.3523103926990895E-4,7.8055933379214475E-6,-1.1376086548474221E-5,3.4803030598932817E-5]
["VGT",5.9955617105507258E-2,-2.0591719004863163E-4,2.6523152061260234E-5,-2.7480126369190926E-4,4.0848005530155251E-5,6.0554485928643017E-4,-1.1376086548474221E-5,1.2195536968767702E-4,-1.7193231724064312E-4]
["IFGL",-0.13506197865726438,5.1572283975258489E-4,-6.1750978063869691E-5,6.1008500094990065E-4,-1.821964489665213E-4,-1.6233405855920922E-3,3.4803030598932824E-5,-1.7193231724064312E-4,5.8385522489000298E-4]
["Sum",{"$f":"SUM(B15:B22)","v":1.0000000232399959}]
[]
["Port. Var",{"$f":"SUM(C15:J22)","v":2.1823640904013414E-3}]
["Port. S.D.",{"$f":"SQRT(B25)","v":4.6715779886472422E-2}]
["Port. E(R.)",{"$f":"SUMPRODUCT('Correlation Matrix'!N4:N11,B15:B22)","v":3.4780500763817349E-2}]
[]
["Sharpe",{"$f":"(B27-Returns!U1)/'Covar Matrix'!B26","v":0.10233160562522575}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["$b$17",{"$f":"IF(ISBLANK(A1048500)=TRUE,\"\",INDIRECT(A1048500))","v":-0.15009221988178126},"this is foreign investments"]
["$b$18",{"$f":"IF(ISBLANK(A1048501)=TRUE,\"\",INDIRECT(A1048501))","v":0.15952502244889305}]
["$b$19",{"$f":"IF(ISBLANK(A1048502)=TRUE,\"\",INDIRECT(A1048502))","v":1.1477627191325142}]
["$b$22",-0.13506197865726438]
["$b$20",-2.0228660710092019E-2]
["$b$21",5.9955617105507258E-2]
[null,{"$f":"SUM(B1048500:B1048505)","v":1.0618604994377767}]
["$b$16",{"$f":"IF(ISBLANK(A1048507)=TRUE,\"\",INDIRECT(A1048507))","v":2.3596195168437657E-2},"this is fixed income"]
["$b$17",{"$f":"IF(ISBLANK(A1048508)=TRUE,\"\",INDIRECT(A1048508))","v":-0.15009221988178126}]
["$b$18",{"$f":"IF(ISBLANK(A1048509)=TRUE,\"\",INDIRECT(A1048509))","v":0.15952502244889305}]
["$b$19",1.1477627191325142]
["$b$20",-2.0228660710092019E-2]
[null,{"$f":"SUM(B1048507:B1048511)","v":1.1605630561579716}]
[]
[]
[]
[]
["$b$15",{"$f":"IF(ISBLANK(A1048517)=TRUE,\"\",INDIRECT(A1048517))","v":-8.5456671366218553E-2},"this is real estate"]
["$b$22",{"$f":"IF(ISBLANK(A1048518)=TRUE,\"\",INDIRECT(A1048518))","v":-0.13506197865726438}]
[]
[]
[]
[null,{"$f":"SUM(B1048517:B1048521)","v":-0.22051865002348292}]
[]
[]
["$b$16",{"$f":"IF(ISBLANK(A1048525)=TRUE,\"\",INDIRECT(A1048525))","v":2.3596195168437657E-2},"This is for commodities"]
["$b$18",{"$f":"IF(ISBLANK(A1048526)=TRUE,\"\",INDIRECT(A1048526))","v":0.15952502244889305}]
["$b$20",{"$f":"IF(ISBLANK(A1048527)=TRUE,\"\",INDIRECT(A1048527))","v":-2.0228660710092019E-2}]
[]
[]
[null,{"$f":"SUM(B1048525:B1048529)","v":0.16289255690723869}]

{"sheet":"Efficient Frontier","index":4,"n_rows":16,"n_cols":11,"rows_kept":16,"cut":false,"hidden":false,"merged":[[0,3,0,8]]}
[null,null,null,"Efficient Frontier"]
["Expect. Ret.","Stand. Dev.",{"$f":"'Covar Matrix'!C13","v":"IYE"},{"$f":"'Covar Matrix'!D13","v":"FXI"},{"$f":"'Covar Matrix'!E13","v":"VBR"},{"$f":"'Covar Matrix'!F13","v":"RJA"},{"$f":"'Covar Matrix'!G13","v":"HYG"},{"$f":"'Covar Matrix'!H13","v":"IDU"},{"$f":"'Covar Matrix'!I13","v":"VGT"},{"$f":"'Covar Matrix'!J13","v":"IFGL"}]
[2.0000001019494E-2,6.2865997834002929E-2,-0.1262629720111024,2.0071472782481604E-2,-0.25444854254068988,0.19806333789281291,1.4177154594608694,-3.658551549749213E-2,-4.699325659937964E-2,-0.17155998348749985]
[3.0000000840275209E-2,4.8656944471475845E-2,-9.8638593507668099E-2,2.2450463865789787E-2,-0.18385519676833492,0.17199878865036422,1.2350648458123448,-2.5495904492610875E-2,2.5364893106322371E-2,-0.14688929666620709]
[4.0000000660660257E-2,4.9021010159238591E-2,-7.1043510787789171E-2,2.4834625720993781E-2,-0.11324408282953187,0.14591524047935292,1.0524382463973028,-1.4449653282980448E-2,9.7728660149702634E-2,-0.12217952584705052]
[5.0000000481176518E-2,6.3708847895526041E-2,-4.3438865159768261E-2,2.7225322476396585E-2,-4.2635484923588526E-2,0.11984206266803407,0.86979191814891899,-3.385948301078467E-3,0.17008138664026137,-9.7480391549175621E-2]
[6.0000000301738389E-2,8.5643282425450218E-2,-1.5830684627563138E-2,2.9609905693823553E-2,2.7968743774694497E-2,9.3768407869682893E-2,0.68715085601621606,7.680519603380882E-3,0.24243962788517298,-7.2787376215407748E-2]
[7.0000000122301356E-2,0.11059350346425641,1.1777487301564117E-2,3.1994608082431486E-2,9.857281460997612E-2,6.7694733381854846E-2,0.50450958747192742,1.8747094967807972E-2,0.31479802391431039,-4.8094349729872414E-2]
[7.9999999933130672E-2,0.1369206735475858,3.9385580406355369E-2,3.4379277682408692E-2,0.16917701313584943,4.1621048471264098E-2,0.32186824598445013,2.9813693232037915E-2,0.38715634299174634,-2.3401201904111952E-2]
[8.9999999771633268E-2,0.16396290460934898,6.7697659380670794E-2,3.6802818862183159E-2,0.23806369787968765,1.5996323615100397E-2,0.13853939188184294,4.1191937774376339E-2,0.46027004153467554,1.4381290714632195E-3]
[0.10000007944832433,0.19141755920059159,9.3536415920183261E-2,3.8934116880066982E-2,0.31297880576311743,-1.0606830105857504E-2,-4.3275736256217348E-2,5.1680852610779572E-2,0.53077403774955711,2.5978337438370459E-2]
[0.10999999940453854,0.21912894454793777,0.12220978070170625,4.1533136366144544E-2,0.38098984238979183,-3.6600005435217874E-2,-0.22605564542272297,6.3013459795862384E-2,0.60423133407432894,5.0678097530107061E-2]
[0.12000007910612187,0.24701167062967705,0.14993381665009323,4.4353816986232142E-2,0.45203676239109536,-6.2763151339151405E-2,-0.4085035078356487,7.451327160482564E-2,0.67663138676759471,7.3797604774958558E-2]
[0.13000007892108356,0.27501287822184206,0.1774265797804318,4.6302646569214276E-2,0.52219828605950558,-8.8747482921675849E-2,-0.59133985409754164,8.5146937252470634E-2,0.74894847940145881,0.10006440795613594]
[3.4780500763817349E-2,4.6715779886472422E-2,-8.5456671366218553E-2,2.3596195168437657E-2,-0.15009221988178126,0.15952502244889305,1.1477627191325142,-2.0228660710092019E-2,5.9955617105507258E-2,-0.13506197865726438,"MVP"]
[9.1132485467299781E-2,0.16705517934648351,7.0479294035860687E-2,3.793327703248426E-2,0.24741364818232001,1.2746783673131264E-2,0.11750156498173979,4.3221064153015257E-2,0.46790550734263775,2.7988615542239199E-3,"MVE"]