assume a1 is a counter. It counts nr of contracts sold for 1 minute, then flips back to 0 at the begining of the next minute and counts contracts again for the full minute etc etc.
assume b1 is a counter, which counts the seconds of the minute rolling back to 1 second at the beginning of the next minute.
I want to accumulate in a bucket, the number of contracts sold (from a1) for seconds 1 thru 15 and put them into a bucket c1.
Then, in d1, i want the contracts sold from 1 to 30 seconds. Then in e1 I want the contracts sold from 1 to 45 and finally in f1 I want the contracts (still getting them a1) for seconds 1 to 59.
And if that is not enough, I want to compare them with the number of contracts sold IN The Previous full minute.
My contracts keep going back to 0 whenever the seconds go to the next quarter minute.
hhheeeellllllppppp Thanks
assume b1 is a counter, which counts the seconds of the minute rolling back to 1 second at the beginning of the next minute.
I want to accumulate in a bucket, the number of contracts sold (from a1) for seconds 1 thru 15 and put them into a bucket c1.
Then, in d1, i want the contracts sold from 1 to 30 seconds. Then in e1 I want the contracts sold from 1 to 45 and finally in f1 I want the contracts (still getting them a1) for seconds 1 to 59.
And if that is not enough, I want to compare them with the number of contracts sold IN The Previous full minute.
My contracts keep going back to 0 whenever the seconds go to the next quarter minute.
hhheeeellllllppppp Thanks