Support Board
Support Board
Search Board
Control Panel
View My Posts / Threads
Direct MessagesDate/Time: Sun, 19 May 2024 08:47:27 +0000
Post From: Using Spreadsheet Studies with Alerts
| [2021-10-27 15:32:15] |
| Botan626 - Posts: 294 |
|
I don't see, how that is achievable. If I want to receive an alert indication for the last closed bar at any time moment, like after I reloaded and recalculated chart, I need to set Signal Only on Bar Close to No and reference in cell at row 3 a cell at row 4, because row 3 gives alerts. Is that correct? In cell at row 3 I need to reference cell at row 4 either with relative or absolute reference. 1. With relative reference, e.g. =ID0.SG1@4=ID0.SG3@4 in cell at row 3, if draw style is any arrow for subgraph column, arrows will be drawn 1 bar earlier to the actual bar with TRUE result from condition formula, but there will be an alert indication from cell at row 3 for cell at row 4. 2. With absolute reference, e.g. =ID0.SG1@$4=ID0.SG3@$4, all cells in column with condition formula will have the same result, and each bar will have arrows, if the return result is TRUE, but then again there will be an alert indication from cell at row 3 for cell at row 4. So both ways are only half efficient, they both will give an alert indication for the last closed bar, but they both won't allow to get the desired result from condition formula for the previous closed bars. And this makes it impossible to get correct condition results for all closed bars and receieve an alert indication for the last closed bar at any moment, because the last bar has to close first. Am I wrong somewhere? Date Time Of Last Edit: 2021-10-30 16:58:59
|