# Stock Price Angle of Ascent

#### matthewlouis

##### Active Member
Hello Experts, I am trying to calculate the angle of ascent of stock prices as I am looking for an alert once that angle is over 45 degrees. Is that what the slope formula calculates using price and time? Do I then need to convert the slope to degrees?

Last edited:

### Excel Facts

Spell Check in Excel
Press F7 to start spell check in Excel. Be careful, by default, Excel does not check Capitalized Werds (whoops)

#### shg

##### MrExcel MVP
How do you define the slope? Is increasing in value a dollar a day a slope of 45 degrees, regardless of the stock price?

#### matthewlouis

##### Active Member
Hmmmm, I am thinking S&P 500 Index went from 2497 on 9/25/2017 to 2575 by 10/20/2017. I am trying to set an alert when the angle of ascent is over 45 degrees. Like when it's on a chart and you can the line moving up . . . more than 45 degree angle. Trying to put that in excel.

Last edited:

#### shg

##### MrExcel MVP
Sorry, I don't have a clue what "45 degrees" means.

#### matthewlouis

##### Active Member
Sorry, I mean a 45 degree angle -- If you are looking at a chart, what is the slope of the angle in degrees?

#### Gerald Higgins

##### Well-known Member
Surely the angle will depend on the x axis and y axis proportions ?

For example, if you have a chart where the slope is currently 30 degrees, you can change the slope to nearer 60 degrees (or any other number) by simply stretching the chart vertically.

#### matthewlouis

##### Active Member
Sorry, again I am bad at being clear. What I am looking for is I have 2 columns. One is the date (x axis) and one is the price (y axis). I am looking to calculate the slope of the line (in degrees) from one point to another point -- like over 8 days, did the price have a 38 degree angle on the chart or did it have a 65 degree angle on the chart. I have used the slope formula but am not sure it is giving me what I want (is that degrees or not)? Any stock that has a 60 degree angle upward on a chart is moving up fast. If it's only going up 15 degrees, it is a flatter, more sustainable move.

Hope that is clearer, thanks!

Last edited:

#### shg

##### MrExcel MVP
Again,

Is increasing in value a dollar a day a slope of 45 degrees, regardless of the stock price?

#### t0azt

##### Board Regular
Like Gerald said, the angle will depend on the proportions of the y axis. If in your example of S&P 500 going from 2497 to 2575 the angle will vary wildly if your y axis is going by \$1 increments or 10, or 100 and so on. A % change would be more accurate.

#### matthewlouis

##### Active Member
Yes! Thanks shg and t0azt, I see what you're saying. The two need to be on common ground. So a % change would be more accurate . . . so how do I convert the Y axis (time) to a % change? In other words, if the S&P 500 Index went form 2488 to 2559 like it did from Sept. 25, 2017 to October 18, 2017 (18 trading days) how would I do the % change on the 18 trading days to calculate the slope (degrees)? Or, is degrees the same thing as slope? Does that explain what I mean better?

Last edited: