Support Board
Date/Time: Wed, 27 Nov 2024 07:26:45 +0000
Post From: Programming help-automate with spreadsheet-trigger when bar CLOSES above
| [2023-09-06 00:31:52] |
| User61168 - Posts: 403 |
|
Here's what you could do.... assuming reference to "Spreadsheet formula" in the title means you are using this study >> True Strength Index 1) Use Color Bar based on Alert condition study (say ID1.SG1). select "Evaluate On Bar Close" checkbox. Put your condition formula of above/below price level in this alert condition with a return output value of 1 when true. 2) put this in the spreadsheet formula ID2 study... IF(ID1.SG1=1,"enter spreadsheet formula condition here",0) to calculate only at bar close. ID2 should run right after ID1 in order to trigger both on the same tick. ps. better to post such questions under "Programming Help" to get more responses from other users Date Time Of Last Edit: 2023-09-06 00:32:55
|