Spreadsheet: 214721d1361087084-lookup-values-in-multiple-columns-based-on-a-date-range-return-single-value-per-criteria-excel-forum-lookup-help-1-
Sheet: Calculations & Data

 |  |  | Current Logic |  |  | Desired Result
Action | Start Date | End Date | Basic Trade Price | % Gain/Loss |  | Basic Trade Price | Stop Loss Triggered | % Gain/Loss |  | Stop | Table Name |  | Date | Open | High | Low | Close | Volume | Adj Close | Split Denominator | MyAdjOpen
Uptrend | 2011-08-23 00:00:00 |  |  |  |  |  |  |  |  | 0.1 | Table1 |  | 2012-12-31 00:00:00 | 63.71 | 65.25 | 63.58 | 65.13 | 57544000 | 65.13
Downtrend | 2011-09-22 00:00:00 |  |  |  |  |  |  |  |  |  |  |  | 2012-12-28 00:00:00 | 63.91 | 64.43 | 63.75 | 63.78 | 33082100 | 63.78
Uptrend | 2011-10-13 00:00:00 |  |  |  |  |  |  |  |  |  |  |  | 2012-12-27 00:00:00 | 64.56 | 64.64 | 63.6 | 64.4 | 52933200 | 64.4
Downtrend | 2011-11-17 00:00:00 |  |  |  |  |  |  |  |  |  |  |  | 2012-12-26 00:00:00 | 65.12 | 65.18 | 64.29 | 64.5 | 21751300 | 64.5
Uptrend | 2011-12-20 00:00:00 |  |  |  |  |  |  |  |  |  |  |  | 2012-12-24 00:00:00 | 65.06 | 65.14 | 64.92 | 65.07 | 11418300 | 65.07
Downtrend | 2012-04-04 00:00:00 |  |  |  |  |  |  |  |  |  |  |  | 2012-12-21 00:00:00 | 64.88 | 65.28 | 64.6 | 65.2 | 51152900 | 65.2
Uptrend | 2012-04-25 00:00:00 |  |  |  |  |  |  |  |  |  |  |  | 2012-12-20 00:00:00 | 66.38 | 66.41 | 65.93 | 66.26 | 40754300 | 65.89
Downtrend | 2012-05-04 00:00:00 |  |  |  |  |  |  |  |  |  |  |  | 2012-12-19 00:00:00 | 66.74 | 66.76 | 66.22 | 66.26 | 34832500 | 65.89
Uptrend | 2012-06-15 00:00:00 |  |  |  |  |  |  |  |  |  |  |  | 2012-12-18 00:00:00 | 65.88 | 66.65 | 65.7 | 66.55 | 55596000 | 66.18
Downtrend | 2012-06-25 00:00:00 |  |  |  |  |  |  |  |  |  |  |  | 2012-12-17 00:00:00 | 64.75 | 65.57 | 64.66 | 65.55 | 42302900 | 65.19
Uptrend | 2012-06-29 00:00:00 |  |  |  |  |  |  |  |  |  |  |  | 2012-12-14 00:00:00 | 64.87 | 65.08 | 64.47 | 64.69 | 39630300 | 64.33
Downtrend | 2012-07-24 00:00:00 |  |  |  |  |  |  |  |  |  |  |  | 2012-12-13 00:00:00 | 65.7 | 66.16 | 65.03 | 65.31 | 45467700 | 64.95
Uptrend | 2012-07-26 00:00:00 |  |  |  |  |  |  |  |  |  |  |  | 2012-12-12 00:00:00 | 66.32 | 66.32 | 65.65 | 65.83 | 45917700 | 65.47
Downtrend | 2012-10-10 00:00:00 |  |  |  |  |  |  |  |  |  |  |  | 2012-12-11 00:00:00 | 65.57 | 66.34 | 65.52 | 65.97 | 40750800 | 65.6
 | 2012-11-26 00:00:00 |  |  |  |  |  |  |  |  |  |  |  | 2012-12-10 00:00:00 | 64.75 | 65.46 | 64.75 | 65.12 | 33219600 | 64.76
 |  |  |  |  |  |  |  |  |  |  |  |  | 2012-12-07 00:00:00 | 65.64 | 65.71 | 64.71 | 64.93 | 30089400 | 64.57
 |  |  |  |  |  |  |  |  |  |  |  |  | 2012-12-06 00:00:00 | 64.7 | 65.48 | 64.53 | 65.32 | 47512300 | 64.96
 |  |  |  |  |  |  |  |  |  |  |  |  | 2012-12-05 00:00:00 | 65.53 | 65.54 | 64.55 | 64.9 | 54076200 | 64.54
 |  |  |  |  |  |  |  |  |  |  |  |  | 2012-12-04 00:00:00 | 65.7 | 65.77 | 65.2 | 65.63 | 49584500 | 65.27
 |  |  |  |  |  |  |  |  |  |  |  |  | 2012-12-03 00:00:00 | 66.31 | 66.37 | 65.64 | 65.67 | 28240000 | 65.31
 |  |  |  |  |  |  |  |  |  |  |  |  | 2012-11-30 00:00:00 | 65.92 | 65.97 | 65.61 | 65.8 | 33497400 | 65.44
 |  |  |  |  |  |  |  |  |  |  |  |  | 2012-11-29 00:00:00 | 65.87 | 66.14 | 65.58 | 65.91 | 41136100 | 65.54
 |  |  |  |  |  |  |  |  |  |  |  |  | 2012-11-28 00:00:00 | 64.65 | 65.57 | 64.25 | 65.52 | 37295800 | 65.16
 |  |  |  |  |  |  |  |  |  |  |  |  | 2012-11-27 00:00:00 | 65.17 | 65.4 | 64.85 | 64.96 | 25828600 | 64.6
 |  |  |  |  |  |  |  |  |  |  |  |  | 2012-11-26 00:00:00 | 64.74 | 65.22 | 64.54 | 65.18 | 26430900 | 64.82
 |  |  |  |  |  |  |  |  |  |  |  |  | 2012-11-23 00:00:00 | 64.29 | 64.92 | 64.25 | 64.9 | 16462900 | 64.54
 |  |  |  |  |  |  |  |  |  |  |  |  | 2012-11-21 00:00:00 | 63.87 | 64.02 | 63.6 | 63.93 | 19611700 | 63.58
 |  |  |  |  |  |  |  |  |  |  |  |  | 2012-11-20 00:00:00 | 63.76 | 63.89 | 63.19 | 63.8 | 52012700 | 63.45
 |  |  |  |  |  |  |  |  |  |  |  |  | 2012-11-19 00:00:00 | 62.98 | 63.83 | 62.96 | 63.78 | 55306400 | 63.43
 |  |  |  |  |  |  |  |  |  |  |  |  | 2012-11-16 00:00:00 | 62.08 | 62.48 | 61.31 | 62.3 | 70873100 | 61.95
 |  |  |  |  |  |  |  |  |  |  |  |  | 2012-11-15 00:00:00 | 62.28 | 62.49 | 61.8 | 62.03 | 55124200 | 61.69
 |  |  |  |  |  |  |  |  |  |  |  |  | 2012-11-14 00:00:00 | 63.29 | 63.36 | 62.14 | 62.24 | 82655300 | 61.9
 |  |  |  |  |  |  |  |  |  |  |  |  | 2012-11-13 00:00:00 | 62.93 | 63.58 | 62.78 | 62.98 | 43245500 | 62.98
 |  |  |  |  |  |  |  |  |  |  |  |  | 2012-11-12 00:00:00 | 63.79 | 63.87 | 63.25 | 63.42 | 32620600 | 63.42
 |  |  |  |  |  |  |  |  |  |  |  |  | 2012-11-09 00:00:00 | 63.19 | 64.11 | 63.16 | 63.43 | 51542100 | 63.43
 |  |  |  |  |  |  |  |  |  |  |  |  | 2012-11-08 00:00:00 | 64.35 | 64.5 | 63.16 | 63.16 | 58585800 | 63.16
 |  |  |  |  |  |  |  |  |  |  |  |  | 2012-11-07 00:00:00 | 65.02 | 65.1 | 63.9 | 64.17 | 70737800 | 64.17
 |  |  |  |  |  |  |  |  |  |  |  |  | 2012-11-06 00:00:00 | 65.71 | 66.17 | 65.46 | 65.72 | 29608400 | 65.72
 |  |  |  |  |  |  |  |  |  |  |  |  | 2012-11-05 00:00:00 | 65.18 | 65.73 | 65.04 | 65.6 | 28094700 | 65.6
 |  |  |  |  |  |  |  |  |  |  |  |  | 2012-11-02 00:00:00 | 66.17 | 66.21 | 65.11 | 65.17 | 44069400 | 65.17
 |  |  |  |  |  |  |  |  |  |  |  |  | 2012-11-01 00:00:00 | 65.36 | 66 | 65.17 | 65.87 | 26945000 | 65.87
 |  |  |  |  |  |  |  |  |  |  |  |  | 2012-10-31 00:00:00 | 65.27 | 65.39 | 64.73 | 64.95 | 38524500 | 64.95
 |  |  |  |  |  |  |  |  |  |  |  |  | 2012-10-26 00:00:00 | 65.16 | 65.62 | 64.65 | 65.35 | 54213100 | 65.35
 |  |  |  |  |  |  |  |  |  |  |  |  | 2012-10-25 00:00:00 | 65.61 | 65.72 | 64.97 | 65.16 | 52688700 | 65.16
 |  |  |  |  |  |  |  |  |  |  |  |  | 2012-10-24 00:00:00 | 65.76 | 65.87 | 65.06 | 65.16 | 39872400 | 65.16
 |  |  |  |  |  |  |  |  |  |  |  |  | 2012-10-23 00:00:00 | 65.48 | 65.95 | 65.19 | 65.39 | 52591200 | 65.39
 |  |  |  |  |  |  |  |  |  |  |  |  | 2012-10-22 00:00:00 | 65.65 | 66.19 | 65.5 | 66.02 | 38621500 | 66.02
 |  |  |  |  |  |  |  |  |  |  |  |  | 2012-10-19 00:00:00 | 67.21 | 67.27 | 65.6 | 65.68 | 75362600 | 65.68
 |  |  |  |  |  |  |  |  |  |  |  |  | 2012-10-18 00:00:00 | 67.86 | 68.08 | 67.04 | 67.29 | 61707600 | 67.29
 |  |  |  |  |  |  |  |  |  |  |  |  | 2012-10-17 00:00:00 | 67.77 | 68.3 | 67.68 | 68.08 | 33439400 | 68.08
 |  |  |  |  |  |  |  |  |  |  |  |  | 2012-10-16 00:00:00 | 67.27 | 68.2 | 67.25 | 68.12 | 33960600 | 68.12
 |  |  |  |  |  |  |  |  |  |  |  |  | 2012-10-15 00:00:00 | 66.93 | 67.26 | 66.53 | 67.17 | 22220100 | 67.17
 |  |  |  |  |  |  |  |  |  |  |  |  | 2012-10-12 00:00:00 | 66.7 | 67.06 | 66.55 | 66.68 | 24891200 | 66.68
 |  |  |  |  |  |  |  |  |  |  |  |  | 2012-10-11 00:00:00 | 67.42 | 67.47 | 66.67 | 66.71 | 30469400 | 66.71
 |  |  |  |  |  |  |  |  |  |  |  |  | 2012-10-10 00:00:00 | 67.24 | 67.43 | 66.8 | 66.92 | 45134300 | 66.92
 |  |  |  |  |  |  |  |  |  |  |  |  | 2012-10-09 00:00:00 | 68.17 | 68.34 | 67.1 | 67.26 | 67974000 | 67.26
 |  |  |  |  |  |  |  |  |  |  |  |  | 2012-10-08 00:00:00 | 68.58 | 68.72 | 68.19 | 68.35 | 30911500 | 68.35
 |  |  |  |  |  |  |  |  |  |  |  |  | 2012-10-05 00:00:00 | 69.7 | 69.8 | 68.8 | 68.98 | 25207900 | 68.98
 |  |  |  |  |  |  |  |  |  |  |  |  | 2012-10-04 00:00:00 | 69.22 | 69.54 | 69 | 69.35 | 26128600 | 69.35
 |  |  |  |  |  |  |  |  |  |  |  |  | 2012-10-03 00:00:00 | 68.86 | 69.24 | 68.59 | 69.11 | 38236000 | 69.11
 |  |  |  |  |  |  |  |  |  |  |  |  | 2012-10-02 00:00:00 | 68.77 | 68.98 | 68.13 | 68.67 | 33254300 | 68.67
 |  |  |  |  |  |  |  |  |  |  |  |  | 2012-10-01 00:00:00 | 68.9 | 69.33 | 68.25 | 68.47 | 37715300 | 68.47
 |  |  |  |  |  |  |  |  |  |  |  |  | 2012-09-28 00:00:00 | 68.91 | 69.12 | 68.51 | 68.57 | 30112600 | 68.57
 |  |  |  |  |  |  |  |  |  |  |  |  | 2012-09-27 00:00:00 | 68.37 | 69.3 | 68.25 | 69.14 | 25339500 | 69.14
 |  |  |  |  |  |  |  |  |  |  |  |  | 2012-09-26 00:00:00 | 68.67 | 68.71 | 67.85 | 68.2 | 32770400 | 68.2
 |  |  |  |  |  |  |  |  |  |  |  |  | 2012-09-25 00:00:00 | 69.92 | 70.08 | 68.73 | 68.76 | 41299600 | 68.76
 |  |  |  |  |  |  |  |  |  |  |  |  | 2012-09-24 00:00:00 | 69.57 | 69.86 | 69.42 | 69.74 | 32341600 | 69.74
 |  |  |  |  |  |  |  |  |  |  |  |  | 2012-09-21 00:00:00 | 70.48 | 70.54 | 70.08 | 70.15 | 23678500 | 70.15
 |  |  |  |  |  |  |  |  |  |  |  |  | 2012-09-20 00:00:00 | 70.06 | 70.4 | 69.87 | 70.33 | 42520200 | 70.13
 |  |  |  |  |  |  |  |  |  |  |  |  | 2012-09-19 00:00:00 | 70.26 | 70.58 | 70.06 | 70.4 | 36484600 | 70.2
 |  |  |  |  |  |  |  |  |  |  |  |  | 2012-09-18 00:00:00 | 70.03 | 70.3 | 70.02 | 70.27 | 27169800 | 70.07
 |  |  |  |  |  |  |  |  |  |  |  |  | 2012-09-17 00:00:00 | 70.22 | 70.24 | 69.96 | 70.21 | 31798400 | 70.01
 |  |  |  |  |  |  |  |  |  |  |  |  | 2012-09-14 00:00:00 | 69.81 | 70.43 | 69.79 | 70.18 | 38880300 | 69.98
 |  |  |  |  |  |  |  |  |  |  |  |  | 2012-09-13 00:00:00 | 68.69 | 69.86 | 68.62 | 69.56 | 45417800 | 69.36
 |  |  |  |  |  |  |  |  |  |  |  |  | 2012-09-12 00:00:00 | 68.68 | 68.81 | 68.21 | 68.63 | 42203400 | 68.43
 |  |  |  |  |  |  |  |  |  |  |  |  | 2012-09-11 00:00:00 | 68.55 | 68.82 | 68.32 | 68.43 | 29810100 | 68.24
 |  |  |  |  |  |  |  |  |  |  |  |  | 2012-09-10 00:00:00 | 69.25 | 69.4 | 68.49 | 68.54 | 25490000 | 68.35
 |  |  |  |  |  |  |  |  |  |  |  |  | 2012-09-07 00:00:00 | 69.37 | 69.55 | 69.23 | 69.43 | 32958600 | 69.23
 |  |  |  |  |  |  |  |  |  |  |  |  | 2012-09-06 00:00:00 | 68.44 | 69.55 | 68.42 | 69.53 | 43100000 | 69.33
 |  |  |  |  |  |  |  |  |  |  |  |  | 2012-09-05 00:00:00 | 68.06 | 68.35 | 67.84 | 68.02 | 26129300 | 67.83
 |  |  |  |  |  |  |  |  |  |  |  |  | 2012-09-04 00:00:00 | 68.03 | 68.35 | 67.42 | 68.09 | 32017200 | 67.9
 |  |  |  |  |  |  |  |  |  |  |  |  | 2012-08-31 00:00:00 | 68.2 | 68.45 | 67.47 | 68.16 | 42128000 | 67.97
 |  |  |  |  |  |  |  |  |  |  |  |  | 2012-08-30 00:00:00 | 68.1 | 68.13 | 67.6 | 67.71 | 24425400 | 67.52
 |  |  |  |  |  |  |  |  |  |  |  |  | 2012-08-29 00:00:00 | 68.4 | 68.57 | 68.11 | 68.4 | 26672400 | 68.21
 |  |  |  |  |  |  |  |  |  |  |  |  | 2012-08-28 00:00:00 | 68.34 | 68.59 | 68.11 | 68.4 | 27337900 | 68.21
 |  |  |  |  |  |  |  |  |  |  |  |  | 2012-08-27 00:00:00 | 68.58 | 68.67 | 68.25 | 68.4 | 20671400 | 68.21
 |  |  |  |  |  |  |  |  |  |  |  |  | 2012-08-24 00:00:00 | 67.71 | 68.45 | 67.6 | 68.29 | 38384800 | 68.1
 |  |  |  |  |  |  |  |  |  |  |  |  | 2012-08-23 00:00:00 | 68.12 | 68.34 | 67.69 | 67.87 | 28800400 | 67.68
 |  |  |  |  |  |  |  |  |  |  |  |  | 2012-08-22 00:00:00 | 68 | 68.56 | 67.81 | 68.43 | 44555700 | 68.24
 |  |  |  |  |  |  |  |  |  |  |  |  | 2012-08-21 00:00:00 | 68.6 | 68.88 | 67.88 | 68.15 | 41391000 | 67.96
 |  |  |  |  |  |  |  |  |  |  |  |  | 2012-08-20 00:00:00 | 68.27 | 68.43 | 68 | 68.42 | 26924000 | 68.23
 |  |  |  |  |  |  |  |  |  |  |  |  | 2012-08-17 00:00:00 | 68.17 | 68.33 | 68.01 | 68.32 | 22584800 | 68.13
 |  |  |  |  |  |  |  |  |  |  |  |  | 2012-08-16 00:00:00 | 67.47 | 68.17 | 67.39 | 68.02 | 35699900 | 67.83
 |  |  |  |  |  |  |  |  |  |  |  |  | 2012-08-15 00:00:00 | 67 | 67.32 | 66.99 | 67.22 | 29100400 | 67.03
 |  |  |  |  |  |  |  |  |  |  |  |  | 2012-08-14 00:00:00 | 67.27 | 67.41 | 66.86 | 67.05 | 24218700 | 66.86
 |  |  |  |  |  |  |  |  |  |  |  |  | 2012-08-13 00:00:00 | 66.84 | 67.03 | 66.5 | 67.02 | 19890300 | 66.83
 |  |  |  |  |  |  |  |  |  |  |  |  | 2012-08-10 00:00:00 | 66.58 | 66.88 | 66.41 | 66.86 | 20312000 | 66.67
 |  |  |  |  |  |  |  |  |  |  |  |  | 2012-08-09 00:00:00 | 66.61 | 66.91 | 66.49 | 66.82 | 20726200 | 66.63
 |  |  |  |  |  |  |  |  |  |  |  |  | 2012-08-08 00:00:00 | 66.48 | 66.76 | 66.37 | 66.62 | 20723500 | 66.43
 |  |  |  |  |  |  |  |  |  |  |  |  | 2012-08-07 00:00:00 | 66.38 | 66.92 | 66.28 | 66.65 | 28223300 | 66.46
 |  |  |  |  |  |  |  |  |  |  |  |  | 2012-08-06 00:00:00 | 65.94 | 66.39 | 65.8 | 66.1 | 23523600 | 65.91
 |  |  |  |  |  |  |  |  |  |  |  |  | 2012-08-03 00:00:00 | 65.42 | 65.88 | 65.19 | 65.6 | 42117400 | 65.41
 |  |  |  |  |  |  |  |  |  |  |  |  | 2012-08-02 00:00:00 | 64.12 | 65.02 | 63.91 | 64.38 | 40534900 | 64.2
 |  |  |  |  |  |  |  |  |  |  |  |  | 2012-08-01 00:00:00 | 65.26 | 65.28 | 64.35 | 64.61 | 30920200 | 64.43
 |  |  |  |  |  |  |  |  |  |  |  |  | 2012-07-31 00:00:00 | 64.92 | 65.18 | 64.74 | 64.8 | 34588300 | 64.62
 |  |  |  |  |  |  |  |  |  |  |  |  | 2012-07-30 00:00:00 | 65.03 | 65.31 | 64.6 | 64.82 | 37821300 | 64.64
 |  |  |  |  |  |  |  |  |  |  |  |  | 2012-07-27 00:00:00 | 63.83 | 64.99 | 63.64 | 64.87 | 42621000 | 64.69
 |  |  |  |  |  |  |  |  |  |  |  |  | 2012-07-26 00:00:00 | 63.44 | 63.73 | 62.97 | 63.37 | 41928200 | 63.19
 |  |  |  |  |  |  |  |  |  |  |  |  | 2012-07-25 00:00:00 | 62.47 | 62.95 | 62.15 | 62.54 | 46264400 | 62.36
 |  |  |  |  |  |  |  |  |  |  |  |  | 2012-07-24 00:00:00 | 63.57 | 63.66 | 62.55 | 62.96 | 57269700 | 62.78
 |  |  |  |  |  |  |  |  |  |  |  |  | 2012-07-23 00:00:00 | 62.99 | 63.68 | 62.51 | 63.46 | 48657800 | 63.28
 |  |  |  |  |  |  |  |  |  |  |  |  | 2012-07-20 00:00:00 | 65.08 | 65.1 | 64.21 | 64.24 | 40573100 | 64.06
 |  |  |  |  |  |  |  |  |  |  |  |  | 2012-07-19 00:00:00 | 64.84 | 65.31 | 64.72 | 65.1 | 53017800 | 64.91
 |  |  |  |  |  |  |  |  |  |  |  |  | 2012-07-18 00:00:00 | 63.41 | 64.58 | 63.39 | 64.39 | 44460300 | 64.21
 |  |  |  |  |  |  |  |  |  |  |  |  | 2012-07-17 00:00:00 | 63.6 | 63.74 | 62.63 | 63.53 | 42467800 | 63.35
 |  |  |  |  |  |  |  |  |  |  |  |  | 2012-07-16 00:00:00 | 63.24 | 63.52 | 62.95 | 63.2 | 27621400 | 63.02
 |  |  |  |  |  |  |  |  |  |  |  |  | 2012-07-13 00:00:00 | 62.6 | 63.52 | 62.56 | 63.38 | 32357200 | 63.2
 |  |  |  |  |  |  |  |  |  |  |  |  | 2012-07-12 00:00:00 | 62.52 | 62.69 | 61.86 | 62.43 | 57680400 | 62.25
 |  |  |  |  |  |  |  |  |  |  |  |  | 2012-07-11 00:00:00 | 63.29 | 63.46 | 62.5 | 63.02 | 43432000 | 62.84
 |  |  |  |  |  |  |  |  |  |  |  |  | 2012-07-10 00:00:00 | 64.35 | 64.51 | 63.12 | 63.37 | 47365700 | 63.19
 |  |  |  |  |  |  |  |  |  |  |  |  | 2012-07-09 00:00:00 | 64.05 | 64.26 | 63.68 | 64 | 35628300 | 63.82
 |  |  |  |  |  |  |  |  |  |  |  |  | 2012-07-06 00:00:00 | 64.63 | 64.69 | 63.65 | 64.12 | 40684100 | 63.94
 |  |  |  |  |  |  |  |  |  |  |  |  | 2012-07-05 00:00:00 | 64.83 | 65.25 | 64.48 | 64.93 | 37016200 | 64.75
 |  |  |  |  |  |  |  |  |  |  |  |  | 2012-07-03 00:00:00 | 64.39 | 64.89 | 64.29 | 64.89 | 15895100 | 64.71
 |  |  |  |  |  |  |  |  |  |  |  |  | 2012-07-02 00:00:00 | 64.25 | 64.38 | 63.87 | 64.35 | 33425600 | 64.17
 |  |  |  |  |  |  |  |  |  |  |  |  | 2012-06-29 00:00:00 | 63.4 | 64.16 | 63.21 | 64.16 | 44761300 | 63.98
 |  |  |  |  |  |  |  |  |  |  |  |  | 2012-06-28 00:00:00 | 62.43 | 62.47 | 61.54 | 62.2 | 49768300 | 62.02
 |  |  |  |  |  |  |  |  |  |  |  |  | 2012-06-27 00:00:00 | 62.76 | 63.18 | 62.69 | 62.9 | 35705800 | 62.72
 |  |  |  |  |  |  |  |  |  |  |  |  | 2012-06-26 00:00:00 | 62.34 | 62.7 | 62.06 | 62.52 | 30611100 | 62.34
 |  |  |  |  |  |  |  |  |  |  |  |  | 2012-06-25 00:00:00 | 62.83 | 62.85 | 61.95 | 62.13 | 33136400 | 61.95
 |  |  |  |  |  |  |  |  |  |  |  |  | 2012-06-22 00:00:00 | 62.9 | 63.43 | 62.73 | 63.35 | 29504200 | 63.17
 |  |  |  |  |  |  |  |  |  |  |  | [NAME] should return stop loss price since it opened above but touched stop price during day's trading | 2012-06-21 00:00:00 | 64.24 | 64.31 | 55 | 62.69 | 42492700 | 62.51
 |  |  |  |  |  |  |  |  |  |  |  |  | 2012-06-20 00:00:00 | 64.38 | 64.57 | 63.81 | 64.29 | 51389700 | 64.11
 |  |  |  |  |  |  |  |  |  |  |  |  | 2012-06-19 00:00:00 | 63.9 | 64.51 | 63.85 | 64.24 | 36476500 | 64.06
 |  |  |  |  |  |  |  |  |  |  |  |  | 2012-06-18 00:00:00 | 62.73 | 63.74 | 62.63 | 63.58 | 32191200 | 63.4
 |  |  |  |  |  |  |  |  |  |  |  |  | 2012-06-15 00:00:00 | 62.39 | 63.08 | 62.36 | 62.99 | 41536100 | 62.81
 |  |  |  |  |  |  |  |  |  |  |  |  | 2012-06-14 00:00:00 | 62.12 | 62.61 | 61.8 | 62.36 | 65170600 | 62.04
 |  |  |  |  |  |  |  |  |  |  |  |  | 2012-06-13 00:00:00 | 62.38 | 62.85 | 61.92 | 62.13 | 50830000 | 61.81
 |  |  |  |  |  |  |  |  |  |  |  |  | 2012-06-12 00:00:00 | 62.1 | 62.59 | 61.68 | 62.56 | 48802600 | 62.24
 |  |  |  |  |  |  |  |  |  |  |  |  | 2012-06-11 00:00:00 | 63.35 | 63.38 | 61.77 | 61.81 | 51008900 | 61.49
 |  |  |  |  |  |  |  |  |  |  |  |  | 2012-06-08 00:00:00 | 62.17 | 62.95 | 61.96 | 62.87 | 39730800 | 62.55
 |  |  |  |  |  |  |  |  |  |  |  |  | 2012-06-07 00:00:00 | 63.18 | 63.18 | 62.22 | 62.27 | 38414800 | 61.95
 |  |  |  |  |  |  |  |  |  |  |  |  | 2012-06-06 00:00:00 | 61.58 | 62.57 | 61.52 | 62.52 | 58781800 | 62.2
 |  |  |  |  |  |  |  |  |  |  |  |  | 2012-06-05 00:00:00 | 60.66 | 61.24 | 60.63 | 61.12 | 47916900 | 60.81
 |  |  |  |  |  |  |  |  |  |  |  |  | 2012-06-04 00:00:00 | 60.58 | 60.96 | 60.04 | 60.87 | 74119500 | 60.56
 |  |  |  |  |  |  |  |  |  |  |  |  | 2012-06-01 00:00:00 | 60.94 | 61.32 | 60.39 | 60.41 | 71430800 | 60.1
 |  |  |  |  |  |  |  |  |  |  |  |  | 2012-05-31 00:00:00 | 62.25 | 62.41 | 61.59 | 62.06 | 55260100 | 61.74
 |  |  |  |  |  |  |  |  |  |  |  |  | 2012-05-30 00:00:00 | 62.29 | 62.55 | 61.68 | 62.33 | 56431800 | 62.01
 |  |  |  |  |  |  |  |  |  |  |  |  | 2012-05-29 00:00:00 | 62.65 | 63.15 | 62.28 | 62.86 | 44216700 | 62.54
 |  |  |  |  |  |  |  |  |  |  |  |  | 2012-05-25 00:00:00 | 62.21 | 62.32 | 61.89 | 62.07 | 32078900 | 61.75
 |  |  |  |  |  |  |  |  |  |  |  |  | 2012-05-24 00:00:00 | 62.65 | 62.71 | 61.69 | 62.15 | 83131200 | 61.83
 |  |  |  |  |  |  |  |  |  |  |  |  | 2012-05-23 00:00:00 | 61.91 | 62.71 | 61.37 | 62.56 | 56951100 | 62.24
 |  |  |  |  |  |  |  |  |  |  |  |  | 2012-05-22 00:00:00 | 62.69 | 62.95 | 61.99 | 62.44 | 62954800 | 62.12
 |  |  |  |  |  |  |  |  |  |  |  |  | 2012-05-21 00:00:00 | 60.93 | 62.57 | 60.85 | 62.51 | 61473000 | 62.19
 |  |  |  |  |  |  |  |  |  |  |  |  | 2012-05-18 00:00:00 | 61.8 | 61.96 | 60.76 | 60.81 | 79496500 | 60.5
 |  |  |  |  |  |  |  |  |  |  |  |  | 2012-05-17 00:00:00 | 62.96 | 63.06 | 61.6 | 61.61 | 62253900 | 61.29
 |  |  |  |  |  |  |  |  |  |  |  |  | 2012-05-16 00:00:00 | 63.59 | 63.78 | 62.81 | 62.94 | 52825900 | 62.62
 |  |  |  |  |  |  |  |  |  |  |  |  | 2012-05-15 00:00:00 | 63.75 | 64.27 | 63.26 | 63.37 | 66895600 | 63.04
 |  |  |  |  |  |  |  |  |  |  |  |  | 2012-05-14 00:00:00 | 63.63 | 64.08 | 63.48 | 63.58 | 46360000 | 63.25
 |  |  |  |  |  |  |  |  |  |  |  |  | 2012-05-11 00:00:00 | 63.97 | 64.86 | 63.91 | 64.18 | 47099900 | 63.85
 |  |  |  |  |  |  |  |  |  |  |  |  | 2012-05-10 00:00:00 | 64.61 | 64.63 | 63.95 | 64.19 | 49448900 | 63.86
 |  |  |  |  |  |  |  |  |  |  |  |  | 2012-05-09 00:00:00 | 63.77 | 64.68 | 63.51 | 64.32 | 85715300 | 63.99
 |  |  |  |  |  |  |  |  |  |  |  |  | 2012-05-08 00:00:00 | 64.35 | 64.74 | 63.48 | 64.52 | 72659700 | 64.19
 |  |  |  |  |  |  |  |  |  |  |  |  | 2012-05-07 00:00:00 | 64.31 | 65.07 | 64.29 | 64.76 | 50267800 | 64.43
 |  |  |  |  |  |  |  |  |  |  |  |  | 2012-05-04 00:00:00 | 65.74 | 66.35 | 64.69 | 64.7 | 107554000 | 64.37
 |  |  |  |  |  |  |  |  |  |  |  |  | 2012-05-03 00:00:00 | 67.1 | 67.15 | 66.18 | 66.35 | 51297600 | 66.01
 |  |  |  |  |  |  |  |  |  |  |  |  | 2012-05-02 00:00:00 | 66.54 | 67.11 | 66.38 | 67.06 | 38299300 | 66.72
 |  |  |  |  |  |  |  |  |  |  |  | [NAME] should return Open price, not the day's low for this date | 2012-05-01 00:00:00 | 58 | 67.63 | 55 | 66.87 | 37643800 | 66.53
 |  |  |  |  |  |  |  |  |  |  |  |  | 2012-04-30 00:00:00 | 67.04 | 67.17 | 66.71 | 66.76 | 37787700 | 66.42
 |  |  |  |  |  |  |  |  |  |  |  |  | 2012-04-27 00:00:00 | 67.12 | 67.45 | 66.77 | 67.24 | 46003800 | 66.9
 |  |  |  |  |  |  |  |  |  |  |  |  | 2012-04-26 00:00:00 | 66.44 | 66.99 | 66.35 | 66.84 | 41799500 | 66.5
 |  |  |  |  |  |  |  |  |  |  |  |  | 2012-04-25 00:00:00 | 66.07 | 66.49 | 65.97 | 66.45 | 57526900 | 66.11
 |  |  |  |  |  |  |  |  |  |  |  |  | 2012-04-24 00:00:00 | 64.96 | 65.23 | 64.45 | 64.73 | 49661500 | 64.4
 |  |  |  |  |  |  |  |  |  |  |  |  | 2012-04-23 00:00:00 | 65.06 | 65.18 | 64.49 | 65.08 | 70501000 | 64.75
 |  |  |  |  |  |  |  |  |  |  |  |  | 2012-04-20 00:00:00 | 66.22 | 66.51 | 65.58 | 65.68 | 59906900 | 65.34
 |  |  |  |  |  |  |  |  |  |  |  |  | 2012-04-19 00:00:00 | 66.37 | 67.17 | 65.62 | 65.86 | 81110900 | 65.52
 |  |  |  |  |  |  |  |  |  |  |  |  | 2012-04-18 00:00:00 | 66.59 | 67 | 66.41 | 66.61 | 42536100 | 66.27
 |  |  |  |  |  |  |  |  |  |  |  |  | 2012-04-17 00:00:00 | 65.73 | 66.99 | 65.63 | 66.78 | 47362400 | 66.44
 |  |  |  |  |  |  |  |  |  |  |  |  | 2012-04-16 00:00:00 | 66.52 | 66.56 | 65.24 | 65.45 | 57588000 | 65.11
 |  |  |  |  |  |  |  |  |  |  |  |  | 2012-04-13 00:00:00 | 66.98 | 67.2 | 66.16 | 66.19 | 55227500 | 65.85
 |  |  |  |  |  |  |  |  |  |  |  |  | 2012-04-12 00:00:00 | 66.58 | 67.28 | 66.48 | 67.21 | 57407400 | 66.87
 |  |  |  |  |  |  |  |  |  |  |  |  | 2012-04-11 00:00:00 | 66.71 | 66.89 | 66.28 | 66.45 | 62950000 | 66.11
 |  |  |  |  |  |  |  |  |  |  |  |  | 2012-04-10 00:00:00 | 67.18 | 67.44 | 65.92 | 66.13 | 69254200 | 65.79
 |  |  |  |  |  |  |  |  |  |  |  |  | 2012-04-09 00:00:00 | 66.88 | 67.48 | 66.76 | 67.21 | 36908200 | 66.87
 |  |  |  |  |  |  |  |  |  |  |  |  | 2012-04-05 00:00:00 | 67.18 | 67.78 | 67.13 | 67.72 | 42979900 | 67.37
 |  |  |  |  |  |  |  |  |  |  |  |  | 2012-04-04 00:00:00 | 67.72 | 67.76 | 66.91 | 67.3 | 54088100 | 66.95
 |  |  |  |  |  |  |  |  |  |  |  |  | 2012-04-03 00:00:00 | 68.31 | 68.55 | 67.85 | 68.23 | 45539900 | 67.88
 |  |  |  |  |  |  |  |  |  |  |  |  | 2012-04-02 00:00:00 | 67.48 | 68.34 | 67.36 | 68.25 | 40031600 | 67.9
 |  |  |  |  |  |  |  |  |  |  |  |  | 2012-03-30 00:00:00 | 67.98 | 68.02 | 67.28 | 67.55 | 39480900 | 67.2
 |  |  |  |  |  |  |  |  |  |  |  |  | 2012-03-29 00:00:00 | 67.6 | 67.93 | 67.2 | 67.68 | 53975300 | 67.33
 |  |  |  |  |  |  |  |  |  |  |  |  | 2012-03-28 00:00:00 | 68.25 | 68.51 | 67.54 | 67.94 | 44421900 | 67.59
 |  |  |  |  |  |  |  |  |  |  |  |  | 2012-03-27 00:00:00 | 68.16 | 68.49 | 68.13 | 68.21 | 37278200 | 67.86
 |  |  |  |  |  |  |  |  |  |  |  |  | 2012-03-26 00:00:00 | 67.39 | 68.11 | 67.33 | 68.11 | 40855300 | 67.76
 |  |  |  |  |  |  |  |  |  |  |  |  | 2012-03-23 00:00:00 | 67.06 | 67.08 | 66.56 | 66.94 | 45541700 | 66.6
 |  |  |  |  |  |  |  |  |  |  |  |  | 2012-03-22 00:00:00 | 66.72 | 67.14 | 66.68 | 66.98 | 56953900 | 66.64
 |  |  |  |  |  |  |  |  |  |  |  |  | 2012-03-21 00:00:00 | 67.12 | 67.49 | 67.03 | 67.12 | 39648100 | 66.78
 |  |  |  |  |  |  |  |  |  |  |  |  | 2012-03-20 00:00:00 | 66.64 | 67.18 | 66.46 | 67.11 | 47290600 | 66.77
 |  |  |  |  |  |  |  |  |  |  |  |  | 2012-03-19 00:00:00 | 66.63 | 67.15 | 66.45 | 66.99 | 60966200 | 66.65
 |  |  |  |  |  |  |  |  |  |  |  |  | 2012-03-16 00:00:00 | 66.67 | 66.67 | 66.36 | 66.52 | 53023100 | 66.18
 |  |  |  |  |  |  |  |  |  |  |  |  | 2012-03-15 00:00:00 | 66.69 | 66.82 | 66.35 | 66.68 | 65531200 | 66.23
 |  |  |  |  |  |  |  |  |  |  |  |  | 2012-03-14 00:00:00 | 66.33 | 66.74 | 66.08 | 66.49 | 59926900 | 66.04
 |  |  |  |  |  |  |  |  |  |  |  |  | 2012-03-13 00:00:00 | 65.4 | 66.26 | 65.27 | 66.26 | 61509300 | 65.81
 |  |  |  |  |  |  |  |  |  |  |  |  | 2012-03-12 00:00:00 | 65 | 65.11 | 64.72 | 65.05 | 32687300 | 64.61
 |  |  |  |  |  |  |  |  |  |  |  |  | 2012-03-09 00:00:00 | 64.86 | 65.14 | 64.82 | 65.02 | 43117200 | 64.58
 |  |  |  |  |  |  |  |  |  |  |  |  | 2012-03-08 00:00:00 | 64.44 | 64.94 | 64.3 | 64.75 | 43711100 | 64.31
 |  |  |  |  |  |  |  |  |  |  |  |  | 2012-03-07 00:00:00 | 63.87 | 64.21 | 63.77 | 64.06 | 42741800 | 63.62
 |  |  |  |  |  |  |  |  |  |  |  |  | 2012-03-06 00:00:00 | 63.57 | 63.72 | 63.23 | 63.57 | 54638600 | 63.14
 |  |  |  |  |  |  |  |  |  |  |  |  | 2012-03-05 00:00:00 | 64.83 | 64.91 | 63.99 | 64.2 | 45788800 | 63.76
 |  |  |  |  |  |  |  |  |  |  |  |  | 2012-03-02 00:00:00 | 64.83 | 65.08 | 64.66 | 64.87 | 33358200 | 64.43
 |  |  |  |  |  |  |  |  |  |  |  |  | 2012-03-01 00:00:00 | 64.65 | 64.98 | 64.46 | 64.92 | 67558900 | 64.48
 |  |  |  |  |  |  |  |  |  |  |  |  | 2012-02-29 00:00:00 | 64.75 | 64.96 | 64.2 | 64.41 | 59784400 | 63.97
 |  |  |  |  |  |  |  |  |  |  |  |  | 2012-02-28 00:00:00 | 64.11 | 64.7 | 64.03 | 64.7 | 43717500 | 64.26
 |  |  |  |  |  |  |  |  |  |  |  |  | 2012-02-27 00:00:00 | 63.61 | 64.26 | 63.33 | 64.05 | 42678500 | 63.61
 |  |  |  |  |  |  |  |  |  |  |  |  | 2012-02-24 00:00:00 | 63.92 | 64.07 | 63.8 | 63.96 | 41364900 | 63.52
 |  |  |  |  |  |  |  |  |  |  |  |  | 2012-02-23 00:00:00 | 63.4 | 63.81 | 63.09 | 63.74 | 54250000 | 63.31
 |  |  |  |  |  |  |  |  |  |  |  |  | 2012-02-22 00:00:00 | 63.49 | 63.68 | 63.23 | 63.32 | 43174700 | 62.89
 |  |  |  |  |  |  |  |  |  |  |  |  | 2012-02-21 00:00:00 | 63.5 | 63.89 | 63.21 | 63.61 | 38141300 | 63.18
 |  |  |  |  |  |  |  |  |  |  |  |  | 2012-02-17 00:00:00 | 63.64 | 63.69 | 63.15 | 63.43 | 76112300 | 63
 |  |  |  |  |  |  |  |  |  |  |  |  | 2012-02-16 00:00:00 | 62.79 | 63.7 | 62.63 | 63.63 | 83642300 | 63.2
 |  |  |  |  |  |  |  |  |  |  |  |  | 2012-02-15 00:00:00 | 63.51 | 63.86 | 62.67 | 62.77 | 105709100 | 62.34
 |  |  |  |  |  |  |  |  |  |  |  |  | 2012-02-14 00:00:00 | 62.91 | 63.22 | 62.69 | 63.21 | 51648200 | 62.78
 |  |  |  |  |  |  |  |  |  |  |  |  | 2012-02-13 00:00:00 | 62.94 | 63.13 | 62.65 | 63.05 | 36810200 | 62.62
 |  |  |  |  |  |  |  |  |  |  |  |  | 2012-02-10 00:00:00 | 62.46 | 62.64 | 62.25 | 62.47 | 58090500 | 62.04
 |  |  |  |  |  |  |  |  |  |  |  |  | 2012-02-09 00:00:00 | 62.7 | 62.98 | 62.32 | 62.91 | 46856400 | 62.48
 |  |  |  |  |  |  |  |  |  |  |  |  | 2012-02-08 00:00:00 | 62.14 | 62.46 | 61.91 | 62.46 | 41171100 | 62.03
 |  |  |  |  |  |  |  |  |  |  |  |  | 2012-02-07 00:00:00 | 61.95 | 62.25 | 61.67 | 62.13 | 37935700 | 61.71
 |  |  |  |  |  |  |  |  |  |  |  |  | 2012-02-06 00:00:00 | 61.82 | 62.02 | 61.66 | 62 | 28541300 | 61.58
 |  |  |  |  |  |  |  |  |  |  |  |  | 2012-02-03 00:00:00 | 61.78 | 62.12 | 61.68 | 62.05 | 36453800 | 61.63
 |  |  |  |  |  |  |  |  |  |  |  |  | 2012-02-02 00:00:00 | 61.22 | 61.41 | 60.97 | 61.21 | 46373600 | 60.79
 |  |  |  |  |  |  |  |  |  |  |  |  | 2012-02-01 00:00:00 | 60.88 | 61.24 | 60.66 | 61.02 | 46146700 | 60.6
 |  |  |  |  |  |  |  |  |  |  |  |  | 2012-01-31 00:00:00 | 60.75 | 60.86 | 60.14 | 60.53 | 51449600 | 60.12
 |  |  |  |  |  |  |  |  |  |  |  |  | 2012-01-30 00:00:00 | 59.89 | 60.54 | 59.66 | 60.45 | 42797800 | 60.04
 |  |  |  |  |  |  |  |  |  |  |  |  | 2012-01-27 00:00:00 | 60.09 | 60.51 | 60.06 | 60.4 | 45532300 | 59.99
 |  |  |  |  |  |  |  |  |  |  |  |  | 2012-01-26 00:00:00 | 60.69 | 60.8 | 59.93 | 60.22 | 37852700 | 59.81
 |  |  |  |  |  |  |  |  |  |  |  |  | 2012-01-25 00:00:00 | 60.26 | 60.58 | 59.83 | 60.43 | 61578200 | 60.02
 |  |  |  |  |  |  |  |  |  |  |  |  | 2012-01-24 00:00:00 | 59.52 | 59.84 | 59.41 | 59.68 | 38440200 | 59.27
 |  |  |  |  |  |  |  |  |  |  |  |  | 2012-01-23 00:00:00 | 59.78 | 60.21 | 59.44 | 59.79 | 40958300 | 59.38
 |  |  |  |  |  |  |  |  |  |  |  |  | 2012-01-20 00:00:00 | 59.6 | 59.8 | 59.56 | 59.77 | 41041700 | 59.36
 |  |  |  |  |  |  |  |  |  |  |  |  | 2012-01-19 00:00:00 | 59.76 | 59.97 | 59.65 | 59.86 | 47774500 | 59.45
 |  |  |  |  |  |  |  |  |  |  |  |  | 2012-01-18 00:00:00 | 58.82 | 59.49 | 58.68 | 59.49 | 48692700 | 59.08
 |  |  |  |  |  |  |  |  |  |  |  |  | 2012-01-17 00:00:00 | 58.69 | 58.96 | 58.49 | 58.71 | 41790800 | 58.31
 |  |  |  |  |  |  |  |  |  |  |  |  | 2012-01-13 00:00:00 | 58.08 | 58.2 | 57.68 | 58.18 | 35980400 | 57.78
 |  |  |  |  |  |  |  |  |  |  |  |  | 2012-01-12 00:00:00 | 58.29 | 58.47 | 57.86 | 58.39 | 26188300 | 57.99
 |  |  |  |  |  |  |  |  |  |  |  |  | 2012-01-11 00:00:00 | 58.03 | 58.29 | 57.81 | 58.16 | 37144100 | 57.76
 |  |  |  |  |  |  |  |  |  |  |  |  | 2012-01-10 00:00:00 | 58.23 | 58.4 | 57.64 | 58.04 | 35949900 | 57.64
 |  |  |  |  |  |  |  |  |  |  |  |  | 2012-01-09 00:00:00 | 57.96 | 57.98 | 57.43 | 57.62 | 39195500 | 57.23
 |  |  |  |  |  |  |  |  |  |  |  |  | 2012-01-06 00:00:00 | 57.62 | 57.94 | 57.4 | 57.81 | 46325200 | 57.42
 |  |  |  |  |  |  |  |  |  |  |  |  | 2012-01-05 00:00:00 | 57.02 | 57.66 | 56.8 | 57.61 | 41260600 | 57.22
 |  |  |  |  |  |  |  |  |  |  |  |  | 2012-01-04 00:00:00 | 56.81 | 57.22 | 56.56 | 57.14 | 29403400 | 56.75
 |  |  |  |  |  |  |  |  |  |  |  |  | 2012-01-03 00:00:00 | 56.91 | 57.19 | 56.75 | 56.9 | 39514100 | 56.51
 |  |  |  |  |  |  |  |  |  |  |  |  | 2011-12-30 00:00:00 | 55.87 | 56.12 | 55.82 | 55.83 | 21832400 | 55.45
 |  |  |  |  |  |  |  |  |  |  |  |  | 2011-12-29 00:00:00 | 55.68 | 56.03 | 55.5 | 55.99 | 28077900 | 55.61
 |  |  |  |  |  |  |  |  |  |  |  |  | 2011-12-28 00:00:00 | 56.17 | 56.26 | 55.44 | 55.59 | 38180100 | 55.21
 |  |  |  |  |  |  |  |  |  |  |  |  | 2011-12-27 00:00:00 | 55.99 | 56.42 | 55.93 | 56.24 | 21443500 | 55.86
 |  |  |  |  |  |  |  |  |  |  |  |  | 2011-12-23 00:00:00 | 55.71 | 56.08 | 55.58 | 56.08 | 26594600 | 55.65
 |  |  |  |  |  |  |  |  |  |  |  |  | 2011-12-22 00:00:00 | 55.25 | 55.63 | 55.17 | 55.6 | 40334100 | 55.17
 |  |  |  |  |  |  |  |  |  |  |  |  | 2011-12-21 00:00:00 | 55.6 | 55.64 | 54.49 | 55.13 | 78552300 | 54.71
 |  |  |  |  |  |  |  |  |  |  |  |  | 2011-12-20 00:00:00 | 55.2 | 56 | 55.17 | 55.93 | 81758800 | 55.5
 |  |  |  |  |  |  |  |  |  |  |  |  | 2011-12-19 00:00:00 | 55.07 | 55.2 | 54.17 | 54.32 | 46733900 | 53.9
 |  |  |  |  |  |  |  |  |  |  |  |  | 2011-12-16 00:00:00 | 54.87 | 55.61 | 54.77 | 54.86 | 60978900 | 54.44
 |  |  |  |  |  |  |  |  |  |  |  |  | 2011-12-15 00:00:00 | 55.36 | 55.42 | 54.66 | 54.74 | 58732900 | 54.16
 |  |  |  |  |  |  |  |  |  |  |  |  | 2011-12-14 00:00:00 | 55.55 | 55.59 | 54.58 | 54.89 | 63682800 | 54.31
 |  |  |  |  |  |  |  |  |  |  |  |  | 2011-12-13 00:00:00 | 56.75 | 56.98 | 55.53 | 55.76 | 68557700 | 55.17
 |  |  |  |  |  |  |  |  |  |  |  |  | 2011-12-12 00:00:00 | 56.42 | 57.01 | 55.9 | 56.38 | 55411700 | 55.78
 |  |  |  |  |  |  |  |  |  |  |  |  | 2011-12-09 00:00:00 | 56.26 | 57.19 | 56.24 | 57.02 | 55757900 | 56.42
 |  |  |  |  |  |  |  |  |  |  |  |  | 2011-12-08 00:00:00 | 56.71 | 57.15 | 56.01 | 56.12 | 51692600 | 55.52
 |  |  |  |  |  |  |  |  |  |  |  |  | 2011-12-07 00:00:00 | 56.92 | 57.34 | 56.35 | 57.08 | 44576200 | 56.47
 |  |  |  |  |  |  |  |  |  |  |  |  | 2011-12-06 00:00:00 | 57.29 | 57.45 | 56.89 | 57.08 | 38670000 | 56.47
 |  |  |  |  |  |  |  |  |  |  |  |  | 2011-12-05 00:00:00 | 57.47 | 57.62 | 56.92 | 57.24 | 40492200 | 56.63
 |  |  |  |  |  |  |  |  |  |  |  |  | 2011-12-02 00:00:00 | 57.34 | 57.34 | 56.57 | 56.62 | 36938900 | 56.02
 |  |  |  |  |  |  |  |  |  |  |  |  | 2011-12-01 00:00:00 | 56.38 | 56.93 | 56.35 | 56.78 | 45362200 | 56.18
 |  |  |  |  |  |  |  |  |  |  |  |  | 2011-11-30 00:00:00 | 55.86 | 56.44 | 55.67 | 56.39 | 66918600 | 55.79
 |  |  |  |  |  |  |  |  |  |  |  |  | 2011-11-29 00:00:00 | 54.69 | 55.1 | 54.22 | 54.38 | 52056700 | 53.8
 |  |  |  |  |  |  |  |  |  |  |  |  | 2011-11-28 00:00:00 | 54.17 | 54.79 | 54.14 | 54.72 | 46710700 | 54.14
 |  |  |  |  |  |  |  |  |  |  |  |  | 2011-11-25 00:00:00 | 53.06 | 53.67 | 52.87 | 52.88 | 25448100 | 52.32
 |  |  |  |  |  |  |  |  |  |  |  |  | 2011-11-23 00:00:00 | 54.11 | 54.17 | 53.26 | 53.29 | 48437300 | 52.72
 |  |  |  |  |  |  |  |  |  |  |  |  | 2011-11-22 00:00:00 | 54.17 | 54.68 | 53.87 | 54.52 | 51940100 | 53.94
 |  |  |  |  |  |  |  |  |  |  |  |  | 2011-11-21 00:00:00 | 54.65 | 54.73 | 53.78 | 54.34 | 52283700 | 53.76
 |  |  |  |  |  |  |  |  |  |  |  |  | 2011-11-18 00:00:00 | 55.84 | 55.9 | 55.3 | 55.4 | 60417000 | 54.81
 |  |  |  |  |  |  |  |  |  |  |  |  | 2011-11-17 00:00:00 | 57.01 | 57.04 | 55.48 | 55.83 | 101564300 | 55.24
 |  |  |  |  |  |  |  |  |  |  |  |  | 2011-11-16 00:00:00 | 57.71 | 58.16 | 57.06 | 57.17 | 68342800 | 56.56
 |  |  |  |  |  |  |  |  |  |  |  |  | 2011-11-15 00:00:00 | 57.32 | 58.36 | 57.26 | 58.13 | 52203900 | 57.51
 |  |  |  |  |  |  |  |  |  |  |  |  | 2011-11-14 00:00:00 | 57.69 | 58.01 | 57.28 | 57.49 | 44617600 | 56.88
 |  |  |  |  |  |  |  |  |  |  |  |  | 2011-11-11 00:00:00 | 57.27 | 58.02 | 57.2 | 57.85 | 54471000 | 57.24
 |  |  |  |  |  |  |  |  |  |  |  |  | 2011-11-10 00:00:00 | 57.37 | 57.42 | 56.23 | 56.78 | 66052400 | 56.18
 |  |  |  |  |  |  |  |  |  |  |  |  | 2011-11-09 00:00:00 | 57.74 | 57.83 | 56.63 | 56.81 | 69539000 | 56.21
 |  |  |  |  |  |  |  |  |  |  |  |  | 2011-11-08 00:00:00 | 58.63 | 58.98 | 57.97 | 58.88 | 62906900 | 58.26
 |  |  |  |  |  |  |  |  |  |  |  |  | 2011-11-07 00:00:00 | 57.76 | 58.25 | 57.17 | 58.21 | 65559000 | 57.59
 |  |  |  |  |  |  |  |  |  |  |  |  | 2011-11-04 00:00:00 | 57.82 | 58.05 | 57.22 | 57.8 | 61527800 | 57.19
 |  |  |  |  |  |  |  |  |  |  |  |  | 2011-11-03 00:00:00 | 57.37 | 58.18 | 56.71 | 58.1 | 78994200 | 57.48
 |  |  |  |  |  |  |  |  |  |  |  |  | 2011-11-02 00:00:00 | 57.03 | 57.16 | 56.38 | 56.92 | 65178800 | 56.32
 |  |  |  |  |  |  |  |  |  |  |  |  | 2011-11-01 00:00:00 | 56.52 | 57.91 | 56.12 | 56.44 | 99933000 | 55.84
 |  |  |  |  |  |  |  |  |  |  |  |  | 2011-10-31 00:00:00 | 58.43 | 58.64 | 57.91 | 57.95 | 60520200 | 57.34
 |  |  |  |  |  |  |  |  |  |  |  |  | 2011-10-28 00:00:00 | 58.52 | 59.01 | 58.5 | 58.94 | 42950000 | 58.32
 |  |  |  |  |  |  |  |  |  |  |  |  | 2011-10-27 00:00:00 | 58.64 | 59.2 | 58.03 | 58.85 | 104455500 | 58.23
 |  |  |  |  |  |  |  |  |  |  |  |  | 2011-10-26 00:00:00 | 57.66 | 57.78 | 56.21 | 57.27 | 98193800 | 56.66
 |  |  |  |  |  |  |  |  |  |  |  |  | 2011-10-25 00:00:00 | 58.3 | 58.32 | 57.22 | 57.34 | 65299200 | 56.73
 |  |  |  |  |  |  |  |  |  |  |  |  | 2011-10-24 00:00:00 | 57.51 | 58.65 | 57.31 | 58.49 | 61449500 | 57.87
 |  |  |  |  |  |  |  |  |  |  |  |  | 2011-10-21 00:00:00 | 57.19 | 57.66 | 56.78 | 57.3 | 60455800 | 56.69
 |  |  |  |  |  |  |  |  |  |  |  | [NAME] should return stop loss since it opened above criteria, but hit that price during day's trading | 2011-10-20 00:00:00 | 56.86 | 56.92 | 50 | 56.59 | 80378300 | 55.99
 |  |  |  |  |  |  |  |  |  |  |  |  | 2011-10-19 00:00:00 | 57.67 | 57.85 | 56.68 | 56.87 | 67639400 | 56.27
 |  |  |  |  |  |  |  |  |  |  |  |  | 2011-10-18 00:00:00 | 57.19 | 58.29 | 56.66 | 57.99 | 91434600 | 57.38
 |  |  |  |  |  |  |  |  |  |  |  |  | 2011-10-17 00:00:00 | 57.91 | 58.09 | 56.97 | 57.28 | 65161300 | 56.67
 |  |  |  |  |  |  |  |  |  |  |  |  | 2011-10-14 00:00:00 | 57.82 | 58.19 | 57.51 | 58.18 | 65643600 | 57.56
 |  |  |  |  |  |  |  |  |  |  |  |  | 2011-10-13 00:00:00 | 56.49 | 57.19 | 56.43 | 57.12 | 63443700 | 56.51
 |  |  |  |  |  |  |  |  |  |  |  |  | 2011-10-12 00:00:00 | 56.86 | 57.23 | 56.56 | 56.6 | 85627600 | 56
 |  |  |  |  |  |  |  |  |  |  |  |  | 2011-10-11 00:00:00 | 55.79 | 56.46 | 55.7 | 56.32 | 66449100 | 55.72
 |  |  |  |  |  |  |  |  |  |  |  |  | 2011-10-10 00:00:00 | 54.99 | 55.94 | 54.89 | 55.94 | 48230200 | 55.35
 |  |  |  |  |  |  |  |  |  |  |  |  | 2011-10-07 00:00:00 | 54.4 | 54.66 | 53.72 | 54.07 | 72525200 | 53.5
 |  |  |  |  |  |  |  |  |  |  |  |  | 2011-10-06 00:00:00 | 53.46 | 54.44 | 53.21 | 54.43 | 71939200 | 53.85
 |  |  |  |  |  |  |  |  |  |  |  |  | 2011-10-05 00:00:00 | 52.06 | 53.68 | 51.66 | 53.53 | 108825700 | 52.96
 |  |  |  |  |  |  |  |  |  |  |  |  | 2011-10-04 00:00:00 | 50.62 | 52.29 | 50.1 | 52.19 | 137013700 | 51.64
 |  |  |  |  |  |  |  |  |  |  |  |  | 2011-10-03 00:00:00 | 52.02 | 52.85 | 51.11 | 51.14 | 99149500 | 50.6
 |  |  |  |  |  |  |  |  |  |  |  |  | 2011-09-30 00:00:00 | 53.16 | 53.61 | 52.46 | 52.49 | 104870100 | 51.93
 |  |  |  |  |  |  |  |  |  |  |  |  | 2011-09-29 00:00:00 | 55.36 | 55.43 | 52.97 | 53.88 | 116900200 | 53.31
 |  |  |  |  |  |  |  |  |  |  |  |  | 2011-09-28 00:00:00 | 55.59 | 55.97 | 54.4 | 54.53 | 76757100 | 53.95
 |  |  |  |  |  |  |  |  |  |  |  |  | 2011-09-27 00:00:00 | 55.71 | 56.2 | 54.98 | 55.35 | 81148600 | 54.76
 |  |  |  |  |  |  |  |  |  |  |  |  | 2011-09-26 00:00:00 | 54.42 | 54.88 | 53.21 | 54.78 | 96261400 | 54.2
 |  |  |  |  |  |  |  |  |  |  |  |  | 2011-09-23 00:00:00 | 53.13 | 54.38 | 53.09 | 54.15 | 85921800 | 53.58
 |  |  |  |  |  |  |  |  |  |  |  |  | 2011-09-22 00:00:00 | 53.97 | 54.46 | 52.75 | 53.58 | 151885500 | 53.01
 |  |  |  |  |  |  |  |  |  |  |  |  | 2011-09-21 00:00:00 | 56.65 | 56.93 | 55.37 | 55.38 | 79938000 | 54.79
 |  |  |  |  |  |  |  |  |  |  |  |  | 2011-09-20 00:00:00 | 56.9 | 57.35 | 56.23 | 56.36 | 66570100 | 55.76
 |  |  |  |  |  |  |  |  |  |  |  |  | 2011-09-19 00:00:00 | 55.89 | 56.91 | 55.43 | 56.61 | 73042900 | 56.01
 |  |  |  |  |  |  |  |  |  |  |  |  | 2011-09-16 00:00:00 | 56.2 | 56.65 | 56.09 | 56.59 | 91902100 | 55.99
 |  |  |  |  |  |  |  |  |  |  |  |  | 2011-09-15 00:00:00 | 55.96 | 56.28 | 55.39 | 56.18 | 83536100 | 55.48
 |  |  |  |  |  |  |  |  |  |  |  |  | 2011-09-14 00:00:00 | 54.86 | 55.98 | 54.32 | 55.36 | 90757300 | 54.67
 |  |  |  |  |  |  |  |  |  |  |  |  | 2011-09-13 00:00:00 | 54.06 | 54.69 | 53.8 | 54.58 | 59020000 | 53.9
 |  |  |  |  |  |  |  |  |  |  |  |  | 2011-09-12 00:00:00 | 52.59 | 53.9 | 52.57 | 53.86 | 65973000 | 53.19
 |  |  |  |  |  |  |  |  |  |  |  |  | 2011-09-09 00:00:00 | 54.01 | 54.24 | 52.85 | 53.18 | 63663500 | 52.52
 |  |  |  |  |  |  |  |  |  |  |  |  | 2011-09-08 00:00:00 | 54.36 | 55.17 | 54.21 | 54.39 | 61422800 | 53.71
 |  |  |  |  |  |  |  |  |  |  |  |  | 2011-09-07 00:00:00 | 54.05 | 54.65 | 53.9 | 54.64 | 48952200 | 53.96
 |  |  |  |  |  |  |  |  |  |  |  |  | 2011-09-06 00:00:00 | 52.04 | 53.37 | 51.91 | 53.29 | 52992200 | 52.63
 |  |  |  |  |  |  |  |  |  |  |  |  | 2011-09-02 00:00:00 | 53.58 | 54.61 | 52.99 | 53.28 | 58185700 | 52.62
 |  |  |  |  |  |  |  |  |  |  |  |  | 2011-09-01 00:00:00 | 55.2 | 55.64 | 54.46 | 54.56 | 57158400 | 53.88
 |  |  |  |  |  |  |  |  |  |  |  |  | 2011-08-31 00:00:00 | 55.3 | 55.74 | 54.6 | 55.06 | 60900400 | 54.38
 |  |  |  |  |  |  |  |  |  |  |  |  | 2011-08-30 00:00:00 | 54.41 | 55.3 | 54.11 | 54.97 | 61617900 | 54.29
 |  |  |  |  |  |  |  |  |  |  |  |  | 2011-08-29 00:00:00 | 53.66 | 54.67 | 53.64 | 54.61 | 45985800 | 53.93
 |  |  |  |  |  |  |  |  |  |  |  |  | 2011-08-26 00:00:00 | 51.66 | 53.31 | 51.15 | 53.13 | 91573300 | 52.47
 |  |  |  |  |  |  |  |  |  |  |  | [NAME] sould return Open price, not the day's low | 2011-08-25 00:00:00 | 40 | 52.9 | 39 | 51.83 | 93623700 | 51.19
 |  |  |  |  |  |  |  |  |  |  |  |  | 2011-08-24 00:00:00 | 52.13 | 52.79 | 51.71 | 52.69 | 80197700 | 52.03
 |  |  |  |  |  |  |  |  |  |  |  |  | 2011-08-23 00:00:00 | 50.55 | 52.28 | 50.34 | 52.28 | 75688400 | 51.63
 |  |  |  |  |  |  |  |  |  |  |  |  | 2011-08-22 00:00:00 | 51.23 | 51.24 | 50.06 | 50.21 | 77107700 | 49.59
 |  |  |  |  |  |  |  |  |  |  |  |  | 2011-08-19 00:00:00 | 50.42 | 51.67 | 49.99 | 50.03 | 96674600 | 49.41
 |  |  |  |  |  |  |  |  |  |  |  |  | 2011-08-18 00:00:00 | 52.13 | 52.14 | 50.48 | 50.95 | 130019400 | 50.32
 |  |  |  |  |  |  |  |  |  |  |  |  | 2011-08-17 00:00:00 | 53.97 | 54.42 | 53.02 | 53.58 | 84416600 | 52.91
 |  |  |  |  |  |  |  |  |  |  |  |  | 2011-08-16 00:00:00 | 53.83 | 54.35 | 53.18 | 53.9 | 89219200 | 53.23
 |  |  |  |  |  |  |  |  |  |  |  |  | 2011-08-15 00:00:00 | 53.79 | 54.36 | 53.53 | 54.36 | 73554300 | 53.68
 |  |  |  |  |  |  |  |  |  |  |  |  | 2011-08-12 00:00:00 | 53.43 | 53.9 | 52.88 | 53.57 | 90483300 | 52.9
 |  |  |  |  |  |  |  |  |  |  |  |  | 2011-08-11 00:00:00 | 51.59 | 53.69 | 51.34 | 53.1 | 143825300 | 52.44
 |  |  |  |  |  |  |  |  |  |  |  |  | 2011-08-10 00:00:00 | 51.83 | 53.04 | 50.8 | 50.86 | 205917900 | 50.23
 |  |  |  |  |  |  |  |  |  |  |  |  | 2011-08-09 00:00:00 | 51.35 | 53.08 | 49.93 | 53.03 | 193707100 | 52.37
 |  |  |  |  |  |  |  |  |  |  |  |  | 2011-08-08 00:00:00 | 52.18 | 53.12 | 50.59 | 50.59 | 204804500 | 49.96
 |  |  |  |  |  |  |  |  |  |  |  |  | 2011-08-05 00:00:00 | 54.72 | 55.03 | 52.32 | 53.83 | 214111800 | 53.16
 |  |  |  |  |  |  |  |  |  |  |  |  | 2011-08-04 00:00:00 | 56 | 56.09 | 54.17 | 54.17 | 132830000 | 53.5
 |  |  |  |  |  |  |  |  |  |  |  |  | 2011-08-03 00:00:00 | 56.34 | 56.88 | 55.35 | 56.81 | 103496200 | 56.1
 |  |  |  |  |  |  |  |  |  |  |  |  | 2011-08-02 00:00:00 | 57.46 | 57.72 | 56.21 | 56.27 | 90853300 | 55.57
 |  |  |  |  |  |  |  |  |  |  |  |  | 2011-08-01 00:00:00 | 58.7 | 58.82 | 57.03 | 57.73 | 85421100 | 57.01
 |  |  |  |  |  |  |  |  |  |  |  |  | 2011-07-29 00:00:00 | 57.72 | 58.61 | 57.44 | 58 | 82860500 | 57.28
 |  |  |  |  |  |  |  |  |  |  |  |  | 2011-07-28 00:00:00 | 58.12 | 58.93 | 57.89 | 58.19 | 61031900 | 57.47
 |  |  |  |  |  |  |  |  |  |  |  |  | 2011-07-27 00:00:00 | 59.24 | 59.29 | 57.94 | 58.09 | 83969500 | 57.37
 |  |  |  |  |  |  |  |  |  |  |  |  | 2011-07-26 00:00:00 | 59.44 | 59.83 | 59.32 | 59.63 | 40918900 | 58.89
 |  |  |  |  |  |  |  |  |  |  |  |  | 2011-07-25 00:00:00 | 59.13 | 59.81 | 59.02 | 59.48 | 48916100 | 58.74
 |  |  |  |  |  |  |  |  |  |  |  |  | 2011-07-22 00:00:00 | 58.96 | 59.7 | 58.92 | 59.6 | 43620400 | 58.86
 |  |  |  |  |  |  |  |  |  |  |  |  | 2011-07-21 00:00:00 | 58.66 | 59.32 | 58.34 | 58.99 | 70148800 | 58.26
 |  |  |  |  |  |  |  |  |  |  |  |  | 2011-07-20 00:00:00 | 59.18 | 59.19 | 58.5 | 58.6 | 57085500 | 57.87
 |  |  |  |  |  |  |  |  |  |  |  |  | 2011-07-19 00:00:00 | 58.09 | 58.9 | 58.09 | 58.85 | 73904600 | 58.12
 |  |  |  |  |  |  |  |  |  |  |  |  | 2011-07-18 00:00:00 | 57.53 | 57.79 | 56.98 | 57.54 | 59512200 | 56.82
 |  |  |  |  |  |  |  |  |  |  |  |  | 2011-07-15 00:00:00 | 57.73 | 57.85 | 57.31 | 57.85 | 68281500 | 57.13
 |  |  |  |  |  |  |  |  |  |  |  |  | 2011-07-14 00:00:00 | 57.91 | 58.18 | 56.87 | 57.09 | 98774200 | 56.38
 |  |  |  |  |  |  |  |  |  |  |  |  | 2011-07-13 00:00:00 | 57.94 | 58.34 | 57.55 | 57.76 | 82378100 | 57.04
 |  |  |  |  |  |  |  |  |  |  |  |  | 2011-07-12 00:00:00 | 57.95 | 58.07 | 57.46 | 57.52 | 83958900 | 56.8
 |  |  |  |  |  |  |  |  |  |  |  |  | 2011-07-11 00:00:00 | 58.41 | 58.71 | 57.76 | 57.96 | 52080800 | 57.24
 |  |  |  |  |  |  |  |  |  |  |  |  | 2011-07-08 00:00:00 | 58.68 | 59.04 | 58.37 | 59.03 | 69533600 | 58.3
 |  |  |  |  |  |  |  |  |  |  |  |  | 2011-07-07 00:00:00 | 58.83 | 59.36 | 58.74 | 59.19 | 54799800 | 58.45
 |  |  |  |  |  |  |  |  |  |  |  |  | 2011-07-06 00:00:00 | 58.13 | 58.49 | 57.94 | 58.39 | 49282700 | 57.66
 |  |  |  |  |  |  |  |  |  |  |  |  | 2011-07-05 00:00:00 | 57.97 | 58.26 | 57.83 | 58.2 | 43128800 | 57.48
 |  |  |  |  |  |  |  |  |  |  |  |  | 2011-07-01 00:00:00 | 57.08 | 57.99 | 56.92 | 57.91 | 53203900 | 57.19