Support Board

Date/Time: Fri, 19 Apr 2024 14:25:25 +0000

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

[2016-03-11 21:19:28] Link To Thread - Link To Post [Go To First Post]
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.