Stock market rolling period returns

M

mdelzi23

New Member
Joined
Feb 17, 2016
Messages
6
Hello,
I am trying to calculate stock market returns over different periods. I have downloaded the daily index values from yahoo finance for the S&P 500 and the Russell 2000 index. I would like to start with the 1 year, 3 year and 6 year rolling periods. This is difficult because the data excludes the weekends and holidays which is difficult to calculate 365 days. When I enter a starting period the ending date some times falls on a weekend or holiday. I have used the vlookup function to randomly pick starting dates and find its corresponding index value, but the rolling period often ends on a weekend or holiday where there is no corresponding date or value. I would like to create a lookup that allows the ending date to move out to the next trading day in the future and find the corresponding index value.

This is the formula I have been using =WORKDAY(EDATE(C9,12)-1,0,'S&P Daily '!J2:J7288)
12 is the 12 month rolling period from a specific date. I get a "#N/A" when the end date lands on a weekend, holiday or the data is missing.

Any suggestion would be very helpful.

Thanks
 

Excel Facts

Remove leading & trailing spaces
Save as CSV to remove all leading and trailing spaces. It is faster than using TRIM().
Sort by date Sort by votes
Welcome to the Forum!

Isn't it usual, given that each day's index values are as at the close of the day, for the index value to be taken for the specified date, or the most recent previous trading date?

So here, for example, won't your 30 June 2012 index be:

=VLOOKUP(DATE(2012,6,30),A1:B3,2,TRUE)
=1,001.

Excel 2010
AB

<colgroup><col style="width: 25pxpx"><col><col></colgroup><thead>
</thead><tbody>
[TD="align: center"]1[/TD]
[TD="align: center"]Available index values[/TD]
[TD="align: right"][/TD]

[TD="align: center"]2[/TD]
[TD="align: center"]Thu 28 Jun 2012[/TD]
[TD="align: right"]1,000[/TD]

[TD="align: center"]3[/TD]
[TD="align: center"]Fri 29 Jun 2012[/TD]
[TD="align: right"]1,001[/TD]

[TD="align: center"]4[/TD]
[TD="align: center"]Mon 2 Jul 2012[/TD]
[TD="align: right"]998[/TD]

</tbody>

​
 
Upvote 0
StephenCrump said:
Welcome to the Forum!

Isn't it usual, given that each day's index values are as at the close of the day, for the index value to be taken for the specified date, or the most recent previous trading date?

So here, for example, won't your 30 June 2012 index be:

=VLOOKUP(DATE(2012,6,30),A1:B3,2,TRUE)
=1,001.

Excel 2010
AB

<tbody>
[TD="align: center"]1[/TD]
[TD="align: center"]Available index values[/TD]
[TD="align: right"][/TD]

[TD="align: center"]2[/TD]
[TD="align: center"]Thu 28 Jun 2012[/TD]
[TD="align: right"]1,000[/TD]

[TD="align: center"]3[/TD]
[TD="align: center"]Fri 29 Jun 2012[/TD]
[TD="align: right"]1,001[/TD]

[TD="align: center"]4[/TD]
[TD="align: center"]Mon 2 Jul 2012[/TD]
[TD="align: right"]998[/TD]

</tbody>

Stephen,

Thank you for your prompt response. I completely understand the logic behind your response but the math behind your vlookup is confusing. How is your vlookup finding the date of 6/30/2012 if there is no date in the data? I have pasted the last 12 months of daily closes below to demonstrate what I mean. As you can see the days that fall on a holiday or weekend show #N/A to calculate the 12 month rolling return. Here are the formulas I am using in column H and I.
I might be making this harder than it has to be...:laugh:

Column H =DATE(YEAR(E2)-1,MONTH(E2),DAY(E2)+1)
Column I=(F2-VLOOKUP(H2,A2:F16608,2,FALSE))/VLOOKUP(H2,A2:F16608,2,FALSE) (this calculates the return over the last 12 months)

A B C D E F G H I
[TABLE="width: 619"]
<colgroup><col><col span="3"><col><col span="2"><col><col></colgroup><tbody>[TR]
[TD]Date[/TD]
[TD] Open[/TD]
[TD] High[/TD]
[TD] Low[/TD]
[TD] Date[/TD]
[TD] Close[/TD]
[TD][/TD]
[TD]One year[/TD]
[TD] 1 year[/TD]
[/TR]
[TR]
[TD="align: right"]12/31/2015[/TD]
[TD="align: right"]2060.59[/TD]
[TD="align: right"]2062.54[/TD]
[TD="align: right"]2043.62[/TD]
[TD="align: right"] 12/31/2015[/TD]
[TD="align: right"]2043.94[/TD]
[TD][/TD]
[TD="align: right"]1/1/2015[/TD]
[TD="align: center"]#N/A[/TD]
[/TR]
[TR]
[TD="align: right"]12/30/2015[/TD]
[TD="align: right"]2077.34[/TD]
[TD="align: right"]2077.34[/TD]
[TD="align: right"]2061.97[/TD]
[TD="align: right"]12/30/2015[/TD]
[TD="align: right"]2063.36[/TD]
[TD][/TD]
[TD="align: right"]12/31/2014[/TD]
[TD="align: right"]-0.90%[/TD]
[/TR]
[TR]
[TD="align: right"]12/29/2015[/TD]
[TD="align: right"]2060.54[/TD]
[TD="align: right"]2081.56[/TD]
[TD="align: right"]2060.54[/TD]
[TD="align: right"]12/29/2015[/TD]
[TD="align: right"]2078.36[/TD]
[TD][/TD]
[TD="align: right"]12/30/2014[/TD]
[TD="align: right"]-0.49%[/TD]
[/TR]
[TR]
[TD="align: right"]12/28/2015[/TD]
[TD="align: right"]2057.77[/TD]
[TD="align: right"]2057.77[/TD]
[TD="align: right"]2044.2[/TD]
[TD="align: right"]12/28/2015[/TD]
[TD="align: right"]2056.5[/TD]
[TD][/TD]
[TD="align: right"]12/29/2014[/TD]
[TD="align: right"]-1.49%[/TD]
[/TR]
[TR]
[TD="align: right"]12/24/2015[/TD]
[TD="align: right"]2063.52[/TD]
[TD="align: right"]2067.36[/TD]
[TD="align: right"]2058.73[/TD]
[TD="align: right"]12/24/2015[/TD]
[TD="align: right"]2060.99[/TD]
[TD][/TD]
[TD="align: right"]12/25/2014[/TD]
[TD="align: center"]#N/A[/TD]
[/TR]
[TR]
[TD="align: right"]12/23/2015[/TD]
[TD="align: right"]2042.2[/TD]
[TD="align: right"]2064.73[/TD]
[TD="align: right"]2042.2[/TD]
[TD="align: right"]12/23/2015[/TD]
[TD="align: right"]2064.29[/TD]
[TD][/TD]
[TD="align: right"]12/24/2014[/TD]
[TD="align: right"]-0.91%[/TD]
[/TR]
[TR]
[TD="align: right"]12/22/2015[/TD]
[TD="align: right"]2023.15[/TD]
[TD="align: right"]2042.74[/TD]
[TD="align: right"]2020.49[/TD]
[TD="align: right"]12/22/2015[/TD]
[TD="align: right"]2038.97[/TD]
[TD][/TD]
[TD="align: right"]12/23/2014[/TD]
[TD="align: right"]-2.04%[/TD]
[/TR]
[TR]
[TD="align: right"]12/21/2015[/TD]
[TD="align: right"]2010.27[/TD]
[TD="align: right"]2022.9[/TD]
[TD="align: right"]2005.93[/TD]
[TD="align: right"]12/21/2015[/TD]
[TD="align: right"]2021.15[/TD]
[TD][/TD]
[TD="align: right"]12/22/2014[/TD]
[TD="align: right"]-2.33%[/TD]
[/TR]
[TR]
[TD="align: right"]12/18/2015[/TD]
[TD="align: right"]2040.81[/TD]
[TD="align: right"]2040.81[/TD]
[TD="align: right"]2005.33[/TD]
[TD="align: right"]12/18/2015[/TD]
[TD="align: right"]2005.55[/TD]
[TD][/TD]
[TD="align: right"]12/19/2014[/TD]
[TD="align: right"]-2.69%[/TD]
[/TR]
[TR]
[TD="align: right"]12/17/2015[/TD]
[TD="align: right"]2073.76[/TD]
[TD="align: right"]2076.37[/TD]
[TD="align: right"]2041.66[/TD]
[TD="align: right"]12/17/2015[/TD]
[TD="align: right"]2041.89[/TD]
[TD][/TD]
[TD="align: right"]12/18/2014[/TD]
[TD="align: right"]1.13%[/TD]
[/TR]
[TR]
[TD="align: right"]12/16/2015[/TD]
[TD="align: right"]2046.5[/TD]
[TD="align: right"]2076.72[/TD]
[TD="align: right"]2042.43[/TD]
[TD="align: right"]12/16/2015[/TD]
[TD="align: right"]2073.07[/TD]
[TD][/TD]
[TD="align: right"]12/17/2014[/TD]
[TD="align: right"]5.03%[/TD]
[/TR]
[TR]
[TD="align: right"]12/15/2015[/TD]
[TD="align: right"]2025.55[/TD]
[TD="align: right"]2053.87[/TD]
[TD="align: right"]2025.55[/TD]
[TD="align: right"]12/15/2015[/TD]
[TD="align: right"]2043.41[/TD]
[TD][/TD]
[TD="align: right"]12/16/2014[/TD]
[TD="align: right"]2.85%[/TD]
[/TR]
[TR]
[TD="align: right"]12/14/2015[/TD]
[TD="align: right"]2013.37[/TD]
[TD="align: right"]2022.92[/TD]
[TD="align: right"]1993.26[/TD]
[TD="align: right"]12/14/2015[/TD]
[TD="align: right"]2021.94[/TD]
[TD][/TD]
[TD="align: right"]12/15/2014[/TD]
[TD="align: right"]0.84%[/TD]
[/TR]
[TR]
[TD="align: right"]12/11/2015[/TD]
[TD="align: right"]2047.27[/TD]
[TD="align: right"]2047.27[/TD]
[TD="align: right"]2008.8[/TD]
[TD="align: right"]12/11/2015[/TD]
[TD="align: right"]2012.37[/TD]
[TD][/TD]
[TD="align: right"]12/12/2014[/TD]
[TD="align: right"]-0.89%[/TD]
[/TR]
[TR]
[TD="align: right"]12/10/2015[/TD]
[TD="align: right"]2047.93[/TD]
[TD="align: right"]2067.65[/TD]
[TD="align: right"]2045.67[/TD]
[TD="align: right"]12/10/2015[/TD]
[TD="align: right"]2052.23[/TD]
[TD][/TD]
[TD="align: right"]12/11/2014[/TD]
[TD="align: right"]1.20%[/TD]
[/TR]
[TR]
[TD="align: right"]12/9/2015[/TD]
[TD="align: right"]2061.17[/TD]
[TD="align: right"]2080.33[/TD]
[TD="align: right"]2036.53[/TD]
[TD="align: right"]12/9/2015[/TD]
[TD="align: right"]2047.62[/TD]
[TD][/TD]
[TD="align: right"]12/10/2014[/TD]
[TD="align: right"]-0.55%[/TD]
[/TR]
[TR]
[TD="align: right"]12/8/2015[/TD]
[TD="align: right"]2073.39[/TD]
[TD="align: right"]2073.85[/TD]
[TD="align: right"]2052.32[/TD]
[TD="align: right"]12/8/2015[/TD]
[TD="align: right"]2063.59[/TD]
[TD][/TD]
[TD="align: right"]12/9/2014[/TD]
[TD="align: right"]0.34%[/TD]
[/TR]
[TR]
[TD="align: right"]12/7/2015[/TD]
[TD="align: right"]2090.42[/TD]
[TD="align: right"]2090.42[/TD]
[TD="align: right"]2066.78[/TD]
[TD="align: right"]12/7/2015[/TD]
[TD="align: right"]2077.07[/TD]
[TD][/TD]
[TD="align: right"]12/8/2014[/TD]
[TD="align: right"]0.11%[/TD]
[/TR]
[TR]
[TD="align: right"]12/4/2015[/TD]
[TD="align: right"]2051.24[/TD]
[TD="align: right"]2093.84[/TD]
[TD="align: right"]2051.24[/TD]
[TD="align: right"]12/4/2015[/TD]
[TD="align: right"]2091.69[/TD]
[TD][/TD]
[TD="align: right"]12/5/2014[/TD]
[TD="align: right"]0.91%[/TD]
[/TR]
[TR]
[TD="align: right"]12/3/2015[/TD]
[TD="align: right"]2080.71[/TD]
[TD="align: right"]2085[/TD]
[TD="align: right"]2042.35[/TD]
[TD="align: right"]12/3/2015[/TD]
[TD="align: right"]2049.62[/TD]
[TD][/TD]
[TD="align: right"]12/4/2014[/TD]
[TD="align: right"]-1.16%[/TD]
[/TR]
[TR]
[TD="align: right"]12/2/2015[/TD]
[TD="align: right"]2101.71[/TD]
[TD="align: right"]2104.27[/TD]
[TD="align: right"]2077.11[/TD]
[TD="align: right"]12/2/2015[/TD]
[TD="align: right"]2079.51[/TD]
[TD][/TD]
[TD="align: right"]12/3/2014[/TD]
[TD="align: right"]0.58%[/TD]
[/TR]
[TR]
[TD="align: right"]12/1/2015[/TD]
[TD="align: right"]2082.93[/TD]
[TD="align: right"]2103.37[/TD]
[TD="align: right"]2082.93[/TD]
[TD="align: right"]12/1/2015[/TD]
[TD="align: right"]2102.63[/TD]
[TD][/TD]
[TD="align: right"]12/2/2014[/TD]
[TD="align: right"]2.38%[/TD]
[/TR]
[TR]
[TD="align: right"]11/30/2015[/TD]
[TD="align: right"]2090.95[/TD]
[TD="align: right"]2093.81[/TD]
[TD="align: right"]2080.41[/TD]
[TD="align: right"]11/30/2015[/TD]
[TD="align: right"]2080.41[/TD]
[TD][/TD]
[TD="align: right"]12/1/2014[/TD]
[TD="align: right"]0.71%[/TD]
[/TR]
[TR]
[TD="align: right"]11/27/2015[/TD]
[TD="align: right"]2088.82[/TD]
[TD="align: right"]2093.29[/TD]
[TD="align: right"]2084.13[/TD]
[TD="align: right"]11/27/2015[/TD]
[TD="align: right"]2090.11[/TD]
[TD][/TD]
[TD="align: right"]11/28/2014[/TD]
[TD="align: right"]0.74%[/TD]
[/TR]
[TR]
[TD="align: right"]11/25/2015[/TD]
[TD="align: right"]2089.3[/TD]
[TD="align: right"]2093[/TD]
[TD="align: right"]2086.3[/TD]
[TD="align: right"]11/25/2015[/TD]
[TD="align: right"]2088.87[/TD]
[TD][/TD]
[TD="align: right"]11/26/2014[/TD]
[TD="align: right"]1.04%[/TD]
[/TR]
[TR]
[TD="align: right"]11/24/2015[/TD]
[TD="align: right"]2084.42[/TD]
[TD="align: right"]2094.12[/TD]
[TD="align: right"]2070.29[/TD]
[TD="align: right"]11/24/2015[/TD]
[TD="align: right"]2089.14[/TD]
[TD][/TD]
[TD="align: right"]11/25/2014[/TD]
[TD="align: right"]0.92%[/TD]
[/TR]
[TR]
[TD="align: right"]11/23/2015[/TD]
[TD="align: right"]2089.41[/TD]
[TD="align: right"]2095.61[/TD]
[TD="align: right"]2081.39[/TD]
[TD="align: right"]11/23/2015[/TD]
[TD="align: right"]2086.59[/TD]
[TD][/TD]
[TD="align: right"]11/24/2014[/TD]
[TD="align: right"]1.04%[/TD]
[/TR]
[TR]
[TD="align: right"]11/20/2015[/TD]
[TD="align: right"]2082.82[/TD]
[TD="align: right"]2097.06[/TD]
[TD="align: right"]2082.82[/TD]
[TD="align: right"]11/20/2015[/TD]
[TD="align: right"]2089.17[/TD]
[TD][/TD]
[TD="align: right"]11/21/2014[/TD]
[TD="align: right"]1.54%[/TD]
[/TR]
[TR]
[TD="align: right"]11/19/2015[/TD]
[TD="align: right"]2083.7[/TD]
[TD="align: right"]2086.74[/TD]
[TD="align: right"]2078.76[/TD]
[TD="align: right"]11/19/2015[/TD]
[TD="align: right"]2081.24[/TD]
[TD][/TD]
[TD="align: right"]11/20/2014[/TD]
[TD="align: right"]1.73%[/TD]
[/TR]
[TR]
[TD="align: right"]11/18/2015[/TD]
[TD="align: right"]2051.99[/TD]
[TD="align: right"]2085.31[/TD]
[TD="align: right"]2051.99[/TD]
[TD="align: right"]11/18/2015[/TD]
[TD="align: right"]2083.58[/TD]
[TD][/TD]
[TD="align: right"]11/19/2014[/TD]
[TD="align: right"]1.58%[/TD]
[/TR]
[TR]
[TD="align: right"]11/17/2015[/TD]
[TD="align: right"]2053.67[/TD]
[TD="align: right"]2066.69[/TD]
[TD="align: right"]2045.9[/TD]
[TD="align: right"]11/17/2015[/TD]
[TD="align: right"]2050.44[/TD]
[TD][/TD]
[TD="align: right"]11/18/2014[/TD]
[TD="align: right"]0.44%[/TD]
[/TR]
[TR]
[TD="align: right"]11/16/2015[/TD]
[TD="align: right"]2022.08[/TD]
[TD="align: right"]2053.22[/TD]
[TD="align: right"]2019.39[/TD]
[TD="align: right"]11/16/2015[/TD]
[TD="align: right"]2053.19[/TD]
[TD][/TD]
[TD="align: right"]11/17/2014[/TD]
[TD="align: right"]0.73%[/TD]
[/TR]
[TR]
[TD="align: right"]11/13/2015[/TD]
[TD="align: right"]2044.64[/TD]
[TD="align: right"]2044.64[/TD]
[TD="align: right"]2022.02[/TD]
[TD="align: right"]11/13/2015[/TD]
[TD="align: right"]2023.04[/TD]
[TD][/TD]
[TD="align: right"]11/14/2014[/TD]
[TD="align: right"]-0.82%[/TD]
[/TR]
[TR]
[TD="align: right"]11/12/2015[/TD]
[TD="align: right"]2072.29[/TD]
[TD="align: right"]2072.29[/TD]
[TD="align: right"]2045.66[/TD]
[TD="align: right"]11/12/2015[/TD]
[TD="align: right"]2045.97[/TD]
[TD][/TD]
[TD="align: right"]11/13/2014[/TD]
[TD="align: right"]0.33%[/TD]
[/TR]
[TR]
[TD="align: right"]11/11/2015[/TD]
[TD="align: right"]2083.41[/TD]
[TD="align: right"]2086.94[/TD]
[TD="align: right"]2074.85[/TD]
[TD="align: right"]11/11/2015[/TD]
[TD="align: right"]2075[/TD]
[TD][/TD]
[TD="align: right"]11/12/2014[/TD]
[TD="align: right"]1.83%[/TD]
[/TR]
[TR]
[TD="align: right"]11/10/2015[/TD]
[TD="align: right"]2077.19[/TD]
[TD="align: right"]2083.67[/TD]
[TD="align: right"]2069.91[/TD]
[TD="align: right"]11/10/2015[/TD]
[TD="align: right"]2081.72[/TD]
[TD][/TD]
[TD="align: right"]11/11/2014[/TD]
[TD="align: right"]2.14%[/TD]
[/TR]
[TR]
[TD="align: right"]11/9/2015[/TD]
[TD="align: right"]2096.56[/TD]
[TD="align: right"]2096.56[/TD]
[TD="align: right"]2068.24[/TD]
[TD="align: right"]11/9/2015[/TD]
[TD="align: right"]2078.58[/TD]
[TD][/TD]
[TD="align: right"]11/10/2014[/TD]
[TD="align: right"]2.29%[/TD]
[/TR]
[TR]
[TD="align: right"]11/6/2015[/TD]
[TD="align: right"]2098.6[/TD]
[TD="align: right"]2101.91[/TD]
[TD="align: right"]2083.74[/TD]
[TD="align: right"]11/6/2015[/TD]
[TD="align: right"]2099.2[/TD]
[TD][/TD]
[TD="align: right"]11/7/2014[/TD]
[TD="align: right"]3.29%[/TD]
[/TR]
[TR]
[TD="align: right"]11/5/2015[/TD]
[TD="align: right"]2101.68[/TD]
[TD="align: right"]2108.78[/TD]
[TD="align: right"]2090.41[/TD]
[TD="align: right"]11/5/2015[/TD]
[TD="align: right"]2099.93[/TD]
[TD][/TD]
[TD="align: right"]11/6/2014[/TD]
[TD="align: right"]3.79%[/TD]
[/TR]
[TR]
[TD="align: right"]11/4/2015[/TD]
[TD="align: right"]2110.6[/TD]
[TD="align: right"]2114.59[/TD]
[TD="align: right"]2096.98[/TD]
[TD="align: right"]11/4/2015[/TD]
[TD="align: right"]2102.31[/TD]
[TD][/TD]
[TD="align: right"]11/5/2014[/TD]
[TD="align: right"]4.32%[/TD]
[/TR]
[TR]
[TD="align: right"]11/3/2015[/TD]
[TD="align: right"]2102.63[/TD]
[TD="align: right"]2116.48[/TD]
[TD="align: right"]2097.51[/TD]
[TD="align: right"]11/3/2015[/TD]
[TD="align: right"]2109.79[/TD]
[TD][/TD]
[TD="align: right"]11/4/2014[/TD]
[TD="align: right"]4.66%[/TD]
[/TR]
[TR]
[TD="align: right"]11/2/2015[/TD]
[TD="align: right"]2080.76[/TD]
[TD="align: right"]2106.2[/TD]
[TD="align: right"]2080.76[/TD]
[TD="align: right"]11/2/2015[/TD]
[TD="align: right"]2104.05[/TD]
[TD][/TD]
[TD="align: right"]11/3/2014[/TD]
[TD="align: right"]4.25%[/TD]
[/TR]
[TR]
[TD="align: right"]10/30/2015[/TD]
[TD="align: right"]2090[/TD]
[TD="align: right"]2094.32[/TD]
[TD="align: right"]2079.34[/TD]
[TD="align: right"]10/30/2015[/TD]
[TD="align: right"]2079.36[/TD]
[TD][/TD]
[TD="align: right"]10/31/2014[/TD]
[TD="align: right"]3.91%[/TD]
[/TR]
[TR]
[TD="align: right"]10/29/2015[/TD]
[TD="align: right"]2088.35[/TD]
[TD="align: right"]2092.52[/TD]
[TD="align: right"]2082.63[/TD]
[TD="align: right"]10/29/2015[/TD]
[TD="align: right"]2089.41[/TD]
[TD][/TD]
[TD="align: right"]10/30/2014[/TD]
[TD="align: right"]5.55%[/TD]
[/TR]
[TR]
[TD="align: right"]10/28/2015[/TD]
[TD="align: right"]2066.48[/TD]
[TD="align: right"]2090.35[/TD]
[TD="align: right"]2063.11[/TD]
[TD="align: right"]10/28/2015[/TD]
[TD="align: right"]2090.35[/TD]
[TD][/TD]
[TD="align: right"]10/29/2014[/TD]
[TD="align: right"]5.40%[/TD]
[/TR]
[TR]
[TD="align: right"]10/27/2015[/TD]
[TD="align: right"]2068.75[/TD]
[TD="align: right"]2070.37[/TD]
[TD="align: right"]2058.84[/TD]
[TD="align: right"]10/27/2015[/TD]
[TD="align: right"]2065.89[/TD]
[TD][/TD]
[TD="align: right"]10/28/2014[/TD]
[TD="align: right"]5.18%[/TD]
[/TR]
[TR]
[TD="align: right"]10/26/2015[/TD]
[TD="align: right"]2075.08[/TD]
[TD="align: right"]2075.14[/TD]
[TD="align: right"]2066.53[/TD]
[TD="align: right"]10/26/2015[/TD]
[TD="align: right"]2071.18[/TD]
[TD][/TD]
[TD="align: right"]10/27/2014[/TD]
[TD="align: right"]5.51%[/TD]
[/TR]
[TR]
[TD="align: right"]10/23/2015[/TD]
[TD="align: right"]2058.19[/TD]
[TD="align: right"]2079.74[/TD]
[TD="align: right"]2058.19[/TD]
[TD="align: right"]10/23/2015[/TD]
[TD="align: right"]2075.15[/TD]
[TD][/TD]
[TD="align: right"]10/24/2014[/TD]
[TD="align: right"]6.33%[/TD]
[/TR]
[TR]
[TD="align: right"]10/22/2015[/TD]
[TD="align: right"]2021.88[/TD]
[TD="align: right"]2055.2[/TD]
[TD="align: right"]2021.88[/TD]
[TD="align: right"]10/22/2015[/TD]
[TD="align: right"]2052.51[/TD]
[TD][/TD]
[TD="align: right"]10/23/2014[/TD]
[TD="align: right"]6.29%[/TD]
[/TR]
[TR]
[TD="align: right"]10/21/2015[/TD]
[TD="align: right"]2033.47[/TD]
[TD="align: right"]2037.97[/TD]
[TD="align: right"]2017.22[/TD]
[TD="align: right"]10/21/2015[/TD]
[TD="align: right"]2018.94[/TD]
[TD][/TD]
[TD="align: right"]10/22/2014[/TD]
[TD="align: right"]4.00%[/TD]
[/TR]
[TR]
[TD="align: right"]10/20/2015[/TD]
[TD="align: right"]2033.13[/TD]
[TD="align: right"]2039.12[/TD]
[TD="align: right"]2026.61[/TD]
[TD="align: right"]10/20/2015[/TD]
[TD="align: right"]2030.77[/TD]
[TD][/TD]
[TD="align: right"]10/21/2014[/TD]
[TD="align: right"]6.36%[/TD]
[/TR]
[TR]
[TD="align: right"]10/19/2015[/TD]
[TD="align: right"]2031.73[/TD]
[TD="align: right"]2034.45[/TD]
[TD="align: right"]2022.31[/TD]
[TD="align: right"]10/19/2015[/TD]
[TD="align: right"]2033.66[/TD]
[TD][/TD]
[TD="align: right"]10/20/2014[/TD]
[TD="align: right"]7.85%[/TD]
[/TR]
[TR]
[TD="align: right"]10/16/2015[/TD]
[TD="align: right"]2024.37[/TD]
[TD="align: right"]2033.54[/TD]
[TD="align: right"]2020.46[/TD]
[TD="align: right"]10/16/2015[/TD]
[TD="align: right"]2033.11[/TD]
[TD][/TD]
[TD="align: right"]10/17/2014[/TD]
[TD="align: right"]9.02%[/TD]
[/TR]
[TR]
[TD="align: right"]10/15/2015[/TD]
[TD="align: right"]1996.47[/TD]
[TD="align: right"]2024.15[/TD]
[TD="align: right"]1996.47[/TD]
[TD="align: right"]10/15/2015[/TD]
[TD="align: right"]2023.86[/TD]
[TD][/TD]
[TD="align: right"]10/16/2014[/TD]
[TD="align: right"]9.05%[/TD]
[/TR]
[TR]
[TD="align: right"]10/14/2015[/TD]
[TD="align: right"]2003.66[/TD]
[TD="align: right"]2009.56[/TD]
[TD="align: right"]1990.73[/TD]
[TD="align: right"]10/14/2015[/TD]
[TD="align: right"]1994.24[/TD]
[TD][/TD]
[TD="align: right"]10/15/2014[/TD]
[TD="align: right"]6.41%[/TD]
[/TR]
[TR]
[TD="align: right"]10/13/2015[/TD]
[TD="align: right"]2015[/TD]
[TD="align: right"]2022.34[/TD]
[TD="align: right"]2001.78[/TD]
[TD="align: right"]10/13/2015[/TD]
[TD="align: right"]2003.69[/TD]
[TD][/TD]
[TD="align: right"]10/14/2014[/TD]
[TD="align: right"]6.74%[/TD]
[/TR]
[TR]
[TD="align: right"]10/12/2015[/TD]
[TD="align: right"]2015.65[/TD]
[TD="align: right"]2018.66[/TD]
[TD="align: right"]2010.55[/TD]
[TD="align: right"]10/12/2015[/TD]
[TD="align: right"]2017.46[/TD]
[TD][/TD]
[TD="align: right"]10/13/2014[/TD]
[TD="align: right"]5.87%[/TD]
[/TR]
[TR]
[TD="align: right"]10/9/2015[/TD]
[TD="align: right"]2013.73[/TD]
[TD="align: right"]2020.13[/TD]
[TD="align: right"]2007.61[/TD]
[TD="align: right"]10/9/2015[/TD]
[TD="align: right"]2014.89[/TD]
[TD][/TD]
[TD="align: right"]10/10/2014[/TD]
[TD="align: right"]4.64%[/TD]
[/TR]
[TR]
[TD="align: right"]10/8/2015[/TD]
[TD="align: right"]1994.01[/TD]
[TD="align: right"]2016.5[/TD]
[TD="align: right"]1987.53[/TD]
[TD="align: right"]10/8/2015[/TD]
[TD="align: right"]2013.43[/TD]
[TD][/TD]
[TD="align: right"]10/9/2014[/TD]
[TD="align: right"]2.33%[/TD]
[/TR]
[TR]
[TD="align: right"]10/7/2015[/TD]
[TD="align: right"]1982.34[/TD]
[TD="align: right"]1999.31[/TD]
[TD="align: right"]1976.44[/TD]
[TD="align: right"]10/7/2015[/TD]
[TD="align: right"]1995.83[/TD]
[TD][/TD]
[TD="align: right"]10/8/2014[/TD]
[TD="align: right"]3.11%[/TD]
[/TR]
[TR]
[TD="align: right"]10/6/2015[/TD]
[TD="align: right"]1986.63[/TD]
[TD="align: right"]1991.62[/TD]
[TD="align: right"]1971.99[/TD]
[TD="align: right"]10/6/2015[/TD]
[TD="align: right"]1979.92[/TD]
[TD][/TD]
[TD="align: right"]10/7/2014[/TD]
[TD="align: right"]0.89%[/TD]
[/TR]
[TR]
[TD="align: right"]10/5/2015[/TD]
[TD="align: right"]1954.33[/TD]
[TD="align: right"]1989.17[/TD]
[TD="align: right"]1954.33[/TD]
[TD="align: right"]10/5/2015[/TD]
[TD="align: right"]1987.05[/TD]
[TD][/TD]
[TD="align: right"]10/6/2014[/TD]
[TD="align: right"]0.86%[/TD]
[/TR]
[TR]
[TD="align: right"]10/2/2015[/TD]
[TD="align: right"]1921.77[/TD]
[TD="align: right"]1951.36[/TD]
[TD="align: right"]1893.7[/TD]
[TD="align: right"]10/2/2015[/TD]
[TD="align: right"]1951.36[/TD]
[TD][/TD]
[TD="align: right"]10/3/2014[/TD]
[TD="align: right"]0.17%[/TD]
[/TR]
[TR]
[TD="align: right"]10/1/2015[/TD]
[TD="align: right"]1919.65[/TD]
[TD="align: right"]1927.21[/TD]
[TD="align: right"]1900.7[/TD]
[TD="align: right"]10/1/2015[/TD]
[TD="align: right"]1923.82[/TD]
[TD][/TD]
[TD="align: right"]10/2/2014[/TD]
[TD="align: right"]-1.13%[/TD]
[/TR]
[TR]
[TD="align: right"]9/30/2015[/TD]
[TD="align: right"]1887.14[/TD]
[TD="align: right"]1920.53[/TD]
[TD="align: right"]1887.14[/TD]
[TD="align: right"]9/30/2015[/TD]
[TD="align: right"]1920.03[/TD]
[TD][/TD]
[TD="align: right"]10/1/2014[/TD]
[TD="align: right"]-2.61%[/TD]
[/TR]
[TR]
[TD="align: right"]9/29/2015[/TD]
[TD="align: right"]1881.9[/TD]
[TD="align: right"]1899.48[/TD]
[TD="align: right"]1871.91[/TD]
[TD="align: right"]9/29/2015[/TD]
[TD="align: right"]1884.09[/TD]
[TD][/TD]
[TD="align: right"]9/30/2014[/TD]
[TD="align: right"]-4.76%[/TD]
[/TR]
[TR]
[TD="align: right"]9/28/2015[/TD]
[TD="align: right"]1929.18[/TD]
[TD="align: right"]1929.18[/TD]
[TD="align: right"]1879.21[/TD]
[TD="align: right"]9/28/2015[/TD]
[TD="align: right"]1881.77[/TD]
[TD][/TD]
[TD="align: right"]9/29/2014[/TD]
[TD="align: right"]-4.91%[/TD]
[/TR]
[TR]
[TD="align: right"]9/25/2015[/TD]
[TD="align: right"]1935.93[/TD]
[TD="align: right"]1952.89[/TD]
[TD="align: right"]1921.5[/TD]
[TD="align: right"]9/25/2015[/TD]
[TD="align: right"]1931.34[/TD]
[TD][/TD]
[TD="align: right"]9/26/2014[/TD]
[TD="align: right"]-1.77%[/TD]
[/TR]
[TR]
[TD="align: right"]9/24/2015[/TD]
[TD="align: right"]1934.81[/TD]
[TD="align: right"]1937.17[/TD]
[TD="align: right"]1908.92[/TD]
[TD="align: right"]9/24/2015[/TD]
[TD="align: right"]1932.24[/TD]
[TD][/TD]
[TD="align: right"]9/25/2014[/TD]
[TD="align: right"]-3.26%[/TD]
[/TR]
[TR]
[TD="align: right"]9/23/2015[/TD]
[TD="align: right"]1943.24[/TD]
[TD="align: right"]1949.52[/TD]
[TD="align: right"]1932.57[/TD]
[TD="align: right"]9/23/2015[/TD]
[TD="align: right"]1938.76[/TD]
[TD][/TD]
[TD="align: right"]9/24/2014[/TD]
[TD="align: right"]-2.25%[/TD]
[/TR]
[TR]
[TD="align: right"]9/22/2015[/TD]
[TD="align: right"]1961.39[/TD]
[TD="align: right"]1961.39[/TD]
[TD="align: right"]1929.22[/TD]
[TD="align: right"]9/22/2015[/TD]
[TD="align: right"]1942.74[/TD]
[TD][/TD]
[TD="align: right"]9/23/2014[/TD]
[TD="align: right"]-2.51%[/TD]
[/TR]
[TR]
[TD="align: right"]9/21/2015[/TD]
[TD="align: right"]1960.84[/TD]
[TD="align: right"]1979.64[/TD]
[TD="align: right"]1955.8[/TD]
[TD="align: right"]9/21/2015[/TD]
[TD="align: right"]1966.97[/TD]
[TD][/TD]
[TD="align: right"]9/22/2014[/TD]
[TD="align: right"]-2.10%[/TD]
[/TR]
[TR]
[TD="align: right"]9/18/2015[/TD]
[TD="align: right"]1989.66[/TD]
[TD="align: right"]1989.66[/TD]
[TD="align: right"]1953.45[/TD]
[TD="align: right"]9/18/2015[/TD]
[TD="align: right"]1958.03[/TD]
[TD][/TD]
[TD="align: right"]9/19/2014[/TD]
[TD="align: right"]-2.72%[/TD]
[/TR]
[TR]
[TD="align: right"]9/17/2015[/TD]
[TD="align: right"]1995.33[/TD]
[TD="align: right"]2020.86[/TD]
[TD="align: right"]1986.73[/TD]
[TD="align: right"]9/17/2015[/TD]
[TD="align: right"]1990.2[/TD]
[TD][/TD]
[TD="align: right"]9/18/2014[/TD]
[TD="align: right"]-0.64%[/TD]
[/TR]
[TR]
[TD="align: right"]9/16/2015[/TD]
[TD="align: right"]1978.02[/TD]
[TD="align: right"]1997.26[/TD]
[TD="align: right"]1977.93[/TD]
[TD="align: right"]9/16/2015[/TD]
[TD="align: right"]1995.31[/TD]
[TD][/TD]
[TD="align: right"]9/17/2014[/TD]
[TD="align: right"]-0.20%[/TD]
[/TR]
[TR]
[TD="align: right"]9/15/2015[/TD]
[TD="align: right"]1955.1[/TD]
[TD="align: right"]1983.19[/TD]
[TD="align: right"]1954.3[/TD]
[TD="align: right"]9/15/2015[/TD]
[TD="align: right"]1978.09[/TD]
[TD][/TD]
[TD="align: right"]9/16/2014[/TD]
[TD="align: right"]-0.19%[/TD]
[/TR]
[TR]
[TD="align: right"]9/14/2015[/TD]
[TD="align: right"]1963.06[/TD]
[TD="align: right"]1963.06[/TD]
[TD="align: right"]1948.27[/TD]
[TD="align: right"]9/14/2015[/TD]
[TD="align: right"]1953.03[/TD]
[TD][/TD]
[TD="align: right"]9/15/2014[/TD]
[TD="align: right"]-1.66%[/TD]
[/TR]
[TR]
[TD="align: right"]9/11/2015[/TD]
[TD="align: right"]1951.45[/TD]
[TD="align: right"]1961.05[/TD]
[TD="align: right"]1939.19[/TD]
[TD="align: right"]9/11/2015[/TD]
[TD="align: right"]1961.05[/TD]
[TD][/TD]
[TD="align: right"]9/12/2014[/TD]
[TD="align: right"]-1.79%[/TD]
[/TR]
[TR]
[TD="align: right"]9/10/2015[/TD]
[TD="align: right"]1941.59[/TD]
[TD="align: right"]1965.29[/TD]
[TD="align: right"]1937.19[/TD]
[TD="align: right"]9/10/2015[/TD]
[TD="align: right"]1952.29[/TD]
[TD][/TD]
[TD="align: right"]9/11/2014[/TD]
[TD="align: right"]-2.04%[/TD]
[/TR]
[TR]
[TD="align: right"]9/9/2015[/TD]
[TD="align: right"]1971.45[/TD]
[TD="align: right"]1988.63[/TD]
[TD="align: right"]1937.88[/TD]
[TD="align: right"]9/9/2015[/TD]
[TD="align: right"]1942.04[/TD]
[TD][/TD]
[TD="align: right"]9/10/2014[/TD]
[TD="align: right"]-2.33%[/TD]
[/TR]
[TR]
[TD="align: right"]9/8/2015[/TD]
[TD="align: right"]1927.3[/TD]
[TD="align: right"]1970.42[/TD]
[TD="align: right"]1927.3[/TD]
[TD="align: right"]9/8/2015[/TD]
[TD="align: right"]1969.41[/TD]
[TD][/TD]
[TD="align: right"]9/9/2014[/TD]
[TD="align: right"]-1.57%[/TD]
[/TR]
[TR]
[TD="align: right"]9/4/2015[/TD]
[TD="align: right"]1947.76[/TD]
[TD="align: right"]1947.76[/TD]
[TD="align: right"]1911.21[/TD]
[TD="align: right"]9/4/2015[/TD]
[TD="align: right"]1921.22[/TD]
[TD][/TD]
[TD="align: right"]9/5/2014[/TD]
[TD="align: right"]-3.84%[/TD]
[/TR]
[TR]
[TD="align: right"]9/3/2015[/TD]
[TD="align: right"]1950.79[/TD]
[TD="align: right"]1975.01[/TD]
[TD="align: right"]1944.72[/TD]
[TD="align: right"]9/3/2015[/TD]
[TD="align: right"]1951.13[/TD]
[TD][/TD]
[TD="align: right"]9/4/2014[/TD]
[TD="align: right"]-2.52%[/TD]
[/TR]
[TR]
[TD="align: right"]9/2/2015[/TD]
[TD="align: right"]1916.52[/TD]
[TD="align: right"]1948.91[/TD]
[TD="align: right"]1916.52[/TD]
[TD="align: right"]9/2/2015[/TD]
[TD="align: right"]1948.86[/TD]
[TD][/TD]
[TD="align: right"]9/3/2014[/TD]
[TD="align: right"]-2.73%[/TD]
[/TR]
[TR]
[TD="align: right"]9/1/2015[/TD]
[TD="align: right"]1970.09[/TD]
[TD="align: right"]1970.09[/TD]
[TD="align: right"]1903.07[/TD]
[TD="align: right"]9/1/2015[/TD]
[TD="align: right"]1913.85[/TD]
[TD][/TD]
[TD="align: right"]9/2/2014[/TD]
[TD="align: right"]-4.50%[/TD]
[/TR]
[TR]
[TD="align: right"]8/31/2015[/TD]
[TD="align: right"]1986.73[/TD]
[TD="align: right"]1986.73[/TD]
[TD="align: right"]1965.98[/TD]
[TD="align: right"]8/31/2015[/TD]
[TD="align: right"]1972.18[/TD]
[TD][/TD]
[TD="align: right"]9/1/2014[/TD]
[TD="align: center"]#N/A[/TD]
[/TR]
[TR]
[TD="align: right"]8/28/2015[/TD]
[TD="align: right"]1986.06[/TD]
[TD="align: right"]1993.48[/TD]
[TD="align: right"]1975.19[/TD]
[TD="align: right"]8/28/2015[/TD]
[TD="align: right"]1988.87[/TD]
[TD][/TD]
[TD="align: right"]8/29/2014[/TD]
[TD="align: right"]-0.48%[/TD]
[/TR]
[TR]
[TD="align: right"]8/27/2015[/TD]
[TD="align: right"]1942.77[/TD]
[TD="align: right"]1989.6[/TD]
[TD="align: right"]1942.77[/TD]
[TD="align: right"]8/27/2015[/TD]
[TD="align: right"]1987.66[/TD]
[TD][/TD]
[TD="align: right"]8/28/2014[/TD]
[TD="align: right"]-0.49%[/TD]
[/TR]
[TR]
[TD="align: right"]8/26/2015[/TD]
[TD="align: right"]1872.75[/TD]
[TD="align: right"]1943.09[/TD]
[TD="align: right"]1872.75[/TD]
[TD="align: right"]8/26/2015[/TD]
[TD="align: right"]1940.51[/TD]
[TD][/TD]
[TD="align: right"]8/27/2014[/TD]
[TD="align: right"]-3.00%[/TD]
[/TR]
[TR]
[TD="align: right"]8/25/2015[/TD]
[TD="align: right"]1898.08[/TD]
[TD="align: right"]1948.04[/TD]
[TD="align: right"]1867.08[/TD]
[TD="align: right"]8/25/2015[/TD]
[TD="align: right"]1867.61[/TD]
[TD][/TD]
[TD="align: right"]8/26/2014[/TD]
[TD="align: right"]-6.55%[/TD]
[/TR]
[TR]
[TD="align: right"]8/24/2015[/TD]
[TD="align: right"]1965.15[/TD]
[TD="align: right"]1965.15[/TD]
[TD="align: right"]1867.01[/TD]
[TD="align: right"]8/24/2015[/TD]
[TD="align: right"]1893.21[/TD]
[TD][/TD]
[TD="align: right"]8/25/2014[/TD]
[TD="align: right"]-4.95%[/TD]
[/TR]
[TR]
[TD="align: right"]8/21/2015[/TD]
[TD="align: right"]2034.08[/TD]
[TD="align: right"]2034.08[/TD]
[TD="align: right"]1970.89[/TD]
[TD="align: right"]8/21/2015[/TD]
[TD="align: right"]1970.89[/TD]
[TD][/TD]
[TD="align: right"]8/22/2014[/TD]
[TD="align: right"]-1.09%[/TD]
[/TR]
[TR]
[TD="align: right"]8/20/2015[/TD]
[TD="align: right"]2076.61[/TD]
[TD="align: right"]2076.61[/TD]
[TD="align: right"]2035.73[/TD]
[TD="align: right"]8/20/2015[/TD]
[TD="align: right"]2035.73[/TD]
[TD][/TD]
[TD="align: right"]8/21/2014[/TD]
[TD="align: right"]2.46%[/TD]
[/TR]
[TR]
[TD="align: right"]8/19/2015[/TD]
[TD="align: right"]2095.69[/TD]
[TD="align: right"]2096.17[/TD]
[TD="align: right"]2070.53[/TD]
[TD="align: right"]8/19/2015[/TD]
[TD="align: right"]2079.61[/TD]
[TD][/TD]
[TD="align: right"]8/20/2014[/TD]
[TD="align: right"]5.01%[/TD]
[/TR]
[TR]
[TD="align: right"]8/18/2015[/TD]
[TD="align: right"]2101.99[/TD]
[TD="align: right"]2103.47[/TD]
[TD="align: right"]2094.14[/TD]
[TD="align: right"]8/18/2015[/TD]
[TD="align: right"]2096.92[/TD]
[TD][/TD]
[TD="align: right"]8/19/2014[/TD]
[TD="align: right"]6.30%[/TD]
[/TR]
[TR]
[TD="align: right"]8/17/2015[/TD]
[TD="align: right"]2089.7[/TD]
[TD="align: right"]2102.87[/TD]
[TD="align: right"]2079.3[/TD]
[TD="align: right"]8/17/2015[/TD]
[TD="align: right"]2102.44[/TD]
[TD][/TD]
[TD="align: right"]8/18/2014[/TD]
[TD="align: right"]7.36%[/TD]
[/TR]
[TR]
[TD="align: right"]8/14/2015[/TD]
[TD="align: right"]2083.15[/TD]
[TD="align: right"]2092.45[/TD]
[TD="align: right"]2080.61[/TD]
[TD="align: right"]8/14/2015[/TD]
[TD="align: right"]2091.54[/TD]
[TD][/TD]
[TD="align: right"]8/15/2014[/TD]
[TD="align: right"]6.77%[/TD]
[/TR]
[TR]
[TD="align: right"]8/13/2015[/TD]
[TD="align: right"]2086.19[/TD]
[TD="align: right"]2092.93[/TD]
[TD="align: right"]2078.26[/TD]
[TD="align: right"]8/13/2015[/TD]
[TD="align: right"]2083.39[/TD]
[TD][/TD]
[TD="align: right"]8/14/2014[/TD]
[TD="align: right"]6.98%[/TD]
[/TR]
[TR]
[TD="align: right"]8/12/2015[/TD]
[TD="align: right"]2081.1[/TD]
[TD="align: right"]2089.06[/TD]
[TD="align: right"]2052.09[/TD]
[TD="align: right"]8/12/2015[/TD]
[TD="align: right"]2086.05[/TD]
[TD][/TD]
[TD="align: right"]8/13/2014[/TD]
[TD="align: right"]7.77%[/TD]
[/TR]
[TR]
[TD="align: right"]8/11/2015[/TD]
[TD="align: right"]2102.66[/TD]
[TD="align: right"]2102.66[/TD]
[TD="align: right"]2076.49[/TD]
[TD="align: right"]8/11/2015[/TD]
[TD="align: right"]2084.07[/TD]
[TD][/TD]
[TD="align: right"]8/12/2014[/TD]
[TD="align: right"]7.66%[/TD]
[/TR]
[TR]
[TD="align: right"]8/10/2015[/TD]
[TD="align: right"]2080.98[/TD]
[TD="align: right"]2105.35[/TD]
[TD="align: right"]2080.98[/TD]
[TD="align: right"]8/10/2015[/TD]
[TD="align: right"]2104.18[/TD]
[TD][/TD]
[TD="align: right"]8/11/2014[/TD]
[TD="align: right"]8.83%[/TD]
[/TR]
[TR]
[TD="align: right"]8/7/2015[/TD]
[TD="align: right"]2082.61[/TD]
[TD="align: right"]2082.61[/TD]
[TD="align: right"]2067.91[/TD]
[TD="align: right"]8/7/2015[/TD]
[TD="align: right"]2077.57[/TD]
[TD][/TD]
[TD="align: right"]8/8/2014[/TD]
[TD="align: right"]8.75%[/TD]
[/TR]
[TR]
[TD="align: right"]8/6/2015[/TD]
[TD="align: right"]2100.75[/TD]
[TD="align: right"]2103.32[/TD]
[TD="align: right"]2075.53[/TD]
[TD="align: right"]8/6/2015[/TD]
[TD="align: right"]2083.56[/TD]
[TD][/TD]
[TD="align: right"]8/7/2014[/TD]
[TD="align: right"]8.35%[/TD]
[/TR]
[TR]
[TD="align: right"]8/5/2015[/TD]
[TD="align: right"]2095.27[/TD]
[TD="align: right"]2112.66[/TD]
[TD="align: right"]2095.27[/TD]
[TD="align: right"]8/5/2015[/TD]
[TD="align: right"]2099.84[/TD]
[TD][/TD]
[TD="align: right"]8/6/2014[/TD]
[TD="align: right"]9.52%[/TD]
[/TR]
[TR]
[TD="align: right"]8/4/2015[/TD]
[TD="align: right"]2097.68[/TD]
[TD="align: right"]2102.51[/TD]
[TD="align: right"]2088.6[/TD]
[TD="align: right"]8/4/2015[/TD]
[TD="align: right"]2093.32[/TD]
[TD][/TD]
[TD="align: right"]8/5/2014[/TD]
[TD="align: right"]8.11%[/TD]
[/TR]
[TR]
[TD="align: right"]8/3/2015[/TD]
[TD="align: right"]2104.49[/TD]
[TD="align: right"]2105.7[/TD]
[TD="align: right"]2087.31[/TD]
[TD="align: right"]8/3/2015[/TD]
[TD="align: right"]2098.04[/TD]
[TD][/TD]
[TD="align: right"]8/4/2014[/TD]
[TD="align: right"]8.90%[/TD]
[/TR]
[TR]
[TD="align: right"]7/31/2015[/TD]
[TD="align: right"]2111.6[/TD]
[TD="align: right"]2114.24[/TD]
[TD="align: right"]2102.07[/TD]
[TD="align: right"]7/31/2015[/TD]
[TD="align: right"]2103.84[/TD]
[TD][/TD]
[TD="align: right"]8/1/2014[/TD]
[TD="align: right"]9.02%[/TD]
[/TR]
[TR]
[TD="align: right"]7/30/2015[/TD]
[TD="align: right"]2106.78[/TD]
[TD="align: right"]2110.48[/TD]
[TD="align: right"]2094.97[/TD]
[TD="align: right"]7/30/2015[/TD]
[TD="align: right"]2108.63[/TD]
[TD][/TD]
[TD="align: right"]7/31/2014[/TD]
[TD="align: right"]7.30%[/TD]
[/TR]
[TR]
[TD="align: right"]7/29/2015[/TD]
[TD="align: right"]2094.7[/TD]
[TD="align: right"]2110.6[/TD]
[TD="align: right"]2094.08[/TD]
[TD="align: right"]7/29/2015[/TD]
[TD="align: right"]2108.57[/TD]
[TD][/TD]
[TD="align: right"]7/30/2014[/TD]
[TD="align: right"]6.86%[/TD]
[/TR]
[TR]
[TD="align: right"]7/28/2015[/TD]
[TD="align: right"]2070.75[/TD]
[TD="align: right"]2095.6[/TD]
[TD="align: right"]2069.09[/TD]
[TD="align: right"]7/28/2015[/TD]
[TD="align: right"]2093.25[/TD]
[TD][/TD]
[TD="align: right"]7/29/2014[/TD]
[TD="align: right"]5.72%[/TD]
[/TR]
[TR]
[TD="align: right"]7/27/2015[/TD]
[TD="align: right"]2078.19[/TD]
[TD="align: right"]2078.19[/TD]
[TD="align: right"]2063.52[/TD]
[TD="align: right"]7/27/2015[/TD]
[TD="align: right"]2067.64[/TD]
[TD][/TD]
[TD="align: right"]7/28/2014[/TD]
[TD="align: right"]4.52%[/TD]
[/TR]
[TR]
[TD="align: right"]7/24/2015[/TD]
[TD="align: right"]2102.24[/TD]
[TD="align: right"]2106.01[/TD]
[TD="align: right"]2077.09[/TD]
[TD="align: right"]7/24/2015[/TD]
[TD="align: right"]2079.65[/TD]
[TD][/TD]
[TD="align: right"]7/25/2014[/TD]
[TD="align: right"]4.79%[/TD]
[/TR]
[TR]
[TD="align: right"]7/23/2015[/TD]
[TD="align: right"]2114.16[/TD]
[TD="align: right"]2116.87[/TD]
[TD="align: right"]2098.63[/TD]
[TD="align: right"]7/23/2015[/TD]
[TD="align: right"]2102.15[/TD]
[TD][/TD]
[TD="align: right"]7/24/2014[/TD]
[TD="align: right"]5.74%[/TD]
[/TR]
[TR]
[TD="align: right"]7/22/2015[/TD]
[TD="align: right"]2118.21[/TD]
[TD="align: right"]2118.51[/TD]
[TD="align: right"]2110[/TD]
[TD="align: right"]7/22/2015[/TD]
[TD="align: right"]2114.15[/TD]
[TD][/TD]
[TD="align: right"]7/23/2014[/TD]
[TD="align: right"]6.49%[/TD]
[/TR]
[TR]
[TD="align: right"]7/21/2015[/TD]
[TD="align: right"]2127.55[/TD]
[TD="align: right"]2128.49[/TD]
[TD="align: right"]2115.4[/TD]
[TD="align: right"]7/21/2015[/TD]
[TD="align: right"]2119.21[/TD]
[TD][/TD]
[TD="align: right"]7/22/2014[/TD]
[TD="align: right"]7.27%[/TD]
[/TR]
[TR]
[TD="align: right"]7/20/2015[/TD]
[TD="align: right"]2126.85[/TD]
[TD="align: right"]2132.82[/TD]
[TD="align: right"]2123.66[/TD]
[TD="align: right"]7/20/2015[/TD]
[TD="align: right"]2128.28[/TD]
[TD][/TD]
[TD="align: right"]7/21/2014[/TD]
[TD="align: right"]7.66%[/TD]
[/TR]
[TR]
[TD="align: right"]7/17/2015[/TD]
[TD="align: right"]2126.8[/TD]
[TD="align: right"]2128.91[/TD]
[TD="align: right"]2119.88[/TD]
[TD="align: right"]7/17/2015[/TD]
[TD="align: right"]2126.64[/TD]
[TD][/TD]
[TD="align: right"]7/18/2014[/TD]
[TD="align: right"]8.42%[/TD]
[/TR]
[TR]
[TD="align: right"]7/16/2015[/TD]
[TD="align: right"]2110.55[/TD]
[TD="align: right"]2124.42[/TD]
[TD="align: right"]2110.55[/TD]
[TD="align: right"]7/16/2015[/TD]
[TD="align: right"]2124.29[/TD]
[TD][/TD]
[TD="align: right"]7/17/2014[/TD]
[TD="align: right"]7.30%[/TD]
[/TR]
[TR]
[TD="align: right"]7/15/2015[/TD]
[TD="align: right"]2109.01[/TD]
[TD="align: right"]2114.14[/TD]
[TD="align: right"]2102.49[/TD]
[TD="align: right"]7/15/2015[/TD]
[TD="align: right"]2107.4[/TD]
[TD][/TD]
[TD="align: right"]7/16/2014[/TD]
[TD="align: right"]6.63%[/TD]
[/TR]
[TR]
[TD="align: right"]7/14/2015[/TD]
[TD="align: right"]2099.72[/TD]
[TD="align: right"]2111.98[/TD]
[TD="align: right"]2098.18[/TD]
[TD="align: right"]7/14/2015[/TD]
[TD="align: right"]2108.95[/TD]
[TD][/TD]
[TD="align: right"]7/15/2014[/TD]
[TD="align: right"]6.65%[/TD]
[/TR]
[TR]
[TD="align: right"]7/13/2015[/TD]
[TD="align: right"]2080.03[/TD]
[TD="align: right"]2100.67[/TD]
[TD="align: right"]2080.03[/TD]
[TD="align: right"]7/13/2015[/TD]
[TD="align: right"]2099.6[/TD]
[TD][/TD]
[TD="align: right"]7/14/2014[/TD]
[TD="align: right"]6.59%[/TD]
[/TR]
[TR]
[TD="align: right"]7/10/2015[/TD]
[TD="align: right"]2052.74[/TD]
[TD="align: right"]2081.31[/TD]
[TD="align: right"]2052.74[/TD]
[TD="align: right"]7/10/2015[/TD]
[TD="align: right"]2076.62[/TD]
[TD][/TD]
[TD="align: right"]7/11/2014[/TD]
[TD="align: right"]5.64%[/TD]
[/TR]
[TR]
[TD="align: right"]7/9/2015[/TD]
[TD="align: right"]2049.73[/TD]
[TD="align: right"]2074.28[/TD]
[TD="align: right"]2049.73[/TD]
[TD="align: right"]7/9/2015[/TD]
[TD="align: right"]2051.31[/TD]
[TD][/TD]
[TD="align: right"]7/10/2014[/TD]
[TD="align: right"]4.30%[/TD]
[/TR]
[TR]
[TD="align: right"]7/8/2015[/TD]
[TD="align: right"]2077.66[/TD]
[TD="align: right"]2077.66[/TD]
[TD="align: right"]2044.66[/TD]
[TD="align: right"]7/8/2015[/TD]
[TD="align: right"]2046.68[/TD]
[TD][/TD]
[TD="align: right"]7/9/2014[/TD]
[TD="align: right"]4.15%[/TD]
[/TR]
[TR]
[TD="align: right"]7/7/2015[/TD]
[TD="align: right"]2069.52[/TD]
[TD="align: right"]2083.74[/TD]
[TD="align: right"]2044.02[/TD]
[TD="align: right"]7/7/2015[/TD]
[TD="align: right"]2081.34[/TD]
[TD][/TD]
[TD="align: right"]7/8/2014[/TD]
[TD="align: right"]5.31%[/TD]
[/TR]
[TR]
[TD="align: right"]7/6/2015[/TD]
[TD="align: right"]2073.95[/TD]
[TD="align: right"]2078.61[/TD]
[TD="align: right"]2058.4[/TD]
[TD="align: right"]7/6/2015[/TD]
[TD="align: right"]2068.76[/TD]
[TD][/TD]
[TD="align: right"]7/7/2014[/TD]
[TD="align: right"]4.26%[/TD]
[/TR]
[TR]
[TD="align: right"]7/2/2015[/TD]
[TD="align: right"]2078.03[/TD]
[TD="align: right"]2085.06[/TD]
[TD="align: right"]2071.02[/TD]
[TD="align: right"]7/2/2015[/TD]
[TD="align: right"]2076.78[/TD]
[TD][/TD]
[TD="align: right"]7/3/2014[/TD]
[TD="align: right"]5.11%[/TD]
[/TR]
[TR]
[TD="align: right"]7/1/2015[/TD]
[TD="align: right"]2067[/TD]
[TD="align: right"]2082.78[/TD]
[TD="align: right"]2067[/TD]
[TD="align: right"]7/1/2015[/TD]
[TD="align: right"]2077.42[/TD]
[TD][/TD]
[TD="align: right"]7/2/2014[/TD]
[TD="align: right"]5.29%[/TD]
[/TR]
[TR]
[TD="align: right"]6/30/2015[/TD]
[TD="align: right"]2061.19[/TD]
[TD="align: right"]2074.28[/TD]
[TD="align: right"]2056.32[/TD]
[TD="align: right"]6/30/2015[/TD]
[TD="align: right"]2063.11[/TD]
[TD][/TD]
[TD="align: right"]7/1/2014[/TD]
[TD="align: right"]5.14%[/TD]
[/TR]
[TR]
[TD="align: right"]6/29/2015[/TD]
[TD="align: right"]2098.63[/TD]
[TD="align: right"]2098.63[/TD]
[TD="align: right"]2056.64[/TD]
[TD="align: right"]6/29/2015[/TD]
[TD="align: right"]2057.64[/TD]
[TD][/TD]
[TD="align: right"]6/30/2014[/TD]
[TD="align: right"]4.94%[/TD]
[/TR]
[TR]
[TD="align: right"]6/26/2015[/TD]
[TD="align: right"]2102.62[/TD]
[TD="align: right"]2108.92[/TD]
[TD="align: right"]2095.38[/TD]
[TD="align: right"]6/26/2015[/TD]
[TD="align: right"]2101.49[/TD]
[TD][/TD]
[TD="align: right"]6/27/2014[/TD]
[TD="align: right"]7.41%[/TD]
[/TR]
[TR]
[TD="align: right"]6/25/2015[/TD]
[TD="align: right"]2109.96[/TD]
[TD="align: right"]2116.04[/TD]
[TD="align: right"]2101.78[/TD]
[TD="align: right"]6/25/2015[/TD]
[TD="align: right"]2102.31[/TD]
[TD][/TD]
[TD="align: right"]6/26/2014[/TD]
[TD="align: right"]7.27%[/TD]
[/TR]
[TR]
[TD="align: right"]6/24/2015[/TD]
[TD="align: right"]2123.65[/TD]
[TD="align: right"]2125.1[/TD]
[TD="align: right"]2108.58[/TD]
[TD="align: right"]6/24/2015[/TD]
[TD="align: right"]2108.58[/TD]
[TD][/TD]
[TD="align: right"]6/25/2014[/TD]
[TD="align: right"]8.17%[/TD]
[/TR]
[TR]
[TD="align: right"]6/23/2015[/TD]
[TD="align: right"]2123.16[/TD]
[TD="align: right"]2128.03[/TD]
[TD="align: right"]2119.89[/TD]
[TD="align: right"]6/23/2015[/TD]
[TD="align: right"]2124.2[/TD]
[TD][/TD]
[TD="align: right"]6/24/2014[/TD]
[TD="align: right"]8.27%[/TD]
[/TR]
[TR]
[TD="align: right"]6/22/2015[/TD]
[TD="align: right"]2112.5[/TD]
[TD="align: right"]2129.87[/TD]
[TD="align: right"]2112.5[/TD]
[TD="align: right"]6/22/2015[/TD]
[TD="align: right"]2122.85[/TD]
[TD][/TD]
[TD="align: right"]6/23/2014[/TD]
[TD="align: right"]8.15%[/TD]
[/TR]
[TR]
[TD="align: right"]6/19/2015[/TD]
[TD="align: right"]2121.06[/TD]
[TD="align: right"]2121.64[/TD]
[TD="align: right"]2109.45[/TD]
[TD="align: right"]6/19/2015[/TD]
[TD="align: right"]2109.99[/TD]
[TD][/TD]
[TD="align: right"]6/20/2014[/TD]
[TD="align: right"]7.63%[/TD]
[/TR]
[TR]
[TD="align: right"]6/18/2015[/TD]
[TD="align: right"]2101.58[/TD]
[TD="align: right"]2126.65[/TD]
[TD="align: right"]2101.58[/TD]
[TD="align: right"]6/18/2015[/TD]
[TD="align: right"]2121.24[/TD]
[TD][/TD]
[TD="align: right"]6/19/2014[/TD]
[TD="align: right"]8.36%[/TD]
[/TR]
[TR]
[TD="align: right"]6/17/2015[/TD]
[TD="align: right"]2097.4[/TD]
[TD="align: right"]2106.79[/TD]
[TD="align: right"]2088.86[/TD]
[TD="align: right"]6/17/2015[/TD]
[TD="align: right"]2100.44[/TD]
[TD][/TD]
[TD="align: right"]6/18/2014[/TD]
[TD="align: right"]8.12%[/TD]
[/TR]
[TR]
[TD="align: right"]6/16/2015[/TD]
[TD="align: right"]2084.26[/TD]
[TD="align: right"]2097.4[/TD]
[TD="align: right"]2082.1[/TD]
[TD="align: right"]6/16/2015[/TD]
[TD="align: right"]2096.29[/TD]
[TD][/TD]
[TD="align: right"]6/17/2014[/TD]
[TD="align: right"]8.22%[/TD]
[/TR]
[TR]
[TD="align: right"]6/15/2015[/TD]
[TD="align: right"]2091.34[/TD]
[TD="align: right"]2091.34[/TD]
[TD="align: right"]2072.49[/TD]
[TD="align: right"]6/15/2015[/TD]
[TD="align: right"]2084.43[/TD]
[TD][/TD]
[TD="align: right"]6/16/2014[/TD]
[TD="align: right"]7.73%[/TD]
[/TR]
[TR]
[TD="align: right"]6/12/2015[/TD]
[TD="align: right"]2107.43[/TD]
[TD="align: right"]2107.43[/TD]
[TD="align: right"]2091.33[/TD]
[TD="align: right"]6/12/2015[/TD]
[TD="align: right"]2094.11[/TD]
[TD][/TD]
[TD="align: right"]6/13/2014[/TD]
[TD="align: right"]8.46%[/TD]
[/TR]
[TR]
[TD="align: right"]6/11/2015[/TD]
[TD="align: right"]2106.24[/TD]
[TD="align: right"]2115.02[/TD]
[TD="align: right"]2106.24[/TD]
[TD="align: right"]6/11/2015[/TD]
[TD="align: right"]2108.86[/TD]
[TD][/TD]
[TD="align: right"]6/12/2014[/TD]
[TD="align: right"]8.52%[/TD]
[/TR]
[TR]
[TD="align: right"]6/10/2015[/TD]
[TD="align: right"]2081.12[/TD]
[TD="align: right"]2108.5[/TD]
[TD="align: right"]2081.12[/TD]
[TD="align: right"]6/10/2015[/TD]
[TD="align: right"]2105.2[/TD]
[TD][/TD]
[TD="align: right"]6/11/2014[/TD]
[TD="align: right"]7.99%[/TD]
[/TR]
[TR]
[TD="align: right"]6/9/2015[/TD]
[TD="align: right"]2079.07[/TD]
[TD="align: right"]2085.62[/TD]
[TD="align: right"]2072.14[/TD]
[TD="align: right"]6/9/2015[/TD]
[TD="align: right"]2080.15[/TD]
[TD][/TD]
[TD="align: right"]6/10/2014[/TD]
[TD="align: right"]6.66%[/TD]
[/TR]
[TR]
[TD="align: right"]6/8/2015[/TD]
[TD="align: right"]2092.34[/TD]
[TD="align: right"]2093.01[/TD]
[TD="align: right"]2079.11[/TD]
[TD="align: right"]6/8/2015[/TD]
[TD="align: right"]2079.28[/TD]
[TD][/TD]
[TD="align: right"]6/9/2014[/TD]
[TD="align: right"]6.69%[/TD]
[/TR]
[TR]
[TD="align: right"]6/5/2015[/TD]
[TD="align: right"]2095.09[/TD]
[TD="align: right"]2100.99[/TD]
[TD="align: right"]2085.67[/TD]
[TD="align: right"]6/5/2015[/TD]
[TD="align: right"]2092.83[/TD]
[TD][/TD]
[TD="align: right"]6/6/2014[/TD]
[TD="align: right"]7.74%[/TD]
[/TR]
[TR]
[TD="align: right"]6/4/2015[/TD]
[TD="align: right"]2112.35[/TD]
[TD="align: right"]2112.89[/TD]
[TD="align: right"]2093.23[/TD]
[TD="align: right"]6/4/2015[/TD]
[TD="align: right"]2095.84[/TD]
[TD][/TD]
[TD="align: right"]6/5/2014[/TD]
[TD="align: right"]8.68%[/TD]
[/TR]
[TR]
[TD="align: right"]6/3/2015[/TD]
[TD="align: right"]2110.64[/TD]
[TD="align: right"]2121.92[/TD]
[TD="align: right"]2109.61[/TD]
[TD="align: right"]6/3/2015[/TD]
[TD="align: right"]2114.07[/TD]
[TD][/TD]
[TD="align: right"]6/4/2014[/TD]
[TD="align: right"]9.93%[/TD]
[/TR]
[TR]
[TD="align: right"]6/2/2015[/TD]
[TD="align: right"]2110.41[/TD]
[TD="align: right"]2117.59[/TD]
[TD="align: right"]2099.14[/TD]
[TD="align: right"]6/2/2015[/TD]
[TD="align: right"]2109.6[/TD]
[TD][/TD]
[TD="align: right"]6/3/2014[/TD]
[TD="align: right"]9.70%[/TD]
[/TR]
[TR]
[TD="align: right"]6/1/2015[/TD]
[TD="align: right"]2108.64[/TD]
[TD="align: right"]2119.15[/TD]
[TD="align: right"]2102.54[/TD]
[TD="align: right"]6/1/2015[/TD]
[TD="align: right"]2111.73[/TD]
[TD][/TD]
[TD="align: right"]6/2/2014[/TD]
[TD="align: right"]9.76%[/TD]
[/TR]
[TR]
[TD="align: right"]5/29/2015[/TD]
[TD="align: right"]2120.66[/TD]
[TD="align: right"]2120.66[/TD]
[TD="align: right"]2104.89[/TD]
[TD="align: right"]5/29/2015[/TD]
[TD="align: right"]2107.39[/TD]
[TD][/TD]
[TD="align: right"]5/30/2014[/TD]
[TD="align: right"]9.74%[/TD]
[/TR]
[TR]
[TD="align: right"]5/28/2015[/TD]
[TD="align: right"]2122.27[/TD]
[TD="align: right"]2122.27[/TD]
[TD="align: right"]2112.86[/TD]
[TD="align: right"]5/28/2015[/TD]
[TD="align: right"]2120.79[/TD]
[TD][/TD]
[TD="align: right"]5/29/2014[/TD]
[TD="align: right"]11.00%[/TD]
[/TR]
[TR]
[TD="align: right"]5/27/2015[/TD]
[TD="align: right"]2105.13[/TD]
[TD="align: right"]2126.22[/TD]
[TD="align: right"]2105.13[/TD]
[TD="align: right"]5/27/2015[/TD]
[TD="align: right"]2123.48[/TD]
[TD][/TD]
[TD="align: right"]5/28/2014[/TD]
[TD="align: right"]11.07%[/TD]
[/TR]
[TR]
[TD="align: right"]5/26/2015[/TD]
[TD="align: right"]2125.34[/TD]
[TD="align: right"]2125.34[/TD]
[TD="align: right"]2099.18[/TD]
[TD="align: right"]5/26/2015[/TD]
[TD="align: right"]2104.2[/TD]
[TD][/TD]
[TD="align: right"]5/27/2014[/TD]
[TD="align: right"]10.63%[/TD]
[/TR]
[TR]
[TD="align: right"]5/22/2015[/TD]
[TD="align: right"]2130.36[/TD]
[TD="align: right"]2132.15[/TD]
[TD="align: right"]2126.06[/TD]
[TD="align: right"]5/22/2015[/TD]
[TD="align: right"]2126.06[/TD]
[TD][/TD]
[TD="align: right"]5/23/2014[/TD]
[TD="align: right"]12.29%[/TD]
[/TR]
[TR]
[TD="align: right"]5/21/2015[/TD]
[TD="align: right"]2125.55[/TD]
[TD="align: right"]2134.28[/TD]
[TD="align: right"]2122.95[/TD]
[TD="align: right"]5/21/2015[/TD]
[TD="align: right"]2130.82[/TD]
[TD][/TD]
[TD="align: right"]5/22/2014[/TD]
[TD="align: right"]12.85%[/TD]
[/TR]
[TR]
[TD="align: right"]5/20/2015[/TD]
[TD="align: right"]2127.79[/TD]
[TD="align: right"]2134.72[/TD]
[TD="align: right"]2122.59[/TD]
[TD="align: right"]5/20/2015[/TD]
[TD="align: right"]2125.85[/TD]
[TD][/TD]
[TD="align: right"]5/21/2014[/TD]
[TD="align: right"]13.48%[/TD]
[/TR]
[TR]
[TD="align: right"]5/19/2015[/TD]
[TD="align: right"]2129.45[/TD]
[TD="align: right"]2133.02[/TD]
[TD="align: right"]2124.5[/TD]
[TD="align: right"]5/19/2015[/TD]
[TD="align: right"]2127.83[/TD]
[TD][/TD]
[TD="align: right"]5/20/2014[/TD]
[TD="align: right"]12.89%[/TD]
[/TR]
[TR]
[TD="align: right"]5/18/2015[/TD]
[TD="align: right"]2121.3[/TD]
[TD="align: right"]2131.78[/TD]
[TD="align: right"]2120.01[/TD]
[TD="align: right"]5/18/2015[/TD]
[TD="align: right"]2129.2[/TD]
[TD][/TD]
[TD="align: right"]5/19/2014[/TD]
[TD="align: right"]13.46%[/TD]
[/TR]
[TR]
[TD="align: right"]5/15/2015[/TD]
[TD="align: right"]2122.07[/TD]
[TD="align: right"]2123.89[/TD]
[TD="align: right"]2116.81[/TD]
[TD="align: right"]5/15/2015[/TD]
[TD="align: right"]2122.73[/TD]
[TD][/TD]
[TD="align: right"]5/16/2014[/TD]
[TD="align: right"]13.44%[/TD]
[/TR]
[TR]
[TD="align: right"]5/14/2015[/TD]
[TD="align: right"]2100.43[/TD]
[TD="align: right"]2121.45[/TD]
[TD="align: right"]2100.43[/TD]
[TD="align: right"]5/14/2015[/TD]
[TD="align: right"]2121.1[/TD]
[TD][/TD]
[TD="align: right"]5/15/2014[/TD]
[TD="align: right"]12.34%[/TD]
[/TR]
[TR]
[TD="align: right"]5/13/2015[/TD]
[TD="align: right"]2099.62[/TD]
[TD="align: right"]2110.19[/TD]
[TD="align: right"]2096.04[/TD]
[TD="align: right"]5/13/2015[/TD]
[TD="align: right"]2098.48[/TD]
[TD][/TD]
[TD="align: right"]5/14/2014[/TD]
[TD="align: right"]10.61%[/TD]
[/TR]
[TR]
[TD="align: right"]5/12/2015[/TD]
[TD="align: right"]2102.87[/TD]
[TD="align: right"]2105.06[/TD]
[TD="align: right"]2085.57[/TD]
[TD="align: right"]5/12/2015[/TD]
[TD="align: right"]2099.12[/TD]
[TD][/TD]
[TD="align: right"]5/13/2014[/TD]
[TD="align: right"]10.67%[/TD]
[/TR]
[TR]
[TD="align: right"]5/11/2015[/TD]
[TD="align: right"]2115.56[/TD]
[TD="align: right"]2117.69[/TD]
[TD="align: right"]2104.58[/TD]
[TD="align: right"]5/11/2015[/TD]
[TD="align: right"]2105.33[/TD]
[TD][/TD]
[TD="align: right"]5/12/2014[/TD]
[TD="align: right"]11.98%[/TD]
[/TR]
[TR]
[TD="align: right"]5/8/2015[/TD]
[TD="align: right"]2092.13[/TD]
[TD="align: right"]2117.66[/TD]
[TD="align: right"]2092.13[/TD]
[TD="align: right"]5/8/2015[/TD]
[TD="align: right"]2116.1[/TD]
[TD][/TD]
[TD="align: right"]5/9/2014[/TD]
[TD="align: right"]12.84%[/TD]
[/TR]
[TR]
[TD="align: right"]5/7/2015[/TD]
[TD="align: right"]2079.96[/TD]
[TD="align: right"]2092.9[/TD]
[TD="align: right"]2074.99[/TD]
[TD="align: right"]5/7/2015[/TD]
[TD="align: right"]2088[/TD]
[TD][/TD]
[TD="align: right"]5/8/2014[/TD]
[TD="align: right"]11.22%[/TD]
[/TR]
[TR]
[TD="align: right"]5/6/2015[/TD]
[TD="align: right"]2091.26[/TD]
[TD="align: right"]2098.42[/TD]
[TD="align: right"]2067.93[/TD]
[TD="align: right"]5/6/2015[/TD]
[TD="align: right"]2080.15[/TD]
[TD][/TD]
[TD="align: right"]5/7/2014[/TD]
[TD="align: right"]11.33%[/TD]
[/TR]
[TR]
[TD="align: right"]5/5/2015[/TD]
[TD="align: right"]2112.63[/TD]
[TD="align: right"]2115.24[/TD]
[TD="align: right"]2088.46[/TD]
[TD="align: right"]5/5/2015[/TD]
[TD="align: right"]2089.46[/TD]
[TD][/TD]
[TD="align: right"]5/6/2014[/TD]
[TD="align: right"]10.92%[/TD]
[/TR]
[TR]
[TD="align: right"]5/4/2015[/TD]
[TD="align: right"]2110.23[/TD]
[TD="align: right"]2120.95[/TD]
[TD="align: right"]2110.23[/TD]
[TD="align: right"]5/4/2015[/TD]
[TD="align: right"]2114.49[/TD]
[TD][/TD]
[TD="align: right"]5/5/2014[/TD]
[TD="align: right"]12.51%[/TD]
[/TR]
[TR]
[TD="align: right"]5/1/2015[/TD]
[TD="align: right"]2087.38[/TD]
[TD="align: right"]2108.41[/TD]
[TD="align: right"]2087.38[/TD]
[TD="align: right"]5/1/2015[/TD]
[TD="align: right"]2108.29[/TD]
[TD][/TD]
[TD="align: right"]5/2/2014[/TD]
[TD="align: right"]11.83%[/TD]
[/TR]
[TR]
[TD="align: right"]4/30/2015[/TD]
[TD="align: right"]2105.52[/TD]
[TD="align: right"]2105.52[/TD]
[TD="align: right"]2077.59[/TD]
[TD="align: right"]4/30/2015[/TD]
[TD="align: right"]2085.51[/TD]
[TD][/TD]
[TD="align: right"]5/1/2014[/TD]
[TD="align: right"]10.67%[/TD]
[/TR]
[TR]
[TD="align: right"]4/29/2015[/TD]
[TD="align: right"]2112.49[/TD]
[TD="align: right"]2113.65[/TD]
[TD="align: right"]2097.41[/TD]
[TD="align: right"]4/29/2015[/TD]
[TD="align: right"]2106.85[/TD]
[TD][/TD]
[TD="align: right"]4/30/2014[/TD]
[TD="align: right"]12.24%[/TD]
[/TR]
[TR]
[TD="align: right"]4/28/2015[/TD]
[TD="align: right"]2108.35[/TD]
[TD="align: right"]2116.04[/TD]
[TD="align: right"]2094.89[/TD]
[TD="align: right"]4/28/2015[/TD]
[TD="align: right"]2114.76[/TD]
[TD][/TD]
[TD="align: right"]4/29/2014[/TD]
[TD="align: right"]13.04%[/TD]
[/TR]
[TR]
[TD="align: right"]4/27/2015[/TD]
[TD="align: right"]2119.29[/TD]
[TD="align: right"]2125.92[/TD]
[TD="align: right"]2107.04[/TD]
[TD="align: right"]4/27/2015[/TD]
[TD="align: right"]2108.92[/TD]
[TD][/TD]
[TD="align: right"]4/28/2014[/TD]
[TD="align: right"]13.08%[/TD]
[/TR]
[TR]
[TD="align: right"]4/24/2015[/TD]
[TD="align: right"]2112.8[/TD]
[TD="align: right"]2120.92[/TD]
[TD="align: right"]2112.8[/TD]
[TD="align: right"]4/24/2015[/TD]
[TD="align: right"]2117.69[/TD]
[TD][/TD]
[TD="align: right"]4/25/2014[/TD]
[TD="align: right"]12.78%[/TD]
[/TR]
[TR]
[TD="align: right"]4/23/2015[/TD]
[TD="align: right"]2107.21[/TD]
[TD="align: right"]2120.49[/TD]
[TD="align: right"]2103.19[/TD]
[TD="align: right"]4/23/2015[/TD]
[TD="align: right"]2112.93[/TD]
[TD][/TD]
[TD="align: right"]4/24/2014[/TD]
[TD="align: right"]12.27%[/TD]
[/TR]
[TR]
[TD="align: right"]4/22/2015[/TD]
[TD="align: right"]2098.27[/TD]
[TD="align: right"]2109.98[/TD]
[TD="align: right"]2091.05[/TD]
[TD="align: right"]4/22/2015[/TD]
[TD="align: right"]2107.96[/TD]
[TD][/TD]
[TD="align: right"]4/23/2014[/TD]
[TD="align: right"]12.17%[/TD]
[/TR]
[TR]
[TD="align: right"]4/21/2015[/TD]
[TD="align: right"]2102.82[/TD]
[TD="align: right"]2109.64[/TD]
[TD="align: right"]2094.38[/TD]
[TD="align: right"]4/21/2015[/TD]
[TD="align: right"]2097.29[/TD]
[TD][/TD]
[TD="align: right"]4/22/2014[/TD]
[TD="align: right"]12.00%[/TD]
[/TR]
[TR]
[TD="align: right"]4/20/2015[/TD]
[TD="align: right"]2084.11[/TD]
[TD="align: right"]2103.94[/TD]
[TD="align: right"]2084.11[/TD]
[TD="align: right"]4/20/2015[/TD]
[TD="align: right"]2100.4[/TD]
[TD][/TD]
[TD="align: right"]4/21/2014[/TD]
[TD="align: right"]12.57%[/TD]
[/TR]
[TR]
[TD="align: right"]4/17/2015[/TD]
[TD="align: right"]2102.58[/TD]
[TD="align: right"]2102.58[/TD]
[TD="align: right"]2072.37[/TD]
[TD="align: right"]4/17/2015[/TD]
[TD="align: right"]2081.18[/TD]
[TD][/TD]
[TD="align: right"]4/18/2014[/TD]
[TD="align: center"]#N/A[/TD]
[/TR]
[TR]
[TD="align: right"]4/16/2015[/TD]
[TD="align: right"]2105.96[/TD]
[TD="align: right"]2111.3[/TD]
[TD="align: right"]2100.02[/TD]
[TD="align: right"]4/16/2015[/TD]
[TD="align: right"]2104.99[/TD]
[TD][/TD]
[TD="align: right"]4/17/2014[/TD]
[TD="align: right"]13.07%[/TD]
[/TR]
[TR]
[TD="align: right"]4/15/2015[/TD]
[TD="align: right"]2097.82[/TD]
[TD="align: right"]2111.91[/TD]
[TD="align: right"]2097.82[/TD]
[TD="align: right"]4/15/2015[/TD]
[TD="align: right"]2106.63[/TD]
[TD][/TD]
[TD="align: right"]4/16/2014[/TD]
[TD="align: right"]14.12%[/TD]
[/TR]
[TR]
[TD="align: right"]4/14/2015[/TD]
[TD="align: right"]2092.28[/TD]
[TD="align: right"]2098.62[/TD]
[TD="align: right"]2083.24[/TD]
[TD="align: right"]4/14/2015[/TD]
[TD="align: right"]2095.84[/TD]
[TD][/TD]
[TD="align: right"]4/15/2014[/TD]
[TD="align: right"]14.44%[/TD]
[/TR]
[TR]
[TD="align: right"]4/13/2015[/TD]
[TD="align: right"]2102.03[/TD]
[TD="align: right"]2107.65[/TD]
[TD="align: right"]2092.33[/TD]
[TD="align: right"]4/13/2015[/TD]
[TD="align: right"]2092.43[/TD]
[TD][/TD]
[TD="align: right"]4/14/2014[/TD]
[TD="align: right"]15.08%[/TD]
[/TR]
[TR]
[TD="align: right"]4/10/2015[/TD]
[TD="align: right"]2091.51[/TD]
[TD="align: right"]2102.61[/TD]
[TD="align: right"]2091.51[/TD]
[TD="align: right"]4/10/2015[/TD]
[TD="align: right"]2102.06[/TD]
[TD][/TD]
[TD="align: right"]4/11/2014[/TD]
[TD="align: right"]14.83%[/TD]
[/TR]
[TR]
[TD="align: right"]4/9/2015[/TD]
[TD="align: right"]2081.29[/TD]
[TD="align: right"]2093.31[/TD]
[TD="align: right"]2074.29[/TD]
[TD="align: right"]4/9/2015[/TD]
[TD="align: right"]2091.18[/TD]
[TD][/TD]
[TD="align: right"]4/10/2014[/TD]
[TD="align: right"]11.69%[/TD]
[/TR]
[TR]
[TD="align: right"]4/8/2015[/TD]
[TD="align: right"]2076.94[/TD]
[TD="align: right"]2086.69[/TD]
[TD="align: right"]2073.3[/TD]
[TD="align: right"]4/8/2015[/TD]
[TD="align: right"]2081.9[/TD]
[TD][/TD]
[TD="align: right"]4/9/2014[/TD]
[TD="align: right"]12.37%[/TD]
[/TR]
[TR]
[TD="align: right"]4/7/2015[/TD]
[TD="align: right"]2080.79[/TD]
[TD="align: right"]2089.81[/TD]
[TD="align: right"]2076.1[/TD]
[TD="align: right"]4/7/2015[/TD]
[TD="align: right"]2076.33[/TD]
[TD][/TD]
[TD="align: right"]4/8/2014[/TD]
[TD="align: right"]12.51%[/TD]
[/TR]
[TR]
[TD="align: right"]4/6/2015[/TD]
[TD="align: right"]2064.87[/TD]
[TD="align: right"]2086.99[/TD]
[TD="align: right"]2056.52[/TD]
[TD="align: right"]4/6/2015[/TD]
[TD="align: right"]2080.62[/TD]
[TD][/TD]
[TD="align: right"]4/7/2014[/TD]
[TD="align: right"]11.63%[/TD]
[/TR]
[TR]
[TD="align: right"]4/2/2015[/TD]
[TD="align: right"]2060.03[/TD]
[TD="align: right"]2072.17[/TD]
[TD="align: right"]2057.32[/TD]
[TD="align: right"]4/2/2015[/TD]
[TD="align: right"]2066.96[/TD]
[TD][/TD]
[TD="align: right"]4/3/2014[/TD]
[TD="align: right"]9.28%[/TD]
[/TR]
[TR]
[TD="align: right"]4/1/2015[/TD]
[TD="align: right"]2067.63[/TD]
[TD="align: right"]2067.63[/TD]
[TD="align: right"]2048.38[/TD]
[TD="align: right"]4/1/2015[/TD]
[TD="align: right"]2059.69[/TD]
[TD][/TD]
[TD="align: right"]4/2/2014[/TD]
[TD="align: right"]9.17%[/TD]
[/TR]
[TR]
[TD="align: right"]3/31/2015[/TD]
[TD="align: right"]2084.05[/TD]
[TD="align: right"]2084.05[/TD]
[TD="align: right"]2067.04[/TD]
[TD="align: right"]3/31/2015[/TD]
[TD="align: right"]2067.89[/TD]
[TD][/TD]
[TD="align: right"]4/1/2014[/TD]
[TD="align: right"]10.35%[/TD]
[/TR]
[TR]
[TD="align: right"]3/30/2015[/TD]
[TD="align: right"]2064.11[/TD]
[TD="align: right"]2088.97[/TD]
[TD="align: right"]2064.11[/TD]
[TD="align: right"]3/30/2015[/TD]
[TD="align: right"]2086.24[/TD]
[TD][/TD]
[TD="align: right"]3/31/2014[/TD]
[TD="align: right"]12.21%[/TD]
[/TR]
[TR]
[TD="align: right"]3/27/2015[/TD]
[TD="align: right"]2055.78[/TD]
[TD="align: right"]2062.83[/TD]
[TD="align: right"]2052.96[/TD]
[TD="align: right"]3/27/2015[/TD]
[TD="align: right"]2061.02[/TD]
[TD][/TD]
[TD="align: right"]3/28/2014[/TD]
[TD="align: right"]11.40%[/TD]
[/TR]
[TR]
[TD="align: right"]3/26/2015[/TD]
[TD="align: right"]2059.94[/TD]
[TD="align: right"]2067.15[/TD]
[TD="align: right"]2045.5[/TD]
[TD="align: right"]3/26/2015[/TD]
[TD="align: right"]2056.15[/TD]
[TD][/TD]
[TD="align: right"]3/27/2014[/TD]
[TD="align: right"]11.02%[/TD]
[/TR]
[TR]
[TD="align: right"]3/25/2015[/TD]
[TD="align: right"]2093.1[/TD]
[TD="align: right"]2097.43[/TD]
[TD="align: right"]2061.05[/TD]
[TD="align: right"]3/25/2015[/TD]
[TD="align: right"]2061.05[/TD]
[TD][/TD]
[TD="align: right"]3/26/2014[/TD]
[TD="align: right"]10.39%[/TD]
[/TR]
[TR]
[TD="align: right"]3/24/2015[/TD]
[TD="align: right"]2103.94[/TD]
[TD="align: right"]2107.63[/TD]
[TD="align: right"]2091.5[/TD]
[TD="align: right"]3/24/2015[/TD]
[TD="align: right"]2091.5[/TD]
[TD][/TD]
[TD="align: right"]3/25/2014[/TD]
[TD="align: right"]12.48%[/TD]
[/TR]
[TR]
[TD="align: right"]3/23/2015[/TD]
[TD="align: right"]2107.99[/TD]
[TD="align: right"]2114.86[/TD]
[TD="align: right"]2104.42[/TD]
[TD="align: right"]3/23/2015[/TD]
[TD="align: right"]2104.42[/TD]
[TD][/TD]
[TD="align: right"]3/24/2014[/TD]
[TD="align: right"]12.68%[/TD]
[/TR]
[TR]
[TD="align: right"]3/20/2015[/TD]
[TD="align: right"]2090.32[/TD]
[TD="align: right"]2113.92[/TD]
[TD="align: right"]2090.32[/TD]
[TD="align: right"]3/20/2015[/TD]
[TD="align: right"]2108.1[/TD]
[TD][/TD]
[TD="align: right"]3/21/2014[/TD]
[TD="align: right"]12.46%[/TD]
[/TR]
[TR]
[TD="align: right"]3/19/2015[/TD]
[TD="align: right"]2098.69[/TD]
[TD="align: right"]2098.69[/TD]
[TD="align: right"]2085.56[/TD]
[TD="align: right"]3/19/2015[/TD]
[TD="align: right"]2089.27[/TD]
[TD][/TD]
[TD="align: right"]3/20/2014[/TD]
[TD="align: right"]12.32%[/TD]
[/TR]
[TR]
[TD="align: right"]3/18/2015[/TD]
[TD="align: right"]2072.84[/TD]
[TD="align: right"]2106.85[/TD]
[TD="align: right"]2061.23[/TD]
[TD="align: right"]3/18/2015[/TD]
[TD="align: right"]2099.5[/TD]
[TD][/TD]
[TD="align: right"]3/19/2014[/TD]
[TD="align: right"]12.14%[/TD]
[/TR]
[TR]
[TD="align: right"]3/17/2015[/TD]
[TD="align: right"]2080.59[/TD]
[TD="align: right"]2080.59[/TD]
[TD="align: right"]2065.08[/TD]
[TD="align: right"]3/17/2015[/TD]
[TD="align: right"]2074.28[/TD]
[TD][/TD]
[TD="align: right"]3/18/2014[/TD]
[TD="align: right"]11.59%[/TD]
[/TR]
[TR]
[TD="align: right"]3/16/2015[/TD]
[TD="align: right"]2055.35[/TD]
[TD="align: right"]2081.41[/TD]
[TD="align: right"]2055.35[/TD]
[TD="align: right"]3/16/2015[/TD]
[TD="align: right"]2081.19[/TD]
[TD][/TD]
[TD="align: right"]3/17/2014[/TD]
[TD="align: right"]12.94%[/TD]
[/TR]
[TR]
[TD="align: right"]3/13/2015[/TD]
[TD="align: right"]2064.56[/TD]
[TD="align: right"]2064.56[/TD]
[TD="align: right"]2041.17[/TD]
[TD="align: right"]3/13/2015[/TD]
[TD="align: right"]2053.4[/TD]
[TD][/TD]
[TD="align: right"]3/14/2014[/TD]
[TD="align: right"]11.29%[/TD]
[/TR]
[TR]
[TD="align: right"]3/12/2015[/TD]
[TD="align: right"]2041.1[/TD]
[TD="align: right"]2066.41[/TD]
[TD="align: right"]2041.1[/TD]
[TD="align: right"]3/12/2015[/TD]
[TD="align: right"]2065.95[/TD]
[TD][/TD]
[TD="align: right"]3/13/2014[/TD]
[TD="align: right"]10.53%[/TD]
[/TR]
[TR]
[TD="align: right"]3/11/2015[/TD]
[TD="align: right"]2044.69[/TD]
[TD="align: right"]2050.08[/TD]
[TD="align: right"]2039.69[/TD]
[TD="align: right"]3/11/2015[/TD]
[TD="align: right"]2040.24[/TD]
[TD][/TD]
[TD="align: right"]3/12/2014[/TD]
[TD="align: right"]9.33%[/TD]
[/TR]
[TR]
[TD="align: right"]3/10/2015[/TD]
[TD="align: right"]2076.14[/TD]
[TD="align: right"]2076.14[/TD]
[TD="align: right"]2044.16[/TD]
[TD="align: right"]3/10/2015[/TD]
[TD="align: right"]2044.16[/TD]
[TD][/TD]
[TD="align: right"]3/11/2014[/TD]
[TD="align: right"]8.83%[/TD]
[/TR]
[TR]
[TD="align: right"]3/9/2015[/TD]
[TD="align: right"]2072.25[/TD]
[TD="align: right"]2083.49[/TD]
[TD="align: right"]2072.21[/TD]
[TD="align: right"]3/9/2015[/TD]
[TD="align: right"]2079.43[/TD]
[TD][/TD]
[TD="align: right"]3/10/2014[/TD]
[TD="align: right"]10.73%[/TD]
[/TR]
[TR]
[TD="align: right"]3/6/2015[/TD]
[TD="align: right"]2100.91[/TD]
[TD="align: right"]2100.91[/TD]
[TD="align: right"]2067.27[/TD]
[TD="align: right"]3/6/2015[/TD]
[TD="align: right"]2071.26[/TD]
[TD][/TD]
[TD="align: right"]3/7/2014[/TD]
[TD="align: right"]10.26%[/TD]
[/TR]
[TR]
[TD="align: right"]3/5/2015[/TD]
[TD="align: right"]2098.54[/TD]
[TD="align: right"]2104.25[/TD]
[TD="align: right"]2095.22[/TD]
[TD="align: right"]3/5/2015[/TD]
[TD="align: right"]2101.04[/TD]
[TD][/TD]
[TD="align: right"]3/6/2014[/TD]
[TD="align: right"]12.10%[/TD]
[/TR]
[TR]
[TD="align: right"]3/4/2015[/TD]
[TD="align: right"]2107.72[/TD]
[TD="align: right"]2107.72[/TD]
[TD="align: right"]2094.49[/TD]
[TD="align: right"]3/4/2015[/TD]
[TD="align: right"]2098.53[/TD]
[TD][/TD]
[TD="align: right"]3/5/2014[/TD]
[TD="align: right"]11.98%[/TD]
[/TR]
[TR]
[TD="align: right"]3/3/2015[/TD]
[TD="align: right"]2115.76[/TD]
[TD="align: right"]2115.76[/TD]
[TD="align: right"]2098.26[/TD]
[TD="align: right"]3/3/2015[/TD]
[TD="align: right"]2107.78[/TD]
[TD][/TD]
[TD="align: right"]3/4/2014[/TD]
[TD="align: right"]13.98%[/TD]
[/TR]
[TR]
[TD="align: right"]3/2/2015[/TD]
[TD="align: right"]2105.23[/TD]
[TD="align: right"]2117.52[/TD]
[TD="align: right"]2104.5[/TD]
[TD="align: right"]3/2/2015[/TD]
[TD="align: right"]2117.39[/TD]
[TD][/TD]
[TD="align: right"]3/3/2014[/TD]
[TD="align: right"]13.98%[/TD]
[/TR]
[TR]
[TD="align: right"]2/27/2015[/TD]
[TD="align: right"]2110.88[/TD]
[TD="align: right"]2112.74[/TD]
[TD="align: right"]2103.75[/TD]
[TD="align: right"]2/27/2015[/TD]
[TD="align: right"]2104.5[/TD]
[TD][/TD]
[TD="align: right"]2/28/2014[/TD]
[TD="align: right"]13.44%[/TD]
[/TR]
[TR]
[TD="align: right"]2/26/2015[/TD]
[TD="align: right"]2113.91[/TD]
[TD="align: right"]2113.91[/TD]
[TD="align: right"]2103.76[/TD]
[TD="align: right"]2/26/2015[/TD]
[TD="align: right"]2110.74[/TD]
[TD][/TD]
[TD="align: right"]2/27/2014[/TD]
[TD="align: right"]14.41%[/TD]
[/TR]
[TR]
[TD="align: right"]2/25/2015[/TD]
[TD="align: right"]2115.3[/TD]
[TD="align: right"]2119.59[/TD]
[TD="align: right"]2109.89[/TD]
[TD="align: right"]2/25/2015[/TD]
[TD="align: right"]2113.86[/TD]
[TD][/TD]
[TD="align: right"]2/26/2014[/TD]
[TD="align: right"]14.52%[/TD]
[/TR]
[TR]
[TD="align: right"]2/24/2015[/TD]
[TD="align: right"]2109.1[/TD]
[TD="align: right"]2117.94[/TD]
[TD="align: right"]2105.87[/TD]
[TD="align: right"]2/24/2015[/TD]
[TD="align: right"]2115.48[/TD]
[TD][/TD]
[TD="align: right"]2/25/2014[/TD]
[TD="align: right"]14.50%[/TD]
[/TR]
[TR]
[TD="align: right"]2/23/2015[/TD]
[TD="align: right"]2109.83[/TD]
[TD="align: right"]2110.05[/TD]
[TD="align: right"]2103[/TD]
[TD="align: right"]2/23/2015[/TD]
[TD="align: right"]2109.66[/TD]
[TD][/TD]
[TD="align: right"]2/24/2014[/TD]
[TD="align: right"]14.86%[/TD]
[/TR]
[TR]
[TD="align: right"]2/20/2015[/TD]
[TD="align: right"]2097.65[/TD]
[TD="align: right"]2110.61[/TD]
[TD="align: right"]2085.44[/TD]
[TD="align: right"]2/20/2015[/TD]
[TD="align: right"]2110.3[/TD]
[TD][/TD]
[TD="align: right"]2/21/2014[/TD]
[TD="align: right"]14.62%[/TD]
[/TR]
[TR]
[TD="align: right"]2/19/2015[/TD]
[TD="align: right"]2099.25[/TD]
[TD="align: right"]2102.13[/TD]
[TD="align: right"]2090.79[/TD]
[TD="align: right"]2/19/2015[/TD]
[TD="align: right"]2097.45[/TD]
[TD][/TD]
[TD="align: right"]2/20/2014[/TD]
[TD="align: right"]14.66%[/TD]
[/TR]
[TR]
[TD="align: right"]2/18/2015[/TD]
[TD="align: right"]2099.16[/TD]
[TD="align: right"]2100.23[/TD]
[TD="align: right"]2092.15[/TD]
[TD="align: right"]2/18/2015[/TD]
[TD="align: right"]2099.68[/TD]
[TD][/TD]
[TD="align: right"]2/19/2014[/TD]
[TD="align: right"]14.18%[/TD]
[/TR]
[TR]
[TD="align: right"]2/17/2015[/TD]
[TD="align: right"]2096.47[/TD]
[TD="align: right"]2101.3[/TD]
[TD="align: right"]2089.8[/TD]
[TD="align: right"]2/17/2015[/TD]
[TD="align: right"]2100.34[/TD]
[TD][/TD]
[TD="align: right"]2/18/2014[/TD]
[TD="align: right"]14.21%[/TD]
[/TR]
[TR]
[TD="align: right"]2/13/2015[/TD]
[TD="align: right"]2088.78[/TD]
[TD="align: right"]2097.03[/TD]
[TD="align: right"]2086.7[/TD]
[TD="align: right"]2/13/2015[/TD]
[TD="align: right"]2096.99[/TD]
[TD][/TD]
[TD="align: right"]2/14/2014[/TD]
[TD="align: right"]14.69%[/TD]
[/TR]
[TR]
[TD="align: right"]2/12/2015[/TD]
[TD="align: right"]2069.98[/TD]
[TD="align: right"]2088.53[/TD]
[TD="align: right"]2069.98[/TD]
[TD="align: right"]2/12/2015[/TD]
[TD="align: right"]2088.48[/TD]
[TD][/TD]
[TD="align: right"]2/13/2014[/TD]
[TD="align: right"]15.08%[/TD]
[/TR]
[TR]
[TD="align: right"]2/11/2015[/TD]
[TD="align: right"]2068.55[/TD]
[TD="align: right"]2073.48[/TD]
[TD="align: right"]2057.99[/TD]
[TD="align: right"]2/11/2015[/TD]
[TD="align: right"]2068.53[/TD]
[TD][/TD]
[TD="align: right"]2/12/2014[/TD]
[TD="align: right"]13.65%[/TD]
[/TR]
[TR]
[TD="align: right"]2/10/2015[/TD]
[TD="align: right"]2049.38[/TD]
[TD="align: right"]2070.86[/TD]
[TD="align: right"]2048.62[/TD]
[TD="align: right"]2/10/2015[/TD]
[TD="align: right"]2068.59[/TD]
[TD][/TD]
[TD="align: right"]2/11/2014[/TD]
[TD="align: right"]14.89%[/TD]
[/TR]
[TR]
[TD="align: right"]2/9/2015[/TD]
[TD="align: right"]2053.47[/TD]
[TD="align: right"]2056.16[/TD]
[TD="align: right"]2041.88[/TD]
[TD="align: right"]2/9/2015[/TD]
[TD="align: right"]2046.74[/TD]
[TD][/TD]
[TD="align: right"]2/10/2014[/TD]
[TD="align: right"]13.95%[/TD]
[/TR]
[TR]
[TD="align: right"]2/6/2015[/TD]
[TD="align: right"]2062.28[/TD]
[TD="align: right"]2072.4[/TD]
[TD="align: right"]2049.97[/TD]
[TD="align: right"]2/6/2015[/TD]
[TD="align: right"]2055.47[/TD]
[TD][/TD]
[TD="align: right"]2/7/2014[/TD]
[TD="align: right"]15.74%[/TD]
[/TR]
[TR]
[TD="align: right"]2/5/2015[/TD]
[TD="align: right"]2043.45[/TD]
[TD="align: right"]2063.55[/TD]
[TD="align: right"]2043.45[/TD]
[TD="align: right"]2/5/2015[/TD]
[TD="align: right"]2062.52[/TD]
[TD][/TD]
[TD="align: right"]2/6/2014[/TD]
[TD="align: right"]17.66%[/TD]
[/TR]
[TR]
[TD="align: right"]2/4/2015[/TD]
[TD="align: right"]2048.86[/TD]
[TD="align: right"]2054.74[/TD]
[TD="align: right"]2036.72[/TD]
[TD="align: right"]2/4/2015[/TD]
[TD="align: right"]2041.51[/TD]
[TD][/TD]
[TD="align: right"]2/5/2014[/TD]
[TD="align: right"]16.43%[/TD]
[/TR]
[TR]
[TD="align: right"]2/3/2015[/TD]
[TD="align: right"]2022.71[/TD]
[TD="align: right"]2050.3[/TD]
[TD="align: right"]2022.71[/TD]
[TD="align: right"]2/3/2015[/TD]
[TD="align: right"]2050.03[/TD]
[TD][/TD]
[TD="align: right"]2/4/2014[/TD]
[TD="align: right"]17.56%[/TD]
[/TR]
[TR]
[TD="align: right"]2/2/2015[/TD]
[TD="align: right"]1996.67[/TD]
[TD="align: right"]2021.66[/TD]
[TD="align: right"]1980.9[/TD]
[TD="align: right"]2/2/2015[/TD]
[TD="align: right"]2020.85[/TD]
[TD][/TD]
[TD="align: right"]2/3/2014[/TD]
[TD="align: right"]13.36%[/TD]
[/TR]
[TR]
[TD="align: right"]1/30/2015[/TD]
[TD="align: right"]2019.35[/TD]
[TD="align: right"]2023.32[/TD]
[TD="align: right"]1993.38[/TD]
[TD="align: right"]1/30/2015[/TD]
[TD="align: right"]1994.99[/TD]
[TD][/TD]
[TD="align: right"]1/31/2014[/TD]
[TD="align: right"]11.40%[/TD]
[/TR]
[TR]
[TD="align: right"]1/29/2015[/TD]
[TD="align: right"]2002.45[/TD]
[TD="align: right"]2024.64[/TD]
[TD="align: right"]1989.18[/TD]
[TD="align: right"]1/29/2015[/TD]
[TD="align: right"]2021.25[/TD]
[TD][/TD]
[TD="align: right"]1/30/2014[/TD]
[TD="align: right"]13.73%[/TD]
[/TR]
[TR]
[TD="align: right"]1/28/2015[/TD]
[TD="align: right"]2032.34[/TD]
[TD="align: right"]2042.49[/TD]
[TD="align: right"]2001.49[/TD]
[TD="align: right"]1/28/2015[/TD]
[TD="align: right"]2002.16[/TD]
[TD][/TD]
[TD="align: right"]1/29/2014[/TD]
[TD="align: right"]11.84%[/TD]
[/TR]
[TR]
[TD="align: right"]1/27/2015[/TD]
[TD="align: right"]2047.86[/TD]
[TD="align: right"]2047.86[/TD]
[TD="align: right"]2019.91[/TD]
[TD="align: right"]1/27/2015[/TD]
[TD="align: right"]2029.55[/TD]
[TD][/TD]
[TD="align: right"]1/28/2014[/TD]
[TD="align: right"]13.83%[/TD]
[/TR]
[TR]
[TD="align: right"]1/26/2015[/TD]
[TD="align: right"]2050.42[/TD]
[TD="align: right"]2057.62[/TD]
[TD="align: right"]2040.97[/TD]
[TD="align: right"]1/26/2015[/TD]
[TD="align: right"]2057.09[/TD]
[TD][/TD]
[TD="align: right"]1/27/2014[/TD]
[TD="align: right"]14.86%[/TD]
[/TR]
[TR]
[TD="align: right"]1/23/2015[/TD]
[TD="align: right"]2062.98[/TD]
[TD="align: right"]2062.98[/TD]
[TD="align: right"]2050.54[/TD]
[TD="align: right"]1/23/2015[/TD]
[TD="align: right"]2051.82[/TD]
[TD][/TD]
[TD="align: right"]1/24/2014[/TD]
[TD="align: right"]12.31%[/TD]
[/TR]
[TR]
[TD="align: right"]1/22/2015[/TD]
[TD="align: right"]2034.3[/TD]
[TD="align: right"]2064.62[/TD]
[TD="align: right"]2026.38[/TD]
[TD="align: right"]1/22/2015[/TD]
[TD="align: right"]2063.15[/TD]
[TD][/TD]
[TD="align: right"]1/23/2014[/TD]
[TD="align: right"]11.99%[/TD]
[/TR]
[TR]
[TD="align: right"]1/21/2015[/TD]
[TD="align: right"]2020.19[/TD]
[TD="align: right"]2038.29[/TD]
[TD="align: right"]2012.04[/TD]
[TD="align: right"]1/21/2015[/TD]
[TD="align: right"]2032.12[/TD]
[TD][/TD]
[TD="align: right"]1/22/2014[/TD]
[TD="align: right"]10.16%[/TD]
[/TR]
[TR]
[TD="align: right"]1/20/2015[/TD]
[TD="align: right"]2020.76[/TD]
[TD="align: right"]2028.94[/TD]
[TD="align: right"]2004.49[/TD]
[TD="align: right"]1/20/2015[/TD]
[TD="align: right"]2022.55[/TD]
[TD][/TD]
[TD="align: right"]1/21/2014[/TD]
[TD="align: right"]9.86%[/TD]
[/TR]
[TR]
[TD="align: right"]1/16/2015[/TD]
[TD="align: right"]1992.25[/TD]
[TD="align: right"]2020.46[/TD]
[TD="align: right"]1988.12[/TD]
[TD="align: right"]1/16/2015[/TD]
[TD="align: right"]2019.42[/TD]
[TD][/TD]
[TD="align: right"]1/17/2014[/TD]
[TD="align: right"]9.50%[/TD]
[/TR]
[TR]
[TD="align: right"]1/15/2015[/TD]
[TD="align: right"]2013.75[/TD]
[TD="align: right"]2021.35[/TD]
[TD="align: right"]1991.47[/TD]
[TD="align: right"]1/15/2015[/TD]
[TD="align: right"]1992.67[/TD]
[TD][/TD]
[TD="align: right"]1/16/2014[/TD]
[TD="align: right"]7.83%[/TD]
[/TR]
[TR]
[TD="align: right"]1/14/2015[/TD]
[TD="align: right"]2018.4[/TD]
[TD="align: right"]2018.4[/TD]
[TD="align: right"]1988.44[/TD]
[TD="align: right"]1/14/2015[/TD]
[TD="align: right"]2011.27[/TD]
[TD][/TD]
[TD="align: right"]1/15/2014[/TD]
[TD="align: right"]9.28%[/TD]
[/TR]
[TR]
[TD="align: right"]1/13/2015[/TD]
[TD="align: right"]2031.58[/TD]
[TD="align: right"]2056.93[/TD]
[TD="align: right"]2008.25[/TD]
[TD="align: right"]1/13/2015[/TD]
[TD="align: right"]2023.03[/TD]
[TD][/TD]
[TD="align: right"]1/14/2014[/TD]
[TD="align: right"]11.07%[/TD]
[/TR]
[TR]
[TD="align: right"]1/12/2015[/TD]
[TD="align: right"]2046.13[/TD]
[TD="align: right"]2049.3[/TD]
[TD="align: right"]2022.58[/TD]
[TD="align: right"]1/12/2015[/TD]
[TD="align: right"]2028.26[/TD]
[TD][/TD]
[TD="align: right"]1/13/2014[/TD]
[TD="align: right"]10.16%[/TD]
[/TR]
[TR]
[TD="align: right"]1/9/2015[/TD]
[TD="align: right"]2063.45[/TD]
[TD="align: right"]2064.43[/TD]
[TD="align: right"]2038.33[/TD]
[TD="align: right"]1/9/2015[/TD]
[TD="align: right"]2044.81[/TD]
[TD][/TD]
[TD="align: right"]1/10/2014[/TD]
[TD="align: right"]11.13%[/TD]
[/TR]
[TR]
[TD="align: right"]1/8/2015[/TD]
[TD="align: right"]2030.61[/TD]
[TD="align: right"]2064.08[/TD]
[TD="align: right"]2030.61[/TD]
[TD="align: right"]1/8/2015[/TD]
[TD="align: right"]2062.14[/TD]
[TD][/TD]
[TD="align: right"]1/9/2014[/TD]
[TD="align: right"]12.13%[/TD]
[/TR]
[TR]
[TD="align: right"]1/7/2015[/TD]
[TD="align: right"]2005.55[/TD]
[TD="align: right"]2029.61[/TD]
[TD="align: right"]2005.55[/TD]
[TD="align: right"]1/7/2015[/TD]
[TD="align: right"]2025.9[/TD]
[TD][/TD]
[TD="align: right"]1/8/2014[/TD]
[TD="align: right"]10.23%[/TD]
[/TR]
[TR]
[TD="align: right"]1/6/2015[/TD]
[TD="align: right"]2022.15[/TD]
[TD="align: right"]2030.25[/TD]
[TD="align: right"]1992.44[/TD]
[TD="align: right"]1/6/2015[/TD]
[TD="align: right"]2002.61[/TD]
[TD][/TD]
[TD="align: right"]1/7/2014[/TD]
[TD="align: right"]9.51%[/TD]
[/TR]
[TR]
[TD="align: right"]1/5/2015[/TD]
[TD="align: right"]2054.44[/TD]
[TD="align: right"]2054.44[/TD]
[TD="align: right"]2017.34[/TD]
[TD="align: right"]1/5/2015[/TD]
[TD="align: right"]2020.58[/TD]
[TD][/TD]
[TD="align: right"]1/6/2014[/TD]
[TD="align: right"]10.28%[/TD]
[/TR]
[TR]
[TD="align: right"]1/2/2015[/TD]
[TD="align: right"]2058.9[/TD]
[TD="align: right"]2072.36[/TD]
[TD="align: right"]2046.04[/TD]
[TD="align: right"]1/2/2015[/TD]
[TD="align: right"]2058.2[/TD]
[TD][/TD]
[TD="align: right"]1/3/2014[/TD]
[TD="align: right"]12.27%[/TD]
[/TR]
[TR]
[TD="align: right"]12/31/2014[/TD]
[TD="align: right"]2082.11[/TD]
[TD="align: right"]2085.58[/TD]
[TD="align: right"]2057.94[/TD]
[TD="align: right"]12/31/2014[/TD]
[TD="align: right"]2058.9[/TD]
[TD][/TD]
[TD="align: right"]1/1/2014[/TD]
[TD="align: center"]#N/A[/TD]
[/TR]
[TR]
[TD="align: right"]12/30/2014[/TD]
[TD="align: right"]2088.49[/TD]
[TD="align: right"]2088.49[/TD]
[TD="align: right"]2079.53[/TD]
[TD="align: right"]12/30/2014[/TD]
[TD="align: right"]2080.35[/TD]
[TD][/TD]
[TD="align: right"]12/31/2013[/TD]
[TD="align: right"]12.90%[/TD]
[/TR]
[TR]
[TD="align: right"]12/29/2014[/TD]
[TD="align: right"]2087.63[/TD]
[TD="align: right"]2093.55[/TD]
[TD="align: right"]2085.75[/TD]
[TD="align: right"]12/29/2014[/TD]
[TD="align: right"]2090.57[/TD]
[TD][/TD]
[TD="align: right"]12/30/2013[/TD]
[TD="align: right"]13.53%[/TD]
[/TR]
[TR]
[TD="align: right"]12/26/2014[/TD]
[TD="align: right"]2084.3[/TD]
[TD="align: right"]2092.7[/TD]
[TD="align: right"]2084.3[/TD]
[TD="align: right"]12/26/2014[/TD]
[TD="align: right"]2088.77[/TD]
[TD][/TD]
[TD="align: right"]12/27/2013[/TD]
[TD="align: right"]13.34%[/TD]
[/TR]
</tbody>[/TABLE]
Click to expand...
 
Upvote 0
I'd be calculating returns based on the ratios of index closing values. Given that your dates are in descending order, VLOOKUP is out, and we need a variation on INDEX/MATCH. Here's my take on an abridged version of your data.

C2: =INDEX(B$2:B$25,MATCH(EDATE(A2,-12),A$2:A$25,-1)+ISERROR(MATCH(EDATE(A2,-12),A$2:A$25,)))
D2: =B2/C2-1

For example, the 28 Dec 15 1-yr rolling return is based on the 26 Dec 14 closing value of 2,088.77.

I have used the same methodology to calculate some quarterly returns, and matched the numbers quoted by Morningstar here:
S&P 500 PR (SPX) Fund Performance and Returns

G10: =INDEX($B$2:$B$25,MATCH(EDATE(G9+1,-3)-1,$A$2:$A$25,-1)+ISERROR(MATCH(EDATE(G9+1,-3)-1,$A$2:$A$25,)))
G11: =INDEX($B$2:$B$25,MATCH(G9,$A$2:$A$25,-1)+ISERROR(MATCH(G9,$A$2:$A$25,)))
(Copy down and across)

Note the values highlighted which are based on the previous available day (i.e. 28th in both cases here).

Excel 2010
ABCDEFGHIJ
Morningstar
2015
2014
2013
Qtr to
Open
Close
Return
Qtr to
Open
Close
Return
Qtr to
Open
Close
Return

<tbody>
[TD="align: center"]1[/TD]
[TD="align: right"]Date[/TD]
[TD="align: right"]Close[/TD]
[TD="align: center"]Start[/TD]
[TD="align: right"]Rolling 1-yr[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]

[TD="align: center"]2[/TD]
[TD="align: right"]31 Dec 15[/TD]
[TD="align: right"]2,043.94[/TD]
[TD="align: right"]2,058.90[/TD]
[TD="align: right"]-0.73%[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]

[TD="align: center"]3[/TD]
[TD="align: right"]30 Dec 15[/TD]
[TD="align: right"]2,063.36[/TD]
[TD="align: right"]2,080.35[/TD]
[TD="align: right"]-0.82%[/TD]
[TD="align: right"][/TD]

[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]

[TD="align: center"]4[/TD]
[TD="align: right"]29 Dec 15[/TD]
[TD="align: right"]2,078.36[/TD]
[TD="align: right"]2,090.57[/TD]
[TD="align: right"]-0.58%[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]

[TD="align: center"]5[/TD]
[TD="align: right"]28 Dec 15[/TD]
[TD="align: right"]2,056.50[/TD]
[TD="align: right"]2,088.77[/TD]
[TD="align: right"]-1.54%[/TD]
[TD="align: right"][/TD]

[TD="align: right"]0.44[/TD]
[TD="align: right"]-0.23[/TD]
[TD="align: right"]-6.94[/TD]
[TD="align: right"]6.45[/TD]

[TD="align: center"]6[/TD]
[TD="align: right"]24 Dec 15[/TD]
[TD="align: right"]2,060.99[/TD]
[TD="align: right"]2,081.88[/TD]
[TD="align: right"]-1.00%[/TD]
[TD="align: right"][/TD]

[TD="align: right"]1.3[/TD]
[TD="align: right"]4.69[/TD]
[TD="align: right"]0.61[/TD]
[TD="align: right"]4.39[/TD]

[TD="align: center"]7[/TD]
[TD="align: right"]23 Dec 15[/TD]
[TD="align: right"]2,064.29[/TD]
[TD="align: right"]2,082.17[/TD]
[TD="align: right"]-0.86%[/TD]
[TD="align: right"][/TD]

[TD="align: right"]10.03[/TD]
[TD="align: right"]2.36[/TD]
[TD="align: right"]4.69[/TD]
[TD="align: right"]9.92[/TD]

[TD="align: center"]8[/TD]
[TD="align: right"]30 Sep 15[/TD]
[TD="align: right"]1,920.03[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]

[TD="align: center"]9[/TD]
[TD="align: right"]30 Jun 15[/TD]
[TD="align: right"]2,063.11[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]

[TD="align: right"]31/03/2015[/TD]
[TD="align: right"]30/06/2015[/TD]
[TD="align: right"]30/09/2015[/TD]
[TD="align: right"]31/12/2015[/TD]

[TD="align: center"]10[/TD]
[TD="align: right"]29 May 15[/TD]
[TD="align: right"]2,107.39[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]

[TD="align: right"]2,058.90[/TD]
[TD="align: right"]2,067.89[/TD]
[TD="align: right"]2,063.11[/TD]
[TD="align: right"]1,920.03[/TD]

[TD="align: center"]11[/TD]
[TD="align: right"]31 Mar 15[/TD]
[TD="align: right"]2,067.89[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]

[TD="align: right"]2,067.89[/TD]
[TD="align: right"]2,063.11[/TD]
[TD="align: right"]1,920.03[/TD]
[TD="align: right"]2,043.94[/TD]

[TD="align: center"]12[/TD]
[TD="align: right"]31 Dec 14[/TD]
[TD="align: right"]2,058.90[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]

[TD="align: right"]0.44%[/TD]
[TD="align: right"]-0.23%[/TD]
[TD="align: right"]-6.94%[/TD]
[TD="align: right"]6.45%[/TD]

[TD="align: center"]13[/TD]
[TD="align: right"]30 Dec 14[/TD]
[TD="align: right"]2,080.35[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]

[TD="align: center"]14[/TD]
[TD="align: right"]29 Dec 14[/TD]
[TD="align: right"]2,090.57[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]

[TD="align: right"]31/03/2014[/TD]
[TD="align: right"]30/06/2014[/TD]
[TD="align: right"]30/09/2014[/TD]
[TD="align: right"]31/12/2014[/TD]

[TD="align: center"]15[/TD]
[TD="align: right"]26 Dec 14[/TD]
[TD="align: right"]2,088.77[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]

[TD="align: right"]1,848.36[/TD]
[TD="align: right"]1,872.34[/TD]
[TD="align: right"]1,960.23[/TD]
[TD="align: right"]1,972.29[/TD]

[TD="align: center"]16[/TD]
[TD="align: right"]24 Dec 14[/TD]
[TD="align: right"]2,081.88[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]

[TD="align: right"]1,872.34[/TD]
[TD="align: right"]1,960.23[/TD]
[TD="align: right"]1,972.29[/TD]
[TD="align: right"]2,058.90[/TD]

[TD="align: center"]17[/TD]
[TD="align: right"]23 Dec 14[/TD]
[TD="align: right"]2,082.17[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]

[TD="align: right"]1.30%[/TD]
[TD="align: right"]4.69%[/TD]
[TD="align: right"]0.62%[/TD]
[TD="align: right"]4.39%[/TD]

[TD="align: center"]18[/TD]
[TD="align: right"]30 Sep 14[/TD]
[TD="align: right"]1,972.29[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]

[TD="align: center"]19[/TD]
[TD="align: right"]30 Jun 14[/TD]
[TD="align: right"]1,960.23[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]

[TD="align: right"]31/03/2013[/TD]
[TD="align: right"]30/06/2013[/TD]
[TD="align: right"]30/09/2013[/TD]
[TD="align: right"]31/12/2013[/TD]

[TD="align: center"]20[/TD]
[TD="align: right"]31 Mar 14[/TD]
[TD="align: right"]1,872.34[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]

[TD="align: right"]1,426.19[/TD]
[TD="bgcolor: #FFFF00, align: right"]1,569.19[/TD]
[TD="bgcolor: #FFFF00, align: right"]1,606.28[/TD]
[TD="align: right"]1,681.55[/TD]

[TD="align: center"]21[/TD]
[TD="align: right"]31 Dec 13[/TD]
[TD="align: right"]1,848.36[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]

[TD="bgcolor: #FFFF00, align: right"]1,569.19[/TD]
[TD="bgcolor: #FFFF00, align: right"]1,606.28[/TD]
[TD="align: right"]1,681.55[/TD]
[TD="align: right"]1,848.36[/TD]

[TD="align: center"]22[/TD]
[TD="align: right"]30 Sep 13[/TD]
[TD="align: right"]1,681.55[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]

[TD="align: right"]10.03%[/TD]
[TD="align: right"]2.36%[/TD]
[TD="align: right"]4.69%[/TD]
[TD="align: right"]9.92%[/TD]

[TD="align: center"]23[/TD]
[TD="bgcolor: #FFFF00, align: right"]28 Jun 13[/TD]
[TD="bgcolor: #FFFF00, align: right"]1,606.28[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]

[TD="align: center"]24[/TD]
[TD="bgcolor: #FFFF00, align: right"]28 Mar 13[/TD]
[TD="bgcolor: #FFFF00, align: right"]1,569.19[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]

[TD="align: center"]25[/TD]
[TD="align: right"]31 Dec 12[/TD]
[TD="align: right"]1,426.19[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]

</tbody>
 
Last edited:
Upvote 0
Stephen,

This is awesome! I completely agree it's easier using the ratio method. I am not very familiar with the iserror function but it looks like it automatically looks at the next closest available date. I am just curious - If the data was in ascending order would you prefer to use the lookup function over the index/match function? Thank you so much for the help. I may have a few questions regarding calculating caps on index returns, but let me get my spreadsheet fixed first. you are a life saver.

StephenCrump said:
I'd be calculating returns based on the ratios of index closing values. Given that your dates are in descending order, VLOOKUP is out, and we need a variation on INDEX/MATCH. Here's my take on an abridged version of your data.

C2: =INDEX(B$2:B$25,MATCH(EDATE(A2,-12),A$2:A$25,-1)+ISERROR(MATCH(EDATE(A2,-12),A$2:A$25,)))
D2: =B2/C2-1

For example, the 28 Dec 15 1-yr rolling return is based on the 26 Dec 14 closing value of 2,088.77.

I have used the same methodology to calculate some quarterly returns, and matched the numbers quoted by Morningstar here:
S&P 500 PR (SPX) Fund Performance and Returns

G10: =INDEX($B$2:$B$25,MATCH(EDATE(G9+1,-3)-1,$A$2:$A$25,-1)+ISERROR(MATCH(EDATE(G9+1,-3)-1,$A$2:$A$25,)))
G11: =INDEX($B$2:$B$25,MATCH(G9,$A$2:$A$25,-1)+ISERROR(MATCH(G9,$A$2:$A$25,)))
(Copy down and across)

Note the values highlighted which are based on the previous available day (i.e. 28th in both cases here).

Excel 2010
ABCDEFGHIJ
Morningstar
2015
2014
2013
Qtr to
Open
Close
Return
Qtr to
Open
Close
Return
Qtr to
Open
Close
Return

<tbody>
[TD="align: center"]1[/TD]
[TD="align: right"]Date[/TD]
[TD="align: right"]Close[/TD]
[TD="align: center"]Start[/TD]
[TD="align: right"]Rolling 1-yr[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]

[TD="align: center"]2[/TD]
[TD="align: right"]31 Dec 15[/TD]
[TD="align: right"]2,043.94[/TD]
[TD="align: right"]2,058.90[/TD]
[TD="align: right"]-0.73%[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]

[TD="align: center"]3[/TD]
[TD="align: right"]30 Dec 15[/TD]
[TD="align: right"]2,063.36[/TD]
[TD="align: right"]2,080.35[/TD]
[TD="align: right"]-0.82%[/TD]
[TD="align: right"][/TD]

[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]

[TD="align: center"]4[/TD]
[TD="align: right"]29 Dec 15[/TD]
[TD="align: right"]2,078.36[/TD]
[TD="align: right"]2,090.57[/TD]
[TD="align: right"]-0.58%[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]

[TD="align: center"]5[/TD]
[TD="align: right"]28 Dec 15[/TD]
[TD="align: right"]2,056.50[/TD]
[TD="align: right"]2,088.77[/TD]
[TD="align: right"]-1.54%[/TD]
[TD="align: right"][/TD]

[TD="align: right"]0.44[/TD]
[TD="align: right"]-0.23[/TD]
[TD="align: right"]-6.94[/TD]
[TD="align: right"]6.45[/TD]

[TD="align: center"]6[/TD]
[TD="align: right"]24 Dec 15[/TD]
[TD="align: right"]2,060.99[/TD]
[TD="align: right"]2,081.88[/TD]
[TD="align: right"]-1.00%[/TD]
[TD="align: right"][/TD]

[TD="align: right"]1.3[/TD]
[TD="align: right"]4.69[/TD]
[TD="align: right"]0.61[/TD]
[TD="align: right"]4.39[/TD]

[TD="align: center"]7[/TD]
[TD="align: right"]23 Dec 15[/TD]
[TD="align: right"]2,064.29[/TD]
[TD="align: right"]2,082.17[/TD]
[TD="align: right"]-0.86%[/TD]
[TD="align: right"][/TD]

[TD="align: right"]10.03[/TD]
[TD="align: right"]2.36[/TD]
[TD="align: right"]4.69[/TD]
[TD="align: right"]9.92[/TD]

[TD="align: center"]8[/TD]
[TD="align: right"]30 Sep 15[/TD]
[TD="align: right"]1,920.03[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]

[TD="align: center"]9[/TD]
[TD="align: right"]30 Jun 15[/TD]
[TD="align: right"]2,063.11[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]

[TD="align: right"]31/03/2015[/TD]
[TD="align: right"]30/06/2015[/TD]
[TD="align: right"]30/09/2015[/TD]
[TD="align: right"]31/12/2015[/TD]

[TD="align: center"]10[/TD]
[TD="align: right"]29 May 15[/TD]
[TD="align: right"]2,107.39[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]

[TD="align: right"]2,058.90[/TD]
[TD="align: right"]2,067.89[/TD]
[TD="align: right"]2,063.11[/TD]
[TD="align: right"]1,920.03[/TD]

[TD="align: center"]11[/TD]
[TD="align: right"]31 Mar 15[/TD]
[TD="align: right"]2,067.89[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]

[TD="align: right"]2,067.89[/TD]
[TD="align: right"]2,063.11[/TD]
[TD="align: right"]1,920.03[/TD]
[TD="align: right"]2,043.94[/TD]

[TD="align: center"]12[/TD]
[TD="align: right"]31 Dec 14[/TD]
[TD="align: right"]2,058.90[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]

[TD="align: right"]0.44%[/TD]
[TD="align: right"]-0.23%[/TD]
[TD="align: right"]-6.94%[/TD]
[TD="align: right"]6.45%[/TD]

[TD="align: center"]13[/TD]
[TD="align: right"]30 Dec 14[/TD]
[TD="align: right"]2,080.35[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]

[TD="align: center"]14[/TD]
[TD="align: right"]29 Dec 14[/TD]
[TD="align: right"]2,090.57[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]

[TD="align: right"]31/03/2014[/TD]
[TD="align: right"]30/06/2014[/TD]
[TD="align: right"]30/09/2014[/TD]
[TD="align: right"]31/12/2014[/TD]

[TD="align: center"]15[/TD]
[TD="align: right"]26 Dec 14[/TD]
[TD="align: right"]2,088.77[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]

[TD="align: right"]1,848.36[/TD]
[TD="align: right"]1,872.34[/TD]
[TD="align: right"]1,960.23[/TD]
[TD="align: right"]1,972.29[/TD]

[TD="align: center"]16[/TD]
[TD="align: right"]24 Dec 14[/TD]
[TD="align: right"]2,081.88[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]

[TD="align: right"]1,872.34[/TD]
[TD="align: right"]1,960.23[/TD]
[TD="align: right"]1,972.29[/TD]
[TD="align: right"]2,058.90[/TD]

[TD="align: center"]17[/TD]
[TD="align: right"]23 Dec 14[/TD]
[TD="align: right"]2,082.17[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]

[TD="align: right"]1.30%[/TD]
[TD="align: right"]4.69%[/TD]
[TD="align: right"]0.62%[/TD]
[TD="align: right"]4.39%[/TD]

[TD="align: center"]18[/TD]
[TD="align: right"]30 Sep 14[/TD]
[TD="align: right"]1,972.29[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]

[TD="align: center"]19[/TD]
[TD="align: right"]30 Jun 14[/TD]
[TD="align: right"]1,960.23[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]

[TD="align: right"]31/03/2013[/TD]
[TD="align: right"]30/06/2013[/TD]
[TD="align: right"]30/09/2013[/TD]
[TD="align: right"]31/12/2013[/TD]

[TD="align: center"]20[/TD]
[TD="align: right"]31 Mar 14[/TD]
[TD="align: right"]1,872.34[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]

[TD="align: right"]1,426.19[/TD]
[TD="bgcolor: #FFFF00, align: right"]1,569.19[/TD]
[TD="bgcolor: #FFFF00, align: right"]1,606.28[/TD]
[TD="align: right"]1,681.55[/TD]

[TD="align: center"]21[/TD]
[TD="align: right"]31 Dec 13[/TD]
[TD="align: right"]1,848.36[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]

[TD="bgcolor: #FFFF00, align: right"]1,569.19[/TD]
[TD="bgcolor: #FFFF00, align: right"]1,606.28[/TD]
[TD="align: right"]1,681.55[/TD]
[TD="align: right"]1,848.36[/TD]

[TD="align: center"]22[/TD]
[TD="align: right"]30 Sep 13[/TD]
[TD="align: right"]1,681.55[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]

[TD="align: right"]10.03%[/TD]
[TD="align: right"]2.36%[/TD]
[TD="align: right"]4.69%[/TD]
[TD="align: right"]9.92%[/TD]

[TD="align: center"]23[/TD]
[TD="bgcolor: #FFFF00, align: right"]28 Jun 13[/TD]
[TD="bgcolor: #FFFF00, align: right"]1,606.28[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]

[TD="align: center"]24[/TD]
[TD="bgcolor: #FFFF00, align: right"]28 Mar 13[/TD]
[TD="bgcolor: #FFFF00, align: right"]1,569.19[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]

[TD="align: center"]25[/TD]
[TD="align: right"]31 Dec 12[/TD]
[TD="align: right"]1,426.19[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]

</tbody>
Click to expand...
 
Upvote 0
mdelzi23 said:
I am not very familiar with the iserror function but it looks like it automatically looks at the next closest available date. I am just curious - If the data was in ascending order would you prefer to use the lookup function over the index/match function?
Click to expand...

Yes, if the dates are in ascending order, you can use a simple VLOOKUP.

B7: =VLOOKUP(A7,A2:B4,2,TRUE)

But with dates in descending order, the formula is a little more complicated. There are various ways you could do this, but I have used:

E7: =INDEX(E2:E4,MATCH(D7,D2:D4,-1)+ISERROR(MATCH(D7,D2:D4,)))

MATCH(D7,D2:D4,-1) will return 1, i.e. corresponding to the date 2 July 2012.
Is this an exact match for 30 June 2012? No!
So ISERROR(MATCH(D7,D2:D4,) is TRUE, and 1 + TRUE = 2, i.e. we want the value in the 2nd row.

Excel 2010
ABCDE

<tbody>
[TD="align: center"]1[/TD]
[TD="bgcolor: #FAFAFA, align: center"]Ascending Date Order[/TD]
[TD="bgcolor: #FAFAFA, align: right"][/TD]
[TD="align: right"][/TD]
[TD="bgcolor: #FAFAFA, align: center"]Descending Date Order[/TD]
[TD="bgcolor: #FAFAFA, align: right"][/TD]

[TD="align: center"]2[/TD]
[TD="bgcolor: #FAFAFA, align: center"]Thu 28 Jun 2012[/TD]
[TD="bgcolor: #FAFAFA, align: right"]1,000[/TD]
[TD="align: right"][/TD]
[TD="bgcolor: #FAFAFA, align: center"]Mon 2 Jul 2012[/TD]
[TD="bgcolor: #FAFAFA, align: right"]998[/TD]

[TD="align: center"]3[/TD]
[TD="bgcolor: #FAFAFA, align: center"]Fri 29 Jun 2012[/TD]
[TD="bgcolor: #FAFAFA, align: right"]1,001[/TD]
[TD="align: right"][/TD]
[TD="bgcolor: #FAFAFA, align: center"]Fri 29 Jun 2012[/TD]
[TD="bgcolor: #FAFAFA, align: right"]1,001[/TD]

[TD="align: center"]4[/TD]
[TD="bgcolor: #FAFAFA, align: center"]Mon 2 Jul 2012[/TD]
[TD="bgcolor: #FAFAFA, align: right"]998[/TD]
[TD="align: right"][/TD]
[TD="bgcolor: #FAFAFA, align: center"]Thu 28 Jun 2012[/TD]
[TD="bgcolor: #FAFAFA, align: right"]1,000[/TD]

[TD="align: center"]5[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]

[TD="align: center"]6[/TD]
[TD="bgcolor: #FAFAFA, align: center"]Lookup[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="bgcolor: #FAFAFA, align: center"]Lookup[/TD]
[TD="align: right"][/TD]

[TD="align: center"]7[/TD]
[TD="bgcolor: #FAFAFA, align: center"]Sat 30 Jun 2012[/TD]
[TD="align: right"]1,001[/TD]
[TD="align: right"][/TD]
[TD="bgcolor: #FAFAFA, align: center"]Sat 30 Jun 2012[/TD]
[TD="align: right"]1,001[/TD]

</tbody>
 
Upvote 0
Stephen,
Here is a tough one which is my ultimate goal. I have done this formula using multiple columns and then use a Max or Min comparison, but I was wondering if it can be done in one cell. Based on the returns I want to calculate the value of the return based on caps and predetermined loss protection... The return is a point to point return in this example 12 months. let's assume that over any 1 year period the max cap you can earn is 10% on the S&P 500. So if the index earns 12% for the year, your return is capped at 10%. If you earn 5% then you earn the entire 5%. Let's also assume that for any losses over that 1 year period you have protection of up to a 10% loss. So if you lose 8%, you lose nothing. If you lose 15%, then you only end up losing 5% because the first 10% loss is erased. I am assuming this would be a very complex if,then formula. Let me know if you can calculate this... Thanks so much for your help.
 
Upvote 0
? Do you mean like this:

D6: =MEDIAN(PosCap,A6,MIN(A6+NegOffset,0))

Excel 2010
AB
Positive Cap
Negative Offset
Returns:

<colgroup><col style="width: 25pxpx"><col><col></colgroup><thead>
</thead><tbody>
[TD="align: center"]1[/TD]

[TD="align: right"]10%[/TD]

[TD="align: center"]2[/TD]

[TD="align: right"]10%[/TD]

[TD="align: center"]3[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]

[TD="align: center"]4[/TD]

[TD="align: right"][/TD]

[TD="align: center"]5[/TD]
[TD="align: right"]Raw[/TD]
[TD="align: right"]Adjusted[/TD]

[TD="align: center"]6[/TD]
[TD="align: right"]12%[/TD]
[TD="align: right"]10%[/TD]

[TD="align: center"]7[/TD]
[TD="align: right"]10%[/TD]
[TD="align: right"]10%[/TD]

[TD="align: center"]8[/TD]
[TD="align: right"]8%[/TD]
[TD="align: right"]8%[/TD]

[TD="align: center"]9[/TD]
[TD="align: right"]2%[/TD]
[TD="align: right"]2%[/TD]

[TD="align: center"]10[/TD]
[TD="align: right"]0%[/TD]
[TD="align: right"]0%[/TD]

[TD="align: center"]11[/TD]
[TD="align: right"]-2%[/TD]
[TD="align: right"]0%[/TD]

[TD="align: center"]12[/TD]
[TD="align: right"]-10%[/TD]
[TD="align: right"]0%[/TD]

[TD="align: center"]13[/TD]
[TD="align: right"]-12%[/TD]
[TD="align: right"]-2%[/TD]

[TD="align: center"]14[/TD]
[TD="align: right"]-14%[/TD]
[TD="align: right"]-4%[/TD]

</tbody>

​
 
Upvote 0
Wow! You really can come up with the same thing with unlimited formulas or approaches. Here is what I came up with.

=IF($J4>$M$2,MAX($M$2),IF(AND($J4>0,$J4<$M$2),$J4,IF($J4<$M$3,-$M$3+$J4,IF(AND($J4<0,$J4>$M$3),0))))

J4 = Index return
M2 = PosCap = 10%
M3 = Negative offset

You seem to do everything much easier than I do. :eeek:
 
Upvote 0
Stepehen,
You have been tremendous. Now that the nuts and bolts of the spreadsheet are set. My goal is to run random dates comparing raw return versus cap/protected adjusted return on a set dollar amount over 1 year, 3 year and 6 year rolling periods. I would like to see each of the scenarios run for an investment period of 6 years. So if you calculate the one year rolling periods it would include 6 consecutive 1 year periods. If you use 3 year rolling periods, it would be 2 consecutive 3 year rolling periods and obviously 6 years would be one 6 year rolling period.

i.e. - input - A1 - date = 01/02/2003
A2 - $amount - $100,000


result #1 - compare six consecutive 1 year periods compounding the dollar amount on a raw versus cap/protected adjusted basis.

result #2 - compare 2 consecutive 3 year periods compounding the dollar amount on a raw versus cap/protected adjusted basis.

result #3 - compare one 6 year period compounding the dollar amount on a raw versus cap/protected adjusted basis.

The caps and offset will be adjusted to the length of rolling period. Below are the current caps and offsets for each term (rolling period).

[TABLE="class: grid, width: 500, align: left"]
<tbody>[TR]
[TD]A
[/TD]
[TD]B[/TD]
[TD]C[/TD]
[TD]D[/TD]
[TD]E[/TD]
[TD]F[/TD]
[TD]G[/TD]
[TD]H[/TD]
[/TR]
[TR]
[TD]Term[/TD]
[TD]1[/TD]
[TD]1[/TD]
[TD]3[/TD]
[TD]3[/TD]
[TD]6[/TD]
[TD]6[/TD]
[TD]6[/TD]
[/TR]
[TR]
[TD]Cap[/TD]
[TD].1[/TD]
[TD].03[/TD]
[TD].26[/TD]
[TD].17[/TD]
[TD].82[/TD]
[TD].63[/TD]
[TD].43[/TD]
[/TR]
[TR]
[TD]Offset[/TD]
[TD]-.10[/TD]
[TD]100[/TD]
[TD]-.10[/TD]
[TD]-.15[/TD]
[TD]-.10[/TD]
[TD]-.15[/TD]
[TD]-.25[/TD]
[/TR]
</tbody>[/TABLE]
[TABLE="width: 448"]
<colgroup><col width="64" span="7" style="width:48pt"> </colgroup><tbody>[TR]
[TD="class: xl63, width: 128, colspan: 2"][/TD]
[TD="class: xl63, width: 128, colspan: 2"] [/TD]
[TD="class: xl63, width: 192, colspan: 3"] [/TD]
[/TR]
[TR]
[TD="class: xl64"] [/TD]
[TD="class: xl65"][/TD]
[TD="class: xl66"][/TD]
[TD="class: xl66"][/TD]
[TD="class: xl64"][/TD]
[TD="class: xl66"][/TD]
[TD="class: xl66"][/TD]
[/TR]
</tbody>[/TABLE]

I would only need to see how you calculate one rolling period over 6 years. Thank you so much for your help.
 
Upvote 0
You must log in or register to reply here.

Similar threads

JCabral
  • Question Question
Working days per worker, per event and month
Replies
2
Views
215
JCabral
JCabral
R
  • Solved
Subtracting all calendar days, but end date cannot fall on a weekend or holiday. If it does, the end date shifts to the preceding work day.
Replies
8
Views
2K
Romy
R
R
  • Question Question
Calculate a total amount based on number of days in period and incremental increases in daily rate
Replies
0
Views
613
Rochelle13
R
S
  • Question Question
Algo help needed to find if a stock moved greater than 175% within a 5 day period over one year time
Replies
5
Views
391
offthelip
O
S
  • Solved
Networkdays formula issue
Replies
3
Views
256
Joe4
Joe4

Forum statistics

Threads
1,222,900
Messages
6,168,926
Members
452,227
Latest member
sam1121

Share this page

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top