Bet Angel - Spreadsheet / Excel chat : Angle of Inclination Calculation

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

Mon Sep 14, 2020 10:16 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: 1219
Joined: Thu Sep 06, 2012 8:07 pm

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.

User avatar
CallumPerry
Posts: 483
Joined: Wed Apr 19, 2017 5:12 pm
Location: Wolverhampton

Mon Sep 14, 2020 10:26 pm

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

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!

User avatar
CallumPerry
Posts: 483
Joined: Wed Apr 19, 2017 5:12 pm
Location: Wolverhampton

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

Jukebox
Posts: 1219
Joined: Thu Sep 06, 2012 8:07 pm

Mon Sep 14, 2020 10:36 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

firlandsfarm
Posts: 1128
Joined: Sat May 03, 2014 8:20 am

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.

User avatar
jimibt
Posts: 2539
Joined: Mon Nov 30, 2015 6:42 pm

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...

firlandsfarm
Posts: 1128
Joined: Sat May 03, 2014 8:20 am

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
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: 2539
Joined: Mon Nov 30, 2015 6:42 pm

Tue Sep 15, 2020 3:49 pm

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

Fri Sep 18, 2020 11:55 am

? 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.

Post Reply

Return to “Bet Angel - Spreadsheet / Excel chat”

  • Information
  • Who is online

    Users browsing this forum: Google [Bot] and 2 guests