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