Dear All
link to download excel spreadsheet is
http://vll.co.in/wp-content/uploads/2013/03/data-series.xlsx
Here column a contains date and column b contains price of a share (in rs.)on that date.
I need to see how many times the share price has moved from a certain price by a certain number. for e.g. from 100 rs. by 10 rs., ie from rs. 100 to rs. 110 or rs. 90 and then from 90 to 80 or 100, etc.
Here in the chart we can see the price moves from 100 to 110, then 120, then 130, then 140 and then it did not cross 150 but comes back to 130, then again 140 and then 150.
So here if i select the range from b2 to b89 the total no. of 10 rs. move from price 100 rs. is 7. Here in the chart it can be seen and counted with our eyes, but when the data series becomes very large it becomes very difficult to count the number of moves.
hence i require a VBA code that can do it for me. Also in VBa i need the flexibility for changing the starting no. and movement of points, which is in above case 100 and 10.
Regards
Anup
link to download excel spreadsheet is
http://vll.co.in/wp-content/uploads/2013/03/data-series.xlsx
Here column a contains date and column b contains price of a share (in rs.)on that date.
I need to see how many times the share price has moved from a certain price by a certain number. for e.g. from 100 rs. by 10 rs., ie from rs. 100 to rs. 110 or rs. 90 and then from 90 to 80 or 100, etc.
Here in the chart we can see the price moves from 100 to 110, then 120, then 130, then 140 and then it did not cross 150 but comes back to 130, then again 140 and then 150.
So here if i select the range from b2 to b89 the total no. of 10 rs. move from price 100 rs. is 7. Here in the chart it can be seen and counted with our eyes, but when the data series becomes very large it becomes very difficult to count the number of moves.
hence i require a VBA code that can do it for me. Also in VBa i need the flexibility for changing the starting no. and movement of points, which is in above case 100 and 10.
Regards
Anup