1. Most Discussed
  2. Gainers & Losers

Slope & Angle

  1. greenpastures

    5,769 Posts.

    I use the slope function a bit. Slope is a relative measure, ie, the numbers can be different scales depending on how U setup your measuring benchmark. ie -1 to +1 or -10 to +10 and so on.

    Nevetheless, in addition to slope, what I wish to calculate the angle of a line in relation to the X axis using an excel function, ie straight line between 2 points going down might be -5 degrees, and a straight line between 2 points going up might be +6 degrees.

    For starters an simple example, the two points wish to calculate an angle for might be;

    31/08/01, 2.0190
    20/05/02, 2.0572

    however would be more accurate to calculate the angle of the linear average line between two dates (with 180 points of data reference. Excel automatically draws a linear average line, but how do we get an angle for that line?

    mit freunlichen Gruessen.

Before making any financial decisions based on what you read, always consult an advisor or expert.

The HotCopper website is operated by Report Card Pty Ltd. Any information posted on the website has been prepared without taking into account your objectives, financial situation or needs and as such, you should before acting on the information or advice, consider the appropriateness of the information or advice in relation to your objectives, financial situation or needs. Please be aware that any information posted on this site should not be considered to be financial product advice.

From time to time comments aimed at manipulating other investors may appear on these forums. Posters may post overly optimistic or pessimistic comments on particular stocks, in an attempt to influence other investors. It is not possible for management to moderate all posts so some misleading and inaccurate posts may still appear on these forums. If you do have serious concerns with a post or posts you should report a Terms of Use Violation (TOU) on the link above. Unless specifically stated persons posting on this site are NOT investment advisors and do NOT hold the necessary licence, or have any formal training, to give investment advice.


Thank you for visiting HotCopper

We have detected that you are running ad blocking software.

HotCopper relies on revenue generated from advertisers. Kindly disable your ad blocking software to return to the HotCopper website.

I understand, I have disabled my ad blocker. Let me in!

Need help? Click here for support.