Support Board

Date/Time: Fri, 19 Apr 2024 06:18:16 +0000

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

[2016-03-11 18:24:27] Link To Thread - Link To Post [Go To First Post]
Sawtooth - Posts: 3973
I never followed up on that old post. What I was wondering is: Is an MA the KnownY or the KnownX ? It's true that two ranges are required, but which is which? Try this: =-SLOPE(A3:A12,B3:B12) where: -the Open is in column B is used as the KnownX -the time stamp in column A is used as the KnownY -the polarity is reversed with a preceding '-' because column A is in descending order.