Support Board
Support Board
Search Board
Control Panel
View My Posts / Threads
Direct MessagesDate/Time: Sun, 05 May 2024 01:08:42 +0000
Post From: Auto updating horizontal line
| [2021-10-13 14:42:25] |
| VolTrader73 - Posts: 133 |
|
Used and using only the Spread Sheet formula study. I followed the whole time your original post and first option quoted bellow: _______________________________________________________________________________________ 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. _______________________________________________________________________ Aside of the fact the HL disappears, I do not understand why I need tow values in the study formula. Using the following which is only the spread sheet value (ID4 SG1) or just the RSI (ID20 SG1), IF(AND(ID4.SG1[-1]<=0,ID4.SG1>0),C,ID4.SG1[-1]) ----> I get the horizontal line when condition is true but again, it continually updates to the last close of the bar which leads me to the conclusion that the study dose not work purely "intrabar" but rather evaluates based on the previse bar instead of the previous tick within the current bar. And again it disappears at the end of the bar or so. It just needs to stay at one price when triggered once during the bar and wait for the next bar/trigger to move Please advise Date Time Of Last Edit: 2021-10-13 15:06:08
|