Support Board
Date/Time: Tue, 04 Feb 2025 04:54:26 +0000
[Programming Help] - Automated trading - Adding a delay on the entry into the spreadsheet system
View Count: 868
| [2019-12-11 20:07:09] |
| User710679 - Posts: 43 |
|
Hi, i am trying to add a condition to my entry based on a delay/time. That way I can't start a new entry if my last entry was executed less than, lets say, 2 minutes before. is that possible using the spreadsheet system? i am trying to use the function fractime but i dont know how to do it thanks in advance! David |
| [2019-12-27 03:49:04] |
| feifei786 - Posts: 6 |
|
Hello, I was wondering the same thing.
|
| [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 |
To post a message in this thread, you need to log in with your Sierra Chart account: