Trading signal to short a stock
Hello, I'm collecting real-time data from a trading platform (think or swim) using RTD function. I would like to setup a column to signal when to Short a stock when a condition is met (ex: RSI1hr and RSI2hr is <70). I have this being used =IF(AND(B3<70,C3<70), "SHORT", ""). However, I only want the column D to add the SHORT text when a NEW condition is met (say within the last 2 hrs). Would anyone be able to help me with this request? I greatly appreciate it!