• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

VBA CODE REQUIRED

anup47

Member
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
 
Anup


You have now asked this question or a related one 4 times in the past 3 months

Twice you have never gone back and told the respondee if the answer was appropriate


Refer:

http://chandoo.org/forums/topic/movement-of-points-in-given-data-set

http://chandoo.org/forums/topic/options-pricing-model

http://chandoo.org/forums/topic/vba-code-for-calculation-of-movement-in-series-of-numbers


Can you please read the Forum's Posting Rules and Etiquette

http://chandoo.org/forums/topic/phd-forum-posting-rules-etiquette-pls-read-before-posting
 
Back
Top