Support Board
Date/Time: Thu, 13 Feb 2025 09:51:40 +0000
[User Discussion] - Spreadsheet Signal from Linear Regression End Channel study
View Count: 782
| [2020-12-01 19:01:18] |
| User351605 - Posts: 82 |
|
I would like to generate a signal from the LREC study in the spreadsheet system for trading, but I don't know how to accomplish it. I have found an old reply from tomgilb in that regard: "The Linear Regression End Channel study constantly redraws the lines so there is no way to compare the previous slope to the current slope, using a Simple Alert. It would be possible with the Spreadsheet System/Alert study, by locking the TRUE state of a cell with a formula. Post again if you want the details." Let's say I have a moving average as ID2.SG1, and the LREC study has the subgraph ID7.SG2 (spreadsheet column R) for StdDev High, and ID7.SG3 (column S) for StdDev Low. Now, for example, I would like to have a buy signal when the MA is < than StdDev Low. How can I lock the TRUE state in this regard and how to proceed then? Thank you! Date Time Of Last Edit: 2020-12-01 19:08:11
|
| [2020-12-02 00:11:36] |
| Sawtooth - Posts: 4173 |
|
How can I lock the TRUE state in this regard and how to proceed then?
That quote is from a user trying to capture when the LREC study's slope changes from upslope to downslope, and vice versa.Locking a TRUE is easy enough, but using another event to automatically release it can be problematic. If you want to use this method, here is an example: https://www.sawtoothtrade.com/example-9.html Here's an easier way to get a signal when the ID2.SG1 crosses ID7.SG3 from above: =CROSSFROMABOVE(ID2.SG1@3:ID2.SG1@4,ID7.SG3@3:ID7.SG3@4) You'll probably need to set Signal Only On Bar Close to No, since it might not remain TRUE at close of bar. Locking a TRUE would always be intrabar anyway. |
| [2020-12-02 15:49:51] |
| User351605 - Posts: 82 |
|
Thank you!
|
To post a message in this thread, you need to log in with your Sierra Chart account: