Support Board
Support Board
Search Board
Control Panel
View My Posts / Threads
Direct MessagesDate/Time: Sun, 19 May 2024 12:15:17 +0000
Post From: Using Spreadsheet Studies with Alerts
| [2021-10-25 16:29:50] |
| Botan626 - Posts: 294 |
|
What if I'm connected to data feed, like I said in post #9? But either way, live or closed market, why Spreadsheet System/Alert can't give alert for the last closed bar, if corresponding cell at row 4 returns 1, without waiting for a close of last bar? This will fully match the 1st sentence here: Spreadsheet Systems, Alerts and Automated Trading: Signal Only on Bar Close Moreover, this section Spreadsheet Systems, Alerts and Automated Trading: Signal Only on Bar Close says: You may want to set Strict Signal Only On Bar Close Evaluation to Yes, when you set one of these inputs to Yes.
But Spreadsheet System/Alert doesn't have this input.The description of this input Spreadsheet Systems, Alerts and Automated Trading: Strict Signal Only On Bar Close Evaluation says: When this Input is set to Yes, then only at the moment when a bar closes when one or more new bars are added to the chart, will an evaluation of your Spreadsheet formulas from the corresponding Spreadsheet columns (K, M, L, N-Z) be evaluated for TRUE conditions.
When this Input is set to Yes, row 4 will not be continuously monitored as usual, only exactly at the moment when a bar closes and the chart is updated. Looks like this is how Spreadsheet System/Alert works now, like Strict Signal Only On Bar Close Evaluation is set to Yes permanently, while setting it to No could help to get an alert strictly based on result from cell in row 4 and only with Signal Only on Bar Close set to Yes. Date Time Of Last Edit: 2021-10-25 17:39:50
|