The data is pulled from another program that has the data feed plugged in.

Date is not important but the day is haha, that will be my next issue. I am ultimately trying to find if the day of the week has any significance on the high and low of the week and then test that against any 5 day period to see if Monday and Friday are significant or the start and finish of any 5 day period are significant.

It was in spired by this post

http://www.ranchodinero.com/market-s...res-contracts/

Just didn't want to ask for the complete solution.

The formula and lay out is showing the sum of the week not the high of the week?