Support Board
Date/Time: Sat, 01 Mar 2025 20:00:57 +0000
Post From: Auto updating horizontal line
| [2021-10-12 20:38:22] |
| Sawtooth - Posts: 4178 |
|
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. |