Support Board

Date/Time: Sat, 04 May 2024 05:19:34 +0000

Post From: Spreadsheet Signal from Linear Regression End Channel study

[2020-12-01 19:01:18] Link To Thread - Link To Post [Go To First Post]
User351605 - Posts: 76
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