Support Board

Date/Time: Wed, 27 Nov 2024 14:45:01 +0000

Post From: active formula depend on difference between bars

[2023-07-27 07:54:41] Link To Thread - Link To Post [Go To First Post]
User278398 - Posts: 291
" You can also do it with another instance of the Spreadsheet Formula study using a formula that counts bars since the crossover: =IF(CROSSOVER(ID1.SG1,ID2.SG1),1,ID4.SG1[-1]+1) where ID4 is this Spreadsheet Formula study. Then reference this study's output for a value >40. " i dont really understand: 1. id3 ( Spreadsheet Formula study ): =IF(CROSSOVER(ID1.SG1,ID2.SG1),1,ID4.SG1[-1]+1) id4 ( Spreadsheet Formula study ): what i need to write in the formula ? 2. Then reference this study's output for a value >40 .... do u mean by study's output is the vertical yellow line that in the pic (i got them by, study subgraph above/below bar as text, and the draw style is background) ? and how can i change the output for value >40 ( i didnt find something similar to this in the settings study) regards