Support Board
Date/Time: Thu, 20 Mar 2025 00:23:14 +0000
Post From: formula help
| [2022-10-28 07:41:27] |
| User486817 - Posts: 83 |
|
hello, i am using two spreadsheet formulas to calculate the number of bars since a slope change. i'm trying to use the same formulas for an SG whose alert is =ID4.SG2<>0 but i cannot get it to work. my formulas look like this: ID10 SPREADSHEET FORMULA STUDY =ID4.SG2<>0 ID11 SPREADSHEET FORMULA STUDY (to determine how many bars it has been since the last time ID10 (ID4.SG2) was not equal to zero) IF(ID10.SG1<>0,ID11.SG1[-1]+1,0) i've tried this and i cannot get it to print the number of bars it has been since ID10 was true. is there a way to do this? kindest regards, |