Support Board
Date/Time: Sun, 02 Nov 2025 22:51:54 +0000
Post From: Auto updating horizontal line
| [2021-10-13 13:46:05] |
| Sawtooth - Posts: 4285 |
|
If your RSI is ID20 and your Spreadsheet Formula study is ID4, than use this formula in the Spreadsheet Formula study's Formula field: =IF(AND(ID20.SG1[-1]<=50,ID20.SG1>50),C,ID4.SG1[-1]) The IF statement is If,Then,Else. This portion of the formula finds where the RSI crosses 50 from below: AND(ID20.SG1[-1]<=50,ID20.SG1>50) If this is TRUE, Then it plots the Close price, Else it plots the previous line's price. This is the previous line's value: ID4.SG1[-1] |