Support Board
Date/Time: Fri, 31 Oct 2025 08:44:23 +0000
[User Discussion] - Flatten or Cancel Spreadsheet trading
View Count: 1667
| [2013-10-04 18:20:43] |
| toews&kane - Posts: 209 |
|
Hi there, I am using this code in J29 it doesn't seem to be working. I just want it to flatten at 16:09:00 It's returning true right now. Suggestions? =AND(OR(J41-INT(J41)<TIMEVALUE("16:00:00"),J41-INT(J41)>TIMEVALUE("16:30:00"))) |
| [2013-10-04 18:27:52] |
| |
|
Do you see a message in the Trade >> Trade Service Log indicating a Flatten and Cancel operation for the symbol at the time it became TRUE?
Sierra Chart Support - Engineering Level Your definitive source for support. Other responses are from users. Try to keep your questions brief and to the point. Be aware of support policy: https://www.sierrachart.com/index.php?l=PostingInformation.php#GeneralInformation For the most reliable, advanced, and zero cost futures order routing, *change* to the Teton service: Sierra Chart Teton Futures Order Routing |
| [2013-10-04 19:03:07] |
| Sawtooth - Posts: 4281 |
|
Try this instead: =J41-INT(J41)>=TIMEVALUE("16:09:00") |
| [2013-10-04 21:21:13] |
| toews&kane - Posts: 209 |
|
but I also want it to return false at 17:00 so that it enters into a trade again on a new day
|
| [2013-10-04 21:59:41] |
| Sawtooth - Posts: 4281 |
|
Then try this: =AND(J41-INT(J41)>=TIMEVALUE("16:09:00"),J41-INT(J41)<TIMEVALUE("17:00:00")) |
To post a message in this thread, you need to log in with your Sierra Chart account: