Angle of Inclination Calculation

[firlandsfarm]

I'm having a bit of a mind blank here, hope somebody can help. The line is this attached screenshot (to my eye) has an angle of about 45 degrees. Does anybody know what calculation would I need to do to achieve this value? =SLOPE() gives me the first 10 (M value) in 'Y = 10X - 10'.

I can not for the life of me remember how to use this to give me the angle of inclination in Excel. From what I've read it's TAN^-1 or something. Before I overly complicate it, I was hoping somebody here knew of a simple function or calculation please?

Screen Shot 2020-09-14 at 18.51.40.png

Sorry to spoil the party Callum but the angle will depend on the scaling of the axis … if you shorten the X the angle will steepen but if you lengthen the X the angle will go shallow with the reverse for the Y.

[jimibt]

I'm having a bit of a mind blank here, hope somebody can help. The line is this attached screenshot (to my eye) has an angle of about 45 degrees. Does anybody know what calculation would I need to do to achieve this value? =SLOPE() gives me the first 10 (M value) in 'Y = 10X - 10'.

I can not for the life of me remember how to use this to give me the angle of inclination in Excel. From what I've read it's TAN^-1 or something. Before I overly complicate it, I was hoping somebody here knew of a simple function or calculation please?

Screen Shot 2020-09-14 at 18.51.40.png

Sorry to spoil the party Callum but the angle will depend on the scaling of the axis … if you shorten the X the angle will steepen but if you lengthen the X the angle will go shallow with the reverse for the Y.

yeah, so the feature request that i put into the suggestions was to exploit this very fact -comparison between SAME spaced x axis time duration. that way, you can calculate the trend as index comparisons, rather than was ltp > ltp 10 seconds ago etc.. that tells no real story, tan does...

[firlandsfarm]

I'm having a bit of a mind blank here, hope somebody can help. The line is this attached screenshot (to my eye) has an angle of about 45 degrees. Does anybody know what calculation would I need to do to achieve this value? =SLOPE() gives me the first 10 (M value) in 'Y = 10X - 10'.

I can not for the life of me remember how to use this to give me the angle of inclination in Excel. From what I've read it's TAN^-1 or something. Before I overly complicate it, I was hoping somebody here knew of a simple function or calculation please?

Screen Shot 2020-09-14 at 18.51.40.png

Sorry to spoil the party Callum but the angle will depend on the scaling of the axis … if you shorten the X the angle will steepen but if you lengthen the X the angle will go shallow with the reverse for the Y.

yeah, so the feature request that i put into the suggestions was to exploit this very fact -comparison between SAME spaced x axis time duration. that way, you can calculate the trend as index comparisons, rather than was ltp > ltp 10 seconds ago etc.. that tells no real story, tan does...

yeah but to get a true comparison with something else both the X and the Y need to be in the same proportion with the original

[jimibt]

Sorry to spoil the party Callum but the angle will depend on the scaling of the axis … if you shorten the X the angle will steepen but if you lengthen the X the angle will go shallow with the reverse for the Y.

yeah, so the feature request that i put into the suggestions was to exploit this very fact -comparison between SAME spaced x axis time duration. that way, you can calculate the trend as index comparisons, rather than was ltp > ltp 10 seconds ago etc.. that tells no real story, tan does...

yeah but to get a true comparison with something else both the X and the Y need to be in the same proportion with the original

the SCALE has to be the same and the INTERVAL has to be the same. BUT the price should by virtue be different in order to get our index...

so if looking over 30 seconds, you may measure the price every 5 seconds based on a 5 second interval. the price may (in a crazy world) look a bit like this:

time price
00:00:05 2.5
00:00:10 3.5
00:00:15 4.0
00:00:20 3.5
00:00:25 3.5
00:00:30 3.0

So, your index (slope, tan etc) would/could measure the index between each interval OR could group intervals into the same sized buckets and measure them, horses and courses

[Bundybob]

? The scales aren't the same on X & Y axis so any visual reading (ie 30 or 45 degrees) would be a misleading to what the data represents.

[firlandsfarm]

I don't know why it's only just dawned on me, yes I do it's because over 50 years have passed since I did this in a classroom but I think what you are looking for is not the angle of inclination but the Gradient (https://www.mathsisfun.com/gradient.html)! That way the scales of the axes is irrelevant. The Gradient measures how many ups (negative = downs) there are for each across.

[mcgoo]

Been wanting be able to do this-gradient/tangent for years..never got around to figuring it out. Be a great addition to BA automation ..nudge

[mcgoo]

Just watching Microsoft Ignite..apparently they have achieved Human parity in image recognition..jeebus imagine that for trading

[Jukebox]

Just watching Microsoft Ignite..apparently they have achieved Human parity in image recognition..jeebus imagine that for trading

I suppose it depends on which human.

[mcgoo]

Just watching Microsoft Ignite..apparently they have achieved Human parity in image recognition..jeebus imagine that for trading

I suppose it depends on which human.

Indeed but ..training ..24x7