Angle of Inclination Calculation

Discussion regarding the spreadsheet functionality of Bet Angel.
Post Reply
Jukebox
Posts: 1576
Joined: Thu Sep 06, 2012 8:07 pm

MemphisFlash wrote:
Mon Sep 14, 2020 9:08 pm
thats not 45 Degrees, looks more like 30, and i'm a draughtsman
tbf the excel scale has reduced the height considerably - if that is 11 wide does it really look 100 tall?
Jukebox
Posts: 1576
Joined: Thu Sep 06, 2012 8:07 pm

CallumPerry wrote:
Mon Sep 14, 2020 9:27 pm
Thank you but the ATAN is for a value not a series, which value?

I tried taking the slope of the two series (10) so =ATAN(10) gives 1.47112767. =Degrees() of this number gives 84.289. Doesn’t look like 84 degrees?
If x is 10 then y is 90 according to your constant. 10/90=9 ATAN of 9 = 1.460139 radians = 83.65981 degrees. The reason is doesn't look like 83.65981 degrees is because excel has scaled the y axis to something you can see - if you made the x and y the same scale you'd see it..

You are really only solving a right angled triangle.
CallumPerry
Posts: 575
Joined: Wed Apr 19, 2017 5:12 pm
Location: Wolverhampton

:!: :!: :!: :!: :!: :!: :!: :!: :!: :!:

I've just managed to scale it so the axis use the same increments and now visually it matches the number I am getting. Thank you for your help! Yeah Excel tricked me with the scale of the line; something to remember in future analysis I suppose!
CallumPerry
Posts: 575
Joined: Wed Apr 19, 2017 5:12 pm
Location: Wolverhampton

Jukebox wrote:
Mon Sep 14, 2020 10:25 pm
CallumPerry wrote:
Mon Sep 14, 2020 9:27 pm
Thank you but the ATAN is for a value not a series, which value?

I tried taking the slope of the two series (10) so =ATAN(10) gives 1.47112767. =Degrees() of this number gives 84.289. Doesn’t look like 84 degrees?
If x is 10 then y is 90 according to your constant. 10/90=9 ATAN of 9 = 1.460139 radians = 83.65981 degrees. The reason is doesn't look like 83.65981 degrees is because excel has scaled the y axis to something you can see - if you made the x and y the same scale you'd see it..

You are really only solving a right angled triangle.
Oops, just behind your reply here when typing my last message. Yep, big brain freeze moment there :oops: Thank you for explaining :D
Jukebox
Posts: 1576
Joined: Thu Sep 06, 2012 8:07 pm

CallumPerry wrote:
Mon Sep 14, 2020 10:27 pm
Jukebox wrote:
Mon Sep 14, 2020 10:25 pm
CallumPerry wrote:
Mon Sep 14, 2020 9:27 pm
Thank you but the ATAN is for a value not a series, which value?

I tried taking the slope of the two series (10) so =ATAN(10) gives 1.47112767. =Degrees() of this number gives 84.289. Doesn’t look like 84 degrees?
If x is 10 then y is 90 according to your constant. 10/90=9 ATAN of 9 = 1.460139 radians = 83.65981 degrees. The reason is doesn't look like 83.65981 degrees is because excel has scaled the y axis to something you can see - if you made the x and y the same scale you'd see it..

You are really only solving a right angled triangle.
Oops, just behind your reply here when typing my last message. Yep, big brain freeze moment there :oops: Thank you for explaining :D
no probs
User avatar
firlandsfarm
Posts: 2688
Joined: Sat May 03, 2014 8:20 am

CallumPerry wrote:
Mon Sep 14, 2020 6:57 pm
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.
User avatar
jimibt
Posts: 3641
Joined: Mon Nov 30, 2015 6:42 pm
Location: Narnia

firlandsfarm wrote:
Tue Sep 15, 2020 3:29 pm
CallumPerry wrote:
Mon Sep 14, 2020 6:57 pm
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...
User avatar
firlandsfarm
Posts: 2688
Joined: Sat May 03, 2014 8:20 am

jimibt wrote:
Tue Sep 15, 2020 3:34 pm
firlandsfarm wrote:
Tue Sep 15, 2020 3:29 pm
CallumPerry wrote:
Mon Sep 14, 2020 6:57 pm
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
User avatar
jimibt
Posts: 3641
Joined: Mon Nov 30, 2015 6:42 pm
Location: Narnia

firlandsfarm wrote:
Tue Sep 15, 2020 3:39 pm
jimibt wrote:
Tue Sep 15, 2020 3:34 pm
firlandsfarm wrote:
Tue Sep 15, 2020 3:29 pm

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
Posts: 1
Joined: Sat Nov 30, 2019 11:20 pm

? 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.
User avatar
firlandsfarm
Posts: 2688
Joined: Sat May 03, 2014 8:20 am

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.
User avatar
mcgoo
Posts: 898
Joined: Thu Jul 18, 2013 12:30 pm

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 :D
User avatar
mcgoo
Posts: 898
Joined: Thu Jul 18, 2013 12:30 pm

Just watching Microsoft Ignite..apparently they have achieved Human parity in image recognition..jeebus imagine that for trading :shock:
Jukebox
Posts: 1576
Joined: Thu Sep 06, 2012 8:07 pm

mcgoo wrote:
Wed Sep 23, 2020 8:37 am
Just watching Microsoft Ignite..apparently they have achieved Human parity in image recognition..jeebus imagine that for trading :shock:
I suppose it depends on which human.
User avatar
mcgoo
Posts: 898
Joined: Thu Jul 18, 2013 12:30 pm

Jukebox wrote:
Wed Sep 23, 2020 8:44 am
mcgoo wrote:
Wed Sep 23, 2020 8:37 am
Just watching Microsoft Ignite..apparently they have achieved Human parity in image recognition..jeebus imagine that for trading :shock:
I suppose it depends on which human.
Indeed but ..training :)..24x7 :ugeek:
Post Reply

Return to “Bet Angel - Spreadsheet / Excel chat”