How to get the First date the Price was over or below the Average Price?

[Mathman]

Hi

I'm trying to figure out how to get the First date the Price was over or below the Average Price.

The first thing needed is to see if the current price (dec 23,2016) is above or below the average. If the current price is above the average the result should be positive but if the result was current price is below the average the result should be negative.

I need to find (in the example) when the First time (Date) the price was above the current average (as the current price is above the average) the result should be Positive (Dec 23,2016) - First day price was above the average (Dec 19, 2016) =Should Return 4.






[TABLE="width: 130"]
<tbody>[TR]
[TD="width: 65"]Current Average[/TD]
[TD="class: gmail-m_7317369843439429420gmail-xl65, width: 65, align: right"]$23.25[/TD]
[/TR]
[TR]
[TD][/TD]
[TD] Price[/TD]
[/TR]
[TR]
[TD="class: gmail-m_7317369843439429420gmail-xl63, align: right"]23-Dec-16[/TD]
[TD="class: gmail-m_7317369843439429420gmail-xl64, align: right"]$24.22[/TD]
[/TR]
[TR]
[TD="class: gmail-m_7317369843439429420gmail-xl63, align: right"]22-Dec-16[/TD]
[TD="class: gmail-m_7317369843439429420gmail-xl64, align: right"]$24.20[/TD]
[/TR]
[TR]
[TD="class: gmail-m_7317369843439429420gmail-xl63, align: right"]21-Dec-16[/TD]
[TD="class: gmail-m_7317369843439429420gmail-xl64, align: right"]$23.85[/TD]
[/TR]
[TR]
[TD="class: gmail-m_7317369843439429420gmail-xl63, align: right"]20-Dec-16[/TD]
[TD="class: gmail-m_7317369843439429420gmail-xl64, align: right"]$23.90[/TD]
[/TR]
[TR]
[TD="class: gmail-m_7317369843439429420gmail-xl63, align: right"]19-Dec-16[/TD]
[TD="class: gmail-m_7317369843439429420gmail-xl64, align: right"]$23.60[/TD]
[/TR]
[TR]
[TD="class: gmail-m_7317369843439429420gmail-xl63, align: right"]16-Dec-16[/TD]
[TD="class: gmail-m_7317369843439429420gmail-xl64, align: right"]$23.06[/TD]
[/TR]
[TR]
[TD="class: gmail-m_7317369843439429420gmail-xl63, align: right"]15-Dec-16[/TD]
[TD="class: gmail-m_7317369843439429420gmail-xl64, align: right"]$23.43[/TD]
[/TR]
[TR]
[TD="class: gmail-m_7317369843439429420gmail-xl63, align: right"]14-Dec-16[/TD]
[TD="class: gmail-m_7317369843439429420gmail-xl64, align: right"]$23.41[/TD]
[/TR]
[TR]
[TD="class: gmail-m_7317369843439429420gmail-xl63, align: right"]13-Dec-16[/TD]
[TD="class: gmail-m_7317369843439429420gmail-xl64, align: right"]$23.64[/TD]
[/TR]
[TR]
[TD="class: gmail-m_7317369843439429420gmail-xl63, align: right"]12-Dec-16[/TD]
[TD="class: gmail-m_7317369843439429420gmail-xl64, align: right"]$23.53[/TD]
[/TR]
[TR]
[TD="class: gmail-m_7317369843439429420gmail-xl63, align: right"]9-Dec-16[/TD]
[TD="class: gmail-m_7317369843439429420gmail-xl64, align: right"]$23.46[/TD]
[/TR]
[TR]
[TD="class: gmail-m_7317369843439429420gmail-xl63, align: right"]8-Dec-16[/TD]
[TD="class: gmail-m_7317369843439429420gmail-xl64, align: right"]$23.46[/TD]
[/TR]
[TR]
[TD="class: gmail-m_7317369843439429420gmail-xl63, align: right"]7-Dec-16[/TD]
[TD="class: gmail-m_7317369843439429420gmail-xl64, align: right"]$22.99[/TD]
[/TR]
[TR]
[TD="class: gmail-m_7317369843439429420gmail-xl63, align: right"]6-Dec-16[/TD]
[TD="class: gmail-m_7317369843439429420gmail-xl64, align: right"]$22.90[/TD]
[/TR]
[TR]
[TD="class: gmail-m_7317369843439429420gmail-xl63, align: right"]5-Dec-16[/TD]
[TD="class: gmail-m_7317369843439429420gmail-xl64, align: right"]$22.84[/TD]
[/TR]
[TR]
[TD="class: gmail-m_7317369843439429420gmail-xl63, align: right"]2-Dec-16[/TD]
[TD="class: gmail-m_7317369843439429420gmail-xl64, align: right"]$22.64[/TD]
[/TR]
[TR]
[TD="class: gmail-m_7317369843439429420gmail-xl63, align: right"]1-Dec-16[/TD]
[TD="class: gmail-m_7317369843439429420gmail-xl64, align: right"]$22.86[/TD]
[/TR]
[TR]
[TD="class: gmail-m_7317369843439429420gmail-xl63, align: right"]30-Nov-16[/TD]
[TD="class: gmail-m_7317369843439429420gmail-xl64, align: right"]$22.30[/TD]
[/TR]
[TR]
[TD="class: gmail-m_7317369843439429420gmail-xl63, align: right"]29-Nov-16[/TD]
[TD="class: gmail-m_7317369843439429420gmail-xl64, align: right"]$22.54[/TD]
[/TR]
[TR]
[TD="class: gmail-m_7317369843439429420gmail-xl63, align: right"]28-Nov-16[/TD]
[TD="class: gmail-m_7317369843439429420gmail-xl64, align: right"]$22.41[/TD]
[/TR]
[TR]
[TD="class: gmail-m_7317369843439429420gmail-xl63, align: right"]25-Nov-16[/TD]
[TD="class: gmail-m_7317369843439429420gmail-xl64, align: right"]$23.21[/TD]
[/TR]
[TR]
[TD="class: gmail-m_7317369843439429420gmail-xl63, align: right"]23-Nov-16[/TD]
[TD="class: gmail-m_7317369843439429420gmail-xl64, align: right"]$23.08[/TD]
[/TR]
</tbody>[/TABLE]



In this example the result should be a negative number as the Last price (Dec 23, 2016) is below the average. The result should be (Dec 23,2016) - First date below average (Dec 14,2016) results = -9




Average 0.53
23-Dec-16 0.49
22-Dec-16. 0.52
21-Dec-16. 0.52
20-Dec-16. 0.50
19-Dec-16. 0.51
16-Dec-16. 0.52
15-Dec-16. 0.52
14-Dec-16. 0.51
13-Dec-16. 0.53
12-Dec-16. 0.52
9-Dec-16 0.53
8-Dec-16. 0.53
7-Dec-16. 0.54
6-Dec-16. 0.53
5-Dec-16. 0.53
2-Dec-16. 0.51
1-Dec-16. 0.51
30-Nov-16. 0.53
29-Nov-16. 0.53
28-Nov-16. 0.53
25-Nov-16. 0.55
24-Nov-16. 0.54
23-Nov-16. 0.56

If you can help that would be great.

Thank you

 

[Tetra201]

Assuming that:
- Current Average is always in cell B1;
- current date is always in cell A3; and
- current price is always in cell B3,

here is a formula that returns the desired results for the two provided datasets:

=IF(B3=B1,0,IF(B3>B1,A3-MAX(IF(B4:B24<=B1,A3:A23)),MAX(IF(B4:B24>=B1,A3:A23))-A3))

Note: this is an array formula. It should be entered using Ctrl+Shift+Enter, not just Enter.

 

[Mathman]

for some reason I keep getting 0 as a result.....

 

[svendiamond]

Did you use CTRL+SHIFT+ENTER to enter the formula?

 

[Mathman]

Yes I did. trying to go threw it but I seem to be missing something

 

[AliGW]

Does the real data have blank rows between entries???

 

[Tetra201]

for some reason I keep getting 0 as a result.....

If your data are positioned correctly, the suggested formula returns 0 when either:
- B1=B3, or
- B3 is a text string.

 

[Mathman]

I was able to run a test after getting it going and I made a few observations.

1- The result is always 1 day off. Example if today was the most recent first day the price crossed over the average from the previous day when the price was below the average the formulae returns 0 when I would prefer it to be 1 and the opposite is true if the price is below the average.


2- The second which was odd to me was that out of 50 tests about 10 where off by 3 days and 2 where off by 5 and 1 was just off. Not only was it off but if it was, it was most likely off by the same consistent amount.


One concern I have is that it's a array formula. Given that I will use this thousands of times thought a worksheet I'm worried mistakes on my end can happen.


All my averages/ mins/max with dates have been constructed using DSUM functions. Example below.


Would their be a way to get the results working with this set up? I'm not a concerned if it takes a few separate steps to get the data as much as I would prefer to have only a cut and paste to do rather then worry I pasted an array and missed set-in it up improperly.


Thanks Tetra201 for helping me out on this one.





[TABLE="width: 174"]
<colgroup><col width="87" span="2" style="width: 65pt;"></colgroup><tbody>[TR]
[TD="class: gmail-xl64, width: 87"]Average[/TD]
[TD="class: gmail-xl65, width: 87, align: right"] $3.73 [/TD]
[/TR]
[TR]
[TD="class: gmail-xl63"][/TD]
[TD="class: gmail-xl63"][/TD]
[/TR]
[TR]
[TD="class: gmail-xl64"]Date[/TD]
[TD="class: gmail-xl64"]Pice[/TD]
[/TR]
[TR]
[TD="class: gmail-xl66, align: right"]23-Jan-17[/TD]
[TD="class: gmail-xl65, align: right"] $4.20 [/TD]
[/TR]
[TR]
[TD="class: gmail-xl66, align: right"]20-Jan-17[/TD]
[TD="class: gmail-xl65, align: right"] $4.13 [/TD]
[/TR]
[TR]
[TD="class: gmail-xl66, align: right"]19-Jan-17[/TD]
[TD="class: gmail-xl65, align: right"] $4.03 [/TD]
[/TR]
[TR]
[TD="class: gmail-xl66, align: right"]18-Jan-17[/TD]
[TD="class: gmail-xl65, align: right"] $3.90 [/TD]
[/TR]
[TR]
[TD="class: gmail-xl66, align: right"]17-Jan-17[/TD]
[TD="class: gmail-xl65, align: right"] $3.80 [/TD]
[/TR]
[TR]
[TD="class: gmail-xl66, align: right"]13-Jan-17[/TD]
[TD="class: gmail-xl65, align: right"] $3.90 [/TD]
[/TR]
[TR]
[TD="class: gmail-xl66, align: right"]12-Jan-17[/TD]
[TD="class: gmail-xl65, align: right"] $4.09 [/TD]
[/TR]
[TR]
[TD="class: gmail-xl66, align: right"]11-Jan-17[/TD]
[TD="class: gmail-xl65, align: right"] $3.76 [/TD]
[/TR]
[TR]
[TD="class: gmail-xl66, align: right"]10-Jan-17[/TD]
[TD="class: gmail-xl65, align: right"] $3.74 [/TD]
[/TR]
[TR]
[TD="class: gmail-xl66, align: right"]9-Jan-17[/TD]
[TD="class: gmail-xl65, align: right"] $3.85 [/TD]
[/TR]
[TR]
[TD="class: gmail-xl66, align: right"]6-Jan-17[/TD]
[TD="class: gmail-xl65, align: right"] $3.71 [/TD]
[/TR]
[TR]
[TD="class: gmail-xl66, align: right"]5-Jan-17[/TD]
[TD="class: gmail-xl65, align: right"] $3.98 [/TD]
[/TR]
[TR]
[TD="class: gmail-xl66, align: right"]4-Jan-17[/TD]
[TD="class: gmail-xl65, align: right"] $3.71 [/TD]
[/TR]
[TR]
[TD="class: gmail-xl66, align: right"]3-Jan-17[/TD]
[TD="class: gmail-xl65, align: right"] $3.38 [/TD]
[/TR]
[TR]
[TD="class: gmail-xl66, align: right"]30-Dec-16[/TD]
[TD="class: gmail-xl65, align: right"] $3.14 [/TD]
[/TR]
[TR]
[TD="class: gmail-xl66, align: right"]29-Dec-16[/TD]
[TD="class: gmail-xl65, align: right"] $3.24 [/TD]
[/TR]
[TR]
[TD="class: gmail-xl66, align: right"]28-Dec-16[/TD]
[TD="class: gmail-xl65, align: right"] $3.44 [/TD]
[/TR]
[TR]
[TD="class: gmail-xl66, align: right"]27-Dec-16[/TD]
[TD="class: gmail-xl65, align: right"] $3.46 [/TD]
[/TR]
[TR]
[TD="class: gmail-xl66, align: right"]23-Dec-16[/TD]
[TD="class: gmail-xl65, align: right"] $3.50 [/TD]
[/TR]
[TR]
[TD="class: gmail-xl66, align: right"]22-Dec-16[/TD]
[TD="class: gmail-xl65, align: right"] $3.57 [/TD]
[/TR]
[TR]
[TD="class: gmail-xl63"][/TD]
[TD="class: gmail-xl63"][/TD]
[/TR]
[TR]
[TD="class: gmail-xl67"]22-Dec-16[/TD]
[TD="class: gmail-xl68"]23-Jan-17[/TD]
[/TR]
[TR]
[TD="class: gmail-xl64"]Date[/TD]
[TD="class: gmail-xl64"]Date[/TD]
[/TR]
[TR]
[TD="class: gmail-xl69"]>=42726[/TD]
[TD="class: gmail-xl69"]<=42758[/TD]
[/TR]
</tbody>[/TABLE]

 

[Tetra201]

... 1- The result is always 1 day off. Example if today was the most recent first day the price crossed over the average from the previous day when the price was below the average the formulae returns 0 when I would prefer it to be 1 and the opposite is true if the price is below the average.

The suggested formula returns the expected results for the two datasets from Post #1. So, it's not "always." If you want 1 or -1 for today's date, then the requested results for the datasets from Post #1 should have been 5 and -10, not 4 and -9. You decide.

... 2- The second which was odd to me was that out of 50 tests about 10 where off by 3 days and 2 where off by 5 and 1 was just off. Not only was it off but if it was, it was most likely off by the same consistent amount.

The best approach would be to post some examples where the results are supposedly off and show the desired outcomes.

... I would prefer to have only a cut and paste to do rather then worry I pasted an array and missed set-in it up improperly.

Here is another, less compact formula. It's also an array formula. You only need to make sure B1, B3, and A3 are set correctly (see Post #2 for the descriptions). The upper boundaries (currently, A1000 and B1000) can be set to A100 and B100, or A11111 and B11111, or whatever suits you.

=IF(B3=B1,0,IF(B3>B1,A3-INDEX(A3:A1000,MATCH(FALSE,B3:B1000>B1,0)-1),INDEX(A3:A1000,MATCH(FALSE,B3:B1000< B1,0)-1)-A3))<b1,0)-1)-a3))< html=""></b1,0)-1)-a3))<>

 

[Mathman]

[FONT=arial, sans-serif]You are correct, I was off by one on my initial post, my apologies. Here are some of the results I got and what the the results should be. Both formula did return the same results.
[/FONT]

Thank you.




Should be -1
[TABLE="width: 174"]
<colgroup><col width="87" span="2" style="width: 65pt;"></colgroup><tbody>[TR]
[TD="class: gmail-xl64, width: 87"][/TD]
[TD="class: gmail-xl65, width: 87, align: right"] $0.493 [/TD]
[/TR]
[TR]
[TD="class: gmail-xl63"][/TD]
[TD="class: gmail-xl63, align: right"]0[/TD]
[/TR]
[TR]
[TD="class: gmail-xl66, align: right"]23-Jan-17[/TD]
[TD="class: gmail-xl67, align: right"] $0.490 [/TD]
[/TR]
[TR]
[TD="class: gmail-xl66, align: right"]20-Jan-17[/TD]
[TD="class: gmail-xl67, align: right"] $0.500 [/TD]
[/TR]
[TR]
[TD="class: gmail-xl66, align: right"]19-Jan-17[/TD]
[TD="class: gmail-xl67, align: right"] $0.480 [/TD]
[/TR]
[TR]
[TD="class: gmail-xl66, align: right"]18-Jan-17[/TD]
[TD="class: gmail-xl67, align: right"] $0.480 [/TD]
[/TR]
[TR]
[TD="class: gmail-xl66, align: right"]17-Jan-17[/TD]
[TD="class: gmail-xl67, align: right"] $0.480 [/TD]
[/TR]
[TR]
[TD="class: gmail-xl66, align: right"]16-Jan-17[/TD]
[TD="class: gmail-xl67, align: right"] $0.480 [/TD]
[/TR]
[TR]
[TD="class: gmail-xl66, align: right"]13-Jan-17[/TD]
[TD="class: gmail-xl67, align: right"] $0.480 [/TD]
[/TR]
[TR]
[TD="class: gmail-xl66, align: right"]12-Jan-17[/TD]
[TD="class: gmail-xl67, align: right"] $0.480 [/TD]
[/TR]
[TR]
[TD="class: gmail-xl66, align: right"]11-Jan-17[/TD]
[TD="class: gmail-xl67, align: right"] $0.480 [/TD]
[/TR]
[TR]
[TD="class: gmail-xl66, align: right"]10-Jan-17[/TD]
[TD="class: gmail-xl67, align: right"] $0.500 [/TD]
[/TR]
[TR]
[TD="class: gmail-xl66, align: right"]9-Jan-17[/TD]
[TD="class: gmail-xl67, align: right"] $0.520 [/TD]
[/TR]
[TR]
[TD="class: gmail-xl66, align: right"]6-Jan-17[/TD]
[TD="class: gmail-xl67, align: right"] $0.500 [/TD]
[/TR]
[TR]
[TD="class: gmail-xl66, align: right"]5-Jan-17[/TD]
[TD="class: gmail-xl67, align: right"] $0.500 [/TD]
[/TR]
[TR]
[TD="class: gmail-xl66, align: right"]4-Jan-17[/TD]
[TD="class: gmail-xl67, align: right"] $0.500 [/TD]
[/TR]
[TR]
[TD="class: gmail-xl66, align: right"]3-Jan-17[/TD]
[TD="class: gmail-xl67, align: right"] $0.490 [/TD]
[/TR]
[TR]
[TD="class: gmail-xl66, align: right"]30-Dec-16[/TD]
[TD="class: gmail-xl67, align: right"] $0.520 [/TD]
[/TR]
[TR]
[TD="class: gmail-xl66, align: right"]29-Dec-16[/TD]
[TD="class: gmail-xl67, align: right"] $0.500 [/TD]
[/TR]
[TR]
[TD="class: gmail-xl66, align: right"]28-Dec-16[/TD]
[TD="class: gmail-xl67, align: right"] $0.500 [/TD]
[/TR]
[TR]
[TD="class: gmail-xl66, align: right"]23-Dec-16[/TD]
[TD="class: gmail-xl67, align: right"] $0.490 [/TD]
[/TR]
</tbody>[/TABLE]





[TABLE="width: 174"]
<colgroup><col width="87" span="2" style="width: 65pt;"></colgroup><tbody>[TR]
[TD="class: gmail-xl64, width: 87"]Should be 1[/TD]
[TD="class: gmail-xl65, width: 87, align: right"] $6.103 [/TD]
[/TR]
[TR]
[TD="class: gmail-xl63"][/TD]
[TD="class: gmail-xl63, align: right"]0[/TD]
[/TR]
[TR]
[TD="class: gmail-xl66, align: right"]23-Jan-17[/TD]
[TD="class: gmail-xl67, align: right"] $6.200 [/TD]
[/TR]
[TR]
[TD="class: gmail-xl66, align: right"]20-Jan-17[/TD]
[TD="class: gmail-xl67, align: right"] $6.070 [/TD]
[/TR]
[TR]
[TD="class: gmail-xl66, align: right"]19-Jan-17[/TD]
[TD="class: gmail-xl67, align: right"] $6.060 [/TD]
[/TR]
[TR]
[TD="class: gmail-xl66, align: right"]18-Jan-17[/TD]
[TD="class: gmail-xl67, align: right"] $6.070 [/TD]
[/TR]
[TR]
[TD="class: gmail-xl66, align: right"]17-Jan-17[/TD]
[TD="class: gmail-xl67, align: right"] $6.170 [/TD]
[/TR]
[TR]
[TD="class: gmail-xl66, align: right"]16-Jan-17[/TD]
[TD="class: gmail-xl67, align: right"] $6.320 [/TD]
[/TR]
[TR]
[TD="class: gmail-xl66, align: right"]13-Jan-17[/TD]
[TD="class: gmail-xl67, align: right"] $6.200 [/TD]
[/TR]
[TR]
[TD="class: gmail-xl66, align: right"]12-Jan-17[/TD]
[TD="class: gmail-xl67, align: right"] $6.260 [/TD]
[/TR]
[TR]
[TD="class: gmail-xl66, align: right"]11-Jan-17[/TD]
[TD="class: gmail-xl67, align: right"] $6.200 [/TD]
[/TR]
[TR]
[TD="class: gmail-xl66, align: right"]10-Jan-17[/TD]
[TD="class: gmail-xl67, align: right"] $6.270 [/TD]
[/TR]
[TR]
[TD="class: gmail-xl66, align: right"]9-Jan-17[/TD]
[TD="class: gmail-xl67, align: right"] $6.250 [/TD]
[/TR]
[TR]
[TD="class: gmail-xl66, align: right"]6-Jan-17[/TD]
[TD="class: gmail-xl67, align: right"] $6.210 [/TD]
[/TR]
[TR]
[TD="class: gmail-xl66, align: right"]5-Jan-17[/TD]
[TD="class: gmail-xl67, align: right"] $6.470 [/TD]
[/TR]
[TR]
[TD="class: gmail-xl66, align: right"]4-Jan-17[/TD]
[TD="class: gmail-xl67, align: right"] $5.880 [/TD]
[/TR]
[TR]
[TD="class: gmail-xl66, align: right"]3-Jan-17[/TD]
[TD="class: gmail-xl67, align: right"] $5.880 [/TD]
[/TR]
[TR]
[TD="class: gmail-xl66, align: right"]30-Dec-16[/TD]
[TD="class: gmail-xl67, align: right"] $5.830 [/TD]
[/TR]
[TR]
[TD="class: gmail-xl66, align: right"]29-Dec-16[/TD]
[TD="class: gmail-xl67, align: right"] $5.830 [/TD]
[/TR]
[TR]
[TD="class: gmail-xl66, align: right"]28-Dec-16[/TD]
[TD="class: gmail-xl67, align: right"] $5.850 [/TD]
[/TR]
[TR]
[TD="class: gmail-xl66, align: right"]23-Dec-16[/TD]
[TD="class: gmail-xl67, align: right"] $5.940 [/TD]
[/TR]
</tbody>[/TABLE]



Here is an example were the result should have been -9


[TABLE="width: 174"]
<colgroup><col width="87" span="2" style="width: 65pt;"></colgroup><tbody>[TR]
[TD="class: gmail-xl64, width: 87"][/TD]
[TD="class: gmail-xl65, width: 87, align: right"] $26.484 [/TD]
[/TR]
[TR]
[TD="class: gmail-xl63"][/TD]
[TD="class: gmail-xl63, align: right"]-12[/TD]
[/TR]
[TR]
[TD="class: gmail-xl66, align: right"]23-Jan-17[/TD]
[TD="class: gmail-xl67, align: right"] $26.190 [/TD]
[/TR]
[TR]
[TD="class: gmail-xl66, align: right"]20-Jan-17[/TD]
[TD="class: gmail-xl67, align: right"] $26.210 [/TD]
[/TR]
[TR]
[TD="class: gmail-xl66, align: right"]19-Jan-17[/TD]
[TD="class: gmail-xl67, align: right"] $26.130 [/TD]
[/TR]
[TR]
[TD="class: gmail-xl66, align: right"]18-Jan-17[/TD]
[TD="class: gmail-xl67, align: right"] $26.110 [/TD]
[/TR]
[TR]
[TD="class: gmail-xl66, align: right"]17-Jan-17[/TD]
[TD="class: gmail-xl67, align: right"] $26.280 [/TD]
[/TR]
[TR]
[TD="class: gmail-xl66, align: right"]16-Jan-17[/TD]
[TD="class: gmail-xl67, align: right"] $26.340 [/TD]
[/TR]
[TR]
[TD="class: gmail-xl66, align: right"]13-Jan-17[/TD]
[TD="class: gmail-xl67, align: right"] $26.310 [/TD]
[/TR]
[TR]
[TD="class: gmail-xl66, align: right"]12-Jan-17[/TD]
[TD="class: gmail-xl67, align: right"] $26.230 [/TD]
[/TR]
[TR]
[TD="class: gmail-xl66, align: right"]11-Jan-17[/TD]
[TD="class: gmail-xl67, align: right"] $26.400 [/TD]
[/TR]
[TR]
[TD="class: gmail-xl66, align: right"]10-Jan-17[/TD]
[TD="class: gmail-xl67, align: right"] $26.810 [/TD]
[/TR]
[TR]
[TD="class: gmail-xl66, align: right"]9-Jan-17[/TD]
[TD="class: gmail-xl67, align: right"] $26.970 [/TD]
[/TR]
[TR]
[TD="class: gmail-xl66, align: right"]6-Jan-17[/TD]
[TD="class: gmail-xl67, bgcolor: #FFC7CE, align: right"] $27.080 [/TD]
[/TR]
[TR]
[TD="class: gmail-xl66, align: right"]5-Jan-17[/TD]
[TD="class: gmail-xl67, align: right"] $26.980 [/TD]
[/TR]
[TR]
[TD="class: gmail-xl66, align: right"]4-Jan-17[/TD]
[TD="class: gmail-xl67, align: right"] $26.840 [/TD]
[/TR]
[TR]
[TD="class: gmail-xl66, align: right"]3-Jan-17[/TD]
[TD="class: gmail-xl67, align: right"] $26.530 [/TD]
[/TR]
[TR]
[TD="class: gmail-xl66, align: right"]30-Dec-16[/TD]
[TD="class: gmail-xl67, align: right"] $26.630 [/TD]
[/TR]
[TR]
[TD="class: gmail-xl66, align: right"]29-Dec-16[/TD]
[TD="class: gmail-xl67, align: right"] $26.570 [/TD]
[/TR]
[TR]
[TD="class: gmail-xl66, align: right"]28-Dec-16[/TD]
[TD="class: gmail-xl67, align: right"] $26.200 [/TD]
[/TR]
[TR]
[TD="class: gmail-xl66, align: right"]23-Dec-16[/TD]
[TD="class: gmail-xl67, align: right"] $26.380 [/TD]
[/TR]
</tbody>[/TABLE]






Should be -7
[TABLE="width: 174"]
<colgroup><col width="87" span="2" style="width: 65pt;"></colgroup><tbody>[TR]
[TD="class: gmail-xl64, width: 87"][/TD]
[TD="class: gmail-xl65, width: 87, align: right"] $1.238 [/TD]
[/TR]
[TR]
[TD="class: gmail-xl63"][/TD]
[TD="class: gmail-xl63, align: right"]-10[/TD]
[/TR]
[TR]
[TD="class: gmail-xl66, align: right"]23-Jan-17[/TD]
[TD="class: gmail-xl67, align: right"] $1.170 [/TD]
[/TR]
[TR]
[TD="class: gmail-xl66, align: right"]20-Jan-17[/TD]
[TD="class: gmail-xl67, align: right"] $1.210 [/TD]
[/TR]
[TR]
[TD="class: gmail-xl66, align: right"]19-Jan-17[/TD]
[TD="class: gmail-xl67, align: right"] $1.160 [/TD]
[/TR]
[TR]
[TD="class: gmail-xl66, align: right"]18-Jan-17[/TD]
[TD="class: gmail-xl67, align: right"] $1.150 [/TD]
[/TR]
[TR]
[TD="class: gmail-xl66, align: right"]17-Jan-17[/TD]
[TD="class: gmail-xl67, align: right"] $1.210 [/TD]
[/TR]
[TR]
[TD="class: gmail-xl66, align: right"]16-Jan-17[/TD]
[TD="class: gmail-xl67, align: right"] $1.220 [/TD]
[/TR]
[TR]
[TD="class: gmail-xl66, align: right"]13-Jan-17[/TD]
[TD="class: gmail-xl67, align: right"] $1.230 [/TD]
[/TR]
[TR]
[TD="class: gmail-xl66, align: right"]12-Jan-17[/TD]
[TD="class: gmail-xl67, align: right"] $1.260 [/TD]
[/TR]
[TR]
[TD="class: gmail-xl66, align: right"]11-Jan-17[/TD]
[TD="class: gmail-xl67, align: right"] $1.220 [/TD]
[/TR]
[TR]
[TD="class: gmail-xl66, align: right"]10-Jan-17[/TD]
[TD="class: gmail-xl67, bgcolor: #FFC7CE, align: right"] $1.210 [/TD]
[/TR]
[TR]
[TD="class: gmail-xl66, align: right"]9-Jan-17[/TD]
[TD="class: gmail-xl67, align: right"] $1.230 [/TD]
[/TR]
[TR]
[TD="class: gmail-xl66, align: right"]6-Jan-17[/TD]
[TD="class: gmail-xl67, align: right"] $1.280 [/TD]
[/TR]
[TR]
[TD="class: gmail-xl66, align: right"]5-Jan-17[/TD]
[TD="class: gmail-xl67, align: right"] $1.280 [/TD]
[/TR]
[TR]
[TD="class: gmail-xl66, align: right"]4-Jan-17[/TD]
[TD="class: gmail-xl67, align: right"] $1.280 [/TD]
[/TR]
[TR]
[TD="class: gmail-xl66, align: right"]3-Jan-17[/TD]
[TD="class: gmail-xl67, align: right"] $1.290 [/TD]
[/TR]
[TR]
[TD="class: gmail-xl66, align: right"]30-Dec-16[/TD]
[TD="class: gmail-xl67, align: right"] $1.280 [/TD]
[/TR]
[TR]
[TD="class: gmail-xl66, align: right"]29-Dec-16[/TD]
[TD="class: gmail-xl67, align: right"] $1.280 [/TD]
[/TR]
[TR]
[TD="class: gmail-xl66, align: right"]28-Dec-16[/TD]
[TD="class: gmail-xl67, align: right"] $1.280 [/TD]
[/TR]
[TR]
[TD="class: gmail-xl66, align: right"]23-Dec-16[/TD]
[TD="class: gmail-xl67, align: right"] $1.280 [/TD]
[/TR]
</tbody>[/TABLE]




Should be 8
[TABLE="width: 174"]
<colgroup><col width="87" span="2" style="width: 65pt;"></colgroup><tbody>[TR]
[TD="class: gmail-xl64, width: 87"][/TD]
[TD="class: gmail-xl65, width: 87, align: right"] $7.447 [/TD]
[/TR]
[TR]
[TD="class: gmail-xl63"][/TD]
[TD="class: gmail-xl63, align: right"]11[/TD]
[/TR]
[TR]
[TD="class: gmail-xl66, align: right"]23-Jan-17[/TD]
[TD="class: gmail-xl67, align: right"] $7.530 [/TD]
[/TR]
[TR]
[TD="class: gmail-xl66, align: right"]20-Jan-17[/TD]
[TD="class: gmail-xl67, align: right"] $7.530 [/TD]
[/TR]
[TR]
[TD="class: gmail-xl66, align: right"]19-Jan-17[/TD]
[TD="class: gmail-xl67, align: right"] $7.590 [/TD]
[/TR]
[TR]
[TD="class: gmail-xl66, align: right"]18-Jan-17[/TD]
[TD="class: gmail-xl67, align: right"] $7.450 [/TD]
[/TR]
[TR]
[TD="class: gmail-xl66, align: right"]17-Jan-17[/TD]
[TD="class: gmail-xl67, align: right"] $7.550 [/TD]
[/TR]
[TR]
[TD="class: gmail-xl66, align: right"]16-Jan-17[/TD]
[TD="class: gmail-xl67, align: right"] $7.620 [/TD]
[/TR]
[TR]
[TD="class: gmail-xl66, align: right"]13-Jan-17[/TD]
[TD="class: gmail-xl67, align: right"] $7.680 [/TD]
[/TR]
[TR]
[TD="class: gmail-xl66, align: right"]12-Jan-17[/TD]
[TD="class: gmail-xl67, align: right"] $7.730 [/TD]
[/TR]
[TR]
[TD="class: gmail-xl66, align: right"]11-Jan-17[/TD]
[TD="class: gmail-xl67, align: right"] $7.350 [/TD]
[/TR]
[TR]
[TD="class: gmail-xl66, align: right"]10-Jan-17[/TD]
[TD="class: gmail-xl67, align: right"] $7.590 [/TD]
[/TR]
[TR]
[TD="class: gmail-xl66, align: right"]9-Jan-17[/TD]
[TD="class: gmail-xl67, bgcolor: #FFC7CE, align: right"] $7.310 [/TD]
[/TR]
[TR]
[TD="class: gmail-xl66, align: right"]6-Jan-17[/TD]
[TD="class: gmail-xl67, align: right"] $7.550 [/TD]
[/TR]
[TR]
[TD="class: gmail-xl66, align: right"]5-Jan-17[/TD]
[TD="class: gmail-xl67, align: right"] $7.880 [/TD]
[/TR]
[TR]
[TD="class: gmail-xl66, align: right"]4-Jan-17[/TD]
[TD="class: gmail-xl67, align: right"] $7.430 [/TD]
[/TR]
[TR]
[TD="class: gmail-xl66, align: right"]3-Jan-17[/TD]
[TD="class: gmail-xl67, align: right"] $7.280 [/TD]
[/TR]
[TR]
[TD="class: gmail-xl66, align: right"]30-Dec-16[/TD]
[TD="class: gmail-xl67, align: right"] $7.020 [/TD]
[/TR]
[TR]
[TD="class: gmail-xl66, align: right"]29-Dec-16[/TD]
[TD="class: gmail-xl67, align: right"] $7.160 [/TD]
[/TR]
[TR]
[TD="class: gmail-xl66, align: right"]28-Dec-16[/TD]
[TD="class: gmail-xl67, align: right"] $7.150 [/TD]
[/TR]
[TR]
[TD="class: gmail-xl66, align: right"]23-Dec-16[/TD]
[TD="class: gmail-xl67, align: right"] $7.090 [/TD]
[/TR]
</tbody>[/TABLE]




This one should be 13


[TABLE="width: 174"]
<colgroup><col width="87" span="2" style="width: 65pt;"></colgroup><tbody>[TR]
[TD="class: gmail-xl64, width: 87"][/TD]
[TD="class: gmail-xl65, width: 87, align: right"] $2.369 [/TD]
[/TR]
[TR]
[TD="class: gmail-xl63"][/TD]
[TD="class: gmail-xl63, align: right"]18[/TD]
[/TR]
[TR]
[TD="class: gmail-xl66, align: right"]23-Jan-17[/TD]
[TD="class: gmail-xl67, align: right"] $2.430 [/TD]
[/TR]
[TR]
[TD="class: gmail-xl66, align: right"]20-Jan-17[/TD]
[TD="class: gmail-xl67, align: right"] $2.440 [/TD]
[/TR]
[TR]
[TD="class: gmail-xl66, align: right"]19-Jan-17[/TD]
[TD="class: gmail-xl67, align: right"] $2.470 [/TD]
[/TR]
[TR]
[TD="class: gmail-xl66, align: right"]18-Jan-17[/TD]
[TD="class: gmail-xl67, align: right"] $2.480 [/TD]
[/TR]
[TR]
[TD="class: gmail-xl66, align: right"]17-Jan-17[/TD]
[TD="class: gmail-xl67, align: right"] $2.490 [/TD]
[/TR]
[TR]
[TD="class: gmail-xl66, align: right"]16-Jan-17[/TD]
[TD="class: gmail-xl67, align: right"] $2.410 [/TD]
[/TR]
[TR]
[TD="class: gmail-xl66, align: right"]13-Jan-17[/TD]
[TD="class: gmail-xl67, align: right"] $2.430 [/TD]
[/TR]
[TR]
[TD="class: gmail-xl66, align: right"]12-Jan-17[/TD]
[TD="class: gmail-xl67, align: right"] $2.380 [/TD]
[/TR]
[TR]
[TD="class: gmail-xl66, align: right"]11-Jan-17[/TD]
[TD="class: gmail-xl67, align: right"] $2.430 [/TD]
[/TR]
[TR]
[TD="class: gmail-xl66, align: right"]10-Jan-17[/TD]
[TD="class: gmail-xl67, align: right"] $2.440 [/TD]
[/TR]
[TR]
[TD="class: gmail-xl66, align: right"]9-Jan-17[/TD]
[TD="class: gmail-xl67, align: right"] $2.440 [/TD]
[/TR]
[TR]
[TD="class: gmail-xl66, align: right"]6-Jan-17[/TD]
[TD="class: gmail-xl67, align: right"] $2.380 [/TD]
[/TR]
[TR]
[TD="class: gmail-xl66, align: right"]5-Jan-17[/TD]
[TD="class: gmail-xl67, align: right"] $2.510 [/TD]
[/TR]
[TR]
[TD="class: gmail-xl66, align: right"]4-Jan-17[/TD]
[TD="class: gmail-xl67, align: right"] $2.350 [/TD]
[/TR]
[TR]
[TD="class: gmail-xl66, align: right"]3-Jan-17[/TD]
[TD="class: gmail-xl67, align: right"] $2.350 [/TD]
[/TR]
[TR]
[TD="class: gmail-xl66, align: right"]30-Dec-16[/TD]
[TD="class: gmail-xl67, align: right"] $2.240 [/TD]
[/TR]
[TR]
[TD="class: gmail-xl66, align: right"]29-Dec-16[/TD]
[TD="class: gmail-xl67, align: right"] $2.230 [/TD]
[/TR]
[TR]
[TD="class: gmail-xl66, align: right"]28-Dec-16[/TD]
[TD="class: gmail-xl67, bgcolor: #FFC7CE, align: right"] $2.110 [/TD]
[/TR]
[TR]
[TD="class: gmail-xl66, align: right"]23-Dec-16[/TD]
[TD="class: gmail-xl67, align: right"] $2.000 [/TD]
[/TR]
</tbody>[/TABLE]


[TABLE="width: 174"]
<colgroup><col width="87" span="2" style="width: 65pt;"></colgroup><tbody>[TR]
[TD="class: gmail-xl64, width: 87"]Should be 12



[/TD]
[TD="class: gmail-xl65, width: 87, align: right"] $7.200 [/TD]
[/TR]
[TR]
[TD="class: gmail-xl63"][/TD]
[TD="class: gmail-xl63, align: right"]17[/TD]
[/TR]
[TR]
[TD="class: gmail-xl66, align: right"]23-Jan-17[/TD]
[TD="class: gmail-xl67, align: right"] $7.750 [/TD]
[/TR]
[TR]
[TD="class: gmail-xl66, align: right"]20-Jan-17[/TD]
[TD="class: gmail-xl67, align: right"] $7.650 [/TD]
[/TR]
[TR]
[TD="class: gmail-xl66, align: right"]19-Jan-17[/TD]
[TD="class: gmail-xl67, align: right"] $7.550 [/TD]
[/TR]
[TR]
[TD="class: gmail-xl66, align: right"]18-Jan-17[/TD]
[TD="class: gmail-xl67, align: right"] $7.600 [/TD]
[/TR]
[TR]
[TD="class: gmail-xl66, align: right"]17-Jan-17[/TD]
[TD="class: gmail-xl67, align: right"] $8.000 [/TD]
[/TR]
[TR]
[TD="class: gmail-xl66, align: right"]16-Jan-17[/TD]
[TD="class: gmail-xl67, align: right"] $7.550 [/TD]
[/TR]
[TR]
[TD="class: gmail-xl66, align: right"]13-Jan-17[/TD]
[TD="class: gmail-xl67, align: right"] $7.500 [/TD]
[/TR]
[TR]
[TD="class: gmail-xl66, align: right"]12-Jan-17[/TD]
[TD="class: gmail-xl67, align: right"] $7.550 [/TD]
[/TR]
[TR]
[TD="class: gmail-xl66, align: right"]11-Jan-17[/TD]
[TD="class: gmail-xl67, align: right"] $7.700 [/TD]
[/TR]
[TR]
[TD="class: gmail-xl66, align: right"]10-Jan-17[/TD]
[TD="class: gmail-xl67, align: right"] $7.600 [/TD]
[/TR]
[TR]
[TD="class: gmail-xl66, align: right"]9-Jan-17[/TD]
[TD="class: gmail-xl67, align: right"] $7.400 [/TD]
[/TR]
[TR]
[TD="class: gmail-xl66, align: right"]6-Jan-17[/TD]
[TD="class: gmail-xl67, align: right"] $7.800 [/TD]
[/TR]
[TR]
[TD="class: gmail-xl66, align: right"]5-Jan-17[/TD]
[TD="class: gmail-xl67, align: right"] $7.000 [/TD]
[/TR]
[TR]
[TD="class: gmail-xl66, align: right"]4-Jan-17[/TD]
[TD="class: gmail-xl67, align: right"] $6.950 [/TD]
[/TR]
[TR]
[TD="class: gmail-xl66, align: right"]3-Jan-17[/TD]
[TD="class: gmail-xl67, align: right"] $6.500 [/TD]
[/TR]
[TR]
[TD="class: gmail-xl66, align: right"]30-Dec-16[/TD]
[TD="class: gmail-xl67, align: right"] $6.950 [/TD]
[/TR]
[TR]
[TD="class: gmail-xl66, align: right"]29-Dec-16[/TD]
[TD="class: gmail-xl67, bgcolor: #FFC7CE, align: right"] $6.100 [/TD]
[/TR]
[TR]
[TD="class: gmail-xl66, align: right"]28-Dec-16[/TD]
[TD="class: gmail-xl67, align: right"] $6.000 [/TD]
[/TR]
[TR]
[TD="class: gmail-xl66, align: right"]23-Dec-16[/TD]
[TD="class: gmail-xl67, align: right"] $5.650 [/TD]
[/TR]
</tbody>[/TABLE]