Support Board

Date/Time: Mon, 06 May 2024 12:50:03 +0000

Post From: Automated trading - Adding a delay on the entry into the spreadsheet system

[2019-12-27 13:32:39] Link To Thread - Link To Post [Go To First Post]
Sawtooth - Posts: 3993
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