Good morning! I'm currently looking for help on a problem I've been facing in Excel. I'm trying to process a massive amount of data. To be specific, I'm referencing 17,352,100 rows. Fortunately, I don't plan on processing or working with all of them at once. I'm running sales data for different items. Each item has a daily sales amount. This means each item gets 365 rows just to itself. I'm looking to calculate everything down to thirteen four-week periods. I'm looking for a formula (or other solution) that will look at each item, pick out the four weeks worth of dates, and total the sales amounts for each day.
My plan is to set something up so that I can process about 500 items at a time, copy/paste the results, wash, rinse, and repeat. This will also be something that in the future, I can hopefully just alter the dates and use again. I can only think of formulas that are too long to create. Any help anyone can offer would be great.
Below, I have copied a sample of two codes. I need to break down the sales days into four week intervals. The first interval would be 10/08/14 to 11/07/14. If you have any questions or need any additional clarification, please let me know.
<tbody>
[TD="class: xl68"][TABLE="width: 248"]
<tbody>[TR]
</tbody>[/TD]
[TD="class: xl64, width: 71"][/TD]
[TD="class: xl64, width: 57"][/TD]
[/TR]
</tbody>[/TABLE]
My plan is to set something up so that I can process about 500 items at a time, copy/paste the results, wash, rinse, and repeat. This will also be something that in the future, I can hopefully just alter the dates and use again. I can only think of formulas that are too long to create. Any help anyone can offer would be great.
Below, I have copied a sample of two codes. I need to break down the sales days into four week intervals. The first interval would be 10/08/14 to 11/07/14. If you have any questions or need any additional clarification, please let me know.
Code | Sales Day | Dollars | Units |
1 | 10/8/2014 | $363.00 | 121.00 |
1 | 10/9/2014 | $312.00 | 104.00 |
1 | 10/10/2014 | $360.00 | 120.00 |
1 | 10/11/2014 | $453.00 | 151.00 |
1 | 10/12/2014 | $585.00 | 195.00 |
1 | 10/13/2014 | $411.00 | 137.00 |
1 | 10/14/2014 | $462.00 | 154.00 |
1 | 10/15/2014 | $375.00 | 125.00 |
1 | 10/16/2014 | $288.00 | 96.00 |
1 | 10/17/2014 | $369.00 | 123.00 |
1 | 10/18/2014 | $456.00 | 152.00 |
1 | 10/19/2014 | $621.00 | 207.00 |
1 | 10/20/2014 | $414.00 | 138.00 |
1 | 10/21/2014 | $390.00 | 130.00 |
1 | 10/22/2014 | $276.00 | 92.00 |
1 | 10/23/2014 | $324.00 | 108.00 |
1 | 10/24/2014 | $330.00 | 110.00 |
1 | 10/25/2014 | $408.00 | 136.00 |
1 | 10/26/2014 | $645.00 | 215.00 |
1 | 10/27/2014 | $453.00 | 151.00 |
1 | 10/28/2014 | $336.00 | 112.00 |
1 | 10/29/2014 | $312.00 | 104.00 |
1 | 10/30/2014 | $288.00 | 96.00 |
1 | 10/31/2014 | $339.00 | 113.00 |
1 | 11/1/2014 | $447.00 | 149.00 |
1 | 11/2/2014 | $588.00 | 196.00 |
1 | 11/3/2014 | $405.00 | 135.00 |
1 | 11/4/2014 | $372.00 | 124.00 |
1 | 11/5/2014 | $306.00 | 102.00 |
1 | 11/6/2014 | $321.00 | 107.00 |
1 | 11/7/2014 | $345.00 | 115.00 |
1 | 11/8/2014 | $396.00 | 132.00 |
1 | 11/9/2014 | $788.00 | 315.00 |
1 | 11/10/2014 | $500.50 | 200.00 |
1 | 11/11/2014 | $413.00 | 164.00 |
1 | 11/12/2014 | $489.00 | 195.00 |
1 | 11/13/2014 | $443.00 | 177.00 |
1 | 11/14/2014 | $413.50 | 165.00 |
1 | 11/15/2014 | $514.00 | 205.00 |
1 | 11/16/2014 | $708.00 | 236.00 |
1 | 11/17/2014 | $498.00 | 166.00 |
1 | 11/18/2014 | $357.00 | 119.00 |
1 | 11/19/2014 | $324.00 | 108.00 |
1 | 11/20/2014 | $378.00 | 126.00 |
1 | 11/21/2014 | $420.00 | 140.00 |
1 | 11/22/2014 | $498.00 | 166.00 |
1 | 11/23/2014 | $612.00 | 204.00 |
1 | 11/24/2014 | $474.00 | 158.00 |
1 | 11/25/2014 | $527.25 | 176.00 |
1 | 11/26/2014 | $300.00 | 100.00 |
1 | 11/27/2014 | $33.00 | 11.00 |
1 | 11/28/2014 | $294.00 | 98.00 |
1 | 11/29/2014 | $357.00 | 119.00 |
1 | 11/30/2014 | $576.00 | 192.00 |
1 | 12/1/2014 | $429.00 | 143.00 |
1 | 12/2/2014 | $369.00 | 123.00 |
1 | 12/3/2014 | $366.00 | 122.00 |
1 | 12/4/2014 | $273.00 | 91.00 |
1 | 12/5/2014 | $441.00 | 147.00 |
1 | 12/6/2014 | $489.00 | 163.00 |
1 | 12/7/2014 | $600.00 | 200.00 |
1 | 12/8/2014 | $591.00 | 197.00 |
1 | 12/9/2014 | $378.00 | 126.00 |
1 | 12/10/2014 | $363.00 | 121.00 |
1 | 12/11/2014 | $360.00 | 120.00 |
1 | 12/12/2014 | $408.00 | 136.00 |
1 | 12/13/2014 | $429.00 | 143.00 |
1 | 12/14/2014 | $792.00 | 264.00 |
1 | 12/15/2014 | $354.00 | 118.00 |
1 | 12/16/2014 | $282.00 | 94.00 |
1 | 12/17/2014 | $315.00 | 105.00 |
1 | 12/18/2014 | $357.00 | 119.00 |
1 | 12/19/2014 | $351.00 | 117.00 |
1 | 12/20/2014 | $351.00 | 117.00 |
1 | 12/21/2014 | $630.00 | 210.00 |
1 | 12/22/2014 | $357.00 | 119.00 |
1 | 12/23/2014 | $363.00 | 121.00 |
1 | 12/24/2014 | $393.00 | 131.00 |
1 | 12/26/2014 | $294.00 | 98.00 |
1 | 12/27/2014 | $387.00 | 129.00 |
1 | 12/28/2014 | $474.00 | 158.00 |
1 | 12/29/2014 | $420.00 | 140.00 |
1 | 12/30/2014 | $348.00 | 116.00 |
1 | 12/31/2014 | $384.00 | 128.00 |
1 | 1/1/2015 | $186.00 | 62.00 |
1 | 1/2/2015 | $414.00 | 138.00 |
1 | 1/3/2015 | $423.00 | 141.00 |
1 | 1/4/2015 | $681.00 | 227.00 |
1 | 1/5/2015 | $429.00 | 143.00 |
1 | 1/6/2015 | $282.00 | 94.00 |
1 | 1/7/2015 | $342.00 | 114.00 |
1 | 1/8/2015 | $420.00 | 140.00 |
1 | 1/9/2015 | $426.00 | 142.00 |
1 | 1/10/2015 | $573.00 | 191.00 |
1 | 1/11/2015 | $789.00 | 263.00 |
1 | 1/12/2015 | $366.00 | 122.00 |
1 | 1/13/2015 | $276.00 | 92.00 |
1 | 1/14/2015 | $321.00 | 107.00 |
1 | 1/15/2015 | $375.00 | 125.00 |
1 | 1/16/2015 | $357.00 | 119.00 |
1 | 1/17/2015 | $408.00 | 136.00 |
1 | 1/18/2015 | $573.00 | 191.00 |
1 | 1/19/2015 | $474.00 | 158.00 |
1 | 1/20/2015 | $393.00 | 131.00 |
1 | 1/21/2015 | $243.00 | 81.00 |
1 | 1/22/2015 | $279.00 | 93.00 |
1 | 1/23/2015 | $567.00 | 189.00 |
1 | 1/24/2015 | $363.00 | 121.00 |
1 | 1/25/2015 | $777.00 | 259.00 |
1 | 1/26/2015 | $213.00 | 71.00 |
1 | 1/27/2015 | $267.00 | 89.00 |
1 | 1/28/2015 | $285.00 | 95.00 |
1 | 1/29/2015 | $312.00 | 104.00 |
1 | 1/30/2015 | $360.00 | 120.00 |
1 | 1/31/2015 | $642.00 | 214.00 |
1 | 2/1/2015 | $612.00 | 204.00 |
1 | 2/2/2015 | $285.00 | 95.00 |
1 | 2/3/2015 | $324.00 | 108.00 |
1 | 2/4/2015 | $291.00 | 97.00 |
1 | 2/5/2015 | $366.00 | 122.00 |
1 | 2/6/2015 | $405.00 | 135.00 |
1 | 2/7/2015 | $384.00 | 128.00 |
1 | 2/8/2015 | $648.00 | 216.00 |
1 | 2/9/2015 | $414.00 | 138.00 |
1 | 2/10/2015 | $333.00 | 111.00 |
1 | 2/11/2015 | $324.00 | 108.00 |
1 | 2/12/2015 | $351.00 | 117.00 |
1 | 2/13/2015 | $351.00 | 117.00 |
1 | 2/14/2015 | $393.00 | 131.00 |
1 | 2/15/2015 | $417.00 | 139.00 |
1 | 2/16/2015 | $534.00 | 178.00 |
1 | 2/17/2015 | $270.00 | 90.00 |
1 | 2/18/2015 | $327.00 | 109.00 |
1 | 2/19/2015 | $288.00 | 96.00 |
1 | 2/20/2015 | $441.00 | 147.00 |
1 | 2/21/2015 | $621.00 | 207.00 |
1 | 2/22/2015 | $537.00 | 179.00 |
1 | 2/23/2015 | $420.00 | 140.00 |
1 | 2/24/2015 | $297.00 | 99.00 |
1 | 2/25/2015 | $303.00 | 101.00 |
1 | 2/26/2015 | $321.00 | 107.00 |
1 | 2/27/2015 | $336.00 | 112.00 |
1 | 2/28/2015 | $519.00 | 173.00 |
1 | 3/1/2015 | $683.00 | 228.00 |
1 | 3/2/2015 | $498.00 | 166.00 |
1 | 3/3/2015 | $441.00 | 147.00 |
1 | 3/4/2015 | $519.00 | 173.00 |
1 | 3/5/2015 | $219.00 | 73.00 |
1 | 3/6/2015 | $366.00 | 122.00 |
1 | 3/7/2015 | $423.00 | 141.00 |
1 | 3/8/2015 | $720.00 | 240.00 |
1 | 3/9/2015 | $438.00 | 146.00 |
1 | 3/10/2015 | $357.00 | 119.00 |
1 | 3/11/2015 | $426.00 | 142.00 |
1 | 3/12/2015 | $387.00 | 129.00 |
1 | 3/13/2015 | $378.00 | 126.00 |
1 | 3/14/2015 | $465.00 | 155.00 |
1 | 3/15/2015 | $696.00 | 232.00 |
1 | 3/16/2015 | $369.00 | 123.00 |
1 | 3/17/2015 | $363.00 | 121.00 |
1 | 3/18/2015 | $249.00 | 83.00 |
1 | 3/19/2015 | $384.00 | 128.00 |
1 | 3/20/2015 | $291.00 | 97.00 |
1 | 3/21/2015 | $396.00 | 132.00 |
1 | 3/22/2015 | $633.00 | 211.00 |
1 | 3/23/2015 | $438.00 | 146.00 |
1 | 3/24/2015 | $312.00 | 104.00 |
1 | 3/25/2015 | $297.00 | 99.00 |
1 | 3/26/2015 | $333.00 | 111.00 |
1 | 3/27/2015 | $285.00 | 95.00 |
1 | 3/28/2015 | $456.00 | 152.00 |
1 | 3/29/2015 | $732.00 | 244.00 |
1 | 3/30/2015 | $348.00 | 116.00 |
1 | 3/31/2015 | $240.00 | 80.00 |
1 | 4/1/2015 | $333.00 | 111.00 |
1 | 4/2/2015 | $333.00 | 111.00 |
1 | 4/3/2015 | $429.00 | 143.00 |
1 | 4/4/2015 | $495.00 | 165.00 |
1 | 4/5/2015 | $341.50 | 136.00 |
1 | 4/6/2015 | $608.00 | 243.00 |
1 | 4/7/2015 | $504.50 | 202.00 |
1 | 4/8/2015 | $381.00 | 152.00 |
1 | 4/9/2015 | $480.50 | 192.00 |
1 | 4/10/2015 | $370.00 | 148.00 |
1 | 4/11/2015 | $503.50 | 201.00 |
1 | 4/12/2015 | $675.00 | 225.00 |
1 | 4/13/2015 | $504.00 | 168.00 |
1 | 4/14/2015 | $492.00 | 164.00 |
1 | 4/15/2015 | $368.00 | 123.00 |
1 | 4/16/2015 | $438.00 | 146.00 |
1 | 4/17/2015 | $357.00 | 119.00 |
1 | 4/18/2015 | $441.00 | 147.00 |
1 | 4/19/2015 | $792.00 | 264.00 |
1 | 4/20/2015 | $462.00 | 154.00 |
1 | 4/21/2015 | $387.00 | 129.00 |
1 | 4/22/2015 | $363.00 | 121.00 |
1 | 4/23/2015 | $357.00 | 119.00 |
1 | 4/24/2015 | $330.00 | 110.00 |
1 | 4/25/2015 | $417.00 | 139.00 |
1 | 4/26/2015 | $813.00 | 271.00 |
1 | 4/27/2015 | $576.00 | 192.00 |
1 | 4/28/2015 | $327.00 | 109.00 |
1 | 4/29/2015 | $315.00 | 105.00 |
1 | 4/30/2015 | $417.00 | 139.00 |
1 | 5/1/2015 | $441.00 | 147.00 |
1 | 5/2/2015 | $450.00 | 150.00 |
1 | 5/3/2015 | $791.00 | 264.00 |
1 | 5/4/2015 | $453.00 | 151.00 |
1 | 5/5/2015 | $408.00 | 136.00 |
1 | 5/6/2015 | $432.00 | 144.00 |
1 | 5/7/2015 | $438.00 | 146.00 |
1 | 5/8/2015 | $477.00 | 159.00 |
1 | 5/9/2015 | $501.00 | 167.00 |
1 | 5/10/2015 | $612.00 | 204.00 |
1 | 5/11/2015 | $549.00 | 183.00 |
1 | 5/12/2015 | $384.00 | 128.00 |
1 | 5/13/2015 | $453.00 | 151.00 |
1 | 5/14/2015 | $447.00 | 149.00 |
1 | 5/15/2015 | $372.00 | 124.00 |
1 | 5/16/2015 | $444.00 | 148.00 |
1 | 5/17/2015 | $884.25 | 295.00 |
1 | 5/18/2015 | $378.00 | 126.00 |
1 | 5/19/2015 | $387.00 | 129.00 |
1 | 5/20/2015 | $429.00 | 143.00 |
1 | 5/21/2015 | $462.00 | 154.00 |
1 | 5/22/2015 | $426.00 | 142.00 |
1 | 5/23/2015 | $480.00 | 160.00 |
1 | 5/24/2015 | $486.00 | 162.00 |
1 | 5/25/2015 | $549.00 | 183.00 |
1 | 5/26/2015 | $450.00 | 150.00 |
1 | 5/27/2015 | $378.00 | 126.00 |
1 | 5/28/2015 | $339.00 | 113.00 |
1 | 5/29/2015 | $348.00 | 116.00 |
1 | 5/30/2015 | $417.00 | 139.00 |
1 | 5/31/2015 | $696.00 | 232.00 |
1 | 6/1/2015 | $462.00 | 154.00 |
1 | 6/2/2015 | $357.00 | 119.00 |
1 | 6/3/2015 | $435.00 | 145.00 |
1 | 6/4/2015 | $315.00 | 105.00 |
1 | 6/5/2015 | $399.00 | 133.00 |
1 | 6/6/2015 | $495.00 | 165.00 |
1 | 6/7/2015 | $666.00 | 222.00 |
1 | 6/8/2015 | $438.00 | 146.00 |
1 | 6/9/2015 | $507.00 | 169.00 |
1 | 6/10/2015 | $399.00 | 133.00 |
1 | 6/11/2015 | $477.00 | 159.00 |
1 | 6/12/2015 | $402.00 | 134.00 |
1 | 6/13/2015 | $447.00 | 149.00 |
1 | 6/14/2015 | $552.00 | 184.00 |
1 | 6/15/2015 | $453.00 | 151.00 |
1 | 6/16/2015 | $360.00 | 120.00 |
1 | 6/17/2015 | $276.00 | 92.00 |
1 | 6/18/2015 | $348.00 | 116.00 |
1 | 6/19/2015 | $345.00 | 115.00 |
1 | 6/20/2015 | $441.00 | 147.00 |
1 | 6/21/2015 | $558.00 | 186.00 |
1 | 6/22/2015 | $435.00 | 145.00 |
1 | 6/23/2015 | $339.00 | 113.00 |
1 | 6/24/2015 | $384.00 | 128.00 |
1 | 6/25/2015 | $300.00 | 100.00 |
1 | 6/26/2015 | $336.00 | 112.00 |
1 | 6/27/2015 | $423.00 | 141.00 |
1 | 6/28/2015 | $576.00 | 192.00 |
1 | 6/29/2015 | $426.00 | 142.00 |
1 | 6/30/2015 | $294.00 | 98.00 |
1 | 7/1/2015 | $357.00 | 119.00 |
1 | 7/2/2015 | $423.00 | 141.00 |
1 | 7/3/2015 | $459.00 | 153.00 |
1 | 7/4/2015 | $381.00 | 127.00 |
1 | 7/5/2015 | $414.00 | 138.00 |
1 | 7/6/2015 | $396.00 | 132.00 |
1 | 7/7/2015 | $374.00 | 125.00 |
1 | 7/8/2015 | $297.00 | 99.00 |
1 | 7/9/2015 | $372.00 | 124.00 |
1 | 7/10/2015 | $387.00 | 129.00 |
1 | 7/11/2015 | $441.00 | 147.00 |
1 | 7/12/2015 | $594.00 | 198.00 |
1 | 7/13/2015 | $417.00 | 139.00 |
1 | 7/14/2015 | $369.00 | 123.00 |
1 | 7/15/2015 | $354.00 | 118.00 |
1 | 7/16/2015 | $396.00 | 132.00 |
1 | 7/17/2015 | $336.00 | 112.00 |
1 | 7/18/2015 | $465.00 | 155.00 |
1 | 7/19/2015 | $579.00 | 193.00 |
1 | 7/20/2015 | $390.00 | 130.00 |
1 | 7/21/2015 | $339.00 | 113.00 |
1 | 7/22/2015 | $282.00 | 94.00 |
1 | 7/23/2015 | $270.00 | 90.00 |
1 | 7/24/2015 | $348.00 | 116.00 |
1 | 7/25/2015 | $402.00 | 134.00 |
1 | 7/26/2015 | $705.50 | 282.00 |
1 | 7/27/2015 | $382.00 | 152.00 |
1 | 7/28/2015 | $353.50 | 141.00 |
1 | 7/29/2015 | $303.50 | 121.00 |
1 | 7/30/2015 | $383.00 | 153.00 |
1 | 7/31/2015 | $376.50 | 150.00 |
1 | 8/1/2015 | $412.50 | 165.00 |
1 | 8/2/2015 | $686.00 | 274.00 |
1 | 8/3/2015 | $413.00 | 165.00 |
1 | 8/4/2015 | $447.50 | 179.00 |
1 | 8/5/2015 | $340.50 | 136.00 |
1 | 8/6/2015 | $415.00 | 166.00 |
1 | 8/7/2015 | $474.50 | 189.00 |
1 | 8/8/2015 | $424.00 | 169.00 |
1 | 8/9/2015 | $547.50 | 183.00 |
1 | 8/10/2015 | $438.00 | 146.00 |
1 | 8/11/2015 | $345.00 | 115.00 |
1 | 8/12/2015 | $339.00 | 113.00 |
1 | 8/13/2015 | $357.00 | 119.00 |
1 | 8/14/2015 | $495.00 | 165.00 |
1 | 8/15/2015 | $438.00 | 146.00 |
1 | 8/16/2015 | $567.00 | 189.00 |
1 | 8/17/2015 | $474.00 | 158.00 |
1 | 8/18/2015 | $375.00 | 125.00 |
1 | 8/19/2015 | $369.00 | 123.00 |
1 | 8/20/2015 | $327.00 | 109.00 |
1 | 8/21/2015 | $324.00 | 108.00 |
1 | 8/22/2015 | $429.00 | 143.00 |
1 | 8/23/2015 | $759.00 | 253.00 |
1 | 8/24/2015 | $459.00 | 153.00 |
1 | 8/25/2015 | $387.00 | 129.00 |
1 | 8/26/2015 | $348.00 | 116.00 |
1 | 8/27/2015 | $276.00 | 92.00 |
1 | 8/28/2015 | $372.00 | 124.00 |
1 | 8/29/2015 | $474.00 | 158.00 |
1 | 8/30/2015 | $612.00 | 204.00 |
1 | 8/31/2015 | $429.00 | 143.00 |
1 | 9/1/2015 | $315.00 | 105.00 |
1 | 9/2/2015 | $312.00 | 104.00 |
1 | 9/3/2015 | $345.00 | 115.00 |
1 | 9/4/2015 | $453.00 | 151.00 |
1 | 9/5/2015 | $420.00 | 140.00 |
1 | 9/6/2015 | $368.25 | 123.00 |
1 | 9/7/2015 | $507.00 | 169.00 |
1 | 9/8/2015 | $375.00 | 125.00 |
1 | 9/9/2015 | $276.00 | 92.00 |
1 | 9/10/2015 | $291.00 | 97.00 |
1 | 9/11/2015 | $333.00 | 111.00 |
1 | 9/12/2015 | $534.00 | 178.00 |
1 | 9/13/2015 | $645.00 | 215.00 |
1 | 9/14/2015 | $435.00 | 145.00 |
1 | 9/15/2015 | $396.00 | 132.00 |
1 | 9/16/2015 | $282.00 | 94.00 |
1 | 9/17/2015 | $318.00 | 106.00 |
1 | 9/18/2015 | $291.00 | 97.00 |
1 | 9/19/2015 | $414.00 | 138.00 |
1 | 9/20/2015 | $600.00 | 200.00 |
1 | 9/21/2015 | $432.00 | 144.00 |
1 | 9/22/2015 | $291.00 | 97.00 |
1 | 9/23/2015 | $282.00 | 94.00 |
1 | 9/24/2015 | $275.00 | 92.00 |
1 | 9/25/2015 | $342.00 | 114.00 |
1 | 9/26/2015 | $402.00 | 134.00 |
1 | 9/27/2015 | $729.00 | 243.00 |
1 | 9/28/2015 | $423.00 | 141.00 |
1 | 9/29/2015 | $276.00 | 92.00 |
1 | 9/30/2015 | $261.00 | 87.00 |
1 | 10/1/2015 | $336.00 | 112.00 |
1 | 10/2/2015 | $285.00 | 95.00 |
1 | 10/3/2015 | $435.00 | 145.00 |
1 | 10/4/2015 | $642.00 | 214.00 |
1 | 10/5/2015 | $396.00 | 132.00 |
1 | 10/6/2015 | $366.00 | 122.00 |
1 | 10/7/2015 | $297.00 | 99.00 |
1 | 10/8/2015 | $294.00 | 98.00 |
2 | 10/8/2014 | $348.68 | 92.00 |
2 | 10/9/2014 | $515.44 | 136.00 |
2 | 10/10/2014 | $496.49 | 131.00 |
2 | 10/11/2014 | $625.35 | 165.00 |
2 | 10/12/2014 | $780.24 | 206.00 |
2 | 10/13/2014 | $432.06 | 114.00 |
2 | 10/14/2014 | $473.75 | 125.00 |
2 | 10/15/2014 | $515.44 | 136.00 |
2 | 10/16/2014 | $481.33 | 127.00 |
2 | 10/17/2014 | $598.82 | 158.00 |
2 | 10/18/2014 | $825.47 | 218.00 |
2 | 10/19/2014 | $826.22 | 218.00 |
2 | 10/20/2014 | $397.95 | 105.00 |
2 | 10/21/2014 | $496.09 | 131.00 |
2 | 10/22/2014 | $439.14 | 116.00 |
2 | 10/23/2014 | $613.63 | 162.00 |
2 | 10/24/2014 | $606.40 | 160.00 |
2 | 10/25/2014 | $701.15 | 185.00 |
2 | 10/26/2014 | $674.62 | 178.00 |
2 | 10/27/2014 | $428.27 | 113.00 |
2 | 10/28/2014 | $492.20 | 130.00 |
2 | 10/29/2014 | $560.92 | 148.00 |
2 | 10/30/2014 | $394.16 | 104.00 |
2 | 10/31/2014 | $621.01 | 164.00 |
2 | 11/1/2014 | $678.41 | 179.00 |
2 | 11/2/2014 | $863.22 | 228.00 |
2 | 11/3/2014 | $447.22 | 118.00 |
2 | 11/4/2014 | $382.79 | 101.00 |
2 | 11/5/2014 | $420.69 | 111.00 |
2 | 11/6/2014 | $405.18 | 107.00 |
2 | 11/7/2014 | $413.11 | 109.00 |
2 | 11/8/2014 | $697.01 | 184.00 |
2 | 11/9/2014 | $792.11 | 209.00 |
2 | 11/10/2014 | $526.81 | 139.00 |
2 | 11/11/2014 | $495.49 | 131.00 |
2 | 11/12/2014 | $542.91 | 144.00 |
2 | 11/13/2014 | $544.91 | 144.00 |
2 | 11/14/2014 | $563.96 | 149.00 |
2 | 11/15/2014 | $778.44 | 206.00 |
2 | 11/16/2014 | $1,111.58 | 370.00 |
2 | 11/17/2014 | $499.74 | 165.00 |
2 | 11/18/2014 | $614.57 | 203.00 |
2 | 11/19/2014 | $690.20 | 229.00 |
2 | 11/20/2014 | $841.58 | 280.00 |
2 | 11/21/2014 | $1,081.95 | 360.00 |
2 | 11/22/2014 | $1,662.24 | 553.00 |
2 | 11/23/2014 | $2,287.50 | 760.00 |
2 | 11/24/2014 | $2,369.03 | 788.00 |
2 | 11/25/2014 | $3,324.97 | 1,104.00 |
2 | 11/26/2014 | $2,723.16 | 905.00 |
2 | 11/27/2014 | $1,013.69 | 335.00 |
2 | 11/28/2014 | $567.79 | 189.00 |
2 | 11/29/2014 | $684.16 | 227.00 |
2 | 11/30/2014 | $583.11 | 154.00 |
2 | 12/1/2014 | $606.40 | 160.00 |
2 | 12/2/2014 | $439.64 | 116.00 |
2 | 12/3/2014 | $466.17 | 123.00 |
2 | 12/4/2014 | $541.97 | 143.00 |
2 | 12/5/2014 | $643.35 | 170.00 |
2 | 12/6/2014 | $814.85 | 215.00 |
2 | 12/7/2014 | $765.08 | 202.00 |
2 | 12/8/2014 | $688.73 | 182.00 |
2 | 12/9/2014 | $572.29 | 151.00 |
2 | 12/10/2014 | $480.83 | 127.00 |
2 | 12/11/2014 | $605.90 | 160.00 |
2 | 12/12/2014 | $738.55 | 195.00 |
2 | 12/13/2014 | $924.76 | 244.00 |
2 | 12/14/2014 | $897.33 | 237.00 |
2 | 12/15/2014 | $648.09 | 171.00 |
2 | 12/16/2014 | $678.41 | 179.00 |
2 | 12/17/2014 | $697.36 | 184.00 |
2 | 12/18/2014 | $811.06 | 214.00 |
2 | 12/19/2014 | $1,071.67 | 283.00 |
2 | 12/20/2014 | $1,586.96 | 419.00 |
2 | 12/21/2014 | $1,909.31 | 504.00 |
2 | 12/22/2014 | $2,417.67 | 638.00 |
2 | 12/23/2014 | $3,732.60 | 985.00 |
2 | 12/24/2014 | $3,956.01 | 1,044.00 |
2 | 12/26/2014 | $916.68 | 242.00 |
2 | 12/27/2014 | $958.87 | 253.00 |
2 | 12/28/2014 | $943.11 | 249.00 |
2 | 12/29/2014 | $788.32 | 208.00 |
2 | 12/30/2014 | $1,500.64 | 396.00 |
2 | 12/31/2014 | $2,296.39 | 606.00 |
2 | 1/1/2015 | $791.81 | 209.00 |
2 | 1/2/2015 | $734.76 | 194.00 |
2 | 1/3/2015 | $689.78 | 182.00 |
2 | 1/4/2015 | $765.58 | 202.00 |
2 | 1/5/2015 | $447.22 | 118.00 |
2 | 1/6/2015 | $360.05 | 95.00 |
2 | 1/7/2015 | $526.81 | 139.00 |
2 | 1/8/2015 | $492.70 | 130.00 |
2 | 1/9/2015 | $670.83 | 177.00 |
2 | 1/10/2015 | $852.75 | 225.00 |
2 | 1/11/2015 | $909.60 | 240.00 |
2 | 1/12/2015 | $477.54 | 126.00 |
2 | 1/13/2015 | $560.92 | 148.00 |
2 | 1/14/2015 | $602.61 | 159.00 |
2 | 1/15/2015 | $541.97 | 143.00 |
2 | 1/16/2015 | $663.05 | 175.00 |
2 | 1/17/2015 | $742.34 | 196.00 |
2 | 1/18/2015 | $836.74 | 221.00 |
2 | 1/19/2015 | $628.89 | 166.00 |
2 | 1/20/2015 | $640.01 | 169.00 |
2 | 1/21/2015 | $424.48 | 112.00 |
2 | 1/22/2015 | $579.87 | 153.00 |
2 | 1/23/2015 | $974.03 | 257.00 |
2 | 1/24/2015 | $572.29 | 151.00 |
2 | 1/25/2015 | $1,163.13 | 307.00 |
2 | 1/26/2015 | $428.27 | 113.00 |
2 | 1/27/2015 | $424.48 | 112.00 |
2 | 1/28/2015 | $598.82 | 158.00 |
2 | 1/29/2015 | $658.71 | 174.00 |
2 | 1/30/2015 | $882.87 | 233.00 |
2 | 1/31/2015 | $1,620.62 | 428.00 |
2 | 2/1/2015 | $1,413.67 | 373.00 |
2 | 2/2/2015 | $328.73 | 87.00 |
2 | 2/3/2015 | $484.12 | 128.00 |
2 | 2/4/2015 | $511.65 | 135.00 |
2 | 2/5/2015 | $488.91 | 129.00 |
2 | 2/6/2015 | $651.88 | 172.00 |
2 | 2/7/2015 | $822.43 | 217.00 |
2 | 2/8/2015 | $852.75 | 225.00 |
2 | 2/9/2015 | $477.54 | 126.00 |
2 | 2/10/2015 | $462.38 | 122.00 |
2 | 2/11/2015 | $621.31 | 164.00 |
2 | 2/12/2015 | $576.08 | 152.00 |
2 | 2/13/2015 | $739.05 | 195.00 |
2 | 2/14/2015 | $875.49 | 231.00 |
2 | 2/15/2015 | $644.30 | 170.00 |
2 | 2/16/2015 | $780.74 | 206.00 |
2 | 2/17/2015 | $420.69 | 111.00 |
2 | 2/18/2015 | $549.55 | 145.00 |
2 | 2/19/2015 | $481.33 | 127.00 |
2 | 2/20/2015 | $700.90 | 185.00 |
2 | 2/21/2015 | $788.32 | 208.00 |
2 | 2/22/2015 | $670.83 | 177.00 |
2 | 2/23/2015 | $504.07 | 133.00 |
2 | 2/24/2015 | $481.33 | 127.00 |
2 | 2/25/2015 | $534.39 | 141.00 |
2 | 2/26/2015 | $568.50 | 150.00 |
2 | 2/27/2015 | $572.29 | 151.00 |
2 | 2/28/2015 | $760.79 | 201.00 |
2 | 3/1/2015 | $670.83 | 177.00 |
2 | 3/2/2015 | $492.70 | 130.00 |
2 | 3/3/2015 | $704.94 | 186.00 |
2 | 3/4/2015 | $708.48 | 187.00 |
2 | 3/5/2015 | $348.68 | 92.00 |
2 | 3/6/2015 | $519.23 | 137.00 |
2 | 3/7/2015 | $761.79 | 201.00 |
2 | 3/8/2015 | $897.98 | 237.00 |
2 | 3/9/2015 | $576.08 | 152.00 |
2 | 3/10/2015 | $523.02 | 138.00 |
2 | 3/11/2015 | $432.06 | 114.00 |
2 | 3/12/2015 | $587.45 | 155.00 |
2 | 3/13/2015 | $670.83 | 177.00 |
2 | 3/14/2015 | $773.16 | 204.00 |
2 | 3/15/2015 | $735.26 | 194.00 |
2 | 3/16/2015 | $541.97 | 143.00 |
2 | 3/17/2015 | $523.02 | 138.00 |
2 | 3/18/2015 | $473.75 | 125.00 |
2 | 3/19/2015 | $549.55 | 145.00 |
2 | 3/20/2015 | $549.55 | 145.00 |
2 | 3/21/2015 | $761.79 | 201.00 |
2 | 3/22/2015 | $928.55 | 245.00 |
2 | 3/23/2015 | $454.30 | 120.00 |
2 | 3/24/2015 | $496.49 | 131.00 |
2 | 3/25/2015 | $553.34 | 146.00 |
2 | 3/26/2015 | $549.55 | 145.00 |
2 | 3/27/2015 | $602.61 | 159.00 |
2 | 3/28/2015 | $871.20 | 230.00 |
2 | 3/29/2015 | $1,041.93 | 317.00 |
2 | 3/30/2015 | $600.28 | 182.00 |
2 | 3/31/2015 | $876.64 | 266.00 |
2 | 4/1/2015 | $1,215.22 | 368.00 |
2 | 4/2/2015 | $1,730.60 | 525.00 |
2 | 4/3/2015 | $3,071.37 | 933.00 |
2 | 4/4/2015 | $3,928.68 | 1,192.00 |
2 | 4/5/2015 | $1,771.72 | 468.00 |
2 | 4/6/2015 | $617.77 | 163.00 |
2 | 4/7/2015 | $515.44 | 136.00 |
2 | 4/8/2015 | $576.08 | 152.00 |
2 | 4/9/2015 | $613.43 | 162.00 |
2 | 4/10/2015 | $613.98 | 162.00 |
2 | 4/11/2015 | $845.17 | 223.00 |
2 | 4/12/2015 | $761.09 | 201.00 |
2 | 4/13/2015 | $602.36 | 159.00 |
2 | 4/14/2015 | $670.83 | 177.00 |
2 | 4/15/2015 | $564.71 | 149.00 |
2 | 4/16/2015 | $576.08 | 152.00 |
2 | 4/17/2015 | $718.10 | 190.00 |
2 | 4/18/2015 | $768.87 | 203.00 |
2 | 4/19/2015 | $905.31 | 239.00 |
2 | 4/20/2015 | $632.18 | 167.00 |
2 | 4/21/2015 | $523.02 | 138.00 |
2 | 4/22/2015 | $503.57 | 133.00 |
2 | 4/23/2015 | $564.71 | 149.00 |
2 | 4/24/2015 | $586.50 | 155.00 |
2 | 4/25/2015 | $598.82 | 158.00 |
2 | 4/26/2015 | $745.63 | 197.00 |
2 | 4/27/2015 | $629.14 | 166.00 |
2 | 4/28/2015 | $511.65 | 135.00 |
2 | 4/29/2015 | $477.54 | 126.00 |
2 | 4/30/2015 | $538.18 | 142.00 |
2 | 5/1/2015 | $680.90 | 180.00 |
2 | 5/2/2015 | $787.77 | 208.00 |
2 | 5/3/2015 | $874.94 | 231.00 |
2 | 5/4/2015 | $541.77 | 143.00 |
2 | 5/5/2015 | $439.64 | 116.00 |
2 | 5/6/2015 | $507.86 | 134.00 |
2 | 5/7/2015 | $488.91 | 129.00 |
2 | 5/8/2015 | $667.04 | 176.00 |
2 | 5/9/2015 | $829.30 | 220.00 |
2 | 5/10/2015 | $898.23 | 237.00 |
2 | 5/11/2015 | $544.96 | 144.00 |
2 | 5/12/2015 | $549.05 | 145.00 |
2 | 5/13/2015 | $504.07 | 133.00 |
2 | 5/14/2015 | $526.81 | 139.00 |
2 | 5/15/2015 | $525.31 | 139.00 |
2 | 5/16/2015 | $598.82 | 158.00 |
2 | 5/17/2015 | $807.07 | 213.00 |
2 | 5/18/2015 | $553.34 | 146.00 |
2 | 5/19/2015 | $595.03 | 157.00 |
2 | 5/20/2015 | $560.42 | 148.00 |
2 | 5/21/2015 | $572.29 | 151.00 |
2 | 5/22/2015 | $881.87 | 233.00 |
2 | 5/23/2015 | $913.04 | 241.00 |
2 | 5/24/2015 | $765.58 | 202.00 |
2 | 5/25/2015 | $729.42 | 193.00 |
2 | 5/26/2015 | $424.48 | 112.00 |
2 | 5/27/2015 | $534.39 | 141.00 |
2 | 5/28/2015 | $541.52 | 143.00 |
2 | 5/29/2015 | $526.81 | 139.00 |
2 | 5/30/2015 | $708.73 | 187.00 |
2 | 5/31/2015 | $640.01 | 169.00 |
2 | 6/1/2015 | $454.80 | 120.00 |
2 | 6/2/2015 | $481.33 | 127.00 |
2 | 6/3/2015 | $428.27 | 113.00 |
2 | 6/4/2015 | $576.08 | 152.00 |
2 | 6/5/2015 | $447.22 | 118.00 |
2 | 6/6/2015 | $735.26 | 194.00 |
2 | 6/7/2015 | $807.27 | 213.00 |
2 | 6/8/2015 | $485.12 | 128.00 |
2 | 6/9/2015 | $496.49 | 131.00 |
2 | 6/10/2015 | $534.19 | 141.00 |
2 | 6/11/2015 | $420.69 | 111.00 |
2 | 6/12/2015 | $515.44 | 136.00 |
2 | 6/13/2015 | $629.14 | 166.00 |
2 | 6/14/2015 | $670.83 | 177.00 |
2 | 6/15/2015 | $511.65 | 135.00 |
2 | 6/16/2015 | $458.59 | 121.00 |
2 | 6/17/2015 | $405.53 | 107.00 |
2 | 6/18/2015 | $454.80 | 120.00 |
2 | 6/19/2015 | $560.37 | 148.00 |
2 | 6/20/2015 | $663.00 | 175.00 |
2 | 6/21/2015 | $821.93 | 217.00 |
2 | 6/22/2015 | $454.80 | 120.00 |
2 | 6/23/2015 | $420.69 | 111.00 |
2 | 6/24/2015 | $496.49 | 131.00 |
2 | 6/25/2015 | $625.35 | 165.00 |
2 | 6/26/2015 | $583.66 | 154.00 |
2 | 6/27/2015 | $758.00 | 200.00 |
2 | 6/28/2015 | $727.18 | 192.00 |
2 | 6/29/2015 | $469.96 | 124.00 |
2 | 6/30/2015 | $499.03 | 132.00 |
2 | 7/1/2015 | $442.93 | 117.00 |
2 | 7/2/2015 | $666.29 | 176.00 |
2 | 7/3/2015 | $897.73 | 237.00 |
2 | 7/4/2015 | $746.63 | 197.00 |
2 | 7/5/2015 | $523.02 | 138.00 |
2 | 7/6/2015 | $500.28 | 132.00 |
2 | 7/7/2015 | $500.28 | 132.00 |
2 | 7/8/2015 | $500.28 | 132.00 |
2 | 7/9/2015 | $397.95 | 105.00 |
2 | 7/10/2015 | $575.33 | 152.00 |
2 | 7/11/2015 | $640.51 | 169.00 |
2 | 7/12/2015 | $689.78 | 182.00 |
2 | 7/13/2015 | $462.38 | 122.00 |
2 | 7/14/2015 | $447.22 | 118.00 |
2 | 7/15/2015 | $504.07 | 133.00 |
2 | 7/16/2015 | $462.38 | 122.00 |
2 | 7/17/2015 | $613.98 | 162.00 |
2 | 7/18/2015 | $708.73 | 187.00 |
2 | 7/19/2015 | $663.25 | 175.00 |
2 | 7/20/2015 | $507.86 | 134.00 |
2 | 7/21/2015 | $610.19 | 161.00 |
2 | 7/22/2015 | $538.18 | 142.00 |
2 | 7/23/2015 | $523.02 | 138.00 |
2 | 7/24/2015 | $495.99 | 131.00 |
2 | 7/25/2015 | $860.33 | 227.00 |
2 | 7/26/2015 | $727.68 | 192.00 |
2 | 7/27/2015 | $466.17 | 123.00 |
2 | 7/28/2015 | $488.91 | 129.00 |
2 | 7/29/2015 | $439.64 | 116.00 |
2 | 7/30/2015 | $469.96 | 124.00 |
2 | 7/31/2015 | $579.87 | 153.00 |
2 | 8/1/2015 | $583.66 | 154.00 |
2 | 8/2/2015 | $706.23 | 177.00 |
2 | 8/3/2015 | $542.39 | 136.00 |
2 | 8/4/2015 | $454.86 | 114.00 |
2 | 8/5/2015 | $498.75 | 125.00 |
2 | 8/6/2015 | $498.75 | 125.00 |
2 | 8/7/2015 | $709.22 | 178.00 |
2 | 8/8/2015 | $602.49 | 151.00 |
2 | 8/9/2015 | $765.08 | 192.00 |
2 | 8/10/2015 | $534.36 | 134.00 |
2 | 8/11/2015 | $622.44 | 156.00 |
2 | 8/12/2015 | $522.69 | 131.00 |
2 | 8/13/2015 | $490.02 | 123.00 |
2 | 8/14/2015 | $662.34 | 166.00 |
2 | 8/15/2015 | $546.63 | 137.00 |
2 | 8/16/2015 | $714.21 | 179.00 |
2 | 8/17/2015 | $359.10 | 90.00 |
2 | 8/18/2015 | $546.63 | 137.00 |
2 | 8/19/2015 | $422.94 | 106.00 |
2 | 8/20/2015 | $578.05 | 145.00 |
2 | 8/21/2015 | $673.36 | 169.00 |
2 | 8/22/2015 | $662.34 | 166.00 |
2 | 8/23/2015 | $798.00 | 200.00 |
2 | 8/24/2015 | $594.51 | 149.00 |
2 | 8/25/2015 | $541.89 | 136.00 |
2 | 8/26/2015 | $530.17 | 133.00 |
2 | 8/27/2015 | $466.83 | 117.00 |
2 | 8/28/2015 | $570.57 | 143.00 |
2 | 8/29/2015 | $789.52 | 198.00 |
2 | 8/30/2015 | $791.01 | 199.00 |
2 | 8/31/2015 | $530.67 | 133.00 |
2 | 9/1/2015 | $550.62 | 138.00 |
2 | 9/2/2015 | $514.71 | 129.00 |
2 | 9/3/2015 | $630.42 | 158.00 |
2 | 9/4/2015 | $861.84 | 216.00 |
2 | 9/5/2015 | $921.69 | 231.00 |
2 | 9/6/2015 | $913.71 | 229.00 |
2 | 9/7/2015 | $833.91 | 209.00 |
2 | 9/8/2015 | $574.56 | 144.00 |
2 | 9/9/2015 | $518.70 | 130.00 |
2 | 9/10/2015 | $514.71 | 129.00 |
2 | 9/11/2015 | $562.59 | 141.00 |
2 | 9/12/2015 | $821.94 | 206.00 |
2 | 9/13/2015 | $901.74 | 226.00 |
2 | 9/14/2015 | $642.39 | 161.00 |
2 | 9/15/2015 | $474.81 | 119.00 |
2 | 9/16/2015 | $558.60 | 140.00 |
2 | 9/17/2015 | $593.76 | 149.00 |
2 | 9/18/2015 | $717.45 | 180.00 |
2 | 9/19/2015 | $868.32 | 218.00 |
2 | 9/20/2015 | $1,129.17 | 283.00 |
2 | 9/21/2015 | $490.77 | 123.00 |
2 | 9/22/2015 | $514.71 | 129.00 |
2 | 9/23/2015 | $574.56 | 144.00 |
2 | 9/24/2015 | $486.78 | 122.00 |
2 | 9/25/2015 | $713.76 | 179.00 |
2 | 9/26/2015 | $853.86 | 214.00 |
2 | 9/27/2015 | $790.02 | 198.00 |
2 | 9/28/2015 | $542.64 | 136.00 |
2 | 9/29/2015 | $622.44 | 156.00 |
2 | 9/30/2015 | $554.61 | 139.00 |
2 | 10/1/2015 | $578.55 | 145.00 |
2 | 10/2/2015 | $642.39 | 161.00 |
2 | 10/3/2015 | $849.87 | 213.00 |
2 | 10/4/2015 | $853.86 | 214.00 |
2 | 10/5/2015 | $598.50 | 150.00 |
2 | 10/6/2015 | $526.68 | 132.00 |
2 | 10/7/2015 | $590.52 | 148.00 |
2 | 10/8/2015 | $618.45 | 155.00 |
<tbody>
[TD="class: xl68"][TABLE="width: 248"]
<tbody>[TR]
</tbody>
[TD="class: xl64, width: 71"][/TD]
[TD="class: xl64, width: 57"][/TD]
[/TR]
</tbody>[/TABLE]
Last edited: