Support Board
Date/Time: Thu, 26 Dec 2024 22:36:22 +0000
Post From: Need Example of SLOPE Function for Spreadsheet Column K-X formulas
| [2016-03-11 21:19:28] |
| User791263 - Posts: 151 |
|
I may be confused, after reading MSFT EXCEL help such as at http://www.excelfunctions.net/Excel-Slope-Function.html Tom, I was intending Column AB, not A & B as sets/colums of serial data (terminal points.) The Study- Regressive Slope is simple; It locates y's for the x,y to x',y' --- of another study function (a curve(MA for example), within the x' - x time range, by simply input of bars back. The work-around I use is: plot the spreadsheet column, then apply Regressive Slope, which is added as a spreadsheet column with changing slope values. It would be nice if S.C. just adapted that-- creating a simplified SLOPE command to directly apply to a column. Such new RegSlope function, adapting the Regressive Slope study, inputting bars back-bars span, ie: REGSLOPE(V4:V9) for spreadsheet column V-- would be nice. |