Login Page - Create Account

Support Board


Date/Time: Thu, 28 Mar 2024 09:20:47 +0000



Post From: Need Example of SLOPE Function for Spreadsheet Column K-X formulas

[2016-03-11 22:44:08]
Sawtooth - Posts: 3952
You could use a spare column, e.g. cell P3, with this:
=ROW()-2
This would number the rows in ascending order, and would avoid variations in timestamps, giving a constant increment between bars. This should be the KnownX (bars axis) and the MA should be the KnownY (price axis):
=SLOPE(AB4:AB9,P4:P9)

But I still want to see Support's examples. As you mentioned, maybe a new function would be the best solution.

If you don't care about intermediate points within the Length, you might have a look at the Study Angle study.
It outputs in degrees -90 to +90.