Spreadsheet: 218984d1362630682-ifthen-formula-with-4-logical-tests-unable-to-compute-qqqvxx
Sheet: Sheet1

Date | QQQ | VXX | Short QQQ, Long VXX | Total | Short QQQ, Long VXX - |  | Long QQQ, Short VXX | Total
2013-03-06 00:00:00 | 68.51 | 22.39 |  |  | True
2013-03-05 00:00:00 | 68.68 | 22.28
2013-03-04 00:00:00 | 67.68 | 23.06
2013-03-01 00:00:00 | 67.38 | 24.33
2013-02-28 00:00:00 | 67.1 | 23.97
2013-02-27 00:00:00 | 67.24 | 23.27
2013-02-26 00:00:00 | 66.56 | 24.93
2013-02-25 00:00:00 | 66.31 | 25.56
2013-02-22 00:00:00 | 67.14 | 22.48
2013-02-21 00:00:00 | 66.47 | 23.27
2013-02-20 00:00:00 | 67.19 | 22.83
2013-02-19 00:00:00 | 68.24 | 21.02
2013-02-15 00:00:00 | 67.75 | 21.96
2013-02-14 00:00:00 | 67.95 | 22.16
2013-02-13 00:00:00 | 67.97 | 22.49
2013-02-12 00:00:00 | 67.73 | 22.37
2013-02-11 00:00:00 | 68.01 | 22.6
2013-02-08 00:00:00 | 67.99 | 22.99
2013-02-07 00:00:00 | 67.3 | 23.46
2013-02-06 00:00:00 | 67.24 | 23.55
2013-02-05 00:00:00 | 67.46 | 23.67
2013-02-04 00:00:00 | 66.48 | 24.68
2013-02-01 00:00:00 | 67.66 | 23.09
2013-01-31 00:00:00 | 66.87 | 24.34
2013-01-30 00:00:00 | 67.02 | 24.27
2013-01-29 00:00:00 | 67.16 | 22.86
2013-01-28 00:00:00 | 67.15 | 23.57
2013-01-25 00:00:00 | 67 | 22.95
2013-01-24 00:00:00 | 66.66 | 22.8
2013-01-23 00:00:00 | 67.59 | 22.67
2013-01-22 00:00:00 | 67.18 | 23.3
2013-01-18 00:00:00 | 67.07 | 23.98
2013-01-17 00:00:00 | 67.22 | 25.63
2013-01-16 00:00:00 | 66.9 | 25.49
2013-01-15 00:00:00 | 66.63 | 26.04
2013-01-14 00:00:00 | 66.96 | 26.03
2013-01-11 00:00:00 | 67.26 | 26.46
2013-01-10 00:00:00 | 67.17 | 26.57
2013-01-09 00:00:00 | 66.77 | 27.24
2013-01-08 00:00:00 | 66.52 | 27.18
2013-01-07 00:00:00 | 66.65 | 27.52
2013-01-04 00:00:00 | 66.63 | 27.55
2013-01-03 00:00:00 | 66.85 | 28.13
2013-01-02 00:00:00 | 67.2 | 28.05
2012-12-31 00:00:00 | 65.13 | 31.81
2012-12-28 00:00:00 | 63.78 | 35.43
2012-12-27 00:00:00 | 64.4 | 33.71
2012-12-26 00:00:00 | 64.5 | 33.74
2012-12-24 00:00:00 | 65.07 | 31.96
2012-12-21 00:00:00 | 65.2 | 32.54
2012-12-20 00:00:00 | 66.26 | 30.46
2012-12-19 00:00:00 | 66.26 | 29.79
2012-12-18 00:00:00 | 66.55 | 28.15
2012-12-17 00:00:00 | 65.55 | 29.29
2012-12-14 00:00:00 | 64.69 | 30.33
2012-12-13 00:00:00 | 65.31 | 30.13
2012-12-12 00:00:00 | 65.83 | 29.57
2012-12-11 00:00:00 | 65.97 | 28.86
2012-12-10 00:00:00 | 65.12 | 29.88
2012-12-07 00:00:00 | 64.93 | 29.44
2012-12-06 00:00:00 | 65.32 | 30.54
2012-12-05 00:00:00 | 64.9 | 30.16
2012-12-04 00:00:00 | 65.63 | 30.67
2012-12-03 00:00:00 | 65.67 | 30.24
2012-11-30 00:00:00 | 65.8 | 29.62
2012-11-29 00:00:00 | 65.91 | 29.1
2012-11-28 00:00:00 | 65.52 | 29.44
2012-11-27 00:00:00 | 64.96 | 30.36
2012-11-26 00:00:00 | 65.18 | 29.74
2012-11-23 00:00:00 | 64.9 | 30
2012-11-21 00:00:00 | 63.93 | 31.34
2012-11-20 00:00:00 | 63.8 | 31.15
2012-11-19 00:00:00 | 63.78 | 31.7
2012-11-16 00:00:00 | 62.3 | 34.74
2012-11-15 00:00:00 | 62.03 | 36.32
2012-11-14 00:00:00 | 62.24 | 36.01
2012-11-13 00:00:00 | 62.98 | 34.88
2012-11-12 00:00:00 | 63.42 | 34.79
2012-11-09 00:00:00 | 63.43 | 37.18
2012-11-08 00:00:00 | 63.16 | 37.2
2012-11-07 00:00:00 | 64.17 | 36.96
2012-11-06 00:00:00 | 65.72 | 34.31
2012-11-05 00:00:00 | 65.6 | 35.59
2012-11-02 00:00:00 | 65.17 | 34.95
2012-11-01 00:00:00 | 65.87 | 33.99
2012-10-31 00:00:00 | 64.95 | 37
2012-10-26 00:00:00 | 65.35 | 36.3
2012-10-25 00:00:00 | 65.16 | 36.43
2012-10-24 00:00:00 | 65.16 | 37.5
2012-10-23 00:00:00 | 65.39 | 37.26
2012-10-22 00:00:00 | 66.02 | 34.55
2012-10-19 00:00:00 | 65.68 | 34.97
2012-10-18 00:00:00 | 67.29 | 32.88
2012-10-17 00:00:00 | 68.08 | 33
2012-10-16 00:00:00 | 68.12 | 33.38
2012-10-15 00:00:00 | 67.17 | 34.22
2012-10-12 00:00:00 | 66.68 | 35.41
2012-10-11 00:00:00 | 66.71 | 35.01
2012-10-10 00:00:00 | 66.92 | 35.55
2012-10-09 00:00:00 | 67.26 | 35.95
2012-10-08 00:00:00 | 68.35 | 34.52
2012-10-05 00:00:00 | 68.98 | 34.12
2012-10-04 00:00:00 | 69.35 | 34.6
2012-10-03 00:00:00 | 69.11 | 35.52
2012-10-02 00:00:00 | 68.67 | 35.52
2012-10-01 00:00:00 | 68.47 | 36.32
2012-09-28 00:00:00 | 68.57 | 36.04
2012-09-27 00:00:00 | 69.14 | 34.84
2012-09-26 00:00:00 | 68.2 | 38.28
2012-09-25 00:00:00 | 68.76 | 37
2012-09-24 00:00:00 | 69.74 | 34.28
2012-09-21 00:00:00 | 70.15 | 34.68
2012-09-20 00:00:00 | 70.33 | 35.08
2012-09-19 00:00:00 | 70.4 | 35.4
2012-09-18 00:00:00 | 70.27 | 35.32
2012-09-17 00:00:00 | 70.21 | 36.28
2012-09-14 00:00:00 | 70.18 | 36.72
2012-09-13 00:00:00 | 69.56 | 35.4
2012-09-12 00:00:00 | 68.63 | 38.24
2012-09-11 00:00:00 | 68.43 | 39.44
2012-09-10 00:00:00 | 68.54 | 39.72
2012-09-07 00:00:00 | 69.43 | 37.64
2012-09-06 00:00:00 | 69.53 | 39.8
2012-09-05 00:00:00 | 68.02 | 44.48
2012-09-04 00:00:00 | 68.09 | 45.68
2012-08-31 00:00:00 | 68.16 | 46.04
2012-08-30 00:00:00 | 67.71 | 47.68
2012-08-29 00:00:00 | 68.4 | 46.64
2012-08-28 00:00:00 | 68.4 | 46.56
2012-08-27 00:00:00 | 68.4 | 45.76
2012-08-24 00:00:00 | 68.29 | 45.28
2012-08-23 00:00:00 | 67.87 | 47.24
2012-08-22 00:00:00 | 68.43 | 46.4
2012-08-21 00:00:00 | 68.15 | 46
2012-08-20 00:00:00 | 68.42 | 44.8
2012-08-17 00:00:00 | 68.32 | 44.8
2012-08-16 00:00:00 | 68.02 | 46.04
2012-08-15 00:00:00 | 67.22 | 47
2012-08-14 00:00:00 | 67.05 | 46.96
2012-08-13 00:00:00 | 67.02 | 44.52
2012-08-10 00:00:00 | 66.86 | 45.68
2012-08-09 00:00:00 | 66.82 | 46.52
2012-08-08 00:00:00 | 66.62 | 46.84
2012-08-07 00:00:00 | 66.65 | 48.88
2012-08-06 00:00:00 | 66.1 | 47.44
2012-08-03 00:00:00 | 65.6 | 48.56
2012-08-02 00:00:00 | 64.38 | 52.12
2012-08-01 00:00:00 | 64.61 | 53.36
2012-07-31 00:00:00 | 64.8 | 54.48
2012-07-30 00:00:00 | 64.82 | 53.04
2012-07-27 00:00:00 | 64.87 | 51.92
2012-07-26 00:00:00 | 63.37 | 53.4
2012-07-25 00:00:00 | 62.54 | 57.8
2012-07-24 00:00:00 | 62.96 | 58.64
2012-07-23 00:00:00 | 63.46 | 56.24
2012-07-20 00:00:00 | 64.24 | 52.8
2012-07-19 00:00:00 | 65.1 | 50.28
2012-07-18 00:00:00 | 64.39 | 51.4
2012-07-17 00:00:00 | 63.53 | 50.8
2012-07-16 00:00:00 | 63.2 | 52.68
2012-07-13 00:00:00 | 63.38 | 53.4
2012-07-12 00:00:00 | 62.43 | 56.64
2012-07-11 00:00:00 | 63.02 | 56.24
2012-07-10 00:00:00 | 63.37 | 58.12
2012-07-09 00:00:00 | 64 | 56.56
2012-07-06 00:00:00 | 64.12 | 57
2012-07-05 00:00:00 | 64.93 | 57.6
2012-07-03 00:00:00 | 64.89 | 55.6
2012-07-02 00:00:00 | 64.35 | 56.88
2012-06-29 00:00:00 | 64.16 | 60.84
2012-06-28 00:00:00 | 62.2 | 65.04
2012-06-27 00:00:00 | 62.9 | 67.24
2012-06-26 00:00:00 | 62.52 | 66.72
2012-06-25 00:00:00 | 62.13 | 68.72
2012-06-22 00:00:00 | 63.35 | 63.56
2012-06-21 00:00:00 | 62.69 | 70.8
2012-06-20 00:00:00 | 64.29 | 63.72
2012-06-19 00:00:00 | 64.24 | 66.52
2012-06-18 00:00:00 | 63.58 | 67.88
2012-06-15 00:00:00 | 62.99 | 73.96
2012-06-14 00:00:00 | 62.36 | 77.2
2012-06-13 00:00:00 | 62.13 | 82.48
2012-06-12 00:00:00 | 62.56 | 78.44
2012-06-11 00:00:00 | 61.8 | 79.8
2012-06-08 00:00:00 | 62.87 | 73.6
2012-06-07 00:00:00 | 62.27 | 77.84
2012-06-06 00:00:00 | 62.52 | 78.6
2012-06-05 00:00:00 | 61.12 | 84.76
2012-06-04 00:00:00 | 60.87 | 86.68
2012-06-01 00:00:00 | 60.41 | 90.36
2012-05-31 00:00:00 | 62.06 | 83.28
2012-05-30 00:00:00 | 62.33 | 82.2
2012-05-29 00:00:00 | 62.86 | 76.88
2012-05-25 00:00:00 | 62.07 | 80.88
2012-05-24 00:00:00 | 62.15 | 81.68
2012-05-23 00:00:00 | 62.56 | 81.04
2012-05-22 00:00:00 | 62.44 | 82.44
2012-05-21 00:00:00 | 62.51 | 79.6
2012-05-18 00:00:00 | 60.81 | 89.6
2012-05-17 00:00:00 | 61.61 | 84
2012-05-16 00:00:00 | 62.94 | 80.28
2012-05-15 00:00:00 | 63.37 | 77.4
2012-05-14 00:00:00 | 63.58 | 73.76
2012-05-11 00:00:00 | 64.18 | 69.92
2012-05-10 00:00:00 | 64.19 | 68.8
2012-05-09 00:00:00 | 64.32 | 71
2012-05-08 00:00:00 | 64.52 | 68.56
2012-05-07 00:00:00 | 64.76 | 67.72
2012-05-04 00:00:00 | 64.7 | 68.92
2012-05-03 00:00:00 | 66.35 | 66.16
2012-05-02 00:00:00 | 67.06 | 64.76
2012-05-01 00:00:00 | 66.87 | 64.04
2012-04-30 00:00:00 | 66.76 | 66.2
2012-04-27 00:00:00 | 67.24 | 64.76
2012-04-26 00:00:00 | 66.84 | 64.88
2012-04-25 00:00:00 | 66.45 | 67.28
2012-04-24 00:00:00 | 64.73 | 71.64
2012-04-23 00:00:00 | 65.08 | 73.44
2012-04-20 00:00:00 | 65.68 | 71.08
2012-04-19 00:00:00 | 65.86 | 73.44
2012-04-18 00:00:00 | 66.61 | 73
2012-04-17 00:00:00 | 66.78 | 71.96
2012-04-16 00:00:00 | 65.45 | 76.04
2012-04-13 00:00:00 | 66.19 | 77.12
2012-04-12 00:00:00 | 67.2 | 73.32
2012-04-11 00:00:00 | 66.45 | 80.04
2012-04-10 00:00:00 | 66.13 | 81.96
2012-04-09 00:00:00 | 67.21 | 76
2012-04-05 00:00:00 | 67.72 | 71.48
2012-04-04 00:00:00 | 67.3 | 69.84
2012-04-03 00:00:00 | 68.23 | 68.4
2012-04-02 00:00:00 | 68.25 | 67.24
2012-03-30 00:00:00 | 67.55 | 67.28
2012-03-29 00:00:00 | 67.68 | 69.12
2012-03-28 00:00:00 | 67.94 | 69.32
2012-03-27 00:00:00 | 68.21 | 68.84
2012-03-26 00:00:00 | 68.11 | 62.68
2012-03-23 00:00:00 | 66.94 | 69.16
2012-03-22 00:00:00 | 66.98 | 74.32
2012-03-21 00:00:00 | 67.12 | 73.48
2012-03-20 00:00:00 | 67.11 | 77.32
2012-03-19 00:00:00 | 66.99 | 80.92
2012-03-16 00:00:00 | 66.52 | 86.28
2012-03-15 00:00:00 | 66.68 | 86.36
2012-03-14 00:00:00 | 66.49 | 87.84
2012-03-13 00:00:00 | 66.26 | 84.92
2012-03-12 00:00:00 | 65.05 | 89.12
2012-03-09 00:00:00 | 65.02 | 93.36
2012-03-08 00:00:00 | 64.75 | 95.24
2012-03-07 00:00:00 | 64.06 | 99.04
 |  | True
 |  | False
 |  |  | Total