Trying to find percentage of winners and losers

[alexm3430]

Below is a sample of data that i want to see on a percentage basis how many times a certain hour is positive or negative over last 30 days or however many days i plug in. I want to see each hour independently.

Thank you.


[TABLE="width: 1843"]
<colgroup><col><col><col><col><col span="24"></colgroup><tbody>[TR]
[TD]Day[/TD]
[TD]Year[/TD]
[TD]Month[/TD]
[TD]Dat 2[/TD]
[TD]1[/TD]
[TD]2[/TD]
[TD]3[/TD]
[TD]4[/TD]
[TD]5[/TD]
[TD]6[/TD]
[TD]7[/TD]
[TD]8[/TD]
[TD]9[/TD]
[TD]10[/TD]
[TD]11[/TD]
[TD]12[/TD]
[TD]13[/TD]
[TD]14[/TD]
[TD]15[/TD]
[TD]16[/TD]
[TD]17[/TD]
[TD]18[/TD]
[TD]19[/TD]
[TD]20[/TD]
[TD]21[/TD]
[TD]22[/TD]
[TD]23[/TD]
[TD]24[/TD]
[/TR]
[TR]
[TD]Sat[/TD]
[TD="align: right"]2011[/TD]
[TD]Jan[/TD]
[TD="align: right"]1/1/2011[/TD]
[TD="align: right"]1.60[/TD]
[TD="align: right"]1.90[/TD]
[TD="align: right"]2.67[/TD]
[TD="align: right"]3.00[/TD]
[TD="align: right"]3.00[/TD]
[TD="align: right"]5.64[/TD]
[TD="align: right"]8.78[/TD]
[TD="align: right"]10.22[/TD]
[TD="align: right"]9.32[/TD]
[TD="align: right"]6.91[/TD]
[TD="align: right"]4.83[/TD]
[TD="align: right"]3.43[/TD]
[TD="align: right"]1.99[/TD]
[TD="align: right"]2.90[/TD]
[TD="align: right"]2.12[/TD]
[TD="align: right"]1.83[/TD]
[TD="align: right"]2.85[/TD]
[TD="align: right"]7.48[/TD]
[TD="align: right"]10.44[/TD]
[TD="align: right"]4.91[/TD]
[TD="align: right"](6.63)[/TD]
[TD="align: right"]0.15[/TD]
[TD="align: right"]1.23[/TD]
[TD="align: right"]0.62[/TD]
[/TR]
[TR]
[TD]Sun[/TD]
[TD="align: right"]2011[/TD]
[TD]Jan[/TD]
[TD="align: right"]1/2/2011[/TD]
[TD="align: right"](1.90)[/TD]
[TD="align: right"](1.53)[/TD]
[TD="align: right"](1.19)[/TD]
[TD="align: right"](1.38)[/TD]
[TD="align: right"](1.20)[/TD]
[TD="align: right"]5.55[/TD]
[TD="align: right"]4.51[/TD]
[TD="align: right"]4.24[/TD]
[TD="align: right"](12.07)[/TD]
[TD="align: right"](1.72)[/TD]
[TD="align: right"]1.00[/TD]
[TD="align: right"]1.27[/TD]
[TD="align: right"]0.39[/TD]
[TD="align: right"]0.73[/TD]
[TD="align: right"]0.84[/TD]
[TD="align: right"]1.13[/TD]
[TD="align: right"]1.96[/TD]
[TD="align: right"]3.87[/TD]
[TD="align: right"]9.74[/TD]
[TD="align: right"]8.76[/TD]
[TD="align: right"]7.62[/TD]
[TD="align: right"]8.96[/TD]
[TD="align: right"]7.39[/TD]
[TD="align: right"]8.58[/TD]
[/TR]
[TR]
[TD]Mon[/TD]
[TD="align: right"]2011[/TD]
[TD]Jan[/TD]
[TD="align: right"]1/3/2011[/TD]
[TD="align: right"]4.15[/TD]
[TD="align: right"]2.81[/TD]
[TD="align: right"]3.33[/TD]
[TD="align: right"]3.81[/TD]
[TD="align: right"]5.78[/TD]
[TD="align: right"]9.93[/TD]
[TD="align: right"]18.10[/TD]
[TD="align: right"]24.14[/TD]
[TD="align: right"]13.24[/TD]
[TD="align: right"]8.50[/TD]
[TD="align: right"]5.80[/TD]
[TD="align: right"]7.27[/TD]
[TD="align: right"]6.46[/TD]
[TD="align: right"]5.16[/TD]
[TD="align: right"]4.22[/TD]
[TD="align: right"]4.17[/TD]
[TD="align: right"]2.84[/TD]
[TD="align: right"]5.26[/TD]
[TD="align: right"]19.44[/TD]
[TD="align: right"]15.63[/TD]
[TD="align: right"]11.75[/TD]
[TD="align: right"]12.82[/TD]
[TD="align: right"]12.37[/TD]
[TD="align: right"]11.54[/TD]
[/TR]
[TR]
[TD]Tue[/TD]
[TD="align: right"]2011[/TD]
[TD]Jan[/TD]
[TD="align: right"]1/4/2011[/TD]
[TD="align: right"]2.16[/TD]
[TD="align: right"]4.08[/TD]
[TD="align: right"]4.53[/TD]
[TD="align: right"]0.09[/TD]
[TD="align: right"](0.57)[/TD]
[TD="align: right"](2.26)[/TD]
[TD="align: right"]0.44[/TD]
[TD="align: right"](0.18)[/TD]
[TD="align: right"]4.26[/TD]
[TD="align: right"](5.94)[/TD]
[TD="align: right"](7.60)[/TD]
[TD="align: right"](5.39)[/TD]
[TD="align: right"](2.48)[/TD]
[TD="align: right"](3.27)[/TD]
[TD="align: right"](2.79)[/TD]
[TD="align: right"](2.08)[/TD]
[TD="align: right"](2.92)[/TD]
[TD="align: right"]5.44[/TD]
[TD="align: right"]10.70[/TD]
[TD="align: right"]4.36[/TD]
[TD="align: right"]2.28[/TD]
[TD="align: right"]3.41[/TD]
[TD="align: right"]5.17[/TD]
[TD="align: right"]6.64[/TD]
[/TR]
[TR]
[TD]Wed[/TD]
[TD="align: right"]2011[/TD]
[TD]Jan[/TD]
[TD="align: right"]1/5/2011[/TD]
[TD="align: right"]0.97[/TD]
[TD="align: right"]0.95[/TD]
[TD="align: right"]1.87[/TD]
[TD="align: right"]1.39[/TD]
[TD="align: right"]0.05[/TD]
[TD="align: right"]4.46[/TD]
[TD="align: right"](414.05)[/TD]
[TD="align: right"](210.23)[/TD]
[TD="align: right"]7.51[/TD]
[TD="align: right"](0.16)[/TD]
[TD="align: right"](16.08)[/TD]
[TD="align: right"](8.86)[/TD]
[TD="align: right"](2.29)[/TD]
[TD="align: right"](0.30)[/TD]
[TD="align: right"](1.17)[/TD]
[TD="align: right"](2.65)[/TD]
[TD="align: right"](3.09)[/TD]
[TD="align: right"]1.55[/TD]
[TD="align: right"](339.75)[/TD]
[TD="align: right"](1.57)[/TD]
[TD="align: right"](8.13)[/TD]
[TD="align: right"](5.90)[/TD]
[TD="align: right"](11.95)[/TD]
[TD="align: right"](10.25)[/TD]
[/TR]
[TR]
[TD]Thur[/TD]
[TD="align: right"]2011[/TD]
[TD]Jan[/TD]
[TD="align: right"]1/6/2011[/TD]
[TD="align: right"](7.26)[/TD]
[TD="align: right"](5.97)[/TD]
[TD="align: right"](4.46)[/TD]
[TD="align: right"](7.73)[/TD]
[TD="align: right"](609.35)[/TD]
[TD="align: right"]0.16[/TD]
[TD="align: right"](1.80)[/TD]
[TD="align: right"]1.54[/TD]
[TD="align: right"]3.83[/TD]
[TD="align: right"](0.48)[/TD]
[TD="align: right"](1.78)[/TD]
[TD="align: right"](0.62)[/TD]
[TD="align: right"]1.06[/TD]
[TD="align: right"]0.13[/TD]
[TD="align: right"]1.74[/TD]
[TD="align: right"]2.17[/TD]
[TD="align: right"]2.13[/TD]
[TD="align: right"]5.37[/TD]
[TD="align: right"]11.11[/TD]
[TD="align: right"]4.15[/TD]
[TD="align: right"]0.36[/TD]
[TD="align: right"](1.02)[/TD]
[TD="align: right"](3.83)[/TD]
[TD="align: right"]2.99[/TD]
[/TR]
[TR]
[TD]Fri[/TD]
[TD="align: right"]2011[/TD]
[TD]Jan[/TD]
[TD="align: right"]1/7/2011[/TD]
[TD="align: right"]2.34[/TD]
[TD="align: right"]1.42[/TD]
[TD="align: right"]0.56[/TD]
[TD="align: right"]1.44[/TD]
[TD="align: right"]7.37[/TD]
[TD="align: right"]8.82[/TD]
[TD="align: right"](1046.96)[/TD]
[TD="align: right"]13.85[/TD]
[TD="align: right"]9.50[/TD]
[TD="align: right"]5.42[/TD]
[TD="align: right"]1.92[/TD]
[TD="align: right"]1.94[/TD]
[TD="align: right"]1.46[/TD]
[TD="align: right"]0.41[/TD]
[TD="align: right"]1.18[/TD]
[TD="align: right"]1.71[/TD]
[TD="align: right"]4.05[/TD]
[TD="align: right"]10.01[/TD]
[TD="align: right"]22.46[/TD]
[TD="align: right"]17.60[/TD]
[TD="align: right"]10.08[/TD]
[TD="align: right"]9.07[/TD]
[TD="align: right"]8.83[/TD]
[TD="align: right"]7.50[/TD]
[/TR]
[TR]
[TD]Sat[/TD]
[TD="align: right"]2011[/TD]
[TD]Jan[/TD]
[TD="align: right"]1/8/2011[/TD]
[TD="align: right"]5.00[/TD]
[TD="align: right"]3.11[/TD]
[TD="align: right"]2.55[/TD]
[TD="align: right"]1.36[/TD]
[TD="align: right"]4.33[/TD]
[TD="align: right"]4.61[/TD]
[TD="align: right"]8.08[/TD]
[TD="align: right"]10.11[/TD]
[TD="align: right"]4.87[/TD]
[TD="align: right"]4.64[/TD]
[TD="align: right"]4.01[/TD]
[TD="align: right"]2.51[/TD]
[TD="align: right"]2.72[/TD]
[TD="align: right"]4.64[/TD]
[TD="align: right"]4.99[/TD]
[TD="align: right"]6.05[/TD]
[TD="align: right"]5.68[/TD]
[TD="align: right"]11.64[/TD]
[TD="align: right"]22.99[/TD]
[TD="align: right"]13.81[/TD]
[TD="align: right"]10.92[/TD]
[TD="align: right"]9.03[/TD]
[TD="align: right"]10.73[/TD]
[TD="align: right"]12.53[/TD]
[/TR]
[TR]
[TD]Sun[/TD]
[TD="align: right"]2011[/TD]
[TD]Jan[/TD]
[TD="align: right"]1/9/2011[/TD]
[TD="align: right"]10.13[/TD]
[TD="align: right"]6.55[/TD]
[TD="align: right"]8.05[/TD]
[TD="align: right"]8.35[/TD]
[TD="align: right"]6.51[/TD]
[TD="align: right"]5.89[/TD]
[TD="align: right"]12.19[/TD]
[TD="align: right"]15.41[/TD]
[TD="align: right"]11.74[/TD]
[TD="align: right"]11.54[/TD]
[TD="align: right"]9.78[/TD]
[TD="align: right"]3.86[/TD]
[TD="align: right"](0.12)[/TD]
[TD="align: right"](1.78)[/TD]
[TD="align: right"](0.62)[/TD]
[TD="align: right"]0.25[/TD]
[TD="align: right"]2.81[/TD]
[TD="align: right"]12.60[/TD]
[TD="align: right"]25.05[/TD]
[TD="align: right"]17.95[/TD]
[TD="align: right"]15.92[/TD]
[TD="align: right"]13.72[/TD]
[TD="align: right"]13.38[/TD]
[TD="align: right"]12.88[/TD]
[/TR]
[TR]
[TD]Mon[/TD]
[TD="align: right"]2011[/TD]
[TD]Jan[/TD]
[TD="align: right"]1/10/2011[/TD]
[TD="align: right"]4.45[/TD]
[TD="align: right"]4.16[/TD]
[TD="align: right"]4.15[/TD]
[TD="align: right"]4.02[/TD]
[TD="align: right"]9.55[/TD]
[TD="align: right"]11.96[/TD]
[TD="align: right"]21.99[/TD]
[TD="align: right"]21.79[/TD]
[TD="align: right"]9.54[/TD]
[TD="align: right"]6.89[/TD]
[TD="align: right"]2.70[/TD]
[TD="align: right"]0.26[/TD]
[TD="align: right"](2.82)[/TD]
[TD="align: right"](4.23)[/TD]
[TD="align: right"](4.84)[/TD]
[TD="align: right"](4.10)[/TD]
[TD="align: right"](0.75)[/TD]
[TD="align: right"]8.98[/TD]
[TD="align: right"]29.66[/TD]
[TD="align: right"]15.31[/TD]
[TD="align: right"]13.72[/TD]
[TD="align: right"]11.19[/TD]
[TD="align: right"]9.63[/TD]
[TD="align: right"]13.15[/TD]
[/TR]
[TR]
[TD]Tue[/TD]
[TD="align: right"]2011[/TD]
[TD]Jan[/TD]
[TD="align: right"]1/11/2011[/TD]
[TD="align: right"]1.83[/TD]
[TD="align: right"]2.26[/TD]
[TD="align: right"]1.42[/TD]
[TD="align: right"](1.34)[/TD]
[TD="align: right"](0.93)[/TD]
[TD="align: right"](0.52)[/TD]
[TD="align: right"]6.22[/TD]
[TD="align: right"](17.33)[/TD]
[TD="align: right"]2.24[/TD]
[TD="align: right"](3.46)[/TD]
[TD="align: right"](5.73)[/TD]
[TD="align: right"](7.75)[/TD]
[TD="align: right"](5.34)[/TD]
[TD="align: right"](3.98)[/TD]
[TD="align: right"](2.32)[/TD]
[TD="align: right"](1.34)[/TD]
[TD="align: right"](1.72)[/TD]
[TD="align: right"]5.85[/TD]
[TD="align: right"]16.25[/TD]
[TD="align: right"]4.95[/TD]
[TD="align: right"]2.43[/TD]
[TD="align: right"]5.00[/TD]
[TD="align: right"]2.82[/TD]
[TD="align: right"]3.61[/TD]
[/TR]
[TR]
[TD]Wed[/TD]
[TD="align: right"]2011[/TD]
[TD]Jan[/TD]
[TD="align: right"]1/12/2011[/TD]
[TD="align: right"](2.97)[/TD]
[TD="align: right"](1.61)[/TD]
[TD="align: right"](1.58)[/TD]
[TD="align: right"](1.42)[/TD]
[TD="align: right"]2.24[/TD]
[TD="align: right"]7.90[/TD]
[TD="align: right"]33.80[/TD]
[TD="align: right"]24.63[/TD]
[TD="align: right"]13.57[/TD]
[TD="align: right"]8.38[/TD]
[TD="align: right"]4.80[/TD]
[TD="align: right"]3.91[/TD]
[TD="align: right"]2.52[/TD]
[TD="align: right"]1.38[/TD]
[TD="align: right"]0.26[/TD]
[TD="align: right"]0.30[/TD]
[TD="align: right"](1.37)[/TD]
[TD="align: right"]1.77[/TD]
[TD="align: right"]16.19[/TD]
[TD="align: right"]9.01[/TD]
[TD="align: right"]5.77[/TD]
[TD="align: right"]4.55[/TD]
[TD="align: right"]1.52[/TD]
[TD="align: right"]5.58[/TD]
[/TR]
[TR]
[TD]Thur[/TD]
[TD="align: right"]2011[/TD]
[TD]Jan[/TD]
[TD="align: right"]1/13/2011[/TD]
[TD="align: right"]2.56[/TD]
[TD="align: right"]1.91[/TD]
[TD="align: right"]1.87[/TD]
[TD="align: right"]3.51[/TD]
[TD="align: right"]5.87[/TD]
[TD="align: right"]9.50[/TD]
[TD="align: right"]35.50[/TD]
[TD="align: right"]34.06[/TD]
[TD="align: right"]14.22[/TD]
[TD="align: right"]7.71[/TD]
[TD="align: right"]5.02[/TD]
[TD="align: right"]4.34[/TD]
[TD="align: right"]0.84[/TD]
[TD="align: right"](1.07)[/TD]
[TD="align: right"](0.30)[/TD]
[TD="align: right"](1.61)[/TD]
[TD="align: right"](2.53)[/TD]
[TD="align: right"]0.62[/TD]
[TD="align: right"]9.40[/TD]
[TD="align: right"]7.93[/TD]
[TD="align: right"]6.41[/TD]
[TD="align: right"]5.01[/TD]
[TD="align: right"]2.23[/TD]
[TD="align: right"]3.51[/TD]
[/TR]
[TR]
[TD]Fri[/TD]
[TD="align: right"]2011[/TD]
[TD]Jan[/TD]
[TD="align: right"]1/14/2011[/TD]
[TD="align: right"]0.84[/TD]
[TD="align: right"]0.72[/TD]
[TD="align: right"]0.97[/TD]
[TD="align: right"]1.04[/TD]
[TD="align: right"]3.36[/TD]
[TD="align: right"]8.30[/TD]
[TD="align: right"]28.03[/TD]
[TD="align: right"]26.69[/TD]
[TD="align: right"]12.69[/TD]
[TD="align: right"]5.99[/TD]
[TD="align: right"](0.32)[/TD]
[TD="align: right"](1.72)[/TD]
[TD="align: right"](2.62)[/TD]
[TD="align: right"](1.08)[/TD]
[TD="align: right"]0.13[/TD]
[TD="align: right"](1.53)[/TD]
[TD="align: right"](1.22)[/TD]
[TD="align: right"]4.53[/TD]
[TD="align: right"]14.29[/TD]
[TD="align: right"]8.45[/TD]
[TD="align: right"]4.03[/TD]
[TD="align: right"]4.54[/TD]
[TD="align: right"](1.18)[/TD]
[TD="align: right"]1.59[/TD]
[/TR]
[TR]
[TD]Sat[/TD]
[TD="align: right"]2011[/TD]
[TD]Jan[/TD]
[TD="align: right"]1/15/2011[/TD]
[TD="align: right"]0.30[/TD]
[TD="align: right"](1.19)[/TD]
[TD="align: right"](0.54)[/TD]
[TD="align: right"](0.61)[/TD]
[TD="align: right"](1.33)[/TD]
[TD="align: right"]0.25[/TD]
[TD="align: right"]10.98[/TD]
[TD="align: right"]7.11[/TD]
[TD="align: right"]4.00[/TD]
[TD="align: right"](12.05)[/TD]
[TD="align: right"](9.26)[/TD]
[TD="align: right"](6.21)[/TD]
[TD="align: right"](4.00)[/TD]
[TD="align: right"](4.58)[/TD]
[TD="align: right"](2.35)[/TD]
[TD="align: right"](1.16)[/TD]
[TD="align: right"]0.18[/TD]
[TD="align: right"]1.28[/TD]
[TD="align: right"]14.32[/TD]
[TD="align: right"]5.14[/TD]
[TD="align: right"]1.06[/TD]
[TD="align: right"]0.71[/TD]
[TD="align: right"](22.49)[/TD]
[TD="align: right"](4.05)[/TD]
[/TR]
[TR]
[TD]Sun[/TD]
[TD="align: right"]2011[/TD]
[TD]Jan[/TD]
[TD="align: right"]1/16/2011[/TD]
[TD="align: right"](4.05)[/TD]
[TD="align: right"](5.56)[/TD]
[TD="align: right"](3.61)[/TD]
[TD="align: right"](4.23)[/TD]
[TD="align: right"](3.91)[/TD]
[TD="align: right"](1.10)[/TD]
[TD="align: right"]8.25[/TD]
[TD="align: right"]8.33[/TD]
[TD="align: right"]11.46[/TD]
[TD="align: right"]6.36[/TD]
[TD="align: right"](3.62)[/TD]
[TD="align: right"](13.15)[/TD]
[TD="align: right"](28.00)[/TD]
[TD="align: right"](15.69)[/TD]
[TD="align: right"](13.21)[/TD]
[TD="align: right"](11.15)[/TD]
[TD="align: right"](6.53)[/TD]
[TD="align: right"](1.24)[/TD]
[TD="align: right"]14.38[/TD]
[TD="align: right"]12.76[/TD]
[TD="align: right"]6.27[/TD]
[TD="align: right"]2.38[/TD]
[TD="align: right"]0.20[/TD]
[TD="align: right"](4.40)[/TD]
[/TR]
[TR]
[TD]Mon[/TD]
[TD="align: right"]2011[/TD]
[TD]Jan[/TD]
[TD="align: right"]1/17/2011[/TD]
[TD="align: right"](4.49)[/TD]
[TD="align: right"](0.23)[/TD]
[TD="align: right"]2.58[/TD]
[TD="align: right"]2.08[/TD]
[TD="align: right"]2.40[/TD]
[TD="align: right"]8.07[/TD]
[TD="align: right"]19.28[/TD]
[TD="align: right"]20.28[/TD]
[TD="align: right"]15.69[/TD]
[TD="align: right"]3.09[/TD]
[TD="align: right"](5.30)[/TD]
[TD="align: right"](6.84)[/TD]
[TD="align: right"](2.25)[/TD]
[TD="align: right"]1.73[/TD]
[TD="align: right"]4.09[/TD]
[TD="align: right"]4.29[/TD]
[TD="align: right"]5.28[/TD]
[TD="align: right"]7.00[/TD]
[TD="align: right"]19.69[/TD]
[TD="align: right"]7.25[/TD]
[TD="align: right"]5.54[/TD]
[TD="align: right"]6.26[/TD]
[TD="align: right"]5.74[/TD]
[TD="align: right"]7.56[/TD]
[/TR]
[TR]
[TD]Tue[/TD]
[TD="align: right"]2011[/TD]
[TD]Jan[/TD]
[TD="align: right"]1/18/2011[/TD]
[TD="align: right"]5.39[/TD]
[TD="align: right"]6.25[/TD]
[TD="align: right"]4.78[/TD]
[TD="align: right"]2.84[/TD]
[TD="align: right"]4.90[/TD]
[TD="align: right"]10.33[/TD]
[TD="align: right"]21.23[/TD]
[TD="align: right"]22.34[/TD]
[TD="align: right"]11.93[/TD]
[TD="align: right"]3.96[/TD]
[TD="align: right"]3.91[/TD]
[TD="align: right"]2.50[/TD]
[TD="align: right"]2.56[/TD]
[TD="align: right"]2.96[/TD]
[TD="align: right"]3.04[/TD]
[TD="align: right"]3.67[/TD]
[TD="align: right"]3.25[/TD]
[TD="align: right"]6.04[/TD]
[TD="align: right"]17.88[/TD]
[TD="align: right"]6.85[/TD]
[TD="align: right"]4.66[/TD]
[TD="align: right"]3.86[/TD]
[TD="align: right"]6.24[/TD]
[TD="align: right"]7.29[/TD]
[/TR]
[TR]
[TD]Wed[/TD]
[TD="align: right"]2011[/TD]
[TD]Jan[/TD]
[TD="align: right"]1/19/2011[/TD]
[TD="align: right"]5.18[/TD]
[TD="align: right"]3.62[/TD]
[TD="align: right"]2.71[/TD]
[TD="align: right"]2.92[/TD]
[TD="align: right"]4.28[/TD]
[TD="align: right"]5.83[/TD]
[TD="align: right"]18.33[/TD]
[TD="align: right"]18.69[/TD]
[TD="align: right"]10.93[/TD]
[TD="align: right"]8.05[/TD]
[TD="align: right"]8.49[/TD]
[TD="align: right"]8.13[/TD]
[TD="align: right"]8.29[/TD]
[TD="align: right"]6.72[/TD]
[TD="align: right"]6.96[/TD]
[TD="align: right"]5.71[/TD]
[TD="align: right"]5.29[/TD]
[TD="align: right"]9.25[/TD]
[TD="align: right"]24.67[/TD]
[TD="align: right"]6.96[/TD]
[TD="align: right"]6.02[/TD]
[TD="align: right"]6.53[/TD]
[TD="align: right"]8.53[/TD]
[TD="align: right"]8.12[/TD]
[/TR]
[TR]
[TD]Thur[/TD]
[TD="align: right"]2011[/TD]
[TD]Jan[/TD]
[TD="align: right"]1/20/2011[/TD]
[TD="align: right"]2.84[/TD]
[TD="align: right"]3.80[/TD]
[TD="align: right"]3.36[/TD]
[TD="align: right"]3.31[/TD]
[TD="align: right"]4.94[/TD]
[TD="align: right"]5.72[/TD]
[TD="align: right"]11.22[/TD]
[TD="align: right"]7.91[/TD]
[TD="align: right"]3.73[/TD]
[TD="align: right"]1.29[/TD]
[TD="align: right"](111.08)[/TD]
[TD="align: right"]2.39[/TD]
[TD="align: right"]2.14[/TD]
[TD="align: right"]3.01[/TD]
[TD="align: right"]1.60[/TD]
[TD="align: right"]4.01[/TD]
[TD="align: right"]2.51[/TD]
[TD="align: right"]6.23[/TD]
[TD="align: right"](1.98)[/TD]
[TD="align: right"](5.45)[/TD]
[TD="align: right"](49.96)[/TD]
[TD="align: right"](5.49)[/TD]
[TD="align: right"](1.50)[/TD]
[TD="align: right"]0.70[/TD]
[/TR]
[TR]
[TD]Fri[/TD]
[TD="align: right"]2011[/TD]
[TD]Jan[/TD]
[TD="align: right"]1/21/2011[/TD]
[TD="align: right"](4.88)[/TD]
[TD="align: right"](1.55)[/TD]
[TD="align: right"]0.48[/TD]
[TD="align: right"]3.21[/TD]
[TD="align: right"]7.35[/TD]
[TD="align: right"]11.45[/TD]
[TD="align: right"]28.09[/TD]
[TD="align: right"]29.19[/TD]
[TD="align: right"]18.89[/TD]
[TD="align: right"]12.00[/TD]
[TD="align: right"]5.99[/TD]
[TD="align: right"]4.38[/TD]
[TD="align: right"]2.52[/TD]
[TD="align: right"]3.12[/TD]
[TD="align: right"]6.09[/TD]
[TD="align: right"]8.19[/TD]
[TD="align: right"]8.79[/TD]
[TD="align: right"]14.71[/TD]
[TD="align: right"]27.52[/TD]
[TD="align: right"]16.38[/TD]
[TD="align: right"]10.10[/TD]
[TD="align: right"]7.29[/TD]
[TD="align: right"](4.92)[/TD]
[TD="align: right"](5.35)[/TD]
[/TR]
[TR]
[TD]Sat[/TD]
[TD="align: right"]2011[/TD]
[TD]Jan[/TD]
[TD="align: right"]1/22/2011[/TD]
[TD="align: right"](50.93)[/TD]
[TD="align: right"](15.68)[/TD]
[TD="align: right"](8.49)[/TD]
[TD="align: right"](16.08)[/TD]
[TD="align: right"](3.81)[/TD]
[TD="align: right"](0.74)[/TD]
[TD="align: right"](7.42)[/TD]
[TD="align: right"]2.13[/TD]
[TD="align: right"]11.79[/TD]
[TD="align: right"]7.83[/TD]
[TD="align: right"]5.82[/TD]
[TD="align: right"]6.61[/TD]
[TD="align: right"]6.69[/TD]
[TD="align: right"]7.49[/TD]
[TD="align: right"]8.23[/TD]
[TD="align: right"]10.28[/TD]
[TD="align: right"]10.69[/TD]
[TD="align: right"]11.84[/TD]
[TD="align: right"]22.57[/TD]
[TD="align: right"]13.87[/TD]
[TD="align: right"]11.28[/TD]
[TD="align: right"]11.40[/TD]
[TD="align: right"]9.97[/TD]
[TD="align: right"]11.44[/TD]
[/TR]
[TR]
[TD]Sun[/TD]
[TD="align: right"]2011[/TD]
[TD]Jan[/TD]
[TD="align: right"]1/23/2011[/TD]
[TD="align: right"]4.28[/TD]
[TD="align: right"]0.51[/TD]
[TD="align: right"](0.20)[/TD]
[TD="align: right"]3.89[/TD]
[TD="align: right"]4.78[/TD]
[TD="align: right"]7.77[/TD]
[TD="align: right"]16.11[/TD]
[TD="align: right"]21.23[/TD]
[TD="align: right"]23.54[/TD]
[TD="align: right"]22.40[/TD]
[TD="align: right"]13.56[/TD]
[TD="align: right"]8.93[/TD]
[TD="align: right"]6.59[/TD]
[TD="align: right"]2.00[/TD]
[TD="align: right"](1.78)[/TD]
[TD="align: right"](4.34)[/TD]
[TD="align: right"](2.71)[/TD]
[TD="align: right"](1.96)[/TD]
[TD="align: right"](10.66)[/TD]
[TD="align: right"]0.50[/TD]
[TD="align: right"]0.97[/TD]
[TD="align: right"]0.85[/TD]
[TD="align: right"](0.18)[/TD]
[TD="align: right"]4.48[/TD]
[/TR]
[TR]
[TD]Mon[/TD]
[TD="align: right"]2011[/TD]
[TD]Jan[/TD]
[TD="align: right"]1/24/2011[/TD]
[TD="align: right"]1.99[/TD]
[TD="align: right"]2.43[/TD]
[TD="align: right"]3.37[/TD]
[TD="align: right"]3.25[/TD]
[TD="align: right"]3.36[/TD]
[TD="align: right"]2.10[/TD]
[TD="align: right"]12.41[/TD]
[TD="align: right"]18.10[/TD]
[TD="align: right"]12.42[/TD]
[TD="align: right"]6.14[/TD]
[TD="align: right"]2.15[/TD]
[TD="align: right"]1.01[/TD]
[TD="align: right"]1.82[/TD]
[TD="align: right"]2.26[/TD]
[TD="align: right"]2.36[/TD]
[TD="align: right"]2.08[/TD]
[TD="align: right"]1.34[/TD]
[TD="align: right"]5.26[/TD]
[TD="align: right"]20.04[/TD]
[TD="align: right"]14.42[/TD]
[TD="align: right"]10.83[/TD]
[TD="align: right"]6.28[/TD]
[TD="align: right"]4.41[/TD]
[TD="align: right"]10.65[/TD]
[/TR]
[TR]
[TD]Tue[/TD]
[TD="align: right"]2011[/TD]
[TD]Jan[/TD]
[TD="align: right"]1/25/2011[/TD]
[TD="align: right"]5.68[/TD]
[TD="align: right"]4.03[/TD]
[TD="align: right"]4.40[/TD]
[TD="align: right"]4.00[/TD]
[TD="align: right"]3.42[/TD]
[TD="align: right"]3.19[/TD]
[TD="align: right"](44.21)[/TD]
[TD="align: right"](93.72)[/TD]
[TD="align: right"]5.83[/TD]
[TD="align: right"]3.07[/TD]
[TD="align: right"](0.86)[/TD]
[TD="align: right"](1.02)[/TD]
[TD="align: right"]1.46[/TD]
[TD="align: right"]2.13[/TD]
[TD="align: right"]3.12[/TD]
[TD="align: right"]6.04[/TD]
[TD="align: right"]7.06[/TD]
[TD="align: right"]8.32[/TD]
[TD="align: right"]20.83[/TD]
[TD="align: right"]10.36[/TD]
[TD="align: right"]7.47[/TD]
[TD="align: right"](0.02)[/TD]
[TD="align: right"]0.72[/TD]
[TD="align: right"]4.85[/TD]
[/TR]
[TR]
[TD]Wed[/TD]
[TD="align: right"]2011[/TD]
[TD]Jan[/TD]
[TD="align: right"]1/26/2011[/TD]
[TD="align: right"](0.93)[/TD]
[TD="align: right"](2.25)[/TD]
[TD="align: right"](1.44)[/TD]
[TD="align: right"]0.15[/TD]
[TD="align: right"]0.79[/TD]
[TD="align: right"]5.72[/TD]
[TD="align: right"]24.33[/TD]
[TD="align: right"]27.40[/TD]
[TD="align: right"]7.50[/TD]
[TD="align: right"]4.22[/TD]
[TD="align: right"]4.46[/TD]
[TD="align: right"]2.48[/TD]
[TD="align: right"]2.67[/TD]
[TD="align: right"]1.55[/TD]
[TD="align: right"]2.11[/TD]
[TD="align: right"]2.79[/TD]
[TD="align: right"]2.98[/TD]
[TD="align: right"]6.57[/TD]
[TD="align: right"]16.79[/TD]
[TD="align: right"]6.30[/TD]
[TD="align: right"]5.70[/TD]
[TD="align: right"]2.94[/TD]
[TD="align: right"](3.30)[/TD]
[TD="align: right"]3.41[/TD]
[/TR]
[TR]
[TD]Thur[/TD]
[TD="align: right"]2011[/TD]
[TD]Jan[/TD]
[TD="align: right"]1/27/2011[/TD]
[TD="align: right"](1.13)[/TD]
[TD="align: right"](1.66)[/TD]
[TD="align: right"](2.23)[/TD]
[TD="align: right"](2.12)[/TD]
[TD="align: right"](0.67)[/TD]
[TD="align: right"](8.53)[/TD]
[TD="align: right"](776.99)[/TD]
[TD="align: right"](4.96)[/TD]
[TD="align: right"]6.85[/TD]
[TD="align: right"]2.49[/TD]
[TD="align: right"]3.02[/TD]
[TD="align: right"]2.87[/TD]
[TD="align: right"]2.34[/TD]
[TD="align: right"]3.33[/TD]
[TD="align: right"]4.21[/TD]
[TD="align: right"]4.08[/TD]
[TD="align: right"]3.93[/TD]
[TD="align: right"]6.54[/TD]
[TD="align: right"]16.25[/TD]
[TD="align: right"]8.47[/TD]
[TD="align: right"]9.14[/TD]
[TD="align: right"]10.82[/TD]
[TD="align: right"]12.96[/TD]
[TD="align: right"]13.50[/TD]
[/TR]
[TR]
[TD]Fri[/TD]
[TD="align: right"]2011[/TD]
[TD]Jan[/TD]
[TD="align: right"]1/28/2011[/TD]
[TD="align: right"]4.91[/TD]
[TD="align: right"]5.07[/TD]
[TD="align: right"]3.79[/TD]
[TD="align: right"]4.04[/TD]
[TD="align: right"]5.82[/TD]
[TD="align: right"]7.02[/TD]
[TD="align: right"]29.68[/TD]
[TD="align: right"]23.22[/TD]
[TD="align: right"]7.45[/TD]
[TD="align: right"]4.18[/TD]
[TD="align: right"]2.19[/TD]
[TD="align: right"]1.55[/TD]
[TD="align: right"]2.34[/TD]
[TD="align: right"]2.57[/TD]
[TD="align: right"]2.51[/TD]
[TD="align: right"]2.44[/TD]
[TD="align: right"]3.47[/TD]
[TD="align: right"]7.91[/TD]
[TD="align: right"]23.83[/TD]
[TD="align: right"]9.32[/TD]
[TD="align: right"]8.68[/TD]
[TD="align: right"]9.20[/TD]
[TD="align: right"]12.70[/TD]
[TD="align: right"]19.74[/TD]
[/TR]
[TR]
[TD]Sat[/TD]
[TD="align: right"]2011[/TD]
[TD]Jan[/TD]
[TD="align: right"]1/29/2011[/TD]
[TD="align: right"]8.92[/TD]
[TD="align: right"]10.20[/TD]
[TD="align: right"]9.32[/TD]
[TD="align: right"]9.08[/TD]
[TD="align: right"]9.44[/TD]
[TD="align: right"]11.47[/TD]
[TD="align: right"]9.98[/TD]
[TD="align: right"]9.72[/TD]
[TD="align: right"]17.23[/TD]
[TD="align: right"]11.61[/TD]
[TD="align: right"]4.70[/TD]
[TD="align: right"]4.49[/TD]
[TD="align: right"]4.56[/TD]
[TD="align: right"]5.96[/TD]
[TD="align: right"]7.18[/TD]
[TD="align: right"]6.62[/TD]
[TD="align: right"]4.10[/TD]
[TD="align: right"]6.99[/TD]
[TD="align: right"]17.93[/TD]
[TD="align: right"]8.71[/TD]
[TD="align: right"]7.74[/TD]
[TD="align: right"]7.69[/TD]
[TD="align: right"]12.34[/TD]
[TD="align: right"]12.11[/TD]
[/TR]
[TR]
[TD]Sun[/TD]
[TD="align: right"]2011[/TD]
[TD]Jan[/TD]
[TD="align: right"]1/30/2011[/TD]
[TD="align: right"]3.41[/TD]
[TD="align: right"]3.70[/TD]
[TD="align: right"]10.39[/TD]
[TD="align: right"]14.53[/TD]
[TD="align: right"]8.57[/TD]
[TD="align: right"]5.26[/TD]
[TD="align: right"]3.62[/TD]
[TD="align: right"]7.59[/TD]
[TD="align: right"]6.41[/TD]
[TD="align: right"]7.83[/TD]
[TD="align: right"]5.89[/TD]
[TD="align: right"](1.26)[/TD]
[TD="align: right"](7.30)[/TD]
[TD="align: right"](10.08)[/TD]
[TD="align: right"](4.42)[/TD]
[TD="align: right"](3.38)[/TD]
[TD="align: right"](0.72)[/TD]
[TD="align: right"]4.90[/TD]
[TD="align: right"]25.12[/TD]
[TD="align: right"]10.36[/TD]
[TD="align: right"]0.91[/TD]
[TD="align: right"]4.05[/TD]
[TD="align: right"]6.37[/TD]
[TD="align: right"]4.72[/TD]
[/TR]
[TR]
[TD]Mon[/TD]
[TD="align: right"]2011[/TD]
[TD]Jan[/TD]
[TD="align: right"]1/31/2011[/TD]
[TD="align: right"]2.36[/TD]
[TD="align: right"]3.53[/TD]
[TD="align: right"]6.09[/TD]
[TD="align: right"]5.75[/TD]
[TD="align: right"]5.40[/TD]
[TD="align: right"]4.86[/TD]
[TD="align: right"]16.78[/TD]
[TD="align: right"]12.63[/TD]
[TD="align: right"]9.73[/TD]
[TD="align: right"]5.44[/TD]
[TD="align: right"](4.05)[/TD]
[TD="align: right"]0.68[/TD]
[TD="align: right"]2.34[/TD]
[TD="align: right"]3.32[/TD]
[TD="align: right"]4.01[/TD]
[TD="align: right"]4.80[/TD]
[TD="align: right"]7.69[/TD]
[TD="align: right"]12.43[/TD]
[TD="align: right"]30.45[/TD]
[TD="align: right"]11.86[/TD]
[TD="align: right"]10.25[/TD]
[TD="align: right"]9.52[/TD]
[TD="align: right"]13.01[/TD]
[TD="align: right"]14.11[/TD]
[/TR]
</tbody>[/TABLE]

 

[tybaltlives]

hope this is what you are looking for. I only show a portion of your table but the range extends over all of January. The formulas may be copied to the right for each hour:

Excel 2010
	A	B	C	D	E	F	G
6				Positive	71.0%	67.7%	71.0%
7				negative	29.0%	32.3%	29.0%
8
9	Day	Year	Month	Dat 2	1	2	3
10	Sat	2011	Jan	1/1/2011	1.6	1.9	2.67
11	Sun	2011	Jan	1/2/2011	-1.9	-1.53	-1.19
12	Mon	2011	Jan	1/3/2011	4.15	2.81	3.33
13	Tue	2011	Jan	1/4/2011	2.16	4.08	4.53
14	Wed	2011	Jan	1/5/2011	0.97	0.95	1.87
15	Thur	2011	Jan	1/6/2011	-7.26	-5.97	-4.46
Sheet1

Cell Formulas
Range	Formula
E6	=1-E7
E7	=COUNTIF(E10:E40,"<"&0)/COUNT(E10:E40)

 

[alexm3430]

This is exactly what I needed thank you. What if I only wanted to see just what Mondays do?

 

[tybaltlives]

I can tell you but I'm away from my computer and can't give you the formulas. Replace COUNT with the COUNTIFS function and add the criteria to count only if mon. Replace the SUM with SUMPRODUCT and include the day column to sum only rows with Monday in it. Would take me about 2 min to do but won't be back at a computer for a few days. I'm on vacation.

 

[tybaltlives]

Oh sorry. No SUMPRODUCT. Instead replace the count function in the denominator with COUNTIFS and only count if Monday's. I think you can figure this out!

 

[tybaltlives]

OK. Im back. Try this. You can select the day you want in cell C3.

Excel 2010
	A	B	C	D	E	F	G	H
3			Mon	Positive	80.0%	80.0%	100.0%	100.0%
4				negative	20.0%	20.0%	0.0%	0.0%
5
6			All	Positive	71.0%	67.7%	71.0%	74.2%
7				negative	29.0%	32.3%	29.0%	25.8%
8
9	Day	Year	Month	Dat 2	1	2	3	4
10	Sat	2011	Jan	1/1/2011	1.6	1.9	2.67	3
11	Sun	2011	Jan	1/2/2011	-1.9	-1.53	-1.19	-1.38
12	Mon	2011	Jan	1/3/2011	4.15	2.81	3.33	3.81
13	Tue	2011	Jan	1/4/2011	2.16	4.08	4.53	0.09
14	Wed	2011	Jan	1/5/2011	0.97	0.95	1.87	1.39
15	Thur	2011	Jan	1/6/2011	-7.26	-5.97	-4.46	-7.73
Sheet1

Cell Formulas
Range	Formula
E3	=COUNTIFS(E10:E40,">"&0,$A$10:$A$40,"="&$C$3)/COUNTIFS($A$10:$A$40,"="&$C$3)
E4	=COUNTIFS(E10:E40,"<"&0,$A$10:$A$40,"="&$C$3)/COUNTIFS($A$10:$A$40,"="&$C$3)
E6	=1-E7
E7	=COUNTIF(E10:E40,"<"&0)/COUNT(E10:E40)