Hi guys,

I am using thinkorswim as my DDE and Excel. All i want excel to do is count how many times a value appears. For example, I want excel do count how many time the price 1151 to 1155 got hit. did it get hit 1 or mybe 20 times. please help thank you kevin.

something like this
price ---------->how many times it got hit
1151-------------> 15
1151.25--------->7
1151.50-------->10
1151.75--------->25
1152------------>5