Support Board
Date/Time: Thu, 26 Dec 2024 21:54:26 +0000
Post From: Need Example of SLOPE Function for Spreadsheet Column K-X formulas
| [2016-03-11 22:44:08] |
| Sawtooth - Posts: 4143 |
|
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. |