Finding the Peak and Trough of a Data set and then the days between Trough to Peak

M

Michael515

Board Regular
Joined
Jul 10, 2014
Messages
136
The generic idea is we have prices of Treasury Bonds that fluctuate over time. They hit a ceiling and then they decline and hit the floor. and then at the floor they start rising back up again. My desire is to find the these peaks and toughs and then find how many days between these peaks and troughs, here's a snapshot of the data set:

[TABLE="width: 927"]
<colgroup><col><col span="4"><col><col><col><col span="4"></colgroup><tbody>[TR]
[TD]Date[/TD]
[TD]Open[/TD]
[TD]High[/TD]
[TD]Low[/TD]
[TD]Close[/TD]
[TD]Volume[/TD]
[TD]Adj Close[/TD]
[TD]Semi-Annual Yield[/TD]
[TD]Theoretical Bond Price[/TD]
[TD]Index[/TD]
[TD]Coupon[/TD]
[TD]Total Value[/TD]
[/TR]
[TR]
[TD="align: right"]1/2/1962[/TD]
[TD="align: right"]4.06[/TD]
[TD="align: right"]4.06[/TD]
[TD="align: right"]4.06[/TD]
[TD="align: right"]4.06[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]4.06[/TD]
[TD="align: right"]0.0203[/TD]
[TD="align: right"]1015.488984[/TD]
[TD="align: right"]1000[/TD]
[TD="align: right"]0.111232877[/TD]
[TD="align: right"]1000.111233[/TD]
[/TR]
[TR]
[TD="align: right"]1/3/1962[/TD]
[TD="align: right"]4.03[/TD]
[TD="align: right"]4.03[/TD]
[TD="align: right"]4.03[/TD]
[TD="align: right"]4.03[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]4.03[/TD]
[TD="align: right"]0.02015[/TD]
[TD="align: right"]1017.960568[/TD]
[TD="align: right"]1002.55[/TD]
[TD="align: right"]0.110410959[/TD]
[TD="align: right"]1002.771644[/TD]
[/TR]
[TR]
[TD="align: right"]1/4/1962[/TD]
[TD="align: right"]3.99[/TD]
[TD="align: right"]3.99[/TD]
[TD="align: right"]3.99[/TD]
[TD="align: right"]3.99[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]3.99[/TD]
[TD="align: right"]0.01995[/TD]
[TD="align: right"]1021.267124[/TD]
[TD="align: right"]1005.95867[/TD]
[TD="align: right"]0.109315068[/TD]
[TD="align: right"]1006.289629[/TD]
[/TR]
[TR]
[TD="align: right"]1/5/1962[/TD]
[TD="align: right"]4.02[/TD]
[TD="align: right"]4.02[/TD]
[TD="align: right"]4.02[/TD]
[TD="align: right"]4.02[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]4.02[/TD]
[TD="align: right"]0.0201[/TD]
[TD="align: right"]1018.786014[/TD]
[TD="align: right"]1003.393475[/TD]
[TD="align: right"]0.110136986[/TD]
[TD="align: right"]1003.834571[/TD]
[/TR]
[TR]
[TD="align: right"]1/8/1962[/TD]
[TD="align: right"]4.03[/TD]
[TD="align: right"]4.03[/TD]
[TD="align: right"]4.03[/TD]
[TD="align: right"]4.03[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]4.03[/TD]
[TD="align: right"]0.02015[/TD]
[TD="align: right"]1017.960568[/TD]
[TD="align: right"]1002.540591[/TD]
[TD="align: right"]0.110410959[/TD]
[TD="align: right"]1003.092098[/TD]
[/TR]
[TR]
[TD="align: right"]1/9/1962[/TD]
[TD="align: right"]4.05[/TD]
[TD="align: right"]4.05[/TD]
[TD="align: right"]4.05[/TD]
[TD="align: right"]4.05[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]4.05[/TD]
[TD="align: right"]0.02025[/TD]
[TD="align: right"]1016.312053[/TD]
[TD="align: right"]1000.836272[/TD]
[TD="align: right"]0.110958904[/TD]
[TD="align: right"]1001.498738[/TD]
[/TR]
[TR]
[TD="align: right"]1/10/1962[/TD]
[TD="align: right"]4.07[/TD]
[TD="align: right"]4.07[/TD]
[TD="align: right"]4.07[/TD]
[TD="align: right"]4.07[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]4.07[/TD]
[TD="align: right"]0.02035[/TD]
[TD="align: right"]1014.666705[/TD]
[TD="align: right"]999.1348503[/TD]
[TD="align: right"]0.111506849[/TD]
[TD="align: right"]999.9088229[/TD]
[/TR]
[TR]
[TD="align: right"]1/11/1962[/TD]
[TD="align: right"]4.08[/TD]
[TD="align: right"]4.08[/TD]
[TD="align: right"]4.08[/TD]
[TD="align: right"]4.08[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]4.08[/TD]
[TD="align: right"]0.0204[/TD]
[TD="align: right"]1013.845217[/TD]
[TD="align: right"]998.2855856[/TD]
[TD="align: right"]0.111780822[/TD]
[TD="align: right"]999.1713391[/TD]
[/TR]
[TR]
[TD="align: right"]1/12/1962[/TD]
[TD="align: right"]4.08[/TD]
[TD="align: right"]4.08[/TD]
[TD="align: right"]4.08[/TD]
[TD="align: right"]4.08[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]4.08[/TD]
[TD="align: right"]0.0204[/TD]
[TD="align: right"]1013.845217[/TD]
[TD="align: right"]998.2855856[/TD]
[TD="align: right"]0.111780822[/TD]
[TD="align: right"]999.2831199[/TD]
[/TR]
[TR]
[TD="align: right"]1/15/1962[/TD]
[TD="align: right"]4.1[/TD]
[TD="align: right"]4.1[/TD]
[TD="align: right"]4.1[/TD]
[TD="align: right"]4.1[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]4.1[/TD]
[TD="align: right"]0.0205[/TD]
[TD="align: right"]1012.204607[/TD]
[TD="align: right"]996.5885002[/TD]
[TD="align: right"]0.112328767[/TD]
[TD="align: right"]997.6983632[/TD]
[/TR]
[TR]
[TD="align: right"]1/16/1962[/TD]
[TD="align: right"]4.13[/TD]
[TD="align: right"]4.13[/TD]
[TD="align: right"]4.13[/TD]
[TD="align: right"]4.13[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]4.13[/TD]
[TD="align: right"]0.02065[/TD]
[TD="align: right"]1009.749597[/TD]
[TD="align: right"]994.0471995[/TD]
[TD="align: right"]0.113150685[/TD]
[TD="align: right"]995.2702132[/TD]
[/TR]
[TR]
[TD="align: right"]1/17/1962[/TD]
[TD="align: right"]4.12[/TD]
[TD="align: right"]4.12[/TD]
[TD="align: right"]4.12[/TD]
[TD="align: right"]4.12[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]4.12[/TD]
[TD="align: right"]0.0206[/TD]
[TD="align: right"]1010.567147[/TD]
[TD="align: right"]994.8921396[/TD]
[TD="align: right"]0.112876712[/TD]
[TD="align: right"]996.22803[/TD]
[/TR]
[TR]
[TD="align: right"]1/18/1962[/TD]
[TD="align: right"]4.11[/TD]
[TD="align: right"]4.11[/TD]
[TD="align: right"]4.11[/TD]
[TD="align: right"]4.11[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]4.11[/TD]
[TD="align: right"]0.02055[/TD]
[TD="align: right"]1011.385484[/TD]
[TD="align: right"]995.7377979[/TD]
[TD="align: right"]0.11260274[/TD]
[TD="align: right"]997.1862911[/TD]
[/TR]
[TR]
[TD="align: right"]1/19/1962[/TD]
[TD="align: right"]4.11[/TD]
[TD="align: right"]4.11[/TD]
[TD="align: right"]4.11[/TD]
[TD="align: right"]4.11[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]4.11[/TD]
[TD="align: right"]0.02055[/TD]
[TD="align: right"]1011.385484[/TD]
[TD="align: right"]995.7377979[/TD]
[TD="align: right"]0.11260274[/TD]
[TD="align: right"]997.2988938[/TD]
[/TR]
[TR]
[TD="align: right"]1/22/1962[/TD]
[TD="align: right"]4.09[/TD]
[TD="align: right"]4.09[/TD]
[TD="align: right"]4.09[/TD]
[TD="align: right"]4.09[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]4.09[/TD]
[TD="align: right"]0.02045[/TD]
[TD="align: right"]1013.024518[/TD]
[TD="align: right"]997.4305522[/TD]
[TD="align: right"]0.112054795[/TD]
[TD="align: right"]999.1037029[/TD]
[/TR]
[TR]
[TD="align: right"]1/23/1962[/TD]
[TD="align: right"]4.11[/TD]
[TD="align: right"]4.11[/TD]
[TD="align: right"]4.11[/TD]
[TD="align: right"]4.11[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]4.11[/TD]
[TD="align: right"]0.02055[/TD]
[TD="align: right"]1011.385484[/TD]
[TD="align: right"]995.7349202[/TD]
[TD="align: right"]0.11260274[/TD]
[TD="align: right"]997.5206737[/TD]
[/TR]
[TR]
[TD="align: right"]1/24/1962[/TD]
[TD="align: right"]4.1[/TD]
[TD="align: right"]4.1[/TD]
[TD="align: right"]4.1[/TD]
[TD="align: right"]4.1[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]4.1[/TD]
[TD="align: right"]0.0205[/TD]
[TD="align: right"]1012.204607[/TD]
[TD="align: right"]996.5812949[/TD]
[TD="align: right"]0.112328767[/TD]
[TD="align: right"]998.4793771[/TD]
[/TR]
[TR]
[TD="align: right"]1/25/1962[/TD]
[TD="align: right"]4.11[/TD]
[TD="align: right"]4.11[/TD]
[TD="align: right"]4.11[/TD]
[TD="align: right"]4.11[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]4.11[/TD]
[TD="align: right"]0.02055[/TD]
[TD="align: right"]1011.385484[/TD]
[TD="align: right"]995.7342008[/TD]
[TD="align: right"]0.11260274[/TD]
[TD="align: right"]997.7448857[/TD]
[/TR]
[TR]
[TD="align: right"]1/26/1962[/TD]
[TD="align: right"]4.11[/TD]
[TD="align: right"]4.11[/TD]
[TD="align: right"]4.11[/TD]
[TD="align: right"]4.11[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]4.11[/TD]
[TD="align: right"]0.02055[/TD]
[TD="align: right"]1011.385484[/TD]
[TD="align: right"]995.7342008[/TD]
[TD="align: right"]0.11260274[/TD]
[TD="align: right"]997.8574885[/TD]
[/TR]
[TR]
[TD="align: right"]1/29/1962[/TD]
[TD="align: right"]4.12[/TD]
[TD="align: right"]4.12[/TD]
[TD="align: right"]4.12[/TD]
[TD="align: right"]4.12[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]4.12[/TD]
[TD="align: right"]0.0206[/TD]
[TD="align: right"]1010.567147[/TD]
[TD="align: right"]994.8878267[/TD]
[TD="align: right"]0.112876712[/TD]
[TD="align: right"]997.1239911[/TD]
[/TR]
[TR]
[TD="align: right"]1/30/1962[/TD]
[TD="align: right"]4.11[/TD]
[TD="align: right"]4.11[/TD]
[TD="align: right"]4.11[/TD]
[TD="align: right"]4.11[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]4.11[/TD]
[TD="align: right"]0.02055[/TD]
[TD="align: right"]1011.385484[/TD]
[TD="align: right"]995.7334814[/TD]
[TD="align: right"]0.11260274[/TD]
[TD="align: right"]998.0822485[/TD]
[/TR]
[TR]
[TD="align: right"]1/31/1962[/TD]
[TD="align: right"]4.1[/TD]
[TD="align: right"]4.1[/TD]
[TD="align: right"]4.1[/TD]
[TD="align: right"]4.1[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]4.1[/TD]
[TD="align: right"]0.0205[/TD]
[TD="align: right"]1012.204607[/TD]
[TD="align: right"]996.5798549[/TD]
[TD="align: right"]0.112328767[/TD]
[TD="align: right"]999.0409507[/TD]
[/TR]
[TR]
[TD="align: right"]2/1/1962[/TD]
[TD="align: right"]4.09[/TD]
[TD="align: right"]4.09[/TD]
[TD="align: right"]4.09[/TD]
[TD="align: right"]4.09[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]4.09[/TD]
[TD="align: right"]0.02045[/TD]
[TD="align: right"]1013.024518[/TD]
[TD="align: right"]997.4269477[/TD]
[TD="align: right"]0.112054795[/TD]
[TD="align: right"]1000.000098[/TD]
[/TR]
[TR]
[TD="align: right"]2/2/1962[/TD]
[TD="align: right"]4.08[/TD]
[TD="align: right"]4.08[/TD]
[TD="align: right"]4.08[/TD]
[TD="align: right"]4.08[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]4.08[/TD]
[TD="align: right"]0.0204[/TD]
[TD="align: right"]1013.845217[/TD]
[TD="align: right"]998.2747606[/TD]
[TD="align: right"]0.111780822[/TD]
[TD="align: right"]1000.959692[/TD]
[/TR]
[TR]
[TD="align: right"]2/5/1962[/TD]
[TD="align: right"]4.07[/TD]
[TD="align: right"]4.07[/TD]
[TD="align: right"]4.07[/TD]
[TD="align: right"]4.07[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]4.07[/TD]
[TD="align: right"]0.02035[/TD]
[TD="align: right"]1014.666705[/TD]
[TD="align: right"]999.1232942[/TD]
[TD="align: right"]0.111506849[/TD]
[TD="align: right"]1001.919733[/TD]
[/TR]
[TR]
[TD="align: right"]2/6/1962[/TD]
[TD="align: right"]4.06[/TD]
[TD="align: right"]4.06[/TD]
[TD="align: right"]4.06[/TD]
[TD="align: right"]4.06[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]4.06[/TD]
[TD="align: right"]0.0203[/TD]
[TD="align: right"]1015.488984[/TD]
[TD="align: right"]999.972549[/TD]
[TD="align: right"]0.111232877[/TD]
[TD="align: right"]1002.88022[/TD]
[/TR]
[TR]
[TD="align: right"]2/7/1962[/TD]
[TD="align: right"]4.07[/TD]
[TD="align: right"]4.07[/TD]
[TD="align: right"]4.07[/TD]
[TD="align: right"]4.07[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]4.07[/TD]
[TD="align: right"]0.02035[/TD]
[TD="align: right"]1014.666705[/TD]
[TD="align: right"]999.1225723[/TD]
[TD="align: right"]0.111506849[/TD]
[TD="align: right"]1002.14175[/TD]
[/TR]
[TR]
[TD="align: right"]2/8/1962[/TD]
[TD="align: right"]4.07[/TD]
[TD="align: right"]4.07[/TD]
[TD="align: right"]4.07[/TD]
[TD="align: right"]4.07[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]4.07[/TD]
[TD="align: right"]0.02035[/TD]
[TD="align: right"]1014.666705[/TD]
[TD="align: right"]999.1225723[/TD]
[TD="align: right"]0.111506849[/TD]
[TD="align: right"]1002.253257[/TD]
[/TR]
[TR]
[TD="align: right"]2/9/1962[/TD]
[TD="align: right"]4.05[/TD]
[TD="align: right"]4.05[/TD]
[TD="align: right"]4.05[/TD]
[TD="align: right"]4.05[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]4.05[/TD]
[TD="align: right"]0.02025[/TD]
[TD="align: right"]1016.312053[/TD]
[TD="align: right"]1000.821081[/TD]
[TD="align: right"]0.110958904[/TD]
[TD="align: right"]1004.062725[/TD]
[/TR]
[TR]
[TD="align: right"]2/13/1962[/TD]
[TD="align: right"]4.03[/TD]
[TD="align: right"]4.03[/TD]
[TD="align: right"]4.03[/TD]
[TD="align: right"]4.03[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]4.03[/TD]
[TD="align: right"]0.02015[/TD]
[TD="align: right"]1017.960568[/TD]
[TD="align: right"]1002.522477[/TD]
[TD="align: right"]0.110410959[/TD]
[TD="align: right"]1005.874531[/TD]
[/TR]
[TR]
[TD="align: right"]2/14/1962[/TD]
[TD="align: right"]4.03[/TD]
[TD="align: right"]4.03[/TD]
[TD="align: right"]4.03[/TD]
[TD="align: right"]4.03[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]4.03[/TD]
[TD="align: right"]0.02015[/TD]
[TD="align: right"]1017.960568[/TD]
[TD="align: right"]1002.522477[/TD]
[TD="align: right"]0.110410959[/TD]
[TD="align: right"]1005.984942[/TD]
[/TR]
[TR]
[TD="align: right"]2/15/1962[/TD]
[TD="align: right"]4.02[/TD]
[TD="align: right"]4.02[/TD]
[TD="align: right"]4.02[/TD]
[TD="align: right"]4.02[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]4.02[/TD]
[TD="align: right"]0.0201[/TD]
[TD="align: right"]1018.786014[/TD]
[TD="align: right"]1003.374621[/TD]
[TD="align: right"]0.110136986[/TD]
[TD="align: right"]1006.947223[/TD]
[/TR]
[TR]
[TD="align: right"]2/16/1962[/TD]
[TD="align: right"]4.02[/TD]
[TD="align: right"]4.02[/TD]
[TD="align: right"]4.02[/TD]
[TD="align: right"]4.02[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]4.02[/TD]
[TD="align: right"]0.0201[/TD]
[TD="align: right"]1018.786014[/TD]
[TD="align: right"]1003.374621[/TD]
[TD="align: right"]0.110136986[/TD]
[TD="align: right"]1007.05736[/TD]
[/TR]
[TR]
[TD="align: right"]2/19/1962[/TD]
[TD="align: right"]4.01[/TD]
[TD="align: right"]4.01[/TD]
[TD="align: right"]4.01[/TD]
[TD="align: right"]4.01[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]4.01[/TD]
[TD="align: right"]0.02005[/TD]
[TD="align: right"]1019.612256[/TD]
[TD="align: right"]1004.227489[/TD]
[TD="align: right"]0.109863014[/TD]
[TD="align: right"]1008.020092[/TD]
[/TR]
[TR]
[TD="align: right"]2/20/1962[/TD]
[TD="align: right"]4.05[/TD]
[TD="align: right"]4.05[/TD]
[TD="align: right"]4.05[/TD]
[TD="align: right"]4.05[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]4.05[/TD]
[TD="align: right"]0.02025[/TD]
[TD="align: right"]1016.312053[/TD]
[TD="align: right"]1000.813116[/TD]
[TD="align: right"]0.110958904[/TD]
[TD="align: right"]1004.716677[/TD]
[/TR]
[TR]
[TD="align: right"]2/21/1962[/TD]
[TD="align: right"]4.03[/TD]
[TD="align: right"]4.03[/TD]
[TD="align: right"]4.03[/TD]
[TD="align: right"]4.03[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]4.03[/TD]
[TD="align: right"]0.02015[/TD]
[TD="align: right"]1017.960568[/TD]
[TD="align: right"]1002.514498[/TD]
[TD="align: right"]0.110410959[/TD]
[TD="align: right"]1006.52847[/TD]
[/TR]
[TR]
[TD="align: right"]2/23/1962[/TD]
[TD="align: right"]4.02[/TD]
[TD="align: right"]4.02[/TD]
[TD="align: right"]4.02[/TD]
[TD="align: right"]4.02[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]4.02[/TD]
[TD="align: right"]0.0201[/TD]
[TD="align: right"]1018.786014[/TD]
[TD="align: right"]1003.366635[/TD]
[TD="align: right"]0.110136986[/TD]
[TD="align: right"]1007.490745[/TD]
[/TR]
[TR]
[TD="align: right"]2/26/1962[/TD]
[TD="align: right"]4[/TD]
[TD="align: right"]4[/TD]
[TD="align: right"]4[/TD]
[TD="align: right"]4[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]4[/TD]
[TD="align: right"]0.02[/TD]
[TD="align: right"]1020.439292[/TD]
[TD="align: right"]1005.072358[/TD]
[TD="align: right"]0.109589041[/TD]
[TD="align: right"]1009.306057[/TD]
[/TR]
[TR]
[TD="align: right"]2/27/1962[/TD]
[TD="align: right"]4.01[/TD]
[TD="align: right"]4.01[/TD]
[TD="align: right"]4.01[/TD]
[TD="align: right"]4.01[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]4.01[/TD]
[TD="align: right"]0.02005[/TD]
[TD="align: right"]1019.612256[/TD]
[TD="align: right"]1004.218047[/TD]
[TD="align: right"]0.109863014[/TD]
[TD="align: right"]1008.561609[/TD]
[/TR]
[TR]
[TD="align: right"]2/28/1962[/TD]
[TD="align: right"]4[/TD]
[TD="align: right"]4[/TD]
[TD="align: right"]4[/TD]
[TD="align: right"]4[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]4[/TD]
[TD="align: right"]0.02[/TD]
[TD="align: right"]1020.439292[/TD]
[TD="align: right"]1005.071632[/TD]
[TD="align: right"]0.109589041[/TD]
[TD="align: right"]1009.524783[/TD]
[/TR]
[TR]
[TD="align: right"]3/1/1962[/TD]
[TD="align: right"]3.98[/TD]
[TD="align: right"]3.98[/TD]
[TD="align: right"]3.98[/TD]
[TD="align: right"]3.98[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]3.98[/TD]
[TD="align: right"]0.0199[/TD]
[TD="align: right"]1022.095752[/TD]
[TD="align: right"]1006.780254[/TD]
[TD="align: right"]0.109041096[/TD]
[TD="align: right"]1011.342446[/TD]
[/TR]
[TR]
[TD="align: right"]3/2/1962[/TD]
[TD="align: right"]3.98[/TD]
[TD="align: right"]3.98[/TD]
[TD="align: right"]3.98[/TD]
[TD="align: right"]3.98[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]3.98[/TD]
[TD="align: right"]0.0199[/TD]
[TD="align: right"]1022.095752[/TD]
[TD="align: right"]1006.780254[/TD]
[TD="align: right"]0.109041096[/TD]
[TD="align: right"]1011.451487[/TD]
[/TR]
[TR]
[TD="align: right"]3/5/1962[/TD]
[TD="align: right"]4[/TD]
[TD="align: right"]4[/TD]
[TD="align: right"]4[/TD]
[TD="align: right"]4[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]4[/TD]
[TD="align: right"]0.02[/TD]
[TD="align: right"]1020.439292[/TD]
[TD="align: right"]1005.068728[/TD]
[TD="align: right"]0.109589041[/TD]
[TD="align: right"]1009.84955[/TD]
[/TR]
[TR]
[TD="align: right"]3/6/1962[/TD]
[TD="align: right"]4.01[/TD]
[TD="align: right"]4.01[/TD]
[TD="align: right"]4.01[/TD]
[TD="align: right"]4.01[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]4.01[/TD]
[TD="align: right"]0.02005[/TD]
[TD="align: right"]1019.612256[/TD]
[TD="align: right"]1004.214419[/TD]
[TD="align: right"]0.109863014[/TD]
[TD="align: right"]1009.105104[/TD]
[/TR]
[TR]
[TD="align: right"]3/7/1962[/TD]
[TD="align: right"]4[/TD]
[TD="align: right"]4[/TD]
[TD="align: right"]4[/TD]
[TD="align: right"]4[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]4[/TD]
[TD="align: right"]0.02[/TD]
[TD="align: right"]1020.439292[/TD]
[TD="align: right"]1005.068002[/TD]
[TD="align: right"]0.109589041[/TD]
[TD="align: right"]1010.068275[/TD]
[/TR]
[TR]
[TD="align: right"]3/8/1962[/TD]
[TD="align: right"]3.98[/TD]
[TD="align: right"]3.98[/TD]
[TD="align: right"]3.98[/TD]
[TD="align: right"]3.98[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]3.98[/TD]
[TD="align: right"]0.0199[/TD]
[TD="align: right"]1022.095752[/TD]
[TD="align: right"]1006.776617[/TD]
[TD="align: right"]0.109041096[/TD]
[TD="align: right"]1011.885932[/TD]
[/TR]
[TR]
[TD="align: right"]3/9/1962[/TD]
[TD="align: right"]3.96[/TD]
[TD="align: right"]3.96[/TD]
[TD="align: right"]3.96[/TD]
[TD="align: right"]3.96[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]3.96[/TD]
[TD="align: right"]0.0198[/TD]
[TD="align: right"]1023.755403[/TD]
[TD="align: right"]1008.488137[/TD]
[TD="align: right"]0.108493151[/TD]
[TD="align: right"]1013.705946[/TD]
[/TR]
[TR]
[TD="align: right"]3/12/1962[/TD]
[TD="align: right"]3.94[/TD]
[TD="align: right"]3.94[/TD]
[TD="align: right"]3.94[/TD]
[TD="align: right"]3.94[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]3.94[/TD]
[TD="align: right"]0.0197[/TD]
[TD="align: right"]1025.41825[/TD]
[TD="align: right"]1010.202567[/TD]
[TD="align: right"]0.107945205[/TD]
[TD="align: right"]1015.528321[/TD]
[/TR]
[TR]
[TD="align: right"]3/13/1962[/TD]
[TD="align: right"]3.92[/TD]
[TD="align: right"]3.92[/TD]
[TD="align: right"]3.92[/TD]
[TD="align: right"]3.92[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]3.92[/TD]
[TD="align: right"]0.0196[/TD]
[TD="align: right"]1027.084301[/TD]
[TD="align: right"]1011.919912[/TD]
[TD="align: right"]0.10739726[/TD]
[TD="align: right"]1017.353062[/TD]
[/TR]
[TR]
[TD="align: right"]3/14/1962[/TD]
[TD="align: right"]3.93[/TD]
[TD="align: right"]3.93[/TD]
[TD="align: right"]3.93[/TD]
[TD="align: right"]3.93[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]3.93[/TD]
[TD="align: right"]0.01965[/TD]
[TD="align: right"]1026.250875[/TD]
[TD="align: right"]1011.05978[/TD]
[TD="align: right"]0.107671233[/TD]
[TD="align: right"]1016.600602[/TD]
[/TR]
[TR]
[TD="align: right"]3/15/1962[/TD]
[TD="align: right"]3.96[/TD]
[TD="align: right"]3.96[/TD]
[TD="align: right"]3.96[/TD]
[TD="align: right"]3.96[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]3.96[/TD]
[TD="align: right"]0.0198[/TD]
[TD="align: right"]1023.755403[/TD]
[TD="align: right"]1008.481577[/TD]
[TD="align: right"]0.108493151[/TD]
[TD="align: right"]1014.130892[/TD]
[/TR]
[TR]
[TD="align: right"]3/16/1962[/TD]
[TD="align: right"]3.96[/TD]
[TD="align: right"]3.96[/TD]
[TD="align: right"]3.96[/TD]
[TD="align: right"]3.96[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]3.96[/TD]
[TD="align: right"]0.0198[/TD]
[TD="align: right"]1023.755403[/TD]
[TD="align: right"]1008.481577[/TD]
[TD="align: right"]0.108493151[/TD]
[TD="align: right"]1014.239385[/TD]
[/TR]
[TR]
[TD="align: right"]3/19/1962[/TD]
[TD="align: right"]3.93[/TD]
[TD="align: right"]3.93[/TD]
[TD="align: right"]3.93[/TD]
[TD="align: right"]3.93[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]3.93[/TD]
[TD="align: right"]0.01965[/TD]
[TD="align: right"]1026.250875[/TD]
[TD="align: right"]1011.053205[/TD]
[TD="align: right"]0.107671233[/TD]
[TD="align: right"]1016.918685[/TD]
[/TR]
[TR]
[TD="align: right"]3/20/1962[/TD]
[TD="align: right"]3.91[/TD]
[TD="align: right"]3.91[/TD]
[TD="align: right"]3.91[/TD]
[TD="align: right"]3.91[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]3.91[/TD]
[TD="align: right"]0.01955[/TD]
[TD="align: right"]1027.918529[/TD]
[TD="align: right"]1012.771996[/TD]
[TD="align: right"]0.107123288[/TD]
[TD="align: right"]1018.744598[/TD]
[/TR]
[TR]
[TD="align: right"]3/21/1962[/TD]
[TD="align: right"]3.86[/TD]
[TD="align: right"]3.86[/TD]
[TD="align: right"]3.86[/TD]
[TD="align: right"]3.86[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]3.86[/TD]
[TD="align: right"]0.0193[/TD]
[TD="align: right"]1032.10174[/TD]
[TD="align: right"]1017.076277[/TD]
[TD="align: right"]0.105753425[/TD]
[TD="align: right"]1023.154633[/TD]
[/TR]
[TR]
[TD="align: right"]3/22/1962[/TD]
[TD="align: right"]3.83[/TD]
[TD="align: right"]3.83[/TD]
[TD="align: right"]3.83[/TD]
[TD="align: right"]3.83[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]3.83[/TD]
[TD="align: right"]0.01915[/TD]
[TD="align: right"]1034.621349[/TD]
[TD="align: right"]1019.669821[/TD]
[TD="align: right"]0.104931507[/TD]
[TD="align: right"]1025.853109[/TD]
[/TR]
[TR]
[TD="align: right"]3/23/1962[/TD]
[TD="align: right"]3.87[/TD]
[TD="align: right"]3.87[/TD]
[TD="align: right"]3.87[/TD]
[TD="align: right"]3.87[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]3.87[/TD]
[TD="align: right"]0.01935[/TD]
[TD="align: right"]1031.263486[/TD]
[TD="align: right"]1016.202944[/TD]
[TD="align: right"]0.106027397[/TD]
[TD="align: right"]1022.492259[/TD]
[/TR]
[TR]
[TD="align: right"]3/26/1962[/TD]
[TD="align: right"]3.89[/TD]
[TD="align: right"]3.89[/TD]
[TD="align: right"]3.89[/TD]
[TD="align: right"]3.89[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]3.89[/TD]
[TD="align: right"]0.01945[/TD]
[TD="align: right"]1029.589398[/TD]
[TD="align: right"]1014.475399[/TD]
[TD="align: right"]0.106575342[/TD]
[TD="align: right"]1020.871289[/TD]
[/TR]
[TR]
[TD="align: right"]3/27/1962[/TD]
[TD="align: right"]3.9[/TD]
[TD="align: right"]3.9[/TD]
[TD="align: right"]3.9[/TD]
[TD="align: right"]3.9[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]3.9[/TD]
[TD="align: right"]0.0195[/TD]
[TD="align: right"]1028.753561[/TD]
[TD="align: right"]1013.613095[/TD]
[TD="align: right"]0.106849315[/TD]
[TD="align: right"]1020.115834[/TD]
[/TR]
[TR]
[TD="align: right"]3/28/1962[/TD]
[TD="align: right"]3.9[/TD]
[TD="align: right"]3.9[/TD]
[TD="align: right"]3.9[/TD]
[TD="align: right"]3.9[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]3.9[/TD]
[TD="align: right"]0.0195[/TD]
[TD="align: right"]1028.753561[/TD]
[TD="align: right"]1013.613095[/TD]
[TD="align: right"]0.106849315[/TD]
[TD="align: right"]1020.222684[/TD]
[/TR]
[TR]
[TD="align: right"]3/29/1962[/TD]
[TD="align: right"]3.9[/TD]
[TD="align: right"]3.9[/TD]
[TD="align: right"]3.9[/TD]
[TD="align: right"]3.9[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]3.9[/TD]
[TD="align: right"]0.0195[/TD]
[TD="align: right"]1028.753561[/TD]
[TD="align: right"]1013.613095[/TD]
[TD="align: right"]0.106849315[/TD]
[TD="align: right"]1020.329533[/TD]
[/TR]
[TR]
[TD="align: right"]3/30/1962[/TD]
[TD="align: right"]3.86[/TD]
[TD="align: right"]3.86[/TD]
[TD="align: right"]3.86[/TD]
[TD="align: right"]3.86[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]3.86[/TD]
[TD="align: right"]0.0193[/TD]
[TD="align: right"]1032.10174[/TD]
[TD="align: right"]1017.059379[/TD]
[TD="align: right"]0.105753425[/TD]
[TD="align: right"]1023.881571[/TD]
[/TR]
[TR]
[TD="align: right"]4/2/1962[/TD]
[TD="align: right"]3.86[/TD]
[TD="align: right"]3.86[/TD]
[TD="align: right"]3.86[/TD]
[TD="align: right"]3.86[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]3.86[/TD]
[TD="align: right"]0.0193[/TD]
[TD="align: right"]1032.10174[/TD]
[TD="align: right"]1017.059379[/TD]
[TD="align: right"]0.105753425[/TD]
[TD="align: right"]1023.987324[/TD]
[/TR]
[TR]
[TD="align: right"]4/3/1962[/TD]
[TD="align: right"]3.83[/TD]
[TD="align: right"]3.83[/TD]
[TD="align: right"]3.83[/TD]
[TD="align: right"]3.83[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]3.83[/TD]
[TD="align: right"]0.01915[/TD]
[TD="align: right"]1034.621349[/TD]
[TD="align: right"]1019.652881[/TD]
[TD="align: right"]0.104931507[/TD]
[TD="align: right"]1026.685757[/TD]
[/TR]
[TR]
[TD="align: right"]4/4/1962[/TD]
[TD="align: right"]3.78[/TD]
[TD="align: right"]3.78[/TD]
[TD="align: right"]3.78[/TD]
[TD="align: right"]3.78[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]3.78[/TD]
[TD="align: right"]0.0189[/TD]
[TD="align: right"]1038.836912[/TD]
[TD="align: right"]1023.986405[/TD]
[TD="align: right"]0.103561644[/TD]
[TD="align: right"]1031.122844[/TD]
[/TR]
[TR]
[TD="align: right"]4/5/1962[/TD]
[TD="align: right"]3.84[/TD]
[TD="align: right"]3.84[/TD]
[TD="align: right"]3.84[/TD]
[TD="align: right"]3.84[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]3.84[/TD]
[TD="align: right"]0.0192[/TD]
[TD="align: right"]1033.78067[/TD]
[TD="align: right"]1018.764075[/TD]
[TD="align: right"]0.105205479[/TD]
[TD="align: right"]1026.005719[/TD]
[/TR]
[TR]
[TD="align: right"]4/6/1962[/TD]
[TD="align: right"]3.81[/TD]
[TD="align: right"]3.81[/TD]
[TD="align: right"]3.81[/TD]
[TD="align: right"]3.81[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]3.81[/TD]
[TD="align: right"]0.01905[/TD]
[TD="align: right"]1036.305138[/TD]
[TD="align: right"]1021.361923[/TD]
[TD="align: right"]0.104383562[/TD]
[TD="align: right"]1028.70795[/TD]
[/TR]
[TR]
[TD="align: right"]4/9/1962[/TD]
[TD="align: right"]3.83[/TD]
[TD="align: right"]3.83[/TD]
[TD="align: right"]3.83[/TD]
[TD="align: right"]3.83[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]3.83[/TD]
[TD="align: right"]0.01915[/TD]
[TD="align: right"]1034.621349[/TD]
[TD="align: right"]1019.625608[/TD]
[TD="align: right"]0.104931507[/TD]
[TD="align: right"]1027.076567[/TD]
[/TR]
[TR]
[TD="align: right"]4/10/1962[/TD]
[TD="align: right"]3.83[/TD]
[TD="align: right"]3.83[/TD]
[TD="align: right"]3.83[/TD]
[TD="align: right"]3.83[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]3.83[/TD]
[TD="align: right"]0.01915[/TD]
[TD="align: right"]1034.621349[/TD]
[TD="align: right"]1019.625608[/TD]
[TD="align: right"]0.104931507[/TD]
[TD="align: right"]1027.181498[/TD]
[/TR]
[TR]
[TD="align: right"]4/11/1962[/TD]
[TD="align: right"]3.87[/TD]
[TD="align: right"]3.87[/TD]
[TD="align: right"]3.87[/TD]
[TD="align: right"]3.87[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]3.87[/TD]
[TD="align: right"]0.01935[/TD]
[TD="align: right"]1031.263486[/TD]
[TD="align: right"]1016.158881[/TD]
[TD="align: right"]0.106027397[/TD]
[TD="align: right"]1023.820799[/TD]
[/TR]
[TR]
[TD="align: right"]4/12/1962[/TD]
[TD="align: right"]3.86[/TD]
[TD="align: right"]3.86[/TD]
[TD="align: right"]3.86[/TD]
[TD="align: right"]3.86[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]3.86[/TD]
[TD="align: right"]0.0193[/TD]
[TD="align: right"]1032.10174[/TD]
[TD="align: right"]1017.022616[/TD]
[TD="align: right"]0.105753425[/TD]
[TD="align: right"]1024.790287[/TD]
[/TR]
[TR]
[TD="align: right"]4/13/1962[/TD]
[TD="align: right"]3.85[/TD]
[TD="align: right"]3.85[/TD]
[TD="align: right"]3.85[/TD]
[TD="align: right"]3.85[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]3.85[/TD]
[TD="align: right"]0.01925[/TD]
[TD="align: right"]1032.940801[/TD]
[TD="align: right"]1017.887085[/TD]
[TD="align: right"]0.105479452[/TD]
[TD="align: right"]1025.760236[/TD]
[/TR]
[TR]
[TD="align: right"]4/16/1962[/TD]
[TD="align: right"]3.83[/TD]
[TD="align: right"]3.83[/TD]
[TD="align: right"]3.83[/TD]
[TD="align: right"]3.83[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]3.83[/TD]
[TD="align: right"]0.01915[/TD]
[TD="align: right"]1034.621349[/TD]
[TD="align: right"]1019.617493[/TD]
[TD="align: right"]0.104931507[/TD]
[TD="align: right"]1027.595575[/TD]
[/TR]
[TR]
[TD="align: right"]4/17/1962[/TD]
[TD="align: right"]3.82[/TD]
[TD="align: right"]3.82[/TD]
[TD="align: right"]3.82[/TD]
[TD="align: right"]3.82[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]3.82[/TD]
[TD="align: right"]0.0191[/TD]
[TD="align: right"]1035.462838[/TD]
[TD="align: right"]1020.484168[/TD]
[TD="align: right"]0.104657534[/TD]
[TD="align: right"]1028.566908[/TD]
[/TR]
[TR]
[TD="align: right"]4/18/1962[/TD]
[TD="align: right"]3.81[/TD]
[TD="align: right"]3.81[/TD]
[TD="align: right"]3.81[/TD]
[TD="align: right"]3.81[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]3.81[/TD]
[TD="align: right"]0.01905[/TD]
[TD="align: right"]1036.305138[/TD]
[TD="align: right"]1021.351579[/TD]
[TD="align: right"]0.104383562[/TD]
[TD="align: right"]1029.538703[/TD]
[/TR]
[TR]
[TD="align: right"]4/19/1962[/TD]
[TD="align: right"]3.82[/TD]
[TD="align: right"]3.82[/TD]
[TD="align: right"]3.82[/TD]
[TD="align: right"]3.82[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]3.82[/TD]
[TD="align: right"]0.0191[/TD]
[TD="align: right"]1035.462838[/TD]
[TD="align: right"]1020.483431[/TD]
[TD="align: right"]0.104657534[/TD]
[TD="align: right"]1028.775211[/TD]
[/TR]
[TR]
[TD="align: right"]4/23/1962[/TD]
[TD="align: right"]3.86[/TD]
[TD="align: right"]3.86[/TD]
[TD="align: right"]3.86[/TD]
[TD="align: right"]3.86[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]3.86[/TD]
[TD="align: right"]0.0193[/TD]
[TD="align: right"]1032.10174[/TD]
[TD="align: right"]1017.013787[/TD]
[TD="align: right"]0.105753425[/TD]
[TD="align: right"]1025.411321[/TD]
[/TR]
[TR]
[TD="align: right"]4/24/1962[/TD]
[TD="align: right"]3.87[/TD]
[TD="align: right"]3.87[/TD]
[TD="align: right"]3.87[/TD]
[TD="align: right"]3.87[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]3.87[/TD]
[TD="align: right"]0.01935[/TD]
[TD="align: right"]1031.263486[/TD]
[TD="align: right"]1016.149325[/TD]
[TD="align: right"]0.106027397[/TD]
[TD="align: right"]1024.652887[/TD]
[/TR]
[TR]
[TD="align: right"]4/25/1962[/TD]
[TD="align: right"]3.88[/TD]
[TD="align: right"]3.88[/TD]
[TD="align: right"]3.88[/TD]
[TD="align: right"]3.88[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]3.88[/TD]
[TD="align: right"]0.0194[/TD]
[TD="align: right"]1030.426039[/TD]
[TD="align: right"]1015.285598[/TD]
[TD="align: right"]0.10630137[/TD]
[TD="align: right"]1023.895461[/TD]
[/TR]
[TR]
[TD="align: right"]4/26/1962[/TD]
[TD="align: right"]3.89[/TD]
[TD="align: right"]3.89[/TD]
[TD="align: right"]3.89[/TD]
[TD="align: right"]3.89[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]3.89[/TD]
[TD="align: right"]0.01945[/TD]
[TD="align: right"]1029.589398[/TD]
[TD="align: right"]1014.422606[/TD]
[TD="align: right"]0.106575342[/TD]
[TD="align: right"]1023.139044[/TD]
[/TR]
[TR]
[TD="align: right"]4/27/1962[/TD]
[TD="align: right"]3.86[/TD]
[TD="align: right"]3.86[/TD]
[TD="align: right"]3.86[/TD]
[TD="align: right"]3.86[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]3.86[/TD]
[TD="align: right"]0.0193[/TD]
[TD="align: right"]1032.10174[/TD]
[TD="align: right"]1017.009383[/TD]
[TD="align: right"]0.105753425[/TD]
[TD="align: right"]1025.831575[/TD]
[/TR]
[TR]
[TD="align: right"]4/30/1962[/TD]
[TD="align: right"]3.86[/TD]
[TD="align: right"]3.86[/TD]
[TD="align: right"]3.86[/TD]
[TD="align: right"]3.86[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]3.86[/TD]
[TD="align: right"]0.0193[/TD]
[TD="align: right"]1032.10174[/TD]
[TD="align: right"]1017.009383[/TD]
[TD="align: right"]0.105753425[/TD]
[TD="align: right"]1025.937328[/TD]
[/TR]
[TR]
[TD="align: right"]5/1/1962[/TD]
[TD="align: right"]3.85[/TD]
[TD="align: right"]3.85[/TD]
[TD="align: right"]3.85[/TD]
[TD="align: right"]3.85[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]3.85[/TD]
[TD="align: right"]0.01925[/TD]
[TD="align: right"]1032.940801[/TD]
[TD="align: right"]1017.873841[/TD]
[TD="align: right"]0.105479452[/TD]
[TD="align: right"]1026.907266[/TD]
[/TR]
[TR]
[TD="align: right"]5/2/1962[/TD]
[TD="align: right"]3.86[/TD]
[TD="align: right"]3.86[/TD]
[TD="align: right"]3.86[/TD]
[TD="align: right"]3.86[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]3.86[/TD]
[TD="align: right"]0.0193[/TD]
[TD="align: right"]1032.10174[/TD]
[TD="align: right"]1017.008648[/TD]
[TD="align: right"]0.105753425[/TD]
[TD="align: right"]1026.147826[/TD]
[/TR]
[TR]
[TD="align: right"]5/3/1962[/TD]
[TD="align: right"]3.86[/TD]
[TD="align: right"]3.86[/TD]
[TD="align: right"]3.86[/TD]
[TD="align: right"]3.86[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]3.86[/TD]
[TD="align: right"]0.0193[/TD]
[TD="align: right"]1032.10174[/TD]
[TD="align: right"]1017.008648[/TD]
[TD="align: right"]0.105753425[/TD]
[TD="align: right"]1026.25358[/TD]
[/TR]
[TR]
[TD="align: right"]5/4/1962[/TD]
[TD="align: right"]3.87[/TD]
[TD="align: right"]3.87[/TD]
[TD="align: right"]3.87[/TD]
[TD="align: right"]3.87[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]3.87[/TD]
[TD="align: right"]0.01935[/TD]
[TD="align: right"]1031.263486[/TD]
[TD="align: right"]1016.144191[/TD]
[TD="align: right"]0.106027397[/TD]
[TD="align: right"]1025.49515[/TD]
[/TR]
[TR]
[TD="align: right"]5/7/1962[/TD]
[TD="align: right"]3.86[/TD]
[TD="align: right"]3.86[/TD]
[TD="align: right"]3.86[/TD]
[TD="align: right"]3.86[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]3.86[/TD]
[TD="align: right"]0.0193[/TD]
[TD="align: right"]1032.10174[/TD]
[TD="align: right"]1017.007914[/TD]
[TD="align: right"]0.105753425[/TD]
[TD="align: right"]1026.464626[/TD]
[/TR]
[TR]
[TD="align: right"]5/8/1962[/TD]
[TD="align: right"]3.85[/TD]
[TD="align: right"]3.85[/TD]
[TD="align: right"]3.85[/TD]
[TD="align: right"]3.85[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]3.85[/TD]
[TD="align: right"]0.01925[/TD]
[TD="align: right"]1032.940801[/TD]
[TD="align: right"]1017.87237[/TD]
[TD="align: right"]0.105479452[/TD]
[TD="align: right"]1027.434562[/TD]
[/TR]
[TR]
[TD="align: right"]5/9/1962[/TD]
[TD="align: right"]3.82[/TD]
[TD="align: right"]3.82[/TD]
[TD="align: right"]3.82[/TD]
[TD="align: right"]3.82[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]3.82[/TD]
[TD="align: right"]0.0191[/TD]
[TD="align: right"]1035.462838[/TD]
[TD="align: right"]1020.467945[/TD]
[TD="align: right"]0.104657534[/TD]
[TD="align: right"]1030.134794[/TD]
[/TR]
[TR]
[TD="align: right"]5/10/1962[/TD]
[TD="align: right"]3.83[/TD]
[TD="align: right"]3.83[/TD]
[TD="align: right"]3.83[/TD]
[TD="align: right"]3.83[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]3.83[/TD]
[TD="align: right"]0.01915[/TD]
[TD="align: right"]1034.621349[/TD]
[TD="align: right"]1019.600547[/TD]
[TD="align: right"]0.104931507[/TD]
[TD="align: right"]1029.372328[/TD]
[/TR]
[TR]
[TD="align: right"]5/11/1962[/TD]
[TD="align: right"]3.82[/TD]
[TD="align: right"]3.82[/TD]
[TD="align: right"]3.82[/TD]
[TD="align: right"]3.82[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]3.82[/TD]
[TD="align: right"]0.0191[/TD]
[TD="align: right"]1035.462838[/TD]
[TD="align: right"]1020.467208[/TD]
[TD="align: right"]0.104657534[/TD]
[TD="align: right"]1030.343646[/TD]
[/TR]
[TR]
[TD="align: right"]5/14/1962[/TD]
[TD="align: right"]3.85[/TD]
[TD="align: right"]3.85[/TD]
[TD="align: right"]3.85[/TD]
[TD="align: right"]3.85[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]3.85[/TD]
[TD="align: right"]0.01925[/TD]
[TD="align: right"]1032.940801[/TD]
[TD="align: right"]1017.865016[/TD]
[TD="align: right"]0.105479452[/TD]
[TD="align: right"]1027.846934[/TD]
[/TR]
[TR]
[TD="align: right"]5/15/1962[/TD]
[TD="align: right"]3.87[/TD]
[TD="align: right"]3.87[/TD]
[TD="align: right"]3.87[/TD]
[TD="align: right"]3.87[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]3.87[/TD]
[TD="align: right"]0.01935[/TD]
[TD="align: right"]1031.263486[/TD]
[TD="align: right"]1016.134646[/TD]
[TD="align: right"]0.106027397[/TD]
[TD="align: right"]1026.222591[/TD]
[/TR]
[TR]
[TD="align: right"]5/16/1962[/TD]
[TD="align: right"]3.86[/TD]
[TD="align: right"]3.86[/TD]
[TD="align: right"]3.86[/TD]
[TD="align: right"]3.86[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]3.86[/TD]
[TD="align: right"]0.0193[/TD]
[TD="align: right"]1032.10174[/TD]
[TD="align: right"]1016.99836[/TD]
[TD="align: right"]0.105753425[/TD]
[TD="align: right"]1027.192059[/TD]
[/TR]
[TR]
[TD="align: right"]5/17/1962[/TD]
[TD="align: right"]3.87[/TD]
[TD="align: right"]3.87[/TD]
[TD="align: right"]3.87[/TD]
[TD="align: right"]3.87[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]3.87[/TD]
[TD="align: right"]0.01935[/TD]
[TD="align: right"]1031.263486[/TD]
[TD="align: right"]1016.133912[/TD]
[TD="align: right"]0.106027397[/TD]
[TD="align: right"]1026.433638[/TD]
[/TR]
[TR]
[TD="align: right"]5/18/1962[/TD]
[TD="align: right"]3.93[/TD]
[TD="align: right"]3.93[/TD]
[TD="align: right"]3.93[/TD]
[TD="align: right"]3.93[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]3.93[/TD]
[TD="align: right"]0.01965[/TD]
[TD="align: right"]1026.250875[/TD]
[TD="align: right"]1010.951629[/TD]
[TD="align: right"]0.107671233[/TD]
[TD="align: right"]1021.359026[/TD]
[/TR]
[TR]
[TD="align: right"]5/21/1962[/TD]
[TD="align: right"]3.94[/TD]
[TD="align: right"]3.94[/TD]
[TD="align: right"]3.94[/TD]
[TD="align: right"]3.94[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]3.94[/TD]
[TD="align: right"]0.0197[/TD]
[TD="align: right"]1025.41825[/TD]
[TD="align: right"]1010.09232[/TD]
[TD="align: right"]0.107945205[/TD]
[TD="align: right"]1020.607662[/TD]
[/TR]
[TR]
[TD="align: right"]5/22/1962[/TD]
[TD="align: right"]3.93[/TD]
[TD="align: right"]3.93[/TD]
[TD="align: right"]3.93[/TD]
[TD="align: right"]3.93[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]3.93[/TD]
[TD="align: right"]0.01965[/TD]
[TD="align: right"]1026.250875[/TD]
[TD="align: right"]1010.950898[/TD]
[TD="align: right"]0.107671233[/TD]
[TD="align: right"]1021.573912[/TD]
[/TR]
[TR]
[TD="align: right"]5/23/1962[/TD]
[TD="align: right"]3.91[/TD]
[TD="align: right"]3.91[/TD]
[TD="align: right"]3.91[/TD]
[TD="align: right"]3.91[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]3.91[/TD]
[TD="align: right"]0.01955[/TD]
[TD="align: right"]1027.918529[/TD]
[TD="align: right"]1012.669515[/TD]
[TD="align: right"]0.107123288[/TD]
[TD="align: right"]1023.399652[/TD]
[/TR]
</tbody>[/TABLE]

Lets call "Total Value" Column L and "Date" Column A. 1/2/1962 would then be cell A2 and 1000.111233 would be cell L2 and so on. Just by quick glance the first trough is at 1/17/1962 at 996.228 and the next peak is at 2/19/1962 1008.020. The following trough is a day later, and the following peak is 3/2/1961 at 1011.45. I want to somehow automate the dataset in say column M to find the peaks and troughs of the data set. That is probably the simple part of the solution. It gets more complicated that the other requirement is that I only want to find peaks and troughs of 5% or greater. Like for example the peak to drop trough of 1008.020 to 1004.716 is a drop of .33% so I don't even want to analyze that. If say the trough was 970 in relation to 1008, that would be something I would want to see. I guess I am saying I want to see significant price drops (troughs) and significant price increases (peaks not just small fluctuations. Then after finding these significant troughs and peaks, I want to see the amount of days between the toughs to the peaks. I feel like that will be a simple if statement followed by days 360. Thank you for your help, I really appreciate it.
 

Excel Facts

Easy bullets in Excel
If you have a numeric keypad, press Alt+7 on numeric keypad to type a bullet in Excel.
Sort by date Sort by votes
You must log in or register to reply here.

Similar threads

Deepakchoudhary
  • Question Question
Database & Bar Chart preparation for comparison of 3 parameters, 5 items on Dynamic selection of OUTLETS
Replies
0
Views
101
Deepakchoudhary
Deepakchoudhary
M
  • Solved
Match and Index problems
Replies
4
Views
442
maabadi
M
1
  • Question Question
Calculate on every third Friday of the month and show results between positive & negative weeks
2
Replies
14
Views
949
15minoffame
1
H
  • Question Question
Having trouble calendarizing a utility bill across multiple months. Is there a quicker method than what I've done so far?
Replies
1
Views
613
helnuma2k
H
AlexinJap
  • Solved
Find result in Data Table by multiple conditions
Replies
7
Views
832
AlexinJap
AlexinJap

Forum statistics

Threads
1,223,228
Messages
6,170,876
Members
452,363
Latest member
merico17

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