1) Calculate the weights on the stocks that minimize risk using Excel's SOLVER. 2) Compute the optimal...

Fantastic news! We've Found the answer you've been seeking!

Question:

1) Calculate the weights on the stocks that minimize risk using Excel's SOLVER.

2) Compute the optimal risky portfolio (e.g. maximize Sharpe ratio)

3) Use 5 points to draw the efficient frontier using these portfolios

Date	AMZNRtrn	QQQRtrn	SPYRtrn	VZRtrn	MSFTRtrn	WMTRtrn	IBMRtrn
2012-01-04	-0.0085	0.0042	0.0016	-0.0131	0.0235	-0.0103	-0.0041
2012-01-05	0.0006	0.0082	0.0027	-0.0069	0.0102	-0.0049	-0.0047
2012-01-06	0.0282	0.0035	-0.0026	-0.0157	0.0155	-0.0071	-0.0115
2012-01-09	-0.0222	-0.0033	0.0024	0.0010	-0.0132	0.0031	-0.0052
2012-01-10	0.0044	0.0073	0.0087	0.0052	0.0036	-0.0024	-0.0015
2012-01-11	-0.0025	0.0021	0.0005	0.0086	-0.0043	0.0061	0.0056
2012-01-12	-0.0166	0.0040	0.0024	0.0005	0.0101	0.0017	-0.0097
2012-01-13	0.0142	-0.0036	-0.0052	0.0000	0.0089	0.0007	-0.0077
2012-01-17	0.0182	0.0091	0.0039	0.0026	0.0004	0.0052	0.0047
2012-01-18	0.0428	0.0133	0.0111	-0.0003	-0.0011	0.0027	0.0059
2012-01-19	0.0264	0.0062	0.0053	-0.0003	-0.0039	0.0100	-0.0030
2012-01-20	-0.0181	-0.0015	0.0006	-0.0008	0.0565	0.0066	0.0443
2012-01-23	-0.0253	0.0003	0.0005	-0.0146	0.0007	-0.0016	0.0077
2012-01-24	0.0049	-0.0018	-0.0011	-0.0159	-0.0131	0.0079	0.0103
2012-01-25	0.0043	0.0126	0.0084	-0.0026	0.0075	0.0013	-0.0010
2012-01-26	0.0294	-0.0035	-0.0051	-0.0093	-0.0020	-0.0081	-0.0039
2012-01-27	0.0106	0.0030	-0.0005	-0.0035	-0.0092	-0.0043	-0.0027
2012-01-30	-0.0165	0.0008	-0.0034	0.0107	0.0130	0.0097	0.0107
2012-01-31	0.0119	0.0013	-0.0004	0.0013	-0.0027	0.0010	0.0005
2012-02-01	-0.0770	0.0081	0.0088	0.0037	0.0122	0.0134	0.0001
2012-02-02	0.0126	0.0031	0.0016	-0.0063	0.0020	-0.0039	-0.0057
2012-02-03	0.0328	0.0137	0.0140	0.0075	0.0097	0.0015	0.0110
2012-02-06	-0.0242	-0.0008	-0.0007	0.0079	-0.0013	-0.0024	-0.0042
2012-02-07	0.0057	0.0021	0.0025	-0.0058	0.0050	-0.0031	0.0027
2012-02-08	0.0070	0.0053	0.0030	0.0000	0.0102	-0.0011	-0.0021
2012-02-09	-0.0027	0.0072	0.0013	0.0000	0.0036	0.0055	0.0009
2012-02-10	0.0030	-0.0070	-0.0074	-0.0061	-0.0088	-0.0010	-0.0037
2012-02-13	0.0326	0.0093	0.0074	0.0117	0.0026	-0.0018	0.0010
2012-02-14	-0.0015	0.0025	-0.0013	-0.0024	-0.0108	0.0070	-0.0021
2012-02-15	-0.0357	-0.0070	-0.0047	-0.0055	-0.0066	-0.0074	0.0002
2012-02-16	-0.0246	0.0137	0.0111	0.0058	0.0413	0.0045	0.0040
2012-02-17	0.0143	-0.0031	0.0026	0.0108	-0.0013	0.0071	0.0021
2012-02-21	-0.0013	0.0028	0.0004	0.0008	0.0061	-0.0386	-0.0002
2012-02-22	-0.0092	-0.0046	-0.0032	-0.0073	-0.0054	-0.0245	0.0025
2012-02-23	-0.0094	0.0066	0.0044	-0.0021	0.0032	-0.0010	0.0193
2012-02-24	0.0013	0.0035	0.0022	0.0003	0.0035	0.0043	0.0008
2012-02-27	-0.0033	0.0014	0.0017	-0.0003	-0.0041	-0.0056	-0.0012
2012-02-28	0.0295	0.0101	0.0029	0.0005	0.0166	0.0080	0.0023
2012-02-29	-0.0224	-0.0045	-0.0039	-0.0010	-0.0041	0.0025	-0.0063
2012-03-01	0.0019	0.0079	0.0052	0.0084	0.0173	-0.0044	0.0041
2012-03-02	-0.0041	-0.0008	-0.0030	0.0062	-0.0065	0.0032	0.0065
2012-03-05	0.0054	-0.0103	-0.0041	0.0085	-0.0087	0.0066	0.0093
2012-03-06	0.0046	-0.0098	-0.0146	-0.0079	-0.0075	-0.0072	-0.0169
2012-03-07	0.0148	0.0077	0.0070	0.0047	0.0089	0.0151	0.0026
2012-03-08	0.0211	0.0108	0.0099	0.0090	0.0053	-0.0015	0.0103
2012-03-09	-0.0177	0.0042	0.0039	-0.0031	-0.0006	0.0052	0.0041
2012-03-12	-0.0050	0.0005	0.0001	0.0056	0.0016	0.0100	0.0019
2012-03-13	0.0065	0.0186	0.0180	0.0041	0.0197	0.0053	0.0138
2012-03-14	-0.0126	0.0035	-0.0011	-0.0003	0.0031	0.0013	0.0046
2012-03-15	0.0119	0.0029	0.0058	0.0018	0.0024	0.0025	0.0063
2012-03-16	0.0034	-0.0024	-0.0030	0.0008	-0.0076	-0.0064	0.0000
2012-03-19	0.0025	0.0071	0.0039	0.0020	-0.0123	-0.0016	-0.0014
2012-03-20	0.0367	0.0018	-0.0029	-0.0005	-0.0065	-0.0023	-0.0071
2012-03-21	-0.0031	0.0001	-0.0016	0.0038	-0.0025	-0.0007	0.0022
2012-03-22	0.0035	-0.0021	-0.0072	-0.0030	0.0028	0.0015	0.0039
2012-03-23	0.0137	-0.0006	0.0032	-0.0061	0.0003	0.0016	0.0000
2012-03-26	0.0401	0.0175	0.0140	-0.0023	0.0181	0.0074	0.0111
2012-03-27	0.0127	0.0015	-0.0031	-0.0170	-0.0021	-0.0018	-0.0028
2012-03-28	-0.0208	-0.0040	-0.0050	-0.0103	-0.0101	0.0016	0.0005
2012-03-29	0.0172	-0.0038	-0.0017	-0.0050	-0.0022	-0.0060	0.0047
2012-03-30	-0.0103	-0.0019	0.0041	0.0042	0.0044	0.0062	0.0018
2012-04-02	-0.0220	0.0104	0.0073	0.0076	0.0009	0.0026	0.0039
2012-04-03	0.0081	-0.0003	-0.0041	-0.0016	-0.0108	-0.0116	0.0001
2012-04-04	-0.0284	-0.0136	-0.0099	-0.0018	-0.0229	-0.0064	-0.0165
2012-04-05	0.0021	0.0062	-0.0005	-0.0190	0.0099	0.0068	-0.0028
2012-04-09	-0.0130	-0.0075	-0.0112	-0.0053	-0.0133	-0.0089	-0.0026
2012-04-10	-0.0255	-0.0161	-0.0168	-0.0176	-0.0203	-0.0033	-0.0127
2012-04-11	0.0053	0.0048	0.0081	0.0158	-0.0039	-0.0022	0.0012
2012-04-12	0.0145	0.0114	0.0131	0.0045	0.0208	0.0057	0.0135
2012-04-13	-0.0117	-0.0152	-0.0119	-0.0077	-0.0055	-0.0062	-0.0123
2012-04-16	-0.0157	-0.0112	-0.0007	0.0046	0.0088	0.0136	-0.0004
2012-04-17	0.0156	0.0203	0.0148	0.0083	0.0116	0.0213	0.0233
2012-04-18	0.0142	-0.0025	-0.0034	-0.0021	-0.0095	0.0031	-0.0353
2012-04-19	0.0002	-0.0113	-0.0064	0.0130	-0.0042	-0.0050	-0.0031
2012-04-20	-0.0059	-0.0027	0.0017	0.0152	0.0455	0.0113	0.0005
2012-04-23	-0.0092	-0.0091	-0.0084	-0.0041	-0.0093	-0.0466	-0.0049
2012-04-24	0.0111	-0.0054	0.0038	0.0241	-0.0062	-0.0297	0.0069
2012-04-25	0.0215	0.0266	0.0137	-0.0005	0.0088	-0.0071	0.0178
2012-04-26	0.0081	0.0059	0.0070	0.0167	-0.0028	0.0277	0.0099
2012-04-27	0.1575	0.0060	0.0016	0.0022	-0.0040	0.0014	0.0060
2012-04-30	0.0223	-0.0071	-0.0037	0.0037	0.0013	-0.0020	0.0013
2012-05-01	-0.0080	0.0016	0.0062	0.0045	-0.0003	0.0027	0.0044
2012-05-02	0.0009	0.0028	-0.0030	0.0010	-0.0066	-0.0010	0.0003
2012-05-03	-0.0035	-0.0106	-0.0076	0.0010	-0.0013	-0.0003	-0.0039
2012-05-04	-0.0238	-0.0249	-0.0162	-0.0094	-0.0246	-0.0049	-0.0109
2012-05-07	0.0052	0.0009	0.0007	0.0067	-0.0107	0.0083	-0.0060
2012-05-08	-0.0056	-0.0037	-0.0040	0.0005	-0.0049	-0.0024	-0.0111
2012-05-09	-0.0041	-0.0031	-0.0059	-0.0074	0.0085	-0.0003	-0.0012
2012-05-10	0.0166	-0.0020	0.0021	0.0075	-0.0007	0.0027	-0.0031
2012-05-11	0.0044	-0.0002	-0.0030	0.0150	0.0137	0.0039	0.0028
2012-05-14	-0.0209	-0.0093	-0.0111	-0.0066	-0.0154	-0.0059	-0.0086
2012-05-15	0.0065	-0.0033	-0.0057	0.0039	-0.0153	0.0047	-0.0020
2012-05-16	-0.0015	-0.0068	-0.0038	-0.0041	-0.0103	-0.0027	0.0035
2012-05-17	-0.0254	-0.0211	-0.0148	0.0120	-0.0060	0.0421	-0.0092
2012-05-18	-0.0207	-0.0130	-0.0086	0.0039	-0.0151	0.0122	-0.0102
2012-05-21	0.0199	0.0280	0.0172	-0.0046	0.0164	0.0098	0.0096
2012-05-22	-0.0127	-0.0011	0.0017	0.0012	0.0003	0.0109	-0.0048
2012-05-23	0.0091	0.0019	0.0005	0.0000	-0.0218	0.0000	0.0000
2012-05-24	-0.0094	-0.0066	0.0020	0.0000	-0.0014	0.0210	-0.0037
2012-05-25	-0.0109	-0.0013	-0.0032	0.0014	-0.0003	0.0037	-0.0091
2012-05-29	0.0087	0.0127	0.0121	0.0072	0.0172	0.0057	0.0111
2012-05-30	-0.0257	-0.0084	-0.0145	-0.0079	-0.0074	-0.0037	-0.0098
2012-05-31	0.0176	-0.0043	-0.0022	0.0053	-0.0051	0.0058	-0.0084
2012-06-01	-0.0220	-0.0266	-0.0252	-0.0146	-0.0254	-0.0041	-0.0198
2012-06-04	0.0305	0.0076	-0.0005	0.0076	0.0035	0.0067	-0.0029
2012-06-05	-0.0063	0.0041	0.0076	-0.0034	-0.0014	-0.0074	0.0035
2012-06-06	0.0208	0.0229	0.0225	0.0138	0.0295	0.0066	0.0253
2012-06-07	0.0053	-0.0040	0.0006	-0.0031	-0.0041	-0.0009	0.0023
2012-06-08	-0.0015	0.0096	0.0080	0.0192	0.0144	0.0357	0.0036
2012-06-11	-0.0091	-0.0169	-0.0127	0.0028	-0.0253	-0.0101	-0.0135
2012-06-12	-0.0004	0.0121	0.0115	0.0089	0.0135	0.0028	0.0106
2012-06-13	-0.0078	-0.0069	-0.0064	0.0012	-0.0055	-0.0096	-0.0075
2012-06-14	-0.0013	0.0037	0.0106	0.0177	0.0072	0.0083	0.0104
2012-06-15	0.0182	0.0101	0.0050	-0.0046	0.0232	0.0018	0.0205
2012-06-18	0.0197	0.0094	0.0019	0.0062	-0.0060	0.0055	-0.0041
2012-06-19	0.0062	0.0104	0.0097	-0.0021	0.0288	-0.0046	0.0032
2012-06-20	-0.0045	0.0008	-0.0016	-0.0098	0.0075	0.0105	-0.0008
2012-06-21	-0.0109	-0.0249	-0.0224	0.0007	-0.0255	-0.0120	-0.0271
2012-06-22	0.0072	0.0105	0.0077	0.0143	0.0186	-0.0059	0.0016
2012-06-25	-0.0094	-0.0193	-0.0160	-0.0068	-0.0270	0.0131	-0.0043
2012-06-26	0.0252	0.0063	0.0050	0.0044	0.0050	0.0059	-0.0047
2012-06-27	0.0000	0.0061	0.0090	-0.0014	0.0050	0.0001	0.0055
2012-06-28	-0.0191	-0.0111	-0.0029	0.0043	-0.0086	-0.0042	-0.0083
2012-06-29	0.0318	0.0315	0.0249	0.0107	0.0227	0.0208	0.0218
2012-07-02	0.0042	0.0030	0.0030	0.0110	-0.0010	-0.0053	0.0013
2012-07-03	0.0009	0.0084	0.0066	0.0004	0.0065	0.0202	0.0005
2012-07-05	-0.0108	0.0006	-0.0045	-0.0013	-0.0020	0.0047	-0.0033
2012-07-06	-0.0089	-0.0125	-0.0095	-0.0105	-0.0166	0.0039	-0.0199
2012-07-09	0.0000	-0.0019	-0.0013	0.0072	-0.0063	0.0056	-0.0091
2012-07-10	-0.0247	-0.0098	-0.0087	-0.0009	-0.0087	0.0049	-0.0180
2012-07-11	-0.0051	-0.0055	0.0001	0.0045	-0.0148	0.0021	-0.0054
2012-07-12	-0.0138	-0.0094	-0.0048	-0.0051	-0.0229	0.0007	-0.0117
2012-07-13	0.0141	0.0152	0.0168	0.0121	0.0265	0.0120	0.0159
2012-07-16	-0.0109	-0.0028	-0.0024	0.0013	0.0017	-0.0027	-0.0066
2012-07-17	0.0043	0.0052	0.0069	0.0086	0.0075	0.0016	-0.0062
2012-07-18	0.0025	0.0135	0.0074	0.0050	0.0266	-0.0034	0.0250
2012-07-19	0.0400	0.0110	0.0026	-0.0294	0.0072	-0.0181	0.0377
2012-07-20	0.0094	-0.0132	-0.0091	-0.0011	-0.0179	0.0101	-0.0148
2012-07-23	-0.0100	-0.0121	-0.0101	-0.0031	-0.0279	-0.0055	-0.0084
2012-07-24	-0.0131	-0.0079	-0.0086	-0.0131	-0.0044	0.0040	-0.0026
2012-07-25	-0.0269	-0.0067	0.0002	-0.0011	-0.0110	-0.0008	0.0039
2012-07-26	0.0136	0.0133	0.0165	0.0169	0.0114	0.0221	0.0150
2012-07-27	0.0787	0.0237	0.0184	0.0099	0.0206	0.0115	0.0126
2012-07-30	-0.0052	-0.0008	0.0000	0.0011	-0.0040	0.0062	0.0015
2012-07-31	-0.0118	-0.0003	-0.0070	0.0042	-0.0057	-0.0073	-0.0036
2012-08-01	-0.0052	-0.0029	-0.0009	0.0016	-0.0020	-0.0109	-0.0041
2012-08-02	-0.0055	-0.0036	-0.0069	-0.0131	-0.0075	0.0058	-0.0037
2012-08-03	0.0180	0.0189	0.0198	-0.0036	0.0192	0.0068	0.0209
2012-08-06	-0.0042	0.0076	0.0019	0.0052	0.0067	-0.0036	0.0012
2012-08-07	0.0110	0.0083	0.0050	-0.0049	0.0104	-0.0039	0.0059
2012-08-08	-0.0092	-0.0005	0.0012	-0.0065	0.0023	0.0043	-0.0045
2012-08-09	-0.0014	0.0030	0.0009	0.0036	0.0056	-0.0062	-0.0031
2012-08-10	-0.0056	0.0006	0.0016	0.0059	-0.0026	-0.0023	0.0044
2012-08-13	-0.0013	0.0024	-0.0005	-0.0074	-0.0010	-0.0038	-0.0014
2012-08-14	0.0032	0.0004	0.0001	0.0014	-0.0086	0.0083	-0.0036
2012-08-15	0.0181	0.0025	0.0011	-0.0032	0.0023	0.0059	0.0006
2012-08-16	0.0174	0.0119	0.0074	-0.0016	0.0192	-0.0309	0.0123
2012-08-17	-0.0016	0.0044	0.0013	-0.0014	0.0039	-0.0022	0.0019
2012-08-20	-0.0034	0.0015	0.0001	-0.0082	-0.0052	0.0043	-0.0036
2012-08-21	-0.0037	-0.0039	-0.0030	-0.0185	0.0020	-0.0120	-0.0092
2012-08-22	0.0152	0.0041	0.0004	-0.0063	-0.0084	0.0048	-0.0070
2012-08-23	-0.0078	-0.0082	-0.0082	-0.0087	-0.0092	-0.0029	-0.0079
2012-08-24	0.0188	0.0062	0.0060	0.0218	0.0099	0.0077	0.0106
2012-08-27	-0.0074	0.0016	0.0002	-0.0095	0.0043	0.0054	-0.0105
2012-08-28	0.0090	0.0000	-0.0010	-0.0021	-0.0020	-0.0012	-0.0042
2012-08-29	0.0041	0.0000	0.0008	0.0098	0.0007	0.0050	0.0011
2012-08-30	-0.0036	-0.0101	-0.0072	-0.0074	-0.0108	-0.0071	-0.0088
2012-08-31	0.0083	0.0066	0.0048	0.0040	0.0165	0.0048	0.0077
2012-09-04	-0.0016	-0.0010	-0.0009	0.0177	-0.0140	0.0125	-0.0016
2012-09-05	-0.0067	-0.0010	-0.0009	0.0023	0.0000	0.0005	0.0026
2012-09-06	0.0210	0.0222	0.0203	0.0080	0.0316	0.0171	0.0208
2012-09-07	0.0309	-0.0014	0.0039	-0.0097	-0.0128	-0.0132	0.0020
2012-09-10	-0.0079	-0.0128	-0.0057	0.0078	-0.0074	-0.0042	0.0073
2012-09-11	-0.0055	-0.0016	0.0028	0.0041	0.0023	0.0075	0.0115
2012-09-12	-0.0002	0.0029	0.0033	0.0147	-0.0003	0.0001	0.0025
2012-09-13	0.0180	0.0136	0.0152	0.0154	0.0052	0.0144	0.0127
2012-09-14	0.0040	0.0089	0.0044	-0.0230	0.0087	-0.0085	0.0022
2012-09-17	-0.0125	0.0004	-0.0034	0.0011	0.0000	-0.0068	0.0016
2012-09-18	0.0029	0.0009	-0.0008	0.0074	-0.0010	-0.0005	-0.0004
2012-09-19	0.0113	0.0019	0.0005	0.0080	-0.0042	0.0057	-0.0031
2012-09-20	-0.0033	-0.0010	0.0001	0.0049	0.0129	0.0051	-0.0012
2012-09-21	-0.0128	-0.0026	-0.0057	0.0033	-0.0083	-0.0040	-0.0010
2012-09-24	-0.0104	-0.0058	-0.0015	0.0009	-0.0131	0.0039	-0.0033
2012-09-25	-0.0092	-0.0141	-0.0106	-0.0013	-0.0127	-0.0064	-0.0015
2012-09-26	-0.0111	-0.0081	-0.0056	-0.0007	-0.0072	-0.0009	-0.0048
2012-09-27	0.0277	0.0138	0.0094	0.0037	-0.0003	-0.0028	0.0094
2012-09-28	-0.0088	-0.0082	-0.0046	-0.0042	-0.0133	-0.0024	0.0075
2012-10-01	-0.0091	-0.0015	0.0026	0.0053	-0.0091	0.0034	0.0146
2012-10-02	-0.0056	0.0029	0.0010	0.0011	0.0058	-0.0041	-0.0030
2012-10-03	0.0212	0.0064	0.0041	0.0092	0.0067	0.0061	0.0032
2012-10-04	0.0178	0.0035	0.0072	0.0212	0.0057	0.0070	-0.0006
2012-10-05	-0.0075	-0.0053	0.0001	-0.0044	-0.0060	0.0055	0.0010
2012-10-08	0.0021	-0.0091	-0.0034	-0.0102	-0.0023	0.0016	-0.0037
2012-10-09	-0.0313	-0.0159	-0.0099	-0.0099	-0.0168	-0.0148	-0.0087
2012-10-10	-0.0238	-0.0051	-0.0064	-0.0072	-0.0102	0.0173	-0.0104
2012-10-11	-0.0031	-0.0031	0.0006	-0.0127	-0.0010	-0.0054	-0.0003
2012-10-12	-0.0076	-0.0004	-0.0033	-0.0128	0.0086	0.0107	0.0099
2012-10-15	0.0075	0.0073	0.0083	-0.0027	0.0106	0.0177	0.0054
2012-10-16	-0.0010	0.0141	0.0101	-0.0094	-0.0007	-0.0031	0.0099
2012-10-17	0.0146	-0.0006	0.0045	0.0145	0.0034	0.0016	-0.0491
2012-10-18	-0.0107	-0.0116	-0.0026	0.0237	-0.0030	-0.0061	-0.0283
2012-10-19	-0.0198	-0.0239	-0.0167	-0.0135	-0.0292	-0.0123	-0.0082
2012-10-22	-0.0259	0.0052	0.0001	-0.0086	-0.0223	0.0004	0.0054
2012-10-23	0.0023	-0.0095	-0.0139	-0.0156	0.0018	-0.0118	-0.0162
2012-10-24	-0.0248	-0.0035	-0.0028	0.0036	-0.0053	0.0008	-0.0028
2012-10-25	-0.0244	0.0000	0.0029	0.0005	-0.0007	0.0067	0.0046
2012-10-26	0.0687	0.0029	-0.0006	0.0108	0.0118	-0.0028	0.0087
2012-10-31	-0.0225	-0.0061	0.0000	-0.0020	0.0117	-0.0012	0.0065
2012-11-01	-0.0032	0.0142	0.0105	0.0112	0.0343	-0.0209	0.0135
2012-11-02	0.0012	-0.0106	-0.0089	-0.0137	-0.0007	-0.0093	-0.0189
2012-11-05	0.0082	0.0066	0.0020	-0.0072	0.0044	0.0051	0.0037
2012-11-06	0.0138	0.0018	0.0078	0.0023	0.0078	0.0085	0.0048
2012-11-07	-0.0232	-0.0236	-0.0227	-0.0251	-0.0261	-0.0088	-0.0200
2012-11-08	-0.0203	-0.0157	-0.0120	-0.0134	-0.0093	-0.0086	-0.0055
2012-11-09	-0.0046	0.0043	0.0009	0.0007	0.0007	-0.0023	-0.0024
2012-11-12	0.0007	-0.0002	0.0007	-0.0019	-0.0212	0.0024	-0.0021
2012-11-13	0.0006	-0.0069	-0.0034	-0.0005	-0.0400	-0.0092	-0.0049
2012-11-14	-0.0161	-0.0117	-0.0135	-0.0071	-0.0092	-0.0070	-0.0149
2012-11-15	-0.0105	-0.0034	-0.0017	-0.0128	-0.0067	-0.0363	0.0018
2012-11-16	0.0210	0.0044	0.0049	-0.0072	-0.0053	-0.0100	0.0059
2012-11-19	0.0199	0.0238	0.0202	0.0341	0.0079	0.0146	0.0182
2012-11-20	0.0177	0.0003	0.0004	0.0002	-0.0007	-0.0003	-0.0060
2012-11-21	0.0182	0.0020	0.0019	0.0079	0.0090	-0.0016	0.0058
2012-11-23	0.0078	0.0152	0.0136	0.0139	0.0278	0.0190	0.0168
2012-11-26	0.0156	0.0043	-0.0021	-0.0105	-0.0112	-0.0041	-0.0032
2012-11-27	-0.0009	-0.0034	-0.0051	-0.0074	-0.0113	-0.0059	-0.0086
2012-11-28	0.0152	0.0086	0.0081	0.0135	0.0103	0.0153	0.0039
2012-11-29	0.0168	0.0060	0.0047	0.0103	-0.0150	0.0038	-0.0023
2012-11-30	0.0031	-0.0017	0.0003	0.0025	-0.0122	0.0168	-0.0076
2012-12-03	-0.0068	-0.0020	-0.0050	-0.0005	-0.0071	-0.0094	-0.0031
2012-12-04	0.0086	-0.0006	-0.0014	-0.0098	-0.0023	0.0109	-0.0006
2012-12-05	0.0058	-0.0111	0.0018	0.0098	0.0114	-0.0065	-0.0037
2012-12-06	-0.0023	0.0065	0.0034	0.0079	0.0022	-0.0008	0.0056
2012-12-07	-0.0004	-0.0060	0.0030	-0.0009	-0.0101	0.0098	0.0119
2012-12-10	-0.0217	0.0029	0.0004	-0.0086	0.0181	-0.0019	0.0035
2012-12-11	0.0118	0.0131	0.0068	0.0093	0.0141	-0.0175	0.0082
2012-12-12	0.0043	-0.0021	0.0005	0.0079	-0.0029	-0.0275	-0.0064
2012-12-13	-0.0020	-0.0079	-0.0061	-0.0060	-0.0048	0.0015	-0.0050
2012-12-14	-0.0082	-0.0095	-0.0036	-0.0070	-0.0111	-0.0042	-0.0012
2012-12-17	0.0187	0.0133	0.0117	-0.0020	0.0108	0.0065	0.0097
2012-12-18	0.0258	0.0153	0.0111	-0.0057	0.0170	0.0043	0.0107
2012-12-19	-0.0093	-0.0044	-0.0074	-0.0112	-0.0091	-0.0141	-0.0031
2012-12-20	0.0136	0.0000	0.0058	0.0099	0.0135	0.0070	-0.0016
2012-12-21	-0.0175	-0.0160	-0.0161	-0.0055	-0.0083	-0.0051	-0.0069
2012-12-24	0.0066	-0.0020	-0.0031	-0.0007	-0.0142	-0.0012	-0.0053
2012-12-26	-0.0386	-0.0088	-0.0042	-0.0021	-0.0074	-0.0085	-0.0023
2012-12-27	-0.0013	-0.0016	-0.0013	0.0007	0.0037	0.0029	0.0040
2012-12-28	-0.0126	-0.0096	-0.0108	-0.0133	-0.0152	-0.0085	-0.0149
2012-12-31	0.0232	0.0212	0.0170	0.0086	0.0060	0.0092	0.0091