Support Board
Date/Time: Tue, 04 Feb 2025 04:59:27 +0000
Post From: Automated trading - Adding a delay on the entry into the spreadsheet system
| [2019-12-27 13:32:39] |
| Sawtooth - Posts: 4166 |
|
Try including references to J41 and J42 in your K3/M3 entry formulas: =AND(YourEntryConditions,FRACTIME($J$41)-FRACTIME($J$42)>2/1440) J41 is the chart DateTime and J42 is the previous entry DateTime. FRACTIME removes the date. There are 1440 minutes in 24 hours, so 2/1440 equals 2 minutes in SerialDateTime format. https://www.sierrachart.com/index.php?page=doc/SpreadsheetFunctions.html#FRACTIME_Function Spreadsheet Example Formulas and Usage: Using Date Time |