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
there are three options i.e. pivot table, countif and sumproduct.
It is better to upload a sample workbook with sample data and your desired results
In order to attach a file Click the Go Advanced button, and click on the Manage Attachments button
Azam
If you want to say Thank you to a member, click the reputation icon (Star) in the left bottom of the post.
For prompt answer, be descriptive, concise, short, direct, and to-the-point.
I have attached an example how I want it to look like. I do want to advise that the data needs to be real time. However, with this attachment I can not upload the real time because you need thinkorswim running. I hope this helps. Thank you Kevin.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Reply With Quote
Bookmarks