Login Page - Create Account

Home >> Support Board

Support Board

Date/Time: Sun, 05 May 2024 03:08:12 +0000

How to Post a Message for Support

Post From: Auto updating horizontal line

[2021-10-13 13:46:05]
[Go To First Post]
Sawtooth - Posts: 3993
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]