Support Board

Date/Time: Sun, 05 May 2024 00:01:19 +0000

Post From: Auto updating horizontal line

[2021-10-12 20:38:22] Link To Thread - Link To Post [Go To First Post]
Sawtooth - Posts: 3993
Am I supposed to use the SS formula study? Despite its name, the Spreadsheet Formula study is not a spreadsheet study. However, you could use it to draw a single line that moves to a new price at each new threshold crossing. Using your RSI example, use a formula like this in its Formula field: =IF(AND(ID1.SG1[-1]<=50,ID1.SG1>50),C,ID2.SG1[-1]) where the RSI study is ID1 and the Spreadsheet Formula study is ID2. You could also use the Spreadsheet Study study, with a formula like this in K3: =IF(AND(ID1.SG1@4<=50,ID1.SG1@3>50),E3,K4) where the RSI study is ID1.